eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_AP_TAX_CLASSIFICATN_DEF_PKG dependencies on ZX_LINES_DET_FACTORS

Line 220: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,

216:
217: PROCEDURE get_default_tax_classification(
218:
219: -- p_line_location_id IN po_line_locations.line_location_id%TYPE,
220: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
221: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
222: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
223: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
224: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

Line 221: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,

217: PROCEDURE get_default_tax_classification(
218:
219: -- p_line_location_id IN po_line_locations.line_location_id%TYPE,
220: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
221: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
222: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
223: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
224: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
225: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

Line 222: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,

218:
219: -- p_line_location_id IN po_line_locations.line_location_id%TYPE,
220: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
221: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
222: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
223: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
224: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
225: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
226: p_vendor_id IN po_vendors.vendor_id%TYPE,

Line 223: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,

219: -- p_line_location_id IN po_line_locations.line_location_id%TYPE,
220: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
221: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
222: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
223: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
224: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
225: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
226: p_vendor_id IN po_vendors.vendor_id%TYPE,
227: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,

Line 224: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

220: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
221: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
222: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
223: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
224: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
225: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
226: p_vendor_id IN po_vendors.vendor_id%TYPE,
227: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
228: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,

Line 225: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

221: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
222: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
223: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
224: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
225: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
226: p_vendor_id IN po_vendors.vendor_id%TYPE,
227: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
228: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
229: p_concatenated_segments IN varchar2,

Line 306: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,

302: -- bug#4891362- overloaded version
303: --
304:
305: PROCEDURE get_default_tax_classification(
306: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
307: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
308: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
309: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
310: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

Line 307: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,

303: --
304:
305: PROCEDURE get_default_tax_classification(
306: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
307: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
308: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
309: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
310: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
311: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

Line 308: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,

304:
305: PROCEDURE get_default_tax_classification(
306: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
307: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
308: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
309: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
310: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
311: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
312: p_vendor_id IN po_vendors.vendor_id%TYPE,

Line 309: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,

305: PROCEDURE get_default_tax_classification(
306: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
307: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
308: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
309: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
310: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
311: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
312: p_vendor_id IN po_vendors.vendor_id%TYPE,
313: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,

Line 310: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

306: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
307: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
308: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
309: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
310: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
311: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
312: p_vendor_id IN po_vendors.vendor_id%TYPE,
313: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
314: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,

Line 311: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

307: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
308: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
309: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
310: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
311: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
312: p_vendor_id IN po_vendors.vendor_id%TYPE,
313: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
314: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
315: p_concatenated_segments IN varchar2,

Line 394: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,

390: --------------------------------------------------------------
391: -- The API get_default_tax_classification replaces 11i API get_default_tax_code
392: PROCEDURE get_default_tax_classification(
393: -- p_line_location_id IN po_line_locations.line_location_id%TYPE,
394: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
395: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
396: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
397: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
398: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

Line 395: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,

391: -- The API get_default_tax_classification replaces 11i API get_default_tax_code
392: PROCEDURE get_default_tax_classification(
393: -- p_line_location_id IN po_line_locations.line_location_id%TYPE,
394: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
395: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
396: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
397: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
398: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
399: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

Line 396: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,

392: PROCEDURE get_default_tax_classification(
393: -- p_line_location_id IN po_line_locations.line_location_id%TYPE,
394: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
395: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
396: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
397: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
398: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
399: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
400: p_vendor_id IN po_vendors.vendor_id%TYPE,

Line 397: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,

393: -- p_line_location_id IN po_line_locations.line_location_id%TYPE,
394: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
395: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
396: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
397: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
398: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
399: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
400: p_vendor_id IN po_vendors.vendor_id%TYPE,
401: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,

Line 398: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

394: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
395: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
396: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
397: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
398: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
399: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
400: p_vendor_id IN po_vendors.vendor_id%TYPE,
401: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
402: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,

Line 399: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

395: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
396: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
397: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
398: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
399: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
400: p_vendor_id IN po_vendors.vendor_id%TYPE,
401: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
402: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
403: p_concatenated_segments IN varchar2,

Line 1373: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,

1369: -- bug#4891362- overloaded version
1370: --
1371:
1372: PROCEDURE get_default_tax_classification(
1373: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1374: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1375: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1376: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1377: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

Line 1374: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,

1370: --
1371:
1372: PROCEDURE get_default_tax_classification(
1373: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1374: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1375: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1376: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1377: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1378: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

Line 1375: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,

1371:
1372: PROCEDURE get_default_tax_classification(
1373: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1374: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1375: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1376: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1377: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1378: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1379: p_vendor_id IN po_vendors.vendor_id%TYPE,

Line 1376: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,

1372: PROCEDURE get_default_tax_classification(
1373: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1374: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1375: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1376: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1377: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1378: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1379: p_vendor_id IN po_vendors.vendor_id%TYPE,
1380: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,

Line 1377: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

1373: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1374: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1375: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1376: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1377: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1378: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1379: p_vendor_id IN po_vendors.vendor_id%TYPE,
1380: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
1381: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,

Line 1378: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

1374: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1375: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1376: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1377: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1378: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1379: p_vendor_id IN po_vendors.vendor_id%TYPE,
1380: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
1381: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
1382: p_concatenated_segments IN varchar2,

Line 1482: -- zx_lines_det_factors

1478: -- 15-JUL-97 Fiona Purves created based on AR API.
1479: -- 11-MAY-05 Phong La modified for bug#4310278, po_line_locations
1480: -- will no longer carry tax columns, need to
1481: -- get input_tax_classification_code from
1482: -- zx_lines_det_factors
1483: -------------------------------------------------------------------------------
1484:
1485: FUNCTION get_input_tax_classif_code (
1486: --p_line_location_id IN po_line_locations.line_location_id%TYPE,

Line 1487: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,

1483: -------------------------------------------------------------------------------
1484:
1485: FUNCTION get_input_tax_classif_code (
1486: --p_line_location_id IN po_line_locations.line_location_id%TYPE,
1487: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1488: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1489: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1490: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1491: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

Line 1488: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,

1484:
1485: FUNCTION get_input_tax_classif_code (
1486: --p_line_location_id IN po_line_locations.line_location_id%TYPE,
1487: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1488: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1489: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1490: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1491: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1492: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

Line 1489: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,

1485: FUNCTION get_input_tax_classif_code (
1486: --p_line_location_id IN po_line_locations.line_location_id%TYPE,
1487: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1488: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1489: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1490: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1491: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1492: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1493: p_calling_sequence IN varchar2) RETURN VARCHAR2 IS

Line 1490: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,

1486: --p_line_location_id IN po_line_locations.line_location_id%TYPE,
1487: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1488: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1489: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1490: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1491: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1492: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1493: p_calling_sequence IN varchar2) RETURN VARCHAR2 IS
1494:

Line 1491: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

1487: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1488: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1489: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1490: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1491: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1492: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1493: p_calling_sequence IN varchar2) RETURN VARCHAR2 IS
1494:
1495: l_curr_calling_sequence VARCHAR2(2000);

Line 1492: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

1488: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1489: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1490: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1491: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1492: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1493: p_calling_sequence IN varchar2) RETURN VARCHAR2 IS
1494:
1495: l_curr_calling_sequence VARCHAR2(2000);
1496: l_tax_classification_code VARCHAR2(30);

Line 1503: * zx_lines_det_factors

1499: -- with tax classification code and the following query needs
1500: -- to replace tax_code_id with right column
1501: /*
1502: * bug#4310278 get input_tax_classification_code from
1503: * zx_lines_det_factors
1504: CURSOR sel_input_tax_cls_cd IS
1505: SELECT tc.lookup_code
1506: FROM fnd_lookups tc,
1507: po_line_locations ll

Line 1515: (c_ref_doc_application_id ZX_LINES_DET_FACTORS.application_id%TYPE,

1511: AND nvl(tc.enabled_flag,'Y') = 'Y';
1512: */
1513:
1514: CURSOR sel_input_tax_cls_cd
1515: (c_ref_doc_application_id ZX_LINES_DET_FACTORS.application_id%TYPE,
1516: c_ref_doc_entity_code ZX_LINES_DET_FACTORS.entity_code%TYPE,
1517: c_ref_doc_event_class_code ZX_LINES_DET_FACTORS.event_class_code%TYPE,
1518: c_ref_doc_trx_id ZX_LINES_DET_FACTORS.trx_id%TYPE,
1519: c_ref_doc_line_id ZX_LINES_DET_FACTORS.trx_line_id%TYPE,

Line 1516: c_ref_doc_entity_code ZX_LINES_DET_FACTORS.entity_code%TYPE,

1512: */
1513:
1514: CURSOR sel_input_tax_cls_cd
1515: (c_ref_doc_application_id ZX_LINES_DET_FACTORS.application_id%TYPE,
1516: c_ref_doc_entity_code ZX_LINES_DET_FACTORS.entity_code%TYPE,
1517: c_ref_doc_event_class_code ZX_LINES_DET_FACTORS.event_class_code%TYPE,
1518: c_ref_doc_trx_id ZX_LINES_DET_FACTORS.trx_id%TYPE,
1519: c_ref_doc_line_id ZX_LINES_DET_FACTORS.trx_line_id%TYPE,
1520: c_ref_doc_trx_level_type ZX_LINES_DET_FACTORS.trx_level_type%TYPE)

Line 1517: c_ref_doc_event_class_code ZX_LINES_DET_FACTORS.event_class_code%TYPE,

1513:
1514: CURSOR sel_input_tax_cls_cd
1515: (c_ref_doc_application_id ZX_LINES_DET_FACTORS.application_id%TYPE,
1516: c_ref_doc_entity_code ZX_LINES_DET_FACTORS.entity_code%TYPE,
1517: c_ref_doc_event_class_code ZX_LINES_DET_FACTORS.event_class_code%TYPE,
1518: c_ref_doc_trx_id ZX_LINES_DET_FACTORS.trx_id%TYPE,
1519: c_ref_doc_line_id ZX_LINES_DET_FACTORS.trx_line_id%TYPE,
1520: c_ref_doc_trx_level_type ZX_LINES_DET_FACTORS.trx_level_type%TYPE)
1521: IS

Line 1518: c_ref_doc_trx_id ZX_LINES_DET_FACTORS.trx_id%TYPE,

1514: CURSOR sel_input_tax_cls_cd
1515: (c_ref_doc_application_id ZX_LINES_DET_FACTORS.application_id%TYPE,
1516: c_ref_doc_entity_code ZX_LINES_DET_FACTORS.entity_code%TYPE,
1517: c_ref_doc_event_class_code ZX_LINES_DET_FACTORS.event_class_code%TYPE,
1518: c_ref_doc_trx_id ZX_LINES_DET_FACTORS.trx_id%TYPE,
1519: c_ref_doc_line_id ZX_LINES_DET_FACTORS.trx_line_id%TYPE,
1520: c_ref_doc_trx_level_type ZX_LINES_DET_FACTORS.trx_level_type%TYPE)
1521: IS
1522: SELECT input_tax_classification_code

Line 1519: c_ref_doc_line_id ZX_LINES_DET_FACTORS.trx_line_id%TYPE,

1515: (c_ref_doc_application_id ZX_LINES_DET_FACTORS.application_id%TYPE,
1516: c_ref_doc_entity_code ZX_LINES_DET_FACTORS.entity_code%TYPE,
1517: c_ref_doc_event_class_code ZX_LINES_DET_FACTORS.event_class_code%TYPE,
1518: c_ref_doc_trx_id ZX_LINES_DET_FACTORS.trx_id%TYPE,
1519: c_ref_doc_line_id ZX_LINES_DET_FACTORS.trx_line_id%TYPE,
1520: c_ref_doc_trx_level_type ZX_LINES_DET_FACTORS.trx_level_type%TYPE)
1521: IS
1522: SELECT input_tax_classification_code
1523: FROM zx_lines_det_factors

Line 1520: c_ref_doc_trx_level_type ZX_LINES_DET_FACTORS.trx_level_type%TYPE)

1516: c_ref_doc_entity_code ZX_LINES_DET_FACTORS.entity_code%TYPE,
1517: c_ref_doc_event_class_code ZX_LINES_DET_FACTORS.event_class_code%TYPE,
1518: c_ref_doc_trx_id ZX_LINES_DET_FACTORS.trx_id%TYPE,
1519: c_ref_doc_line_id ZX_LINES_DET_FACTORS.trx_line_id%TYPE,
1520: c_ref_doc_trx_level_type ZX_LINES_DET_FACTORS.trx_level_type%TYPE)
1521: IS
1522: SELECT input_tax_classification_code
1523: FROM zx_lines_det_factors
1524: WHERE application_id = c_ref_doc_application_id

Line 1523: FROM zx_lines_det_factors

1519: c_ref_doc_line_id ZX_LINES_DET_FACTORS.trx_line_id%TYPE,
1520: c_ref_doc_trx_level_type ZX_LINES_DET_FACTORS.trx_level_type%TYPE)
1521: IS
1522: SELECT input_tax_classification_code
1523: FROM zx_lines_det_factors
1524: WHERE application_id = c_ref_doc_application_id
1525: AND entity_code = c_ref_doc_entity_code
1526: AND event_class_code = c_ref_doc_event_class_code
1527: AND trx_id = c_ref_doc_trx_id