DBA Data[Home] [Help]

PACKAGE: APPS.XTR_XTRTMAOD_XMLP_PKG

Source


1 PACKAGE XTR_XTRTMAOD_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRTMAODS.pls 120.1 2007/12/28 13:00:03 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   SHOW_DETAILS VARCHAR2(1);
14 
15   Z2OVERDUE_AMOUNTS VARCHAR2(100);
16 
17   Z2TOTAL VARCHAR2(100);
18 
19   Z2OVERDUE_AMOUNTS_BY_PERIODS VARCHAR2(100);
20 
21   Z2END_OF_REPORT VARCHAR2(100);
22 
23   Z2PRODUCT VARCHAR2(100);
24 
25   Z2TYPE VARCHAR2(100);
26 
27   Z2CURRENT VARCHAR2(100);
28 
29   Z2BALANCE VARCHAR2(100);
30 
31   Z1PARAMETERS VARCHAR2(100);
32 
33   Z1DEAL_NUMBER VARCHAR2(100);
34 
35   Z1PARTY_NAME VARCHAR2(100);
36 
37   Z1SHOW_DETAILS VARCHAR2(100);
38 
39   Z1PRODUCT VARCHAR2(100);
40 
41   Z1AS_AT_DATE VARCHAR2(100);
42 
43   Z1PARTY_CODE VARCHAR2(100);
44 
45   Z1ORDER_BY_COLUMN VARCHAR2(100);
46 
47   Z2DEAL VARCHAR2(100);
48 
49   Z2NUMBER VARCHAR2(100);
50 
51   Z2INTEREST VARCHAR2(100);
52 
53   Z2PRINCIPAL VARCHAR2(100);
54 
55   Z2TOTAL_DUE VARCHAR2(100);
56 
57   Z2MOST_RECENT VARCHAR2(100);
58 
59   Z2ROLLOVER VARCHAR2(100);
60 
61   Z2AMOUNT VARCHAR2(100);
62 
63   Z2RECEIVED VARCHAR2(100);
64 
65   Z2CLIENT VARCHAR2(100);
66 
67   Z2CODE VARCHAR2(100);
68 
69   Z2CLIENT_NAME VARCHAR2(100);
70 
71   Z2DUE_DATE VARCHAR2(100);
72 
73   Z2PAGE VARCHAR2(100);
74 
75   P_SQL_TRACE VARCHAR2(32767);
76 
77   COMPANY_NAME_HEADER VARCHAR2(80);
78 
79   P_DISPLAY_DEBUG VARCHAR2(32767);
80 
81   P_CONC_REQUEST_ID NUMBER;
82 
83   REPORT_SHORT_NAME2 VARCHAR2(240);
84 
85   P_PRODUCT_TYPE VARCHAR2(32767);
86 
87   ORDER_BY_COLUMN2 VARCHAR2(7);
88 
89   DEAL_NO2 VARCHAR2(7);
90 
91   CPARTY_CODE2 VARCHAR2(7);
92 
93   PRODUCT_TYPE2 VARCHAR2(10);
94 
95   CPARTY_NAME2 VARCHAR2(32767);
96 
97   AS_AT_DATE2 DATE;
98 
99   P_CPARTY VARCHAR2(32767);
100 
101   P_DEAL_NUMBER VARCHAR2(7);
102 
103   P_INCLUDE_PREV_ACT VARCHAR2(1);
104 
105   P_AS_OF_DATE VARCHAR2(32767);
106   P_AS_OF_DATE_1 VARCHAR2(32767);
107 
108   P_SORT_BY VARCHAR2(7);
109 
110   SHOW_DETAILS2 VARCHAR2(1);
111 
112   REPORT_DATE VARCHAR2(100);
113 
114   P_SHOW_DETAILS_DSP VARCHAR2(32767);
115 
116   P_SORT_BY_DSP VARCHAR2(100);
117 
118   INT_COMPONENT NUMBER;
119 
120   BAL_COMPONENT NUMBER;
121 
122   TOT_OVERDUE NUMBER;
123 
124   CP_PARA VARCHAR2(32767);
125 
126   FUNCTION INT_COMPONENT1FORMULA(INT_OD_RUNNING IN NUMBER
127                                 ,INT_OVERDUE2 IN NUMBER
128                                 ,INT_OVERDUE IN NUMBER) RETURN VARCHAR2;
129 
130   FUNCTION INT_COMPONENTFORMULA RETURN NUMBER;
131 
132   FUNCTION BAL_COMPONENT1FORMULA(BAL_RUNNING IN NUMBER
133                                 ,BAL_OVERDUE2 IN NUMBER
134                                 ,BAL_OVERDUE IN NUMBER) RETURN VARCHAR2;
135 
136   FUNCTION BAL_COMPONENTFORMULA RETURN NUMBER;
137 
138   FUNCTION TOT_OVERDUE1FORMULA RETURN VARCHAR2;
139 
140   FUNCTION TOT_OVERDUEFORMULA RETURN NUMBER;
141 
142   FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
143 
144   FUNCTION BEFOREREPORT RETURN BOOLEAN;
145 
146   FUNCTION AFTERREPORT RETURN BOOLEAN;
147 
148   FUNCTION AFTERPFORM RETURN BOOLEAN;
149 
150   FUNCTION PRIN_AMT_DUEFORMULA(PI_AMOUNT_DUE IN NUMBER) RETURN NUMBER;
151 
152   FUNCTION INT_COMPONENT_P RETURN NUMBER;
153 
154   FUNCTION BAL_COMPONENT_P RETURN NUMBER;
155 
156   FUNCTION TOT_OVERDUE_P RETURN NUMBER;
157 
158   FUNCTION CP_PARA_P RETURN VARCHAR2;
159 
160 END XTR_XTRTMAOD_XMLP_PKG;
161