[Home] [Help]
170: P_VAT_TAX IN VARCHAR2 DEFAULT NULL,
171: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
172: P_REPORT_NAME IN VARCHAR2,
173: P_REQUEST_ID IN NUMBER,
174: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
175: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
176: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
177: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
178: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
171: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
172: P_REPORT_NAME IN VARCHAR2,
173: P_REQUEST_ID IN NUMBER,
174: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
175: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
176: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
177: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
178: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
179: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
172: P_REPORT_NAME IN VARCHAR2,
173: P_REQUEST_ID IN NUMBER,
174: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
175: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
176: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
177: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
178: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
179: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
180: X_VAT_AMT_TBL OUT NOCOPY NUMERIC9_TBL
173: P_REQUEST_ID IN NUMBER,
174: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
175: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
176: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
177: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
178: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
179: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
180: X_VAT_AMT_TBL OUT NOCOPY NUMERIC9_TBL
181: );
174: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
175: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
176: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
177: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
178: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
179: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
180: X_VAT_AMT_TBL OUT NOCOPY NUMERIC9_TBL
181: );
182:
175: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
176: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
177: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
178: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
179: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
180: X_VAT_AMT_TBL OUT NOCOPY NUMERIC9_TBL
181: );
182:
183: PROCEDURE GET_TAXABLE_AMOUNT
185: P_VAT_TAX IN VARCHAR2 DEFAULT NULL,
186: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
187: P_REPORT_NAME IN VARCHAR2,
188: P_REQUEST_ID IN NUMBER,
189: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
190: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
191: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
192: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
193: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
186: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
187: P_REPORT_NAME IN VARCHAR2,
188: P_REQUEST_ID IN NUMBER,
189: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
190: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
191: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
192: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
193: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
194: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
187: P_REPORT_NAME IN VARCHAR2,
188: P_REQUEST_ID IN NUMBER,
189: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
190: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
191: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
192: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
193: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
194: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
195: X_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC10_TBL
188: P_REQUEST_ID IN NUMBER,
189: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
190: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
191: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
192: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
193: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
194: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
195: X_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC10_TBL
196: );
189: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
190: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
191: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
192: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
193: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
194: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
195: X_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC10_TBL
196: );
197:
190: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
191: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
192: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
193: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
194: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
195: X_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC10_TBL
196: );
197:
198: PROCEDURE GET_NON_TAXABLE_AMOUNT
202: P_VAT_ADDIT_TAX IN VARCHAR2 DEFAULT NULL,
203: P_VAT_PERCEP_TAX IN VARCHAR2 DEFAULT NULL,
204: P_REPORT_NAME IN VARCHAR2,
205: p_REQUEST_ID IN NUMBER,
206: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
207: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
208: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
209: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
210: X_NON_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC8_TBL
203: P_VAT_PERCEP_TAX IN VARCHAR2 DEFAULT NULL,
204: P_REPORT_NAME IN VARCHAR2,
205: p_REQUEST_ID IN NUMBER,
206: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
207: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
208: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
209: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
210: X_NON_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC8_TBL
211: );
204: P_REPORT_NAME IN VARCHAR2,
205: p_REQUEST_ID IN NUMBER,
206: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
207: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
208: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
209: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
210: X_NON_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC8_TBL
211: );
212:
205: p_REQUEST_ID IN NUMBER,
206: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
207: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
208: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
209: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
210: X_NON_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC8_TBL
211: );
212:
213: PROCEDURE GET_VAT_EXEMPT_AMOUNT
217: P_VAT_PERCEP_TAX IN VARCHAR2 DEFAULT NULL,
218: P_REPORT_NAME IN VARCHAR2,
219: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
220: P_REQUEST_ID IN NUMBER,
221: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
222: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
223: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
224: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
225: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
218: P_REPORT_NAME IN VARCHAR2,
219: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
220: P_REQUEST_ID IN NUMBER,
221: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
222: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
223: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
224: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
225: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
226: X_VAT_EXEMPT_AMT_TBL OUT NOCOPY NUMERIC2_TBL
219: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
220: P_REQUEST_ID IN NUMBER,
221: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
222: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
223: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
224: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
225: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
226: X_VAT_EXEMPT_AMT_TBL OUT NOCOPY NUMERIC2_TBL
227: );
220: P_REQUEST_ID IN NUMBER,
221: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
222: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
223: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
224: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
225: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
226: X_VAT_EXEMPT_AMT_TBL OUT NOCOPY NUMERIC2_TBL
227: );
228:
221: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
222: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
223: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
224: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
225: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
226: X_VAT_EXEMPT_AMT_TBL OUT NOCOPY NUMERIC2_TBL
227: );
228:
229: PROCEDURE GET_VAT_ADDITIONAL_AMOUNT
230: (
231: P_VAT_ADDIT_TAX IN VARCHAR2 DEFAULT NULL,
232: P_REPORT_NAME IN VARCHAR2,
233: p_REQUEST_ID IN NUMBER,
234: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
235: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
236: X_VAT_ADDITIONAL_AMT_TBL OUT NOCOPY NUMERIC7_TBL
237: );
238:
231: P_VAT_ADDIT_TAX IN VARCHAR2 DEFAULT NULL,
232: P_REPORT_NAME IN VARCHAR2,
233: p_REQUEST_ID IN NUMBER,
234: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
235: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
236: X_VAT_ADDITIONAL_AMT_TBL OUT NOCOPY NUMERIC7_TBL
237: );
238:
239: PROCEDURE GET_NOT_REGISTERED_TAX_AMOUNT
242: P_VAT_ADDIT_TAX IN VARCHAR2 DEFAULT NULL,
243: P_VAT_NOT_CATEG_TAX IN VARCHAR2 DEFAULT NULL,
244: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
245: P_REQUEST_ID IN NUMBER,
246: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
247: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
248: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
249: X_NOT_REG_TAX_AMT_TBL OUT NOCOPY NUMERIC1_TBL
250: );
243: P_VAT_NOT_CATEG_TAX IN VARCHAR2 DEFAULT NULL,
244: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
245: P_REQUEST_ID IN NUMBER,
246: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
247: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
248: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
249: X_NOT_REG_TAX_AMT_TBL OUT NOCOPY NUMERIC1_TBL
250: );
251:
244: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
245: P_REQUEST_ID IN NUMBER,
246: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
247: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
248: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
249: X_NOT_REG_TAX_AMT_TBL OUT NOCOPY NUMERIC1_TBL
250: );
251:
252: PROCEDURE GET_VAT_PERCEPTION_AMOUNT
256: P_VAT_PERC_TAX IN VARCHAR2 DEFAULT NULL,
257: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
258: P_REPORT_NAME IN VARCHAR2,
259: p_REQUEST_ID IN NUMBER,
260: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
261: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
262: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
263: X_VAT_PERCEPTION_AMT_TBL OUT NOCOPY NUMERIC3_TBL
264: );
257: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
258: P_REPORT_NAME IN VARCHAR2,
259: p_REQUEST_ID IN NUMBER,
260: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
261: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
262: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
263: X_VAT_PERCEPTION_AMT_TBL OUT NOCOPY NUMERIC3_TBL
264: );
265:
258: P_REPORT_NAME IN VARCHAR2,
259: p_REQUEST_ID IN NUMBER,
260: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
261: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
262: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
263: X_VAT_PERCEPTION_AMT_TBL OUT NOCOPY NUMERIC3_TBL
264: );
265:
266: PROCEDURE GET_OTHER_FED_PERC_AMOUNT
270: P_VAT_PERC_TAX IN VARCHAR2 DEFAULT NULL,
271: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
272: P_REPORT_NAME IN VARCHAR2,
273: p_REQUEST_ID IN NUMBER,
274: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
275: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
276: X_OTHER_FED_PERC_AMT_TBL OUT NOCOPY NUMERIC7_TBL
277: );
278:
271: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
272: P_REPORT_NAME IN VARCHAR2,
273: p_REQUEST_ID IN NUMBER,
274: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
275: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
276: X_OTHER_FED_PERC_AMT_TBL OUT NOCOPY NUMERIC7_TBL
277: );
278:
279:
283: P_PROV_TAX_TYPE_TO IN VARCHAR2 DEFAULT NULL,
284: P_PROV_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
285: P_REPORT_NAME IN VARCHAR2,
286: p_REQUEST_ID IN NUMBER,
287: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
288: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
289: X_PROVINCIAL_PERC_AMT_TBL OUT NOCOPY NUMERIC4_TBL
290: );
291:
284: P_PROV_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
285: P_REPORT_NAME IN VARCHAR2,
286: p_REQUEST_ID IN NUMBER,
287: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
288: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
289: X_PROVINCIAL_PERC_AMT_TBL OUT NOCOPY NUMERIC4_TBL
290: );
291:
292: PROCEDURE GET_MUNICIPAL_PERC_AMOUNT
295: P_MUN_TAX_TYPE_TO IN VARCHAR2 DEFAULT NULL,
296: P_MUN_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
297: P_REPORT_NAME IN VARCHAR2,
298: p_REQUEST_ID IN NUMBER,
299: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
300: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
301: X_MUNICIPAL_PERC_AMT_TBL OUT NOCOPY NUMERIC5_TBL
302: );
303:
296: P_MUN_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
297: P_REPORT_NAME IN VARCHAR2,
298: p_REQUEST_ID IN NUMBER,
299: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
300: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
301: X_MUNICIPAL_PERC_AMT_TBL OUT NOCOPY NUMERIC5_TBL
302: );
303:
304: PROCEDURE GET_EXCISE_TAX_AMOUNT
307: P_EXC_TAX_TYPE_TO IN VARCHAR2 DEFAULT NULL,
308: P_EXC_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
309: P_REPORT_NAME IN VARCHAR2,
310: p_REQUEST_ID IN NUMBER,
311: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
312: X_EXCISE_AMT_TBL OUT NOCOPY NUMERIC6_TBL
313: );
314:
315: PROCEDURE GET_OTHER_TAX_AMOUNT
315: PROCEDURE GET_OTHER_TAX_AMOUNT
316: (
317: P_REPORT_NAME IN VARCHAR2,
318: p_REQUEST_ID IN NUMBER,
319: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
320: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
321: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
322: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
323: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
316: (
317: P_REPORT_NAME IN VARCHAR2,
318: p_REQUEST_ID IN NUMBER,
319: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
320: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
321: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
322: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
323: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
324: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
317: P_REPORT_NAME IN VARCHAR2,
318: p_REQUEST_ID IN NUMBER,
319: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
320: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
321: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
322: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
323: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
324: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
325: X_OTHER_TAX_AMT_TBL OUT NOCOPY NUMERIC7_TBL
318: p_REQUEST_ID IN NUMBER,
319: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
320: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
321: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
322: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
323: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
324: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
325: X_OTHER_TAX_AMT_TBL OUT NOCOPY NUMERIC7_TBL
326: );
319: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
320: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
321: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
322: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
323: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
324: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
325: X_OTHER_TAX_AMT_TBL OUT NOCOPY NUMERIC7_TBL
326: );
327:
320: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
321: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
322: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
323: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
324: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
325: X_OTHER_TAX_AMT_TBL OUT NOCOPY NUMERIC7_TBL
326: );
327:
328: PROCEDURE GET_COUNTED_SUM_DOC
328: PROCEDURE GET_COUNTED_SUM_DOC
329: (
330: P_REPORT_NAME IN VARCHAR2,
331: P_REQUEST_ID IN NUMBER,
332: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
333: X_CL_NUM_OF_DOC_TBL OUT NOCOPY NUMERIC3_TBL,
334: X_CL_TOTAL_EXEMPT_TBL OUT NOCOPY NUMERIC4_TBL,
335: X_CL_TOTAL_EFFECTIVE_TBL OUT NOCOPY NUMERIC5_TBL,
336: X_CL_TOTAL_VAT_TAX_TBL OUT NOCOPY NUMERIC6_TBL,
339:
340: PROCEDURE GET_CUSTOMER_CONDITION_CODE
341: (
342: P_VAT_PERCEP_TAX IN VARCHAR2,
343: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
344: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
345: P_REQUEST_ID IN NUMBER,
346: X_CUST_CONDITION_CODE_TBL OUT NOCOPY ATTRIBUTE7_TBL
347: );
340: PROCEDURE GET_CUSTOMER_CONDITION_CODE
341: (
342: P_VAT_PERCEP_TAX IN VARCHAR2,
343: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
344: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
345: P_REQUEST_ID IN NUMBER,
346: X_CUST_CONDITION_CODE_TBL OUT NOCOPY ATTRIBUTE7_TBL
347: );
348:
348:
349: PROCEDURE GET_VAT_REG_STAT_CODE
350: (
351: P_VAT_TAX IN VARCHAR2,
352: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
353: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
354: P_REQUEST_ID IN NUMBER,
355: X_VAT_REG_STAT_CODE_TBL OUT NOCOPY ATTRIBUTE8_TBL
356: );
349: PROCEDURE GET_VAT_REG_STAT_CODE
350: (
351: P_VAT_TAX IN VARCHAR2,
352: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
353: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
354: P_REQUEST_ID IN NUMBER,
355: X_VAT_REG_STAT_CODE_TBL OUT NOCOPY ATTRIBUTE8_TBL
356: );
357:
363: return ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE;
364:
365: PROCEDURE GET_FISCAL_PRINTER
366: (
367: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
368: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
369: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
370: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
371: X_FISCAL_PRINTER_TBL OUT NOCOPY ATTRIBUTE20_TBL
364:
365: PROCEDURE GET_FISCAL_PRINTER
366: (
367: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
368: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
369: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
370: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
371: X_FISCAL_PRINTER_TBL OUT NOCOPY ATTRIBUTE20_TBL
372: );
365: PROCEDURE GET_FISCAL_PRINTER
366: (
367: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
368: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
369: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
370: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
371: X_FISCAL_PRINTER_TBL OUT NOCOPY ATTRIBUTE20_TBL
372: );
373:
366: (
367: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
368: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
369: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
370: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
371: X_FISCAL_PRINTER_TBL OUT NOCOPY ATTRIBUTE20_TBL
372: );
373:
374: PROCEDURE GET_FISCAL_PRINTER_AR
372: );
373:
374: PROCEDURE GET_FISCAL_PRINTER_AR
375: (
376: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
377: P_BATCH_SOURCE_ID_TBL IN ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL,
378: X_FISCAL_PRINTER_TBL OUT NOCOPY GDF_RA_BATCH_SOURCES_ATT7_TBL
379: );
380:
373:
374: PROCEDURE GET_FISCAL_PRINTER_AR
375: (
376: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
377: P_BATCH_SOURCE_ID_TBL IN ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL,
378: X_FISCAL_PRINTER_TBL OUT NOCOPY GDF_RA_BATCH_SOURCES_ATT7_TBL
379: );
380:
381: PROCEDURE GET_CAI_NUM
379: );
380:
381: PROCEDURE GET_CAI_NUM
382: (
383: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
384: P_REPORT_NAME IN VARCHAR2,
385: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
386: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
387: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
381: PROCEDURE GET_CAI_NUM
382: (
383: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
384: P_REPORT_NAME IN VARCHAR2,
385: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
386: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
387: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
388: P_INTERNAL_ORG_ID IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
389: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
382: (
383: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
384: P_REPORT_NAME IN VARCHAR2,
385: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
386: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
387: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
388: P_INTERNAL_ORG_ID IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
389: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
390: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
383: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
384: P_REPORT_NAME IN VARCHAR2,
385: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
386: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
387: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
388: P_INTERNAL_ORG_ID IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
389: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
390: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
391: );
384: P_REPORT_NAME IN VARCHAR2,
385: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
386: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
387: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
388: P_INTERNAL_ORG_ID IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
389: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
390: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
391: );
392:
391: );
392:
393: PROCEDURE GET_CAI_NUM_AR
394: (
395: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
396: P_REPORT_NAME IN VARCHAR2,
397: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
398: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
399: );
399: );
400:
401: PROCEDURE GET_TAX_AUTH_CATEG
402: (
403: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
404: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
405: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
406: X_TAX_AUTH_CATEG_TBL OUT NOCOPY ATTRIBUTE10_TBL
407: ) ;
400:
401: PROCEDURE GET_TAX_AUTH_CATEG
402: (
403: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
404: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
405: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
406: X_TAX_AUTH_CATEG_TBL OUT NOCOPY ATTRIBUTE10_TBL
407: ) ;
408: PROCEDURE PROV_JURISDICTION_CODE
401: PROCEDURE GET_TAX_AUTH_CATEG
402: (
403: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
404: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
405: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
406: X_TAX_AUTH_CATEG_TBL OUT NOCOPY ATTRIBUTE10_TBL
407: ) ;
408: PROCEDURE PROV_JURISDICTION_CODE
409: (
406: X_TAX_AUTH_CATEG_TBL OUT NOCOPY ATTRIBUTE10_TBL
407: ) ;
408: PROCEDURE PROV_JURISDICTION_CODE
409: (
410: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
411: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
412: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
413: X_PROV_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE1_TBL
414: ) ;
407: ) ;
408: PROCEDURE PROV_JURISDICTION_CODE
409: (
410: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
411: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
412: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
413: X_PROV_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE1_TBL
414: ) ;
415: PROCEDURE MUN_JURISDICTION_CODE
408: PROCEDURE PROV_JURISDICTION_CODE
409: (
410: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
411: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
412: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
413: X_PROV_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE1_TBL
414: ) ;
415: PROCEDURE MUN_JURISDICTION_CODE
416: (
413: X_PROV_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE1_TBL
414: ) ;
415: PROCEDURE MUN_JURISDICTION_CODE
416: (
417: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
418: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
419: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
420: X_MUN_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE3_TBL
421: ) ;
414: ) ;
415: PROCEDURE MUN_JURISDICTION_CODE
416: (
417: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
418: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
419: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
420: X_MUN_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE3_TBL
421: ) ;
422:
415: PROCEDURE MUN_JURISDICTION_CODE
416: (
417: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
418: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
419: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
420: X_MUN_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE3_TBL
421: ) ;
422:
423: PROCEDURE GET_TAXPAYERID_TYPE
421: ) ;
422:
423: PROCEDURE GET_TAXPAYERID_TYPE
424: (
425: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
426: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
427: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
428: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
429: X_TAXPAYERID_TYPE_TBL OUT NOCOPY ATTRIBUTE21_TBL,
422:
423: PROCEDURE GET_TAXPAYERID_TYPE
424: (
425: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
426: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
427: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
428: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
429: X_TAXPAYERID_TYPE_TBL OUT NOCOPY ATTRIBUTE21_TBL,
430: X_REG_STATUS_CODE_TBL OUT NOCOPY ATTRIBUTE22_TBL
423: PROCEDURE GET_TAXPAYERID_TYPE
424: (
425: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
426: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
427: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
428: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
429: X_TAXPAYERID_TYPE_TBL OUT NOCOPY ATTRIBUTE21_TBL,
430: X_REG_STATUS_CODE_TBL OUT NOCOPY ATTRIBUTE22_TBL
431: );
424: (
425: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
426: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
427: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
428: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
429: X_TAXPAYERID_TYPE_TBL OUT NOCOPY ATTRIBUTE21_TBL,
430: X_REG_STATUS_CODE_TBL OUT NOCOPY ATTRIBUTE22_TBL
431: );
432:
432:
433: PROCEDURE GET_DGI_TAX_REGIME_CODE
434: (
435: P_VAT_PERCEP_TAX IN VARCHAR2,
436: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
437: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
438: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
439: P_REQUEST_ID IN NUMBER,
440: X_DGI_TAX_REGIME_CODE_TBL OUT NOCOPY ATTRIBUTE25_TBL
433: PROCEDURE GET_DGI_TAX_REGIME_CODE
434: (
435: P_VAT_PERCEP_TAX IN VARCHAR2,
436: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
437: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
438: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
439: P_REQUEST_ID IN NUMBER,
440: X_DGI_TAX_REGIME_CODE_TBL OUT NOCOPY ATTRIBUTE25_TBL
441: );
434: (
435: P_VAT_PERCEP_TAX IN VARCHAR2,
436: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
437: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
438: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
439: P_REQUEST_ID IN NUMBER,
440: X_DGI_TAX_REGIME_CODE_TBL OUT NOCOPY ATTRIBUTE25_TBL
441: );
442:
441: );
442:
443: PROCEDURE GET_DGI_CODE
444: (
445: P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL,
446: P_TRX_CATEGORY_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL,
447: P_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
448: X_DGI_CODE_TBL OUT NOCOPY ATTRIBUTE11_TBL
449: );
442:
443: PROCEDURE GET_DGI_CODE
444: (
445: P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL,
446: P_TRX_CATEGORY_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL,
447: P_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
448: X_DGI_CODE_TBL OUT NOCOPY ATTRIBUTE11_TBL
449: );
450: PROCEDURE GET_DGI_DOC_TYPE
443: PROCEDURE GET_DGI_CODE
444: (
445: P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL,
446: P_TRX_CATEGORY_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL,
447: P_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
448: X_DGI_CODE_TBL OUT NOCOPY ATTRIBUTE11_TBL
449: );
450: PROCEDURE GET_DGI_DOC_TYPE
451: (
448: X_DGI_CODE_TBL OUT NOCOPY ATTRIBUTE11_TBL
449: );
450: PROCEDURE GET_DGI_DOC_TYPE
451: (
452: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
453: X_DGI_DOC_TYPE_TBL OUT NOCOPY ATTRIBUTE1_TBL,
454: X_GDF_AP_INV_ATT11_TBL OUT NOCOPY GDF_AP_INV_ATT11_TBL,
455: X_GDF_AP_INV_ATT12_TBL OUT NOCOPY GDF_AP_INV_ATT12_TBL
456: );
456: );
457:
458: PROCEDURE DGI_TRX_CODE
459: (
460: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
461: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
462: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
463: X_DGI_TRX_CODE_TBL OUT NOCOPY ATTRIBUTE4_TBL
464: );
457:
458: PROCEDURE DGI_TRX_CODE
459: (
460: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
461: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
462: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
463: X_DGI_TRX_CODE_TBL OUT NOCOPY ATTRIBUTE4_TBL
464: );
465:
458: PROCEDURE DGI_TRX_CODE
459: (
460: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
461: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
462: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
463: X_DGI_TRX_CODE_TBL OUT NOCOPY ATTRIBUTE4_TBL
464: );
465:
466: PROCEDURE UPDATE_DGI_CURR_CODE
469: );
470:
471: PROCEDURE GET_LOOKUP_INFO
472: (
473: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
474: X_JLCL_AP_DOC_TYPE_MEANING_TBL OUT NOCOPY DOCUMENT_SUB_TYPE_MNG_TBL,
475: X_ORDER_BY_DOC_TYPE_TBL OUT NOCOPY ATTRIBUTE14_TBL
476: );
477:
478: PROCEDURE GET_REC_COUNT
479: (
480: P_VAT_TAX IN ZX_REP_TRX_DETAIL_T.TAX%TYPE,
481: P_TAX_REGIME IN ZX_REP_TRX_DETAIL_T.TAX_REGIME_CODE%TYPE,
482: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
483: P_REQUEST_ID IN NUMBER,
484: X_REC_COUNT_TBL OUT NOCOPY NUMERIC11_TBL
485: );
486:
488: (
489: P_VAT_TAX IN ZX_REP_TRX_DETAIL_T.TAX%TYPE,
490: P_VAT_NON_TAX IN ZX_REP_TRX_DETAIL_T.TAX%TYPE,
491: P_TAX_REGIME IN ZX_REP_TRX_DETAIL_T.TAX_REGIME_CODE%TYPE,
492: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
493: P_REQUEST_ID IN NUMBER,
494: X_RATE_COUNT_TBL OUT NOCOPY NUMERIC13_TBL
495: );
496:
495: );
496:
497: PROCEDURE GET_TOTAL_DOCUMENT_AMOUNT
498: (
499: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
500: P_EXCHANGE_RATE_TBL IN ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL,
501: P_REPORT_NAME IN VARCHAR2,
502: X_TOTAL_DOC_AMT_TBL OUT NOCOPY NUMERIC12_TBL
503: );
496:
497: PROCEDURE GET_TOTAL_DOCUMENT_AMOUNT
498: (
499: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
500: P_EXCHANGE_RATE_TBL IN ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL,
501: P_REPORT_NAME IN VARCHAR2,
502: X_TOTAL_DOC_AMT_TBL OUT NOCOPY NUMERIC12_TBL
503: );
504:
503: );
504:
505: PROCEDURE GET_TOTAL_DOC_TAXABLE_AMOUNT
506: (
507: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
508: P_REQUEST_ID IN NUMBER,
509: X_TOTAL_DOC_TAXAB_AMT_TBL OUT NOCOPY NUMERIC8_TBL
510: );
511:
511:
512: PROCEDURE GET_VALIDATION_DIGIT
513: (
514: P_REQUEST_ID IN NUMBER,
515: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
516: X_VALIDATION_DIGIT_TBL OUT NOCOPY ATTRIBUTE12_TBL
517: );
518:
519: -- Declare global varibles for FND log messages
536:
537: END FILTER_JL_AP_TAX_LINES;
538:
539: PROCEDURE FILTER_JL_AR_TAX_LINES
540: (P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
541: ) IS
542: BEGIN
543:
544: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
625: | |
626: +===========================================================================*/
627:
628: PROCEDURE POPULATE_JL_AP(
629: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
630: )
631: IS
632:
633: P_REQUEST_ID NUMBER;
654: P_VAT_ADDIT_TAX_TYPE VARCHAR2(30);
655:
656: l_err_msg VARCHAR2(120);
657:
658: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
659: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
660: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
661: l_trx_line_dist_id_tbl ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL;
662: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
655:
656: l_err_msg VARCHAR2(120);
657:
658: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
659: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
660: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
661: l_trx_line_dist_id_tbl ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL;
662: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
663: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
656: l_err_msg VARCHAR2(120);
657:
658: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
659: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
660: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
661: l_trx_line_dist_id_tbl ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL;
662: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
663: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
664: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
657:
658: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
659: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
660: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
661: l_trx_line_dist_id_tbl ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL;
662: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
663: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
664: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
665: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
658: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
659: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
660: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
661: l_trx_line_dist_id_tbl ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL;
662: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
663: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
664: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
665: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
666: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
659: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
660: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
661: l_trx_line_dist_id_tbl ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL;
662: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
663: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
664: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
665: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
666: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
667: l_trx_currency_code_tbl ZX_EXTRACT_PKG.TRX_CURRENCY_CODE_TBL;
660: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
661: l_trx_line_dist_id_tbl ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL;
662: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
663: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
664: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
665: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
666: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
667: l_trx_currency_code_tbl ZX_EXTRACT_PKG.TRX_CURRENCY_CODE_TBL;
668: l_vat_exempt_amt_tbl NUMERIC2_TBL;
661: l_trx_line_dist_id_tbl ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL;
662: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
663: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
664: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
665: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
666: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
667: l_trx_currency_code_tbl ZX_EXTRACT_PKG.TRX_CURRENCY_CODE_TBL;
668: l_vat_exempt_amt_tbl NUMERIC2_TBL;
669: l_vat_perc_amt_tbl NUMERIC3_TBL;
662: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
663: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
664: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
665: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
666: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
667: l_trx_currency_code_tbl ZX_EXTRACT_PKG.TRX_CURRENCY_CODE_TBL;
668: l_vat_exempt_amt_tbl NUMERIC2_TBL;
669: l_vat_perc_amt_tbl NUMERIC3_TBL;
670: l_other_fed_perc_amt_tbl NUMERIC7_TBL;
663: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
664: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
665: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
666: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
667: l_trx_currency_code_tbl ZX_EXTRACT_PKG.TRX_CURRENCY_CODE_TBL;
668: l_vat_exempt_amt_tbl NUMERIC2_TBL;
669: l_vat_perc_amt_tbl NUMERIC3_TBL;
670: l_other_fed_perc_amt_tbl NUMERIC7_TBL;
671: l_prov_perc_amt_tbl NUMERIC4_TBL;
696: l_taxpayerid_type_tbl ATTRIBUTE21_TBL;
697: l_reg_status_code_tbl ATTRIBUTE22_TBL;
698: l_jlcl_ap_doc_type_mng_tbl DOCUMENT_SUB_TYPE_MNG_TBL;
699:
700: l_tax_regime_code_tbl ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL;
701: l_bill_from_site_prof_id_tbl ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL;
702: --l_shipping_tp_address_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
703: --l_billing_tp_address_id_tbl ZX_EXTRACT_PKG.BILLING_TP_ADDRESS_ID_TBL;
704: l_bill_from_site_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
697: l_reg_status_code_tbl ATTRIBUTE22_TBL;
698: l_jlcl_ap_doc_type_mng_tbl DOCUMENT_SUB_TYPE_MNG_TBL;
699:
700: l_tax_regime_code_tbl ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL;
701: l_bill_from_site_prof_id_tbl ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL;
702: --l_shipping_tp_address_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
703: --l_billing_tp_address_id_tbl ZX_EXTRACT_PKG.BILLING_TP_ADDRESS_ID_TBL;
704: l_bill_from_site_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
705: l_bill_from_tp_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
698: l_jlcl_ap_doc_type_mng_tbl DOCUMENT_SUB_TYPE_MNG_TBL;
699:
700: l_tax_regime_code_tbl ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL;
701: l_bill_from_site_prof_id_tbl ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL;
702: --l_shipping_tp_address_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
703: --l_billing_tp_address_id_tbl ZX_EXTRACT_PKG.BILLING_TP_ADDRESS_ID_TBL;
704: l_bill_from_site_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
705: l_bill_from_tp_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
706:
699:
700: l_tax_regime_code_tbl ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL;
701: l_bill_from_site_prof_id_tbl ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL;
702: --l_shipping_tp_address_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
703: --l_billing_tp_address_id_tbl ZX_EXTRACT_PKG.BILLING_TP_ADDRESS_ID_TBL;
704: l_bill_from_site_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
705: l_bill_from_tp_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
706:
707: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
700: l_tax_regime_code_tbl ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL;
701: l_bill_from_site_prof_id_tbl ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL;
702: --l_shipping_tp_address_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
703: --l_billing_tp_address_id_tbl ZX_EXTRACT_PKG.BILLING_TP_ADDRESS_ID_TBL;
704: l_bill_from_site_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
705: l_bill_from_tp_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
706:
707: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
708: l_tax_amt_func_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
701: l_bill_from_site_prof_id_tbl ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL;
702: --l_shipping_tp_address_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
703: --l_billing_tp_address_id_tbl ZX_EXTRACT_PKG.BILLING_TP_ADDRESS_ID_TBL;
704: l_bill_from_site_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
705: l_bill_from_tp_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
706:
707: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
708: l_tax_amt_func_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
709:
703: --l_billing_tp_address_id_tbl ZX_EXTRACT_PKG.BILLING_TP_ADDRESS_ID_TBL;
704: l_bill_from_site_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
705: l_bill_from_tp_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
706:
707: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
708: l_tax_amt_func_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
709:
710: BEGIN
711:
704: l_bill_from_site_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
705: l_bill_from_tp_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
706:
707: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
708: l_tax_amt_func_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
709:
710: BEGIN
711:
712: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1914: +======================================================================================*/
1915:
1916:
1917: PROCEDURE POPULATE_JL_AR(
1918: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
1919: )
1920: IS
1921:
1922: P_TAX_REGIME VARCHAR2(30);
1932: P_TRX_LETTER_TO VARCHAR2(30);
1933: P_REPORT_NAME VARCHAR2(30);
1934: P_REQUEST_ID NUMBER;
1935:
1936: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1937: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1938: l_trx_line_dist_id_tbl ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL;
1939: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1940: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1933: P_REPORT_NAME VARCHAR2(30);
1934: P_REQUEST_ID NUMBER;
1935:
1936: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1937: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1938: l_trx_line_dist_id_tbl ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL;
1939: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1940: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1941: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1934: P_REQUEST_ID NUMBER;
1935:
1936: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1937: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1938: l_trx_line_dist_id_tbl ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL;
1939: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1940: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1941: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1942: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1935:
1936: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1937: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1938: l_trx_line_dist_id_tbl ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL;
1939: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1940: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1941: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1942: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1943: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1936: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1937: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1938: l_trx_line_dist_id_tbl ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL;
1939: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1940: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1941: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1942: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1943: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1944: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
1937: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1938: l_trx_line_dist_id_tbl ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL;
1939: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1940: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1941: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1942: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1943: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1944: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
1945: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1938: l_trx_line_dist_id_tbl ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL;
1939: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1940: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1941: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1942: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1943: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1944: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
1945: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1946: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1939: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1940: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1941: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1942: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1943: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1944: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
1945: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1946: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1947: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1940: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1941: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1942: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1943: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1944: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
1945: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1946: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1947: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1948:
1941: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1942: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1943: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1944: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
1945: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1946: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1947: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1948:
1949: l_not_reg_tax_amt_tbl NUMERIC1_TBL;
1942: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1943: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1944: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
1945: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1946: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1947: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1948:
1949: l_not_reg_tax_amt_tbl NUMERIC1_TBL;
1950: l_vat_exempt_amt_tbl NUMERIC2_TBL;
1943: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1944: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
1945: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1946: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1947: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1948:
1949: l_not_reg_tax_amt_tbl NUMERIC1_TBL;
1950: l_vat_exempt_amt_tbl NUMERIC2_TBL;
1951: l_vat_perc_amt_tbl NUMERIC3_TBL;
1972: l_cai_number_tbl ATTRIBUTE19_TBL;
1973: l_cai_due_date_tbl ATTRIBUTE23_TBL;
1974: l_dgi_trx_code_tbl ATTRIBUTE4_TBL;
1975: l_count NUMBER;
1976: l_tax_regime_code_tbl ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL;
1977:
1978: l_tax_catg_desc zx_rep_trx_jx_ext_t.attribute1%type; --bug 5251425
1979: l_extended_amt_tbl NUMERIC10_TBL; --Bug 5396444
1980: l_validation_digit_tbl ATTRIBUTE12_TBL;
3641: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
3642: | P_TAX_REGIME IN VARCHAR2 Opt |
3643: | P_REPORT_NAME IN VARCHAR2 Req |
3644: | P_REQUEST_ID IN NUMBER Req |
3645: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req |
3646: | P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL |
3647: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
3648: | SUB_TYPE_TBL Opt |
3649: | |
3642: | P_TAX_REGIME IN VARCHAR2 Opt |
3643: | P_REPORT_NAME IN VARCHAR2 Req |
3644: | P_REQUEST_ID IN NUMBER Req |
3645: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req |
3646: | P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL |
3647: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
3648: | SUB_TYPE_TBL Opt |
3649: | |
3650: | OUT : X_VAT_AMT_TBL OUT NUMERIC9_TBL |
3643: | P_REPORT_NAME IN VARCHAR2 Req |
3644: | P_REQUEST_ID IN NUMBER Req |
3645: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req |
3646: | P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL |
3647: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
3648: | SUB_TYPE_TBL Opt |
3649: | |
3650: | OUT : X_VAT_AMT_TBL OUT NUMERIC9_TBL |
3651: | |
3661: P_VAT_TAX IN VARCHAR2 DEFAULT NULL,
3662: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
3663: P_REPORT_NAME IN VARCHAR2,
3664: P_REQUEST_ID IN NUMBER,
3665: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
3666: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
3667: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
3668: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
3669: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
3662: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
3663: P_REPORT_NAME IN VARCHAR2,
3664: P_REQUEST_ID IN NUMBER,
3665: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
3666: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
3667: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
3668: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
3669: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
3670: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
3663: P_REPORT_NAME IN VARCHAR2,
3664: P_REQUEST_ID IN NUMBER,
3665: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
3666: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
3667: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
3668: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
3669: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
3670: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
3671: X_VAT_AMT_TBL OUT NOCOPY NUMERIC9_TBL
3664: P_REQUEST_ID IN NUMBER,
3665: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
3666: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
3667: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
3668: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
3669: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
3670: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
3671: X_VAT_AMT_TBL OUT NOCOPY NUMERIC9_TBL
3672:
3665: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
3666: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
3667: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
3668: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
3669: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
3670: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
3671: X_VAT_AMT_TBL OUT NOCOPY NUMERIC9_TBL
3672:
3673: ) IS
3666: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
3667: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
3668: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
3669: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
3670: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
3671: X_VAT_AMT_TBL OUT NOCOPY NUMERIC9_TBL
3672:
3673: ) IS
3674:
4146: | Parameters : |
4147: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
4148: | P_REPORT_NAME IN VARCHAR2 Req |
4149: | P_REQUEST_ID IN NUMBER Req |
4150: | P_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl |
4151: | P_trx_line_id_tbl IN ZX_EXTRACT_PKG.P_trx_line_id_tbl |
4152: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
4153: | P_TRX_RATE_TBL IN ZX_EXTRACT_PKG.RATE_TBL Opt|
4154: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
4147: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
4148: | P_REPORT_NAME IN VARCHAR2 Req |
4149: | P_REQUEST_ID IN NUMBER Req |
4150: | P_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl |
4151: | P_trx_line_id_tbl IN ZX_EXTRACT_PKG.P_trx_line_id_tbl |
4152: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
4153: | P_TRX_RATE_TBL IN ZX_EXTRACT_PKG.RATE_TBL Opt|
4154: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
4155: | SUB_TYPE_TBL Opt|
4148: | P_REPORT_NAME IN VARCHAR2 Req |
4149: | P_REQUEST_ID IN NUMBER Req |
4150: | P_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl |
4151: | P_trx_line_id_tbl IN ZX_EXTRACT_PKG.P_trx_line_id_tbl |
4152: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
4153: | P_TRX_RATE_TBL IN ZX_EXTRACT_PKG.RATE_TBL Opt|
4154: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
4155: | SUB_TYPE_TBL Opt|
4156: | |
4149: | P_REQUEST_ID IN NUMBER Req |
4150: | P_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl |
4151: | P_trx_line_id_tbl IN ZX_EXTRACT_PKG.P_trx_line_id_tbl |
4152: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
4153: | P_TRX_RATE_TBL IN ZX_EXTRACT_PKG.RATE_TBL Opt|
4154: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
4155: | SUB_TYPE_TBL Opt|
4156: | |
4157: | OUT |
4150: | P_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl |
4151: | P_trx_line_id_tbl IN ZX_EXTRACT_PKG.P_trx_line_id_tbl |
4152: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
4153: | P_TRX_RATE_TBL IN ZX_EXTRACT_PKG.RATE_TBL Opt|
4154: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
4155: | SUB_TYPE_TBL Opt|
4156: | |
4157: | OUT |
4158: | X_TAXABLE_AMT_TBL OUT NUMERIC10_TBL |
4168: P_VAT_TAX IN VARCHAR2 DEFAULT NULL,
4169: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
4170: P_REPORT_NAME IN VARCHAR2,
4171: P_REQUEST_ID IN NUMBER,
4172: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4173: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4174: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
4175: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4176: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4169: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
4170: P_REPORT_NAME IN VARCHAR2,
4171: P_REQUEST_ID IN NUMBER,
4172: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4173: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4174: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
4175: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4176: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4177: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
4170: P_REPORT_NAME IN VARCHAR2,
4171: P_REQUEST_ID IN NUMBER,
4172: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4173: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4174: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
4175: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4176: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4177: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
4178: X_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC10_TBL
4171: P_REQUEST_ID IN NUMBER,
4172: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4173: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4174: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
4175: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4176: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4177: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
4178: X_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC10_TBL
4179:
4172: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4173: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4174: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
4175: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4176: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4177: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
4178: X_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC10_TBL
4179:
4180: ) IS
4173: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4174: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
4175: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4176: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4177: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
4178: X_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC10_TBL
4179:
4180: ) IS
4181:
4790: | Parameters : |
4791: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
4792: | P_REPORT_NAME IN VARCHAR2 Req |
4793: | P_REQUEST_ID IN NUMBER Req |
4794: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
4795: | |
4796: | OUT |
4797: | X_NON_TAXABLE_AMT_TBL OUT NUMERIC8_TBL |
4798: | |
4809: P_VAT_ADDIT_TAX IN VARCHAR2 DEFAULT NULL,
4810: P_VAT_PERCEP_TAX IN VARCHAR2 DEFAULT NULL,
4811: P_REPORT_NAME IN VARCHAR2,
4812: p_REQUEST_ID IN NUMBER,
4813: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4814: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4815: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4816: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4817: X_NON_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC8_TBL
4810: P_VAT_PERCEP_TAX IN VARCHAR2 DEFAULT NULL,
4811: P_REPORT_NAME IN VARCHAR2,
4812: p_REQUEST_ID IN NUMBER,
4813: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4814: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4815: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4816: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4817: X_NON_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC8_TBL
4818: ) IS
4811: P_REPORT_NAME IN VARCHAR2,
4812: p_REQUEST_ID IN NUMBER,
4813: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4814: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4815: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4816: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4817: X_NON_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC8_TBL
4818: ) IS
4819:
4812: p_REQUEST_ID IN NUMBER,
4813: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4814: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4815: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4816: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4817: X_NON_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC8_TBL
4818: ) IS
4819:
4820: l_err_msg VARCHAR2(120);
5021: | Parameters : |
5022: | IN : P_VAT_ADDIT_TAX IN VARCHAR2 Opt |
5023: | P_REPORT_NAME IN VARCHAR2 Req |
5024: | P_REQUEST_ID IN NUMBER Req |
5025: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
5026: | P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
5027: | SUB_TYPE_TBL Opt|
5028: | |
5029: | OUT |
5022: | IN : P_VAT_ADDIT_TAX IN VARCHAR2 Opt |
5023: | P_REPORT_NAME IN VARCHAR2 Req |
5024: | P_REQUEST_ID IN NUMBER Req |
5025: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
5026: | P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
5027: | SUB_TYPE_TBL Opt|
5028: | |
5029: | OUT |
5030: | X_VAT_ADDITIONAL_AMT_TBL OUT NUMERIC11_TBL |
5039: (
5040: P_VAT_ADDIT_TAX IN VARCHAR2 DEFAULT NULL,
5041: P_REPORT_NAME IN VARCHAR2,
5042: p_REQUEST_ID IN NUMBER,
5043: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5044: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
5045: X_VAT_ADDITIONAL_AMT_TBL OUT NOCOPY NUMERIC7_TBL
5046: ) IS
5047:
5040: P_VAT_ADDIT_TAX IN VARCHAR2 DEFAULT NULL,
5041: P_REPORT_NAME IN VARCHAR2,
5042: p_REQUEST_ID IN NUMBER,
5043: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5044: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
5045: X_VAT_ADDITIONAL_AMT_TBL OUT NOCOPY NUMERIC7_TBL
5046: ) IS
5047:
5048: l_err_msg VARCHAR2(120);
5171: | Parameters : |
5172: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
5173: | P_REPORT_NAME IN VARCHAR2 Req |
5174: | P_REQUEST_ID IN NUMBER Req |
5175: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
5176: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
5177: | SUB_TYPE_TBL Opt|
5178: | |
5179: | OUT |
5172: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
5173: | P_REPORT_NAME IN VARCHAR2 Req |
5174: | P_REQUEST_ID IN NUMBER Req |
5175: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
5176: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
5177: | SUB_TYPE_TBL Opt|
5178: | |
5179: | OUT |
5180: | X_VAT_EXEMPT_AMT_TBL OUT NUMERIC14_TBL |
5192: P_VAT_PERCEP_TAX IN VARCHAR2 DEFAULT NULL,
5193: P_REPORT_NAME IN VARCHAR2,
5194: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
5195: p_REQUEST_ID IN NUMBER,
5196: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5197: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
5198: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
5199: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5200: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
5193: P_REPORT_NAME IN VARCHAR2,
5194: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
5195: p_REQUEST_ID IN NUMBER,
5196: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5197: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
5198: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
5199: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5200: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
5201: X_VAT_EXEMPT_AMT_TBL OUT NOCOPY NUMERIC2_TBL
5194: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
5195: p_REQUEST_ID IN NUMBER,
5196: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5197: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
5198: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
5199: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5200: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
5201: X_VAT_EXEMPT_AMT_TBL OUT NOCOPY NUMERIC2_TBL
5202: ) IS
5195: p_REQUEST_ID IN NUMBER,
5196: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5197: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
5198: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
5199: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5200: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
5201: X_VAT_EXEMPT_AMT_TBL OUT NOCOPY NUMERIC2_TBL
5202: ) IS
5203:
5196: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5197: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
5198: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
5199: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5200: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
5201: X_VAT_EXEMPT_AMT_TBL OUT NOCOPY NUMERIC2_TBL
5202: ) IS
5203:
5204: l_err_msg VARCHAR2(120);
5650: | Parameters : |
5651: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
5652: | P_REPORT_NAME IN VARCHAR2 Req |
5653: | P_REQUEST_ID IN NUMBER Req |
5654: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
5655: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
5656: | SUB_TYPE_TBL Opt|
5657: | |
5658: | OUT |
5651: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
5652: | P_REPORT_NAME IN VARCHAR2 Req |
5653: | P_REQUEST_ID IN NUMBER Req |
5654: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
5655: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
5656: | SUB_TYPE_TBL Opt|
5657: | |
5658: | OUT |
5659: | X_VAT_PERCEPTION_AMT_TBL OUT NUMERIC3_TBL |
5671: P_VAT_PERC_TAX IN VARCHAR2 DEFAULT NULL,
5672: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
5673: P_REPORT_NAME IN VARCHAR2,
5674: p_REQUEST_ID IN NUMBER,
5675: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5676: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
5677: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5678: X_VAT_PERCEPTION_AMT_TBL OUT NOCOPY NUMERIC3_TBL
5679: ) IS
5672: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
5673: P_REPORT_NAME IN VARCHAR2,
5674: p_REQUEST_ID IN NUMBER,
5675: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5676: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
5677: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5678: X_VAT_PERCEPTION_AMT_TBL OUT NOCOPY NUMERIC3_TBL
5679: ) IS
5680:
5673: P_REPORT_NAME IN VARCHAR2,
5674: p_REQUEST_ID IN NUMBER,
5675: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5676: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
5677: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5678: X_VAT_PERCEPTION_AMT_TBL OUT NOCOPY NUMERIC3_TBL
5679: ) IS
5680:
5681: l_err_msg VARCHAR2(120);
6067: | Parameters : |
6068: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
6069: | P_REPORT_NAME IN VARCHAR2 Req |
6070: | P_REQUEST_ID IN NUMBER Req |
6071: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
6072: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
6073: | SUB_TYPE_TBL Opt|
6074: | |
6075: | OUT |
6068: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
6069: | P_REPORT_NAME IN VARCHAR2 Req |
6070: | P_REQUEST_ID IN NUMBER Req |
6071: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
6072: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
6073: | SUB_TYPE_TBL Opt|
6074: | |
6075: | OUT |
6076: | X_OTHER_FED_PERC_AMT_TBL OUT NUMERIC7_TBL |
6088: P_VAT_PERC_TAX IN VARCHAR2 DEFAULT NULL,
6089: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6090: P_REPORT_NAME IN VARCHAR2,
6091: p_REQUEST_ID IN NUMBER,
6092: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6093: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6094: X_OTHER_FED_PERC_AMT_TBL OUT NOCOPY NUMERIC7_TBL
6095: ) IS
6096:
6089: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6090: P_REPORT_NAME IN VARCHAR2,
6091: p_REQUEST_ID IN NUMBER,
6092: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6093: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6094: X_OTHER_FED_PERC_AMT_TBL OUT NOCOPY NUMERIC7_TBL
6095: ) IS
6096:
6097: l_err_msg VARCHAR2(120);
6209: | Parameters : |
6210: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
6211: | P_REPORT_NAME IN VARCHAR2 Req |
6212: | P_REQUEST_ID IN NUMBER Req |
6213: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
6214: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
6215: | SUB_TYPE_TBL Opt|
6216: | |
6217: | OUT |
6210: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
6211: | P_REPORT_NAME IN VARCHAR2 Req |
6212: | P_REQUEST_ID IN NUMBER Req |
6213: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
6214: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
6215: | SUB_TYPE_TBL Opt|
6216: | |
6217: | OUT |
6218: | X_OTHER_TAX_AMT_TBL OUT NUMERIC7_TBL |
6226: PROCEDURE GET_OTHER_TAX_AMOUNT
6227: (
6228: P_REPORT_NAME IN VARCHAR2,
6229: p_REQUEST_ID IN NUMBER,
6230: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6231: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6232: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
6233: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
6234: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
6227: (
6228: P_REPORT_NAME IN VARCHAR2,
6229: p_REQUEST_ID IN NUMBER,
6230: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6231: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6232: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
6233: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
6234: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
6235: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
6228: P_REPORT_NAME IN VARCHAR2,
6229: p_REQUEST_ID IN NUMBER,
6230: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6231: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6232: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
6233: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
6234: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
6235: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
6236: X_OTHER_TAX_AMT_TBL OUT NOCOPY NUMERIC7_TBL
6229: p_REQUEST_ID IN NUMBER,
6230: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6231: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6232: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
6233: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
6234: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
6235: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
6236: X_OTHER_TAX_AMT_TBL OUT NOCOPY NUMERIC7_TBL
6237: ) IS
6230: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6231: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6232: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
6233: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
6234: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
6235: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
6236: X_OTHER_TAX_AMT_TBL OUT NOCOPY NUMERIC7_TBL
6237: ) IS
6238:
6231: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6232: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
6233: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
6234: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
6235: P_TRX_LINE_DIST_ID IN ZX_EXTRACT_PKG.TAXABLE_ITEM_SOURCE_ID_TBL,
6236: X_OTHER_TAX_AMT_TBL OUT NOCOPY NUMERIC7_TBL
6237: ) IS
6238:
6239: l_err_msg VARCHAR2(120);
6419: | Parameters : |
6420: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
6421: | P_REPORT_NAME IN VARCHAR2 Req |
6422: | P_REQUEST_ID IN NUMBER Req |
6423: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
6424: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
6425: | SUB_TYPE_TBL Opt|
6426: | |
6427: | OUT |
6420: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
6421: | P_REPORT_NAME IN VARCHAR2 Req |
6422: | P_REQUEST_ID IN NUMBER Req |
6423: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
6424: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
6425: | SUB_TYPE_TBL Opt|
6426: | |
6427: | OUT |
6428: | X_OTHER_TAX_AMT_TBL OUT NUMERIC3_TBL |
6439: P_VAT_ADDIT_TAX IN VARCHAR2 DEFAULT NULL,
6440: P_VAT_NOT_CATEG_TAX IN VARCHAR2 DEFAULT NULL,
6441: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6442: p_REQUEST_ID IN NUMBER,
6443: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6444: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6445: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
6446: X_NOT_REG_TAX_AMT_TBL OUT NOCOPY NUMERIC1_TBL
6447: ) IS
6440: P_VAT_NOT_CATEG_TAX IN VARCHAR2 DEFAULT NULL,
6441: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6442: p_REQUEST_ID IN NUMBER,
6443: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6444: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6445: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
6446: X_NOT_REG_TAX_AMT_TBL OUT NOCOPY NUMERIC1_TBL
6447: ) IS
6448:
6441: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6442: p_REQUEST_ID IN NUMBER,
6443: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6444: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6445: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
6446: X_NOT_REG_TAX_AMT_TBL OUT NOCOPY NUMERIC1_TBL
6447: ) IS
6448:
6449: l_err_msg VARCHAR2(120);
6664: | P_PROV_TAX_TYPE_TO IN VARCHAR2 Opt
6665: | P_PROV_TAX_REGIME IN VARCHAR2 Opt
6666: | P_REPORT_NAME IN VARCHAR2 Req |
6667: | P_REQUEST_ID IN NUMBER Req |
6668: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
6669: | |
6670: | OUT |
6671: | X_PROVINCIAL_PERC_AMT_TBLOUT NUMERIC4_TBL |
6672: | |
6682: P_PROV_TAX_TYPE_TO IN VARCHAR2 DEFAULT NULL,
6683: P_PROV_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6684: P_REPORT_NAME IN VARCHAR2,
6685: p_REQUEST_ID IN NUMBER,
6686: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6687: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
6688: X_PROVINCIAL_PERC_AMT_TBL OUT NOCOPY NUMERIC4_TBL
6689: ) IS
6690:
6683: P_PROV_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6684: P_REPORT_NAME IN VARCHAR2,
6685: p_REQUEST_ID IN NUMBER,
6686: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6687: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
6688: X_PROVINCIAL_PERC_AMT_TBL OUT NOCOPY NUMERIC4_TBL
6689: ) IS
6690:
6691: l_err_msg VARCHAR2(120);
6890: | IN : P_MUN_TAX_TYPE_FROM IN VARCHAR2 Opt |
6891: | P_MUN_TAX_TYPE_TO IN VARCHAR2 Opt |
6892: | P_REPORT_NAME IN VARCHAR2 Req |
6893: | P_REQUEST_ID IN NUMBER Req |
6894: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
6895: | |
6896: | OUT |
6897: | X_MUNICIPAL_PERC_AMT_TBL OUT NUMERIC5_TBL |
6898: | |
6908: P_MUN_TAX_TYPE_TO IN VARCHAR2 DEFAULT NULL,
6909: P_MUN_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6910: P_REPORT_NAME IN VARCHAR2,
6911: p_REQUEST_ID IN NUMBER,
6912: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6913: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
6914: X_MUNICIPAL_PERC_AMT_TBL OUT NOCOPY NUMERIC5_TBL
6915: ) IS
6916:
6909: P_MUN_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6910: P_REPORT_NAME IN VARCHAR2,
6911: p_REQUEST_ID IN NUMBER,
6912: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6913: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
6914: X_MUNICIPAL_PERC_AMT_TBL OUT NOCOPY NUMERIC5_TBL
6915: ) IS
6916:
6917: l_err_msg VARCHAR2(120);
7119: | Parameters : |
7120: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
7121: | P_REPORT_NAME IN VARCHAR2 Req |
7122: | P_REQUEST_ID IN NUMBER Req |
7123: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
7124: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
7125: | SUB_TYPE_TBL Opt|
7126: | |
7127: | OUT |
7120: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
7121: | P_REPORT_NAME IN VARCHAR2 Req |
7122: | P_REQUEST_ID IN NUMBER Req |
7123: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
7124: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
7125: | SUB_TYPE_TBL Opt|
7126: | |
7127: | OUT |
7128: | X_EXCISE_TAX_AMT_TBL OUT NUMERIC5_TBL |
7139: P_EXC_TAX_TYPE_TO IN VARCHAR2 DEFAULT NULL,
7140: P_EXC_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
7141: P_REPORT_NAME IN VARCHAR2,
7142: p_REQUEST_ID IN NUMBER,
7143: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
7144: X_EXCISE_AMT_TBL OUT NOCOPY NUMERIC6_TBL
7145: ) IS
7146:
7147: l_err_msg VARCHAR2(120);
7318: | |
7319: | Parameters : |
7320: | IN : P_REPORT_NAME IN VARCHAR2 Req |
7321: | P_REQUEST_ID IN NUMBER Req |
7322: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
7323: | SUB_TYPE_TBL Opt|
7324: | |
7325: | OUT |
7326: | X_CL_NUM_OF_DOC_TBL OUT NUMERIC5_TBL |
7334: PROCEDURE GET_COUNTED_SUM_DOC
7335: (
7336: P_REPORT_NAME IN VARCHAR2,
7337: P_REQUEST_ID IN NUMBER,
7338: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
7339: X_CL_NUM_OF_DOC_TBL OUT NOCOPY NUMERIC3_TBL,
7340: X_CL_TOTAL_EXEMPT_TBL OUT NOCOPY NUMERIC4_TBL,
7341: X_CL_TOTAL_EFFECTIVE_TBL OUT NOCOPY NUMERIC5_TBL,
7342: X_CL_TOTAL_VAT_TAX_TBL OUT NOCOPY NUMERIC6_TBL,
7375: )
7376: GROUP BY DOCUMENT_SUB_TYPE;
7377:
7378: l_tbl_index_cust BINARY_INTEGER;
7379: L_CL_DOC_SUB_TYPE_TBL ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
7380: L_CL_NUM_OF_DOC_TBL NUMERIC3_TBL;
7381: L_CL_TOTAL_VAT_TAX_TBL NUMERIC6_TBL;
7382: L_CL_TOTAL_OTHER_TAX_TBL NUMERIC11_TBL;
7383: L_CL_TOTAL_EXEMPT_AMT_TBL NUMERIC4_TBL;
7618: | |
7619: | Called from ZX_JL_EXTRACT_PKG.POPULATE |
7620: | |
7621: | Parameters : |
7622: | IN : P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL|
7623: | X_JLCL_AP_DOC_TYPE_MEANING OUT VARCHAR2 |
7624: | X_ORDER_BY_DOC_TYPE OUT VARCHAR2 |
7625: | |
7626: | MODIFICATION HISTORY |
7630: +=====================================================================================*/
7631:
7632: PROCEDURE GET_LOOKUP_INFO
7633: (
7634: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
7635: X_JLCL_AP_DOC_TYPE_MEANING_TBL OUT NOCOPY DOCUMENT_SUB_TYPE_MNG_TBL,
7636: X_ORDER_BY_DOC_TYPE_TBL OUT NOCOPY ATTRIBUTE14_TBL
7637: )
7638:
7790: | |
7791: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
7792: | |
7793: | Parameters : |
7794: | IN : P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL Required | |
7795: | P_TRX_TYPE_ID_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL Required |
7796: | |
7797: | MODIFICATION HISTORY |
7798: | 07-Nov-03 Hidetaka Kojima created |
7791: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
7792: | |
7793: | Parameters : |
7794: | IN : P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL Required | |
7795: | P_TRX_TYPE_ID_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL Required |
7796: | |
7797: | MODIFICATION HISTORY |
7798: | 07-Nov-03 Hidetaka Kojima created |
7799: | |
7801: +=================================================================================*/
7802:
7803: PROCEDURE GET_DGI_CODE
7804: (
7805: P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL,
7806: P_TRX_CATEGORY_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL,
7807: P_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
7808: X_DGI_CODE_TBL OUT NOCOPY ATTRIBUTE11_TBL
7809: )
7802:
7803: PROCEDURE GET_DGI_CODE
7804: (
7805: P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL,
7806: P_TRX_CATEGORY_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL,
7807: P_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
7808: X_DGI_CODE_TBL OUT NOCOPY ATTRIBUTE11_TBL
7809: )
7810: IS
7803: PROCEDURE GET_DGI_CODE
7804: (
7805: P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL,
7806: P_TRX_CATEGORY_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL,
7807: P_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
7808: X_DGI_CODE_TBL OUT NOCOPY ATTRIBUTE11_TBL
7809: )
7810: IS
7811:
7882: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
7883: | |
7884: | Parameters : |
7885: | IN : P_REQUEST_ID IN NUMBER Required |
7886: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Required |
7887: | |
7888: | MODIFICATION HISTORY |
7889: | 18-Aug-10 Binapani Beura created |
7890: | |
7894:
7895: PROCEDURE GET_VALIDATION_DIGIT
7896: (
7897: P_REQUEST_ID IN NUMBER,
7898: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
7899: X_VALIDATION_DIGIT_TBL OUT NOCOPY ATTRIBUTE12_TBL
7900: )
7901: IS
7902:
7969:
7970: PROCEDURE GET_CUSTOMER_CONDITION_CODE
7971: (
7972: P_VAT_PERCEP_TAX IN VARCHAR2,
7973: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
7974: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
7975: P_REQUEST_ID IN NUMBER,
7976: X_CUST_CONDITION_CODE_TBL OUT NOCOPY ATTRIBUTE7_TBL
7977: )
7970: PROCEDURE GET_CUSTOMER_CONDITION_CODE
7971: (
7972: P_VAT_PERCEP_TAX IN VARCHAR2,
7973: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
7974: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
7975: P_REQUEST_ID IN NUMBER,
7976: X_CUST_CONDITION_CODE_TBL OUT NOCOPY ATTRIBUTE7_TBL
7977: )
7978: is
8149:
8150: PROCEDURE GET_DGI_TAX_REGIME_CODE
8151: (
8152: P_VAT_PERCEP_TAX IN VARCHAR2,
8153: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8154: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
8155: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
8156: P_REQUEST_ID IN NUMBER,
8157: X_DGI_TAX_REGIME_CODE_TBL OUT NOCOPY ATTRIBUTE25_TBL
8150: PROCEDURE GET_DGI_TAX_REGIME_CODE
8151: (
8152: P_VAT_PERCEP_TAX IN VARCHAR2,
8153: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8154: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
8155: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
8156: P_REQUEST_ID IN NUMBER,
8157: X_DGI_TAX_REGIME_CODE_TBL OUT NOCOPY ATTRIBUTE25_TBL
8158: )
8151: (
8152: P_VAT_PERCEP_TAX IN VARCHAR2,
8153: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8154: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
8155: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
8156: P_REQUEST_ID IN NUMBER,
8157: X_DGI_TAX_REGIME_CODE_TBL OUT NOCOPY ATTRIBUTE25_TBL
8158: )
8159: IS
8285:
8286: PROCEDURE GET_VAT_REG_STAT_CODE
8287: (
8288: P_VAT_TAX IN VARCHAR2,
8289: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8290: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
8291: P_REQUEST_ID IN NUMBER,
8292: X_VAT_REG_STAT_CODE_TBL OUT NOCOPY ATTRIBUTE8_TBL
8293: )
8286: PROCEDURE GET_VAT_REG_STAT_CODE
8287: (
8288: P_VAT_TAX IN VARCHAR2,
8289: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8290: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
8291: P_REQUEST_ID IN NUMBER,
8292: X_VAT_REG_STAT_CODE_TBL OUT NOCOPY ATTRIBUTE8_TBL
8293: )
8294: IS
8486: PROCEDURE GET_REC_COUNT
8487: (
8488: P_VAT_TAX IN ZX_REP_TRX_DETAIL_T.TAX%TYPE,
8489: P_TAX_REGIME IN ZX_REP_TRX_DETAIL_T.TAX_REGIME_CODE%TYPE,
8490: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8491: P_REQUEST_ID IN NUMBER,
8492: X_REC_COUNT_TBL OUT NOCOPY NUMERIC11_TBL
8493: )
8494: IS
8561: | |
8562: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AP |
8563: | |
8564: | Parameters : |
8565: | IN : P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL |
8566: | |
8567: +==========================================================================*/
8568: PROCEDURE GET_DGI_DOC_TYPE
8569: (
8566: | |
8567: +==========================================================================*/
8568: PROCEDURE GET_DGI_DOC_TYPE
8569: (
8570: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8571: X_DGI_DOC_TYPE_TBL OUT NOCOPY ATTRIBUTE1_TBL,
8572: X_GDF_AP_INV_ATT11_TBL OUT NOCOPY GDF_AP_INV_ATT11_TBL,
8573: X_GDF_AP_INV_ATT12_TBL OUT NOCOPY GDF_AP_INV_ATT12_TBL
8574: )
8692: (
8693: P_VAT_TAX IN ZX_REP_TRX_DETAIL_T.TAX%TYPE,
8694: P_VAT_NON_TAX IN ZX_REP_TRX_DETAIL_T.TAX%TYPE,
8695: P_TAX_REGIME IN ZX_REP_TRX_DETAIL_T.TAX_REGIME_CODE%TYPE,
8696: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8697: P_REQUEST_ID IN NUMBER,
8698: X_RATE_COUNT_TBL OUT NOCOPY NUMERIC13_TBL
8699: )
8700: IS
8775: | |
8776: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
8777: | |
8778: | Parameters : |
8779: | IN : p_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL Required |
8780: | |
8781: | MODIFICATION HISTORY |
8782: | 07-Nov-03 Hidetaka Kojima created |
8783: | |
8786:
8787:
8788: PROCEDURE GET_TOTAL_DOCUMENT_AMOUNT
8789: (
8790: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8791: P_EXCHANGE_RATE_TBL IN ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL,
8792: P_REPORT_NAME IN VARCHAR2,
8793: X_TOTAL_DOC_AMT_TBL OUT NOCOPY NUMERIC12_TBL
8794: )
8787:
8788: PROCEDURE GET_TOTAL_DOCUMENT_AMOUNT
8789: (
8790: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8791: P_EXCHANGE_RATE_TBL IN ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL,
8792: P_REPORT_NAME IN VARCHAR2,
8793: X_TOTAL_DOC_AMT_TBL OUT NOCOPY NUMERIC12_TBL
8794: )
8795: IS
8950:
8951:
8952: PROCEDURE DGI_TRX_CODE
8953: (
8954: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8955: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8956: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
8957: X_DGI_TRX_CODE_TBL OUT NOCOPY ATTRIBUTE4_TBL
8958: ) IS
8951:
8952: PROCEDURE DGI_TRX_CODE
8953: (
8954: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8955: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8956: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
8957: X_DGI_TRX_CODE_TBL OUT NOCOPY ATTRIBUTE4_TBL
8958: ) IS
8959:
8952: PROCEDURE DGI_TRX_CODE
8953: (
8954: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8955: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8956: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
8957: X_DGI_TRX_CODE_TBL OUT NOCOPY ATTRIBUTE4_TBL
8958: ) IS
8959:
8960:
9062:
9063:
9064: PROCEDURE GET_TAX_AUTH_CATEG
9065: (
9066: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9067: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9068: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
9069: X_TAX_AUTH_CATEG_TBL OUT NOCOPY ATTRIBUTE10_TBL
9070: ) IS
9063:
9064: PROCEDURE GET_TAX_AUTH_CATEG
9065: (
9066: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9067: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9068: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
9069: X_TAX_AUTH_CATEG_TBL OUT NOCOPY ATTRIBUTE10_TBL
9070: ) IS
9071:
9064: PROCEDURE GET_TAX_AUTH_CATEG
9065: (
9066: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9067: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9068: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
9069: X_TAX_AUTH_CATEG_TBL OUT NOCOPY ATTRIBUTE10_TBL
9070: ) IS
9071:
9072:
9162:
9163:
9164: PROCEDURE PROV_JURISDICTION_CODE
9165: (
9166: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9167: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9168: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
9169: X_PROV_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE1_TBL
9170: ) IS
9163:
9164: PROCEDURE PROV_JURISDICTION_CODE
9165: (
9166: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9167: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9168: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
9169: X_PROV_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE1_TBL
9170: ) IS
9171:
9164: PROCEDURE PROV_JURISDICTION_CODE
9165: (
9166: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9167: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9168: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
9169: X_PROV_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE1_TBL
9170: ) IS
9171:
9172: l_prov_juris_code_tbl ATTRIBUTE1_TBL;
9274:
9275:
9276: PROCEDURE MUN_JURISDICTION_CODE
9277: (
9278: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9279: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9280: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
9281: X_MUN_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE3_TBL
9282: ) IS
9275:
9276: PROCEDURE MUN_JURISDICTION_CODE
9277: (
9278: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9279: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9280: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
9281: X_MUN_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE3_TBL
9282: ) IS
9283:
9276: PROCEDURE MUN_JURISDICTION_CODE
9277: (
9278: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9279: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9280: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
9281: X_MUN_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE3_TBL
9282: ) IS
9283:
9284:
9380:
9381: /*
9382: PROCEDURE GET_CAI_NUM
9383: (
9384: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9385: P_REPORT_NAME IN VARCHAR2,
9386: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9387: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9388: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9382: PROCEDURE GET_CAI_NUM
9383: (
9384: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9385: P_REPORT_NAME IN VARCHAR2,
9386: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9387: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9388: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9389: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
9390: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
9383: (
9384: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9385: P_REPORT_NAME IN VARCHAR2,
9386: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9387: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9388: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9389: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
9390: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
9391: ) IS
9384: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9385: P_REPORT_NAME IN VARCHAR2,
9386: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9387: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9388: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9389: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
9390: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
9391: ) IS
9392:
9399:
9400: PROCEDURE GET_CAI_NUM
9401: PROCEDURE GET_CAI_NUM
9402: (
9403: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9404: P_REPORT_NAME IN VARCHAR2,
9405: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9406: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9407: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9401: PROCEDURE GET_CAI_NUM
9402: (
9403: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9404: P_REPORT_NAME IN VARCHAR2,
9405: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9406: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9407: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9408: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
9409: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
9402: (
9403: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9404: P_REPORT_NAME IN VARCHAR2,
9405: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9406: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9407: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9408: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
9409: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
9410: ) IS
9403: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9404: P_REPORT_NAME IN VARCHAR2,
9405: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9406: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9407: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9408: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
9409: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
9410: ) IS
9411:
9418:
9419: PROCEDURE GET_CAI_NUM
9420: PROCEDURE GET_CAI_NUM
9421: (
9422: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9423: P_REPORT_NAME IN VARCHAR2,
9424: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9425: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9426: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9420: PROCEDURE GET_CAI_NUM
9421: (
9422: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9423: P_REPORT_NAME IN VARCHAR2,
9424: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9425: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9426: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9427: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
9428: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
9421: (
9422: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9423: P_REPORT_NAME IN VARCHAR2,
9424: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9425: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9426: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9427: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
9428: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
9429: ) IS
9422: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9423: P_REPORT_NAME IN VARCHAR2,
9424: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9425: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9426: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9427: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
9428: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
9429: ) IS
9430:
9436: */
9437:
9438: PROCEDURE GET_CAI_NUM
9439: (
9440: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9441: P_REPORT_NAME IN VARCHAR2,
9442: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9443: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9444: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9438: PROCEDURE GET_CAI_NUM
9439: (
9440: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9441: P_REPORT_NAME IN VARCHAR2,
9442: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9443: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9444: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9445: P_INTERNAL_ORG_ID IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
9446: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
9439: (
9440: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9441: P_REPORT_NAME IN VARCHAR2,
9442: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9443: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9444: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9445: P_INTERNAL_ORG_ID IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
9446: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
9447: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
9440: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9441: P_REPORT_NAME IN VARCHAR2,
9442: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9443: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9444: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9445: P_INTERNAL_ORG_ID IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
9446: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
9447: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
9448: ) IS
9441: P_REPORT_NAME IN VARCHAR2,
9442: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9443: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9444: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9445: P_INTERNAL_ORG_ID IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
9446: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
9447: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
9448: ) IS
9449:
9571: END GET_CAI_NUM;
9572:
9573: PROCEDURE GET_CAI_NUM_AR
9574: (
9575: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9576: P_REPORT_NAME IN VARCHAR2,
9577: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
9578: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
9579: ) IS
9655:
9656:
9657: PROCEDURE GET_FISCAL_PRINTER
9658: (
9659: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9660: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9661: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9662: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9663: X_FISCAL_PRINTER_TBL OUT NOCOPY ATTRIBUTE20_TBL
9656:
9657: PROCEDURE GET_FISCAL_PRINTER
9658: (
9659: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9660: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9661: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9662: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9663: X_FISCAL_PRINTER_TBL OUT NOCOPY ATTRIBUTE20_TBL
9664: ) IS
9657: PROCEDURE GET_FISCAL_PRINTER
9658: (
9659: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9660: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9661: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9662: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9663: X_FISCAL_PRINTER_TBL OUT NOCOPY ATTRIBUTE20_TBL
9664: ) IS
9665:
9658: (
9659: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9660: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9661: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9662: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9663: X_FISCAL_PRINTER_TBL OUT NOCOPY ATTRIBUTE20_TBL
9664: ) IS
9665:
9666: l_fiscal_printer_tbl ATTRIBUTE20_TBL;
9751:
9752:
9753: PROCEDURE GET_TAXPAYERID_TYPE
9754: (
9755: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9756: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9757: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9758: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9759: X_TAXPAYERID_TYPE_TBL OUT NOCOPY ATTRIBUTE21_TBL,
9752:
9753: PROCEDURE GET_TAXPAYERID_TYPE
9754: (
9755: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9756: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9757: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9758: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9759: X_TAXPAYERID_TYPE_TBL OUT NOCOPY ATTRIBUTE21_TBL,
9760: X_REG_STATUS_CODE_TBL OUT NOCOPY ATTRIBUTE22_TBL
9753: PROCEDURE GET_TAXPAYERID_TYPE
9754: (
9755: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9756: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9757: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9758: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9759: X_TAXPAYERID_TYPE_TBL OUT NOCOPY ATTRIBUTE21_TBL,
9760: X_REG_STATUS_CODE_TBL OUT NOCOPY ATTRIBUTE22_TBL
9761: ) IS
9754: (
9755: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9756: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9757: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9758: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9759: X_TAXPAYERID_TYPE_TBL OUT NOCOPY ATTRIBUTE21_TBL,
9760: X_REG_STATUS_CODE_TBL OUT NOCOPY ATTRIBUTE22_TBL
9761: ) IS
9762:
9841: END GET_TAXPAYERID_TYPE;
9842:
9843: PROCEDURE GET_FISCAL_PRINTER_AR
9844: (
9845: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9846: P_BATCH_SOURCE_ID_TBL IN ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL,
9847: X_FISCAL_PRINTER_TBL OUT NOCOPY GDF_RA_BATCH_SOURCES_ATT7_TBL
9848: ) IS
9849:
9842:
9843: PROCEDURE GET_FISCAL_PRINTER_AR
9844: (
9845: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9846: P_BATCH_SOURCE_ID_TBL IN ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL,
9847: X_FISCAL_PRINTER_TBL OUT NOCOPY GDF_RA_BATCH_SOURCES_ATT7_TBL
9848: ) IS
9849:
9850: l_fiscal_printer_tbl GDF_RA_BATCH_SOURCES_ATT7_TBL;
9924: | |
9925: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
9926: | |
9927: | Parameters : |
9928: | IN : p_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL Required|
9929: | |
9930: | MODIFICATION HISTORY |
9931: | 07-Nov-03 Hidetaka Kojima created |
9932: | |
9934: +===========================================================================*/
9935:
9936: PROCEDURE GET_TOTAL_DOC_TAXABLE_AMOUNT
9937: (
9938: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9939: P_REQUEST_ID IN NUMBER,
9940: X_TOTAL_DOC_TAXAB_AMT_TBL OUT NOCOPY NUMERIC8_TBL
9941: )
9942: IS