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_TRANSACTION_LINES_GT

Line 76: FROM zx_transaction_lines_gt zxlgt

72: p_progress IN NUMBER);
73:
74: CURSOR successful_documents_csr(p_requisition_header_id IN NUMBER) IS
75: SELECT zxlgt.trx_line_id
76: FROM zx_transaction_lines_gt zxlgt
77: WHERE p_requisition_header_id=zxlgt.trx_id
78: AND p_requisition_header_id NOT IN (SELECT trx_id FROM zx_errors_gt zxegt)
79: AND zxlgt.application_id = PO_CONSTANTS_SV.APPLICATION_ID
80: AND zxlgt.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

Line 254: SELECT COUNT(1) INTO l_count FROM zx_transaction_lines_gt;

250: -- Call eTax API calculate_tax to construct tax lines
251: -- For lines wih line_level_action of COPY_AND_CREATE eTax will use
252: -- Additional Tax Attributes from source doucment to create the tax lines
253: BEGIN
254: SELECT COUNT(1) INTO l_count FROM zx_transaction_lines_gt;
255: EXCEPTION WHEN OTHERS THEN
256: l_count := 0;
257: IF PO_LOG.d_stmt THEN
258: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_transaction_lines_gt');

Line 258: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_transaction_lines_gt');

254: SELECT COUNT(1) INTO l_count FROM zx_transaction_lines_gt;
255: EXCEPTION WHEN OTHERS THEN
256: l_count := 0;
257: IF PO_LOG.d_stmt THEN
258: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_transaction_lines_gt');
259: END IF;
260: END;
261:
262: IF PO_LOG.d_stmt THEN

Line 263: PO_LOG.stmt(d_module_base,d_progress,'Number of rows in zx_transaction_lines_gt='||l_count);

259: END IF;
260: END;
261:
262: IF PO_LOG.d_stmt THEN
263: PO_LOG.stmt(d_module_base,d_progress,'Number of rows in zx_transaction_lines_gt='||l_count);
264: END IF;
265:
266: IF (l_count <> 0) THEN
267:

Line 382: DELETE FROM zx_transaction_lines_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;
382: DELETE FROM zx_transaction_lines_gt
383: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
384: WHERE psgt.key = l_po_session_gt_key
385: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
386:

Line 420: UPDATE zx_transaction_lines_gt zxlgt

416:
417: d_progress := 200;
418: -- Override product_type Additional Tax Attribute if not already populated
419: -- by eTax defaulting/redefaulting API
420: UPDATE zx_transaction_lines_gt zxlgt
421: SET zxlgt.product_type =
422: (SELECT DECODE(pl.purchase_basis,
423: 'GOODS', 'GOODS',
424: 'SERVICES')

Line 541: DELETE FROM zx_transaction_lines_gt

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');
540: d_progress := 270;
541: DELETE FROM zx_transaction_lines_gt
542: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
543: WHERE psgt.key = l_po_session_gt_key
544: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
545: AND psgt.char3 = 'CALCULATE_TAX');

Line 547: DELETE FROM zx_transaction_lines_gt

543: WHERE psgt.key = l_po_session_gt_key
544: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
545: AND psgt.char3 = 'CALCULATE_TAX');
546: d_progress := 280;
547: DELETE FROM zx_transaction_lines_gt
548: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
549: WHERE psgt.key = l_po_session_gt_key
550: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
551: AND psgt.char3 = 'CALCULATE_TAX');

Line 809: FROM zx_transaction_lines_gt zxlgt

805: -- Bug 4774900 null out if even a single shipment has been processed
806: -- correctly. That would mean that the header has been recorded
807: -- in eTax, and next time we need to pass UPDATE
808: AND EXISTS (SELECT 'Y'
809: FROM zx_transaction_lines_gt zxlgt
810: WHERE zxlgt.trx_id=ph.po_header_id);
811:
812: d_progress := 470;
813: FORALL i IN 1..p_po_release_id_tbl.COUNT

Line 818: FROM zx_transaction_lines_gt zxlgt

814: UPDATE po_releases_all pr
815: SET pr.tax_attribute_update_code = null
816: WHERE pr.po_release_id = p_po_release_id_tbl(i)
817: AND EXISTS (SELECT 'Y'
818: FROM zx_transaction_lines_gt zxlgt
819: WHERE zxlgt.trx_id=pr.po_release_id);
820:
821: d_progress := 480;
822: FORALL i IN 1..p_po_header_id_tbl.COUNT

