'І8,RS_CHECK_INMODULE1DEFAULT&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;""""$'(*,    8ͫͫͫͫͫͫͫ0D 99 pTq{t  w  t !x`BB 8@ T! hl(HLd8SELECT V_NUMBER FROM V_RS_LOANS WHERE ID = :b1"Date Duemm/dd/RRRR1 $ qP3_29_JAN_200216_29_401Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss" TT  &' (${(G  9;0&'&'0GE$Fh!x-WHEN-VALIDATE-ITEM trigger failed on field - $((LP 4< @H?mr  -1 $ P4_29_JAN_200216_29_40Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T=ͫͫͫͫͫͫͫ0D >>   ] , ],$$ !ddT1$,4< @HLdh=DATE_SENTDate Sentmm/dd/RRRR1 $ qP5_29_JAN_200216_29_401Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss" TT  &' (${(G  9;0&'&'0GE$Fh!x-WHEN-VALIDATE-ITEM trigger failed on field - $((LP 4< @H?mr  -Stock #RS_COPY_IDCopy Id1 $ !P6_29_JAN_200216_29_40oͫͫͫͫͫͫͫ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 gdgd tgd !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|!DATE_NEEDEDDate Neededmm/dd/RRRRmm/dd/RRRR1 $ qP7_29_JAN_200216_29_401Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss" TT  &' (${(G  9;0&'&'0GE$Fh!x-WHEN-VALIDATE-ITEM trigger failed on field - $((LP 4< @H?mr  -PS_PERSON_IDPs Person Id1 $ 1P8_29_JAN_200216_29_40qͫͫͫͫͫͫͫ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 !`BB8@TPerson ID is a REQUIRED field%Person Id is not in the PERSON table. PRIMARY_CUR-\` dh$lx8| @X?^g#BSELECT ''x'' FROM PS_PERSON WHERE ID = :b1"!T%MAIL_ADDRESSMail Address1 $ -P9_29_JAN_200216_29_40rͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS xh ('MFS SY_ADDRESS$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ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 !|| `BB8@TMail Address is required&Address ID not found in ADDRESS table. PRIMARY_CUR-\` dh$lx8| @X?^g#BSELECT ''x'' FROM SY_ADDRESS WHERE ID = :b1"!T|&SHIPPING_DAYSShipping Days1 $ P10_29_JAN_200216_29_40Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D   X  .( (I  9;0&'&'0GE$Fh  &' 4$K4G  9;<&'&'<GE$Fh!-WHEN-VALIDATE-ITEM trigger failed on field - ,((h(4 @X \d0^c $-DAYS_NEEDEDDays Needed1 $ P11_29_JAN_200216_29_40Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D   X) .( (I  9,;0&'&'0GE$Fh) &' 4$K4G  9,;<&'&'<GE$Fh!-WHEN-VALIDATE-ITEM trigger failed on field - ,((h(4 @X \d0^c $-STATUS_DATEStatus Datemm/dd/RRRRmm/dd/RRRR1 $ rP12_29_JAN_200216_29_401Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss" TT  &' (${(G  9;0&'&'0GE$Fh!x-WHEN-VALIDATE-ITEM trigger failed on field - $((LP 4< @H?mr  -PS_MEMBERSHIP_IDPs Membership Id1 $ P13_29_JAN_200216_29_40Yuͫͫͫͫͫͫͫw SYSSTANDARD xh !MFS PS_MEMBERSHIPSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D >"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:<>@B    & ͫͫͫͫͫͫͫ0P 8 t &' 0$K0h `#[w`u y<  .&'&'G E$Fshs! r{t gdgdtgd !DD `BB8@T,Membership ID not found in MEMBERSHIP table. PRIMARY_CUR' TX\h0lp 8P = C W kBSELECT ''x'' FROM PS_MEMBERSHIP WHERE ID = :b1"\,STATUSStatus1 $ P14_29_JAN_200216_29_40IWͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D Kx; t4   v p f 0` V HP  @ ;` 8&'&'8GE$Fh &' <$B<G  9 ;` D&'&'DGE$Fh!OUTLOSTDAMAGEDRETURNED-WHEN-VALIDATE-ITEM trigger failed on field - &(""T&ͫͫͫͫͫͫͫ0D '' 00&'$/!``HRETURNED,& Details1 $ 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 L1 $ P2_29_JAN_200216_29_40Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T+ͫͫͫͫͫͫͫ0D ,,  x,. E   !hhPOUT! \t(@ DX+  $Check In1 $ ]P3_20_JUN_200311_46_36ͫͫͫͫͫͫͫw SYSSTANDARD xh ( MFSRS_LOANSQLFORMS FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08N W"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY"""$&,/069:@BDFHJL    $8& ͫͫͫͫͫͫͫ0P =` 0$#w`$u $y[  M&'&'G E$F&'&'G E$Fshsq{tX88t8 &'$(0@E@&'H$F&'$/! r{t$gdgdtgd !d``BB<DXBBppBThat ITEM is not checked out! You may need to enter it as a loan! rs_loan.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 IdStock # searchTahomaww$x@xxxxxy(y@y`yyyyz4zlz  LOV11xtWINDOW_CHECKIN%RS_COPY_ID_SCAN( DATE_NEEDEDXxx DATE_DUE SHIPPING_DAYSxXPS_MEMBERSHIP_IDxH DAYS_NEEDEDDRS_LOANh PB_CHECK_IN<V_NUMx#P ROWIDCANVAS2X$PB_CHECK_IN_SCANyl LOV_PICK_COPYySTATUS"BLK_SCAN0 ID0' STOCK_NUMBERy PS_PERSON_IDP RS_COPY_ID PB_VIEW_LOANPz8 MAIL_ADDRESS STATUS_DATE  DATE_SENT1 $ !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 gdgd tgd !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|!1 $ !P1_01_APR_200416_17_43oͫͫͫͫͫͫͫ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 gdgd tgd !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|! )<p  d   ((``8 Dw2 dHp 1 t7  P,tw"08 4ytpX) HFQ S  pHFQ SP rOrr__\9FRAME3H  q HUU ppq q rq HUU0 TahomaCheck In ItemHHX{ C/4L;nK]XLL`/ 4l lyl (P$wdJL0' $Q4%$) D"x  " d))$)   ,)<)X  P 0 x  <P(8HXhDyD4 yt   =< ) )?0 D)D D| Lx   J=< X --nx D-xx D  1  D xz8  U =< 3 4 4n D4D@x =<7Dz$0 = =< 77lnPD7D,0x  A Q ==@==n(D=|Dy4 A Q pAA@nDAD<@z A Q GG@n8DGDdxD  AN$N@nD4NDLx  A",R(8R@nHDDRD\zT   A Q