DBA Data[Home] [Help]

PACKAGE: APPS.XTR_XTRSESTA_XMLP_PKG

Source


1 PACKAGE XTR_XTRSESTA_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRSESTAS.pls 120.1 2007/12/28 12:59:34 npannamp noship $ */
3   REPORT_NOS VARCHAR2(30);
4 
5   REPORT_SHORT_NAME VARCHAR2(80);
6 
7   REPORT_GROUP VARCHAR2(32767);
8 
9   USE_DEFAULTS VARCHAR2(1);
10 
11   VERSION_NUM NUMBER;
12 
13   COMPANY_CODE VARCHAR2(7);
14 
15   CURRENCY_CODE VARCHAR2(15);
16 
17   ACCOUNT_NO VARCHAR2(32767);
18 
19   FROM_DATE DATE;
20 
21   TO_DATE_1 DATE;
22 
23   AUTH_UNAUTH VARCHAR2(12);
24 
25   BENEFICIARY VARCHAR2(7);
26 
27   Z2ACCOUNT_NUMBER VARCHAR2(100);
28 
29   Z2NUMBER VARCHAR2(100);
30 
31   Z2AMOUNT VARCHAR2(100);
32 
33   Z2SETTLEMENT VARCHAR2(100);
34 
35   Z2AUTHORISED VARCHAR2(100);
36 
37   Z2USER VARCHAR2(100);
38 
39   Z2SET VARCHAR2(100);
40 
41   Z2BY VARCHAR2(100);
42 
43   Z1PARAMETERS VARCHAR2(100);
44 
45   Z1COMPANY_CODE VARCHAR2(100);
46 
47   Z1SETTLEMENTS_FROM VARCHAR2(100);
48 
49   Z1TO VARCHAR2(100);
50 
51   Z1CURRENCY VARCHAR2(100);
52 
53   Z1AUTHORISED_UNAUTHORISED_BOTH VARCHAR2(100);
54 
55   Z1ACCOUNT_NOS VARCHAR2(100);
56 
57   Z1BENEFICIARY VARCHAR2(100);
58 
59   Z2COMPANY VARCHAR2(100);
60 
61   Z2CCY VARCHAR2(100);
62 
63   Z2CPARTY VARCHAR2(100);
64 
65   Z2CODE VARCHAR2(100);
66 
67   Z2DEAL VARCHAR2(100);
68 
69   Z2TYPE VARCHAR2(100);
70 
71   Z2SUBTYPE VARCHAR2(100);
72 
73   Z2END_OF_REPORT VARCHAR2(100);
74 
75   Z2PRODUCT VARCHAR2(100);
76 
77   Z2TRANS VARCHAR2(100);
78 
79   Z2BY_USER VARCHAR2(100);
80 
81   Z2PAGE VARCHAR2(100);
82 
83   P_COMPANY VARCHAR2(7);
84 
85   P_CURRENCY VARCHAR2(15);
86 
87   P_BANK_ACCOUNT_NUMBER VARCHAR2(32767);
88 
89   P_SETTLEMENT_DATE_FROM VARCHAR2(32767);
90 
91   P_SETTLEMENT_DATE_TO VARCHAR2(32767);
92 
93   P_AUTH_UNAUTH VARCHAR2(12);
94 
95   P_BENEFICIARY VARCHAR2(7);
96 
97   P_DISPLAY_DEBUG VARCHAR2(32767);
98 
99   P_SQL_TRACE VARCHAR2(32767);
100 
101   COMPANY_NAME_HEADER VARCHAR2(80);
102 
103   COMPANY_CODE2 VARCHAR2(7);
104 
105   CURRENCY_CODE2 VARCHAR2(15);
106 
107   ACCOUNT_NO2 VARCHAR2(32767);
108 
109   FROM_DATE2 DATE;
110 
111   TO_DATE2 DATE;
112 
113   AUTH_UNAUTH2 VARCHAR2(12);
114 
115   BENEFICIARY2 VARCHAR2(7);
116 
117   REPORT_SHORT_NAME2 VARCHAR2(240);
118 
119   P_CONC_REQUEST_ID NUMBER;
120 
121   REPORT_DATE VARCHAR2(100);
122 
123   Z2AMOUNT_DATE VARCHAR2(100);
124 
125   CP_PARA VARCHAR2(32767);
126 
127   FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
128 
129   FUNCTION BEFOREREPORT RETURN BOOLEAN;
130 
131   FUNCTION AFTERREPORT RETURN BOOLEAN;
132 
133   FUNCTION AFTERPFORM RETURN BOOLEAN;
134 
135   FUNCTION BEFOREPFORM RETURN BOOLEAN;
136 
137   FUNCTION BETWEENPAGE RETURN BOOLEAN;
138 
139   FUNCTION CFLOW1FORMULA(CFLOW IN NUMBER
140                         ,CCY IN VARCHAR2) RETURN NUMBER;
141 
142   FUNCTION CP_PARA_P RETURN VARCHAR2;
143 
144 END XTR_XTRSESTA_XMLP_PKG;
145