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.PO_TAX_INTERFACE_PVT dependencies on ZX_TRX_HEADERS_GT

Line 377: DELETE FROM zx_trx_headers_gt

373: END IF;
374:
375: d_progress := 160;
376: -- Delete data from zx gt tables for which defaulting/redefaulting failed
377: DELETE FROM zx_trx_headers_gt
378: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
379: WHERE psgt.key = l_po_session_gt_key
380: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
381: d_progress := 170;

Line 529: DELETE FROM zx_trx_headers_gt

525: END IF;
526:
527: d_progress := 250;
528: -- Delete data from zx gt tables for which defaulting/redefaulting failed
529: DELETE FROM zx_trx_headers_gt
530: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
531: WHERE psgt.key = l_po_session_gt_key
532: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
533: AND psgt.char3 = 'CALCULATE_TAX');

Line 535: DELETE FROM zx_trx_headers_gt

531: WHERE psgt.key = l_po_session_gt_key
532: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
533: AND psgt.char3 = 'CALCULATE_TAX');
534: d_progress := 260;
535: DELETE FROM zx_trx_headers_gt
536: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
537: WHERE psgt.key = l_po_session_gt_key
538: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
539: AND psgt.char3 = 'CALCULATE_TAX');

Line 581: UPDATE zx_trx_headers_gt zxhgt

