PACKAGE: APPS.XTR_XTRTMAVG_XMLP_PKG

Source

1 PACKAGE XTR_XTRTMAVG_XMLP_PKG AS
2 /* $Header: XTRTMAVGS.pls 120.1 2007/12/28 13:01:40 npannamp noship $ */
3   REPORT_DATE2 DATE;
4 
5   REPORT_NOS VARCHAR2(30);
6 
7   REPORT_SHORT_NAME VARCHAR2(80);
8 
9   REPORT_GROUP VARCHAR2(32767);
10 
11   USE_DEFAULTS VARCHAR2(1);
12 
13   DEAL_SUBTYPE VARCHAR2(7);
14 
15   AS_AT_DATE DATE;
16 
17   Z2AVERAGE_RATE VARCHAR2(100);
18 
19   Z2NAME VARCHAR2(100);
20 
21   Z2INT_RATE VARCHAR2(100);
22 
23   Z2PREV_ROLLOVER VARCHAR2(100);
24 
25   Z2P_I_AMOUNT VARCHAR2(100);
26 
27   Z2ACCRUED_INT VARCHAR2(100);
28 
29   Z2BALANCE VARCHAR2(100);
30 
31   Z2END_OF_REPORT VARCHAR2(100);
32 
33   Z1PARAMETERS VARCHAR2(100);
34 
35   Z1SUBTYPE VARCHAR2(100);
36 
37   Z1PRODUCT_TYPE VARCHAR2(100);
38 
39   Z1AS_AT_DATE VARCHAR2(100);
40 
41   Z1SHOW_DETAILS VARCHAR2(100);
42 
43   Z2DEP_ADV VARCHAR2(100);
44 
45   Z2PRODUCT VARCHAR2(100);
46 
47   Z2CCY VARCHAR2(100);
48 
49   Z2NOS_TRANS VARCHAR2(100);
50 
51   Z2TOTAL_OUTSTANDINGS VARCHAR2(100);
52 
53   Z2AVERAGE_BALANCE VARCHAR2(100);
54 
55   Z2DEAL_NOS VARCHAR2(100);
56 
57   Z2TRANS_NOS VARCHAR2(100);
58 
59   Z2CLIENT VARCHAR2(100);
60 
61   Z2PAGE VARCHAR2(100);
62 
63   P_SQL_TRACE VARCHAR2(32767);
64 
65   COMPANY_NAME_HEADER VARCHAR2(80);
66 
67   P_DISPLAY_DEBUG VARCHAR2(32767);
68 
69   REPORT_SHORT_NAME2 VARCHAR2(240);
70 
71   P_PRODUCT_TYPE VARCHAR2(10);
72 
73   P_DEPOSIT_ADVANCE VARCHAR2(7);
74 
75   P_AS_OF_DATE VARCHAR2(32767);
76   P_AS_OF_DATE_1 VARCHAR2(32767);
77 
78   P_SHOW_CONTRACTS VARCHAR2(10);
79 
80   PRODUCT_TYPE2 VARCHAR2(32767);
81 
82   DEAL_SUBTYPE2 VARCHAR2(32767);
83 
84   AS_AT_DATE2 DATE;
85 
86   SHOW_DETAIL2 VARCHAR2(32767);
87 
88   P_CONC_REQUEST_ID NUMBER;
89 
90   REPORT_DATE VARCHAR2(100);
91 
92   WAVG_RATE NUMBER;
93 
94   AVG_AMOUNT NUMBER;
95 
96   CP_PARA VARCHAR2(32767);
97 
98   FUNCTION WAVG_RATE1FORMULA RETURN VARCHAR2;
99 
100   FUNCTION WAVG_RATEFORMULA RETURN NUMBER;
101 
102   FUNCTION AVG_AMOUNT1FORMULA RETURN VARCHAR2;
103 
104   FUNCTION AVG_AMOUNTFORMULA RETURN NUMBER;
105 
106   FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
107 
108   FUNCTION BEFOREREPORT RETURN BOOLEAN;
109 
110   FUNCTION AFTERREPORT RETURN BOOLEAN;
111 
112   FUNCTION AFTERPFORM RETURN BOOLEAN;
113 
114   FUNCTION BEFOREPFORM RETURN BOOLEAN;
115 
116   FUNCTION WAVG_RATE_P RETURN NUMBER;
117 
118   FUNCTION AVG_AMOUNT_P RETURN NUMBER;
119 
120   FUNCTION CP_PARA_P RETURN VARCHAR2;
121 
122 END XTR_XTRTMAVG_XMLP_PKG;
123