'\XRS_RESERVEMODULE2DEFAULT&SMARTBARAMERICAN_AMERICA.WE8ISO8859P11 $ P0_17_AUG_200412_30_49aWͫͫͫͫͫͫͫ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;ͫͫͫͫͫͫͫSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T1ͫͫͫͫͫͫͫ0D 22k &'&'&'GEGE $4!00 1VA_LOV#POPUPHINT#Select ItemReserving a ResourceOKSavedLOV_PICK_PERSONselect name,id,alternate_id,org_name from v_ps_pick_person order by unameNAMEIDALTERNATE_IDORG_NAMELOV_MEMBERSELECT ALL PS_ORGANIZATION.NAME, PS_POSITION_TYPE.POSITION, PS_MEMBERSHIP.ID,ps_organization.paid FROM PS_MEMBERSHIP, PS_ORGANIZATION, PS_POSITION_TYPE WHERE ((PS_MEMBERSHIP.PS_PERSON_ID = :blk_res.PS_PERSON_ID) AND (PS_MEMBERSHIP.PS_ORGANIZATION_ID = PS_ORGANIZATION.ID) AND (PS_MEMBERSHIP.PS_POSITION_TYPE_ID = PS_POSITION_TYPE.ID) and ps_membership.left is null)NAMEPOSITIONIDPAIDLOV_MEDIAselect id,units from rs_media_typeIDUNITSPick PERSONNameIdAlternate_IdOrg_NamePick Member OrganizationNamePositionIDPick MediaMedia????= = = ?zzz??(((??@??????@??????@??????@??????@?????????333333?p=p=p=?GGG?QQQ?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?????(\(\(\?ffffff?ppp?zzz??@??????@??????@??????@??????@??????????\\\??ףףף??@??????@??????@??????@??????@??????????QQQ????@??????@??????@??????@??????@????????? ?GGG????@??????@??????@??????@??????@?????TahomaTahomaPerson IDTahoma1 $ P3_17_AUG_200412_30_49qͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS xh MFS PS_PERSON$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D -"PKG INIT""CUR""JUNK""$&,/069:<>@B    $& ͫͫͫͫͫͫͫ0P !0e   -&'&'GE$Fh$#[w$u $y<  .&'&'GE$Fshs! r{t gdgdtgd !ll `:@8@TPERSON ID is required3That ID is not valid. Press F9 to select a person.CUR' pt$x 8PTl=FL`t @SELECT ''x'' FROM PS_PERSON WHERE ID = :b1"!Tx31 $ P4_17_AUG_200412_30_49eqͫͫͫͫͫͫͫw SYSSTANDARD xh MFS PS_PERSONSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08YF"PKG INIT""CUR""JUNK"""@$&,/069:@BHKMOQSUW    8@\& ͫͫͫͫͫͫͫ0P  @@#w8@u8 @y8<  .&'&'G E$Fs8hs8ETq{tX\w\\t\! r{t$gd8gd8tgd8 ! D``:@<DX:@px3That ID is not valid. Press F9 to select a person.CURJ (8(@ (T4 (\8< d| 0  , @ _ chllx@SELECT ''x'' FROM PS_PERSON WHERE ID = :b1"SELECT LAST_NAME || '', '' || FIRST_NAME FROM PS_PERSON WHERE :b1 = PS_PERSON.ID" 3Membership ID (optional)1 $ -P5_17_AUG_200412_30_49ͫͫͫͫͫͫͫ w SYSSTANDARD xh !MFS PS_MEMBERSHIPSQLFORMS RS_RESERVATION xh (%MFSRS_RESERVATIONxh MFSPS_ORGANIZATIONxh ('MFS SY_ADDRESSFORMS4C FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 RR|"PKG INIT""CUR""JUNK"SID"""""R$&,/069:@CDEKMSVWX^`fijpstz}~    PQJ?  K L M@NA( B"!($C&%(D*),E.- 0F214G56 8O:H<;d>I(((Ppt ddhi&#'+/39= 7ͫͫͫͫͫͫͫ0P i # (D#Wwu y<  .&'&'G E$Fshs&'$K   ,44@HHT\\hpp| E q{t\wtE q{tw w4wwHwpwwt  44HHpp E q {tww t3  &'&'& ' 0G IG I $ &'&'& ' HG IG I $ &'&'& ' `G IG I $ &'&'& ' xG IG I $ &'&'& ' G IG I $ &'&'& ' G IG I $  ! r{t(gdgdtgd !| | |````:@@H\:@t|:@(( :@l d 07That ID is not valid. Press F9 to select a membership.(Organization Address)blk_res.street_1blk_res.street_2 blk_res.city blk_res.state blk_res.zipblk_res.ATTENTION4(CUR6 ( $((4*8P*TX*\h*,lx*@|*T*h*|* ** * ** *$((( @(4Dx(H|(\(p( ((0(4\(`((  , @ _ c hlq #/)24#8/9^:;<=>O@[AhChDq@SELECT ''x'' FROM PS_MEMBERSHIP WHERE ID = :b1"SELECT PS_ORGANIZATION.SHIPPING_DAYS FROM PS_ORGANIZATION WHERE ID = (SELECT PS_ORGANIZATION_ID FROM PS_MEMBERSHIP WHERE ID = :b1 )"SELECT STREET_1,STREET_2,CITY,STATE,ZIP,ATTENTION,ID FROM SY_ADDRESS WHERE ID = (SELECT SY_ADDRESS_ID FROM PS_ORGANIZATION WHERE ID = (SELECT PS_ORGANIZATION_ID FROM PS_MEMBERSHIP WHERE ID = :b1 ) )"SELECT NAME,PAID FROM PS_ORGANIZATION WHERE ID = (SELECT PS_ORGANIZATION_ID FROM PS_MEMBERSHIP WHERE PS_MEMBERSHIP.ID = :b1 )"$87t0H` x  Shipping DaysMM/DD/YYYYDate Neededmm/dd/RRRRmm/dd/RRRRDays Needed1 $ P6_17_AUG_200412_30_49Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D *8 d . :  *&'&'GE$Fh &' $K8  *&'&' GE$Fh!.Days Needed must be Greater than or equal to 0 Days_Needed is a REQUIRED field.@X\` $<0OT $. X Issue IdTahomaFind and Select Item1 $ P7_17_AUG_200412_30_49lͫͫͫͫͫͫͫw SYSSTANDARD FORMS40 SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T&ͫͫͫͫͫͫͫ0D '' &'$F&'$/!X$X@v_rs_description.BTN_SELECT BB&B TahomaChange Address1 $  P8_17_AUG_200412_30_49kͫͫͫͫͫͫͫw SYSSTANDARD FORMS4C FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""TEͫͫͫͫͫͫͫ0D FFY XE &'&'&'GIGI $&'&'&'GIGI $&'&'&'0GIGI $&'&'&'HGIGI $&'&'&'`GIGI $&'&'&'xGIGI $&'$F!$ blk_res.street_1blk_res.street_2 blk_res.city blk_res.state blk_res.zipblk_res.ATTENTION""T&ͫͫͫͫͫͫͫ0D '' &'$;&'$/!HH0 sy_address BB&B Save Reservation1 $ P10_17_AUG_200412_30_49 Pͫͫͫͫͫͫͫ w SYSSTANDARD p <<MFSDUAL xh0-PUBLICDUALxh0-SYSDUALSEQ_ID xh 'MFSSEQ_IDISSUE_AVAILABLE xhMFSISSUE_AVAILABLESQLFORMS xh ('MFS SY_ADDRESSxh (%MFSRS_RESERVATIONFORMS4W $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 ''"PKG INIT""TEMP_ID"TEMP_AVAIL"AL_BUTTON"CUR_SEQ""CUR_AVAIL"ISSUE_AVAILABLE""""%()/2:@BHKSY[adjlrtvxz|~    $  % &!  " # (0J  ͫͫͫͫͫͫͫ0\ ++/H<l* #w u    88@@BTT,hh||-& ' & ' G$E$ Fh#wu q{t(v((((((( t(  8E8q {t000v000!0 0t0 & ' $ & ' 0$ =! r{t(ghtgh ! r{t\gh gh gh !gh  gh tgh  ! ````@@H\@t|@@YES.Address is required-Select or Enter an AddressAL_SAVED\LCUR_SEQ| CUR_AVAIL(4L(P\*`x *| *  *( *0( 8L ( PX((\t(0x(8(@((T(h (|$8 (<p((t( (̸((((0!7GWA#M'-.03@ @SELECT SEQ_ID.NEXTVAL FROM DUAL"SELECT ISSUE_AVAILABLE(:b1,:b2,:b3,:b4) FROM DUAL"INSERT INTO SY_ADDRESS VALUES ( :b1,:b2,:b3,:b4,:b5,:b6,:b7 )"INSERT INTO RS_RESERVATION VALUES ( SEQ_ID.NEXTVAL,:b1,:b2,:b3,:b4,:b5,:b6,:b7 )"/$.0,IDStreet 1Street 2CityStateZipAttention1 $ P11_17_AUG_200412_30_49uAͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T!ͫͫͫͫͫͫͫ0D ""{  !PP@,TX<!Org:Paid:mm/dd/yyyyCANCEL1 $ P12_17_AUG_200412_30_49Vͫͫͫͫͫͫͫw SYSSTANDARD FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D ~ &'$F!LL<blk_res.PS_PERSON_ID  CANCEL1 $ P13_17_AUG_200412_30_49Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T&ͫͫͫͫͫͫͫ0D '' &'$;&'$i!DD,blk_res & Clear Form1 $ P2_26_OCT_200414_43_22a>ͫͫͫͫͫͫͫSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T1ͫͫͫͫͫͫͫ0D 22k &'&'&'GEGE $!00 1V_RS_RESERVATION_LISTV_RS_RESERVATION_LISTissue_id in (select rs_issue.id FROM RS_ISSUE where ISSUE_AVAILABLE(rs_issue.id, :1, :2, :3) = 'YES')mm6N.ITEM_IDItem IdISSUE_IDIssue IdV_NUMBERStock #ITEM_TITLEItem TitleISSUE_TITLEIssue TitlePUBLISHEDPublishedVOLUMEVolumeRS_MEDIA_TYPE_ID MediaTahomaSelect1 $ P14_17_AUG_200412_30_49Vͫͫͫͫͫͫͫw SYSSTANDARD FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T2ͫͫͫͫͫͫͫ0D 33 `<&'$F!tt\blk_res.PS_PERSON_ID0DH\ !2 SY_ADDRESSSY_ADDRESSID in (Select sy_address_id from ps_address where ps_address.ps_person_id = :1)rr FH(IDSEQ_ID.NEXTVALID1 $ P17_17_AUG_200412_30_49\ͫͫͫͫͫͫͫw SYSSTANDARD xh  9MFS PS_ADDRESS$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 . <"PKG INIT"""""$'(*,    8ͫͫͫͫͫͫͫ0D 99  Tq{t  w  t !x`:@ 8@ T! |(\`x8SELECT PS_ADDRESS_TYPE_ID FROM PS_ADDRESS WHERE SY_ADDRESS_ID = :b1"STREET_1Street 11 $ P18_17_AUG_200412_30_49Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D  T  &' 44$, 4I  9 ; H&'&'HGE$Fh &' L$BLG  9 ; T&'&'TGE$Fh!-WHEN-VALIDATE-ITEM trigger failed on field - 14(L X( O} -STREET_2Street 2CITYCitySTATEStateZIPZipATTENTIONAttentionSelectAddress Type={| |<|X||||Ll8xԨ8PЩThԪX"BTN_SAVEWINDOW1 CAN_RESERVE LOV_MEDIA0DSP_PAID\P*ZIP/ ORGANIZATION| CAN_PERSON_ADDRESSNH)STATE1 $ P19_17_AUG_200412_30_49IWͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D : T  &' 44$, 4I  9 ; H&'&'HGE$Fh!-WHEN-VALIDATE-ITEM trigger failed on field - )4 L( O}  -1 $ P20_17_AUG_200412_30_49Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D  T  &' 44$, 4I  9 ; H&'&'HGE$Fh &' L$BLG  9 ; T&'&'TGE$Fh!-WHEN-VALIDATE-ITEM trigger failed on field - 14(L X O} -1 $ P21_17_AUG_200412_30_49Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D  T  &' 44$, 4I  9 ; H&'&'HGE$Fh &' L$BLG  9 ; T&'&'TGE$Fh!-WHEN-VALIDATE-ITEM trigger failed on field - 14tx(L| Xd hpO} -1 $ vP22_17_AUG_200412_30_495Wͫͫͫͫͫͫͫ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 $ P23_17_AUG_200412_30_49yͫͫͫͫͫͫͫw SYSSTANDARD FORMS4C FORMS40 SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D u> |E 44  \\HHpp  &'&'&'GIGI $&'&'&'0GIGI $&'&'&'HGIGI $&'&'&'`GIGI $&'&'&'xGIGI $&'&'&'GIGI $&'$;&'$i!,d(Personal Address)blk_res.street_1blk_res.street_2 blk_res.city blk_res.state blk_res.zipblk_res.ATTENTIONblk_res($<(@X( \(4((H(\8((p<d(h(((( (  (8*<x !4GZm    . ] 80PHh `| x 1 $ P24_17_AUG_200412_30_49Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D  T  &' 44$, 4I  9 ; H&'&'HGE$Fh &' L$BLG  9 ; T&'&'TGE$Fh!-WHEN-VALIDATE-ITEM trigger failed on field - 14(L X( O} -1 $ 2P15_17_AUG_200412_30_49 ͫͫͫͫͫͫͫw SYSSTANDARD xh MFSPS_ORGANIZATIONSQLFORMS xh  9MFS PS_ADDRESSxh (%MFSRS_RESERVATIONxh ( MFSRS_LOAN$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08AA>"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:BHJPSTZ]^flntwx~ <=40  5 >617?82 "9$#@': )3+*-;/.8@\d&'&M&s&&(% !&,ͫͫͫͫͫͫͫ0t 'DMxs @ &' 0$K0b Z#w`u y6 .&'&'G E$Fshs@ &' T$KTb Z#w8`@u8 @y86 .&'&'G E$Fs8hs8d &' x$Kxb Z#0w\`du\ dy\6 .&'&'G E$Fs\hs\ &' $Kb Z#w`u y6 .&'&'G E$Fshs&'$! r{t(gdgdtgd ! r{t\gd8gd8tgd8 ! r{tgd\gd\tgd\ ! r {tgdgdtgd !*````:@@H\:@t|:@:@?Cannot delete master record when matching detail records exist.hT PRIMARY_CUR PRIMARY_CUR PRIMARY_CUR PRIMARY_CURo  0 8@T (\(d(x ( $((4(8<  = C W e"#$%&' (*,?C@IA]BkCDEGIWXYZ[ \]_ab&g/@U@{;@S@SELECT ''x'' FROM PS_ORGANIZATION WHERE SY_ADDRESS_ID = :b1"SELECT ''x'' FROM PS_ADDRESS WHERE SY_ADDRESS_ID = :b1"SELECT ''x'' FROM RS_RESERVATION WHERE MAIL_ADDRESS = :b1"SELECT ''x'' FROM RS_LOAN WHERE MAIL_ADDRESS = :b1"$?1 $ P16_17_AUG_200412_30_49}Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D  ((!PP@MT$  ,4BTN_CANCEL_SELECTQ+0 ATTENTION> ISSUE_TITLE|BRS_MEDIA_TYPE_IDXBTN_FIND:ISSUE_ID|5ITEM104̧8$SHIP_ID;V_NUMBER09ITEM_IDT TXT_ADD_TYPE1TXT_ADDRESS_TYPEX2BTN_CANCEL_PICKt LOV_PICK_PERSON PS_PERSON_IDBTN_NEW_ADDRESS SHIPPING_DAYSPS_MEMBERSHIP_ID?(A|BC664:<A 15 m:m6;<} .+ md;m6<ا<} 5.4 n< n60><}2i.2n > n6?<<}2.2,n`?8n6@Ī <} .4 Dn@Pn6,B<}.8\nBdn6CX<}.2ln\Cn6$ElE D<<(.&E n n@nZC6 n2`F&? F&(AF&|B&\ G WrqqGqGGFF U$HH?(A|BC.,4H>>>>>@?D?`?????@@@@@(A0A4AHAAAAB|BBBBBB