PACKAGE: APPS.XTR_XTRCFACC_XMLP_PKG

Source

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