ROS.60050 ) r
!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ GHIJKLMNOP RTUVWXYZ[\]^_ `Arial ,: b >p?p?p?0EFGHIJKLMNOP RTUVWXYZ[\]^_ `Arial ur b >p?p?p?0EFGHIJKLMNOP RTUVWXYZ[\]^_ `Arial -- ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [ ri di b >p?p?p?0EFGHIJKLMNOP RTUVWXYZ[\]^_ `Arial b >p?p?p?0EFGHIJKLMNOP RTUVWXYZ[\]^_ `Arial he c >p@p@p@0FGHIJKLMNOPQ RTU VXYZ[\]^_` aArial g s ] >p@p@pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [ r he c >p@p@p@0FGHIJKLMNOPQ RTU VXYZ[\]^_` a'Arial g o h >p@p@p@0LMNOPQRSTUVW XZ[\]^_`abcde f6Courier New h >p@p@p@0LMNOPQRSTUVW XZ[\]^_`abcde f9Courier New c >p@p@p@0FGHIJKLMNOPQ RTU VXYZ[\]^_` aHArial g , c >p@p@p@0FGHIJKLMNOPQ RTU VXYZ[\]^_` aPArial g ,
1p"&'*. /build_order_by _G 1p"&'*. /build_where by =p.236: ;initialize_parameters ( * , .
00r75g88b100 008x ( * , . $
00r88g88b100 208x * , . 0 ( 00r100g88b100 .08x & ( * ,
00custom5 .08x & ( * ,8g 00custom6 0 .08x & ( * ,0b 00custom7 0 .08x & ( * , 00custom8 $ ,08x $ & ( * D 00gray16
,08x $ & ( * 00gray12GGG ,08x $ & ( * 00gray8 ,08x $ & ( * 00gray4 -08x & (* + 00r0g100b0 &Ba /08x ( *, -0 00r25g100b0 @ y /08x ( *, -! 00r50g100b0 /08x ( *, - 00r75g100b0 /08x ( *, - 00r88g100b0 /08x ( *, -5g
00r100g100b0 .08x ' ( * ,b0 00r0g100b50 008x ( * , .
00r25g100b50@ 008x ( * , .
00r50g100b50 008x ( * , .@
00r75g100b50 008x ( * , .
00r88g100b50 208x * , . 0 00r100g100b50 , .08x ' ( * , 00r0g100b75 , 008x ( * , .
00r25g100b75@ 008x ( * , .
00r50g100b75 008x ( * , .
00r75g100b75 008x ( * , .
00r88g100b75 208x * , . 0 00r100g100b75 .08x ' ( * , 00r0g100b88 008x ( * , .
00r25g100b88@ 008x ( * , .
00r50g100b88 008x ( * , .
00r75g100b88 008x ( * , .
00r88g100b88 208x * , . 0 00r100g100b88 008x ( * , .
00r0g100b100 208x * , . 0 00r25g100b100 @ 00 208x * , . 08 00r50g100b100 5g75b100@ @ r 08op(vpz @z 08x0 0 P 0800p 0 ` 08 p 08trx_code P 080 `
j p rep_gen p
(0@ tu . bpdrs(vpzpz@z0~88x000000p0ppp
|B_description
0d $e ` 88 ` P 88 0 88 pd &00x $x A r25g25b88 *08x (
00r50g75b100 ,08x *0 00r75g100b100 @ ,p"&'*$ proc_filter ara u fphpqrs bpdrs(vpzpz8z@~88x000000p0pp6DECIMAL ILT x fphstuv A @ A @ # P_PASSWORD ` | fphwxyz000000p0ppp 0B_PAGE_NUMBER_SEC2 0P_CHAR_TO_DATE p | bpdop(vpz
. bpd hj(nprpr8r8t@vzB_trx_code 00 h FpH]^(bpfppp B_1
NUM R_G_confirmation_no1 {0
. bpdhi(jpnpn8n8p8r8tvwxx~000000p0ppp 0$B_2 " " $
d
`
K ` FpH_`(fpjpj0j0k@n8rtuvw0x0y0z0{0|0}~00p 8zaM_G_resv_name_id_GRPFR 0 0 FpH]^ `pbpb0b0c@f8jlmno0p0q0r0s0t0uv0w0xyz{|}~p cM_G_resv_name_id_HDR ` 0 8 FpHYZ(^pbpb0b8d@f8jlmno0p0q0r0s0t0uv0w0xyz{|}~p dR_G_resv_name_id R 0 ` R 0X 8 FpHbc(fpjpj8j8l@n8rtuvw0x0y0z0{0|0}~00p
kM_G_confirmation_no_GRPFR R0 b A3 h t1 FpH RT(Zp^p^8^8`@b8fh jlm0n0o0p0q0r0st0u0vwxyz{|}p~ ~ R_window rion_n0 { '
0# x$_codes tc1,
reservation_name rn1
where
ft1.resort = :p_resort
and ft1.resv_name_id = rn1.resv_name_id
and rn1.resort = :p_resort
and rn1.resv_status = 'CHECKED IN'
and tc1.resort = :p_resort
and tc1.tc_transaction_type = 'FC'
and ft1.trx_code = tc1.trx_code
and ft1.bill_no is null
order by ft1.room, ft1.folio_view ::FF\(b fjj(vzz((((pppppppp RUNONLY md_hrs_open_payments R " Le" " " " r="0" cellspacing="0" width="100%" L!
p"p"p"p"p"p"p"p"pJpJpJ J 0border="0" cellspacing="0" width="100%" \% .0 2(6:p; NPpQpSSTUpVpVVWXpYpYY Z$ 6(:CP_color = '1') 31 [[ \% .0 2(6:p; NPpQpSSTUpVpVVWXpYpYY Z$ 9 (:CP_color = '0') 30 [[ |}p~~pp000000pppppppp P_BUSINESS_DATE
P_BUSINESS_DATE 1 fphopqrstpzzp{p{{|}~000000pppppppp P_DATE E (
P_DATE 8 1 fphqrstuvpzzp{p{{|} ~000000pppppppp P_FILTER
P_FILTER 1 fphqrstuvpzzp{p{{|}~000000pppppppp P_FORMAT
P_FORMAT 00 208x * , . 0 00r25g100b100 @ 00 208x * , . 08 00r50g100b100 5g75b100@ x 0 r 88
5no0p0q0r8t8vx z0|0}~0ppppppqqrorrrrrrrrrrrrrre C a xv , | 2D:\MICROS\opera\Production\Customizable_Reports\template_portrait.tdf
MD_HRS_OPEN_PAYMENTS
B(F0JK@N@R@V@Z0^0_0`0a0b0cd0e0fgh0i0j0klmnopppp f @ @ P @ Report Parameters Enter values for the parameters lev $00x ! "eb black (00x " $ &"p white %00x " # green TED )00x# $& 'RS darkgreen ͫ (00x " $ & gray96
=
=
= (00x " $ & gray92zzz (00x " $ &T gray88 (00x " $ & gray84((( %00x !" # r0g0b0 (00x "$% &D_ r25g0b0 @ (00x "$% &
r50g0b0 (00x "$% &f8 r75g0b0 (00x "$% & r88g0b0 (00x "$% &
r100g0b0 (00x!" $ & r0g0b50 *00x "$ & ( r25g0b50@ *00x "$ & ( r50g0b50 @n *00x "$ & (0 r75g0b50 8z *00x "$ & ( r88g0b50 ,00x $& ( * r100g0b50 (00x!" $ &0x r0g0b75 *00x "$ & ( r25g0b75@ *00x "$ & (pH r50g0b75 l *00x "$ & (z r75g0b75 R_ *00x "$ & (R r88g0b75 ,00x $& ( *pj r100g0b75 (00x!" $ & r0g0b88 *00x "$ & ( r25g0b88@ *00x "$ & (T r50g0b88 l *00x "$ & (z r75g0b88 nd *00x "$ & ( 0 r88g0b88 ,00x $& ( *n_ r100g0b88 (00x"# $ &ft r0g0b100 ,00x $& ( *1. ! r25g0b100 @ ,00x $& ( *EC " r50g0b100 ,00x $& ( *.t # r75g0b100 ,00x $& ( * t $ r88g0b100 ,00x $& ( * f %
r100g0b100 &00x " $j & gray ( *00x " $ & (RU ' darkgray pe &00x " $ ( cyan r *00x" $ & (=" ) darkcyan w (00x " $ &p" * gray80333333 (00x " $ &ci + gray76=p=p=p (00x " $ &P , gray72GGG (00x " $ &:C - gray68QQQ '00x! "$ %(6 . r0g25b0 @ T )00x " $& ' / r25g25b0@ @ '0 )00x " $& 'p 0 r50g25b0 @ 0 )00x " $& ' 1 r75g25b0 @ )00x " $& ' 2 r88g25b0 @ +00x $ &( )_D 3 r100g25b0 @ h *00x" $ & (~ 4 r0g25b50 @ ,00x $ & ( * 5 r25g25b50 @ @ ,00x $ & ( *
6 r50g25b50 @ ,00x $ & ( *ph 7 r75g25b50 @ ,00x $ & ( * 8 r88g25b50 @ ,00x $ & ( * 9
r100g25b50@ *00x" $ & ( : r0g25b75 0@ ,00x $ & ( *z ; r25g25b75 @ @ ,00x $ & ( * < r50g25b75 @ ,00x $ & ( * = r75g25b75 @ ,00x $ & ( * > r88g25b75 @ ,00x $ & ( *5g ?
r100g25b75@ *00x" $ & ( @ r0g25b88 5@ 5g75b100@ @
r .hh , ROSATTRIBS class attributes +hh )&'ROSLFDESC ros lf descrip C )hh 'VWROSOBJMAP ros name->id qrs +hh )ROSSTRINGS tk2 uiStrings *hh (ROSSTRUCTS struct types *hh (ROSTK2RESV tk2 reserved hh SRW2_ACTION ( I hh SRW2_ANCHOR T &h!"h# $SRW2_BODY_LOCATION T $h h! "hSRW2_BOILERPLATE hh SRW2_BUTTON hh h SRW2_COLUMN Y #h h !h SRW2_DATA_MODEL $h h! ",:SRW2_DISPLAY_TAG %h !h" #'SRW2_DISTRIBUTION & @ h h $SRW2_ELEMENT hh SRW2_FIELD ) )h$%h& '_SSRW2_FORMAT_EXCEPTION % ( "h h NASRW2_FORMFIELD ' hh -SRW2_FRAME R_ hh SRW2_GROUP % #h h ! SRW2_GROUP_NODE " % "h h N SRW2_HYPERLINK ! $h h! "ORSRW2_JAVA_APPLET # (h#$h% &HSRW2_JAVA_PROPERTIES $ hh `SRW2_LAYOUT
%h !h" #heSRW2_LAYOUT_GROUP HI hh TSRW2_LINK \] hh SRW2_LISTS hh p@SRW2_MATRIX G 'h"#h$ %QSRW2_OGD_COLUMN_MAP r $h h! " SRW2_OG_DOCUMENT #h h !MSRW2_PARAM_FORM
Y hh ArSRW2_QUERY %h !h" #SRW2_TEXT_SEGMENT PQ h h \TOOL_COMMENT h h TOOL_LIBRARY hh p@TOOL_MODULE Q hh \TOOL_PLSQL d $pp " VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID @ T +pp $&'( )VG_COLOR CELLID @ -pp &()* +VG_COLOR NAME_SET @ PQ /pp (*+, -VG_COLOR NAME_LENGTH /pp (*+, -VG_COLOR COLOR_NAME x & 'pp "#$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE ete ( x & ( g Conf No % x #8 g Room + x ) g Guest Name ( ' x % g Window , x *st g Trans. Date * x (00 g
Trx. Code , x * g Description / x - g Payment Amount ' x % D g Filter
D x B ( g$ Page & of & 8 x 6K g Window &window balance: gray4 -08x & (* + 00r0g100b0 &Ba /08x ( *, -0 00r25g100b0 @ y /08x ( *, -! 00r50g100b0 /08x ( *, - 00r75g100b0 /08x ( *, - 00r88g100b0 /08x ( *, -5g
00r100g100b0 .08x ' ( * ,b0 00r0g100b50 008x ( * , .
00r25g100b50@ 008x ( * , .
00r50g100b50 008x ( * , .@
00r75g100b50 008x ( * , .
00r88g100b50 208x * , . 0 00r100g100b50 , .08x ' ( * , 00r0g100b75 , 008x ( * , .
00r25g100b75@ 008x ( * , .
00r50g100b75 008x ( * , .
00r75g100b75 008x ( * , .
00r88g100b75 208x * , . 0 00r100g100b75 .08x ' ( * , 00r0g100b88 008x ( * , .
00r25g100b88@ 008x ( * , .
00r50g100b88 008x ( * , .
00r75g100b88 008x ( * , .
00r88g100b88 208x * , . 0 00r100g100b88 008x ( * , .
00r0g100b100 208x * , . 0 00r25g100b100 @ 00 208x * , . 08 00r50g100b100 5g75b100@ P r 88 RIBS class attributes +hh )&'ROSLFDESC ros lf descrip C )hh 'VWROSOBJMAP ros name->id qrs +hh )ROSSTRINGS tk2 uiStrings *hh (ROSSTRUCTS struct types *hh (ROSTK2RESV tk2 reserved hh SRW2_ACTION ( I hh SRW2_ANCHOR T &h!"h# $SRW2_BODY_LOCATION T $h h! "hSRW2_BOILERPLATE hh SRW2_BUTTON hh h SRW2_COLUMN Y #h h !h SRW2_DATA_MODEL $h h! ",:SRW2_DISPLAY_TAG %h !h" #'SRW2_DISTRIBUTION & @ h h $SRW2_ELEMENT hh SRW2_FIELD ) )h$%h& '_SSRW2_FORMAT_EXCEPTION % ( "h h NASRW2_FORMFIELD ' hh -SRW2_FRAME R_ hh SRW2_GROUP % #h h ! SRW2_GROUP_NODE " % "h h N SRW2_HYPERLINK ! $h h! "ORSRW2_JAVA_APPLET # (h#$h% &HSRW2_JAVA_PROPERTIES $ hh `SRW2_LAYOUT
%h !h" #heSRW2_LAYOUT_GROUP HI hh TSRW2_LINK \] hh SRW2_LISTS hh p@SRW2_MATRIX G 'h"#h$ %QSRW2_OGD_COLUMN_MAP r $h h! " SRW2_OG_DOCUMENT #h h !MSRW2_PARAM_FORM
Y hh ArSRW2_QUERY %h !h" #SRW2_TEXT_SEGMENT PQ h h \TOOL_COMMENT h h TOOL_LIBRARY hh p@TOOL_MODULE Q hh \TOOL_PLSQL d $pp " VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID @ T +pp $&'( )VG_COLOR CELLID @ -pp &()* +VG_COLOR NAME_SET @ PQ /pp (*+, -VG_COLOR NAME_LENGTH /pp (*+, -VG_COLOR COLOR_NAME x & 'pp "#$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE ete ( x & ( g Conf No % x #8 g Room + x ) g Guest Name ( ' x % g Window , x *st g Trans. Date * x (00 g
Trx. Code , x * g Description / x - g Payment Amount ' x % D g Filter
D x B ( g$ Page & of & 8 x 6K g Window &window balance: gray4 -08x & (* + 00r0g100b0 &Ba /08x ( *, -0 00r25g100b0 @ y /08x ( *, -! 00r50g100b0 /08x ( *, - 00r75g100b0 /08x ( *, - 00r88g100b0 /08x ( *, -5g
00r100g100b0 .08x ' ( * ,b0 00r0g100b50 008x ( * , .
00r25g100b50@ 008x ( * , .
00r50g100b50 008x ( * , .@
00r75g100b50 008x ( * , .
00r88g100b50 208x * , . 0 00r100g100b50 , .08x ' ( * , 00r0g100b75 , 008x ( * , .
00r25g100b75@ 008x ( * , .
00r50g100b75 008x ( * , .
00r75g100b75 008x ( * , .
00r88g100b75 208x * , . 0 00r100g100b75 .08x ' ( * , 00r0g100b88 008x ( * , .
00r25g100b88@ 008x ( * , .
00r50g100b88 008x ( * , .
00r75g100b88 008x ( * , .
00r88g100b88 208x * , . 0 00r100g100b88 008x ( * , .
00r0g100b100 208x * , . 0 00r25g100b100 @ 00 208x * , . 08 00r50g100b100 5g75b100@ ` r 88 RIBS class attributes +hh )&'ROSLFDESC ros lf descrip C )hh 'VWROSOBJMAP ros name->id qrs +hh )ROSSTRINGS tk2 uiStrings *hh (ROSSTRUCTS struct types *hh (ROSTK2RESV tk2 reserved hh SRW2_ACTION ( I hh SRW2_ANCHOR T &h!"h# $SRW2_BODY_LOCATION T $h h! "hSRW2_BOILERPLATE hh SRW2_BUTTON hh h SRW2_COLUMN Y #h h !h SRW2_DATA_MODEL $h h! ",:SRW2_DISPLAY_TAG %h !h" #'SRW2_DISTRIBUTION & @ h h $SRW2_ELEMENT hh SRW2_FIELD ) )h$%h& '_SSRW2_FORMAT_EXCEPTION % ( "h h NASRW2_FORMFIELD ' hh -SRW2_FRAME R_ hh SRW2_GROUP % #h h ! SRW2_GROUP_NODE " % "h h N SRW2_HYPERLINK ! $h h! "ORSRW2_JAVA_APPLET # (h#$h% &HSRW2_JAVA_PROPERTIES $ hh `SRW2_LAYOUT
%h !h" #heSRW2_LAYOUT_GROUP HI hh TSRW2_LINK \] hh SRW2_LISTS hh p@SRW2_MATRIX G 'h"#h$ %QSRW2_OGD_COLUMN_MAP r $h h! " SRW2_OG_DOCUMENT #h h !MSRW2_PARAM_FORM
Y hh ArSRW2_QUERY %h !h" #SRW2_TEXT_SEGMENT PQ h h \TOOL_COMMENT h h TOOL_LIBRARY hh p@TOOL_MODULE Q hh \TOOL_PLSQL d $pp " VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID @ T +pp $&'( )VG_COLOR CELLID @ -pp &()* +VG_COLOR NAME_SET @ PQ /pp (*+, -VG_COLOR NAME_LENGTH /pp (*+, -VG_COLOR COLOR_NAME x & 'pp "#$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE ete ( x & ( g Conf No % x #8 g Room + x ) g Guest Name ( ' x % g Window , x *st g Trans. Date * x (00 g
Trx. Code , x * g Description / x - g Payment Amount ' x % D g Filter
D x B ( g$ Page & of & 8 x 6K g Window &window balance: gray4 -08x & (* + 00r0g100b0 &Ba /08x ( *, -0 00r25g100b0 @ y /08x ( *, -! 00r50g100b0 /08x ( *, - 00r75g100b0 /08x ( *, - 00r88g100b0 /08x ( *, -5g
00r100g100b0 .08x ' ( * ,b0 00r0g100b50 008x ( * , .
00r25g100b50@ 008x ( * , .
00r50g100b50 008x ( * , .@
00r75g100b50 008x ( * , .
00r88g100b50 208x * , . 0 00r100g100b50 , .08x ' ( * , 00r0g100b75 , 008x ( * , .
00r25g100b75@ 008x ( * , .
00r50g100b75 008x ( * , .
00r75g100b75 008x ( * , .
00r88g100b75 208x * , . 0 00r100g100b75 .08x ' ( * , 00r0g100b88 008x ( * , .
00r25g100b88@ 008x ( * , .
00r50g100b88 008x ( * , .
00r75g100b88 008x ( * , .
00r88g100b88 208x * , . 0 00r100g100b88 008x ( * , .
00r0g100b100 208x * , . 0 00r25g100b100 @ 00 208x * , . 08 00r50g100b100 5g75b100@ p h r b
Q(0@@80@@@@@@000000ppp 00880 !A
A11AAA A"A&A*1.1/A2A61:1;A>ABAFAJANAR1V1WXYZ[\]^_`d $e BD B d ` `
g d jj P L PB ` ` L PB ` `
R T &h!"h# $SRW2_BODY_LOCATION T $h h! "hSRW2_BOILERPLATE hh SRW2_BUTTON hh h SRW2_COLUMN Y #h h !h SRW2_DATA_MODEL $h h! ",:SRW2_DISPLAY_TAG %h !h" #'SRW2_DISTRIBUTION & @ h h $SRW2_ELEMENT hh SRW2_FIELD ) )h$%h& '_SSRW2_FORMAT_EXCEPTION % ( "h h NASRW2_FORMFIELD ' hh -SRW2_FRAME R_ hh SRW2_GROUP % #h h ! SRW2_GROUP_NODE " % "h h N SRW2_HYPERLINK ! $h h! "ORSRW2_JAVA_APPLET # (h#$h% &HSRW2_JAVA_PROPERTIES $ hh `SRW2_LAYOUT
%h !h" #heSRW2_LAYOUT_GROUP HI hh TSRW2_LINK \] hh SRW2_LISTS hh p@SRW2_MATRIX G 'h"#h$ %QSRW2_OGD_COLUMN_MAP r $h h! " SRW2_OG_DOCUMENT #h h !MSRW2_PARAM_FORM
Y hh ArSRW2_QUERY %h !h" #SRW2_TEXT_SEGMENT PQ h h \TOOL_COMMENT h h TOOL_LIBRARY hh p@TOOL_MODULE Q hh \TOOL_PLSQL d $pp " VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID @ T +pp $&'( )VG_COLOR CELLID @ -pp &()* +VG_COLOR NAME_SET @ PQ /pp (*+, -VG_COLOR NAME_LENGTH /pp (*+, -VG_COLOR COLOR_NAME x & 'pp "#$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE ete ( x & ( g Conf No % x #8 g Room + x ) g Guest Name ( ' x % g Window , x *st g Trans. Date * x (00 g
Trx. Code , x * g Description / x - g Payment Amount ' x % D g Filter
D x B ( g$ Page & of & 8 x 6K g Window &window balance: gray4 -08x & (* + 00r0g100b0 &Ba /08x ( *, -0 00r25g100b0 @ y /08x ( *, -! 00r50g100b0 /08x ( *, - 00r75g100b0 /08x ( *, - 00r88g100b0 /08x ( *, -5g
00r100g100b0 .08x ' ( * ,b0 00r0g100b50 008x ( * , .
00r25g100b50@ 008x ( * , .
00r50g100b50 008x ( * , .@
00r75g100b50 008x ( * , .
00r88g100b50 208x * , . 0 00r100g100b50 , .08x ' ( * , 00r0g100b75 , 008x ( * , .
00r25g100b75@ 008x ( * , .
00r50g100b75 008x ( * , .
00r75g100b75 008x ( * , .
00r88g100b75 208x * , . 0 00r100g100b75 .08x ' ( * , 00r0g100b88 008x ( * , .
00r25g100b88@ 008x ( * , .
00r50g100b88 008x ( * , .
00r75g100b88 008x ( * , .
00r88g100b88 208x * , . 0 00r100g100b88 008x ( * , .
00r0g100b100 208x * , . 0 00r25g100b100 @ 00 208x * , . 08 00r50g100b100 5g75b100@ r p rep_gen @80@@@@@@000000ppp 00880 !A
A11AAA A"A&A*1.1/A2A61:1;A>ABAFAJANAR1V1WXYZ[\]^_`d $e BD B d ` `
g d jj P L PB ` ` L PB ` `
R T &h!"h# $SRW2_BODY_LOCATION T $h h! "hSRW2_BOILERPLATE hh SRW2_BUTTON hh h SRW2_COLUMN Y #h h !h SRW2_DATA_MODEL $h h! ",:SRW2_DISPLAY_TAG %h !h" #'SRW2_DISTRIBUTION & @ h h $SRW2_ELEMENT hh SRW2_FIELD ) )h$%h& '_SSRW2_FORMAT_EXCEPTION % ( "h h NASRW2_FORMFIELD ' hh -SRW2_FRAME R_ hh SRW2_GROUP % #h h ! SRW2_GROUP_NODE " % "h h N SRW2_HYPERLINK ! $h h! "ORSRW2_JAVA_APPLET # (h#$h% &HSRW2_JAVA_PROPERTIES $ hh `SRW2_LAYOUT
%h !h" #heSRW2_LAYOUT_GROUP HI hh TSRW2_LINK \] hh SRW2_LISTS hh p@SRW2_MATRIX G 'h"#h$ %QSRW2_OGD_COLUMN_MAP r $h h! " SRW2_OG_DOCUMENT #h h !MSRW2_PARAM_FORM
Y hh ArSRW2_QUERY %h !h" #SRW2_TEXT_SEGMENT PQ h h \TOOL_COMMENT h h TOOL_LIBRARY hh p@TOOL_MODULE Q hh \TOOL_PLSQL d $pp " VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID @ T +pp $&'( )VG_COLOR CELLID @ -pp &()* +VG_COLOR NAME_SET @ PQ /pp (*+, -VG_COLOR NAME_LENGTH /pp (*+, -VG_COLOR COLOR_NAME x & 'pp "#$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE ete ( x & ( g Conf No % x #8 g Room + x ) g Guest Name ( ' x % g Window , x *st g Trans. Date * x (00 g
Trx. Code , x * g Description / x - g Payment Amount ' x % D g Filter
D x B ( g$ Page & of & 8 x 6K g Window &window balance: gray4 -08x & (* + 00r0g100b0 &Ba /08x ( *, -0 00r25g100b0 @ y /08x ( *, -! 00r50g100b0 /08x ( *, - 00r75g100b0 /08x ( *, - 00r88g100b0 /08x ( *, -5g
00r100g100b0 .08x ' ( * ,b0 00r0g100b50 008x ( * , .
00r25g100b50@ 008x ( * , .
00r50g100b50 008x ( * , .@
00r75g100b50 008x ( * , .
00r88g100b50 208x * , . 0 00r100g100b50 , .08x ' ( * , 00r0g100b75 , 008x ( * , .
00r25g100b75@ 008x ( * , .
00r50g100b75 008x ( * , .
00r75g100b75 008x ( * , .
00r88g100b75 208x * , . 0 00r100g100b75 .08x ' ( * , 00r0g100b88 008x ( * , .
00r25g100b88@ 008x ( * , .
00r50g100b88 008x ( * , .
00r75g100b88 008x ( * , .
00r88g100b88 208x * , . 0 00r100g100b88 008x ( * , .
00r0g100b100 208x * , . 0 00r25g100b100 @ 00 208x * , . 08 00r50g100b100 5g75b100@ d r ]0808[ E E
Oracle HTML Navigator
$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE ete ( x & ( g Conf No % x #8 g Room + x ) g Guest Name ( ' x % g Window , x *st g Trans. Date * x (00 g
Trx. Code , x * g Description / x - g Payment Amount ' x % D g Filter
D x B ( g$ Page & of & 8 x 6K g Window &window balance: gray4 -08x & (* + 00r0g100b0 &Ba /08x ( *, -0 00r25g100b0 @ y /08x ( *, -! 00r50g100b0 /08x ( *, - 00r75g100b0 /08x ( *, - 00r88g100b0 /08x ( *, -5g
00r100g100b0 .08x ' ( * ,b0 00r0g100b50 008x ( * , .
00r25g100b50@ 008x ( * , .
00r50g100b50 008x ( * , .@
00r75g100b50 008x ( * , .
00r88g100b50 208x * , . 0 00r100g100b50 , .08x ' ( * , 00r0g100b75 , 008x ( * , .
00r25g100b75@ 008x ( * , .
00r50g100b75 008x ( * , .
00r75g100b75 008x ( * , .
00r88g100b75 208x * , . 0 00r100g100b75 .08x ' ( * , 00r0g100b88 008x ( * , .
00r25g100b88@ 008x ( * , .
00r50g100b88 008x ( * , .
00r75g100b88 008x ( * , .
00r88g100b88 208x * , . 0 00r100g100b88 008x ( * , .
00r0g100b100 208x * , . 0 00r25g100b100 @ 00 208x * , . 08 00r50g100b100 5g75b100@ l <%@ taglib uri="/WEB-INF/lib/reports_tld.jar" prefix="rw" %>
<%@ page language="java" import="java.io.*" errorPage="/rwerror.jsp" session="false" %>
<%@ page contentType="text/html;charset=ISO-8859-1" %>
Your Title
class="OraColumnHeader"> Resv Name Id
class="OraColumnHeader"> Confirmation No
class="OraColumnHeader"> Room
class="OraColumnHeader"> Guest Name
class="OraColumnHeader"> Window
class="OraColumnHeader"> Trx Date
class="OraColumnHeader"> Trx Code
class="OraColumnHeader"> Description
class="OraColumnHeader"> Trx Amount
class="OraRowHeader"> F_resv_name_id
class="OraCellText"> F_confirmation_no
class="OraCellText"> F_room
class="OraCellText"> F_guest_name
class="OraCellNumber"> F_window
class="OraCellText"> F_trx_date
class="OraCellText"> F_trx_code
class="OraCellText"> F_description
class="OraCellNumber"> F_trx_amount
#,5>BEKTX[ajpqrxyz{ ()*;@JKLRSTUVW]^_`aghi h U k k . k . k n . n . k n . n . r ,00x $ & ( *E A r25g25b88 @ @ ,00x $ & ( *EA B r50g25b88 @ ,00x $ & ( *in C r75g25b88 @ ,00x $ & ( * & D r88g25b88 @ ,00x $ & ( *fi E
r100g25b88@ *00x# $ & (il F r0g25b100 @ ,00x $ & ( * t G
r25g25b100@ @ ,00x $ & ( *ge H
r50g25b100 @ ,00x $ & ( *am I
r75g25b100 @ ,00x $ & ( * + J
r88g25b100 @ .00x & ( * ,on K r100g25b100 @ e $00x ! "if L red (00x "$% & n M darkred $00x "wa N blue (00x"# $ &{
O darkblue (00x " $ &p_ P gray64\(\(\( (00x " $ &w_ Q gray60ffffff (00x " $ &st R gray56ppp (00x " $ &nd S gray52zzz '00x! "$ %or T r0g50b0
)00x " $& '/
U r25g50b0@ m)
)00x " $& 'ge V r50g50b0 x = )00x " $& 'm, W r75g50b0 }
)00x " $& 'd X r88g50b0 nct +00x $ &( )ni Y r100g50b0 r *00x" $ & (fo Z r0g50b50 1 ,00x $ & ( *ue [ r25g50b50 @ ,00x $ & ( *ge \ r50g50b50 ,00x $ & ( *ag ] r75g50b50 ,00x $ & ( *Y> ^ r88g50b50 ,00x $ & ( *; _
r100g50b50 *00x" $ & (T ` r0g50b75 0 UE ,00x $ & ( *.f a r25g50b75 @ ,00x $ & ( *on b r50g50b75 ,00x $ & ( *to c r75g50b75 ,00x $ & ( *>
d r88g50b75 ,00x $ & ( *td e
r100g50b75 *00x" $ & (or f r0g50b88 5 p?p?p?0GHIJKLMNOPQR TVWXYZ[\]^_`a bCourier ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [ ou b >p?p?p?0EFGHIJKLMNOP RTUVWXYZ[\]^_ `Arial b >p?p?p?0EFGHIJKLMNOP RTUVWXYZ[\]^_ `Arial b >p?p?p?0EFGHIJKLMNOP RTUVWXYZ[\]^_ `Arial * b >p?p?p?0EFGHIJKLMNOP RTUVWXYZ[\]^_ `Arial * ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [ ri ( b >p?p?p?0EFGHIJKLMNOP RTUVWXYZ[\]^_ `Arial ( b >p?p?p?0EFGHIJKLMNOP RTUVWXYZ[\]^_ `Arial ( c >p@p@p@0FGHIJKLMNOPQ RTU VXYZ[\]^_` aArial g ( ] >p@p@pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [ r c >p@p@p@0FGHIJKLMNOPQ RTU VXYZ[\]^_` a'Arial g h >p@p@p@0LMNOPQRSTUVW XZ[\]^_`abcde f6Courier New h >p@p@p@0LMNOPQRSTUVW XZ[\]^_`abcde f9Courier New c >p@p@p@0FGHIJKLMNOPQ RTU VXYZ[\]^_` aHArial g , c >p@p@p@0FGHIJKLMNOPQ RTU VXYZ[\]^_` aPArial g , 1p"&'*. /build_order_by , 1p"&'*. /build_where by =p.236: ;initialize_parameters 0 008x ( * , .
00r75g88b100 008x ( * , . $
00r88g88b100 208x * , . 0 ( 00r100g88b100 .08x & ( * ,
00custom5 .08x & ( * ,8g 00custom6 0 .08x & ( * ,0b 00custom7 0 .08x & ( * , 00custom8 $ ,08x $ & ( * D 00gray16
,08x $ & ( * 00gray12GGG ,08x $ & ( * 00gray8 ,08x $ & ( * 00gray4 -08x & (* + 00r0g100b0 &Ba /08x ( *, -0 00r25g100b0 @ y /08x ( *, -! 00r50g100b0 /08x ( *, - 00r75g100b0 /08x ( *, - 00r88g100b0 /08x ( *, -5g
00r100g100b0 .08x ' ( * ,b0 00r0g100b50 008x ( * , .
00r25g100b50@ 008x ( * , .
00r50g100b50 008x ( * , .@
00r75g100b50 008x ( * , .
00r88g100b50 208x * , . 0 00r100g100b50 , .08x ' ( * , 00r0g100b75 , 008x ( * , .
00r25g100b75@ 008x ( * , .
00r50g100b75 008x ( * , .
00r75g100b75 008x ( * , .
00r88g100b75 208x * , . 0 00r100g100b75 .08x ' ( * , 00r0g100b88 008x ( * , .
00r25g100b88@ 008x ( * , .
00r50g100b88 008x ( * , .
00r75g100b88 008x ( * , .
00r88g100b88 208x * , . 0 00r100g100b88 008x ( * , .
00r0g100b100 208x * , . 0 00r25g100b100 @ 00 208x * , . 08 00r50g100b100 5g75b100@ $ r 1 fphpqrstupvvpwpwwxyz{0|0}0~000pppppppp 6DECIMAL Decimal Indicator 1 fphrstuvwpzzp{p{{|}~000000pppppppp 7THOUSANDS
Thousands Indicator 1 fphqrstuvpzzp{p{{|} ~000000pppppppp 8CURRENCY Currency Symbol \ 1 fphopqrstpzzp{p}}~000000pppppppp 9COPIES 1 Number of Copies L 1 fphrstuvwpzzp{p 000000pppppppp :DESFORMAT dflt Destination Format ? 1 fphpqrstupvvpwpwwxy z|0}0~0000pppppppp ;DESNAME Destination Name 1 fphpqrstupvvpwp~~000000pppppppp h U O
<
< e v plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"plscope_settings" 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H
@ T 8 BUILD_ORDER_BY $ "BUILD_ORDER_BY"#980980e97e42f8ec #1 2 @ @ N E % NpP \^(bpfpf@f8j8l8npqrstuvwx0y0z0{p|p~0~pp F_trx_code1 ''0 | RR % NpP \^(bpfpf8f8h8j8lnopqrstuv0w0x0ypzp0pp F_trx_date1 ''0 ~P y D DD.MM.RRRR % NpP Z\(bpfpf8f8h8j8lnopqrstuv0w0x0ypzpz0z{|}~pp F_window1 ''0 j v D % NpP ^`(fpjpj8j8l8n8prstuvwxyz0{0|0}p~p~0~pp F_guest_name1 ' 00 (0@t s 1 % NpP XZ(^pbpb8b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|}~pp F_room1 'e1 0 p nd % NpP ^`(fpjpj8j8l8n8prstuv xz{|0}0~0pp0pp F_win_balance H0 ;/ S C $ NNNGNNNGNN0.00 J!
p p p p p p p p pHpHpH H border="0" cellspacing="0" width="100%" ph J!
p p p p p p p p pHpHpH H border="0" cellspacing="0" width="100%" J!
p p p p p p p p pHpHpH H border="0" cellspacing="0" width="100%" J!
p p p p p p p p pHpHpH H border="0" cellspacing="0" width="100%" L!
p"p"p"p"p"p"p"p"pJpJpJ J $border="0" cellspacing="0" width="100%" L!
p"p"p"p"p"p"p"p"pJpJpJ J 0border="0" cellspacing="0" width="100%" \% .0 2(6:p; NPpQpSSTUpVpVVWXpYpYY Z$ 6(:CP_color = '1') 31 [[ \% .0 2(6:p; NPpQpSSTUpVpVVWXpYpYY Z$ 9 (:CP_color = '0') 30 [[ |}p~~pp000000pppppppp P_BUSINESS_DATE
P_BUSINESS_DATE 1 fphopqrstpzzp{p{{|}~000000pppppppp P_DATE E (
P_DATE 8 1 fphqrstuvpzzp{p{{|} ~000000pppppppp P_FILTER
P_FILTER 1 fphqrstuvpzzp{p{{|}~000000pppppppp P_FORMAT
P_FORMAT 00 208x * , . 0 00r25g100b100 @ 00 208x * , . 08 00r50g100b100 5g75b100@ l 1
$" %g INITIALIZE_PARAMETERS initialize_parameters % ͫͫͫͫͫͫͫ xj SYS STANDARD p << OPERA DUAL
xp - PUBLIC DUAL xp - SYS DUAL PMS_P
xu ( OPERA PMS_P xu ! OPERA RESORT $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 J J $ "INITIALIZE_PARAMETERS""$F0"$F1"$F2"$F3"":P_DATE":P_TIME":P_ROOM_CLASS_YN":P_FORMAT":P_RESORT_NAME":P_RESORT":P_FROM_DATE":P_TO_DATE":P_CHAR_FROM_DATE":P_CHAR_TO_DATE"" ! ' + - 1 7 ; A E K O S Y \ b f g i m q w { | ~
!
g P g x?
( gp@ ! # ' $ % & g@ ! "
# * A ! ) - 1 . / 0 gHA ! , 4 8 5 6 7 d gA ! 3
; B ! : > ? xB ! = > B B ! A #
E B ! D # H B ! G
" ) , 3 : = A D G
! ( + 2 9 < @ C F I $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 x ) j { ) e 8 . e Y N e e Y N e e
{
3 ) e 3 ) e A A e e A A e e A A e e A A e e A A e e A A e e A A e e A A e e e e A A e A A e A A e A A e e e e e e e e e e e ` "INITIALIZE_PARAMETERS"C590A038B364ED539F6C3DB1F7E17411"TO_CHAR"PMS_P"BUSINESS_DATE"DATE_FORMAT"SYSDATE"TIME_FORMAT"NVL"GET_PARAMETER"ROOMCLASS_YN"N"AMOUNT_FORMAT"NNNNNNNNNNN0.00"P_DATE""P_TIME"P_ROOM_CLASS_YN"P_FORMAT"DUAL"NAME"P_RESORT_NAME"RESORT"R"P_RESORT"="P_FROM_DATE"IS NULL"P_TO_DATE"<"P_CHAR_FROM_DATE"P_CHAR_TO_DATE"40"20"30"100"12"1"13"15""
- 1 2 4 7 ; ? B F J M N T W [ _ c f g m q u y | $(,./6:>AHOSTZ[aefkry}~ #'+./59;?DKRVW]dgnrvyz
#,5>BEKTX[ajpqrxyz{ ()*;@JKLRSTUVW]^_`aghi h U k k . k . k n . n . k n . n . k | . | . k
< | . | . R
< | . k .
< | . k .
< Q c Q c Q c Q c Q c Q c Q c Q c . . . . Q c Q c Q c Q c ` ` . . .
0 l
( . .
" "
# 4
# 5
. .
( & & & 5 - 3 3 ) / / . .
" "
# # # 4 4 4
# # # 5 5 5
& 3 3 / / P ! /
# $
% ' " * . 0 2 4 6 8 : ; , 7 9 @ A B ! D M N F G J # K L P Q > E & O T ( U V T ! Y Z X ] * ^ W ] _ , a " . b c # a T $ 0 g h % d j i & a T l m o 3 p k o q 5 s ' 7 t u ( s ) T * + z { 9 x } , w ~ < v >
- @ .
/ a 0 1 B 2 E G I ! g ! 3( 4 56 g " 7 8 9: g " ; < => g # ? @ AB g $ Cd D EF g ! G( H IJ KL MN g " O P QR g " S T UV W X [ Y Z ^ % [ \ ]^ a & _ ` ab c ' c
d ef f ( g h ij h s 9 k l k m n m o p ! o q r + q x } O s t= { [ u | v w & ( ) ! + 5 - / 1 3 = C H I ? S \ ^ ` e f n p r y < R _ q
. 0 2 4 @ J T a s & ( ) H I S ` e f r y V e 0 J . a T s 2 @ 4 v plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"plscope_settings" 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H e L T f (k g VN N N N V u u u
u k g t N V _ "
! _ " \ >r g x ! ?! _ " X B_ _ ??_ x ! ?! _
" 8 d_ r g ? u ! ?_ r g ?
u
8 0 pp @ @ l
DATE_FORMAT PMS_P BUSINESS_DATE ( INITIALIZE_PARAMETERS 2( 8C + "INITIALIZE_PARAMETERS"#980980e97e42f8ec #1
0 xu (
PMS_POPERABUSINESS_DATE PMS_P 0 xu ( PMS_POPERADATE_FORMAT PMS_P
D D D D
A 0 0 0 0 X @ @ H D ( X A A @
2 .* SELECT TO_CHAR (PMS_P.BUSINESS_DATE , PMS_P.DATE_FORMAT ) , TO_CHAR (SYSDATE , PMS_P.TIME_FORMAT ) , NVL(PMS_P.GET_PARAMETER(''ROOMCLASS_YN'' ) , ''N'' ) , NVL(PMS_P.GET_PARAMETER(''AMOUNT_FORMAT'' ) , ''NNNNNNNNNNN0.00'' ) FROM DUAL "SELECT NAME FROM RESORT R WHERE R.RESORT = :b1 " e P X 0 ` H h ` p x x g g
g
@ @ ( B @
D 0
A A D @ A $ F
$ 8 SELECT TO_DATE (:b1 , PMS_P.DATE_FORMAT ) FROM DUAL "SELECT PMS_P.DATE_FORMAT FROM DUAL " s P X 0 ` H h ` p x x g
@ @ P L r "0808
1
$
g BUILD_WHERE build_where ) ͫͫͫͫͫͫͫ $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 "BUILD_WHERE"" N $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8
O / "BUILD_WHERE"F8B72CFA4A25EB4D4BAADC4B98DC16BF""
- 1 2 4 6 8 < > h U O
e v plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"plscope_settings" 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H
@ T 8 BUILD_WHERE ! "BUILD_WHERE"#980980e97e42f8ec #2 @ @ 0800 % @
d
`
K ` FpH_`(fpjpj0j0k@n8rtuvw0x0y0z0{0|0}~00p 8zaM_G_resv_name_id_GRPFR 0 0 FpH]^ `pbpb0b0c@f8jlmno0p0q0r0s0t0uv0w0xyz{|}~p cM_G_resv_name_id_HDR ` 0 8 FpHYZ(^pbpb0b8d@f8jlmno0p0q0r0s0t0uv0w0xyz{|}~p dR_G_resv_name_id R 0 ` R 0X 8 FpHbc(fpjpj8j8l@n8rtuvw0x0y0z0{0|0}~00p
kM_G_confirmation_no_GRPFR R0 b A3 h t1 FpH RT(Zp^p^8^8`@b8fh jlm0n0o0p0q0r0st0u0vwxyz{|}p~ ~ R_window rion_n0 { '
0# x$_codes tc1,
reservation_name rn1
where
ft1.resort = :p_resort
and ft1.resv_name_id = rn1.resv_name_id
and rn1.resort = :p_resort
and rn1.resv_status = 'CHECKED IN'
and tc1.resort = :p_resort
and tc1.tc_transaction_type = 'FC'
and ft1.trx_code = tc1.trx_code
and ft1.bill_no is null
order by ft1.room, ft1.folio_view ::FF\(b fjj(vzz((((pppppppp RUNONLY md_hrs_open_payments R " Le" " " " r="0" cellspacing="0" width="100%" L!
p"p"p"p"p"p"p"p"pJpJpJ J 0border="0" cellspacing="0" width="100%" \% .0 2(6:p; NPpQpSSTUpVpVVWXpYpYY Z$ 6(:CP_color = '1') 31 [[ \% .0 2(6:p; NPpQpSSTUpVpVVWXpYpYY Z$ 9 (:CP_color = '0') 30 [[ |}p~~pp000000pppppppp P_BUSINESS_DATE
P_BUSINESS_DATE 1 fphopqrstpzzp{p{{|}~000000pppppppp P_DATE E (
P_DATE 8 1 fphqrstuvpzzp{p{{|} ~000000pppppppp P_FILTER
P_FILTER 1 fphqrstuvpzzp{p{{|}~000000pppppppp P_FORMAT
P_FORMAT 00 208x * , . 0 00r25g100b100 @ 00 208x * , . 08 00r50g100b100 5g75b100@ ` ( r "0808
1
$
g PROC_FILTER proc_filter ) ͫͫͫͫͫͫͫ $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 "PROC_FILTER"" N $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8
O / "PROC_FILTER"F8B72CFA4A25EB4D4BAADC4B98DC16BF""
- 1 2 4 6 8 < > h U O
e v plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"plscope_settings" 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H
@ T 8 PROC_FILTER ! "PROC_FILTER"#980980e97e42f8ec #1 @ @ r100g0b0 (00x!" $ & r0g0b50 *00x "$ & ( r25g0b50@ *00x "$ & ( r50g0b50 @n *00x "$ & (0 r75g0b50 8z *00x "$ & ( r88g0b50 ,00x $& ( * r100g0b50 (00x!" $ &0x r0g0b75 *00x "$ & ( r25g0b75@ *00x "$ & (pH r50g0b75 l *00x "$ & (z r75g0b75 R_ *00x "$ & (R r88g0b75 ,00x $& ( *pj r100g0b75 (00x!" $ & r0g0b88 *00x "$ & ( r25g0b88@ *00x "$ & (T r50g0b88 l *00x "$ & (z r75g0b88 nd *00x "$ & ( 0 r88g0b88 ,00x $& ( *n_ r100g0b88 (00x"# $ &ft r0g0b100 ,00x $& ( *1. ! r25g0b100 @ ,00x $& ( *EC " r50g0b100 ,00x $& ( *.t # r75g0b100 ,00x $& ( * t $ r88g0b100 ,00x $& ( * f %
r100g0b100 &00x " $j & gray ( *00x " $ & (RU ' darkgray pe &00x " $ ( cyan r *00x" $ & (=" ) darkcyan w (00x " $ &p" * gray80333333 (00x " $ &ci + gray76=p=p=p (00x " $ &P , gray72GGG (00x " $ &:C - gray68QQQ '00x! "$ %(6 . r0g25b0 @ T )00x " $& ' / r25g25b0@ @ '0 )00x " $& 'p 0 r50g25b0 @ 0 )00x " $& ' 1 r75g25b0 @ )00x " $& ' 2 r88g25b0 @ +00x $ &( )_D 3 r100g25b0 @ h *00x" $ & (~ 4 r0g25b50 @ ,00x $ & ( * 5 r25g25b50 @ @ ,00x $ & ( *
6 r50g25b50 @ ,00x $ & ( *ph 7 r75g25b50 @ ,00x $ & ( * 8 r88g25b50 @ ,00x $ & ( * 9
r100g25b50@ *00x" $ & ( : r0g25b75 0@ ,00x $ & ( *z ; r25g25b75 @ @ ,00x $ & ( * < r50g25b75 @ ,00x $ & ( * = r75g25b75 @ ,00x $ & ( * > r88g25b75 @ ,00x $ & ( *5g ?
r100g25b75@ *00x" $ & ( @ r0g25b88 5@ 5g75b100@ p l 1
$" g P_CHAR_FROM_DATEVALIDTRIGGER p_char_from_datevalidtrigger 0 ͫͫͫͫͫͫͫ xj SYS STANDARD p << OPERA DUAL
xp - PUBLIC DUAL xp - SYS DUAL PMS_P
xu ( OPERA PMS_P SRW $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 % % "P_CHAR_FROM_DATEVALIDTRIGGER"MESS_FORMAT""$F0"":P_CHAR_FROM_DATE":P_FROM_DATE"_return"" " # % ) / 2 8 < > B F L O U V Z ^ d h i k o s y }
g(
g h
g # $
" ! $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 / z z z z # L A e F
* ) ) , A @ e
A A e e A e e e e A A e "P_CHAR_FROM_DATEVALIDTRIGGER"B73B12DF826918465DFEF8A39AD23659"BOOLEAN"MESS_FORMAT"CHAR"20"P_CHAR_FROM_DATE""IS NOT NULL"P_FROM_DATE"IS NULL"TO_DATE"PMS_P"DATE_FORMAT"DUAL"TRUE"SRW"MESSAGE"911"Invalid from date. The format is "||"FALSE"33""
- 1 2 6 8 B F I R W X _ f j k q x
$()/06:=BDEJN_aehmosw|~!" h , Q | . | .
k . Z e S k k Q n | . W Z e Z e < Q c c . ` . ` Q c
. * * * * * ( . .
< > @
* . . 4 ] ] /
c c \ a a d
b
b e
Q a
! i
b & ( Q * + j # ' ) 0 - . Q 0 Q
2 3 8 : Q < = q 5 9 ; M ? @ w D F x A H y M J K Q M ! O % N M P ' Q W Q 0 P ] W R ) W S T ] V + X R ] Y V ] Y - Z 0 ] ] ] 2 ] \ Z [ g _ ` !` ^ "# $ 7 9 g % h ; @ ) m & ' " > 4 o ( p D ; t ) * n B +! u , v -.v F I f " % $ , / n 7 6 C E B G > I L 1 O Q U W X Y
f l k s r C E B G . e v plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"p l lscope_settings" 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H s P T Hf H _ "
_ "
k g f N V @ x } k g |N V u 1 t c } . } pp @
Invalid from date. The format is 0 P_CHAR_FROM_DATEVALIDTRIGGER
* 6 0$ 8
8 2 "P_CHAR_FROM_DATEVALIDTRIGGER"#3e4672a427273418 #1
( B @
D 0
A A D @ A $ F
$ 8 SELECT TO_DATE (:b1 , PMS_P.DATE_FORMAT ) FROM DUAL "SELECT PMS_P.DATE_FORMAT FROM DUAL " s P X 0 ` H h ` p x x ! g @ @ ͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 # "AFTERPFORM"_return"" t & $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 $ x "AFTERPFORM"B73B12DF826918465DFEF8A39AD23659"BOOLEAN"INITIALIZE_PARAMETERS"BUILD_WHERE"BUILD_ORDER_BY"PROC_FILTER"TRUE"" ,
- 1 2 6 8 < B C G M N R X Y ] c d h k p r v x h , W W W W Z e
/
e v plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"plscope_settings" 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H ( ( H X T } ( p 8
AFTERPFORM "AFTERPFORM"#3e4672a427273418 #1 @ @ @ ""\ "\
00
. $ ! *
"0 $ "4 $(
" $BP0
"< & 0 . "1 Y Z 4 E F . SE l 1
$" g P_CHAR_TO_DATEVALIDTRIGGER p_char_to_datevalidtrigger ͫͫͫͫͫͫͫ xj SYS STANDARD p << OPERA DUAL
xp - PUBLIC DUAL xp - SYS DUAL PMS_P
xu ( OPERA PMS_P SRW $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 % % "P_CHAR_TO_DATEVALIDTRIGGER"MESS_FORMAT""$F0"":P_CHAR_TO_DATE":P_TO_DATE"_return"" " # % ) / 2 8 < > B F L O U V Z ^ d h i k o s y }
g(
g h
g
# $
" ! $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 / z z z z # L A e F
* ) ) , A @ e
A A e e A e e e e A A e "P_CHAR_TO_DATEVALIDTRIGGER"B73B12DF826918465DFEF8A39AD23659"BOOLEAN"MESS_FORMAT"CHAR"20"P_CHAR_TO_DATE""IS NOT NULL"P_TO_DATE"IS NULL"TO_DATE"PMS_P"DATE_FORMAT"DUAL"TRUE"SRW"MESSAGE"911"Invalid to date. The format is "||"FALSE"31""
- 1 2 6 8 B F I R W X _ f j k q x
$()/06:=BDEJN_aehmosw|~!" h , Q | . | .
k . Z e S k k Q n | . W Z e Z e < Q c c . ` . ` Q c
, ' ' ' ' ' & , ,
: < :
' , , 4 ] ] /
c c \ a
a
d
b
b e
Q a
! i
b & ( Q * + j # ' ) 0 - . Q 0 Q
2 3 8 : Q < = q 5 9 ; M ? @ w D F x A H y M J K Q M ! O % N M P ' Q W Q 0 P ] W R ) W S T ] V + X R ] Y V ] Y - Z 0 ] ] ] 2 ] \ Z [ g _ ` !` ^ "# $ 7 9 g % h ; @ ) m & ' " > 4 o ( p D ; t ) * n B + u , v -.v F I f " % $ , / n 7 6 C E B G > I L 1 O Q U W X Y
f l k s r C E B G . e v plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"plscope_settings" l 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H s H T @f @ _
"
_ "
k g d N
V @ x } k g zN V u 1 t c } . } pp @
Invalid to date. The format is 0 P_CHAR_TO_DATEVALIDTRIGGER
* $6 0 8
0 0 "P_CHAR_TO_DATEVALIDTRIGGER"#3e4672a427273418 #1
( B @
D 0
A A D @ A $ F
$ 8 SELECT TO_DATE (:b1 , PMS_P.DATE_FORMAT ) FROM DUAL "SELECT PMS_P.DATE_FORMAT FROM DUAL " s P X 0 ` H h ` p x x g
@ @
g
e
v plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"plscope_settings" 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H 0 0 0 P T f _ "
} } h 0 ( ` 8 0 B_FILTER_SEC2FORMATTRIGGER 0 "B_FILTER_SEC2FORMATTRIGGER"#3e4672a427273418 #1 D 8 @ H @ @ 00x " $ & w gray44\\\( 00x " $ & x gray40( 00x " $ & y gray36ףףף' 00x!" $% z r0g75b0 ) 00x" $ &' { r25g75b0 @ ) 00x" $ &' | r50g75b0 ) 00x" $ &' } r75g75b0 ) 00x" $ &' ~ r88g75b0 + 00x$ & () r100g75b0 . 08 x&( * , 00r0g75b50 0 08 x( * , . 00r25g75b50 @ 0 08 x( * , . 00r50g75b50 0 08 x( * , . 00r75g75b50 0 08 x( * , . 00r88g75b50 0 08 x( * , .
00r100g75b50 . 08 x&( * , 00r0g75b75 0 0 08 x( * , . 00r25g75b75 @ 0 08 x( * , . 00r50g75b75 0 08 x( * , . 00r75g75b75 0 08 x( * , . 00r88g75b75 0 08 x( * , .
00r100g75b75 . 08 x&( * , 00r0g75b88 5 0 08 x( * , . 00r25g75b88 @ 0 08 x( * , . 00r50g75b88 0 08 x( * , . 00r75g75b88 0 08 x( * , . 00r88g75b88 0 08 x( * , .
00r100g75b88 . 08 x'( * , 00r0g75b100 0 08 x( * , .
00r25g75b100 @ 0 08 x( * , .
00r50g75b100 8
| r 00808. 1
$ g TEMPLATE_HINTS template_hints ) ͫͫͫͫͫͫͫ $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 "TEMPLATE_HINTS"" N # $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8
O 2 "TEMPLATE_HINTS"F8B72CFA4A25EB4D4BAADC4B98DC16BF""
- 1 2 4 6 8 < > h U O #
# e v plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"plscope_settings" 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H
@ T 8 TEMPLATE_HINTS $ "TEMPLATE_HINTS"#980980e97e42f8ec #2 @ @ 0800 p 0800 T +pp $&'( )VG_COLOR CELLID @ -pp &()* +VG_COLOR NAME_SET @ PQ /pp (*+, -VG_COLOR NAME_LENGTH /pp (*+, -VG_COLOR COLOR_NAME x & 'pp "#$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE ete ( x & ( g Conf No % x #8 g Room + x ) g Guest Name ( ' x % g Window , x *st g Trans. Date * x (00 g
Trx. Code , x * g Description / x - g Payment Amount ' x % D g Filter
D x B ( g$ Page & of & 8 x 6K g Window &window balance: gray4 -08x & (* + 00r0g100b0 &Ba /08x ( *, -0 00r25g100b0 @ y /08x ( *, -! 00r50g100b0 /08x ( *, - 00r75g100b0 /08x ( *, - 00r88g100b0 /08x ( *, -5g
00r100g100b0 .08x ' ( * ,b0 00r0g100b50 008x ( * , .
00r25g100b50@ 008x ( * , .
00r50g100b50 008x ( * , .@
00r75g100b50 008x ( * , .
00r88g100b50 208x * , . 0 00r100g100b50 , .08x ' ( * , 00r0g100b75 , 008x ( * , .
00r25g100b75@ 008x ( * , .
00r50g100b75 008x ( * , .
00r75g100b75 008x ( * , .
00r88g100b75 208x * , . 0 00r100g100b75 .08x ' ( * , 00r0g100b88 008x ( * , .
00r25g100b88@ 008x ( * , .
00r50g100b88 008x ( * , .
00r75g100b88 008x ( * , .
00r88g100b88 208x * , . 0 00r100g100b88 008x ( * , .
00r0g100b100 208x * , . 0 00r25g100b100 @ 00 208x * , . 08 00r50g100b100 5g75b100@ l 1
$" g BEFOREPFORM beforepform ( e ͫͫͫͫͫͫͫ xj SYS STANDARD /Lrep_genINIT_REPORT $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 # # T "BEFOREPFORM":P_REPORT_NAME":P_USER":P_PASSWORD":P_RESORT":P_BUSINESS_DATE"_return"" " # % ) - 3 7 8 : > B H L P V Z [ ] a e k l p t z {
P g@
g@
( g ! "
$ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 / / / / ` A A e e A A e e A A e e A A e e "BEFOREPFORM"B73B12DF826918465DFEF8A39AD23659"BOOLEAN"INIT_REPORT"P_REPORT_NAME""P_USER"P_PASSWORD"P_RESORT"P_BUSINESS_DATE"TRUE"2000"20"40""
- 1 2 6 8 < C J Q X _ f m t { h , W Z e Q c Q c Q c Q c
) ) 6 6 A A
/ $
$ (
(
, ,
-
- . g g
"
# # ! g
& ' ' % g ( * + + )
4 e
v plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"plscope_settings" 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H R R C p T f _ _ _
_ _ t } p @ @ h 8 BEFOREPFORM 8 ! "BEFOREPFORM"#3e4672a427273418 #1 @ D D @ D @ D ( X A P < C @ H 0 P H X ` ` x h
@ @ ize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"plscope_settings" 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H X v T f X_ < 6 6r c r c } _ <
6 6r c r c } } @ p 8 1 0 gray16 white solid ( R_WINDOWFORMATTRIGGER $ 8L .B + "R_WINDOWFORMATTRIGGER"#3e4672a427273418 #1 A0 A
l 1
$ g
AFTERPFORM
afterpform } ͫͫͫͫͫͫͫ xj SYS STANDARD $/Namespace0004/INITIALIZE_PARAMETERS /Namespace0004/BUILD_WHERE /Namespace0004/BUILD_ORDER_BY /Namespace0004/PROC_FILTER $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 # "AFTERPFORM"_return"" t & $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 $ x "AFTERPFORM"B73B12DF826918465DFEF8A39AD23659"BOOLEAN"INITIALIZE_PARAMETERS"BUILD_WHERE"BUILD_ORDER_BY"PROC_FILTER"TRUE"" ,
- 1 2 6 8 < B C G M N R X Y ] c d h k p r v x h , W W W W Z e
/
e v plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"plscope_settings" 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H ( ( H X T } ( p 8
AFTERPFORM "AFTERPFORM"#3e4672a427273418 #1 @ @ @ g Trans. Date * x( g
Trx. Code , x* g Description / x- g Payment Amount ' x% g Filter D xB g$ Page & of & 8 x6 K g Window &window balance: :NVbx~( (((((pppppppp SQL*ReportWriter REPORT OPERA md_hrs_open_payments Re OPERAxv ,+ " OPERAxw
6 " " " "
p rep_gen b Q(0@@80@@@@@@000000ppp 00880 !
AA11AA A"A&A*A.1/12A6A:1;1>ABAFAJANARAV1W1XYZ[\]^_`d $eDB B d ` `
g d jj P L PB ` ` L PB ` `
88 88 88 p P_BUSINESS_DATE !&
' P_BUSINESS_DATE 1fgpnopqrsvpvwpwpwxyz{|0}0~0000pppppppp P_DATE E (
P_DATE 1fgppqrstuvpvwpwpwxyz |}0~00000pppppppp P_FILTER
P_FILTER 1fgppqrstuvpvwpwpwxyz{|0}0~0000pppppppp P_FORMAT
P_FORMAT 1fgprstuvwzpz{p{p{|}~000000pppppppp P_PASSWORD
P_PASSWORD E l 1
$" 8g B_FILTER_SEC2FORMATTRIGGER B ͫͫͫͫͫͫͫ xj SYS STANDARD $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 8 / "B_FILTER_SEC2FORMATTRIGGER":P_FILTER"_return"" " # % ) - 3 4 . g
$ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8
! ! ! ! 8 3
A A e e h "B_FILTER_SEC2FORMATTRIGGER"2B2356CCB4A3407803B3F53C1EB23F42"BOOLEAN"P_FILTER""IS NULL"FALSE"TRUE"2000"" v
- 1 2 6 8 ? F J K Q T X [ ` b f k o r w y } h , | . Z Z e < Z e Q c
,
g
e
v plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"plscope_settings" 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H 0 0 0 P T f _ "
} } h 0 ( ` 8 0 B_FILTER_SEC2FORMATTRIGGER 0 "B_FILTER_SEC2FORMATTRIGGER"#3e4672a427273418 #1 D 8 @ H @ @ x" $& ( r88g0b88 , 00x$ &( * r100g0b88 ( 00x"#$ & r0g0b100 , 00x$ &( * ! r25g0b100 @ , 00x$ &( * " r50g0b100 , 00x$ &( * # r75g0b100 , 00x$ &( * $ r88g0b100 , 00x$ &( * %
r100g0b100 & 00x " $ & gray * 00x" $ & ( ' darkgray & 00x " $ ( cyan r * 00x"$ & ( ) darkcyan ( 00x " $ & * gray80333333( 00x " $ & + gray76p=p=p=( 00x " $ & , gray72GGG( 00x " $ & - gray68QQQ' 00x!" $% . r0g25b0 @ Q) 00x" $ &' / r25g25b0 @ @ ) 00x" $ &' 0 r50g25b0 @ ) 00x" $ &' 1 r75g25b0 @ ) 00x" $ &' 2 r88g25b0 @ + 00x$ & () 3 r100g25b0 @ * 00x"$ & ( 4 r0g25b50 @ , 00x$ & ( * 5 r25g25b50 @ @ , 00x$ & ( * 6 r50g25b50 @ , 00x$ & ( * 7 r75g25b50 @ , 00x$ & ( * 8 r88g25b50 @ , 00x$ & ( * 9
r100g25b50 @ * 00x"$ & ( : r0g25b75 0 @ , 00x$ & ( * ; r25g25b75 @ @ , 00x$ & ( * < r50g25b75 @ , 00x$ & ( * = r75g25b75 @ , 00x$ & ( * > r88g25b75 @ , 00x$ & ( * ?
r100g25b75 @ * 00x"$ & ( @ r0g25b88 5 @ , 00x$ & ( * A r25g25b88 @ @ l 1
$" g CF_LOGOFORMULA E B ͫͫͫͫͫͫͫ xj SYS STANDARD $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 = # "CF_LOGOFORMULA":P_RESORT"_return"" " # % ) - 3 7 9 & ( g@
g
$ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8
4 @ e A A e e A A e N "CF_LOGOFORMULA"9A3987C419A7551783AEFBD4152A03AD"CHAR"P_RESORT""||".gif"40"4"" 4
- 1 2 6 8 ? F J O P V [ ] a c t x { h , | n . e Q c Q c
g (
e
v plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"plscope_settings" 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H ( ( ( H h T f _ 1 { 8 0 0 8 .gif CF_LOGOFORMULA ` $ "CF_LOGOFORMULA"#1e7de0b7cf6f55ab #1 0 D ( @ g @ @ x% g Window , x* g Trans. Date * x( g
Trx. Code , x* g Description / x- g Payment Amount ' x% g Filter D xB g$ Page & of & 8 x6 K g Window &window balance: :NVbx~( (((((pppppppp SQL*ReportWriter REPORT OPERA md_hrs_open_payments Re OPERAxv ,+ " OPERAxw
6 " " " "
p rep_gen b Q(0@@80@@@@@@000000ppp 00880 !
AA11AA A"A&A*A.1/12A6A:1;1>ABAFAJANARAV1W1XYZ[\]^_`d $eDB B d ` `
g d jj P L PB ` ` L PB ` `
88 88 88 p P_BUSINESS_DATE !&
' P_BUSINESS_DATE 1fgpnopqrsvpvwpwpwxyz{|0}0~0000pppppppp P_DATE E (
P_DATE 1fgppqrstuvpvwpwpwxyz |}0~00000pppppppp P_FILTER
P_FILTER 1fgppqrstuvpvwpwpwxyz{|0}0~0000pppppppp P_FORMAT
P_FORMAT 1fgprstuvwzpz{p{p{|}~000000pppppppp P_PASSWORD
P_PASSWORD E l 1
$" .g R_WINDOWFORMATTRIGGER S ͫͫͫͫͫͫͫ xj SYS STANDARD SRW $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 4 * "R_WINDOWFORMATTRIGGER":CP_COLOR"_return"" ! % ) / 0
P
$ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 0 Z Z Z Z 1 x 9 x 9 A A e A A e A A e A A e A A e A A e "R_WINDOWFORMATTRIGGER"B73B12DF826918465DFEF8A39AD23659"BOOLEAN"CP_COLOR""="1"SRW"SET_FOREGROUND_FILL_COLOR"gray16"SET_FILL_PATTERN"solid"TRUE"0"white"6"5"" l
- 1 2 6 8 ? F J O P V Y ] a d i j p t x { "+.4=>AGPQTZcdgmvwz h , | n . Z k n W k n W Z e < | n . Z k n W k n W Z e < Z e Q c Q c Q c Q c Q c Q c
' # #
# # # # # # ! @ @ / A
A D
E
H
I L M
@
@ ! =
A
P # % Q &
( ) T * , U 7 . / X 0 2 Y 7
4 5 @ 7 8 ' 7 @ 9 =
: ; @ = @ @ @ @ ? = > B C C # F G G & J ! K "#K ( $ N % O &'O * ( R ) S *+S - , V - W ./W / " $ + 1 - 3 6 8 ! 9 <
" $ + 1 e
v plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"plscope_settings" 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H X v T f X_ < 6 6r c r c } _ <
6 6r c r c } } @ p 8 1 0 gray16 white solid ( R_WINDOWFORMATTRIGGER $ 8L .B + "R_WINDOWFORMATTRIGGER"#3e4672a427273418 #1 A0 A @ H 0 P H X ` ` x h p g x g g g0 g @ @ , 0 4 $ 8 0 < < @ H D g` H gx L g T g l 1
$" g CF_COLORFORMULA [ B ͫͫͫͫͫͫͫ xj SYS STANDARD $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8
3 $ "CF_COLORFORMULA":CP_COLOR"_return"" ! % ) /
P
@
$ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 ' ' ' ' @ x A A A A A A e J "CF_COLORFORMULA"EAC6DA3A708D566387BAEC8AF4ACBC3D"NUMBER"CP_COLOR""="1"0""
- 1 2 6 8 ? F J O P V Y ` c g i p s w y } h , | n . Z Q
Q
< Q Z e Q c
! !
! "
" %
& "
"
! !
!
! ! ! !
# $
$
e
v plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"plscope_settings" 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H R R & X x T f _ < $ $ ! ?x 0 8 p 8 1 CF_COLORFORMULA p % "CF_COLORFORMULA"#9689ba467a19cd19 #1 A0 A H & @ X 0 p g @ @ h U Q k n | k . W k | Q . k W < k W | k . | k .
| k .
| k .
| .
k n | k . W c Q c . . Q c
2 4 = =
"
! !
" "
0 2 ; ;
n n / o o
m r
s t k
x " # % ' y ( ;
) ! ( n * k + , - . z k 1 { 5 7 6 9 ! ~ " # $ % < > & = @ ' : B A ( ) * + , E G - F I . C K J / 0 1 2 3 N P 4 O R 5 L T S 6 7 8 W X 9 U Z Y : l 1
$" #g CF_WIN_BALANCEFORMULA k ͫͫͫͫͫͫͫ xj SYS STANDARD xu OPERA FINANCIAL_TRANSACTIONS $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 w ` "CF_WIN_BALANCEFORMULA"RET""$F0":P_RESORT":RESV_NAME_ID":WINDOW"_return"" ! % + . 4 8 < B F G I M Q W [ _ e i m s
V
@
( gX $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 ' U U U U <
N A i
& A _ x x A A e e "CF_WIN_BALANCEFORMULA"D67AB6F13371915D9F87E59A0E8F9D81"NUMBER"RET"SUM"NVL"GUEST_ACCOUNT_DEBIT"0"-"GUEST_ACCOUNT_CREDIT"FINANCIAL_TRANSACTIONS"RESORT"P_RESORT""="RESV_NAME_ID"FOLIO_VIEW"WINDOW"40"" ,
- 1 2 6 8 B F O T U X \ ` c d j n r u y } $&7;>DMV_`abcdev{ h , Q . | Q . . | . | .
| .
e Q c `
'
&
* , 0 4 I 0 0 ,
Q % . . , , , < K K I I I % % % %
, I 0
" D D $
C N
O P " 9 : D
H &
H ' ( K I , I - . L ) 0 / J 4 J 5 6 M 1 8 7 < = Q @ # ; A ? D A D D D D C A B g ( F G G E !" #$ & ) , / 2 5 : ; T % & 8 ! $ % * + 2 3 > @ & , 4 $ % * + 2 3 S R 0 e 4 & , v plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings"plsql_ccflags"plscope_settings" 6 2"INTERPRETED"TRUE"BYTE"BYTE""IDENTIFIERS:NONE" ͫͫͫͫͫͫͫ H X X 0 ` T f h k g DN V p @ ( CF_WIN_BALANCEFORMULA + "CF_WIN_BALANCEFORMULA"#9689ba467a19cd19 #1 A0
D ( X A0 A < SELECT SUM (NVL(GUEST_ACCOUNT_DEBIT , 0 ) ) - SUM (NVL(GUEST_ACCOUNT_CREDIT , 0 ) ) FROM FINANCIAL_TRANSACTIONS WHERE RESORT = :b1 AND RESV_NAME_ID = :b2 AND FOLIO_VIEW = :b3 " P X 0 l @ @ OPROCEDURE initialize_parameters IS
BEGIN
SELECT TO_CHAR( pms_p.business_date, pms_p.date_format ),
TO_CHAR( SYSDATE, pms_p.time_format ),
NVL( pms_p.get_parameter('ROOMCLASS_YN'), 'N' ),
NVL( pms_p.get_parameter('AMOUNT_FORMAT'), 'NNNNNNNNNNN0.00' )
INTO :p_date, :p_time, :p_room_class_yn, :p_format
FROM dual;
SELECT name
INTO :p_resort_name
FROM resort r
WHERE r.resort = :P_RESORT;
IF :p_from_date IS NULL THEN
:p_from_date := pms_p.business_date;
END IF;
IF :p_to_date IS NULL OR :p_to_date < :p_from_date THEN
:p_to_date := :p_from_date;
END IF;
IF :p_char_from_date IS NULL THEN
:p_char_from_date := to_char(:p_from_date,pms_p.date_format);
END IF;
IF :p_char_to_date IS NULL THEN
:p_char_to_date := to_char(:p_to_date,pms_p.date_format);
END IF;
END; initialize_parameters % ͫͫͫͫͫͫͫ xj SYS STANDARD p << OPERA DUAL
xp - PUBLIC DUAL xp - SYS DUAL PMS_P
xu ( OPERA PMS_P xu ! OPERA RESORT $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 J J $ "INITIALIZE_PARAMETERS""$F0"$F1"$F2"$F3"":P_DATE":P_TIME":P_ROOM_CLASS_YN":P_FORMAT":P_RESORT_NAME":P_RESORT":P_FROM_DATE":P_TO_DATE":P_CHAR_FROM_DATE":P_CHAR_TO_DATE"" ! ' + - 1 7 ; A E K O S Y \ b f g i m q w { | ~
!
g P g x?
( gp@ ! # ' $ % & g@ ! "
# * A ! ) - 1 . / 0 gHA ! , 4 8 5 6 7 d gA ! 3
; B ! : > ? xB ! = > B B ! A #
E B ! D # H B ! G
" ) , 3 : = A D G
! ( + 2 9 < @ C F I $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 x ) j { ) e 8 . e Y N e e Y N e e
{
3 ) e 3 ) e A A e e A A e e A A e e A A e e A A e e A A e e A A e e A A e e e e A A e A A e A A e A A e e e e e e e e e e e ` "INITIALIZE_PARAMETERS"C590A038B364ED539F6C3DB1F7E17411"TO_CHAR"PMS_P"BUSINESS_DATE"DATE_FORMAT"SYSDATE"TIME_FORMAT"NVL"GET_PARAMETER"ROOMCLASS_YN"N"AMOUNT_FORMAT"NNNNNNNNNNN0.00"P_DATE""P_TIME"P_ROOM_CLASS_YN"P_FORMAT"DUAL"NAME"P_RESORT_NAME"RESORT"R"P_RESORT"="P_FROM_DATE"IS NULL"P_TO_DATE"<"P_CHAR_FROM_DATE"P_CHAR_TO_DATE"40"20"30"100"12"1"13"15""
- 1 2 4 7 ; ? B F J M N T W [ _ c f g m q u y | $(,./6:>AHOSTZ[aefkry}~ #'+./59;?DKRVW]dgnrvyz
#,5>BEKTX[ajpqrxyz{ ()*;@JKLRSTUVW]^_`aghi h U k k . k . k n . n . k n . n . @ r 1p"&'*. /proc_filter ara 1p"&'*. /template_hints uil Ap267:> ?p_char_from_datevalidtrigger $ =p.236: ;p_char_to_datevalidtrigger 1p"&'*. /afterreport tev
ig 1p"&'*. /beforepform tev
ig -p "#&* +afterpform =p.236: ;b_filter_sec2formattrigger
ͫ 9 p& *,26 7cf_logoformula mat
= p* .06: ;7r_windowformattrigger $ 9 p& *,26 7;cf_colorformula ig : $ = p* .06: ;Dcf_win_balanceformula C U
p p,p=JKL0M0NOPQR Skresv_name_id rn1.resv_name_id RESV_NAME_ID g ^
p p/pCSTU0V0WXYZ[ \nconfirmation_no rn1.confirmation_no CONFIRMATION_NO 2 g =
p p$p-2340506789: ;qroom ft1.room ROOM g _op s
p p*p]hij0k0lmnop qtguest_name rn1.guest_first_name || ' ' || rn1.guest_last_name GUEST_NAME g G
p p&p5<=>0?0@ABCD Ewwindow ft1.folio_view WINDOW g I
p p(p5>?@0A0BCDEF Gztrx_date ft1.trx_date TRX_DATE g I
p p(p5>?@0A0BCDEF G}trx_code ft1.trx_code TRX_CODE g T
p p+p;GH J0L0MNOPQ Rdescription tc1.description DESCRIPTION r g O
p p*p9DEF0G0HIJKL Mtrx_amount ft1.trx_amount TRX_AMOUNT &g d 2p4;