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 406: DELETE FROM zx_trx_headers_gt

402: END IF;
403:
404: d_progress := 160;
405: -- Delete data from zx gt tables for which defaulting/redefaulting failed
406: DELETE FROM zx_trx_headers_gt
407: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
408: WHERE psgt.key = l_po_session_gt_key
409: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
410: d_progress := 170;

Line 594: DELETE FROM zx_trx_headers_gt

590: END IF;
591:
592: d_progress := 250;
593: -- Delete data from zx gt tables for which defaulting/redefaulting failed
594: DELETE FROM zx_trx_headers_gt
595: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
596: WHERE psgt.key = l_po_session_gt_key
597: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
598: AND psgt.char3 = 'CALCULATE_TAX');

Line 600: DELETE FROM zx_trx_headers_gt

596: WHERE psgt.key = l_po_session_gt_key
597: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
598: AND psgt.char3 = 'CALCULATE_TAX');
599: d_progress := 260;
600: DELETE FROM zx_trx_headers_gt
601: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
602: WHERE psgt.key = l_po_session_gt_key
603: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
604: AND psgt.char3 = 'CALCULATE_TAX');

Line 646: UPDATE zx_trx_headers_gt zxhgt

642: d_progress := 320;
643: -- Update event_type_code on zx headers as required by determine_recovery API
644: -- Update to DISTRIBUTED only if all distributions have
645: -- tax_attribute_update_code = 'CREATE'
646: UPDATE zx_trx_headers_gt zxhgt
647: SET zxhgt.event_type_code =
648: DECODE(zxhgt.event_class_code,
649: PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE,
650: NVL2((SELECT 'EXISTING DISTRIBUTIONS'

Line 1570: UPDATE zx_trx_headers_gt

1566:
1567: IF (l_count <> 0) THEN
1568: d_progress := 230;
1569: -- Update event_type_code on zx headers as required by determine_recovery API
1570: UPDATE zx_trx_headers_gt
1571: SET event_type_code = PO_CONSTANTS_SV.REQ_DISTRIBUTED;
1572:
1573: d_progress := 240;
1574:

Line 2480: -- ZX_TRX_HEADERS_GT

2476: --Name: populate_zx_headers_with_po
2477: --Pre-reqs:
2478: -- None
2479: --Modifies:
2480: -- ZX_TRX_HEADERS_GT
2481: --Locks:
2482: -- ZX_TRX_HEADERS_GT
2483: --Function:
2484: -- Populate ZX_TRX_HEADERS_GT with transaction header data

Line 2482: -- ZX_TRX_HEADERS_GT

2478: -- None
2479: --Modifies:
2480: -- ZX_TRX_HEADERS_GT
2481: --Locks:
2482: -- ZX_TRX_HEADERS_GT
2483: --Function:
2484: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2485: --Parameters:
2486: --IN:

Line 2484: -- Populate ZX_TRX_HEADERS_GT with transaction header data

2480: -- ZX_TRX_HEADERS_GT
2481: --Locks:
2482: -- ZX_TRX_HEADERS_GT
2483: --Function:
2484: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2485: --Parameters:
2486: --IN:
2487: --p_po_header_id_tbl
2488: -- PL/SQL table with list of po_header_id's to process for tax_calculation

Line 2500: -- Populate zx_trx_headers_gt for POs

2496: p_calling_program IN VARCHAR2
2497: ) IS
2498: BEGIN
2499:
2500: -- Populate zx_trx_headers_gt for POs
2501: FORALL i IN 1..p_po_header_id_tbl.COUNT
2502: INSERT INTO zx_trx_headers_gt(
2503: internal_organization_id
2504: ,application_id

Line 2502: INSERT INTO zx_trx_headers_gt(

2498: BEGIN
2499:
2500: -- Populate zx_trx_headers_gt for POs
2501: FORALL i IN 1..p_po_header_id_tbl.COUNT
2502: INSERT INTO zx_trx_headers_gt(
2503: internal_organization_id
2504: ,application_id
2505: ,entity_code
2506: ,event_class_code

Line 2600: -- ZX_TRX_HEADERS_GT

2596: --Name: populate_header_po
2597: --Pre-reqs:
2598: -- None
2599: --Modifies:
2600: -- ZX_TRX_HEADERS_GT
2601: --Locks:
2602: -- ZX_TRX_HEADERS_GT
2603: --Function:
2604: -- Populate ZX_TRX_HEADERS_GT with transaction header data

Line 2602: -- ZX_TRX_HEADERS_GT

2598: -- None
2599: --Modifies:
2600: -- ZX_TRX_HEADERS_GT
2601: --Locks:
2602: -- ZX_TRX_HEADERS_GT
2603: --Function:
2604: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2605: --Parameters:
2606: --IN:

Line 2604: -- Populate ZX_TRX_HEADERS_GT with transaction header data

2600: -- ZX_TRX_HEADERS_GT
2601: --Locks:
2602: -- ZX_TRX_HEADERS_GT
2603: --Function:
2604: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2605: --Parameters:
2606: --IN:
2607: --p_po_header_id
2608: -- po__header_id to process for tax distribution

Line 2616: -- Populate zx_trx_headers_gt for the PO

2612: -----------------------------------------------------------------------------
2613: PROCEDURE populate_header_po(p_po_header_id IN NUMBER) IS
2614: BEGIN
2615:
2616: -- Populate zx_trx_headers_gt for the PO
2617: INSERT INTO zx_trx_headers_gt(
2618: internal_organization_id
2619: ,application_id
2620: ,entity_code

Line 2617: INSERT INTO zx_trx_headers_gt(

2613: PROCEDURE populate_header_po(p_po_header_id IN NUMBER) IS
2614: BEGIN
2615:
2616: -- Populate zx_trx_headers_gt for the PO
2617: INSERT INTO zx_trx_headers_gt(
2618: internal_organization_id
2619: ,application_id
2620: ,entity_code
2621: ,event_class_code

Line 2698: -- ZX_TRX_HEADERS_GT

2694: --Name: populate_zx_headers_with_rel
2695: --Pre-reqs:
2696: -- None
2697: --Modifies:
2698: -- ZX_TRX_HEADERS_GT
2699: --Locks:
2700: -- ZX_TRX_HEADERS_GT
2701: --Function:
2702: -- Populate ZX_TRX_HEADERS_GT with transaction header data

Line 2700: -- ZX_TRX_HEADERS_GT

2696: -- None
2697: --Modifies:
2698: -- ZX_TRX_HEADERS_GT
2699: --Locks:
2700: -- ZX_TRX_HEADERS_GT
2701: --Function:
2702: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2703: --Parameters:
2704: --IN:

Line 2702: -- Populate ZX_TRX_HEADERS_GT with transaction header data

2698: -- ZX_TRX_HEADERS_GT
2699: --Locks:
2700: -- ZX_TRX_HEADERS_GT
2701: --Function:
2702: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2703: --Parameters:
2704: --IN:
2705: --p_po_release_id_tbl
2706: -- PL/SQL table with list of po_release_id's to process for tax_calculation

Line 2717: -- Populate zx_trx_headers_gt for Releases

2713: PROCEDURE populate_zx_headers_with_rel(p_po_release_id_tbl IN PO_TBL_NUMBER,
2714: p_calling_program IN VARCHAR2
2715: ) IS
2716: BEGIN
2717: -- Populate zx_trx_headers_gt for Releases
2718: FORALL i in 1..p_po_release_id_tbl.COUNT
2719: INSERT INTO zx_trx_headers_gt(
2720: internal_organization_id
2721: ,application_id

Line 2719: INSERT INTO zx_trx_headers_gt(

2715: ) IS
2716: BEGIN
2717: -- Populate zx_trx_headers_gt for Releases
2718: FORALL i in 1..p_po_release_id_tbl.COUNT
2719: INSERT INTO zx_trx_headers_gt(
2720: internal_organization_id
2721: ,application_id
2722: ,entity_code
2723: ,event_class_code

Line 2828: -- ZX_TRX_HEADERS_GT

2824: --Name: populate_header_rel
2825: --Pre-reqs:
2826: -- None
2827: --Modifies:
2828: -- ZX_TRX_HEADERS_GT
2829: --Locks:
2830: -- ZX_TRX_HEADERS_GT
2831: --Function:
2832: -- Populate ZX_TRX_HEADERS_GT with transaction header data

Line 2830: -- ZX_TRX_HEADERS_GT

2826: -- None
2827: --Modifies:
2828: -- ZX_TRX_HEADERS_GT
2829: --Locks:
2830: -- ZX_TRX_HEADERS_GT
2831: --Function:
2832: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2833: --Parameters:
2834: --IN:

Line 2832: -- Populate ZX_TRX_HEADERS_GT with transaction header data

2828: -- ZX_TRX_HEADERS_GT
2829: --Locks:
2830: -- ZX_TRX_HEADERS_GT
2831: --Function:
2832: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2833: --Parameters:
2834: --IN:
2835: --p_po_release_id
2836: -- po_release_id to process for tax distribution

Line 2844: -- Populate zx_trx_headers_gt for Releases

2840: -----------------------------------------------------------------------------
2841: PROCEDURE populate_header_rel(p_po_release_id IN NUMBER) IS
2842: BEGIN
2843:
2844: -- Populate zx_trx_headers_gt for Releases
2845: INSERT INTO zx_trx_headers_gt(
2846: internal_organization_id
2847: ,application_id
2848: ,entity_code

Line 2845: INSERT INTO zx_trx_headers_gt(

2841: PROCEDURE populate_header_rel(p_po_release_id IN NUMBER) IS
2842: BEGIN
2843:
2844: -- Populate zx_trx_headers_gt for Releases
2845: INSERT INTO zx_trx_headers_gt(
2846: internal_organization_id
2847: ,application_id
2848: ,entity_code
2849: ,event_class_code

Line 2927: -- ZX_TRX_HEADERS_GT

2923: --Name: populate_zx_headers_with_req
2924: --Pre-reqs:
2925: -- None
2926: --Modifies:
2927: -- ZX_TRX_HEADERS_GT
2928: --Locks:
2929: -- ZX_TRX_HEADERS_GT
2930: --Function:
2931: -- Populate ZX_TRX_HEADERS_GT with transaction header data

Line 2929: -- ZX_TRX_HEADERS_GT

2925: -- None
2926: --Modifies:
2927: -- ZX_TRX_HEADERS_GT
2928: --Locks:
2929: -- ZX_TRX_HEADERS_GT
2930: --Function:
2931: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2932: --Parameters:
2933: --IN:

Line 2931: -- Populate ZX_TRX_HEADERS_GT with transaction header data

2927: -- ZX_TRX_HEADERS_GT
2928: --Locks:
2929: -- ZX_TRX_HEADERS_GT
2930: --Function:
2931: -- Populate ZX_TRX_HEADERS_GT with transaction header data
2932: --Parameters:
2933: --IN:
2934: --p_requisition_header_id
2935: -- PL/SQL table with list of po_header_id's to process for tax_calculation

Line 2946: -- populate zx_trx_headers_gt for the requisition

2942: PROCEDURE populate_zx_headers_with_req(p_requisition_header_id IN NUMBER,
2943: p_calling_program IN VARCHAR2
2944: ) IS
2945: BEGIN
2946: -- populate zx_trx_headers_gt for the requisition
2947: -- Addition/Removal of any attribute entails similar change in
2948: -- populate_zx_record as well
2949: INSERT INTO zx_trx_headers_gt(
2950: internal_organization_id

Line 2949: INSERT INTO zx_trx_headers_gt(

2945: BEGIN
2946: -- populate zx_trx_headers_gt for the requisition
2947: -- Addition/Removal of any attribute entails similar change in
2948: -- populate_zx_record as well
2949: INSERT INTO zx_trx_headers_gt(
2950: internal_organization_id
2951: ,application_id
2952: ,entity_code
2953: ,event_class_code

Line 4680: (SELECT trx_id FROM zx_trx_headers_gt

4676: --OR pd1.tax_attribute_update_code IS NOT NULL
4677: OR pll.tax_attribute_update_code IS NOT NULL
4678: )
4679: AND pd1.po_header_id IN
4680: (SELECT trx_id FROM zx_trx_headers_gt
4681: WHERE event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
4682:
4683: END populate_zx_dists_with_po;
4684:

Line 4877: (SELECT trx_id FROM zx_trx_headers_gt

4873: --OR pd1.tax_attribute_update_code IS NOT NULL
4874: OR pll.tax_attribute_update_code IS NOT NULL
4875: )
4876: AND pd1.po_release_id IN
4877: (SELECT trx_id FROM zx_trx_headers_gt
4878: WHERE event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE);
4879:
4880: END populate_zx_dists_with_rel;
4881:

Line 5372: FROM zx_trx_headers_gt zxhgt, zx_transaction_lines_gt zxlgt

5368: ,ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.product_description(l_count)
5369: -- Bug 5082762. Product Type dropped when line is updated
5370: ,ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.user_upd_det_factors_flag(l_count)
5371: ,ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.DEFAULTING_ATTRIBUTE1(l_count) --Bug#6902111
5372: FROM zx_trx_headers_gt zxhgt, zx_transaction_lines_gt zxlgt
5373: WHERE zxlgt.trx_line_id = i.trx_line_id
5374: AND zxlgt.trx_id = zxhgt.trx_id;
5375:
5376: END LOOP;

Line 5625: -- ZX_TRX_HEADERS_GT

5621: --Name: initialize_zx_gt_tables
5622: --Pre-reqs:
5623: -- None
5624: --Modifies:
5625: -- ZX_TRX_HEADERS_GT
5626: -- ZX_TRANSACTION_LINES_GT
5627: -- ZX_ITM_DISTRIBUTIONS_GT
5628: -- ZX_VALIDATION_ERRORS_GT
5629: -- ZX_ERRORS_GT

Line 5631: -- ZX_TRX_HEADERS_GT

5627: -- ZX_ITM_DISTRIBUTIONS_GT
5628: -- ZX_VALIDATION_ERRORS_GT
5629: -- ZX_ERRORS_GT
5630: --Locks:
5631: -- ZX_TRX_HEADERS_GT
5632: -- ZX_TRANSACTION_LINES_GT
5633: -- ZX_ITM_DISTRIBUTIONS_GT
5634: -- ZX_VALIDATION_ERRORS_GT
5635: -- ZX_ERRORS_GT

Line 5705: -- ZX_TRX_HEADERS_GT

5701: --Name: wipe_zx_gt_tables
5702: --Pre-reqs:
5703: -- None
5704: --Modifies:
5705: -- ZX_TRX_HEADERS_GT
5706: -- ZX_TRANSACTION_LINES_GT
5707: -- ZX_ITM_DISTRIBUTIONS_GT
5708: -- ZX_VALIDATION_ERRORS_GT
5709: -- ZX_ERRORS_GT

Line 5711: -- ZX_TRX_HEADERS_GT

5707: -- ZX_ITM_DISTRIBUTIONS_GT
5708: -- ZX_VALIDATION_ERRORS_GT
5709: -- ZX_ERRORS_GT
5710: --Locks:
5711: -- ZX_TRX_HEADERS_GT
5712: -- ZX_TRANSACTION_LINES_GT
5713: -- ZX_ITM_DISTRIBUTIONS_GT
5714: -- ZX_VALIDATION_ERRORS_GT
5715: -- ZX_ERRORS_GT

Line 5738: DELETE ZX_TRX_HEADERS_GT;

5734: IF (PO_LOG.d_proc) THEN
5735: PO_LOG.proc_begin(d_module_base);
5736: END IF;
5737:
5738: DELETE ZX_TRX_HEADERS_GT;
5739: d_progress := 10;
5740: DELETE ZX_TRANSACTION_LINES_GT;
5741: d_progress := 20;
5742: DELETE ZX_ITM_DISTRIBUTIONS_GT;

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

6180: PROCEDURE log_header_tax_attributes(p_module_base IN VARCHAR2,
6181: p_progress IN NUMBER) IS
6182: d_module_base CONSTANT VARCHAR2(100) := p_module_base;
6183: d_progress NUMBER := p_progress;
6184: TYPE zx_headers_type IS TABLE OF ZX_TRX_HEADERS_GT%ROWTYPE;
6185: l_zx_headers_tbl zx_headers_type;
6186: BEGIN
6187: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_trx_headers_gt:');
6188:

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

6183: d_progress NUMBER := p_progress;
6184: TYPE zx_headers_type IS TABLE OF ZX_TRX_HEADERS_GT%ROWTYPE;
6185: l_zx_headers_tbl zx_headers_type;
6186: BEGIN
6187: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_trx_headers_gt:');
6188:
6189: SELECT *
6190: BULK COLLECT INTO l_zx_headers_tbl
6191: FROM zx_trx_headers_gt;

Line 6191: FROM zx_trx_headers_gt;

6187: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_trx_headers_gt:');
6188:
6189: SELECT *
6190: BULK COLLECT INTO l_zx_headers_tbl
6191: FROM zx_trx_headers_gt;
6192:
6193: FOR i IN 1..l_zx_headers_tbl.COUNT LOOP
6194: PO_LOG.stmt(d_module_base,d_progress,' row '||i||':');
6195: PO_LOG.stmt(d_module_base,d_progress,' internal_organization_id = '||l_zx_headers_tbl(i).internal_organization_id);

Line 6749: INSERT INTO zx_trx_headers_gt

6745: initialize_zx_gt_tables(); -- Wipe ZX GT tables clean
6746: initialize_global_error_record();
6747: /* bug 13896725 */
6748:
6749: INSERT INTO zx_trx_headers_gt
6750: (
6751: internal_organization_id,
6752: application_id,
6753: entity_code,

Line 6830: INSERT INTO zx_trx_headers_gt

6826:
6827: ELSIF p_line_id <> 0 THEN
6828: -- Partial document cancel. Populate eTax GT tables and call calculate_tax
6829: d_progress := 70;
6830: INSERT INTO zx_trx_headers_gt
6831: (
6832: internal_organization_id,
6833: application_id,
6834: entity_code,

Line 6947: INSERT INTO zx_trx_headers_gt

6943: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6944: d_progress := 160;
6945: IF p_shipment_id <> 0 THEN
6946: d_progress := 170;
6947: INSERT INTO zx_trx_headers_gt
6948: (
6949: internal_organization_id,
6950: application_id,
6951: entity_code,