APPS.ZX_JL_EXTRACT_PKG dependencies on ZX_EXTRACT_PKG

Line 159: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

155: P_VAT_TAX IN VARCHAR2 DEFAULT NULL,
156: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
157: P_REPORT_NAME IN VARCHAR2,
158: P_REQUEST_ID IN NUMBER,
159: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
160: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
161: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
162: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
163: X_VAT_AMT_TBL OUT NOCOPY NUMERIC9_TBL

Line 160: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

156: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
157: P_REPORT_NAME IN VARCHAR2,
158: P_REQUEST_ID IN NUMBER,
159: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
160: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
161: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
162: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
163: X_VAT_AMT_TBL OUT NOCOPY NUMERIC9_TBL
164: );

Line 161: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,

157: P_REPORT_NAME IN VARCHAR2,
158: P_REQUEST_ID IN NUMBER,
159: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
160: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
161: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
162: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
163: X_VAT_AMT_TBL OUT NOCOPY NUMERIC9_TBL
164: );
165:

Line 162: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,

158: P_REQUEST_ID IN NUMBER,
159: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
160: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
161: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
162: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
163: X_VAT_AMT_TBL OUT NOCOPY NUMERIC9_TBL
164: );
165:
166: PROCEDURE GET_TAXABLE_AMOUNT

Line 172: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

168: P_VAT_TAX IN VARCHAR2 DEFAULT NULL,
169: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
170: P_REPORT_NAME IN VARCHAR2,
171: P_REQUEST_ID IN NUMBER,
172: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
173: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
174: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
175: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
176: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,

Line 173: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

169: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
170: P_REPORT_NAME IN VARCHAR2,
171: P_REQUEST_ID IN NUMBER,
172: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
173: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
174: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
175: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
176: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
177: X_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC10_TBL

Line 174: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

170: P_REPORT_NAME IN VARCHAR2,
171: P_REQUEST_ID IN NUMBER,
172: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
173: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
174: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
175: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
176: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
177: X_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC10_TBL
178: );

Line 175: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,

171: P_REQUEST_ID IN NUMBER,
172: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
173: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
174: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
175: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
176: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
177: X_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC10_TBL
178: );
179:

Line 176: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,

172: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
173: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
174: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
175: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
176: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
177: X_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC10_TBL
178: );
179:
180: PROCEDURE GET_NON_TAXABLE_AMOUNT

Line 188: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

184: P_VAT_ADDIT_TAX IN VARCHAR2 DEFAULT NULL,
185: P_VAT_PERCEP_TAX IN VARCHAR2 DEFAULT NULL,
186: P_REPORT_NAME IN VARCHAR2,
187: p_REQUEST_ID IN NUMBER,
188: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
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_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
192: X_NON_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC8_TBL

Line 189: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

185: P_VAT_PERCEP_TAX IN VARCHAR2 DEFAULT NULL,
186: P_REPORT_NAME IN VARCHAR2,
187: p_REQUEST_ID IN NUMBER,
188: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
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_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
192: X_NON_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC8_TBL
193: );

Line 190: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

186: P_REPORT_NAME IN VARCHAR2,
187: p_REQUEST_ID IN NUMBER,
188: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
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_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
192: X_NON_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC8_TBL
193: );
194:

Line 191: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,

187: p_REQUEST_ID IN NUMBER,
188: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
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_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
192: X_NON_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC8_TBL
193: );
194:
195: PROCEDURE GET_VAT_EXEMPT_AMOUNT

Line 203: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

199: P_VAT_PERCEP_TAX IN VARCHAR2 DEFAULT NULL,
200: P_REPORT_NAME IN VARCHAR2,
201: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
202: P_REQUEST_ID IN NUMBER,
203: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
204: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
205: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
206: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
207: X_VAT_EXEMPT_AMT_TBL OUT NOCOPY NUMERIC2_TBL

Line 204: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

200: P_REPORT_NAME IN VARCHAR2,
201: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
202: P_REQUEST_ID IN NUMBER,
203: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
204: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
205: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
206: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
207: X_VAT_EXEMPT_AMT_TBL OUT NOCOPY NUMERIC2_TBL
208: );

Line 205: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,

201: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
202: P_REQUEST_ID IN NUMBER,
203: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
204: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
205: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
206: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
207: X_VAT_EXEMPT_AMT_TBL OUT NOCOPY NUMERIC2_TBL
208: );
209:

Line 206: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,

202: P_REQUEST_ID IN NUMBER,
203: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
204: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
205: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
206: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
207: X_VAT_EXEMPT_AMT_TBL OUT NOCOPY NUMERIC2_TBL
208: );
209:
210: PROCEDURE GET_VAT_ADDITIONAL_AMOUNT

Line 215: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

211: (
212: P_VAT_ADDIT_TAX IN VARCHAR2 DEFAULT NULL,
213: P_REPORT_NAME IN VARCHAR2,
214: p_REQUEST_ID IN NUMBER,
215: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
216: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
217: X_VAT_ADDITIONAL_AMT_TBL OUT NOCOPY NUMERIC7_TBL
218: );
219:

Line 216: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,

212: P_VAT_ADDIT_TAX IN VARCHAR2 DEFAULT NULL,
213: P_REPORT_NAME IN VARCHAR2,
214: p_REQUEST_ID IN NUMBER,
215: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
216: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
217: X_VAT_ADDITIONAL_AMT_TBL OUT NOCOPY NUMERIC7_TBL
218: );
219:
220: PROCEDURE GET_NOT_REGISTERED_TAX_AMOUNT

Line 227: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

223: P_VAT_ADDIT_TAX IN VARCHAR2 DEFAULT NULL,
224: P_VAT_NOT_CATEG_TAX IN VARCHAR2 DEFAULT NULL,
225: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
226: P_REQUEST_ID IN NUMBER,
227: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
228: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
229: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
230: X_NOT_REG_TAX_AMT_TBL OUT NOCOPY NUMERIC1_TBL
231: );

Line 228: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,

224: P_VAT_NOT_CATEG_TAX IN VARCHAR2 DEFAULT NULL,
225: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
226: P_REQUEST_ID IN NUMBER,
227: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
228: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
229: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
230: X_NOT_REG_TAX_AMT_TBL OUT NOCOPY NUMERIC1_TBL
231: );
232:

Line 229: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,

225: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
226: P_REQUEST_ID IN NUMBER,
227: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
228: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
229: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
230: X_NOT_REG_TAX_AMT_TBL OUT NOCOPY NUMERIC1_TBL
231: );
232:
233: PROCEDURE GET_VAT_PERCEPTION_AMOUNT

Line 241: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

237: P_VAT_PERC_TAX IN VARCHAR2 DEFAULT NULL,
238: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
239: P_REPORT_NAME IN VARCHAR2,
240: p_REQUEST_ID IN NUMBER,
241: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
242: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
243: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
244: X_VAT_PERCEPTION_AMT_TBL OUT NOCOPY NUMERIC3_TBL
245: );

Line 242: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

238: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
239: P_REPORT_NAME IN VARCHAR2,
240: p_REQUEST_ID IN NUMBER,
241: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
242: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
243: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
244: X_VAT_PERCEPTION_AMT_TBL OUT NOCOPY NUMERIC3_TBL
245: );
246:

Line 243: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,

239: P_REPORT_NAME IN VARCHAR2,
240: p_REQUEST_ID IN NUMBER,
241: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
242: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
243: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
244: X_VAT_PERCEPTION_AMT_TBL OUT NOCOPY NUMERIC3_TBL
245: );
246:
247: PROCEDURE GET_OTHER_FED_PERC_AMOUNT

Line 255: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

251: P_VAT_PERC_TAX IN VARCHAR2 DEFAULT NULL,
252: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
253: P_REPORT_NAME IN VARCHAR2,
254: p_REQUEST_ID IN NUMBER,
255: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
256: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
257: X_OTHER_FED_PERC_AMT_TBL OUT NOCOPY NUMERIC7_TBL
258: );
259:

Line 256: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,

252: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
253: P_REPORT_NAME IN VARCHAR2,
254: p_REQUEST_ID IN NUMBER,
255: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
256: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
257: X_OTHER_FED_PERC_AMT_TBL OUT NOCOPY NUMERIC7_TBL
258: );
259:
260:

Line 268: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

264: P_PROV_TAX_TYPE_TO IN VARCHAR2 DEFAULT NULL,
265: P_PROV_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
266: P_REPORT_NAME IN VARCHAR2,
267: p_REQUEST_ID IN NUMBER,
268: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
269: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
270: X_PROVINCIAL_PERC_AMT_TBL OUT NOCOPY NUMERIC4_TBL
271: );
272:

Line 269: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,

265: P_PROV_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
266: P_REPORT_NAME IN VARCHAR2,
267: p_REQUEST_ID IN NUMBER,
268: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
269: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
270: X_PROVINCIAL_PERC_AMT_TBL OUT NOCOPY NUMERIC4_TBL
271: );
272:
273: PROCEDURE GET_MUNICIPAL_PERC_AMOUNT

Line 280: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

276: P_MUN_TAX_TYPE_TO IN VARCHAR2 DEFAULT NULL,
277: P_MUN_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
278: P_REPORT_NAME IN VARCHAR2,
279: p_REQUEST_ID IN NUMBER,
280: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
281: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
282: X_MUNICIPAL_PERC_AMT_TBL OUT NOCOPY NUMERIC5_TBL
283: );
284:

Line 281: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,

277: P_MUN_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
278: P_REPORT_NAME IN VARCHAR2,
279: p_REQUEST_ID IN NUMBER,
280: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
281: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
282: X_MUNICIPAL_PERC_AMT_TBL OUT NOCOPY NUMERIC5_TBL
283: );
284:
285: PROCEDURE GET_EXCISE_TAX_AMOUNT

Line 292: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

