'L'|RS_CHECK_IN_STOCKNRS Check InDEFAULT&SMARTBARAMERICAN_AMERICA.WE8ISO8859P11 $ P0_29_JAN_200216_29_40E>ͫͫͫͫͫͫͫSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D O &'$/!00 1 $ P1_29_JAN_200216_29_40a>ͫͫͫͫͫͫͫSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T1ͫͫͫͫͫͫͫ0D 22k &'&'&'GEGE $4!00 11 $ P17_29_JAN_200216_29_40aWͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08; ,"PKG INIT""MSGNUM"MSGTXT"MSGTYP""%()/23579  P   < ͫͫͫͫͫͫͫ0D  &' $,&'(($-(&'PP$.P<.d d  6.l l  .t t5 +&'&'GE$F.0| |  .8 5 +&'&'@GE$F.X 5 +&'&'`GE$FG;"MSGNUM"MSGTXT"MSGTYP""%()/23579  P   <[ ͫͫͫͫͫͫͫ0D \\ex) &' $G&'(($H(&'PP$IP<.d d  6.l l  .t t  .| |  .    .( 5 +&'&'0GE$FG;""T=ͫͫͫͫͫͫͫ0D >>    ] , ],$$ !ddT1$,4< @HLdh=DATE_SENTDate Sentmm/dd/RRRRPERSONPersonV_NUMBERStock #RS_COPY_IDCopy IdDATE_NEEDEDDate Neededmm/dd/RRRRmm/dd/RRRRPS_PERSON_IDPs Person IdMAIL_ADDRESSMail AddressSHIPPING_DAYSShipping DaysDAYS_NEEDEDDays NeededSTATUS_DATEStatus Datemm/dd/RRRRmm/dd/RRRRPS_MEMBERSHIP_IDPs Membership IdStatusTahomaCheck In1 $ bP15_29_JAN_200216_29_40!ͫͫͫͫͫͫͫw SYSSTANDARD xh ( MFSRS_LOANSQLFORMS FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08N W"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY"""$&,/069:@BDFHJL    $8& ͫͫͫͫͫͫͫ0P =` 4$#w`$u $y[  M&'&'G E$F&'&'G E$Fshsq{tX88t8 &'$(0@E@&'H$F&'$/! r{t$gdgdtgd !h``BB<DXBBppBThat ITEM is not checked out! You may need to enter it as a loan! v_rs_loans.pb_check_in$ PRIMARY_CUR3 $ 8@ H`d|, @ _ ~  BSELECT ''x'' FROM RS_LOAN WHERE RS_COPY_ID = :b1 AND STATUS = ''OUT''"UPDATE RS_LOAN SET STATUS=''RETURNED'' WHERE RS_COPY_ID = :b1 AND STATUS = ''OUT''"= B0HDetails1 $ VP16_29_JAN_200216_29_40ͫͫͫͫͫͫͫw SYSSTANDARD TOOLS FORMS40 FORMS4C SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 , "PKG INIT""PID"ID""#&(*    ͫͫͫͫͫͫͫ0D 8dw  &'0$0 &' @$J@%  &' $&'H$H &'X&' 4GE X$&'&'&'&'LGEGE GId $ &'$/!$4$ &)*&)*params P_LOAN_IDrs_loan4 0@HXl6`q       x4 LCheck In1 $ aP3_20_JUN_200311_46_36!ͫͫͫͫͫͫͫw SYSSTANDARD xh ( MFSRS_LOANSQLFORMS FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08N W"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY"""$&,/069:@BDFHJL    $8& ͫͫͫͫͫͫͫ0P =` 4$#w`$u $y[  M&'&'G E$F&'&'G E$Fshsq{tX88t8 &'$(0@E@&'H$F&'$/! r{t$gdgdtgd !h``BB<DXBBppBThat ITEM is not checked out! You may need to enter it as a loan! v_rs_loans.pb_check_in$ PRIMARY_CUR3 $ 8@ H`d|,@ _ ~  BSELECT ''x'' FROM RS_LOAN WHERE RS_COPY_ID = :b1 AND STATUS = ''OUT''"UPDATE RS_LOAN SET STATUS=''RETURNED'' WHERE RS_COPY_ID = :b1 AND STATUS = ''OUT''"= B0HScan Copy Id1 $ !P1_20_JUN_200311_46_36oͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS xh 'MFSRS_COPY$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D >"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:<>@B    $& ͫͫͫͫͫͫͫ0P !0  &' $K8  *&'&'GE$Fh$ &' 8$K8h `#[w`$u $y<  .&'&'GE$Fshs! r{t gdgdtgd !xx`BB8@TCopy Id is a REQUIRED field!Copy ID is not in the COPY table. PRIMARY_CUR-\` dh$lx8| @X?^g#BSELECT ''x'' FROM RS_COPY WHERE ID = :b1"!T|!DI\IIII,JHJpJJJJJDKXKKKKp LOV11|IWINDOW_CHECKIN$RS_COPY_ID_SCAN DATE_NEEDEDIh DATE_DUE SHIPPING_DAYSJPS_MEMBERSHIP_ID DAYS_NEEDED` PB_CHECK_INV_NUMh"t ROWIDJd V_RS_LOANS<CANVAS2H#PB_CHECK_IN_SCAN PERSONK LOV_PICK_COPY,K STATUS!BLK_SCANT IDtK PS_PERSON_IDl RS_COPY_ID PB_VIEW_LOANKh MAIL_ADDRESSd STATUS_DATE  DATE_SENT H&\8\\\\ @$4``8\H2 dTp 1 7 $ P8@hI"0L <<J & HFQ S   HFQ S rOr8r8__9FRAME3   q HUU ppq (q rq HUU00L TahomaCheck In Item\Hl{ C/;nK]lt/ pK\ (@l$PIJ $Q() d!J 0  )0)<)   H)\)P t T h   lhd `d|JdX PK<pW =< )4 )dl I <p J=< H ))xh d )| d K< pU =< , ,,dJ<p=%=`%,,dTJ< p} "=< ,-pdpK< p} ^=<  -L-dI pA Q  -,-@8-D-ddKpA Q P-`-@dlK pA Q p-H-@dI pA--@dJ pA"--@dhK  pA Q -D-@--dI pA Q - .@d Kp@ /= .d8J<@p<=0 (. 0.@4.Z`d @.dKL<@p<=0 5@5Zd 5T & & %&  &l@ & p & &h &!&0!&d `!&&8K\"L" h"H#$!|J!L$J$<@p< 3($;@ ;ZH#! ;d$!%I&<p| < x%|BAn$!B%T h   l`H#$ X&$'$' h '  'H 'H 'H l'T 'l'7))))HHHHHHHHIIII I,I0I4I8IHI\I`IIIIIIIIJ0JLJ`JhJJJJJJJJKK0KHKXK\KxKKKKKKc(48<@DHLPTx$t8<@Th@(0dhl8$,<@px ,\`dh|0 4 8 < @ D H L P T X \ ` d h l p t T \ ` t   4 h p t , H x  p t 0 $8|dltx,0L, hpt(,H(||dlp$(D$x| x`hlx$X  dl ,0DLP` @ P p !!0!@!`!!!!"\"`"d"h"t"H#P#T#`#h### $($T$t$x$$$$$$$$%\%x%%&&& &$&(&,&0&4&8&<&@&D&L&h&&&&&''0'@'X'''