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

Line 226: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,

222:
223: PROCEDURE get_default_tax_classification(
224:
225: -- p_line_location_id IN po_line_locations.line_location_id%TYPE,
226: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
227: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
228: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
229: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
230: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

Line 227: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,

223: PROCEDURE get_default_tax_classification(
224:
225: -- p_line_location_id IN po_line_locations.line_location_id%TYPE,
226: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
227: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
228: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
229: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
230: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
231: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

Line 228: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,

224:
225: -- p_line_location_id IN po_line_locations.line_location_id%TYPE,
226: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
227: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
228: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
229: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
230: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
231: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
232: p_vendor_id IN po_vendors.vendor_id%TYPE,

Line 229: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,

225: -- p_line_location_id IN po_line_locations.line_location_id%TYPE,
226: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
227: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
228: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
229: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
230: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
231: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
232: p_vendor_id IN po_vendors.vendor_id%TYPE,
233: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,

Line 230: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

226: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
227: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
228: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
229: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
230: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
231: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
232: p_vendor_id IN po_vendors.vendor_id%TYPE,
233: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
234: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,

Line 231: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

227: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
228: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
229: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
230: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
231: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
232: p_vendor_id IN po_vendors.vendor_id%TYPE,
233: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
234: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
235: p_concatenated_segments IN varchar2,

Line 243: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,

239: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
240: p_item_org_id IN mtl_system_items.organization_id%TYPE,
241: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
242: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
243: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
244: APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
245: FUNC_SHORT_NAME IN VARCHAR2,
246: p_calling_sequence IN VARCHAR2,
247: p_event_class_code IN VARCHAR2,

Line 312: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,

308: -- bug#4891362- overloaded version
309: --
310:
311: PROCEDURE get_default_tax_classification(
312: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
313: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
314: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
315: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
316: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

Line 313: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,

309: --
310:
311: PROCEDURE get_default_tax_classification(
312: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
313: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
314: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
315: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
316: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
317: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

Line 314: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,

310:
311: PROCEDURE get_default_tax_classification(
312: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
313: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
314: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
315: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
316: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
317: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
318: p_vendor_id IN po_vendors.vendor_id%TYPE,

Line 315: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,

311: PROCEDURE get_default_tax_classification(
312: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
313: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
314: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
315: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
316: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
317: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
318: p_vendor_id IN po_vendors.vendor_id%TYPE,
319: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,

Line 316: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

312: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
313: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
314: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
315: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
316: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
317: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
318: p_vendor_id IN po_vendors.vendor_id%TYPE,
319: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
320: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,

Line 317: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

313: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
314: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
315: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
316: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
317: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
318: p_vendor_id IN po_vendors.vendor_id%TYPE,
319: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
320: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
321: p_concatenated_segments IN varchar2,

Line 400: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,

396: --------------------------------------------------------------
397: -- The API get_default_tax_classification replaces 11i API get_default_tax_code
398: PROCEDURE get_default_tax_classification(
399: -- p_line_location_id IN po_line_locations.line_location_id%TYPE,
400: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
401: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
402: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
403: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
404: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

Line 401: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,

397: -- The API get_default_tax_classification replaces 11i API get_default_tax_code
398: PROCEDURE get_default_tax_classification(
399: -- p_line_location_id IN po_line_locations.line_location_id%TYPE,
400: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
401: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
402: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
403: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
404: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
405: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

Line 402: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,

398: PROCEDURE get_default_tax_classification(
399: -- p_line_location_id IN po_line_locations.line_location_id%TYPE,
400: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
401: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
402: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
403: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
404: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
405: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
406: p_vendor_id IN po_vendors.vendor_id%TYPE,

Line 403: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,

399: -- p_line_location_id IN po_line_locations.line_location_id%TYPE,
400: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
401: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
402: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
403: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
404: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
405: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
406: p_vendor_id IN po_vendors.vendor_id%TYPE,
407: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,

Line 404: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

400: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
401: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
402: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
403: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
404: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
405: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
406: p_vendor_id IN po_vendors.vendor_id%TYPE,
407: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
408: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,

Line 405: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

401: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
402: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
403: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
404: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
405: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
406: p_vendor_id IN po_vendors.vendor_id%TYPE,
407: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
408: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
409: p_concatenated_segments IN varchar2,

Line 419: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,

415: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
416: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
417: p_tax_user_override_flag IN VARCHAR2,
418: p_user_tax_name IN VARCHAR2,
419: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
420: APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
421: FUNC_SHORT_NAME IN VARCHAR2,
422: p_calling_sequence IN VARCHAR2,
423: p_event_class_code IN VARCHAR2,

Line 1385: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,

1381: -- bug#4891362- overloaded version
1382: --
1383:
1384: PROCEDURE get_default_tax_classification(
1385: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1386: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1387: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1388: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1389: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

Line 1386: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,

1382: --
1383:
1384: PROCEDURE get_default_tax_classification(
1385: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1386: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1387: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1388: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1389: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1390: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

Line 1387: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,

1383:
1384: PROCEDURE get_default_tax_classification(
1385: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1386: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1387: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1388: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1389: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1390: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1391: p_vendor_id IN po_vendors.vendor_id%TYPE,

Line 1388: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,

1384: PROCEDURE get_default_tax_classification(
1385: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1386: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1387: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1388: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1389: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1390: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1391: p_vendor_id IN po_vendors.vendor_id%TYPE,
1392: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,

Line 1389: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

1385: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1386: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1387: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1388: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1389: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1390: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1391: p_vendor_id IN po_vendors.vendor_id%TYPE,
1392: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
1393: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,

Line 1390: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

1386: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1387: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1388: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1389: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1390: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1391: p_vendor_id IN po_vendors.vendor_id%TYPE,
1392: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
1393: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
1394: p_concatenated_segments IN varchar2,

Line 1404: --p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,

1400: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
1401: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
1402: p_tax_user_override_flag IN VARCHAR2,
1403: p_user_tax_name IN VARCHAR2,
1404: --p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
1405: APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
1406: FUNC_SHORT_NAME IN VARCHAR2,
1407: p_calling_sequence IN VARCHAR2,
1408: p_event_class_code IN VARCHAR2,

Line 1494: -- zx_lines_det_factors

1490: -- 15-JUL-97 Fiona Purves created based on AR API.
1491: -- 11-MAY-05 Phong La modified for bug#4310278, po_line_locations
1492: -- will no longer carry tax columns, need to
1493: -- get input_tax_classification_code from
1494: -- zx_lines_det_factors
1495: -------------------------------------------------------------------------------
1496:
1497: FUNCTION get_input_tax_classif_code (
1498: --p_line_location_id IN po_line_locations.line_location_id%TYPE,

Line 1499: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,

1495: -------------------------------------------------------------------------------
1496:
1497: FUNCTION get_input_tax_classif_code (
1498: --p_line_location_id IN po_line_locations.line_location_id%TYPE,
1499: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1500: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1501: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1502: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1503: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

Line 1500: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,

1496:
1497: FUNCTION get_input_tax_classif_code (
1498: --p_line_location_id IN po_line_locations.line_location_id%TYPE,
1499: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1500: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1501: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1502: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1503: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1504: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

Line 1501: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,

1497: FUNCTION get_input_tax_classif_code (
1498: --p_line_location_id IN po_line_locations.line_location_id%TYPE,
1499: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1500: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1501: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1502: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1503: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1504: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1505: p_calling_sequence IN varchar2) RETURN VARCHAR2 IS

Line 1502: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,

1498: --p_line_location_id IN po_line_locations.line_location_id%TYPE,
1499: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1500: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1501: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1502: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1503: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1504: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1505: p_calling_sequence IN varchar2) RETURN VARCHAR2 IS
1506:

Line 1503: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

1499: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
1500: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1501: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1502: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1503: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1504: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1505: p_calling_sequence IN varchar2) RETURN VARCHAR2 IS
1506:
1507: l_curr_calling_sequence VARCHAR2(2000);

Line 1504: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

1500: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
1501: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
1502: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
1503: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1504: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1505: p_calling_sequence IN varchar2) RETURN VARCHAR2 IS
1506:
1507: l_curr_calling_sequence VARCHAR2(2000);
1508: l_tax_classification_code VARCHAR2(30);

Line 1515: * zx_lines_det_factors

1511: -- with tax classification code and the following query needs
1512: -- to replace tax_code_id with right column
1513: /*
1514: * bug#4310278 get input_tax_classification_code from
1515: * zx_lines_det_factors
1516: CURSOR sel_input_tax_cls_cd IS
1517: SELECT tc.lookup_code
1518: FROM fnd_lookups tc,
1519: po_line_locations ll

Line 1527: (c_ref_doc_application_id ZX_LINES_DET_FACTORS.application_id%TYPE,

1523: AND nvl(tc.enabled_flag,'Y') = 'Y';
1524: */
1525:
1526: CURSOR sel_input_tax_cls_cd
1527: (c_ref_doc_application_id ZX_LINES_DET_FACTORS.application_id%TYPE,
1528: c_ref_doc_entity_code ZX_LINES_DET_FACTORS.entity_code%TYPE,
1529: c_ref_doc_event_class_code ZX_LINES_DET_FACTORS.event_class_code%TYPE,
1530: c_ref_doc_trx_id ZX_LINES_DET_FACTORS.trx_id%TYPE,
1531: c_ref_doc_line_id ZX_LINES_DET_FACTORS.trx_line_id%TYPE,

Line 1528: c_ref_doc_entity_code ZX_LINES_DET_FACTORS.entity_code%TYPE,

1524: */
1525:
1526: CURSOR sel_input_tax_cls_cd
1527: (c_ref_doc_application_id ZX_LINES_DET_FACTORS.application_id%TYPE,
1528: c_ref_doc_entity_code ZX_LINES_DET_FACTORS.entity_code%TYPE,
1529: c_ref_doc_event_class_code ZX_LINES_DET_FACTORS.event_class_code%TYPE,
1530: c_ref_doc_trx_id ZX_LINES_DET_FACTORS.trx_id%TYPE,
1531: c_ref_doc_line_id ZX_LINES_DET_FACTORS.trx_line_id%TYPE,
1532: c_ref_doc_trx_level_type ZX_LINES_DET_FACTORS.trx_level_type%TYPE)

Line 1529: c_ref_doc_event_class_code ZX_LINES_DET_FACTORS.event_class_code%TYPE,

1525:
1526: CURSOR sel_input_tax_cls_cd
1527: (c_ref_doc_application_id ZX_LINES_DET_FACTORS.application_id%TYPE,
1528: c_ref_doc_entity_code ZX_LINES_DET_FACTORS.entity_code%TYPE,
1529: c_ref_doc_event_class_code ZX_LINES_DET_FACTORS.event_class_code%TYPE,
1530: c_ref_doc_trx_id ZX_LINES_DET_FACTORS.trx_id%TYPE,
1531: c_ref_doc_line_id ZX_LINES_DET_FACTORS.trx_line_id%TYPE,
1532: c_ref_doc_trx_level_type ZX_LINES_DET_FACTORS.trx_level_type%TYPE)
1533: IS

Line 1530: c_ref_doc_trx_id ZX_LINES_DET_FACTORS.trx_id%TYPE,

1526: CURSOR sel_input_tax_cls_cd
1527: (c_ref_doc_application_id ZX_LINES_DET_FACTORS.application_id%TYPE,
1528: c_ref_doc_entity_code ZX_LINES_DET_FACTORS.entity_code%TYPE,
1529: c_ref_doc_event_class_code ZX_LINES_DET_FACTORS.event_class_code%TYPE,
1530: c_ref_doc_trx_id ZX_LINES_DET_FACTORS.trx_id%TYPE,
1531: c_ref_doc_line_id ZX_LINES_DET_FACTORS.trx_line_id%TYPE,
1532: c_ref_doc_trx_level_type ZX_LINES_DET_FACTORS.trx_level_type%TYPE)
1533: IS
1534: SELECT input_tax_classification_code

Line 1531: c_ref_doc_line_id ZX_LINES_DET_FACTORS.trx_line_id%TYPE,

1527: (c_ref_doc_application_id ZX_LINES_DET_FACTORS.application_id%TYPE,
1528: c_ref_doc_entity_code ZX_LINES_DET_FACTORS.entity_code%TYPE,
1529: c_ref_doc_event_class_code ZX_LINES_DET_FACTORS.event_class_code%TYPE,
1530: c_ref_doc_trx_id ZX_LINES_DET_FACTORS.trx_id%TYPE,
1531: c_ref_doc_line_id ZX_LINES_DET_FACTORS.trx_line_id%TYPE,
1532: c_ref_doc_trx_level_type ZX_LINES_DET_FACTORS.trx_level_type%TYPE)
1533: IS
1534: SELECT input_tax_classification_code
1535: FROM zx_lines_det_factors

Line 1532: c_ref_doc_trx_level_type ZX_LINES_DET_FACTORS.trx_level_type%TYPE)

1528: c_ref_doc_entity_code ZX_LINES_DET_FACTORS.entity_code%TYPE,
1529: c_ref_doc_event_class_code ZX_LINES_DET_FACTORS.event_class_code%TYPE,
1530: c_ref_doc_trx_id ZX_LINES_DET_FACTORS.trx_id%TYPE,
1531: c_ref_doc_line_id ZX_LINES_DET_FACTORS.trx_line_id%TYPE,
1532: c_ref_doc_trx_level_type ZX_LINES_DET_FACTORS.trx_level_type%TYPE)
1533: IS
1534: SELECT input_tax_classification_code
1535: FROM zx_lines_det_factors
1536: WHERE application_id = c_ref_doc_application_id

Line 1535: FROM zx_lines_det_factors

1531: c_ref_doc_line_id ZX_LINES_DET_FACTORS.trx_line_id%TYPE,
1532: c_ref_doc_trx_level_type ZX_LINES_DET_FACTORS.trx_level_type%TYPE)
1533: IS
1534: SELECT input_tax_classification_code
1535: FROM zx_lines_det_factors
1536: WHERE application_id = c_ref_doc_application_id
1537: AND entity_code = c_ref_doc_entity_code
1538: AND event_class_code = c_ref_doc_event_class_code
1539: AND trx_id = c_ref_doc_trx_id

Line 1940: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,

1936:
1937: FUNCTION get_ship_to_location_tax (
1938: p_ship_to_loc_id IN hr_locations_all.location_id%TYPE,
1939: p_ship_to_loc_org_id IN hr_locations_all.inventory_organization_id%TYPE,
1940: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
1941: p_calling_sequence IN varchar2 )
1942:
1943: RETURN VARCHAR2 IS
1944: l_curr_calling_sequence VARCHAR2(2000);

Line 2077: --p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,

2073:
2074: FUNCTION get_ship_to_location_tax (
2075: p_ship_to_loc_id IN hr_locations_all.location_id%TYPE,
2076: p_ship_to_loc_org_id IN hr_locations_all.inventory_organization_id%TYPE,
2077: --p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
2078: p_calling_sequence IN varchar2 )
2079:
2080: RETURN VARCHAR2 IS
2081:

Line 2122: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,

2118: --
2119: -- bug#8717533
2120: --
2121: PROCEDURE get_def_tax_classif_from_acc(
2122: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
2123: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
2124: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
2125: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
2126: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

Line 2123: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,

2119: -- bug#8717533
2120: --
2121: PROCEDURE get_def_tax_classif_from_acc(
2122: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
2123: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
2124: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
2125: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
2126: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
2127: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

Line 2124: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,

2120: --
2121: PROCEDURE get_def_tax_classif_from_acc(
2122: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
2123: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
2124: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
2125: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
2126: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
2127: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
2128: p_vendor_id IN po_vendors.vendor_id%TYPE,

Line 2125: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,

2121: PROCEDURE get_def_tax_classif_from_acc(
2122: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
2123: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
2124: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
2125: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
2126: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
2127: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
2128: p_vendor_id IN po_vendors.vendor_id%TYPE,
2129: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,

Line 2126: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,

2122: p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
2123: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
2124: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
2125: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
2126: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
2127: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
2128: p_vendor_id IN po_vendors.vendor_id%TYPE,
2129: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
2130: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,

Line 2127: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,

2123: p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
2124: p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
2125: p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
2126: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
2127: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
2128: p_vendor_id IN po_vendors.vendor_id%TYPE,
2129: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
2130: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
2131: p_concatenated_segments IN varchar2,

Line 2141: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE DEFAULT NULL,

2137: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
2138: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
2139: p_tax_user_override_flag IN VARCHAR2 DEFAULT 'N',
2140: p_user_tax_name IN VARCHAR2 DEFAULT NULL,
2141: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE DEFAULT NULL,
2142: APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
2143: FUNC_SHORT_NAME IN VARCHAR2,
2144: p_calling_sequence IN VARCHAR2,
2145: p_event_class_code IN VARCHAR2,