288: P_EXC_TAX_TYPE_TO IN VARCHAR2 DEFAULT NULL,
289: P_EXC_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
290: P_REPORT_NAME IN VARCHAR2,
291: p_REQUEST_ID IN NUMBER,
292: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
293: X_EXCISE_AMT_TBL OUT NOCOPY NUMERIC6_TBL
294: );
295:
296: PROCEDURE GET_OTHER_TAX_AMOUNT

Line 300: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

296: PROCEDURE GET_OTHER_TAX_AMOUNT
297: (
298: P_REPORT_NAME IN VARCHAR2,
299: p_REQUEST_ID IN NUMBER,
300: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
301: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
302: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
303: X_OTHER_TAX_AMT_TBL OUT NOCOPY NUMERIC7_TBL
304: );

Line 301: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,

297: (
298: P_REPORT_NAME IN VARCHAR2,
299: p_REQUEST_ID IN NUMBER,
300: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
301: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
302: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
303: X_OTHER_TAX_AMT_TBL OUT NOCOPY NUMERIC7_TBL
304: );
305:

Line 302: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,

298: P_REPORT_NAME IN VARCHAR2,
299: p_REQUEST_ID IN NUMBER,
300: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
301: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
302: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
303: X_OTHER_TAX_AMT_TBL OUT NOCOPY NUMERIC7_TBL
304: );
305:
306: PROCEDURE GET_COUNTED_SUM_DOC

Line 310: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,

306: PROCEDURE GET_COUNTED_SUM_DOC
307: (
308: P_REPORT_NAME IN VARCHAR2,
309: P_REQUEST_ID IN NUMBER,
310: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
311: X_CL_NUM_OF_DOC_TBL OUT NOCOPY NUMERIC3_TBL,
312: X_CL_TOTAL_EXEMPT_TBL OUT NOCOPY NUMERIC4_TBL,
313: X_CL_TOTAL_EFFECTIVE_TBL OUT NOCOPY NUMERIC5_TBL,
314: X_CL_TOTAL_VAT_TAX_TBL OUT NOCOPY NUMERIC6_TBL,

Line 321: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

317:
318: PROCEDURE GET_CUSTOMER_CONDITION_CODE
319: (
320: P_VAT_PERCEP_TAX IN VARCHAR2,
321: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
322: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
323: P_REQUEST_ID IN NUMBER,
324: X_CUST_CONDITION_CODE_TBL OUT NOCOPY ATTRIBUTE7_TBL
325: );

Line 322: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,

318: PROCEDURE GET_CUSTOMER_CONDITION_CODE
319: (
320: P_VAT_PERCEP_TAX IN VARCHAR2,
321: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
322: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
323: P_REQUEST_ID IN NUMBER,
324: X_CUST_CONDITION_CODE_TBL OUT NOCOPY ATTRIBUTE7_TBL
325: );
326:

Line 330: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

326:
327: PROCEDURE GET_VAT_REG_STAT_CODE
328: (
329: P_VAT_TAX IN VARCHAR2,
330: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
331: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
332: P_REQUEST_ID IN NUMBER,
333: X_VAT_REG_STAT_CODE_TBL OUT NOCOPY ATTRIBUTE8_TBL
334: );

Line 331: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,

327: PROCEDURE GET_VAT_REG_STAT_CODE
328: (
329: P_VAT_TAX IN VARCHAR2,
330: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
331: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
332: P_REQUEST_ID IN NUMBER,
333: X_VAT_REG_STAT_CODE_TBL OUT NOCOPY ATTRIBUTE8_TBL
334: );
335:

Line 345: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

341: return ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE;
342:
343: PROCEDURE GET_FISCAL_PRINTER
344: (
345: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
346: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
347: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
348: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
349: X_FISCAL_PRINTER_TBL OUT NOCOPY ATTRIBUTE20_TBL

Line 346: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

342:
343: PROCEDURE GET_FISCAL_PRINTER
344: (
345: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
346: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
347: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
348: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
349: X_FISCAL_PRINTER_TBL OUT NOCOPY ATTRIBUTE20_TBL
350: );

Line 347: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,

343: PROCEDURE GET_FISCAL_PRINTER
344: (
345: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
346: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
347: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
348: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
349: X_FISCAL_PRINTER_TBL OUT NOCOPY ATTRIBUTE20_TBL
350: );
351:

Line 348: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,

344: (
345: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
346: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
347: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
348: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
349: X_FISCAL_PRINTER_TBL OUT NOCOPY ATTRIBUTE20_TBL
350: );
351:
352: PROCEDURE GET_FISCAL_PRINTER_AR

Line 354: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

350: );
351:
352: PROCEDURE GET_FISCAL_PRINTER_AR
353: (
354: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
355: P_BATCH_SOURCE_ID_TBL IN ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL,
356: X_FISCAL_PRINTER_TBL OUT NOCOPY GDF_RA_BATCH_SOURCES_ATT7_TBL
357: );
358:

Line 355: P_BATCH_SOURCE_ID_TBL IN ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL,

351:
352: PROCEDURE GET_FISCAL_PRINTER_AR
353: (
354: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
355: P_BATCH_SOURCE_ID_TBL IN ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL,
356: X_FISCAL_PRINTER_TBL OUT NOCOPY GDF_RA_BATCH_SOURCES_ATT7_TBL
357: );
358:
359: PROCEDURE GET_CAI_NUM

Line 361: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

357: );
358:
359: PROCEDURE GET_CAI_NUM
360: (
361: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
362: P_REPORT_NAME IN VARCHAR2,
363: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
364: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
365: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,

Line 363: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

359: PROCEDURE GET_CAI_NUM
360: (
361: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
362: P_REPORT_NAME IN VARCHAR2,
363: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
364: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
365: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
366: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
367: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL

Line 364: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,

360: (
361: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
362: P_REPORT_NAME IN VARCHAR2,
363: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
364: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
365: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
366: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
367: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
368: );

Line 365: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,

361: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
362: P_REPORT_NAME IN VARCHAR2,
363: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
364: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
365: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
366: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
367: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
368: );
369:

Line 372: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

368: );
369:
370: PROCEDURE GET_CAI_NUM_AR
371: (
372: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
373: P_REPORT_NAME IN VARCHAR2,
374: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
375: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
376: );

Line 380: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

376: );
377:
378: PROCEDURE GET_TAX_AUTH_CATEG
379: (
380: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
381: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
382: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
383: X_TAX_AUTH_CATEG_TBL OUT NOCOPY ATTRIBUTE10_TBL
384: ) ;

Line 381: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

377:
378: PROCEDURE GET_TAX_AUTH_CATEG
379: (
380: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
381: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
382: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
383: X_TAX_AUTH_CATEG_TBL OUT NOCOPY ATTRIBUTE10_TBL
384: ) ;
385: PROCEDURE PROV_JURISDICTION_CODE

Line 382: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,

378: PROCEDURE GET_TAX_AUTH_CATEG
379: (
380: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
381: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
382: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
383: X_TAX_AUTH_CATEG_TBL OUT NOCOPY ATTRIBUTE10_TBL
384: ) ;
385: PROCEDURE PROV_JURISDICTION_CODE
386: (

Line 387: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

383: X_TAX_AUTH_CATEG_TBL OUT NOCOPY ATTRIBUTE10_TBL
384: ) ;
385: PROCEDURE PROV_JURISDICTION_CODE
386: (
387: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
388: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
389: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
390: X_PROV_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE1_TBL
391: ) ;

Line 388: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

384: ) ;
385: PROCEDURE PROV_JURISDICTION_CODE
386: (
387: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
388: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
389: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
390: X_PROV_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE1_TBL
391: ) ;
392: PROCEDURE MUN_JURISDICTION_CODE

Line 389: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,

385: PROCEDURE PROV_JURISDICTION_CODE
386: (
387: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
388: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
389: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
390: X_PROV_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE1_TBL
391: ) ;
392: PROCEDURE MUN_JURISDICTION_CODE
393: (

Line 394: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

390: X_PROV_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE1_TBL
391: ) ;
392: PROCEDURE MUN_JURISDICTION_CODE
393: (
394: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
395: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
396: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
397: X_MUN_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE3_TBL
398: ) ;

Line 395: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

391: ) ;
392: PROCEDURE MUN_JURISDICTION_CODE
393: (
394: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
395: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
396: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
397: X_MUN_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE3_TBL
398: ) ;
399:

Line 396: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,

392: PROCEDURE MUN_JURISDICTION_CODE
393: (
394: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
395: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
396: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
397: X_MUN_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE3_TBL
398: ) ;
399:
400: PROCEDURE GET_TAXPAYERID_TYPE

Line 402: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