Line 835: WHERE line_location_id IN (SELECT trx_line_id FROM zx_transaction_lines_gt);

831:
832: UPDATE po_line_locations_all
833: SET tax_attribute_update_code = null,
834: original_shipment_id = null
835: WHERE line_location_id IN (SELECT trx_line_id FROM zx_transaction_lines_gt);
836:
837: UPDATE po_line_locations_all
838: SET tax_attribute_update_code = null,
839: original_shipment_id = null

Line 875: pll.line_location_id IN (SELECT trx_line_id FROM zx_transaction_lines_gt);

871: 0, 'N',
872: 'Y'
873: )
874: WHERE
875: pll.line_location_id IN (SELECT trx_line_id FROM zx_transaction_lines_gt);
876:
877:
878: d_progress := 520;
879: -- Pour all errors in po_session_gt into global tax error record

Line 1174: SELECT COUNT(1) INTO l_line_count FROM zx_transaction_lines_gt;

1170:
1171: d_progress := 50;
1172: -- Check if zx lines gt table is empty
1173: BEGIN
1174: SELECT COUNT(1) INTO l_line_count FROM zx_transaction_lines_gt;
1175: EXCEPTION WHEN OTHERS THEN
1176: l_line_count := 0;
1177: IF PO_LOG.d_stmt THEN
1178: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_transaction_lines_gt');

Line 1178: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_transaction_lines_gt');

1174: SELECT COUNT(1) INTO l_line_count FROM zx_transaction_lines_gt;
1175: EXCEPTION WHEN OTHERS THEN
1176: l_line_count := 0;
1177: IF PO_LOG.d_stmt THEN
1178: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_transaction_lines_gt');
1179: END IF;
1180: END;
1181:
1182: d_progress := 60;

Line 1184: PO_LOG.stmt(d_module_base,d_progress,'Number of rows in zx_transaction_lines_gt='||l_line_count);

1180: END;
1181:
1182: d_progress := 60;
1183: IF PO_LOG.d_stmt THEN
1184: PO_LOG.stmt(d_module_base,d_progress,'Number of rows in zx_transaction_lines_gt='||l_line_count);
1185: END IF;
1186:
1187: IF (l_line_count <> 0) THEN
1188: d_progress := 70;

Line 1293: UPDATE zx_transaction_lines_gt zxlgt