577: d_progress := 320;
578: -- Update event_type_code on zx headers as required by determine_recovery API
579: -- Update to DISTRIBUTED only if all distributions have
580: -- tax_attribute_update_code = 'CREATE'
581: UPDATE zx_trx_headers_gt zxhgt
582: SET zxhgt.event_type_code =
583: DECODE(zxhgt.event_class_code,
584: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
585: NVL2((SELECT 'EXISTING DISTRIBUTIONS'

Line 1401: UPDATE zx_trx_headers_gt

1397:
1398: IF (l_count <> 0) THEN
1399: d_progress := 230;
1400: -- Update event_type_code on zx headers as required by determine_recovery API
1401: UPDATE zx_trx_headers_gt
1402: SET event_type_code = PO_CONSTANTS_SV.REQ_DISTRIBUTED;
1403:
1404: d_progress := 240;
1405:

Line 2295: -- ZX_TRX_HEADERS_GT

2291: --Name: populate_zx_headers_with_po
2292: --Pre-reqs:
2293: -- None
2294: --Modifies:
2295: -- ZX_TRX_HEADERS_GT
2296: --Locks:
2297: -- ZX_TRX_HEADERS_GT
2298: --Function:
2299: -- Populate ZX_TRX_HEADERS_GT with transaction header data

Line 2297: -- ZX_TRX_HEADERS_GT

2293: -- None
2294: --Modifies:
2295: -- ZX_TRX_HEADERS_GT
2296: --Locks:
2297: -- ZX_TRX_HEADERS_GT
2298: --Function:
2299: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2300: --Parameters:
2301: --IN:

Line 2299: -- Populate ZX_TRX_HEADERS_GT with transaction header data

2295: -- ZX_TRX_HEADERS_GT
2296: --Locks:
2297: -- ZX_TRX_HEADERS_GT
2298: --Function:
2299: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2300: --Parameters:
2301: --IN:
2302: --p_po_header_id_tbl
2303: -- PL/SQL table with list of po_header_id's to process for tax_calculation

Line 2315: -- Populate zx_trx_headers_gt for POs

2311: p_calling_program IN VARCHAR2
2312: ) IS
2313: BEGIN
2314:
2315: -- Populate zx_trx_headers_gt for POs
2316: FORALL i IN 1..p_po_header_id_tbl.COUNT
2317: INSERT INTO zx_trx_headers_gt(
2318: internal_organization_id
2319: ,application_id

Line 2317: INSERT INTO zx_trx_headers_gt(

2313: BEGIN
2314:
2315: -- Populate zx_trx_headers_gt for POs
2316: FORALL i IN 1..p_po_header_id_tbl.COUNT
2317: INSERT INTO zx_trx_headers_gt(
2318: internal_organization_id
2319: ,application_id
2320: ,entity_code
2321: ,event_class_code

Line 2415: -- ZX_TRX_HEADERS_GT

2411: --Name: populate_header_po
2412: --Pre-reqs:
2413: -- None
2414: --Modifies:
2415: -- ZX_TRX_HEADERS_GT
2416: --Locks:
2417: -- ZX_TRX_HEADERS_GT
2418: --Function:
2419: -- Populate ZX_TRX_HEADERS_GT with transaction header data

Line 2417: -- ZX_TRX_HEADERS_GT

2413: -- None
2414: --Modifies:
2415: -- ZX_TRX_HEADERS_GT
2416: --Locks:
2417: -- ZX_TRX_HEADERS_GT
2418: --Function:
2419: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2420: --Parameters:
2421: --IN:

Line 2419: -- Populate ZX_TRX_HEADERS_GT with transaction header data

2415: -- ZX_TRX_HEADERS_GT
2416: --Locks:
2417: -- ZX_TRX_HEADERS_GT
2418: --Function:
2419: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2420: --Parameters:
2421: --IN:
2422: --p_po_header_id
2423: -- po__header_id to process for tax distribution

Line 2431: -- Populate zx_trx_headers_gt for the PO

2427: -----------------------------------------------------------------------------
2428: PROCEDURE populate_header_po(p_po_header_id IN NUMBER) IS
2429: BEGIN
2430:
2431: -- Populate zx_trx_headers_gt for the PO
2432: INSERT INTO zx_trx_headers_gt(
2433: internal_organization_id
2434: ,application_id
2435: ,entity_code

Line 2432: INSERT INTO zx_trx_headers_gt(

2428: PROCEDURE populate_header_po(p_po_header_id IN NUMBER) IS
2429: BEGIN
2430:
2431: -- Populate zx_trx_headers_gt for the PO
2432: INSERT INTO zx_trx_headers_gt(
2433: internal_organization_id
2434: ,application_id
2435: ,entity_code
2436: ,event_class_code

Line 2513: -- ZX_TRX_HEADERS_GT

2509: --Name: populate_zx_headers_with_rel
2510: --Pre-reqs:
2511: -- None
2512: --Modifies:
2513: -- ZX_TRX_HEADERS_GT
2514: --Locks:
2515: -- ZX_TRX_HEADERS_GT
2516: --Function:
2517: -- Populate ZX_TRX_HEADERS_GT with transaction header data

Line 2515: -- ZX_TRX_HEADERS_GT

2511: -- None
2512: --Modifies:
2513: -- ZX_TRX_HEADERS_GT
2514: --Locks:
2515: -- ZX_TRX_HEADERS_GT
2516: --Function:
2517: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2518: --Parameters:
2519: --IN:

Line 2517: -- Populate ZX_TRX_HEADERS_GT with transaction header data

2513: -- ZX_TRX_HEADERS_GT
2514: --Locks:
2515: -- ZX_TRX_HEADERS_GT
2516: --Function:
2517: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2518: --Parameters:
2519: --IN:
2520: --p_po_release_id_tbl
2521: -- PL/SQL table with list of po_release_id's to process for tax_calculation

Line 2532: -- Populate zx_trx_headers_gt for Releases

2528: PROCEDURE populate_zx_headers_with_rel(p_po_release_id_tbl IN PO_TBL_NUMBER,
2529: p_calling_program IN VARCHAR2
2530: ) IS
2531: BEGIN
2532: -- Populate zx_trx_headers_gt for Releases
2533: FORALL i in 1..p_po_release_id_tbl.COUNT
2534: INSERT INTO zx_trx_headers_gt(
2535: internal_organization_id
2536: ,application_id

Line 2534: INSERT INTO zx_trx_headers_gt(

2530: ) IS
2531: BEGIN
2532: -- Populate zx_trx_headers_gt for Releases
2533: FORALL i in 1..p_po_release_id_tbl.COUNT
2534: INSERT INTO zx_trx_headers_gt(
2535: internal_organization_id
2536: ,application_id
2537: ,entity_code
2538: ,event_class_code

Line 2643: -- ZX_TRX_HEADERS_GT

2639: --Name: populate_header_rel
2640: --Pre-reqs:
2641: -- None
2642: --Modifies:
2643: -- ZX_TRX_HEADERS_GT
2644: --Locks:
2645: -- ZX_TRX_HEADERS_GT
2646: --Function:
2647: -- Populate ZX_TRX_HEADERS_GT with transaction header data

Line 2645: -- ZX_TRX_HEADERS_GT

2641: -- None
2642: --Modifies:
2643: -- ZX_TRX_HEADERS_GT
2644: --Locks:
2645: -- ZX_TRX_HEADERS_GT
2646: --Function:
2647: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2648: --Parameters:
2649: --IN:

Line 2647: -- Populate ZX_TRX_HEADERS_GT with transaction header data

2643: -- ZX_TRX_HEADERS_GT
2644: --Locks:
2645: -- ZX_TRX_HEADERS_GT
2646: --Function:
2647: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2648: --Parameters:
2649: --IN:
2650: --p_po_release_id
2651: -- po_release_id to process for tax distribution

Line 2659: -- Populate zx_trx_headers_gt for Releases

2655: -----------------------------------------------------------------------------
2656: PROCEDURE populate_header_rel(p_po_release_id IN NUMBER) IS
2657: BEGIN
2658:
2659: -- Populate zx_trx_headers_gt for Releases
2660: INSERT INTO zx_trx_headers_gt(
2661: internal_organization_id
2662: ,application_id
2663: ,entity_code

Line 2660: INSERT INTO zx_trx_headers_gt(

2656: PROCEDURE populate_header_rel(p_po_release_id IN NUMBER) IS
2657: BEGIN
2658:
2659: -- Populate zx_trx_headers_gt for Releases
2660: INSERT INTO zx_trx_headers_gt(
2661: internal_organization_id
2662: ,application_id
2663: ,entity_code
2664: ,event_class_code

Line 2742: -- ZX_TRX_HEADERS_GT

2738: --Name: populate_zx_headers_with_req
2739: --Pre-reqs:
2740: -- None
2741: --Modifies:
2742: -- ZX_TRX_HEADERS_GT
2743: --Locks:
2744: -- ZX_TRX_HEADERS_GT
2745: --Function:
2746: -- Populate ZX_TRX_HEADERS_GT with transaction header data

Line 2744: -- ZX_TRX_HEADERS_GT

2740: -- None
2741: --Modifies:
2742: -- ZX_TRX_HEADERS_GT
2743: --Locks:
2744: -- ZX_TRX_HEADERS_GT
2745: --Function:
2746: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2747: --Parameters:
2748: --IN:

Line 2746: -- Populate ZX_TRX_HEADERS_GT with transaction header data

2742: -- ZX_TRX_HEADERS_GT
2743: --Locks:
2744: -- ZX_TRX_HEADERS_GT
2745: --Function:
2746: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2747: --Parameters:
2748: --IN:
2749: --p_requisition_header_id
2750: -- PL/SQL table with list of po_header_id's to process for tax_calculation

Line 2761: -- populate zx_trx_headers_gt for the requisition

2757: PROCEDURE populate_zx_headers_with_req(p_requisition_header_id IN NUMBER,
2758: p_calling_program IN VARCHAR2
2759: ) IS
2760: BEGIN
2761: -- populate zx_trx_headers_gt for the requisition
2762: -- Addition/Removal of any attribute entails similar change in
2763: -- populate_zx_record as well
2764: INSERT INTO zx_trx_headers_gt(
2765: internal_organization_id

Line 2764: INSERT INTO zx_trx_headers_gt(

2760: BEGIN
2761: -- populate zx_trx_headers_gt for the requisition
2762: -- Addition/Removal of any attribute entails similar change in
2763: -- populate_zx_record as well
2764: INSERT INTO zx_trx_headers_gt(
2765: internal_organization_id
2766: ,application_id
2767: ,entity_code
2768: ,event_class_code

Line 3796: (SELECT trx_id FROM zx_trx_headers_gt

3792: --OR pd1.tax_attribute_update_code IS NOT NULL
3793: OR pll.tax_attribute_update_code IS NOT NULL
3794: )
3795: AND pd1.po_header_id IN
3796: (SELECT trx_id FROM zx_trx_headers_gt
3797: WHERE event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
3798:
3799: END populate_zx_dists_with_po;
3800:

Line 3984: (SELECT trx_id FROM zx_trx_headers_gt

3980: --OR pd1.tax_attribute_update_code IS NOT NULL
3981: OR pll.tax_attribute_update_code IS NOT NULL
3982: )
3983: AND pd1.po_release_id IN
3984: (SELECT trx_id FROM zx_trx_headers_gt
3985: WHERE event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE);
3986:
3987: END populate_zx_dists_with_rel;
3988:

Line 4477: FROM zx_trx_headers_gt zxhgt, zx_transaction_lines_gt zxlgt

4473: ,ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.product_description(l_count)
4474: -- Bug 5082762. Product Type dropped when line is updated
4475: ,ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.user_upd_det_factors_flag(l_count)
4476: ,ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DEFAULTING_ATTRIBUTE1(l_count) --Bug#6902111
4477: FROM zx_trx_headers_gt zxhgt, zx_transaction_lines_gt zxlgt
4478: WHERE zxlgt.trx_line_id = i.trx_line_id
4479: AND zxlgt.trx_id = zxhgt.trx_id;
4480:
4481: END LOOP;

Line 4730: -- ZX_TRX_HEADERS_GT

4726: --Name: initialize_zx_gt_tables
4727: --Pre-reqs:
4728: -- None
4729: --Modifies:
4730: -- ZX_TRX_HEADERS_GT
4731: -- ZX_TRANSACTION_LINES_GT
4732: -- ZX_ITM_DISTRIBUTIONS_GT
4733: -- ZX_VALIDATION_ERRORS_GT
4734: -- ZX_ERRORS_GT

Line 4736: -- ZX_TRX_HEADERS_GT

4732: -- ZX_ITM_DISTRIBUTIONS_GT
4733: -- ZX_VALIDATION_ERRORS_GT
4734: -- ZX_ERRORS_GT
4735: --Locks:
4736: -- ZX_TRX_HEADERS_GT
4737: -- ZX_TRANSACTION_LINES_GT
4738: -- ZX_ITM_DISTRIBUTIONS_GT
4739: -- ZX_VALIDATION_ERRORS_GT
4740: -- ZX_ERRORS_GT

Line 4810: -- ZX_TRX_HEADERS_GT

4806: --Name: wipe_zx_gt_tables
4807: --Pre-reqs:
4808: -- None
4809: --Modifies:
4810: -- ZX_TRX_HEADERS_GT
4811: -- ZX_TRANSACTION_LINES_GT
4812: -- ZX_ITM_DISTRIBUTIONS_GT
4813: -- ZX_VALIDATION_ERRORS_GT
4814: -- ZX_ERRORS_GT

Line 4816: -- ZX_TRX_HEADERS_GT

4812: -- ZX_ITM_DISTRIBUTIONS_GT
4813: -- ZX_VALIDATION_ERRORS_GT
4814: -- ZX_ERRORS_GT
4815: --Locks:
4816: -- ZX_TRX_HEADERS_GT
4817: -- ZX_TRANSACTION_LINES_GT
4818: -- ZX_ITM_DISTRIBUTIONS_GT
4819: -- ZX_VALIDATION_ERRORS_GT
4820: -- ZX_ERRORS_GT

Line 4843: DELETE ZX_TRX_HEADERS_GT;

4839: IF (PO_LOG.d_proc) THEN
4840: PO_LOG.proc_begin(d_module_base);
4841: END IF;
4842:
4843: DELETE ZX_TRX_HEADERS_GT;
4844: d_progress := 10;
4845: DELETE ZX_TRANSACTION_LINES_GT;
4846: d_progress := 20;
4847: DELETE ZX_ITM_DISTRIBUTIONS_GT;

Line 5289: TYPE zx_headers_type IS TABLE OF ZX_TRX_HEADERS_GT%ROWTYPE;

5285: PROCEDURE log_header_tax_attributes(p_module_base IN VARCHAR2,
5286: p_progress IN NUMBER) IS
5287: d_module_base CONSTANT VARCHAR2(100) := p_module_base;
5288: d_progress NUMBER := p_progress;
5289: TYPE zx_headers_type IS TABLE OF ZX_TRX_HEADERS_GT%ROWTYPE;
5290: l_zx_headers_tbl zx_headers_type;
5291: BEGIN
5292: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_trx_headers_gt:');
5293:

Line 5292: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_trx_headers_gt:');

5288: d_progress NUMBER := p_progress;
5289: TYPE zx_headers_type IS TABLE OF ZX_TRX_HEADERS_GT%ROWTYPE;
5290: l_zx_headers_tbl zx_headers_type;
5291: BEGIN
5292: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_trx_headers_gt:');
5293:
5294: SELECT *
5295: BULK COLLECT INTO l_zx_headers_tbl
5296: FROM zx_trx_headers_gt;

Line 5296: FROM zx_trx_headers_gt;

5292: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_trx_headers_gt:');
5293:
5294: SELECT *
5295: BULK COLLECT INTO l_zx_headers_tbl
5296: FROM zx_trx_headers_gt;
5297:
5298: FOR i IN 1..l_zx_headers_tbl.COUNT LOOP
5299: PO_LOG.stmt(d_module_base,d_progress,' row '||i||':');
5300: PO_LOG.stmt(d_module_base,d_progress,' internal_organization_id = '||l_zx_headers_tbl(i).internal_organization_id);

Line 5841: INSERT INTO zx_trx_headers_gt

5837: IF p_document_type = PO_CONSTANTS_SV.PO THEN
5838: d_progress := 10;
5839: IF p_shipment_id <> 0 THEN
5840: d_progress := 20;
5841: INSERT INTO zx_trx_headers_gt
5842: (
5843: internal_organization_id,
5844: application_id,
5845: entity_code,

Line 5922: INSERT INTO zx_trx_headers_gt

5918:
5919: ELSIF p_line_id <> 0 THEN
5920: -- Partial document cancel. Populate eTax GT tables and call calculate_tax
5921: d_progress := 70;
5922: INSERT INTO zx_trx_headers_gt
5923: (
5924: internal_organization_id,
5925: application_id,
5926: entity_code,

Line 6039: INSERT INTO zx_trx_headers_gt

6035: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6036: d_progress := 160;
6037: IF p_shipment_id <> 0 THEN
6038: d_progress := 170;
6039: INSERT INTO zx_trx_headers_gt
6040: (
6041: internal_organization_id,
6042: application_id,
6043: entity_code,