398: ) ;
399:
400: PROCEDURE GET_TAXPAYERID_TYPE
401: (
402: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
403: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
404: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
405: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
406: X_TAXPAYERID_TYPE_TBL OUT NOCOPY ATTRIBUTE21_TBL,

Line 403: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

399:
400: PROCEDURE GET_TAXPAYERID_TYPE
401: (
402: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
403: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
404: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
405: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
406: X_TAXPAYERID_TYPE_TBL OUT NOCOPY ATTRIBUTE21_TBL,
407: X_REG_STATUS_CODE_TBL OUT NOCOPY ATTRIBUTE22_TBL

Line 404: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,

400: PROCEDURE GET_TAXPAYERID_TYPE
401: (
402: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
403: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
404: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
405: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
406: X_TAXPAYERID_TYPE_TBL OUT NOCOPY ATTRIBUTE21_TBL,
407: X_REG_STATUS_CODE_TBL OUT NOCOPY ATTRIBUTE22_TBL
408: );

Line 405: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,

401: (
402: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
403: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
404: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
405: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
406: X_TAXPAYERID_TYPE_TBL OUT NOCOPY ATTRIBUTE21_TBL,
407: X_REG_STATUS_CODE_TBL OUT NOCOPY ATTRIBUTE22_TBL
408: );
409:

Line 413: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

409:
410: PROCEDURE GET_DGI_TAX_REGIME_CODE
411: (
412: P_VAT_PERCEP_TAX IN VARCHAR2,
413: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
414: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
415: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
416: P_REQUEST_ID IN NUMBER,
417: X_DGI_TAX_REGIME_CODE_TBL OUT NOCOPY ATTRIBUTE25_TBL

Line 414: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

410: PROCEDURE GET_DGI_TAX_REGIME_CODE
411: (
412: P_VAT_PERCEP_TAX IN VARCHAR2,
413: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
414: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
415: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
416: P_REQUEST_ID IN NUMBER,
417: X_DGI_TAX_REGIME_CODE_TBL OUT NOCOPY ATTRIBUTE25_TBL
418: );

Line 415: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,

411: (
412: P_VAT_PERCEP_TAX IN VARCHAR2,
413: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
414: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
415: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
416: P_REQUEST_ID IN NUMBER,
417: X_DGI_TAX_REGIME_CODE_TBL OUT NOCOPY ATTRIBUTE25_TBL
418: );
419:

Line 422: P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL,

418: );
419:
420: PROCEDURE GET_DGI_CODE
421: (
422: P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL,
423: P_TRX_CATEGORY_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL,
424: P_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
425: X_DGI_CODE_TBL OUT NOCOPY ATTRIBUTE11_TBL
426: );

Line 423: P_TRX_CATEGORY_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL,

419:
420: PROCEDURE GET_DGI_CODE
421: (
422: P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL,
423: P_TRX_CATEGORY_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL,
424: P_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
425: X_DGI_CODE_TBL OUT NOCOPY ATTRIBUTE11_TBL
426: );
427: PROCEDURE GET_DGI_DOC_TYPE

Line 424: P_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,

420: PROCEDURE GET_DGI_CODE
421: (
422: P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL,
423: P_TRX_CATEGORY_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL,
424: P_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
425: X_DGI_CODE_TBL OUT NOCOPY ATTRIBUTE11_TBL
426: );
427: PROCEDURE GET_DGI_DOC_TYPE
428: (

Line 429: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

425: X_DGI_CODE_TBL OUT NOCOPY ATTRIBUTE11_TBL
426: );
427: PROCEDURE GET_DGI_DOC_TYPE
428: (
429: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
430: X_DGI_DOC_TYPE_TBL OUT NOCOPY ATTRIBUTE1_TBL,
431: X_GDF_AP_INV_ATT11_TBL OUT NOCOPY GDF_AP_INV_ATT11_TBL,
432: X_GDF_AP_INV_ATT12_TBL OUT NOCOPY GDF_AP_INV_ATT12_TBL
433: );

Line 437: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

433: );
434:
435: PROCEDURE DGI_TRX_CODE
436: (
437: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
438: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
439: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
440: X_DGI_TRX_CODE_TBL OUT NOCOPY ATTRIBUTE4_TBL
441: );

Line 438: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

434:
435: PROCEDURE DGI_TRX_CODE
436: (
437: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
438: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
439: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
440: X_DGI_TRX_CODE_TBL OUT NOCOPY ATTRIBUTE4_TBL
441: );
442:

Line 439: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,

435: PROCEDURE DGI_TRX_CODE
436: (
437: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
438: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
439: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
440: X_DGI_TRX_CODE_TBL OUT NOCOPY ATTRIBUTE4_TBL
441: );
442:
443: PROCEDURE UPDATE_DGI_CURR_CODE

Line 450: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,

446: );
447:
448: PROCEDURE GET_LOOKUP_INFO
449: (
450: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
451: X_JLCL_AP_DOC_TYPE_MEANING_TBL OUT NOCOPY DOCUMENT_SUB_TYPE_MNG_TBL,
452: X_ORDER_BY_DOC_TYPE_TBL OUT NOCOPY ATTRIBUTE14_TBL
453: );
454:

Line 459: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

455: PROCEDURE GET_REC_COUNT
456: (
457: P_VAT_TAX IN ZX_REP_TRX_DETAIL_T.TAX%TYPE,
458: P_TAX_REGIME IN ZX_REP_TRX_DETAIL_T.TAX_REGIME_CODE%TYPE,
459: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
460: P_REQUEST_ID IN NUMBER,
461: X_REC_COUNT_TBL OUT NOCOPY NUMERIC11_TBL
462: );
463:

Line 469: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

465: (
466: P_VAT_TAX IN ZX_REP_TRX_DETAIL_T.TAX%TYPE,
467: P_VAT_NON_TAX IN ZX_REP_TRX_DETAIL_T.TAX%TYPE,
468: P_TAX_REGIME IN ZX_REP_TRX_DETAIL_T.TAX_REGIME_CODE%TYPE,
469: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
470: P_REQUEST_ID IN NUMBER,
471: X_RATE_COUNT_TBL OUT NOCOPY NUMERIC13_TBL
472: );
473:

Line 476: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

472: );
473:
474: PROCEDURE GET_TOTAL_DOCUMENT_AMOUNT
475: (
476: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
477: P_EXCHANGE_RATE_TBL IN ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL,
478: P_REPORT_NAME IN VARCHAR2,
479: X_TOTAL_DOC_AMT_TBL OUT NOCOPY NUMERIC12_TBL
480: );

Line 477: P_EXCHANGE_RATE_TBL IN ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL,

473:
474: PROCEDURE GET_TOTAL_DOCUMENT_AMOUNT
475: (
476: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
477: P_EXCHANGE_RATE_TBL IN ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL,
478: P_REPORT_NAME IN VARCHAR2,
479: X_TOTAL_DOC_AMT_TBL OUT NOCOPY NUMERIC12_TBL
480: );
481:

Line 484: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

480: );
481:
482: PROCEDURE GET_TOTAL_DOC_TAXABLE_AMOUNT
483: (
484: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
485: P_REQUEST_ID IN NUMBER,
486: X_TOTAL_DOC_TAXAB_AMT_TBL OUT NOCOPY NUMERIC8_TBL
487: );
488:

Line 510: (P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

506:
507: END FILTER_JL_AP_TAX_LINES;
508:
509: PROCEDURE FILTER_JL_AR_TAX_LINES
510: (P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
511: ) IS
512: BEGIN
513:
514: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 599: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

595: | |
596: +===========================================================================*/
597:
598: PROCEDURE POPULATE_JL_AP(
599: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
600: )
601: IS
602:
603: P_REQUEST_ID NUMBER;

Line 627: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

623: P_VAT_ADDIT_TAX_TYPE VARCHAR2(30);
624:
625: l_err_msg VARCHAR2(120);
626:
627: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
628: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
629: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
630: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
631: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;

Line 628: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;

624:
625: l_err_msg VARCHAR2(120);
626:
627: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
628: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
629: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
630: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
631: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
632: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

Line 629: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

625: l_err_msg VARCHAR2(120);
626:
627: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
628: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
629: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
630: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
631: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
632: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
633: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;

Line 630: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;

626:
627: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
628: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
629: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
630: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
631: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
632: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
633: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
634: l_trx_currency_code_tbl ZX_EXTRACT_PKG.TRX_CURRENCY_CODE_TBL;

Line 631: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;

627: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
628: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
629: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
630: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
631: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
632: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
633: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
634: l_trx_currency_code_tbl ZX_EXTRACT_PKG.TRX_CURRENCY_CODE_TBL;
635: l_vat_exempt_amt_tbl NUMERIC2_TBL;

Line 632: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

628: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
629: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
630: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
631: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
632: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
633: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
634: l_trx_currency_code_tbl ZX_EXTRACT_PKG.TRX_CURRENCY_CODE_TBL;
635: l_vat_exempt_amt_tbl NUMERIC2_TBL;
636: l_vat_perc_amt_tbl NUMERIC3_TBL;

Line 633: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;

629: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
630: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
631: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
632: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
633: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
634: l_trx_currency_code_tbl ZX_EXTRACT_PKG.TRX_CURRENCY_CODE_TBL;
635: l_vat_exempt_amt_tbl NUMERIC2_TBL;
636: l_vat_perc_amt_tbl NUMERIC3_TBL;
637: l_other_fed_perc_amt_tbl NUMERIC7_TBL;

Line 634: l_trx_currency_code_tbl ZX_EXTRACT_PKG.TRX_CURRENCY_CODE_TBL;

630: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
631: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
632: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
633: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
634: l_trx_currency_code_tbl ZX_EXTRACT_PKG.TRX_CURRENCY_CODE_TBL;
635: l_vat_exempt_amt_tbl NUMERIC2_TBL;
636: l_vat_perc_amt_tbl NUMERIC3_TBL;
637: l_other_fed_perc_amt_tbl NUMERIC7_TBL;
638: l_prov_perc_amt_tbl NUMERIC4_TBL;

Line 667: l_tax_regime_code_tbl ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL;

663: l_taxpayerid_type_tbl ATTRIBUTE21_TBL;
664: l_reg_status_code_tbl ATTRIBUTE22_TBL;
665: l_jlcl_ap_doc_type_mng_tbl DOCUMENT_SUB_TYPE_MNG_TBL;
666:
667: l_tax_regime_code_tbl ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL;
668: l_bill_from_site_prof_id_tbl ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL;
669: --l_shipping_tp_address_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
670: --l_billing_tp_address_id_tbl ZX_EXTRACT_PKG.BILLING_TP_ADDRESS_ID_TBL;
671: l_bill_from_site_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;

Line 668: l_bill_from_site_prof_id_tbl ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL;

664: l_reg_status_code_tbl ATTRIBUTE22_TBL;
665: l_jlcl_ap_doc_type_mng_tbl DOCUMENT_SUB_TYPE_MNG_TBL;
666:
667: l_tax_regime_code_tbl ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL;
668: l_bill_from_site_prof_id_tbl ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL;
669: --l_shipping_tp_address_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
670: --l_billing_tp_address_id_tbl ZX_EXTRACT_PKG.BILLING_TP_ADDRESS_ID_TBL;
671: l_bill_from_site_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
672: l_bill_from_tp_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;

Line 669: --l_shipping_tp_address_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;

665: l_jlcl_ap_doc_type_mng_tbl DOCUMENT_SUB_TYPE_MNG_TBL;
666:
667: l_tax_regime_code_tbl ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL;
668: l_bill_from_site_prof_id_tbl ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL;
669: --l_shipping_tp_address_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
670: --l_billing_tp_address_id_tbl ZX_EXTRACT_PKG.BILLING_TP_ADDRESS_ID_TBL;
671: l_bill_from_site_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
672: l_bill_from_tp_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
673:

Line 670: --l_billing_tp_address_id_tbl ZX_EXTRACT_PKG.BILLING_TP_ADDRESS_ID_TBL;

666:
667: l_tax_regime_code_tbl ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL;
668: l_bill_from_site_prof_id_tbl ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL;
669: --l_shipping_tp_address_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
670: --l_billing_tp_address_id_tbl ZX_EXTRACT_PKG.BILLING_TP_ADDRESS_ID_TBL;
671: l_bill_from_site_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
672: l_bill_from_tp_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
673:
674: BEGIN

Line 671: l_bill_from_site_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;

667: l_tax_regime_code_tbl ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL;
668: l_bill_from_site_prof_id_tbl ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL;
669: --l_shipping_tp_address_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
670: --l_billing_tp_address_id_tbl ZX_EXTRACT_PKG.BILLING_TP_ADDRESS_ID_TBL;
671: l_bill_from_site_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
672: l_bill_from_tp_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
673:
674: BEGIN
675:

Line 672: l_bill_from_tp_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;

668: l_bill_from_site_prof_id_tbl ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL;
669: --l_shipping_tp_address_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
670: --l_billing_tp_address_id_tbl ZX_EXTRACT_PKG.BILLING_TP_ADDRESS_ID_TBL;
671: l_bill_from_site_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
672: l_bill_from_tp_id_tbl ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL;
673:
674: BEGIN
675:
676: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1805: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

1801: +======================================================================================*/
1802:
1803:
1804: PROCEDURE POPULATE_JL_AR(
1805: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
1806: )
1807: IS
1808:
1809: P_TAX_REGIME VARCHAR2(30);

Line 1823: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

1819: P_TRX_LETTER_TO VARCHAR2(30);
1820: P_REPORT_NAME VARCHAR2(30);
1821: P_REQUEST_ID NUMBER;
1822:
1823: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1824: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1825: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1826: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1827: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;

Line 1824: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;

1820: P_REPORT_NAME VARCHAR2(30);
1821: P_REQUEST_ID NUMBER;
1822:
1823: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1824: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1825: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1826: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1827: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1828: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;

Line 1825: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

1821: P_REQUEST_ID NUMBER;
1822:
1823: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1824: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1825: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1826: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1827: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1828: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1829: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;

Line 1826: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;

1822:
1823: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1824: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1825: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1826: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1827: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1828: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1829: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1830: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;

Line 1827: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;

1823: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1824: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1825: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1826: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1827: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1828: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1829: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1830: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
1831: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;

Line 1828: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;

1824: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1825: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1826: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1827: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1828: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1829: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1830: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
1831: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1832: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

Line 1829: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;

1825: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1826: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1827: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1828: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1829: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1830: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
1831: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1832: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1833: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;

Line 1830: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;

1826: l_batch_source_id_tbl ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL;
1827: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1828: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1829: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1830: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
1831: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1832: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1833: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1834:

Line 1831: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;

1827: l_internal_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1828: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1829: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1830: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
1831: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1832: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1833: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1834:
1835: l_not_reg_tax_amt_tbl NUMERIC1_TBL;

Line 1832: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

1828: l_trx_number_tbl ZX_EXTRACT_PKG.TRX_NUMBER_TBL;
1829: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1830: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
1831: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1832: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1833: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1834:
1835: l_not_reg_tax_amt_tbl NUMERIC1_TBL;
1836: l_vat_exempt_amt_tbl NUMERIC2_TBL;

Line 1833: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;

1829: l_trx_type_id_tbl ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL;
1830: l_tax_rate_tbl ZX_EXTRACT_PKG.TAX_RATE_TBL;
1831: l_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1832: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1833: l_exchange_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1834:
1835: l_not_reg_tax_amt_tbl NUMERIC1_TBL;
1836: l_vat_exempt_amt_tbl NUMERIC2_TBL;
1837: l_vat_perc_amt_tbl NUMERIC3_TBL;

Line 1862: l_tax_regime_code_tbl ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL;

1858: l_cai_number_tbl ATTRIBUTE19_TBL;
1859: l_cai_due_date_tbl ATTRIBUTE23_TBL;
1860: l_dgi_trx_code_tbl ATTRIBUTE4_TBL;
1861: l_count NUMBER;
1862: l_tax_regime_code_tbl ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL;
1863:
1864: l_tax_catg_desc zx_rep_trx_jx_ext_t.attribute1%type; --bug 5251425
1865: l_extended_amt_tbl NUMERIC10_TBL; --Bug 5396444
1866: BEGIN

Line 3559: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req |

3555: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
3556: | P_TAX_REGIME IN VARCHAR2 Opt |
3557: | P_REPORT_NAME IN VARCHAR2 Req |
3558: | P_REQUEST_ID IN NUMBER Req |
3559: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req |
3560: | P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL |
3561: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
3562: | SUB_TYPE_TBL Opt |
3563: | |

Line 3560: | P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL |

3556: | P_TAX_REGIME IN VARCHAR2 Opt |
3557: | P_REPORT_NAME IN VARCHAR2 Req |
3558: | P_REQUEST_ID IN NUMBER Req |
3559: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req |
3560: | P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL |
3561: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
3562: | SUB_TYPE_TBL Opt |
3563: | |
3564: | OUT : X_VAT_AMT_TBL OUT NUMERIC9_TBL |

Line 3561: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |

3557: | P_REPORT_NAME IN VARCHAR2 Req |
3558: | P_REQUEST_ID IN NUMBER Req |
3559: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req |
3560: | P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL |
3561: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
3562: | SUB_TYPE_TBL Opt |
3563: | |
3564: | OUT : X_VAT_AMT_TBL OUT NUMERIC9_TBL |
3565: | |

Line 3579: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

3575: P_VAT_TAX IN VARCHAR2 DEFAULT NULL,
3576: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
3577: P_REPORT_NAME IN VARCHAR2,
3578: P_REQUEST_ID IN NUMBER,
3579: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
3580: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
3581: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
3582: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
3583: X_VAT_AMT_TBL OUT NOCOPY NUMERIC9_TBL

Line 3580: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

3576: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
3577: P_REPORT_NAME IN VARCHAR2,
3578: P_REQUEST_ID IN NUMBER,
3579: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
3580: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
3581: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
3582: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
3583: X_VAT_AMT_TBL OUT NOCOPY NUMERIC9_TBL
3584:

Line 3581: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,

3577: P_REPORT_NAME IN VARCHAR2,
3578: P_REQUEST_ID IN NUMBER,
3579: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
3580: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
3581: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
3582: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
3583: X_VAT_AMT_TBL OUT NOCOPY NUMERIC9_TBL
3584:
3585: ) IS

Line 3582: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,

3578: P_REQUEST_ID IN NUMBER,
3579: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
3580: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
3581: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
3582: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
3583: X_VAT_AMT_TBL OUT NOCOPY NUMERIC9_TBL
3584:
3585: ) IS
3586:

Line 4060: | P_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl |

4056: | Parameters : |
4057: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
4058: | P_REPORT_NAME IN VARCHAR2 Req |
4059: | P_REQUEST_ID IN NUMBER Req |
4060: | P_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl |
4061: | P_trx_line_id_tbl IN ZX_EXTRACT_PKG.P_trx_line_id_tbl |
4062: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
4063: | P_TRX_RATE_TBL IN ZX_EXTRACT_PKG.RATE_TBL Opt|
4064: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |

Line 4061: | P_trx_line_id_tbl IN ZX_EXTRACT_PKG.P_trx_line_id_tbl |

4057: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
4058: | P_REPORT_NAME IN VARCHAR2 Req |
4059: | P_REQUEST_ID IN NUMBER Req |
4060: | P_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl |
4061: | P_trx_line_id_tbl IN ZX_EXTRACT_PKG.P_trx_line_id_tbl |
4062: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
4063: | P_TRX_RATE_TBL IN ZX_EXTRACT_PKG.RATE_TBL Opt|
4064: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
4065: | SUB_TYPE_TBL Opt|

Line 4062: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|

4058: | P_REPORT_NAME IN VARCHAR2 Req |
4059: | P_REQUEST_ID IN NUMBER Req |
4060: | P_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl |
4061: | P_trx_line_id_tbl IN ZX_EXTRACT_PKG.P_trx_line_id_tbl |
4062: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
4063: | P_TRX_RATE_TBL IN ZX_EXTRACT_PKG.RATE_TBL Opt|
4064: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
4065: | SUB_TYPE_TBL Opt|
4066: | |

Line 4063: | P_TRX_RATE_TBL IN ZX_EXTRACT_PKG.RATE_TBL Opt|

4059: | P_REQUEST_ID IN NUMBER Req |
4060: | P_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl |
4061: | P_trx_line_id_tbl IN ZX_EXTRACT_PKG.P_trx_line_id_tbl |
4062: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
4063: | P_TRX_RATE_TBL IN ZX_EXTRACT_PKG.RATE_TBL Opt|
4064: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
4065: | SUB_TYPE_TBL Opt|
4066: | |
4067: | OUT |

