PACKAGE: APPS.XTR_XTRTMODR_XMLP_PKG

Source

1 PACKAGE XTR_XTRTMODR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRTMODRS.pls 120.1 2007/12/28 13:03:26 npannamp noship $ */
3   REPORT_SHORT_NAME VARCHAR2(240) := 'SUMMARY OF TERM ADVANCE OVERDUES';
4 
5   Z2INTEREST VARCHAR2(100);
6 
7   Z2PRODUCT_TOTALS VARCHAR2(100);
8 
9   Z2REPORT_TOTALS VARCHAR2(100);
10 
11   Z2END_OF_REPORT VARCHAR2(100);
12 
13   Z2THIRTY_DAYS VARCHAR2(100);
14 
15   Z2OVERDUE VARCHAR2(100);
16 
17   Z2SIXTY_DAYS VARCHAR2(100);
18 
19   Z2NINTY_PLUS_DAYS VARCHAR2(100);
20 
21   Z1PARAMETERS VARCHAR2(100);
22 
23   Z1DEAL_NUMBER VARCHAR2(100);
24 
25   Z1PARTY_NAME VARCHAR2(100);
26 
27   Z1PRODUCT VARCHAR2(100);
28 
29   Z1AS_AT_DATE VARCHAR2(100);
30 
31   Z1PARTY_CODE VARCHAR2(100);
32 
33   Z1ORDER_BY_COLUMN VARCHAR2(100);
34 
35   Z2CLIENT VARCHAR2(100);
36 
37   Z2NAME VARCHAR2(100);
38 
39   Z2OVERDUE_AMOUNTS VARCHAR2(100);
40 
41   Z2PRINCIPAL VARCHAR2(100);
42 
43   Z2TOTAL_DUE VARCHAR2(100);
44 
45   Z2REF VARCHAR2(100);
46 
47   Z2NUMBER VARCHAR2(100);
48 
49   Z2UNDER VARCHAR2(100);
50 
51   Z2PAGE VARCHAR2(100);
52 
53   ORDER_BY_COLUMN2 VARCHAR2(40);
54 
55   DEAL_NO2 VARCHAR2(40);
56 
57   CPARTY_CODE2 VARCHAR2(40);
58 
59   PRODUCT_TYPE2 VARCHAR2(40);
60 
61   CPARTY_NAME2 VARCHAR2(40);
62 
63   AS_AT_DATE2 DATE;
64 
65   P_SQL_TRACE VARCHAR2(32767);
66 
67   P_DISPLAY_DEBUG VARCHAR2(32767);
68 
69   COMPANY_NAME_HEADER VARCHAR2(80);
70 
71   P_CONC_REQUEST_ID NUMBER;
72 
73   P_AS_OF_DATE VARCHAR2(32767);
74   LP_AS_OF_DATE VARCHAR2(32767);
75 
76   P_DEAL_NUMBER NUMBER;
77 
78   P_PRODUCT_TYPE VARCHAR2(32767);
79 
80   P_SORT_BY VARCHAR2(32767);
81 
82   P_CPARTY_NAME VARCHAR2(60);
83 
84   P_CPARTY VARCHAR2(32767);
85 
86   REPORT_DATE VARCHAR2(100);
87 
88   ORDER_BY_CLAUSE VARCHAR2(100) := 'order by 8,9 desc,5';
89 
90   Z1P_FACTOR VARCHAR2(100);
91 
92   P_FACTOR VARCHAR2(10);
93 
94   LP_FACTOR_DESC VARCHAR2(32767);
95 
96   AMT_UNIT2 NUMBER;
97 
98   INT_COMPONENT NUMBER;
99 
100   BAL_COMPONENT NUMBER;
101 
102   TOT_OVERDUE NUMBER;
103 
104   CURR NUMBER;
105 
106   DAY30P NUMBER;
107 
108   DAY60P NUMBER;
109 
110   DAY90P NUMBER;
111 
112   CP_PARA VARCHAR2(32767);
113 
114   FUNCTION INT_COMPONENT1FORMULA RETURN VARCHAR2;
115 
116   FUNCTION BAL_COMPONENT1FORMULA RETURN VARCHAR2;
117 
118   FUNCTION TOT_OVERDUE1FORMULA RETURN VARCHAR2;
119 
120   FUNCTION CURR1FORMULA RETURN VARCHAR2;
121 
122   FUNCTION DAY30P1FORMULA RETURN VARCHAR2;
123 
124   FUNCTION DAY60P1FORMULA RETURN VARCHAR2;
125 
126   FUNCTION DAY90P1FORMULA RETURN VARCHAR2;
127 
128   FUNCTION BEFOREPFORM RETURN BOOLEAN;
129 
130   FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
131 
132   FUNCTION BEFOREREPORT RETURN BOOLEAN;
133 
134   FUNCTION AFTERPFORM RETURN BOOLEAN;
135 
136   FUNCTION AFTERREPORT RETURN BOOLEAN;
137 
138   FUNCTION INT_COMPONENT_P RETURN NUMBER;
139 
140   FUNCTION BAL_COMPONENT_P RETURN NUMBER;
141 
142   FUNCTION TOT_OVERDUE_P RETURN NUMBER;
143 
144   FUNCTION CURR_P RETURN NUMBER;
145 
146   FUNCTION DAY30P_P RETURN NUMBER;
147 
148   FUNCTION DAY60P_P RETURN NUMBER;
149 
150   FUNCTION DAY90P_P RETURN NUMBER;
151 
152   FUNCTION CP_PARA_P RETURN VARCHAR2;
153 
154 END XTR_XTRTMODR_XMLP_PKG;
155