[Home] [Help]
PACKAGE: APPS.JG_JGZZSRCR_XMLP_PKG
Source
1 PACKAGE JG_JGZZSRCR_XMLP_PKG AS
2 /* $Header: JGZZSRCRS.pls 120.2.12010000.2 2008/08/04 13:51:47 vgadde ship $ */
3 P_PAYMENT_GROUP VARCHAR2(32767);
4
5 P_INVOICE_CURRENCY VARCHAR2(3);
6
7 P_VENDOR_ID NUMBER;
8
9 P_ONLY_PAST_FLAG VARCHAR2(1);
10
11 P_MATCH_STATUS_FLAG VARCHAR2(1);
12 P_MATCH_STATUS_FLAG_V VARCHAR2(1);
13
14 P_ONLY_OPEN_INVOICES VARCHAR2(1) := 'Y';
15
16 P_ONLY_PAID_INVOICES VARCHAR2(1) := 'Y';
17
18 P_ONLY_OPEN_INVOICES_V VARCHAR2(1) := 'Y';
19
20 P_ONLY_PAID_INVOICES_V VARCHAR2(1) := 'Y';
21
22 P_CHECK_VOUCHER VARCHAR2(80);
23
24 P_PAYMENT_PERIOD VARCHAR2(32767);
25
26 P_INV_POSTED_FLAG VARCHAR2(1);
27
28 P_PAY_POSTED_FLAG VARCHAR2(1);
29
30 P_CUT_DATE DATE;
31 P_CUT_DATE_v DATE;
32
33 P_SUMMARY_LEVEL NUMBER;
34
35 P_CONC_REQUEST_ID NUMBER := 0;
36
37 P_GROUP_FIELD VARCHAR2(60);
38
39 P_INVOICE_PERIOD VARCHAR2(32767);
40
41 P_DEBUG_SWITCH VARCHAR2(32767);
42
43 P_CONFIRMED VARCHAR2(32767);
44
45 P_CHECKRUN_NAME VARCHAR2(50);
46
47 P_REPORTING_CONTEXT VARCHAR2(40);
48
49 P_REPORTING_LEVEL VARCHAR2(40);
50
51 P_REPORTING_ENTITY_ID NUMBER;
52
53 P_SUMMARIZE_ALL_OU VARCHAR2(40);
54
55 P_CHECK_LEDGER_IN_SP VARCHAR2(10);
56
57 P_PARTIAL_LEDGER_MSG VARCHAR2(240);
58
59 P_REPORTING_ENTITY_NAME VARCHAR2(50);
60
61 P_REPORTING_LEVEL_NAME VARCHAR2(50);
62
63 P_ORG_WHERE_I VARCHAR2(2000):=' ';
64
65 P_ORG_WHERE_ID VARCHAR2(2000):=' ';
66
67 P_ORG_WHERE_VS VARCHAR2(2000):=' ';
68
69 P_ORG_WHERE_PS VARCHAR2(2000):=' ';
70
71 P_ORG_WHERE_AAE1 VARCHAR2(2000):=' ';
72
73 P_ORG_WHERE_ACH1 VARCHAR2(2000):=' ';
74
75 P_ORG_WHERE_SP VARCHAR2(2000);
76
77 P_ORG_WHERE_AAE VARCHAR2(2000);
78
79 P_ORG_WHERE_ACH VARCHAR2(2000);
80
81 P_ORG_WHERE_IP VARCHAR2(2000);
82
83 P_ORG_WHERE_C VARCHAR2(2000);
84
85 CP_INV_DUE_DATE_FMT VARCHAR2(20);
86
87 CP_INVPP_OPEN_BASE NUMBER;
88
89 CP_INVPP_OPEN_AMOUNT NUMBER;
90
91 CP_INVPP_GL_DATE DATE;
92
93 C_FLEXDATA VARCHAR2(600) := 'I.PAY_GROUP_LOOKUP_CODE';
94
95 SQL_PAYMENT_GROUP VARCHAR2(840):= ' ';
96
97 SQL_INVOICE_CURRENCY VARCHAR2(500):= ' ';
98
99 SQL_PAYMENT_GROUP_WH VARCHAR2(840):= ' ';
100
101 SQL_VENDOR_ID VARCHAR2(500):=' ';
102
103 SQL_ONLY_PAST_FLAG VARCHAR2(500):= ' ';
104
105 SQL_DISTRIBUTIONS VARCHAR2(1700):=' ';
106
107 SQL_PAYMENTS2 VARCHAR2(2000);
108
109 SQL_ONLY_PAST_FLAG2 VARCHAR2(400);
110
111 SQL_PAYMENTS3 VARCHAR2(3000);
112
113 C_COAI NUMBER;
114
115 SQL_PAYMENTS1 VARCHAR2(3000):= ' ';
116
117 C_TITLE VARCHAR2(240);
118
119 C_SUMMARY_LEVEL VARCHAR2(80);
120
121 C_YES VARCHAR2(80);
122
123 C_APPROVAL_STATUS VARCHAR2(80);
124
125 C_NO VARCHAR2(80);
126
127 C_ALL VARCHAR2(80);
128
129 C_SOB NUMBER;
130
131 C_HOLD_FLAG VARCHAR2(32767);
132
133 C_PRECISION NUMBER := 2;
134
135 C_FUNCT_CURR VARCHAR2(32767);
136
137 CP_PARTIAL_LEDGER_MSG VARCHAR2(240);
138
139 FUNCTION BEFOREREPORT RETURN BOOLEAN;
140
141 FUNCTION AFTERREPORT RETURN BOOLEAN;
142
143 FUNCTION C_INV_OPEN_AMOUNTFORMULA(C_INV_GROSS_AMOUNT IN NUMBER
144 ,C_INV_PAY_AMOUNT0 IN NUMBER
145 ,C_INV_DISCOUNT_TAKEN0 IN NUMBER
146 ,C_INV_PAY_AMOUNT IN NUMBER
147 ,C_INV_DISCOUNT_TAKEN IN NUMBER) RETURN NUMBER;
148
149 FUNCTION C_INV_OPEN_BASEFORMULA(C_INV_OPEN_AMOUNT IN NUMBER
150 ,EXCHANGE_RATE IN NUMBER
151 ,PAYMENT_CROSS_RATE IN NUMBER) RETURN NUMBER;
152
153 FUNCTION C_CUR_OPEN_AMOUNTFORMULA(C_CUR_GROSS_AMOUNT IN NUMBER
154 ,C_CUR_PAY_AMOUNT IN NUMBER
155 ,C_CUR_DISCOUNT_TAKEN IN NUMBER) RETURN NUMBER;
156
157 FUNCTION C_CUR_OPEN_BASEFORMULA(C_CUR_OPEN_AMOUNT IN NUMBER
158 ,EXCHANGE_RATE IN NUMBER) RETURN NUMBER;
159
160 FUNCTION C_SCH_OPEN_AMOUNTFORMULA(GROSS_AMOUNT IN NUMBER
161 ,C_SCH_PAY_AMOUNT IN NUMBER
162 ,C_SCH_DISCOUNT_TAKEN IN NUMBER) RETURN NUMBER;
163
164 FUNCTION C_SCH_OPEN_BASEFORMULA(C_SCH_OPEN_AMOUNT IN NUMBER
165 ,EXCHANGE_RATE IN NUMBER) RETURN NUMBER;
166
167 FUNCTION C_GRP_OPEN_BASEFORMULA(C_GRP_GROSS_BASE IN NUMBER
168 ,C_GRP_PAY_BASE IN NUMBER
169 ,C_GRP_DISCOUNT_TAKEN_BASE IN NUMBER
170 ,C_GRP_GAINLOSS IN NUMBER) RETURN NUMBER;
171
172 FUNCTION C_VEN_OPEN_AMOUNTFORMULA(C_VEN_GROSS_AMOUNT IN NUMBER
173 ,C_VEN_PAY_AMOUNT IN NUMBER
174 ,C_VEN_DISCOUNT_TAKEN IN NUMBER) RETURN NUMBER;
175
176 FUNCTION C_VEN_OPEN_BASEFORMULA(C_VEN_OPEN_AMOUNT IN NUMBER
177 ,EXCHANGE_RATE IN NUMBER) RETURN NUMBER;
178
179 FUNCTION C_RPT_OPEN_BASEFORMULA(C_RPT_INV_BASE IN NUMBER
180 ,C_RPT_PAY_BASE IN NUMBER
181 ,C_RPT_DISCOUNT_TAKEN_BASE IN NUMBER
182 ,C_RPT_GAINLOSS IN NUMBER) RETURN NUMBER;
183
184 FUNCTION C_VENDOR_NAMEFORMULA RETURN VARCHAR2;
185
186 FUNCTION C_FLEXPROMPTFORMULA RETURN VARCHAR2;
187
188 FUNCTION C_SOB_NAMEFORMULA RETURN VARCHAR2;
189
190 FUNCTION SQL_PAYMENT_GROUP_F RETURN BOOLEAN;
191
192 FUNCTION SQL_CURRENCY RETURN BOOLEAN;
193
194 FUNCTION SQL_VENDOR RETURN BOOLEAN;
195
196 FUNCTION SQL_ONLY_PAST RETURN BOOLEAN;
197
198 FUNCTION SQL_DISTRIBUTIONS_F RETURN BOOLEAN;
199
200 FUNCTION SQL_PAYMENTS RETURN BOOLEAN;
201
202 FUNCTION C_BAL_FACTORFORMULA(DIST_BASE_AMOUNT IN NUMBER
203 ,INVOICE_ID_v IN NUMBER) RETURN NUMBER;
204
205 FUNCTION C_INV_GROSS_BASEFORMULA(CANCELLED_DATE IN DATE
206 ,C_INV_GROSS_BASE0 IN NUMBER
207 ,CANCELLED_AMOUNT IN NUMBER
208 ,EXCHANGE_RATE IN NUMBER) RETURN NUMBER;
209
210 FUNCTION C_INV_GROSS_AMOUNTFORMULA(CANCELLED_DATE IN DATE
211 ,C_INV_GROSS_AMOUNT1 IN NUMBER
212 ,CANCELLED_AMOUNT IN NUMBER
213 ,C_INV_GROSS_AMOUNT0 IN NUMBER) RETURN NUMBER;
214
215 FUNCTION C_INV_PAY_BASEFORMULA(INVOICE_ID_V IN NUMBER
216 ,C_INV_PAY_BASE0 IN NUMBER) RETURN NUMBER;
217
218 FUNCTION C_INV_GAINLOSSFORMULA(C_INV_GAINLOSS0 IN NUMBER) RETURN NUMBER;
219
220 FUNCTION C_INV_DISCOUNT_TAKEN_BASEFORMU(C_INV_DISC_TAKEN_BASE0 IN NUMBER) RETURN NUMBER;
221
222 FUNCTION C_INV_DISCOUNT_AVAILABLEFORMUL(C_INV_DISC_AVAIL0 IN NUMBER
223 ,C_BAL_FACTOR IN NUMBER) RETURN NUMBER;
224
225 FUNCTION NLS_PARAMETERS RETURN BOOLEAN;
226
227 FUNCTION C_APPROVE_FLAGFORMULA(INVOICE_ID_v IN NUMBER) RETURN VARCHAR2;
228
229 FUNCTION CF_CUT_DATEFORMULA RETURN CHAR;
230
231 FUNCTION CF_SYSDATEFORMULA RETURN CHAR;
232
233 FUNCTION CF_C_INV_DISCOUNT_DATEFORMULA(C_INV_DISCOUNT_DATE IN DATE) RETURN CHAR;
234
235 FUNCTION CF_INV_CHECK_GL_DATEFORMULA(C_INV_CHECK_GL_DATE IN DATE) RETURN CHAR;
236
237 FUNCTION CF_ORGANIZATIONFORMULA(ORG_ID IN NUMBER) RETURN VARCHAR2;
238
239 FUNCTION CF_FLEXPROMPTFORMULA RETURN VARCHAR2;
240
241 FUNCTION AFTERPFORM RETURN BOOLEAN;
242
243 FUNCTION CP_INV_DUE_DATE_FMT_P RETURN VARCHAR2;
244
245 FUNCTION CP_INVPP_OPEN_BASE_P RETURN NUMBER;
246
247 FUNCTION CP_INVPP_OPEN_AMOUNT_P RETURN NUMBER;
248
249 FUNCTION CP_INVPP_GL_DATE_P RETURN DATE;
250
251 FUNCTION C_FLEXDATA_P RETURN VARCHAR2;
252
253 FUNCTION SQL_PAYMENT_GROUP_P RETURN VARCHAR2;
254
255 FUNCTION SQL_INVOICE_CURRENCY_P RETURN VARCHAR2;
256
257 FUNCTION SQL_VENDOR_ID_P RETURN VARCHAR2;
258
259 FUNCTION SQL_ONLY_PAST_FLAG_P RETURN VARCHAR2;
260
261 FUNCTION SQL_DISTRIBUTIONS_P RETURN VARCHAR2;
262
263 FUNCTION SQL_PAYMENTS2_P RETURN VARCHAR2;
264
265 FUNCTION SQL_ONLY_PAST_FLAG2_P RETURN VARCHAR2;
266
267 FUNCTION SQL_PAYMENTS3_P RETURN VARCHAR2;
268
269 FUNCTION C_COAI_P RETURN NUMBER;
270
271 FUNCTION SQL_PAYMENTS1_P RETURN VARCHAR2;
272
273 FUNCTION C_TITLE_P RETURN VARCHAR2;
274
275 FUNCTION C_SUMMARY_LEVEL_P RETURN VARCHAR2;
276
277 FUNCTION C_YES_P RETURN VARCHAR2;
278
279 FUNCTION C_APPROVAL_STATUS_P RETURN VARCHAR2;
280
281 FUNCTION C_NO_P RETURN VARCHAR2;
282
283 FUNCTION C_ALL_P RETURN VARCHAR2;
284
285 FUNCTION C_SOB_P RETURN NUMBER;
286
287 FUNCTION C_HOLD_FLAG_P RETURN VARCHAR2;
288
289 FUNCTION C_PRECISION_P RETURN NUMBER;
290
291 FUNCTION C_FUNCT_CURR_P RETURN VARCHAR2;
292
293 FUNCTION CP_PARTIAL_LEDGER_MSG_P RETURN VARCHAR2;
294
295 END JG_JGZZSRCR_XMLP_PKG;
296