Line 4064: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |

4060: | P_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl |
4061: | P_trx_line_id_tbl IN ZX_EXTRACT_PKG.P_trx_line_id_tbl |
4062: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
4063: | P_TRX_RATE_TBL IN ZX_EXTRACT_PKG.RATE_TBL Opt|
4064: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
4065: | SUB_TYPE_TBL Opt|
4066: | |
4067: | OUT |
4068: | X_TAXABLE_AMT_TBL OUT NUMERIC10_TBL |

Line 4082: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

4078: P_VAT_TAX IN VARCHAR2 DEFAULT NULL,
4079: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
4080: P_REPORT_NAME IN VARCHAR2,
4081: P_REQUEST_ID IN NUMBER,
4082: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4083: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4084: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4085: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4086: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,

Line 4083: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

4079: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
4080: P_REPORT_NAME IN VARCHAR2,
4081: P_REQUEST_ID IN NUMBER,
4082: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4083: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4084: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4085: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4086: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
4087: X_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC10_TBL

Line 4084: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

4080: P_REPORT_NAME IN VARCHAR2,
4081: P_REQUEST_ID IN NUMBER,
4082: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4083: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4084: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4085: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4086: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
4087: X_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC10_TBL
4088:

Line 4085: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,

4081: P_REQUEST_ID IN NUMBER,
4082: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4083: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4084: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4085: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4086: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
4087: X_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC10_TBL
4088:
4089: ) IS

Line 4086: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,

4082: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4083: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4084: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4085: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4086: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
4087: X_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC10_TBL
4088:
4089: ) IS
4090:

Line 4665: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|

4661: | Parameters : |
4662: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
4663: | P_REPORT_NAME IN VARCHAR2 Req |
4664: | P_REQUEST_ID IN NUMBER Req |
4665: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
4666: | |
4667: | OUT |
4668: | X_NON_TAXABLE_AMT_TBL OUT NUMERIC8_TBL |
4669: | |

Line 4684: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

4680: P_VAT_ADDIT_TAX IN VARCHAR2 DEFAULT NULL,
4681: P_VAT_PERCEP_TAX IN VARCHAR2 DEFAULT NULL,
4682: P_REPORT_NAME IN VARCHAR2,
4683: p_REQUEST_ID IN NUMBER,
4684: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4685: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4686: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4687: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4688: X_NON_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC8_TBL

Line 4685: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

4681: P_VAT_PERCEP_TAX IN VARCHAR2 DEFAULT NULL,
4682: P_REPORT_NAME IN VARCHAR2,
4683: p_REQUEST_ID IN NUMBER,
4684: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4685: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4686: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4687: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4688: X_NON_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC8_TBL
4689: ) IS

Line 4686: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

4682: P_REPORT_NAME IN VARCHAR2,
4683: p_REQUEST_ID IN NUMBER,
4684: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4685: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4686: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4687: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4688: X_NON_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC8_TBL
4689: ) IS
4690:

Line 4687: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,

4683: p_REQUEST_ID IN NUMBER,
4684: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4685: P_DETAIL_TAX_LINE_ID IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
4686: P_TRX_LINE_ID IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
4687: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
4688: X_NON_TAXABLE_AMT_TBL OUT NOCOPY NUMERIC8_TBL
4689: ) IS
4690:
4691: l_err_msg VARCHAR2(120);

Line 4886: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|

4882: | Parameters : |
4883: | IN : P_VAT_ADDIT_TAX IN VARCHAR2 Opt |
4884: | P_REPORT_NAME IN VARCHAR2 Req |
4885: | P_REQUEST_ID IN NUMBER Req |
4886: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
4887: | P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
4888: | SUB_TYPE_TBL Opt|
4889: | |
4890: | OUT |

Line 4887: | P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |

4883: | IN : P_VAT_ADDIT_TAX IN VARCHAR2 Opt |
4884: | P_REPORT_NAME IN VARCHAR2 Req |
4885: | P_REQUEST_ID IN NUMBER Req |
4886: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
4887: | P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
4888: | SUB_TYPE_TBL Opt|
4889: | |
4890: | OUT |
4891: | X_VAT_ADDITIONAL_AMT_TBL OUT NUMERIC11_TBL |

Line 4904: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

4900: (
4901: P_VAT_ADDIT_TAX IN VARCHAR2 DEFAULT NULL,
4902: P_REPORT_NAME IN VARCHAR2,
4903: p_REQUEST_ID IN NUMBER,
4904: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4905: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
4906: X_VAT_ADDITIONAL_AMT_TBL OUT NOCOPY NUMERIC7_TBL
4907: ) IS
4908:

Line 4905: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,

4901: P_VAT_ADDIT_TAX IN VARCHAR2 DEFAULT NULL,
4902: P_REPORT_NAME IN VARCHAR2,
4903: p_REQUEST_ID IN NUMBER,
4904: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
4905: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
4906: X_VAT_ADDITIONAL_AMT_TBL OUT NOCOPY NUMERIC7_TBL
4907: ) IS
4908:
4909: l_err_msg VARCHAR2(120);

Line 5036: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|

5032: | Parameters : |
5033: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
5034: | P_REPORT_NAME IN VARCHAR2 Req |
5035: | P_REQUEST_ID IN NUMBER Req |
5036: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
5037: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
5038: | SUB_TYPE_TBL Opt|
5039: | |
5040: | OUT |

Line 5037: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |

5033: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
5034: | P_REPORT_NAME IN VARCHAR2 Req |
5035: | P_REQUEST_ID IN NUMBER Req |
5036: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
5037: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
5038: | SUB_TYPE_TBL Opt|
5039: | |
5040: | OUT |
5041: | X_VAT_EXEMPT_AMT_TBL OUT NUMERIC14_TBL |

Line 5057: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

5053: P_VAT_PERCEP_TAX IN VARCHAR2 DEFAULT NULL,
5054: P_REPORT_NAME IN VARCHAR2,
5055: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
5056: p_REQUEST_ID IN NUMBER,
5057: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5058: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
5059: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5060: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
5061: X_VAT_EXEMPT_AMT_TBL OUT NOCOPY NUMERIC2_TBL

Line 5058: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

5054: P_REPORT_NAME IN VARCHAR2,
5055: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
5056: p_REQUEST_ID IN NUMBER,
5057: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5058: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
5059: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5060: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
5061: X_VAT_EXEMPT_AMT_TBL OUT NOCOPY NUMERIC2_TBL
5062: ) IS

Line 5059: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,

5055: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
5056: p_REQUEST_ID IN NUMBER,
5057: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5058: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
5059: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5060: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
5061: X_VAT_EXEMPT_AMT_TBL OUT NOCOPY NUMERIC2_TBL
5062: ) IS
5063:

Line 5060: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,

5056: p_REQUEST_ID IN NUMBER,
5057: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5058: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
5059: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5060: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
5061: X_VAT_EXEMPT_AMT_TBL OUT NOCOPY NUMERIC2_TBL
5062: ) IS
5063:
5064: l_err_msg VARCHAR2(120);

Line 5471: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|

5467: | Parameters : |
5468: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
5469: | P_REPORT_NAME IN VARCHAR2 Req |
5470: | P_REQUEST_ID IN NUMBER Req |
5471: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
5472: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
5473: | SUB_TYPE_TBL Opt|
5474: | |
5475: | OUT |

Line 5472: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |

5468: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
5469: | P_REPORT_NAME IN VARCHAR2 Req |
5470: | P_REQUEST_ID IN NUMBER Req |
5471: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
5472: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
5473: | SUB_TYPE_TBL Opt|
5474: | |
5475: | OUT |
5476: | X_VAT_PERCEPTION_AMT_TBL OUT NUMERIC3_TBL |

Line 5492: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

5488: P_VAT_PERC_TAX IN VARCHAR2 DEFAULT NULL,
5489: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
5490: P_REPORT_NAME IN VARCHAR2,
5491: p_REQUEST_ID IN NUMBER,
5492: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5493: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
5494: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5495: X_VAT_PERCEPTION_AMT_TBL OUT NOCOPY NUMERIC3_TBL
5496: ) IS

Line 5493: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

5489: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
5490: P_REPORT_NAME IN VARCHAR2,
5491: p_REQUEST_ID IN NUMBER,
5492: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5493: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
5494: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5495: X_VAT_PERCEPTION_AMT_TBL OUT NOCOPY NUMERIC3_TBL
5496: ) IS
5497:

Line 5494: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,

5490: P_REPORT_NAME IN VARCHAR2,
5491: p_REQUEST_ID IN NUMBER,
5492: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5493: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
5494: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5495: X_VAT_PERCEPTION_AMT_TBL OUT NOCOPY NUMERIC3_TBL
5496: ) IS
5497:
5498: l_err_msg VARCHAR2(120);

Line 5852: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|

5848: | Parameters : |
5849: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
5850: | P_REPORT_NAME IN VARCHAR2 Req |
5851: | P_REQUEST_ID IN NUMBER Req |
5852: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
5853: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
5854: | SUB_TYPE_TBL Opt|
5855: | |
5856: | OUT |

Line 5853: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |

5849: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
5850: | P_REPORT_NAME IN VARCHAR2 Req |
5851: | P_REQUEST_ID IN NUMBER Req |
5852: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
5853: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
5854: | SUB_TYPE_TBL Opt|
5855: | |
5856: | OUT |
5857: | X_OTHER_FED_PERC_AMT_TBL OUT NUMERIC7_TBL |

Line 5873: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

5869: P_VAT_PERC_TAX IN VARCHAR2 DEFAULT NULL,
5870: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
5871: P_REPORT_NAME IN VARCHAR2,
5872: p_REQUEST_ID IN NUMBER,
5873: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5874: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5875: X_OTHER_FED_PERC_AMT_TBL OUT NOCOPY NUMERIC7_TBL
5876: ) IS
5877:

