ROS.60050 ) p r
!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ 8000 s 8000 8000 [2 8000 8000 rl 8000 rc 8000 8000 t 8000 8000 es 8000 8000 e 8000 8000 ! it 8000 " 8000 # 8000 $ na 8000 % 8000 & us 8000 ' de 8000 ( 8000 ) fi 8000 * 8000 + 8000 , nt 8000 - 8000 . 8000 / AC 8000 0 8000 1 8000 2 8000 3 8000 4 8000 5 8000 6 8000 7 8000 8 8000 9 8000 : 8000 ; 8000 < OP 8000 = on*/;
YES
F 0 80 & p 80 ^ 80 80 80 80 > @ 80 v p 80 80 80 80 V @ r 08h , SA 08ss attri te P 08hh &' ` 08ros lf d cr 08hh VW @ 08ros name
id p rep_gen p
(0@ uiStrings *hh (ROSSTRUCTS struct types *hh (ROSTK2RESV tk2 reserved &h!"h# $ SRW2_BODY_LOCATION de p ` 88 L P 88 W2 T 0 88 h W2 &00x $h h A r25g25b88 _F *08x ( h
00r50g75b100 ,08x *_MODULE 00r75g100b100 0 ,p"&'*LOR proc_filter ara u fphpqrs +pp $&'( )VG_COLOR CELLID R@ -pp &()* +VG_COLOR NA6DECIMAL x fphstuv, -VG_COLOR NAME_LENGTH /pp (*+, -VG_COLOR COLOR_NAME x P_PASSWORD P | fphwxyz )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLP_CHAR_TO_DATE ` | bpdop(vpz00 " 8000 # 8000 $ zB_trx_code 00 h FpH]^(bpf 8000 & us 8000 R_G_confirmation_no1 {0 00 ( 8000 ) fi 8000 * 8000 + 8000 , nt 8000 - 8000 . 8000 / AC 8000 0 8000 1 8000 2 8000 3 8000 4 8000 5 8000 6 8000 7 8000 8 8000 9 8000 : 8000 ; 8000 < OP 8000 = on*/;
YES
F 0 80 & p 80 ^ 80 80 80 80 > @ 80 v p 80 80 80 80 V x 0 r 88 t ^ 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 frr r @ @ P @ Report Parameters Enter values for the parameters _se $00x ! " " black (00x " $ & white %00x " # green )00x# $& ' darkgreen (00x " $ & gray96
=
=
= (00x " $ & gray92zzz (00x " $ &ER gray88 (00x " $ & gray84((( %00x !" # r0g0b0 (00x "$% & r25g0b0 @ (00x "$% &@
r50g0b0 (00x "$% & r75g0b0 (00x "$% &0 r88g0b0 (00x "$% &
r100g0b0 (00x!" $ & r0g0b50 *00x "$ & ( r25g0b50@ *00x "$ & (0 r50g0b50 *00x "$ & ( r75g0b50 0 *00x "$ & ( r88g0b50 ,00x $& ( *0 r100g0b50 (00x!" $ & r0g0b75 *00x "$ & ( r25g0b75@ *00x "$ & (0 r50g0b75 *00x "$ & ( r75g0b75 p *00x "$ & ( r88g0b75 ,00x $& ( * r100g0b75 (00x!" $ & r0g0b88 *00x "$ & ( r25g0b88@ *00x "$ & ( r50g0b88 *00x "$ & ( r75g0b88 *00x "$ & ( 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 " $ & + gray76=p=p=p (00x " $ & , gray72GGG (00x " $ & - gray68QQQ '00x! "$ % . r0g25b0 @ )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@ @
r .hh ,tROSATTRIBS class attributes ^ +hh ) ROSLFDESC ros lf descrip )hh ' ROSOBJMAP ros name->id +hh )ROSSTRINGS tk2 uiStrings *hh ( ROSSTRUCTS struct types *hh ( ROSTK2RESV tk2 reserved hh SRW2_ACTION ( hh SRW2_ANCHOR &h!"h# $ SRW2_BODY_LOCATION $h h! " $SRW2_BOILERPLATE hh SRW2_BUTTON hh SRW2_COLUMN #h h ! SRW2_DATA_MODEL $h h! " SRW2_DISPLAY_TAG %h !h" #. SRW2_DISTRIBUTION & h h SRW2_ELEMENT hh SRW2_FIELD )h$%h& ' SRW2_FORMAT_EXCEPTION % "h h SRW2_FORMFIELD ' hh SRW2_FRAME hh SRW2_GROUP #h h ! SRW2_GROUP_NODE " _ "h h qlSRW2_HYPERLINK ! eb $h h! "ntSRW2_JAVA_APPLET # (h#$h% &ERSRW2_JAVA_PROPERTIES $ hh SRW2_LAYOUT
H %h !h" # SRW2_LAYOUT_GROUP hh SRW2_LINK hh SRW2_LISTS hh SRW2_MATRIX 'h"#h$ % SRW2_OGD_COLUMN_MAP $h h! " SRW2_OG_DOCUMENT #h h ! SRW2_PARAM_FORM
hh SRW2_QUERY @ %h !h" #0 SRW2_TEXT_SEGMENT " h h 0 TOOL_COMMENT h h TOOL_LIBRARY hh %TOOL_MODULE hh TOOL_PLSQL $pp "VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID R@ +pp $&'( )VG_COLOR CELLID R@ -pp &()* +VG_COLOR NAME_SET @ 75g /pp (*+, -VG_COLOR NAME_LENGTH 0 /pp (*+, -VG_COLOR COLOR_NAME x 'pp "#$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE ( x & " g eConf No % x # g eRoom 88g + x )0 g eGuest Name 0 ' x %0 g eWindow , x *0 g eTrans. Date * x (0 g
eTrx. Code 0g , x *0 g eDescription / x -0 g ePayment Amount 8 ' x % g eFilter 0 D x B0 g$ ePage & of & 8 x 610K g eWindow &window balance: " r50g0b100 ,00x $& ( * # r75g0b100 ,00x $& ( * $ r88g0b100 ,00x $& ( * %
r100g0b100 &00x " $ & gray *00x " $ & ( ' darkgray &00x " $ ( cyan r *00x" $ & ( ) darkcyan (00x " $ & * gray80333333 (00x " $ & + gray76=p=p=p (00x " $ & , gray72GGG (00x " $ & - gray68QQQ '00x! "$ % . r0g25b0 @ )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@ P r 88 t RIBS class attributes ^ +hh ) ROSLFDESC ros lf descrip )hh ' ROSOBJMAP ros name->id +hh )ROSSTRINGS tk2 uiStrings *hh ( ROSSTRUCTS struct types *hh ( ROSTK2RESV tk2 reserved hh SRW2_ACTION ( hh SRW2_ANCHOR &h!"h# $ SRW2_BODY_LOCATION $h h! " $SRW2_BOILERPLATE hh SRW2_BUTTON hh SRW2_COLUMN #h h ! SRW2_DATA_MODEL $h h! " SRW2_DISPLAY_TAG %h !h" #. SRW2_DISTRIBUTION & h h SRW2_ELEMENT hh SRW2_FIELD )h$%h& ' SRW2_FORMAT_EXCEPTION % "h h SRW2_FORMFIELD ' hh SRW2_FRAME hh SRW2_GROUP #h h ! SRW2_GROUP_NODE " _ "h h qlSRW2_HYPERLINK ! eb $h h! "ntSRW2_JAVA_APPLET # (h#$h% &ERSRW2_JAVA_PROPERTIES $ hh SRW2_LAYOUT
H %h !h" # SRW2_LAYOUT_GROUP hh SRW2_LINK hh SRW2_LISTS hh SRW2_MATRIX 'h"#h$ % SRW2_OGD_COLUMN_MAP $h h! " SRW2_OG_DOCUMENT #h h ! SRW2_PARAM_FORM
hh SRW2_QUERY @ %h !h" #0 SRW2_TEXT_SEGMENT " h h 0 TOOL_COMMENT h h TOOL_LIBRARY hh %TOOL_MODULE hh TOOL_PLSQL $pp "VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID R@ +pp $&'( )VG_COLOR CELLID R@ -pp &()* +VG_COLOR NAME_SET @ 75g /pp (*+, -VG_COLOR NAME_LENGTH 0 /pp (*+, -VG_COLOR COLOR_NAME x 'pp "#$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE ( x & " g eConf No % x # g eRoom 88g + x )0 g eGuest Name 0 ' x %0 g eWindow , x *0 g eTrans. Date * x (0 g
eTrx. Code 0g , x *0 g eDescription / x -0 g ePayment Amount 8 ' x % g eFilter 0 D x B0 g$ ePage & of & 8 x 610K g eWindow &window balance: " r50g0b100 ,00x $& ( * # r75g0b100 ,00x $& ( * $ r88g0b100 ,00x $& ( * %
r100g0b100 &00x " $ & gray *00x " $ & ( ' darkgray &00x " $ ( cyan r *00x" $ & ( ) darkcyan (00x " $ & * gray80333333 (00x " $ & + gray76=p=p=p (00x " $ & , gray72GGG (00x " $ & - gray68QQQ '00x! "$ % . r0g25b0 @ )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@ ` r 88 t RIBS class attributes ^ +hh ) ROSLFDESC ros lf descrip )hh ' ROSOBJMAP ros name->id +hh )ROSSTRINGS tk2 uiStrings *hh ( ROSSTRUCTS struct types *hh ( ROSTK2RESV tk2 reserved hh SRW2_ACTION ( hh SRW2_ANCHOR &h!"h# $ SRW2_BODY_LOCATION $h h! " $SRW2_BOILERPLATE hh SRW2_BUTTON hh SRW2_COLUMN #h h ! SRW2_DATA_MODEL $h h! " SRW2_DISPLAY_TAG %h !h" #. SRW2_DISTRIBUTION & h h SRW2_ELEMENT hh SRW2_FIELD )h$%h& ' SRW2_FORMAT_EXCEPTION % "h h SRW2_FORMFIELD ' hh SRW2_FRAME hh SRW2_GROUP #h h ! SRW2_GROUP_NODE " _ "h h qlSRW2_HYPERLINK ! eb $h h! "ntSRW2_JAVA_APPLET # (h#$h% &ERSRW2_JAVA_PROPERTIES $ hh SRW2_LAYOUT
H %h !h" # SRW2_LAYOUT_GROUP hh SRW2_LINK hh SRW2_LISTS hh SRW2_MATRIX 'h"#h$ % SRW2_OGD_COLUMN_MAP $h h! " SRW2_OG_DOCUMENT #h h ! SRW2_PARAM_FORM
hh SRW2_QUERY @ %h !h" #0 SRW2_TEXT_SEGMENT " h h 0 TOOL_COMMENT h h TOOL_LIBRARY hh %TOOL_MODULE hh TOOL_PLSQL $pp "VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID R@ +pp $&'( )VG_COLOR CELLID R@ -pp &()* +VG_COLOR NAME_SET @ 75g /pp (*+, -VG_COLOR NAME_LENGTH 0 /pp (*+, -VG_COLOR COLOR_NAME x 'pp "#$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE ( x & " g eConf No % x # g eRoom 88g + x )0 g eGuest Name 0 ' x %0 g eWindow , x *0 g eTrans. Date * x (0 g
eTrx. Code 0g , x *0 g eDescription / x -0 g ePayment Amount 8 ' x % g eFilter 0 D x B0 g$ ePage & of & 8 x 610K g eWindow &window balance: " r50g0b100 ,00x $& ( * # r75g0b100 ,00x $& ( * $ r88g0b100 ,00x $& ( * %
r100g0b100 &00x " $ & gray *00x " $ & ( ' darkgray &00x " $ ( cyan r *00x" $ & ( ) darkcyan (00x " $ & * gray80333333 (00x " $ & + gray76=p=p=p (00x " $ & , gray72GGG (00x " $ & - gray68QQQ '00x! "$ % . r0g25b0 @ )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@ p d r ^
Q(0@@80@@@@@@000000ppp 00880! AA
11AAAA A"A&1*1+A.A21617A:A>ABAFAJAN1R1STUVWXYZ[\de p BD B ` `
g d jj LP L PB ` ` L PB ` `
NCHOR &h!"h# $ SRW2_BODY_LOCATION $h h! " $SRW2_BOILERPLATE hh SRW2_BUTTON hh SRW2_COLUMN #h h ! SRW2_DATA_MODEL $h h! " SRW2_DISPLAY_TAG %h !h" #. SRW2_DISTRIBUTION & h h SRW2_ELEMENT hh SRW2_FIELD )h$%h& ' SRW2_FORMAT_EXCEPTION % "h h SRW2_FORMFIELD ' hh SRW2_FRAME hh SRW2_GROUP #h h ! SRW2_GROUP_NODE " _ "h h qlSRW2_HYPERLINK ! eb $h h! "ntSRW2_JAVA_APPLET # (h#$h% &ERSRW2_JAVA_PROPERTIES $ hh SRW2_LAYOUT
H %h !h" # SRW2_LAYOUT_GROUP hh SRW2_LINK hh SRW2_LISTS hh SRW2_MATRIX 'h"#h$ % SRW2_OGD_COLUMN_MAP $h h! " SRW2_OG_DOCUMENT #h h ! SRW2_PARAM_FORM
hh SRW2_QUERY @ %h !h" #0 SRW2_TEXT_SEGMENT " h h 0 TOOL_COMMENT h h TOOL_LIBRARY hh %TOOL_MODULE hh TOOL_PLSQL $pp "VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID R@ +pp $&'( )VG_COLOR CELLID R@ -pp &()* +VG_COLOR NAME_SET @ 75g /pp (*+, -VG_COLOR NAME_LENGTH 0 /pp (*+, -VG_COLOR COLOR_NAME x 'pp "#$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE ( x & " g eConf No % x # g eRoom 88g + x )0 g eGuest Name 0 ' x %0 g eWindow , x *0 g eTrans. Date * x (0 g
eTrx. Code 0g , x *0 g eDescription / x -0 g ePayment Amount 8 ' x % g eFilter 0 D x B0 g$ ePage & of & 8 x 610K g eWindow &window balance: " r50g0b100 ,00x $& ( * # r75g0b100 ,00x $& ( * $ r88g0b100 ,00x $& ( * %
r100g0b100 &00x " $ & gray *00x " $ & ( ' darkgray &00x " $ ( cyan r *00x" $ & ( ) darkcyan (00x " $ & * gray80333333 (00x " $ & + gray76=p=p=p (00x " $ & , gray72GGG (00x " $ & - gray68QQQ '00x! "$ % . r0g25b0 @ )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@ r p rep_gen @80@@@@@@000000ppp 00880! AA
11AAAA A"A&1*1+A.A21617A:A>ABAFAJAN1R1STUVWXYZ[\de p BD B ` `
g d jj LP L PB ` ` L PB ` `
NCHOR &h!"h# $ SRW2_BODY_LOCATION $h h! " $SRW2_BOILERPLATE hh SRW2_BUTTON hh SRW2_COLUMN #h h ! SRW2_DATA_MODEL $h h! " SRW2_DISPLAY_TAG %h !h" #. SRW2_DISTRIBUTION & h h SRW2_ELEMENT hh SRW2_FIELD )h$%h& ' SRW2_FORMAT_EXCEPTION % "h h SRW2_FORMFIELD ' hh SRW2_FRAME hh SRW2_GROUP #h h ! SRW2_GROUP_NODE " _ "h h qlSRW2_HYPERLINK ! eb $h h! "ntSRW2_JAVA_APPLET # (h#$h% &ERSRW2_JAVA_PROPERTIES $ hh SRW2_LAYOUT
H %h !h" # SRW2_LAYOUT_GROUP hh SRW2_LINK hh SRW2_LISTS hh SRW2_MATRIX 'h"#h$ % SRW2_OGD_COLUMN_MAP $h h! " SRW2_OG_DOCUMENT #h h ! SRW2_PARAM_FORM
hh SRW2_QUERY @ %h !h" #0 SRW2_TEXT_SEGMENT " h h 0 TOOL_COMMENT h h TOOL_LIBRARY hh %TOOL_MODULE hh TOOL_PLSQL $pp "VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID R@ +pp $&'( )VG_COLOR CELLID R@ -pp &()* +VG_COLOR NAME_SET @ 75g /pp (*+, -VG_COLOR NAME_LENGTH 0 /pp (*+, -VG_COLOR COLOR_NAME x 'pp "#$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE ( x & " g eConf No % x # g eRoom 88g + x )0 g eGuest Name 0 ' x %0 g eWindow , x *0 g eTrans. Date * x (0 g
eTrx. Code 0g , x *0 g eDescription / x -0 g ePayment Amount 8 ' x % g eFilter 0 D x B0 g$ ePage & of & 8 x 610K g eWindow &window balance: " r50g0b100 ,00x $& ( * # r75g0b100 ,00x $& ( * $ r88g0b100 ,00x $& ( * %
r100g0b100 &00x " $ & gray *00x " $ & ( ' darkgray &00x " $ ( cyan r *00x" $ & ( ) darkcyan (00x " $ & * gray80333333 (00x " $ & + gray76=p=p=p (00x " $ & , gray72GGG (00x " $ & - gray68QQQ '00x! "$ % . r0g25b0 @ )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@ d r ]0808[ E E
Oracle HTML Navigator
$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE ( x & " g eConf No % x # g eRoom 88g + x )0 g eGuest Name 0 ' x %0 g eWindow , x *0 g eTrans. Date * x (0 g
eTrx. Code 0g , x *0 g eDescription / x -0 g ePayment Amount 8 ' x % g eFilter 0 D x B0 g$ ePage & of & 8 x 610K g eWindow &window balance: " r50g0b100 ,00x $& ( * # r75g0b100 ,00x $& ( * $ r88g0b100 ,00x $& ( * %
r100g0b100 &00x " $ & gray *00x " $ & ( ' darkgray &00x " $ ( cyan r *00x" $ & ( ) darkcyan (00x " $ & * gray80333333 (00x " $ & + gray76=p=p=p (00x " $ & , gray72GGG (00x " $ & - gray68QQQ '00x! "$ % . r0g25b0 @ )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@ 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
P U Y ] a d h l q r w { ~
$
(
+
,
1
2
7
;
=
A
F
J
N
Q
V
W
[
_
b
c
d
i
m
q
u
y
}
~
! % * . 2 6 : > B E J K P T 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 $ & ( * 00gray16
,08x $ & ( * 00gray12GGG ,08x $ & ( * 00gray8 ,08x $ & ( * 00gray4 -08x & (* + 00r0g100b0 & /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 ( * , .0
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 "$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 ?
( g? ! # ' $ % & g? ! "
# * @ ! ) - 1 . / 0 g@@ ! , 4 8 5 6 7 d gx@ ! 3
; @ ! : > ? B PA ! A #
E dA ! D # H A ! G
" ) , 3 : = A D G
! ( + 2 9 < @ C F I $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8 x ( ? { ) e , . e M N e e M N e e z
{
' ) 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 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"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"" t
) - . 0 3 7 ; > B F I J O R V Z ^ a b g k o s v { | "$%,047>EIJOPVZ[`gnrsx
%)+/4;BFGLSV]aehinrtx}
"+/28AEHNW\]^cdefklmrstux~"#$)*+,-.34567<=> 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 < R V d 4 a 2 . s T @ 0 J W plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings" " 2"INTERPRETED"TRUE"BYTE"BYTE" ͫͫͫͫͫͫͫ
H e lsql h T f pk g XN N N N V u u u
u k g - N V _ "
! _ " \ >r g ;x ! ?! _ " X B_ _ ??_ x ! ?! _
" 8 d_ r g ? u ! ?_ r g ?
u
| t
BUSINESS_DATE DATE_FORMAT PMS_P $ INITIALIZE_PARAMETERS
@ l 4 xp
4
PMS_PIBISSAMARABUSINESS_DATE PMS_P A INITIALIZE_PARAMETERS 4 xp
4
PMS_PIBISSAMARADATE_FORMAT PMS_P
D D D D
A D 0 0 8 D ( D A A 0
2 .* SELECT NAME FROM RESORT R WHERE R.RESORT = :1 "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 " e 0 4 8 $ < 0 @ < D
gT T gl ` g
@ @ 7 7 7 7 u ! >! 7 t r g r r g g r g |r s g{r s g r t g r t g t
t u g 5 u v r v g [ gѦ r p g p q q ?0
?0r g r - t ! ?U X M U B G 1 M G t t c T
W 9l g 5W 9( V T ,
W Fl g TW FV T W Vl g eW V( V 4 6 D p 9 > Initialize FAILURE NOPASSWD GET_REPORT_PARAMETER Business Date= REP_REF ***INIT_REPORT*** : PRINTLOG SET_LOG Report Name= Resort= Report ID= User= ; SET_SFA_NAME ^O~ SC ORS ^A~ ^F~ Y alter session set nls_date_format = PMS ' E , dd-mon-rr @ APP_USER SET_RUNNING_APP RESERVATION_I SEARCH_IN_CURRENT_PROPERTY OLC GETPARAMETERVALUE OPERA_SRW DD-MON-YYYY business date= IS_SFA_INSTALLED INSTALLED_APPS INITIALIZE PMS_P X SET_ALLRESORT_ACCESS N ORS_PKG SET_FIRST_LOGGED_RESORT MFN SEARCH_IN_ALL_PROPERTY after pms_p.initialize: util_rep.ParentAudSid= olc.get_running_app= GET_RUNNING_APP pms_p.resort= RESORT pms_p.cro_resort= CRO_RESORT sc.get_sfa_name= GET_SFA_NAME SET_CLIENT_INFO pms_p.date_format= OPERA_LDAP DOMAIN DATE_FORMAT Error occured setting P_USER: IS_LDAP after util_rep.init: util_rep.get_rep_time= SET_MODULE DBMS_APPLICATION_INFO SYS OR_ -BD: BUSINESS_DATE | |{ } before TraceOn: vSid= vSerial#= instance= USERENV ALTER SESSION SET TRACEFILE_IDENTIFIER = ' GEN_UTIL TRACEON OPERA_UTIL _ GET_ADDONS GET_PARAMETER USER_LANGUAGE SET_LOGIN_LANGUAGE SET_TERMINAL RESET LOAD_APP_PARAMS SET_FORCE_MASKING CC_UTIL FIN_TRX_I SET_REP_CURRENCY REP_RESV_STATISTICS CURRENCY SET_BATCH_FOLIO_YN SAVE OTM OU_ Initialize FAILURE FRM_SID after alter session P_BUSINESS_DATE ORS p_user N *ERROR*,E INSTANCE MM/DD/YYYY before getSidInfo populate parameters LOGIN_LANGUAGE _STATION_ID_ after Populate_Labels end of init_report BATCH_YN after traceon INIT_REPORT_WITH_BD
GETSIDINFO CDEBUG CHECKIFTRACEENABLED @ xo
REP_REFV46_MASTERGET_REPORT_PARAMETER REP_REF 4 w
OPERA_LDAPV46_MASTERDOMAIN P r v0808t ^ ^ 1
$ ^g BUILD_WHERE build_where ) ͫͫͫͫͫͫͫ $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8 "BUILD_WHERE"" N $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8
J "BUILD_WHERE""
) - . 0 2 4 8 : h U O
d W plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings" " 2"INTERPRETED"TRUE"BYTE"BYTE" ͫͫͫͫͫͫͫ
H
lsql , T l BUILD_WHERE BUILD_WHERE @ @ nt 0800 $z @ 8000 . 8000 / AC 8000 0 8000 1 8000 2 8000 3 8000 4 8000 5 8000 6 8000 7 8000 8 8000 9 8000 : 8000 ; 8000 < OP 8000 = on*/;
YES
F 0 80 & p 80 ^ 80 80 80 80 > @ 80 v p 80 80 80 80 V ` | r v0808t ^ ^ 1
$ ^g PROC_FILTER proc_filter ) ͫͫͫͫͫͫͫ $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8 "PROC_FILTER"" N $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8
J "PROC_FILTER""
) - . 0 2 4 8 : h U O
d W plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings" " 2"INTERPRETED"TRUE"BYTE"BYTE" ͫͫͫͫͫͫͫ
H
lsql , T l PROC_FILTER PROC_FILTER @ @ 5g0b0 @ (00x "$% &@
r50g0b0 (00x "$% & r75g0b0 (00x "$% &0 r88g0b0 (00x "$% &
r100g0b0 (00x!" $ & r0g0b50 *00x "$ & ( r25g0b50@ *00x "$ & (0 r50g0b50 *00x "$ & ( r75g0b50 0 *00x "$ & ( r88g0b50 ,00x $& ( *0 r100g0b50 (00x!" $ & r0g0b75 *00x "$ & ( r25g0b75@ *00x "$ & (0 r50g0b75 *00x "$ & ( r75g0b75 p *00x "$ & ( r88g0b75 ,00x $& ( * r100g0b75 (00x!" $ & r0g0b88 *00x "$ & ( r25g0b88@ *00x "$ & ( r50g0b88 *00x "$ & ( r75g0b88 *00x "$ & ( 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 " $ & + gray76=p=p=p (00x " $ & , gray72GGG (00x " $ & - gray68QQQ '00x! "$ % . r0g25b0 @ )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@ p l 1
$" zg P_CHAR_FROM_DATEVALIDTRIGGER p_char_from_datevalidtrigger ͫͫͫͫͫͫͫ xg SYS STANDARD p <<
IBISSAMARA DUAL
xl) PUBLIC DUAL xl) SYS DUAL PMS_P
xp
4
IBISSAMARA 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 D
( g\ # $
" ! $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8 / z z z z O A e :
) ) , A 4 e
A A e e A e e e e A A e "P_CHAR_FROM_DATEVALIDTRIGGER"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"" ~
) - . 2 4 ; ? B K P Q X _ c d i p w { |
#$)-0467<@PRVY]_cglnrt h , Q | . | .
k . Z e S k k Q n | . W Z e Z e < Q c c . ` . ` Q c
. * * * * * ( . .
< > @
* . . L 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 , > . d W plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings" " 2"INTERPRETED"TRUE"BYTE"BYTE" ͫͫͫͫͫͫͫ
H l s lsql T (f _ "
_ "
k g X
N V @ x } k g 8N V u 1 t c } . } \ $ T
Invalid from date. The format is ( P_CHAR_FROM_DATEVALIDTRIGGER
P_CHAR_FROM_DATEVALIDTRIGGER B 0
D
A A D 0 A $ F
$ 2 SELECT PMS_P.DATE_FORMAT FROM DUAL "SELECT TO_DATE (:1 , PMS_P.DATE_FORMAT ) FROM DUAL " s 0 4 8 $ < 0 @ < D H H T L ` P l h ! g @ @ , ./01 TOOL_MODULE CREATE_DATE 1 p p* ,-./ TOOL_MODULE CREATE_VER ( / p p( *+,- TOOL_MODULE
MODIFIER / p p( *+,- TOOL_MODULE MOD_DATE / p p( *+,- TOOL_MODULE MOD_VER ( 1 p p* ,-./ TOOL_MODULE
COPYRIGHT ( -/ p p( *+,- TOOL_MODULE REQ_ROLE / p p( *+,- TOOL_MODULE VGS_VER ( - p p& ()*+ TOOL_MODULE DE_VER ( / p p( *+,- TOOL_MODULE ROS_VER ( ( + p p$ &'() TOOL_PLSQL MODID ( + p p$ &'() TOOL_PLSQL NAME p + p p$ &'() TOOL_PLSQL TYPE + p p$ &'() TOOL_PLSQL OWNER p - p p& ()*+ TOOL_PLSQL ITEMID p @ 801 p p* ,-./ TOOL_PLSQL PLSLFID_EP 1 p p* ,-./ TOOL_PLSQL PLSLFID_ST @ 0 0800 :( 0 P 0800 ` 0800 W/ p 0800
0800 3 0800 0800 , 0@00* & 0 0800 f @ 0800
R 0800 7 @ 0800 P 0800
` *:JR^(bcffmnnuvvvz(~ PL/SQL DE` PL/SQL Library MINGUS rep_genr xp 2 xp
9 (p!"p.@2607 ADD_FILTER MINGUS u 9 (p$%p.@2607 ADD_TO_FILTER MINGUS u = (p'(p2@6:0; CURRENCY_DIVISOR MINGUS u
= (p'(p2@6:0; CURRENCY_DIVISOR MINGUS <u
9 (p&'p.@2607 DIVIDE_NON_ZERO MINGUS u 9 (p!"p.@2607 END_REPORT MINGUS u 5 (p"#p*@.203 GET_REP_LBL MINGUS u 5 (p"#p*@.203 INIT_REPORT MINGUS u ? = (p*+p2@6:0; INIT_REPORT_WITH_BD MINGUS u 5 (p p*@.203 LABELS MINGUS < u 9 (p&'p.@2607 POPULATE_LABELS MINGUS u 5 (p p*@.203 UTIL_REP MINGUS u 5 (p p*@.203 UTIL_REP MINGUS u
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 , > . d W plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings" " 2"INTERPRETED"TRUE"BYTE"BYTE" ͫͫͫͫͫͫͫ
H
l 1
$" bg P_CHAR_TO_DATEVALIDTRIGGER p_char_to_datevalidtrigger ͫͫͫͫͫͫͫ xg SYS STANDARD p <<
IBISSAMARA DUAL
xl) PUBLIC DUAL xl) SYS DUAL PMS_P
xp
4
IBISSAMARA 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 D
( g\
# $
" ! $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8 / z z z z O A e :
) ) , A 4 e
A A e e A e e e e A A e "P_CHAR_TO_DATEVALIDTRIGGER"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"" ~
) - . 2 4 ; ? B K P Q X _ c d i p w { |
#$)-0467<@PRVY]_cglnrt h , Q | . | .
k . Z e S k k Q n | . W Z e Z e < Q c c . ` . ` Q c
, ' ' ' ' ' & , ,
: < :
' , , L 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 , > . d W plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings" " 2"INTERPRETED"TRUE"BYTE"BYTE" ͫͫͫͫͫͫͫ
H l s lsql T $f _
"
_ "
k g V
N
V @ x } k g 7N V u 1 t c } . } T L
Invalid to date. The format is ( P_CHAR_TO_DATEVALIDTRIGGER
P_CHAR_TO_DATEVALIDTRIGGER B 0
D
A A D 0 A $ F
$ 2 SELECT PMS_P.DATE_FORMAT FROM DUAL "SELECT TO_DATE (:1 , PMS_P.DATE_FORMAT ) FROM DUAL " s 0 4 8 $ < 0 @ < D H H T L ` P l h g
@ @ begin
if apply_xml then
-- apply XML script
srw.set_xml_prolog(srw.text_escape,xml_prolog);
SRW.ADD_DEFINITION(l_xml);
SRW.APPLY_DEFINITION;
end if;
exception
when others then
srw.message(200,'Error - '||sqlerrm);
end;
g_xml_code := NULL;
apply_xml:= FALSE;
END IF;
END;
-- Add another translation item (boilerplate text) to the XML text. There seems to be a
-- size limit for the length of XML code you can add therefore we check the size of
-- the g_xml_code string plus the new string and if it gets too long we apply the XML code.
-- The size limit for g_xml_code seems to be at 16384. We use 15500 minus the length of the
-- report name because we need some additional room for report name and some additional
-- XML code etc. -- CHH 11-MAR-03 #52103
PROCEDURE add_xml_code(in_object_name IN VARCHAR2,
in_text IN VARCHAR2 ) IS
l_xml VARCHAR2(32000);
BEGIN
IF in_object_name IS NOT NULL AND in_text IS NOT NULL THEN
l_xml := l_xml || '';
IF LENGTHB(g_xml_code) + LENGTHB(l_xml) + LENGTHB(in_rep_name) > 15500 THEN
apply_xml_code;
END IF;
g_xml_code := g_xml_code || l_xml;
apply_xml:= true;
END IF;
END;
BEGIN
-- build XML script to change boilerplate text
-- also populate labels.label_table ('old' p_rep_lbl translation method)
-- If the user language is english there is nothing to translate
If in_rep_name is not null and pms_p.user_language != 'E' then
-- get the client character set
tool_env.getvar( 'NLS_LANG', v_client_char_set );
v_client_char_set := RTRIM(nvl( substr( v_client_char_set, instr( v_client_char_set, '.' ) + 1 ), 'UTF8' )); -- added RTRIM and util_rep.print_debug_message -- CHH 14-SEP-07 #112292
util_rep.print_debug_message('populate_labels; v_client_char_set='||v_client_char_set);
--
For i in c1(v_client_char_set) Loop
v_counter := v_counter + 1;
v_dum := rtrim(ltrim(lower(in_rep_name)))||'.p_rep_lbl';
If instr(lower(i.term_code),v_dum) > 0 then
-- add term_code and term_text to index-by table used with 'old' p_rep_lbl translation method
labels.label_table(v_counter).param_name := i.term_code; --Substr(i.term_code,instr(i.term_code,'.')+1);
labels.label_table(v_counter).lbl_text := i.term_text;
Else
-- add XML code to change the boilerplate text
if i.term_code is not null and i.term_text is not null then
-- the XML code has to use UTF8 character set, therefore if the client character set
-- is not UTF8 we have to convert into UTF8
if v_client_char_set r 0808 p p 1
$ pg TEMPLATE_HINTS template_hints ) ͫͫͫͫͫͫͫ $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8 "TEMPLATE_HINTS"" N # $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8
J "TEMPLATE_HINTS""
) - . 0 2 4 8 : h U O #
# d W plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings" " 2"INTERPRETED"TRUE"BYTE"BYTE" ͫͫͫͫͫͫͫ
H
lsql , T p TEMPLATE_HINTS TEMPLATE_HINTS @ @ 0800 z p 0800 b _LIBRARY hh %TOOL_MODULE hh TOOL_PLSQL $pp "VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID R@ +pp $&'( )VG_COLOR CELLID R@ -pp &()* +VG_COLOR NAME_SET @ 75g /pp (*+, -VG_COLOR NAME_LENGTH 0 /pp (*+, -VG_COLOR COLOR_NAME x 'pp "#$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE ( x & " g eConf No % x # g eRoom 88g + x )0 g eGuest Name 0 ' x %0 g eWindow , x *0 g eTrans. Date * x (0 g
eTrx. Code 0g , x *0 g eDescription / x -0 g ePayment Amount 8 ' x % g eFilter 0 D x B0 g$ ePage & of & 8 x 610K g eWindow &window balance: " r50g0b100 ,00x $& ( * # r75g0b100 ,00x $& ( * $ r88g0b100 ,00x $& ( * %
r100g0b100 &00x " $ & gray *00x " $ & ( ' darkgray &00x " $ ( cyan r *00x" $ & ( ) darkcyan (00x " $ & * gray80333333 (00x " $ & + gray76=p=p=p (00x " $ & , gray72GGG (00x " $ & - gray68QQQ '00x! "$ % . r0g25b0 @ )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@ l 1
$" g BEFOREPFORM beforepform d e ͫͫͫͫͫͫͫ xg 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 <
( gl ! "
$ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8 / / / / ` A A e e A A e e A A e e A A e e l "BEFOREPFORM"BOOLEAN"INIT_REPORT"P_REPORT_NAME""P_USER"P_PASSWORD"P_RESORT"P_BUSINESS_DATE"TRUE"2000"20"40""
) - . 2 4 8 ? F M T [ b i p w ~ h , W Z e Q c Q c Q c Q c
) ) 6 6 A A
/ $
$ (
(
, , - - .
g g "
# # ! g
& ' ' % g
( * + + )
4 d
W plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings" " 2"INTERPRETED"TRUE"BYTE"BYTE" ͫͫͫͫͫͫͫ
H R R C H lsql D j T f _ _ _
_ _ t } BEFOREPFORM BEFOREPFORM D D 0 D 0 D ( D A < C , 0 4 $ 8 0 < < @
@ @ | Q .
. . . | n .
k . . | Q . k A k k
k A k k
k | . k | .
| n . k n .
k
< k W < < G W < c c Q c c . Q c Q c Q c ` c c c Q c Q c Q c Q c Q c Q c . c Q c Q c Q c Q c Q c Q c Q c . Q c Q c Q c Q c Q c Q c Q c Q c
" " " " " " " " " # # # # # # $ $ $ $ $ ' ( ( ( ( ( ( ( ( ( ( ( ' ' ' & + + + , , , l 1
$ g
AFTERPFORM
afterpform ͫͫͫͫͫͫͫ xg SYS STANDARD $/Namespace0004/INITIALIZE_PARAMETERS /Namespace0004/BUILD_WHERE /Namespace0004/BUILD_ORDER_BY /Namespace0004/PROC_FILTER $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8 # "AFTERPFORM"_return"" t & $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8 $ W "AFTERPFORM"BOOLEAN"INITIALIZE_PARAMETERS"BUILD_WHERE"BUILD_ORDER_BY"PROC_FILTER"TRUE""
) - . 2 4 8 = > B G H L Q R V [ \ ` c g i m o h , W W W W Z e
/
d W plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings" " 2"INTERPRETED"TRUE"BYTE"BYTE" ͫͫͫͫͫͫͫ
H ( ( lsql 0 T | } 8
AFTERPFORM t
AFTERPFORM , @ @ ! ! / / / R R R @ o o o
5 5 5
# # & 9 9 9 J J J / D ( ( 9 9 9 6 Y Y Y ? ? $ g g g
/ / /
' % ( ( ( o H /
}
# # $
! $ $ & # $
) * ( , ) * 3 g - e / . - 1 0 / 2 . 1 4 . : > 5 6 @ 6 ! A B " # # G ` a g $ % & % J M ' %' K O ( & ) * + , R T * S V - *P X W . / 0 ! - ! - [ ] 1 .Y _ ^ 2 E H b 7 c f - 3 g 0 g i f h - e g g " m 3
4k D 56D o m 2 # s 7 $ 8( q E 9:E u s 4 % x v / w & | v ; < }z F =>F ~ | 6 ' ? 8 @ G& y & y & y ( A ) J ) : B K( C = D L( E * O * @ F P & y & y ( G + S + C H T & y & y ( I F J U & y & y ( K , X , I L Y & y & y ( M - \ - L N ] ' . O / P . Q 0 R S O ^ . T 1 U & y R _ . V 2 W ` l 1
$" xg B_FILTER_SEC2FORMATTRIGGER B ͫͫͫͫͫͫͫ xg SYS STANDARD $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8 8 / "B_FILTER_SEC2FORMATTRIGGER":P_FILTER"_return"" " # % ) - 3 4 . g
$ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8
! ! ! ! 8 '
A A e e G "B_FILTER_SEC2FORMATTRIGGER"BOOLEAN"P_FILTER""IS NULL"FALSE"TRUE"2000"" f
) - . 2 4 ; B F G L O S V Z \ ` e i l p r v x h , | . Z Z e < Z e Q c
,
g
d
W plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings" " 2"INTERPRETED"TRUE"BYTE"BYTE" ͫͫͫͫͫͫͫ
H 0 0 lsql 4 H T f _ "
} } ( B_FILTER_SEC2FORMATTRIGGER B_FILTER_SEC2FORMATTRIGGER D , 0 @ @ < ʀ' ˀ ̀ ̀ # p E π Ѐ S < р # p Ҁ S < Ӏ
e 6 S 9 Ԁ
h i j % v r & n ( * o H Հ ր Z ׀& ! " ـڀ" " ۀ 57U (܀ ) :[ ݀ +ހ , ߀, =\ / 0 0 \ 2 3 3 @DQ c : 4 I= 5 K@ C MC D O l r { V] H I I X[^ M N N ^_ Q R R ad` V W W ga Z [ [ jmp b a b
b e f ru
xz] l m m |c q r r ` u v v Z & y z z ] ~ ! d "
# $% a & ' () l* O + , -. b / 0 12 O 3 4 56 \ 7 8 9: e ;# < => f ?
@ AB \ C D EF \ G H IJ ' . 1 ; < = 7 8 9 ? 4 5 C D F L I N Q ' Z \ d j p y l 1
$" g CF_LOGOFORMULA B ͫͫͫͫͫͫͫ xg SYS STANDARD $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8 = # "CF_LOGOFORMULA":P_RESORT"_return"" " # % ) - 3 7 9 & ( g$
g
$ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8
4 4 e A A e e A A e - "CF_LOGOFORMULA"CHAR"P_RESORT""||".gif"40"4"" &
) - . 2 4 ; B F K L Q U W [ ] m q t z h , | n . e Q c Q c
g (
d
W plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings" " 2"INTERPRETED"TRUE"BYTE"BYTE" ͫͫͫͫͫͫͫ
H ( ( lsql 4 T f _ 1 { .gif CF_LOGOFORMULA ` h | CF_LOGOFORMULA D ( , g @ @ W ( V T f W "
W u W 1
1 W 1 1 1 W K
B B W t c ? r c : c < ! 0! ,U X 1 t c . W W K} T f "
"
1 1 1 1 1 W D D
W D
6 ! W 1
W K}
% >! ?ئ h ,
v T
: < ? 8 Error - USER_LANGUAGE PMS_P . populate_labels; v_client_char_set= UTF8 .p_rep_lbl NLS_LANG UTF8 APPLY_XML_CODE ADD_XML_CODE C1 POPULATE_LABELS ou{< ADD_XML_CODE
# E ë-69?0* = # POPULATE_LABELS 4 & xo '
PMS_PV46_MASTERUSER_LANGUAGE PMS_P KQ]Wci3!$'?B x V APPLY_XML_CODE q C1 /& ) *
& ) *
\ 4 H
l 1
$" Ng R_WINDOWFORMATTRIGGER
S ͫͫͫͫͫͫͫ xg SYS STANDARD SRW $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8 4 * "R_WINDOWFORMATTRIGGER":CP_COLOR"_return"" ! % ) / 0
4
$ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8 0 Z Z Z Z 1 l 9 l 9 A A e A A e A A e A A e A A e A A e { "R_WINDOWFORMATTRIGGER"BOOLEAN"CP_COLOR""="1"SRW"SET_FOREGROUND_FILL_COLOR"gray16"SET_FILL_PATTERN"solid"TRUE"0"white"6"5"" P
) - . 2 4 ; B F K L Q T X \ _ d e j n r u z { &/039BCFLUVY_hilr{| 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 d
W plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings" " 2"INTERPRETED"TRUE"BYTE"BYTE" ͫͫͫͫͫͫͫ
H lsql d
T f _ < 6 6r c r c } _ < 6 6r
c r c } } h ` 1 0 gray16 white solid $ R_WINDOWFORMATTRIGGER * $ X R_WINDOWFORMATTRIGGER A$ A , 0 4 $ 8 0 < < @ H D g` H gx L g T g \ g @ @ PMS_P # E ɫ-96?0' = # t POPULATE_LABELS ou{B C ADD_XML_CODE K]WQci3!$*?< x [ APPLY_XML_CODE /& ) *
& ) *
\ 4 H
l 1
$" g CF_COLORFORMULA B ͫͫͫͫͫͫͫ xg SYS STANDARD $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8
3 $ "CF_COLORFORMULA":CP_COLOR"_return"" ! % ) /
P
,
$ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8 ' ' ' ' @ l A A A A A A e ) "CF_COLORFORMULA"NUMBER"CP_COLOR""="1"0""
) - . 2 4 ; B F K L Q T [ ^ b d k n r t x | h , | n . Z Q
Q
< Q Z e Q c
! !
! "
" %
& "
"
! !
!
! ! ! !
# $
$
d
W plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings" " 2"INTERPRETED"TRUE"BYTE"BYTE" ͫͫͫͫͫͫͫ
H R R & 0 lsql ` T f _ < $ $ ! ?0 ( 1 CF_COLORFORMULA P CF_COLORFORMULA A$ A & , D \ g @ @
4 d
W plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings" " 2"INTERPRETED"TRUE"BYTE"BYTE" ͫͫͫͫͫͫͫ
H R R C H lsql D j T f _ _ _
_ _ t } BEFOREPFORM BEFOREPFORM D D 0 D 0 D ( D A < C , 0 4 $ 8 0 < < @
@ @
K ~ FGp^_b(fpfpf0g0j@n8pqrst0u0v0w0x0y0z{0|0}~p M_G_resv_name_id_GRPFR 00CF FGp\]^ `pbpb0c0f@j8lmnop0q0r0s0t0u0vw0x0yz{|}~p M_G_resv_name_id_HDR ` 00 ~ FGpXYZ(^p^p^0`8b@f8hijkl0m0n0o0p0q0rs0t0uvwxyz{|p| R_G_resv_name_id 0`R0 X FGpabf(jpjpj8l8n@r8tuvwx0y0z0{0|0}0~00p M_G_confirmation_no_GRPFR 0 bA 3 h F HpR TZ(^p^p^8`8b@f8hj lmn0o0p0q0r0s0tu0v0wxyz{|}~p~ $R_window mon_no 0 {'
0# window rwbwrg window l 1
$" 7g CF_WIN_BALANCEFORMULA p ͫͫͫͫͫͫͫ xg SYS STANDARD xp
.$
IBISSAMARA 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
P
,
( g8 | $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ
8 ' U U U U s >
N A ]
& A _ z l l A A e e "CF_WIN_BALANCEFORMULA"NUMBER"RET"SUM"NVL"GUEST_ACCOUNT_DEBIT"0"-"GUEST_ACCOUNT_CREDIT"FINANCIAL_TRANSACTIONS"RESORT"P_RESORT""="RESV_NAME_ID"FOLIO_VIEW"WINDOW"40""
) - . 2 4 ; ? H M N Q U Y \ ] b f j m q u x y ~ (,/5>GPQRSTUVfkr 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 d , & 4 W plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings" " 2"INTERPRETED"TRUE"BYTE"BYTE" ͫͫͫͫͫͫͫ
H R R lsql 8 V T f k g 0 N V H @ $ CF_WIN_BALANCEFORMULA CF_WIN_BALANCEFORMULA A$
D ( D A$ A ( < SELECT SUM (NVL(GUEST_ACCOUNT_DEBIT , 0 ) ) - SUM (NVL(GUEST_ACCOUNT_CREDIT , 0 ) ) FROM FINANCIAL_TRANSACTIONS WHERE RESORT = :1 AND RESV_NAME_ID = :1 AND FOLIO_VIEW = :1 " 0 4 @ @ F HpR TZ(^p^p^8`8b@f8hj lmn0o0p0q0r0s0tu0v0wxyz{|}~p~ $R_window mon_no 0 {'
0# ) m & ' 0 r 1p"&'*. /proc_filter ara {0| 1p"&'*. /template_hints 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
0 9 p& *,26 7cf_logoformula mat
= p* .06: ;7r_windowformattrigger $ z| 9 p& *,26 7;cf_colorformula ig : $ t_D = p* .06: ;Dcf_win_balanceformula C % U
p p,p=JKL0M0NOPQR Skresv_name_id rn1.resv_name_id RESV_NAME_ID g C2 ^
p p/pCSTU0V0WXYZ[ \nconfirmation_no rn1.confirmation_no CONFIRMATION_NO 2 g p =
p p$p-2340506789: ;qroom ft1.room ROOM g A s
p p*p]hij0k0lmnop qtguest_name rn1.guest_first_name || ' ' || rn1.guest_last_name GUEST_NAME g O G
p p&p5<=>0?0@ABCD Ewwindow ft1.folio_view WINDOW g r 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 wx 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; B E I K O Q a h , W Z e
/
d W plsql_optimize_level"plsql_code_type"plsql_debug"nls_length_semantics"plsql_warnings" " 2"INTERPRETED"TRUE"BYTE"BYTE" ͫͫͫͫͫͫͫ
H lsql 0 T | } AFTERREPORT t AFTERREPORT , @ @ }p} 0800 0800 0800
x 0800 0800 N 0800 0800 7 o0808m W Wselect
rn1.resv_name_id,
rn1.confirmation_no,
ft1.room,
rn1.guest_first_name||' '||rn1.guest_last_name as guest_name,
ft1.folio_view as window,
ft1.trx_date,
ft1.trx_code,
tc1.description,
ft1.trx_amount
from
financial_transactions ft1,
trx$_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 RUNONLYh md_hrs_open_payments 4 R d
" h "
0000pppppppp 5ORIENTATION Portrait P Orientation
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$s6(:CP_color = '1') 31 [[ \% .0 2(6:p; NPpQpSSTUpVpVVWXpYpYY Z$s9 (: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@ P r 1 fphwxyz{|ppp000000pppppppp P_CHAR_TO_DATE N
P_CHAR_TO_DATE _R 1 fphpqrstupvvpwpwwxy z|0}0~8888pppppppp CF_logo
P
U Uf CF_LOGO E 1 fphqr tvwxp~~pp000000pppppppp CP_color # P
1
CP_COLOR 1 fphqr tvwxp~~pp000000pppppppp CF_color # P
CF_COLOR 1 fphwx z|}~ppp000000pppppppp CF_win_balance # " CF_WIN_BALANCE . bpdvw(zp~p~8~088x000000p0ppp pB_confirmation_no 0 0T0` 0 0 ` RUE p l . bpdkl(rpvpv8v0x8z8|~x000000p0ppp serB_room ation0 0 ` T0` 0 ` 0 H . bpdqr(vpzpz8z0|8~8x000000p0ppp } tB_guest_name 00 (00@t` (0 0 @t ` . bpdmn(rpvpv8v0x8z8|~x000000p0ppp vB_window e 0 j 00 ` j 0 ` ` D 0 . bpdop(vpzpz8z0|8~8x000000p0ppp NxB_trx_date 00 ~P0` j ~P 0 ` D t
rn1.resv_name_id,
rn1.confirmation_no,
ft1.room,
rn1.guest_first_name||' '||rn1.guest_last_name as guest_name,
ft1.folio_view as window,
ft1.trx_date,
ft1.trx_code,
tc1.description,
ft1.trx_amount
from
financial_transactions ft1,
trx$_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 RUNONLYh md_hrs_open_payments 4 R d
" h "
0000pppppppp 5ORIENTATION Portrait P Orientation
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$s6(:CP_color = '1') 31 [[ \% .0 2(6:p; NPpQpSSTUpVpVVWXpYpYY Z$s9 (: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 r . bpdop(vpzpz@z0~88x000000p0ppp zB_trx_code 00 0 ` j 0 ` tu . bpdrs(vpzpz@z0~88x000000p0ppp
|B_description
00 0. ` j 0 . ` . bpdqr(vpzpz@z0~88x000000p0ppp ~B_trx_amount
00 0"` j 0 " ` $ . bpdrs(vpzpz8z@~88x000000p0ppp |B_FILTER_SEC2 00 0 A @ A @ # . bpdwx(~pp8@88x000000p0ppp 0B_PAGE_NUMBER_SEC2 0 0 o AFP
A o A FP
D RUE . bpd hj(nprpr8r8t@v0z{|}x~000000p0ppp B_1
NUM
. bpdhi(jpnpn8n8p8r8tvwxx~000000p0ppp 0$B_2 " " $
d
`
K ` FpH_`(fpjpj0j0k@n8rtuvw0x0y0z0{0|0}~00p 8zaM_G_resv_name_id_GRPFR p 0 0in FpH]^ `pbpb0b0c@f8jlmno0p0q0r0s0t0uv0w0xyz{|}~p cM_G_resv_name_id_HDR ` 0 e_ FpHYZ(^pbpb0b8d@f8jlmno0p0q0r0s0t0uv0w0xyz{|}~p esdR_G_resv_name_id R 0 ` R 0X t1 FpHbc(fpjpj8j8l@n8rtuvw0x0y0z0{0|0}~00p ankM_G_confirmation_no_GRPFR R0 b A3 h he FpH RT(Zp^p^8^8`@b8fh jlm0n0o0p0q0r0st0u0vwxyz{|}p~ ~d R_window rion_n0 { '
0# 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 RUNONLYh md_hrs_open_payments 4 R d
" h "
0000pppppppp 5ORIENTATION Portrait P Orientation
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$s6(:CP_color = '1') 31 [[ \% .0 2(6:p; NPpQpSSTUpVpVVWXpYpYY Z$s9 (: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@