PACKAGE: APPS.XTR_XTRCFCON_XMLP_PKG

Source

1 PACKAGE XTR_XTRCFCON_XMLP_PKG AS
2 /* $Header: XTRCFCONS.pls 120.1 2007/12/28 12:46:41 npannamp noship $ */
3   REPORT_DATE2 DATE;
4 
5   REPORT_SHORT_NAME VARCHAR2(240);
6 
7   USE_DEFAULTS VARCHAR2(1);
8 
9   CURRENCY_CODE VARCHAR2(15);
10 
11   DAY_WEEK_MONTH VARCHAR2(1);
12 
13   SETTLE_FROM_DATE DATE;
14 
15   SETTLE_TO_DATE DATE;
16 
17   EXP_TYPES VARCHAR2(40);
18 
19   INCL_CCY_OPT VARCHAR2(40);
20 
21   Z2CASHFLOWS VARCHAR2(100);
22 
23   Z2NET_EXPOSURE VARCHAR2(100);
24 
25   Z1TO VARCHAR2(100);
26 
27   Z2NET_CASHFLOW VARCHAR2(100);
28 
29   Z2NUMBER_OF VARCHAR2(100);
30 
31   Z2AC_BALANCE VARCHAR2(100);
32 
33   Z1SUMMARISE_BY_DAY_WEEK_MONTH VARCHAR2(100);
34 
35   Z1EXP_TYPES VARCHAR2(100);
36 
37   Z1PARAMETERS VARCHAR2(100);
38 
39   Z1CURRENCY VARCHAR2(100);
40 
41   Z1INCLUDE_CCY_OPTION VARCHAR2(100);
42 
43   Z2CCY VARCHAR2(100);
44 
45   Z2DATE_OR VARCHAR2(100);
46 
47   Z2WEEK_MONTH VARCHAR2(100);
48 
49   Z2ENDING VARCHAR2(100);
50 
51   Z2NET_TOTALS VARCHAR2(100);
52 
53   Z2CURRENT_CASH_DEPOSITS VARCHAR2(600);
54 
55   Z2NET_FX VARCHAR2(100);
56 
57   Z2NET_MM VARCHAR2(100);
58 
59   Z1SUMMARISED VARCHAR2(100);
60 
61   Z1SETTLE_FROM VARCHAR2(100);
62 
63   Z2END_OF_REPORT VARCHAR2(100);
64 
65   Z2PAGE VARCHAR2(100);
66 
67   P_CURRENCY VARCHAR2(15);
68 
69   P_EXPOSURE_TYPE VARCHAR2(40);
70 
71   P_INCLUDE_FX_OPTION_BUY_SELL VARCHAR2(40);
72 
73   P_SUMMARIZE_BY VARCHAR2(10);
74 
75   P_PERIOD_FROM DATE;
76 
77   P_PERIOD_TO DATE;
78 
79   P_SQL_TRACE VARCHAR2(32767);
80 
81   P_DISPLAY_DEBUG VARCHAR2(32767);
82 
83   CURRENCY2 VARCHAR2(15);
84 
85   EXP_TYPES2 VARCHAR2(40);
86 
87   INCL_CCY_OPT2 VARCHAR2(40);
88 
89   DAY_WEEK_MONTH2 VARCHAR2(10);
90 
91   SETTLE_FROM_DATE2 DATE;
92 
93   SETTLE_TO_DATE2 DATE;
94 
95   P_CONC_REQUEST_ID NUMBER;
96 
97   COMPANY_NAME_HEADER VARCHAR2(80);
98 
99   REPORT_SHORT_NAME2 VARCHAR2(240);
100 
101   REPORT_DATE VARCHAR2(100);
102 
103   P_1 VARCHAR2(1000):=' ';
104 
105   Z1INCL_IND_EXP VARCHAR2(100);
106 
107   P_FACTOR VARCHAR2(10);
108 
109   AMT_UNIT2 NUMBER;
110 
111   L_AMT_UNIT2 NUMBER;
112 
113   LP_FACTOR_DESC VARCHAR2(100);
114 
115   Z1P_FACTOR VARCHAR2(100);
116 
117   ZRCURRENT_CASH_DEPOSIT NUMBER;
118 
119   Z2CURRENT_CASH_DEPOSITS_MSG VARCHAR2(2000);
120 
121   OPEN_BAL NUMBER;
122 
123   ROLLING_BAL NUMBER;
124 
125   CP_PARA VARCHAR2(32767);
126 
127   LP_PERIOD_FROM varchar2(20);
128 
129   LP_PERIOD_TO varchar2(20);
130 
131   FUNCTION ROLLING_BAL1FORMULA RETURN VARCHAR2;
132 
133   FUNCTION ROLLING_BALFORMULA RETURN NUMBER;
134 
135   FUNCTION OPEN_BAL1FORMULA(ccy varchar2) RETURN VARCHAR2;
136 
137   FUNCTION OPEN_BALFORMULA RETURN NUMBER;
138 
139   FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
140 
141   FUNCTION BEFOREREPORT RETURN BOOLEAN;
142 
143   FUNCTION AFTERPFORM RETURN BOOLEAN;
144 
145   FUNCTION AFTERREPORT RETURN BOOLEAN;
146 
147   FUNCTION BEFOREPFORM RETURN BOOLEAN;
148 
149   FUNCTION BETWEENPAGE RETURN BOOLEAN;
150 
151   FUNCTION OPEN_BAL_P RETURN NUMBER;
152 
153   FUNCTION ROLLING_BAL_P RETURN NUMBER;
154 
155   FUNCTION CP_PARA_P RETURN VARCHAR2;
156 
157 END XTR_XTRCFCON_XMLP_PKG;
158