[Home] [Help]
PACKAGE: APPS.XTR_XTRTMAOD_XMLP_PKG
Source
1 PACKAGE XTR_XTRTMAOD_XMLP_PKG 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