Line 5874: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,

5870: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
5871: P_REPORT_NAME IN VARCHAR2,
5872: p_REQUEST_ID IN NUMBER,
5873: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
5874: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
5875: X_OTHER_FED_PERC_AMT_TBL OUT NOCOPY NUMERIC7_TBL
5876: ) IS
5877:
5878: l_err_msg VARCHAR2(120);

Line 5993: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|

5989: | Parameters : |
5990: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
5991: | P_REPORT_NAME IN VARCHAR2 Req |
5992: | P_REQUEST_ID IN NUMBER Req |
5993: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
5994: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
5995: | SUB_TYPE_TBL Opt|
5996: | |
5997: | OUT |

Line 5994: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |

5990: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
5991: | P_REPORT_NAME IN VARCHAR2 Req |
5992: | P_REQUEST_ID IN NUMBER Req |
5993: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
5994: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
5995: | SUB_TYPE_TBL Opt|
5996: | |
5997: | OUT |
5998: | X_OTHER_TAX_AMT_TBL OUT NUMERIC7_TBL |

Line 6010: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

6006: PROCEDURE GET_OTHER_TAX_AMOUNT
6007: (
6008: P_REPORT_NAME IN VARCHAR2,
6009: p_REQUEST_ID IN NUMBER,
6010: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6011: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6012: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
6013: X_OTHER_TAX_AMT_TBL OUT NOCOPY NUMERIC7_TBL
6014: ) IS

Line 6011: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,

6007: (
6008: P_REPORT_NAME IN VARCHAR2,
6009: p_REQUEST_ID IN NUMBER,
6010: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6011: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6012: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
6013: X_OTHER_TAX_AMT_TBL OUT NOCOPY NUMERIC7_TBL
6014: ) IS
6015:

Line 6012: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,

6008: P_REPORT_NAME IN VARCHAR2,
6009: p_REQUEST_ID IN NUMBER,
6010: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6011: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6012: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
6013: X_OTHER_TAX_AMT_TBL OUT NOCOPY NUMERIC7_TBL
6014: ) IS
6015:
6016: l_err_msg VARCHAR2(120);

Line 6192: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|

6188: | Parameters : |
6189: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
6190: | P_REPORT_NAME IN VARCHAR2 Req |
6191: | P_REQUEST_ID IN NUMBER Req |
6192: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
6193: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
6194: | SUB_TYPE_TBL Opt|
6195: | |
6196: | OUT |

Line 6193: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |

6189: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
6190: | P_REPORT_NAME IN VARCHAR2 Req |
6191: | P_REQUEST_ID IN NUMBER Req |
6192: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
6193: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
6194: | SUB_TYPE_TBL Opt|
6195: | |
6196: | OUT |
6197: | X_OTHER_TAX_AMT_TBL OUT NUMERIC3_TBL |

Line 6212: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

6208: P_VAT_ADDIT_TAX IN VARCHAR2 DEFAULT NULL,
6209: P_VAT_NOT_CATEG_TAX IN VARCHAR2 DEFAULT NULL,
6210: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6211: p_REQUEST_ID IN NUMBER,
6212: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6213: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6214: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
6215: X_NOT_REG_TAX_AMT_TBL OUT NOCOPY NUMERIC1_TBL
6216: ) IS

Line 6213: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,

6209: P_VAT_NOT_CATEG_TAX IN VARCHAR2 DEFAULT NULL,
6210: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6211: p_REQUEST_ID IN NUMBER,
6212: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6213: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6214: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
6215: X_NOT_REG_TAX_AMT_TBL OUT NOCOPY NUMERIC1_TBL
6216: ) IS
6217:

Line 6214: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,

6210: P_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6211: p_REQUEST_ID IN NUMBER,
6212: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6213: P_TAX_RATE_TBL IN ZX_EXTRACT_PKG.TAX_RATE_TBL,
6214: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
6215: X_NOT_REG_TAX_AMT_TBL OUT NOCOPY NUMERIC1_TBL
6216: ) IS
6217:
6218: l_err_msg VARCHAR2(120);

Line 6425: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|

6421: | P_PROV_TAX_TYPE_TO IN VARCHAR2 Opt
6422: | P_PROV_TAX_REGIME IN VARCHAR2 Opt
6423: | P_REPORT_NAME IN VARCHAR2 Req |
6424: | P_REQUEST_ID IN NUMBER Req |
6425: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
6426: | |
6427: | OUT |
6428: | X_PROVINCIAL_PERC_AMT_TBLOUT NUMERIC4_TBL |
6429: | |

Line 6443: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

6439: P_PROV_TAX_TYPE_TO IN VARCHAR2 DEFAULT NULL,
6440: P_PROV_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6441: P_REPORT_NAME IN VARCHAR2,
6442: p_REQUEST_ID IN NUMBER,
6443: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6444: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
6445: X_PROVINCIAL_PERC_AMT_TBL OUT NOCOPY NUMERIC4_TBL
6446: ) IS
6447:

Line 6444: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,

6440: P_PROV_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6441: P_REPORT_NAME IN VARCHAR2,
6442: p_REQUEST_ID IN NUMBER,
6443: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6444: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
6445: X_PROVINCIAL_PERC_AMT_TBL OUT NOCOPY NUMERIC4_TBL
6446: ) IS
6447:
6448: l_err_msg VARCHAR2(120);

Line 6641: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|

6637: | IN : P_MUN_TAX_TYPE_FROM IN VARCHAR2 Opt |
6638: | P_MUN_TAX_TYPE_TO IN VARCHAR2 Opt |
6639: | P_REPORT_NAME IN VARCHAR2 Req |
6640: | P_REQUEST_ID IN NUMBER Req |
6641: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
6642: | |
6643: | OUT |
6644: | X_MUNICIPAL_PERC_AMT_TBL OUT NUMERIC5_TBL |
6645: | |

Line 6659: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

6655: P_MUN_TAX_TYPE_TO IN VARCHAR2 DEFAULT NULL,
6656: P_MUN_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6657: P_REPORT_NAME IN VARCHAR2,
6658: p_REQUEST_ID IN NUMBER,
6659: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6660: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
6661: X_MUNICIPAL_PERC_AMT_TBL OUT NOCOPY NUMERIC5_TBL
6662: ) IS
6663:

Line 6660: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,

6656: P_MUN_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6657: P_REPORT_NAME IN VARCHAR2,
6658: p_REQUEST_ID IN NUMBER,
6659: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6660: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
6661: X_MUNICIPAL_PERC_AMT_TBL OUT NOCOPY NUMERIC5_TBL
6662: ) IS
6663:
6664: l_err_msg VARCHAR2(120);

Line 6859: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|

6855: | Parameters : |
6856: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
6857: | P_REPORT_NAME IN VARCHAR2 Req |
6858: | P_REQUEST_ID IN NUMBER Req |
6859: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
6860: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
6861: | SUB_TYPE_TBL Opt|
6862: | |
6863: | OUT |

Line 6860: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |

6856: | IN : P_VAT_TAX_TYPE IN VARCHAR2 Opt |
6857: | P_REPORT_NAME IN VARCHAR2 Req |
6858: | P_REQUEST_ID IN NUMBER Req |
6859: | P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL Req|
6860: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
6861: | SUB_TYPE_TBL Opt|
6862: | |
6863: | OUT |
6864: | X_EXCISE_TAX_AMT_TBL OUT NUMERIC5_TBL |

Line 6879: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

6875: P_EXC_TAX_TYPE_TO IN VARCHAR2 DEFAULT NULL,
6876: P_EXC_TAX_REGIME IN VARCHAR2 DEFAULT NULL,
6877: P_REPORT_NAME IN VARCHAR2,
6878: p_REQUEST_ID IN NUMBER,
6879: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
6880: X_EXCISE_AMT_TBL OUT NOCOPY NUMERIC6_TBL
6881: ) IS
6882:
6883: l_err_msg VARCHAR2(120);

Line 7046: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |

7042: | |
7043: | Parameters : |
7044: | IN : P_REPORT_NAME IN VARCHAR2 Req |
7045: | P_REQUEST_ID IN NUMBER Req |
7046: | P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_ |
7047: | SUB_TYPE_TBL Opt|
7048: | |
7049: | OUT |
7050: | X_CL_NUM_OF_DOC_TBL OUT NUMERIC5_TBL |

Line 7062: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,

