1 PACKAGE JG_JGZZRDLR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JGZZRDLRS.pls 120.2 2007/12/25 16:04:09 npannamp noship $ */
3 P_CONC_REQUEST_ID NUMBER := 0;
4
5 P_SET_OF_BOOKS_ID NUMBER := 1;
6
7 P_CHART_OF_ACCOUNTS_ID NUMBER;
8
9 P_CUSTOMER_FROM VARCHAR2(80);
10
11 P_CUSTOMER_TO VARCHAR2(80);
12
13 P_CURRENCY VARCHAR2(3);
14
15 P_INCL_RAR VARCHAR2(3);
16
17 P_RISKVAR1 VARCHAR2(50) := 'rps.amount_due_original';
18
19 P_RISKVAR2 VARCHAR2(50) := 'nvl(ara.amount_applied,0)';
20
21 P_RISKVAR3 VARCHAR2(60) := 'nvl(rps.amount_due_remaining, 0) * -1';
22
23 P_DUNNING_LETTER_ID NUMBER;
24
25 P_AS_OF_DATE VARCHAR2(30);
26
27 P_SITE VARCHAR2(100);
28
29 P_CUST_ID NUMBER;
30
31 P_TAX_ID VARCHAR2(40);
32
33 P_WHERE_CURR VARCHAR2(500);
34
35 P_DATE_TO DATE;
36
37 P_AS_OF_DATE1 DATE;
38
39 P_DEBUG_SWITCH VARCHAR2(2);
40
41 C_STRUCT_NUM VARCHAR2(15);
42
43 C_SET_OF_BOOKS_NAME VARCHAR2(30) := '1';
44
45 C_CURRENCY_CODE VARCHAR2(3);
46
47 C_RAR_YES_NO VARCHAR2(80);
48
49 FUNCTION BEFOREREPORT RETURN BOOLEAN;
50
51 FUNCTION C_PRT_TOT_NET_FOREIGNFORMULA(C_TOT_NET_FOREIGN IN NUMBER
52 ,CURRENCY_CODE IN VARCHAR2
53 ,C_PRT_TOT_NET_FOREIGN IN VARCHAR2) RETURN VARCHAR2;
54
55 FUNCTION C_PRT_TOT_NET_FOR_REMFORMULA(C_TOT_NET_FOR_REM IN NUMBER
56 ,CURRENCY_CODE IN VARCHAR2
57 ,C_PRT_TOT_NET_FOR_REM IN VARCHAR2) RETURN VARCHAR2;
58
59 FUNCTION C_PRT_TOT_O_FOREIGNFORMULA(C_TOT_O_FOREIGN IN NUMBER
60 ,CURRENCY_CODE IN VARCHAR2
61 ,C_PRT_TOT_O_FOREIGN IN VARCHAR2) RETURN VARCHAR2;
62
63 FUNCTION C_PRT_TOT_R_FOREIGNFORMULA(C_TOT_R_FOREIGN IN NUMBER
64 ,CURRENCY_CODE IN VARCHAR2
65 ,C_PRT_TOT_R_FOREIGN IN VARCHAR2) RETURN VARCHAR2;
66
67 FUNCTION C_PRT_ORIG_FRGN_AMOUNTFORMULA(ORIGINAL_FRGN_AMOUNT IN NUMBER
68 ,CURRENCY_CODE IN VARCHAR2
69 ,C_PRT_ORIG_FRGN_AMOUNT IN VARCHAR2) RETURN VARCHAR2;
70
71 FUNCTION C_PRT_ORIG_FUNC_AMOUNTFORMULA(ORIGINAL_FUNC_AMOUNT IN NUMBER
72 ,C_PRT_ORIG_FUNC_AMOUNT IN VARCHAR2
73 ,CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
74
75 FUNCTION C_PRT_FRGN_AMT_DUE_REMFORMULA(ORG_CUR_AMT_REM IN NUMBER
76 ,CURRENCY_CODE IN VARCHAR2
77 ,C_PRT_FRGN_AMT_DUE_REM IN VARCHAR2) RETURN VARCHAR2;
78
79 FUNCTION C_PRT_FUNC_AMT_DUE_REMFORMULA(FUN_CUR_AMT_REM IN NUMBER
80 ,C_PRT_FUNC_AMT_DUE_REM IN VARCHAR2
81 ,CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
82
83 FUNCTION C_PRT_TOT_TAX_FUNCFORMULA(C_TOT_TAX_FUNC IN NUMBER
84 ,C_PRT_TOT_TAX_FUNC IN VARCHAR2
85 ,CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
86
87 FUNCTION C_PRT_TOT_TAX_FUNC_REMFORMULA(C_TOT_TAX_FUNC_REM IN NUMBER
88 ,C_PRT_TOT_TAX_FUNC_REM IN VARCHAR2
89 ,CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
90
91 FUNCTION C_PRT_TOT_SITE_FUNCFORMULA(C_TOT_SITE_FUNC IN NUMBER
92 ,C_PRT_TOT_SITE_FUNC IN VARCHAR2
93 ,CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
94
95 FUNCTION C_PRT_TOT_SITE_FUNC_REMFORMULA(C_TOT_SITE_FUNC_REM IN NUMBER
96 ,C_PRT_TOT_SITE_FUNC_REM IN VARCHAR2
97 ,CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
98
99 FUNCTION AFTERREPORT RETURN BOOLEAN;
100
101 FUNCTION C_PRT_TOT_CUR_FUNCFORMULA(C_TOT_CUR_FUNC IN NUMBER
102 ,C_PRT_TOT_CUR_FUNC IN VARCHAR2
103 ,CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
104
105 FUNCTION C_PRT_TOT_CUR_FUNC_REMFORMULA(C_TOT_CUR_FUNC_REM IN NUMBER
106 ,C_PRT_TOT_CUR_FUNC_REM IN VARCHAR2
107 ,CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
108
109 FUNCTION C_OA_PRT_ORIG_FRGN_AMOUNTFORMU(ORIGINAL_FRGN_AMOUNT_OA IN NUMBER
110 ,CURRENCY_CODE_OA IN VARCHAR2
111 ,C_OA_PRT_ORIG_FRGN_AMOUNT IN VARCHAR2
112 ,CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
113
114 FUNCTION C_OA_PRT_FRGN_AMT_DUE_REMFORMU(AMOUNT_FRGN_DUE_REM_OA IN NUMBER
115 ,CURRENCY_CODE_OA IN VARCHAR2
116 ,C_OA_PRT_FRGN_AMT_DUE_REM IN VARCHAR2
117 ,CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
118
119 FUNCTION C_OA_PRT_ORIG_FUNC_AMOUNTFORMU(ORIGINAL_FUNC_AMOUNT_OA IN NUMBER
120 ,C_OA_PRT_ORIG_FUNC_AMOUNT IN VARCHAR2
121 ,CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
122
123 FUNCTION C_OA_PRT_FUNC_AMT_DUE_REMFORMU(AMOUNT_FUNC_DUE_REM_OA IN NUMBER
124 ,C_OA_PRT_FUNC_AMT_DUE_REM IN VARCHAR2
125 ,CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
126
127 FUNCTION C_DISPLAY_TOTAL_ORIGINALFORMUL(C_OA_TOTAL_ORIGINAL IN NUMBER
128 ,C_DISPLAY_TOTAL_ORIGINAL IN VARCHAR2
129 ,CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
130
131 FUNCTION C_DISPLAY_TOTAL_REMAINFORMULA(C_OA_TOTAL_REMAIN IN NUMBER
132 ,C_DISPLAY_TOTAL_REMAIN IN VARCHAR2
133 ,CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
134
135 FUNCTION CF_INVOICE_DATEFORMULA(INVOICE_DATE IN DATE) RETURN CHAR;
136
137 FUNCTION CF_DATE_TIMEFORMULA RETURN CHAR;
138
139 FUNCTION C_DUE_DATEFORMULA(DUE_DATE IN DATE) RETURN CHAR;
140
141 FUNCTION C_PRT_TOT_NET_FUNCOFORMULA(C_TOT_NET_FUNCO IN NUMBER
142 ,C_PRT_TOT_NET_FUNCO IN VARCHAR2
143 ,CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
144
145 FUNCTION C_PRT_TOT_NET_FUNCRFORMULA(C_TOT_NET_FUNCR IN NUMBER
146 ,C_PRT_TOT_NET_FUNCR IN VARCHAR2
147 ,CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
148
149 FUNCTION C_GRAND_TOTAL_ORIGFORMULA(C_TOT_NET_FUNCR IN NUMBER
150 ,C_GRAND_ORIG1 IN NUMBER) RETURN NUMBER;
151
152 FUNCTION C_PRT_GRAND_TOT_ORIGFORMULA(C_GRAND_TOTAL_ORIG IN NUMBER
153 ,C_PRT_GRAND_TOT_ORIG IN VARCHAR2
154 ,CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
155
156 FUNCTION C_PRT_GRAND_TOT_REMAINFORMULA(C_GRAND_TOT_REMAIN IN NUMBER
157 ,C_PRT_GRAND_TOT_REMAIN IN VARCHAR2
158 ,CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
159
160 FUNCTION C_GRAND_TOT_REMAINFORMULA(C_TOT_NET_FUNCO IN NUMBER
161 ,C_GRAND_REMAIN1 IN NUMBER) RETURN NUMBER;
162
163 FUNCTION CF_TEXTFORMULA(PARAGRAPH_TEXT IN VARCHAR2
164 ,CF_AMOUNT IN VARCHAR2) RETURN VARCHAR;
165
166 FUNCTION CF_DUNNING_NAMEFORMULA RETURN CHAR;
167
168 FUNCTION CF_AS_OF_DATEFORMULA RETURN CHAR;
169
170 FUNCTION CF_AMOUNTFORMULA(C_TOT_SITE_FUNC_REM IN NUMBER
171 ,CF_AMOUNT IN VARCHAR2
172 ,CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
173
174 FUNCTION APPLIED_AMOUNTFORMULA(TRX_ID IN NUMBER) RETURN NUMBER;
175
176 FUNCTION ORG_CUR_AMT_REMFORMULA(AMOUNT_FRGN_DUE_REM IN NUMBER
177 ,APPLIED_AMOUNT IN NUMBER) RETURN NUMBER;
178
179 FUNCTION FUN_CUR_AMT_REMFORMULA(EXCHANGE_RATE IN NUMBER
180 ,ORG_CUR_AMT_REM IN NUMBER
181 ,AMOUNT_FUNC_DUE_REM IN NUMBER) RETURN NUMBER;
182
183 FUNCTION ORG_CUR_AMOUNTFORMULA(ORG_CUR_AMT_REM IN NUMBER
184 ,ORIGINAL_FRGN_AMOUNT IN NUMBER) RETURN NUMBER;
185
186 FUNCTION FUN_CUR_AMOUNTFORMULA(ORG_CUR_AMT_REM IN NUMBER
187 ,ORIGINAL_FUNC_AMOUNT IN NUMBER) RETURN NUMBER;
188
189 FUNCTION C_STRUCT_NUM_P RETURN VARCHAR2;
190
191 FUNCTION C_SET_OF_BOOKS_NAME_P RETURN VARCHAR2;
192
193 FUNCTION C_CURRENCY_CODE_P RETURN VARCHAR2;
194
195 FUNCTION C_RAR_YES_NO_P RETURN VARCHAR2;
196
197 PROCEDURE JG_GET_SET_OF_BOOKS_INFO(SOBID IN NUMBER
198 ,COAID OUT NOCOPY NUMBER
199 ,SOBNAME OUT NOCOPY VARCHAR2
200 ,FUNC_CURR OUT NOCOPY VARCHAR2
201 ,ERRBUF OUT NOCOPY VARCHAR2);
202
203 PROCEDURE JG_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE IN VARCHAR2
204 ,TYPE_ID IN NUMBER
205 ,NAME OUT NOCOPY VARCHAR2
206 ,ERRBUF OUT NOCOPY VARCHAR2);
207
208 PROCEDURE JG_GET_LOOKUP_VALUE(LMODE IN VARCHAR2
209 ,CODE IN VARCHAR2
210 ,TYPE IN VARCHAR2
211 ,VALUE OUT NOCOPY VARCHAR2
212 ,ERRBUF OUT NOCOPY VARCHAR2);
213
214 PROCEDURE JG_GET_FIRST_PERIOD(APP_ID IN NUMBER
215 ,TSET_OF_BOOKS_ID IN NUMBER
216 ,TPERIOD_NAME IN VARCHAR2
217 ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
218 ,ERRBUF OUT NOCOPY VARCHAR2);
219
220 PROCEDURE JG_GET_FIRST_PERIOD_OF_QUARTER(APP_ID IN NUMBER
221 ,TSET_OF_BOOKS_ID IN NUMBER
222 ,TPERIOD_NAME IN VARCHAR2
223 ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
224 ,ERRBUF OUT NOCOPY VARCHAR2);
225
226 FUNCTION JG_FORMAT_CURR_AMT(IN_PRECISION IN NUMBER
227 ,IN_AMOUNT_DISP IN VARCHAR2) RETURN VARCHAR2;
228
229 PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
230 ,NAME IN VARCHAR2);
231
232 PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
233 ,VALUE IN VARCHAR2
234 ,TRANSLATE IN BOOLEAN);
235
236 PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
237
238 PROCEDURE CLEAR;
239
240 FUNCTION GET_STRING(APPIN IN VARCHAR2
241 ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
242
243 FUNCTION GET_NUMBER(APPIN IN VARCHAR2
244 ,NAMEIN IN VARCHAR2) RETURN NUMBER;
245
246 FUNCTION GET RETURN VARCHAR2;
247
248 FUNCTION GET_ENCODED RETURN VARCHAR2;
249
250 PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
251 ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
252 ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
253
254 PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
255
256 PROCEDURE RAISE_ERROR;
257
258 PROCEDURE FORMAT_CURRENCY(CURR_CODE IN NUMBER
259 ,FLD_NAME IN VARCHAR2
260 ,RAW_NUM IN VARCHAR2
261 ,CURRENCY_CODE IN VARCHAR2);
262 END JG_JGZZRDLR_XMLP_PKG;
263
264
265