1289:
1290: d_progress := 150;
1291: -- Override product_type Additional Tax Attribute if not already populated
1292: -- by eTax defaulting/redefaulting API
1293: UPDATE zx_transaction_lines_gt zxlgt
1294: SET zxlgt.product_type =
1295: (SELECT DECODE(prl.purchase_basis,
1296: 'GOODS', 'GOODS',
1297: 'SERVICES')

Line 2824: -- ZX_TRANSACTION_LINES_GT

2820: --Name: populate_zx_lines_with_po
2821: --Pre-reqs:
2822: -- None
2823: --Modifies:
2824: -- ZX_TRANSACTION_LINES_GT
2825: --Locks:
2826: -- ZX_TRANSACTION_LINES_GT
2827: --Function:
2828: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data

Line 2826: -- ZX_TRANSACTION_LINES_GT

2822: -- None
2823: --Modifies:
2824: -- ZX_TRANSACTION_LINES_GT
2825: --Locks:
2826: -- ZX_TRANSACTION_LINES_GT
2827: --Function:
2828: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
2829: --Parameters:
2830: --IN:

Line 2828: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data

2824: -- ZX_TRANSACTION_LINES_GT
2825: --Locks:
2826: -- ZX_TRANSACTION_LINES_GT
2827: --Function:
2828: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
2829: --Parameters:
2830: --IN:
2831: --p_po_header_id_tbl
2832: -- PL/SQL table with list of po_header_id's to process for tax_calculation

Line 2844: -- Populate zx_transaction_lines_gt for POs

2840: p_calling_program IN VARCHAR2
2841: ) IS
2842: BEGIN
2843:
2844: -- Populate zx_transaction_lines_gt for POs
2845: FORALL i in 1..p_po_header_id_tbl.COUNT
2846: INSERT INTO zx_transaction_lines_gt(
2847: application_id
2848: ,entity_code

Line 2846: INSERT INTO zx_transaction_lines_gt(

2842: BEGIN
2843:
2844: -- Populate zx_transaction_lines_gt for POs
2845: FORALL i in 1..p_po_header_id_tbl.COUNT
2846: INSERT INTO zx_transaction_lines_gt(
2847: application_id
2848: ,entity_code
2849: ,event_class_code
2850: ,trx_id

Line 3142: -- ZX_TRANSACTION_LINES_GT

3138: --Name: populate_zx_lines_with_rel
3139: --Pre-reqs:
3140: -- None
3141: --Modifies:
3142: -- ZX_TRANSACTION_LINES_GT
3143: --Locks:
3144: -- ZX_TRANSACTION_LINES_GT
3145: --Function:
3146: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data

Line 3144: -- ZX_TRANSACTION_LINES_GT

3140: -- None
3141: --Modifies:
3142: -- ZX_TRANSACTION_LINES_GT
3143: --Locks:
3144: -- ZX_TRANSACTION_LINES_GT
3145: --Function:
3146: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
3147: --Parameters:
3148: --IN:

Line 3146: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data

3142: -- ZX_TRANSACTION_LINES_GT
3143: --Locks:
3144: -- ZX_TRANSACTION_LINES_GT
3145: --Function:
3146: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
3147: --Parameters:
3148: --IN:
3149: --p_po_release_id_tbl
3150: -- PL/SQL table with list of po_release_id's to process for tax_calculation

Line 3161: -- Populate zx_transaction_lines_gt for Releases

3157: PROCEDURE populate_zx_lines_with_rel(p_po_release_id_tbl IN PO_TBL_NUMBER,
3158: p_calling_program IN VARCHAR2
3159: ) IS
3160: BEGIN
3161: -- Populate zx_transaction_lines_gt for Releases
3162: FORALL i IN 1..p_po_release_id_tbl.COUNT
3163: INSERT INTO zx_transaction_lines_gt(
3164: application_id
3165: ,entity_code

Line 3163: INSERT INTO zx_transaction_lines_gt(

3159: ) IS
3160: BEGIN
3161: -- Populate zx_transaction_lines_gt for Releases
3162: FORALL i IN 1..p_po_release_id_tbl.COUNT
3163: INSERT INTO zx_transaction_lines_gt(
3164: application_id
3165: ,entity_code
3166: ,event_class_code
3167: ,trx_id

Line 3448: -- ZX_TRANSACTION_LINES_GT

3444: --Name: populate_zx_lines_with_req
3445: --Pre-reqs:
3446: -- None
3447: --Modifies:
3448: -- ZX_TRANSACTION_LINES_GT
3449: --Locks:
3450: -- ZX_TRANSACTION_LINES_GT
3451: --Function:
3452: -- Populate ZX_TRANSACTION_LINES_GT with transaction line data

Line 3450: -- ZX_TRANSACTION_LINES_GT

3446: -- None
3447: --Modifies:
3448: -- ZX_TRANSACTION_LINES_GT
3449: --Locks:
3450: -- ZX_TRANSACTION_LINES_GT
3451: --Function:
3452: -- Populate ZX_TRANSACTION_LINES_GT with transaction line data
3453: --Parameters:
3454: --IN:

Line 3452: -- Populate ZX_TRANSACTION_LINES_GT with transaction line data

3448: -- ZX_TRANSACTION_LINES_GT
3449: --Locks:
3450: -- ZX_TRANSACTION_LINES_GT
3451: --Function:
3452: -- Populate ZX_TRANSACTION_LINES_GT with transaction line data
3453: --Parameters:
3454: --IN:
3455: --p_requisition_header_id
3456: -- requisition_header_id of the requisition to process for tax_calculation

Line 3492: -- Populate zx_transaction_lines_gt for Requisitions

3488: x_conversion_date => sysdate,
3489: x_conversion_type => l_rate_type);
3490: --
3491:
3492: -- Populate zx_transaction_lines_gt for Requisitions
3493: -- Addition/Removal of any attribute entails similar change in
3494: -- populate_zx_record as well
3495: INSERT INTO zx_transaction_lines_gt(
3496: application_id

Line 3495: INSERT INTO zx_transaction_lines_gt(

3491:
3492: -- Populate zx_transaction_lines_gt for Requisitions
3493: -- Addition/Removal of any attribute entails similar change in
3494: -- populate_zx_record as well
3495: INSERT INTO zx_transaction_lines_gt(
3496: application_id
3497: ,entity_code
3498: ,event_class_code
3499: ,trx_id

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 4554: INSERT INTO zx_transaction_lines_gt

4550: -- there are no corresponding tax lines to delete
4551: --
4552:
4553: FORALL i IN 1..p_del_shipment_table.COUNT
4554: INSERT INTO zx_transaction_lines_gt
4555: (
4556: application_id,
4557: entity_code,
4558: event_class_code,

Line 4731: -- ZX_TRANSACTION_LINES_GT

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
4735: --Locks:

Line 4737: -- ZX_TRANSACTION_LINES_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
4741: --Function:

Line 4775: FROM zx_transaction_lines_gt zxlgt

4771: INTO l_clear_tables
4772: FROM dual
4773: WHERE EXISTS
4774: (SELECT 'CLEAR'
4775: FROM zx_transaction_lines_gt zxlgt
4776: WHERE zxlgt.line_level_action <> 'DELETE');
4777: EXCEPTION
4778: WHEN NO_DATA_FOUND THEN
4779: l_clear_tables := 'N';

Line 4811: -- ZX_TRANSACTION_LINES_GT

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
4815: --Locks:

Line 4817: -- ZX_TRANSACTION_LINES_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
4821: --Function:

Line 4845: DELETE ZX_TRANSACTION_LINES_GT;

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;
4848: d_progress := 30;
4849: DELETE ZX_VALIDATION_ERRORS_GT;

Line 5360: TYPE zx_lines_type IS TABLE OF ZX_TRANSACTION_LINES_GT%ROWTYPE;

5356: PROCEDURE log_line_tax_attributes(p_module_base IN VARCHAR2,
5357: p_progress IN NUMBER) IS
5358: d_module_base CONSTANT VARCHAR2(100) := p_module_base;
5359: d_progress NUMBER := p_progress;
5360: TYPE zx_lines_type IS TABLE OF ZX_TRANSACTION_LINES_GT%ROWTYPE;
5361: l_zx_lines_tbl zx_lines_type;
5362: BEGIN
5363: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_transaction_lines_gt:');
5364:

Line 5363: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_transaction_lines_gt:');

5359: d_progress NUMBER := p_progress;
5360: TYPE zx_lines_type IS TABLE OF ZX_TRANSACTION_LINES_GT%ROWTYPE;
5361: l_zx_lines_tbl zx_lines_type;
5362: BEGIN
5363: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_transaction_lines_gt:');
5364:
5365: SELECT *
5366: BULK COLLECT INTO l_zx_lines_tbl
5367: FROM zx_transaction_lines_gt;

Line 5367: FROM zx_transaction_lines_gt;

5363: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_transaction_lines_gt:');
5364:
5365: SELECT *
5366: BULK COLLECT INTO l_zx_lines_tbl
5367: FROM zx_transaction_lines_gt;
5368:
5369: FOR i IN 1..l_zx_lines_tbl.COUNT LOOP
5370: PO_LOG.stmt(d_module_base,d_progress,' row '||i||':');
5371: PO_LOG.stmt(d_module_base,d_progress,' application_id = '||l_zx_lines_tbl(i).application_id);

Line 5868: INSERT INTO zx_transaction_lines_gt

5864: FROM po_headers_all ph
5865: WHERE ph.po_header_id = p_document_id;
5866:
5867: d_progress := 30;
5868: INSERT INTO zx_transaction_lines_gt
5869: (
5870: application_id,
5871: entity_code,
5872: event_class_code,

Line 5949: INSERT INTO zx_transaction_lines_gt

5945: FROM po_headers_all ph
5946: WHERE ph.po_header_id = p_document_id;
5947:
5948: d_progress := 80;
5949: INSERT INTO zx_transaction_lines_gt
5950: (
5951: application_id,
5952: entity_code,
5953: event_class_code,

Line 6067: INSERT INTO zx_transaction_lines_gt

6063: WHERE pr.po_release_id = p_document_id
6064: AND pr.po_header_id = ph.po_header_id;
6065:
6066: d_progress := 180;
6067: INSERT INTO zx_transaction_lines_gt
6068: (
6069: application_id,
6070: entity_code,
6071: event_class_code,