7058: PROCEDURE GET_COUNTED_SUM_DOC
7059: (
7060: P_REPORT_NAME IN VARCHAR2,
7061: P_REQUEST_ID IN NUMBER,
7062: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
7063: X_CL_NUM_OF_DOC_TBL OUT NOCOPY NUMERIC3_TBL,
7064: X_CL_TOTAL_EXEMPT_TBL OUT NOCOPY NUMERIC4_TBL,
7065: X_CL_TOTAL_EFFECTIVE_TBL OUT NOCOPY NUMERIC5_TBL,
7066: X_CL_TOTAL_VAT_TAX_TBL OUT NOCOPY NUMERIC6_TBL,

Line 7230: | IN : P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL|

7226: | |
7227: | Called from ZX_JL_EXTRACT_PKG.POPULATE |
7228: | |
7229: | Parameters : |
7230: | IN : P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL|
7231: | X_JLCL_AP_DOC_TYPE_MEANING OUT VARCHAR2 |
7232: | X_ORDER_BY_DOC_TYPE OUT VARCHAR2 |
7233: | |
7234: | MODIFICATION HISTORY |

Line 7242: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,

7238: +=====================================================================================*/
7239:
7240: PROCEDURE GET_LOOKUP_INFO
7241: (
7242: P_DOCUMENT_SUB_TYPE_TBL IN ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL,
7243: X_JLCL_AP_DOC_TYPE_MEANING_TBL OUT NOCOPY DOCUMENT_SUB_TYPE_MNG_TBL,
7244: X_ORDER_BY_DOC_TYPE_TBL OUT NOCOPY ATTRIBUTE14_TBL
7245: )
7246:

Line 7401: | IN : P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL Required | |

7397: | |
7398: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
7399: | |
7400: | Parameters : |
7401: | IN : P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL Required | |
7402: | P_TRX_TYPE_ID_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL Required |
7403: | |
7404: | MODIFICATION HISTORY |
7405: | 07-Nov-03 Hidetaka Kojima created |

Line 7402: | P_TRX_TYPE_ID_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL Required |

7398: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
7399: | |
7400: | Parameters : |
7401: | IN : P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL Required | |
7402: | P_TRX_TYPE_ID_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL Required |
7403: | |
7404: | MODIFICATION HISTORY |
7405: | 07-Nov-03 Hidetaka Kojima created |
7406: | |

Line 7412: P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL,

7408: +=================================================================================*/
7409:
7410: PROCEDURE GET_DGI_CODE
7411: (
7412: P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL,
7413: P_TRX_CATEGORY_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL,
7414: P_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
7415: X_DGI_CODE_TBL OUT NOCOPY ATTRIBUTE11_TBL
7416: )

Line 7413: P_TRX_CATEGORY_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL,

7409:
7410: PROCEDURE GET_DGI_CODE
7411: (
7412: P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL,
7413: P_TRX_CATEGORY_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL,
7414: P_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
7415: X_DGI_CODE_TBL OUT NOCOPY ATTRIBUTE11_TBL
7416: )
7417: IS

Line 7414: P_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,

7410: PROCEDURE GET_DGI_CODE
7411: (
7412: P_TRX_NUMBER_TBL IN ZX_EXTRACT_PKG.TRX_NUMBER_TBL,
7413: P_TRX_CATEGORY_TBL IN ZX_EXTRACT_PKG.TRX_TYPE_ID_TBL,
7414: P_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
7415: X_DGI_CODE_TBL OUT NOCOPY ATTRIBUTE11_TBL
7416: )
7417: IS
7418:

Line 7499: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

7495:
7496: PROCEDURE GET_CUSTOMER_CONDITION_CODE
7497: (
7498: P_VAT_PERCEP_TAX IN VARCHAR2,
7499: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
7500: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
7501: P_REQUEST_ID IN NUMBER,
7502: X_CUST_CONDITION_CODE_TBL OUT NOCOPY ATTRIBUTE7_TBL
7503: )

Line 7500: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,

7496: PROCEDURE GET_CUSTOMER_CONDITION_CODE
7497: (
7498: P_VAT_PERCEP_TAX IN VARCHAR2,
7499: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
7500: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
7501: P_REQUEST_ID IN NUMBER,
7502: X_CUST_CONDITION_CODE_TBL OUT NOCOPY ATTRIBUTE7_TBL
7503: )
7504: is

Line 7679: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

7675:
7676: PROCEDURE GET_DGI_TAX_REGIME_CODE
7677: (
7678: P_VAT_PERCEP_TAX IN VARCHAR2,
7679: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
7680: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
7681: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
7682: P_REQUEST_ID IN NUMBER,
7683: X_DGI_TAX_REGIME_CODE_TBL OUT NOCOPY ATTRIBUTE25_TBL

Line 7680: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

7676: PROCEDURE GET_DGI_TAX_REGIME_CODE
7677: (
7678: P_VAT_PERCEP_TAX IN VARCHAR2,
7679: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
7680: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
7681: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
7682: P_REQUEST_ID IN NUMBER,
7683: X_DGI_TAX_REGIME_CODE_TBL OUT NOCOPY ATTRIBUTE25_TBL
7684: )

Line 7681: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,

7677: (
7678: P_VAT_PERCEP_TAX IN VARCHAR2,
7679: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
7680: P_TRX_LINE_ID_TBL IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
7681: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
7682: P_REQUEST_ID IN NUMBER,
7683: X_DGI_TAX_REGIME_CODE_TBL OUT NOCOPY ATTRIBUTE25_TBL
7684: )
7685: IS

Line 7813: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

7809:
7810: PROCEDURE GET_VAT_REG_STAT_CODE
7811: (
7812: P_VAT_TAX IN VARCHAR2,
7813: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
7814: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
7815: P_REQUEST_ID IN NUMBER,
7816: X_VAT_REG_STAT_CODE_TBL OUT NOCOPY ATTRIBUTE8_TBL
7817: )

Line 7814: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,

7810: PROCEDURE GET_VAT_REG_STAT_CODE
7811: (
7812: P_VAT_TAX IN VARCHAR2,
7813: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
7814: P_INTERNAL_ORG_ID_TBL IN ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL,
7815: P_REQUEST_ID IN NUMBER,
7816: X_VAT_REG_STAT_CODE_TBL OUT NOCOPY ATTRIBUTE8_TBL
7817: )
7818: IS

Line 8014: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

8010: PROCEDURE GET_REC_COUNT
8011: (
8012: P_VAT_TAX IN ZX_REP_TRX_DETAIL_T.TAX%TYPE,
8013: P_TAX_REGIME IN ZX_REP_TRX_DETAIL_T.TAX_REGIME_CODE%TYPE,
8014: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8015: P_REQUEST_ID IN NUMBER,
8016: X_REC_COUNT_TBL OUT NOCOPY NUMERIC11_TBL
8017: )
8018: IS

Line 8089: | IN : P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL |

8085: | |
8086: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AP |
8087: | |
8088: | Parameters : |
8089: | IN : P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL |
8090: | |
8091: +==========================================================================*/
8092: PROCEDURE GET_DGI_DOC_TYPE
8093: (

Line 8094: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

8090: | |
8091: +==========================================================================*/
8092: PROCEDURE GET_DGI_DOC_TYPE
8093: (
8094: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8095: X_DGI_DOC_TYPE_TBL OUT NOCOPY ATTRIBUTE1_TBL,
8096: X_GDF_AP_INV_ATT11_TBL OUT NOCOPY GDF_AP_INV_ATT11_TBL,
8097: X_GDF_AP_INV_ATT12_TBL OUT NOCOPY GDF_AP_INV_ATT12_TBL
8098: )

Line 8220: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

8216: (
8217: P_VAT_TAX IN ZX_REP_TRX_DETAIL_T.TAX%TYPE,
8218: P_VAT_NON_TAX IN ZX_REP_TRX_DETAIL_T.TAX%TYPE,
8219: P_TAX_REGIME IN ZX_REP_TRX_DETAIL_T.TAX_REGIME_CODE%TYPE,
8220: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8221: P_REQUEST_ID IN NUMBER,
8222: X_RATE_COUNT_TBL OUT NOCOPY NUMERIC13_TBL
8223: )
8224: IS

Line 8303: | IN : p_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL Required |

8299: | |
8300: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
8301: | |
8302: | Parameters : |
8303: | IN : p_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL Required |
8304: | |
8305: | MODIFICATION HISTORY |
8306: | 07-Nov-03 Hidetaka Kojima created |
8307: | |

Line 8314: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

8310:
8311:
8312: PROCEDURE GET_TOTAL_DOCUMENT_AMOUNT
8313: (
8314: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8315: P_EXCHANGE_RATE_TBL IN ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL,
8316: P_REPORT_NAME IN VARCHAR2,
8317: X_TOTAL_DOC_AMT_TBL OUT NOCOPY NUMERIC12_TBL
8318: )

Line 8315: P_EXCHANGE_RATE_TBL IN ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL,

8311:
8312: PROCEDURE GET_TOTAL_DOCUMENT_AMOUNT
8313: (
8314: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8315: P_EXCHANGE_RATE_TBL IN ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL,
8316: P_REPORT_NAME IN VARCHAR2,
8317: X_TOTAL_DOC_AMT_TBL OUT NOCOPY NUMERIC12_TBL
8318: )
8319: IS

Line 8478: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

8474:
8475:
8476: PROCEDURE DGI_TRX_CODE
8477: (
8478: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8479: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8480: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
8481: X_DGI_TRX_CODE_TBL OUT NOCOPY ATTRIBUTE4_TBL
8482: ) IS

Line 8479: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

8475:
8476: PROCEDURE DGI_TRX_CODE
8477: (
8478: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8479: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8480: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
8481: X_DGI_TRX_CODE_TBL OUT NOCOPY ATTRIBUTE4_TBL
8482: ) IS
8483:

Line 8480: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,

8476: PROCEDURE DGI_TRX_CODE
8477: (
8478: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8479: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8480: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
8481: X_DGI_TRX_CODE_TBL OUT NOCOPY ATTRIBUTE4_TBL
8482: ) IS
8483:
8484:

Line 8574: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

8570:
8571:
8572: PROCEDURE GET_TAX_AUTH_CATEG
8573: (
8574: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8575: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8576: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
8577: X_TAX_AUTH_CATEG_TBL OUT NOCOPY ATTRIBUTE10_TBL
8578: ) IS

Line 8575: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

8571:
8572: PROCEDURE GET_TAX_AUTH_CATEG
8573: (
8574: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8575: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8576: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
8577: X_TAX_AUTH_CATEG_TBL OUT NOCOPY ATTRIBUTE10_TBL
8578: ) IS
8579:

Line 8576: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,

8572: PROCEDURE GET_TAX_AUTH_CATEG
8573: (
8574: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8575: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8576: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
8577: X_TAX_AUTH_CATEG_TBL OUT NOCOPY ATTRIBUTE10_TBL
8578: ) IS
8579:
8580:

Line 8658: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

8654:
8655:
8656: PROCEDURE PROV_JURISDICTION_CODE
8657: (
8658: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8659: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8660: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
8661: X_PROV_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE1_TBL
8662: ) IS

Line 8659: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

8655:
8656: PROCEDURE PROV_JURISDICTION_CODE
8657: (
8658: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8659: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8660: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
8661: X_PROV_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE1_TBL
8662: ) IS
8663:

Line 8660: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,

8656: PROCEDURE PROV_JURISDICTION_CODE
8657: (
8658: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8659: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8660: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
8661: X_PROV_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE1_TBL
8662: ) IS
8663:
8664: l_prov_juris_code_tbl ATTRIBUTE1_TBL;

Line 8770: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

8766:
8767:
8768: PROCEDURE MUN_JURISDICTION_CODE
8769: (
8770: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8771: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8772: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
8773: X_MUN_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE3_TBL
8774: ) IS

Line 8771: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

8767:
8768: PROCEDURE MUN_JURISDICTION_CODE
8769: (
8770: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8771: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8772: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
8773: X_MUN_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE3_TBL
8774: ) IS
8775:

Line 8772: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,

8768: PROCEDURE MUN_JURISDICTION_CODE
8769: (
8770: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8771: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8772: P_TAX_RATE_ID_TBL IN ZX_EXTRACT_PKG.tax_rate_id_tbl,
8773: X_MUN_JURIS_CODE_TBL OUT NOCOPY ATTRIBUTE3_TBL
8774: ) IS
8775:
8776:

Line 8876: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

8872:
8873: /*
8874: PROCEDURE GET_CAI_NUM
8875: (
8876: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8877: P_REPORT_NAME IN VARCHAR2,
8878: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8879: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
8880: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,

Line 8878: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

8874: PROCEDURE GET_CAI_NUM
8875: (
8876: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8877: P_REPORT_NAME IN VARCHAR2,
8878: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8879: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
8880: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
8881: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
8882: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL

Line 8879: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,

8875: (
8876: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8877: P_REPORT_NAME IN VARCHAR2,
8878: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8879: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
8880: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
8881: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
8882: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
8883: ) IS

Line 8880: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,

8876: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8877: P_REPORT_NAME IN VARCHAR2,
8878: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8879: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
8880: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
8881: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
8882: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
8883: ) IS
8884:

Line 8895: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

8891:
8892: PROCEDURE GET_CAI_NUM
8893: PROCEDURE GET_CAI_NUM
8894: (
8895: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8896: P_REPORT_NAME IN VARCHAR2,
8897: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8898: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
8899: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,

Line 8897: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

8893: PROCEDURE GET_CAI_NUM
8894: (
8895: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8896: P_REPORT_NAME IN VARCHAR2,
8897: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8898: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
8899: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
8900: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
8901: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL

Line 8898: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,

8894: (
8895: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8896: P_REPORT_NAME IN VARCHAR2,
8897: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8898: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
8899: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
8900: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
8901: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
8902: ) IS

Line 8899: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,

8895: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8896: P_REPORT_NAME IN VARCHAR2,
8897: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8898: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
8899: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
8900: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
8901: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
8902: ) IS
8903:

Line 8914: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

8910:
8911: PROCEDURE GET_CAI_NUM
8912: PROCEDURE GET_CAI_NUM
8913: (
8914: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8915: P_REPORT_NAME IN VARCHAR2,
8916: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8917: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
8918: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,

Line 8916: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

8912: PROCEDURE GET_CAI_NUM
8913: (
8914: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8915: P_REPORT_NAME IN VARCHAR2,
8916: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8917: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
8918: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
8919: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
8920: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL

Line 8917: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,

8913: (
8914: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8915: P_REPORT_NAME IN VARCHAR2,
8916: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8917: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
8918: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
8919: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
8920: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
8921: ) IS

Line 8918: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,

8914: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8915: P_REPORT_NAME IN VARCHAR2,
8916: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8917: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
8918: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
8919: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
8920: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
8921: ) IS
8922:

Line 8932: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

8928: */
8929:
8930: PROCEDURE GET_CAI_NUM
8931: (
8932: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8933: P_REPORT_NAME IN VARCHAR2,
8934: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8935: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
8936: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,

Line 8934: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

8930: PROCEDURE GET_CAI_NUM
8931: (
8932: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8933: P_REPORT_NAME IN VARCHAR2,
8934: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8935: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
8936: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
8937: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
8938: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL

Line 8935: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,

8931: (
8932: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8933: P_REPORT_NAME IN VARCHAR2,
8934: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8935: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
8936: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
8937: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
8938: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
8939: ) IS

Line 8936: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,

8932: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
8933: P_REPORT_NAME IN VARCHAR2,
8934: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
8935: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
8936: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
8937: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
8938: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
8939: ) IS
8940:

Line 9065: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

9061: END GET_CAI_NUM;
9062:
9063: PROCEDURE GET_CAI_NUM_AR
9064: (
9065: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9066: P_REPORT_NAME IN VARCHAR2,
9067: X_CAI_NUMBER_TBL OUT NOCOPY ATTRIBUTE19_TBL,
9068: X_CAI_DUE_DATE_TBL OUT NOCOPY ATTRIBUTE23_TBL
9069: ) IS

Line 9149: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

9145:
9146:
9147: PROCEDURE GET_FISCAL_PRINTER
9148: (
9149: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9150: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9151: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9152: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9153: X_FISCAL_PRINTER_TBL OUT NOCOPY ATTRIBUTE20_TBL

Line 9150: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

9146:
9147: PROCEDURE GET_FISCAL_PRINTER
9148: (
9149: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9150: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9151: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9152: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9153: X_FISCAL_PRINTER_TBL OUT NOCOPY ATTRIBUTE20_TBL
9154: ) IS

Line 9151: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,

9147: PROCEDURE GET_FISCAL_PRINTER
9148: (
9149: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9150: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9151: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9152: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9153: X_FISCAL_PRINTER_TBL OUT NOCOPY ATTRIBUTE20_TBL
9154: ) IS
9155:

Line 9152: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,

9148: (
9149: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9150: P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9151: P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9152: P_BILL_FROM_SITE_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9153: X_FISCAL_PRINTER_TBL OUT NOCOPY ATTRIBUTE20_TBL
9154: ) IS
9155:
9156: l_fiscal_printer_tbl ATTRIBUTE20_TBL;

Line 9245: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

9241:
9242:
9243: PROCEDURE GET_TAXPAYERID_TYPE
9244: (
9245: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9246: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9247: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9248: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9249: X_TAXPAYERID_TYPE_TBL OUT NOCOPY ATTRIBUTE21_TBL,

Line 9246: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,

9242:
9243: PROCEDURE GET_TAXPAYERID_TYPE
9244: (
9245: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9246: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9247: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9248: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9249: X_TAXPAYERID_TYPE_TBL OUT NOCOPY ATTRIBUTE21_TBL,
9250: X_REG_STATUS_CODE_TBL OUT NOCOPY ATTRIBUTE22_TBL

Line 9247: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,

9243: PROCEDURE GET_TAXPAYERID_TYPE
9244: (
9245: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9246: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9247: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9248: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9249: X_TAXPAYERID_TYPE_TBL OUT NOCOPY ATTRIBUTE21_TBL,
9250: X_REG_STATUS_CODE_TBL OUT NOCOPY ATTRIBUTE22_TBL
9251: ) IS

Line 9248: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,

9244: (
9245: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9246: --P_TAX_REGIME_CODE_TBL IN ZX_EXTRACT_PKG.TAX_REGIME_CODE_TBL,
9247: --P_BILL_FROM_SITE_PROF_ID_TBL IN ZX_EXTRACT_PKG.BILL_FROM_SITE_TAX_PROF_ID_TBL,
9248: P_BILL_FROM_TP_ID_TBL IN ZX_EXTRACT_PKG.SHIPPING_TP_ADDRESS_ID_TBL,
9249: X_TAXPAYERID_TYPE_TBL OUT NOCOPY ATTRIBUTE21_TBL,
9250: X_REG_STATUS_CODE_TBL OUT NOCOPY ATTRIBUTE22_TBL
9251: ) IS
9252:

Line 9335: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

9331: END GET_TAXPAYERID_TYPE;
9332:
9333: PROCEDURE GET_FISCAL_PRINTER_AR
9334: (
9335: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9336: P_BATCH_SOURCE_ID_TBL IN ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL,
9337: X_FISCAL_PRINTER_TBL OUT NOCOPY GDF_RA_BATCH_SOURCES_ATT7_TBL
9338: ) IS
9339:

Line 9336: P_BATCH_SOURCE_ID_TBL IN ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL,

9332:
9333: PROCEDURE GET_FISCAL_PRINTER_AR
9334: (
9335: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9336: P_BATCH_SOURCE_ID_TBL IN ZX_EXTRACT_PKG.BATCH_SOURCE_ID_TBL,
9337: X_FISCAL_PRINTER_TBL OUT NOCOPY GDF_RA_BATCH_SOURCES_ATT7_TBL
9338: ) IS
9339:
9340: l_fiscal_printer_tbl GDF_RA_BATCH_SOURCES_ATT7_TBL;

Line 9418: | IN : p_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL Required|

9414: | |
9415: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
9416: | |
9417: | Parameters : |
9418: | IN : p_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL Required|
9419: | |
9420: | MODIFICATION HISTORY |
9421: | 07-Nov-03 Hidetaka Kojima created |
9422: | |

Line 9428: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,

9424: +===========================================================================*/
9425:
9426: PROCEDURE GET_TOTAL_DOC_TAXABLE_AMOUNT
9427: (
9428: P_TRX_ID_TBL IN ZX_EXTRACT_PKG.TRX_ID_TBL,
9429: P_REQUEST_ID IN NUMBER,
9430: X_TOTAL_DOC_TAXAB_AMT_TBL OUT NOCOPY NUMERIC8_TBL
9431: )
9432: IS