' }RS_RESOURCE_ITEMRS_RESOURCE_ITEMDEFAULT&SMARTBARAMERICAN_AMERICA.WE8ISO8859P11 $ P0_16_MAY_200213_10_19Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08; ,"PKG INIT""MSGNUM"MSGTXT"MSGTYP""%()/23579  P   <[ ͫͫͫͫͫͫͫ0D \\ex) &' $,&'(($-(&'PP$.P<.d d  6.l l  .t t  .| |  .    .( 5 +&'&'0GE$FG;"MSGNUM"MSGTXT"MSGTYP""%()/23579  P   <[ ͫͫͫͫͫͫͫ0D \\ex) &' $G&'(($H(&'PP$IP<.d d  6.l l  .t t  .| |  .    .( 5 +&'&'0GE$FG;ͫͫͫͫͫͫͫSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T1ͫͫͫͫͫͫͫ0D 22k &'&'&'GEGE $4!00 md1md1 $ P1_20_DEC_200113_44_25eUͫͫͫͫͫͫͫ/NSPC1/CLEAR_ALL_MASTER_DETAILS$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D T '$!88  1 $ P2_20_DEC_200113_44_25E>ͫͫͫͫͫͫͫSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D O &'$/!00 1 $ (CHECK_PACKAGE_FAILUREWͫͫͫͫͫͫͫSQLFORMS w SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08!"PKG INIT"CHECK_PACKAGE_FAILURE""T8ͫͫͫͫͫͫͫ0D 99  `&'$:   h!tP0CHECK_PACKAGE_FAILURE131811 $ QUERY_MASTER_DETAILSͫͫͫͫͫͫͫw SYSSTANDARD FORMS4C FORMS40 SQLFORMS /NSPC1/CHECK_PACKAGE_FAILURE$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08K?"PKG INIT"QUERY_MASTER_DETAILS"REL_ID"ID"DETAIL"OLDMSG"RELDEF""#&(.17:;ADEGI     $8  ͫͫͫͫͫͫͫ0D *Lp &'&'%GILL $?L8$8T J&'%$;'$4&'$/$5&'&'&'%GIGI $ $jk!4l  &)*&)*QUERY_MASTER_DETAILSvFALSE105($lx(8|L `h? K [lu 41 $ [CLEAR_ALL_MASTER_DETAILSͫͫͫͫͫͫͫw SYSSTANDARD FORMS40 FORMS4C SQLFORMS /NSPC1/CHECK_PACKAGE_FAILURE$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08DD"PKG INIT"CLEAR_ALL_MASTER_DETAILS"MASTBLK"COORDOP"TRIGBLK"STARTITM"FRMSTAT"CURBLK"CURREL"CURDTL"FIRST_CHANGED_BLOCK_BELOW"MASTER"RETBLK"" &)*034:=>DGHNQRX[\befntw} ?7 8  9:=;< = !>#" C &')*,@.- 0A21 4B65$8~%($  +/3ͫͫͫͫͫͫͫ0P Kx  $$88LL``(   ؄0 ,,#s,&'@$B@ y&'$;'$&'&'G E$``H8  (tt`   h&'&'G I<HH $4H&'\$B\  &'&'G Idd $@d&'&'G Ixx $4x`b W&'$;'$&'&'G E($tt`  h&'&'G I $@LL*  &'$F'$6LL! &'$Fjk! %&'&'G I<LL $4L$&'$`$B`  &'&'$G Ihh $@h&'&'G I|| $4|0! %# 8&'8$B 8%S7&'&'$G I $@$% hg!80`P0CLEAR_ALL_MASTER_DETAILS CLEAR_RECORDSYNCHRONIZE_BLOCKSCHANGEDQUERYNEWFIRST_CHANGED_BLOCK_BELOW((<(@h(l=(ظ(* ( *, T ,X \ *@` d Hh l *\p t dx | x  (($(8(L(`(tz ($((8,TLX\(``dhhl|ptx|((@A&B2C>DJJqNSTYZ[\ `DbOPmnop"q4r=sWtnusx~$)Z~!"'+<,M1~9:` t0H`1 $ LOCKITWͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"LOCKIT""T(ͫͫͫͫͫͫͫ0D ))  &'&'GE$F!ll\@0LOCKITlocked md(mdPVA_LOV#POPUPHINT#RESOURCESCopiesCategoryContentCommentLOV_PERSONselect name,id,alternate_id from v_ps_pick_person order by unameNAMEIDALTERNATE_IDLOV64Select ID from RS_MEDIA_TYPE order by upper(ID)IDFIND_ITEMSELECT ALL RS_ITEM.TITLE, RS_ITEM.ID FROM RS_ITEM order by upper(title)TITLEIDFIND_VNUMSELECT ALL RS_ISSUE.V_NUMBER, RS_ISSUE.ID, RS_ISSUE.RS_ITEM_ID FROM RS_ISSUE order by v_numberV_NUMBERIDRS_ITEM_IDPick PersonNameAlt IDIDPick V NumberV NumberItem IdIssue IdChoose Media Type IDSelect ItemTitleId????= = = ?zzz??(((??@??????@??????@??????@??????@?????????333333?p=p=p=?GGG?QQQ?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?????(\(\(\?ffffff?ppp?zzz??@??????@??????@??????@??????@??????????\\\??ףףף??@??????@??????@??????@??????@??????????QQQ????@??????@??????@??????@??????@????????? ?GGG????@??????@??????@??????@??????@?????TahomaArialTahomaRS_ITEMRS_ITEMupper(title)TITLETitle1 $ uP6_20_DEC_200113_44_255Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss& T  &' 4$B4G  9  ; <&'&'<GE$Fh!|-WHEN-VALIDATE-ITEM trigger failed on field - &(4 @|2 ?mr  -RS_MEDIA_TYPE_IDMedia TypeTahoma1 $ }P7_20_DEC_200113_44_25=uͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS xh ($MFS RS_MEDIA_TYPE$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D >"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:<>@B    @H& ͫͫͫͫͫͫͫ0P ""!0    &' 4$B4G  9  ; <&'&'<GE$FhH  &' \$B\h `#[w@`Hu@ Hy@<  .&'&'GE$Fs@hs@! r{t gd@gd@ tgd@ !D`8@T-WHEN-VALIDATE-ITEM trigger failed on field - 8Media Type does not exist in table. Add to media types. PRIMARY_CUR@(4 (@(H(\ d| ?mv#SELECT ''x'' FROM RS_MEDIA_TYPE WHERE ID = :b1"!T-81 $ P8_20_DEC_200113_44_25_ͫͫͫͫͫͫͫw SYSSTANDARD xh ($MFS RS_MEDIA_TYPE$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 . <"PKG INIT"""""$'(*,    ,8ͫͫͫͫͫͫͫ0D 99 pTq{t ,w,, t, !x` 8@ T# ,hl4H Ld8SELECT UNITS FROM RS_MEDIA_TYPE WHERE ID = :b1"AUTHORAuthorDESCRIPTIONDescription1 $ yP9_20_DEC_200113_44_259Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss* 4 T &' 4$B4G  9  ; <&'&'<GE$Fh!-WHEN-VALIDATE-ITEM trigger failed on field - )(4, 0  @( ( ?mr  -IDSEQ_ID.NEXTVALIDIDUnit MeasurementTahomaFind an Item1 $ jP10_20_DEC_200113_44_25)ͫͫͫͫͫͫͫw SYSSTANDARD FORMS4W FORMS4C FORMS40 SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08!"PKG INIT""DUMMY""vͫͫͫͫͫͫͫ0D =` tT&' $F  &',;,(&'0G IL( $&'&'GE$&'$/&'&'0G ILH $!4| find_itemid=rs_item(\` dh,lp@X6o  ( 80@HLV NUMBER search1 $ -P2_13_OCT_200213_27_58ͫͫͫͫͫͫͫw SYSSTANDARD FORMS4W FORMS4C FORMS40 SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08!"PKG INIT""DUMMY""v,ͫͫͫͫͫͫͫ0D gv x,&'4$F4 &'@;@<&'0G IL< $&';HX;X`T&'xG ILT $&'&'GE$&'$/&'&'0G IL $&'&'xG IL $!4 find_vnumid=rs_itemid=''rs_issue0,4@\tx 6o    ( 80@HL`Xx`p1 $ P3_20_DEC_200113_44_25upͫͫͫͫͫͫͫw SYSSTANDARD xh '(MFSRS_ISSUESQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D >"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:<>@B    & ͫͫͫͫͫͫͫ0P Y t &' 0$K0n f#mw`u yB :&'&'G E$F&'$shs&'$! r{t gdgdtgd !PP `8@T(Cannot delete an item that has an ISSUE. PRIMARY_CUR' TX\h0lp 8P = C W eSELECT ''x'' FROM RS_ISSUE WHERE RS_ITEM_ID = :b1"\(1 $ !P4_20_DEC_200113_44_25ͫͫͫͫͫͫͫw SYSSTANDARD FORMS4C FORMS40 /NSPC1/QUERY_MASTER_DETAILS/NSPC1/CHECK_PACKAGE_FAILURE$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D 2"PKG INIT""RECSTAT"STARTITM"REL_ID"ID"" &)*017:<>@B   = <Pd ͫͫͫͫͫͫͫ0D F| 8   <  Pd<  <4  4&'4t$KtD <&'L|$-|d'dd$  P*  &'P$F'$!t4t  &)*&)*NEWINSERTRS_ITEM.RS_ITEM_RS_ISSUERS_ISSUEP(<(P,=d(t04| ( (4++QW "' x4Ld1 $ uP5_20_DEC_200113_44_255pͫͫͫͫͫͫͫw SYSSTANDARD xh '(MFSRS_ISSUESQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08C >"PKG INIT""DUMMY_DEFINE"RS_ISSUE_CUR""" (.069;=?A     (pq&  ͫͫͫͫͫͫͫ0P q$ #_w(0u(0/088y(6 .&'&'G E$Fs(hs(! r{t gd(gd(tgd( !TT `8@T?Cannot delete master record when matching detail records exist. RS_ISSUE_CUR0ht (x|08 Ld6Dcgl!p%p*y SELECT 1 FROM RS_ISSUE R WHERE R.RS_ITEM_ID = :b1"\?RS_ISSUERS_ISSUEpublishedss-IDIDV_NUMBERV Number1 $ uP2_13_OCT_200213_04_105pͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS xh '(MFSRS_ISSUE$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D 3"PKG INIT""CHK_UNIQUE""TMP""$&,/069:<>@B    <D()& ͫͫͫͫͫͫͫ0P OO!0)  &' 4$B4D  6&'&'GE$F&'$hD#w<Du< Ds<&'DX$BX8 0&'&'GE$FhO&'`$9`  %&'h$8h  h! r{t gd>mm/dd/yyyyIDRS_COPYRS_COPYID{{ hF{ T PURCHASEDPurchasedArialmm/dd/rrrrmm/dd/rrrrPRICEPrice$9999990.99$9999990.99REORDER_INFOReorder InfoSTATUSGOODStatusLOSTLostLOSTDAMAGEDDamagedDAMAGEDREMOVEDRemovedREMOVEDRADIO_OKGoodGOODRS_ISSUE_IDRs Issue IDNumber of Copies:ID1 $ P3_13_OCT_200213_04_10uAͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T!ͫͫͫͫͫͫͫ0D ""{ \ !PP@,@DX !1 $ VP15_20_DEC_200113_44_25Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Toͫͫͫͫͫͫͫ0D pp p< &'  $B D  6&'&'GE$F&'$h!XIssue TITLE is required hl (d2?^jo 1 $ P16_20_DEC_200113_44_25uAͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T!ͫͫͫͫͫͫͫ0D ""{  !PP@,hl2!1 $ P17_20_DEC_200113_44_25uAͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T!ͫͫͫͫͫͫͫ0D ""{  !PP@,hl!1 $ ZP18_20_DEC_200113_44_25Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Toͫͫͫͫͫͫͫ0D pp  \@ &'  $B D  6&'&'GE$F&'$h!\Issue VOLUME is required TX (P?^jo 1 $ P19_20_DEC_200113_44_25qAͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T!ͫͫͫͫͫͫͫ0D ""w ,    !LL< ( ! 1 $ FP20_20_DEC_200113_44_25ͫͫͫͫͫͫͫ w SYSSTANDARD RS_ISSUE xh '(MFSRS_ISSUEp <<MFSDUAL xh0-PUBLICDUALxh0-SYSDUALSEQ_ID xh 'MFSSEQ_IDSQLFORMS FORMS4W $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ089 E"PKG INIT""MYISSID"""" &(.1357    0D ͫͫͫͫͫͫͫ0D =`M 0+q{t DwDtD0& ' $ & ' $ ?& ' $ ;& ' $ /0" & ' $ b& ' 0$ ?& ' H$ ;& ' $ /!< <`8@T can_purchasedRS_ISSUEtab_4csrs_copy+0|  DL`dx  " DP\m~ !#SELECT TO_CHAR(SEQ_ID.NEXTVAL) FROM DUAL"=\ p0H1 $ rP21_20_DEC_200113_44_251Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss" dT &' ($K(G  9 ;0&'&'0GE$Fh!x-WHEN-VALIDATE-ITEM trigger failed on field - $((\` 4L PX?mr  -1 $ P44_20_DEC_200113_44_25lͫͫͫͫͫͫͫSQLFORMS w SYSSTANDARD FORMS4W $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 $"PKG INIT""TABPAGE"" "  ͫͫͫͫͫͫͫ0D !09 \@&'$c&'&'G EP$$ $ $&'$;&'&'G EP $'!$`TAB_4CSRS_COPY8P $TXN _  (41 $ P45_20_DEC_200113_44_25lͫͫͫͫͫͫͫSQLFORMS w SYSSTANDARD FORMS4W $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 $"PKG INIT""TABPAGE"" "  ͫͫͫͫͫͫͫ0D !09 \@&'$b&'&'G EP$$ $ $&'$;&'&'G EP $'!$`TAB_4CSRS_COPY8P $TXN _  (41 $ ^P12_20_DEC_200113_44_25ͫͫͫͫͫͫͫw SYSSTANDARD xk1MFSRS_COPYSQLFORMS xh (%MFSRS_RESERVATION$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08##p>"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:BHJPSTZ]^`bdfhjln  !   " (DL !&G& ͫͫͫͫͫͫͫ0\ mm!0!G(. \( &' <$B<b Z#w `(u  (y 6 .&'&'G E$Fs hs L &' `$B`b Z#wD`LuD LyD6 .&'&'G E$FsDhsD&'$! r{t$gd gd tgd ! r{tXgdDgdDtgdD !LL``<DXpx'Cannot delete ISSUE when a COPY exists..Cannot delete ISSUE when a RESERVATION exists. PRIMARY_CURL8 PRIMARY_CUR= (< DL` h|  = C W e$%&'() *,./ 4)O SELECT ''x'' FROM RS_COPY WHERE RS_ISSUE_ID = :b1"SELECT ''x'' FROM RS_RESERVATION WHERE RS_ISSUE_ID = :b1"! '.1 $ P13_20_DEC_200113_44_25uͫͫͫͫͫͫͫw SYSSTANDARD FORMS4C FORMS40 /NSPC1/QUERY_MASTER_DETAILS/NSPC1/CHECK_PACKAGE_FAILURE$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D 2"PKG INIT""RECSTAT"STARTITM"REL_ID"ID"" &)*017:<>@B   = H\p  ͫͫͫͫͫͫͫ0D    ? h   H  \pH  H4  4&'4$BD <&'L$-p'pd$4&'4$BD <&'|$-p'p$4&'4$BD <&'$-p'p$4&'4$BD <&'$-p'p$  \*  &'\$F'$!4 &)*&)*NEWINSERTRS_ISSUE.RS_ISSUE_RS_COPYRS_COPYRS_ISSUE.RS_ISSUE_RS_CONTENT RS_CONTENTRS_ISSUE.RS_ISSUE_RS_COMMENT RS_COMMENT'RS_ISSUE.RS_ISSUE_V_RS_ISSUE_CATEGORIESV_RS_ISSUE_CATEGORIES| (H0(\4|=p((((Ș ( (4  ++QW !"*D+g,z456<=> @ E x4Ld|   'L1 $ ^P14_20_DEC_200113_44_25oͫͫͫͫͫͫͫw SYSSTANDARD xk1MFSRS_COPYSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08C ="PKG INIT""DUMMY_DEFINE"RS_COPY_CUR""" (.069;=?A      4pq&  ͫͫͫͫͫͫͫ0P q  #_w4""""$')+   @ͫͫͫͫͫͫͫ0D AA @T+q{t wt!p`8@T 8< 4@SELECT TO_CHAR(SEQ_ID.NEXTVAL) FROM DUAL"1 $ FP27_20_DEC_200113_44_25Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tcͫͫͫͫͫͫͫ0D dd 0@  &' ${8  *&'&'GE$Fh!||\Purchase Date is required(, $?^c  1 $ P28_20_DEC_200113_44_25Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D *8 dl . :  *&'&'GE$Fh &' $K8  *&'&' GE$Fh!+Price must be greater than or equal to zeroPrice is required@X\` $<0OT $+ T1 $ P29_20_DEC_200113_44_25Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D Kx `t4   v p f 0` V HP  @  ;` 8&'&'8GE$Fh!GOODLOSTDAMAGEDREMOVEDIncorrect value for status - 

""Trͫͫͫͫͫͫͫ0D ss l@ &' 4$B4G  9  ; <&'&'<GE$Fh!hISSUE ID REQUIRED field - &(4dh @T  X`?mr  SEQ_ID.NEXTVALID / Barcode1 $ P24_20_DEC_200113_44_25Yoͫͫͫͫͫͫͫw SYSSTANDARD xh ( MFSRS_LOANSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D >"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:<>@B    & ͫͫͫͫͫͫͫ0P @ t &' 0$K0b Z#aw`u y6 .&'&'G E$Fshs&'$! r{t gdgdtgd !DD `8@T&Cannot delete COPY when a LOAN EXISTS. PRIMARY_CUR' TX\h0lp 8P = C W eSELECT ''x'' FROM RS_LOAN WHERE RS_COPY_ID = :b1"\&1 $ P25_20_DEC_200113_44_25Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T7ͫͫͫͫͫͫͫ0D 88 \,&'$$$ !hhPGOOD!$PX,48L+7  V_RS_ISSUE_CATEGORIESV_RS_ISSUE_CATEGORIES 0USDCHECKEDNOYESNOTITLECAT_IDCat IdISS_IDIss Id1 $ P32_20_DEC_200113_44_25gͫͫͫͫͫͫͫw SYSSTANDARD xh *MFSV_RS_ISSUE_CATEGORIES$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"<"PKG INIT"""""x 45ͫͫͫͫͫͫͫ0D 66 Lq{t 44 4!4"t4 !x`88L) 4""T ͫͫͫͫͫͫͫ0D   C !0 0  RS_CONTENTRS_CONTENTlist_order \d IDSEQ_ID.NEXTVALContent IDDURATIONDuration9999.009999.00LIST_ORDERList OrderTITLETitle1 $ RP35_20_DEC_200113_44_25Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tcͫͫͫͫͫͫͫ0D dd pL$ &'  $B 8  *&'&'GE$Fh!h'Title for the content entry is required hl (d2?^c  'DESCRIPTIONDescription1 $ ZP36_20_DEC_200113_44_25Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tcͫͫͫͫͫͫͫ0D dd  P% &'  $B 8  *&'&'GE$Fh!p+The description of this content is required(   (?^c  +RS_ISSUE_ID Issue1 $ BP37_20_DEC_200113_44_25Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tcͫͫͫͫͫͫͫ0D dd H<& &'  $B 8  *&'&'GE$Fh!xxXISSUE ID IS REQUIRED @D (< ?^c  Number of Contents:1 $ P34_20_DEC_200113_44_25ͫͫͫͫͫͫͫw SYSSTANDARD p <<MFSDUAL xh0-PUBLICDUALxh0-SYSDUALSEQ_ID xh 'MFSSEQ_ID$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 - <"PKG INIT"""""$')+    @ͫͫͫͫͫͫͫ0D AA 8T#+q{t  w t #!p`8@T 04,@SELECT SEQ_ID.NEXTVAL FROM DUAL"RS_COMMENTRS_COMMENTday desc i PS_PERSON_IDPs Person Id1 $ .P39_20_DEC_200113_44_25qͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS xh MFS PS_PERSON$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D >"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:<>@B    $& ͫͫͫͫͫͫͫ0P !0 ( &' $K8  *&'&'GE$Fh$( &' 8$K8h `#[w`$u $y<  .&'&'GE$Fshs! r{t gdgd(tgd !|| `8@T#PERSON ID is required for a CommentPERSON does not exist in table. PRIMARY_CUR-\` dh$lx8| @X?^g#SELECT ''x'' FROM PS_PERSON WHERE ID = :b1"!T#1 $ 2P40_20_DEC_200113_44_25[ͫͫͫͫͫͫͫw SYSSTANDARD xh MFS PS_PERSON$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08: <"PKG INIT"""""$'(.12468    4K ͫͫͫͫͫͫͫ0D LL% \q{t 4w4w44(t4)*!`$8H\) 4""Trͫͫͫͫͫͫͫ0D ss" TT ' &' (${(G  9 ;0&'&'0GE$Fh!x-WHEN-VALIDATE-ITEM trigger failed on field - $((LP 4< @H?mr  -NOTENote1 $ vP42_20_DEC_200113_44_255Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss& \T+ &' 4$B4G  9  ; <&'&'<GE$Fh!|-WHEN-VALIDATE-ITEM trigger failed on field - '(4TX @D HP?mr  -First Name:Last Name:Number of Comments:RS_ISSUE_IDRs Issue Id1 $ vP43_20_DEC_200113_44_255Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss& lT, &' 4$B4G  9  ; <&'&'<GE$Fh!|-WHEN-VALIDATE-ITEM trigger failed on field - &(4dh @T  X`?mr  -1 $ P38_20_DEC_200113_44_25}Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T+ͫͫͫͫͫͫͫ0D ,, 0 &'$ '!LL<$,  + R0X|\ <X$Xl(p$\t<| h DCATEGORY FIND_ITEMVCHECKED4VOLUME5 PUBLISHEDT CHECK_PACKAGE_FAILURE8BTN_VIEW_ISSUE_INFOK REORDER_INFOf NUM_CONTENTSlDAY9 RS_ITEM_ID-RS_ITEM_RS_ISSUET COPIESD"AUTHORtB&QUERY_ID0UV_RS_ISSUE_CATEGORIESil]VTG.4ROWIDt QUERY_MASTER_DETAILSX MEDIA_TYPE TAB_4CScX7# DESCRIPTIONtT FIND_VNUMoP_FNAME*PB_FIND_ITEM_VNUM\ CAN_PURCHASEDFRS_ISSUE_RS_CONTENT pP_LNAME JPRICE< PERSONi RS_COMMENTnNOTE4H PURCHASEDL@ DSP_TITLE'UNITS@RS_ITEMERS_ISSUE_RS_COPYx RESOURCESCONTENT CLEAR_ALL_MASTER_DETAILSbXX2TITLEq NUM_COMMENTSQ NUM_COPIES<BTN_NEXT` LIST_ORDER hFRS_COPY$>DSP_ID@\ RS_CONTENTj PS_PERSON_ID;BTN_PREV) PB_FIND_ITEM0YCAT_ID0V_NUMBERDZISS_IDL^R/% ID-RS_ISSUEre8PX RS_ISSUE_ID0FRS_ISSUE_RS_COMMENT LOCKIT`_DURATIONLFRS_ISSUE_V_RS_ISSUE_CATEGORIESLSTATUS`A DSP_VOLUME0  RS_MEDIA_TYPE_IDP 8? DSP_PUBLISHEDCAN_ITEMCOMMENT(@T$v(tp8I,1<``8,\2 1 \7 pp  +(dPt<X4+..x"02s. \ \ x|us ǽE  |ǽE` ǽUU99l9FRAME24X   UUV ppq   UU0  TahomaResource Item  |4rge4r~j 7re79799FRAME6  4U Ue4p pq 874U U0@TIssuesx0u e`&9rUxP   09"r"U &@ 99"M0TEXT82  8 ArialInformation for Issue:  0U59 5 U &@ U59U59 M0GRAPHIC137   (Title)  09r9qUU &@ 9r99r9M0GRAPHIC138   (Volume)x 755D T D/  udUrU)u  0     dUrU)u|  Urpxx 9FRAME8t    d Us pq  d U0 ( TahomaCopies AqVrA @ AAAALINE97    cH 7*a ;L cr 7cr 8r 8r cr X9UFRAME130@   jH Uj pq jr jH U0 Copy Status   cD6aeD: cG6cGǙGǙ\c\9UGRAPHIC131   jDUjeDpq jGjDU0$8 Copy Status / uǙFeǝg  ǙFeǝg` Ǚchhl9FRAME94X  9UUppq 99UU0 Categories/ Ludo r  Ldo r, Um99tt89FRAME88$  dUUsppq dUU0Issues Contentt  /  vdFqsdh  dFqs ovv9FRAME19  hdUspq dU0Comments(/$T|4/@l 2x/5<T/MT$/f </'////|c/G2 2$02,0J|00(XG<0^ M0 @X0" X(0. @TX00 0$0PT0$(<j$d0 0J(0QX&$0(J@tB $0l1d $1 0@P 1X|(1p&$F F F @-hF0U\i   p-|-FFF+@@ 4 "#%&')*@@ | w$}2e2FF@n@Fh @! "w$}#lLJ|!`J@!lJ Xn @tJ? @Pp"@"@#(w$}2?&q2T#T@@%H%H$}?4+=T$T@0n#@TP%@&xXw$ 2 tXd&XP@'Pw$@  x'XP@( d$T J (X@@T**)$<D i0*!X X@X Z)@ Xl*@++ )$<f~i+,]@0]Z*@ @]+2 ,& P,&"2,&#,&%&@ pb8@(ho@Ln,-@--@- Hh.EsEXussX.sC-- ./0X245X789;<$>8?L@`AtB--0Z$ 6 th0 tP!-1P2Z$ #6 $t|10t!n0-$}C+*{88{@0-9d9Z$<ID9{@ {Z8- 9-;;%A$ hQ 0{:<{n9-ؔP;-<h<\ $< d<H{@L{Z;- L<-= >\ $<~ =P{@T{Z<- (=-(?\A $T 7 ?X{@-<@< \A  $T C7 @\{@`{-PA\A $2S|2,Al{@-dB \A$2m2@Bp{@-xCPw$@  TCt{P/ C&0 (D&X22XD&4D&5 D&X7D&9&- 8-do-R-|EHEExEEF0FLF-hF-\d-i-0U H4G(U{`ux{{$G{ShFhF TG4H JKL8PQRhFhFIxJ x T $} CB7 {I{P8I){ {{n4HhFIhFKK xT $} B2 {J|L |||n JhF`KhFL UT $}BQ1$|tL4|@0hFM4P L|nT $} J D|MT|@N`|NOp|xh|$!2`NL\|@||ON|x|$-2NLx|@|ON|x|$92`OL|@|NO|x| (OL|@nLhFPhF8?L@`A4H JKLQRVX'L^`_`bcfjlnopq,4v, AAAAAA%'A ' A  ' '' #'&'tB'/'0'$>'X2'L@'`A'4' 8?' 5'9'R' 4H'L' J'8P'V' 0Y'!DZ'"L^'#b'$c'%e'& l''j'(o')p'*n'+r', ssss{{{{{ $< ,dtx (,0<@HTX\dhpt4\ 4<\`$,4X\tx$(@\lp,PX`h$(D`x$,4<\  0 4 T l (048<@DHLPTx8@DHLPTXltx(tx$H`p P8@\`htlx|   T < T , D H L P T X ` h |  d |  4 d 0L\0x$DHPXlH`p$8,<Xdl T$04<HLTdtx| 0\|(48@LPXhptx| $T\dl| $(X`hp04LT\lp(,048<@DXdt  $(,04@ ,4x | !!\!`!|!!!!8"P"T"h""""""""""#h#l###$$$$h$$$$`%d%x%%%%%%%%D&H&d&&&&&'\'x''''' (L(X((()) )) )d)l))))0*\*|*********+ +d++++++++, ,0,P,`,,,,,-$-8-T-h-p-t-x-|------------- ...$.(.h.l.p.t.x.|............./////H0L0h0|0000001\1`1|112220242H2P2T2X2`2d2p2x223383333334 4444 4,4444444x5|555555555555<6666664787L7T7X7`7d7x778888888889p99999999::: :h::::`;d;x;;;;;;;;H<d<<<<<<<<<<<@====>>> >$>,>0>D>>>?8?@?D?X???@H@L@T@X@l@@A,A`AhAlAAA$B@BtB|BBB8CTCCCCCD(D8DXDhDDDDDD,E@E\EpEEEEEEEEEEEEEEFFFF$F0F8F@FLFTF\FhFlFFFFFFFFFFFF4G8G