PACKAGE: APPS.XTR_XTRCFCCY_XMLP_PKG

Source

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