[Home] [Help]
80: p_progress IN NUMBER);
81:
82: CURSOR successful_documents_csr(p_requisition_header_id IN NUMBER) IS
83: SELECT zxlgt.trx_line_id
84: FROM zx_transaction_lines_gt zxlgt
85: WHERE p_requisition_header_id=zxlgt.trx_id
86: AND p_requisition_header_id NOT IN (SELECT trx_id FROM zx_errors_gt zxegt)
87: AND zxlgt.application_id = PO_CONSTANTS_SV.APPLICATION_ID
88: AND zxlgt.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
204: -- whichever is non-null in that order
205: -- 4.
206: /* Bug 13925912: When tax determining attribute is changed only at distribution level corresponding
207: shipment's tax_attribute_update_code is not updated and thus no records are inserted into
208: zx_transaction_lines_gt and no call is being made to ZX calculate_tax API. Updating shipments
209: tax_attribute_update_code accordingly to overcome above issue */
210:
211: FORALL i IN 1..p_po_header_id_tbl.COUNT
212: UPDATE po_line_locations_all pll
276: -- Call eTax API calculate_tax to construct tax lines
277: -- For lines wih line_level_action of COPY_AND_CREATE eTax will use
278: -- Additional Tax Attributes from source doucment to create the tax lines
279: BEGIN
280: SELECT COUNT(1) INTO l_count FROM zx_transaction_lines_gt;
281: EXCEPTION WHEN OTHERS THEN
282: l_count := 0;
283: IF PO_LOG.d_stmt THEN
284: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_transaction_lines_gt');
280: SELECT COUNT(1) INTO l_count FROM zx_transaction_lines_gt;
281: EXCEPTION WHEN OTHERS THEN
282: l_count := 0;
283: IF PO_LOG.d_stmt THEN
284: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_transaction_lines_gt');
285: END IF;
286: END;
287:
288: IF PO_LOG.d_stmt THEN
285: END IF;
286: END;
287:
288: IF PO_LOG.d_stmt THEN
289: PO_LOG.stmt(d_module_base,d_progress,'Number of rows in zx_transaction_lines_gt='||l_count);
290: END IF;
291:
292: IF (l_count <> 0) THEN
293:
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;
411: DELETE FROM zx_transaction_lines_gt
412: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
413: WHERE psgt.key = l_po_session_gt_key
414: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE);
415:
452: d_progress := 198;
453: populate_zx_lines_with_rel_cal(p_po_release_id_tbl, p_calling_program);
454:
455: BEGIN
456: SELECT COUNT(1) INTO l_count FROM zx_transaction_lines_gt;
457: EXCEPTION WHEN OTHERS THEN
458: l_count := 0;
459: IF PO_LOG.d_stmt THEN
460: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_transaction_lines_gt');
456: SELECT COUNT(1) INTO l_count FROM zx_transaction_lines_gt;
457: EXCEPTION WHEN OTHERS THEN
458: l_count := 0;
459: IF PO_LOG.d_stmt THEN
460: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_transaction_lines_gt');
461: END IF;
462: END;
463:
464: IF PO_LOG.d_stmt THEN
461: END IF;
462: END;
463:
464: IF PO_LOG.d_stmt THEN
465: PO_LOG.stmt(d_module_base,d_progress,'Number of rows in zx_transaction_lines_gt='||l_count);
466: END IF;
467:
468: IF (l_count <> 0) THEN
469:
473:
474: d_progress := 200;
475: -- Override product_type Additional Tax Attribute if not already populated
476: -- by eTax defaulting/redefaulting API
477: UPDATE zx_transaction_lines_gt zxlgt
478: SET zxlgt.product_type =
479: (SELECT DECODE(pl.purchase_basis,
480: 'GOODS', 'GOODS',
481: 'SERVICES')
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');
605: d_progress := 270;
606: DELETE FROM zx_transaction_lines_gt
607: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
608: WHERE psgt.key = l_po_session_gt_key
609: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
610: AND psgt.char3 = 'CALCULATE_TAX');
608: WHERE psgt.key = l_po_session_gt_key
609: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
610: AND psgt.char3 = 'CALCULATE_TAX');
611: d_progress := 280;
612: DELETE FROM zx_transaction_lines_gt
613: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
614: WHERE psgt.key = l_po_session_gt_key
615: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
616: AND psgt.char3 = 'CALCULATE_TAX');
878: -- Bug 4774900 null out if even a single shipment has been processed
879: -- correctly. That would mean that the header has been recorded
880: -- in eTax, and next time we need to pass UPDATE
881: AND EXISTS (SELECT 'Y'
882: FROM zx_transaction_lines_gt zxlgt
883: WHERE zxlgt.trx_id=ph.po_header_id);
884:
885: d_progress := 470;
886: FORALL i IN 1..p_po_release_id_tbl.COUNT
887: UPDATE po_releases_all pr
888: SET pr.tax_attribute_update_code = null
889: WHERE pr.po_release_id = p_po_release_id_tbl(i)
890: AND EXISTS (SELECT 'Y'
891: FROM zx_transaction_lines_gt zxlgt
892: WHERE zxlgt.trx_id=pr.po_release_id);
893:
894: d_progress := 480;
895: FORALL i IN 1..p_po_header_id_tbl.COUNT
904:
905: UPDATE po_line_locations_all
906: SET tax_attribute_update_code = null,
907: original_shipment_id = null
908: WHERE line_location_id IN (SELECT trx_line_id FROM zx_transaction_lines_gt);
909:
910: UPDATE po_line_locations_all
911: SET tax_attribute_update_code = null,
912: original_shipment_id = null
944: 0, 'N',
945: 'Y'
946: )
947: WHERE
948: pll.line_location_id IN (SELECT trx_line_id FROM zx_transaction_lines_gt);
949:
950:
951: d_progress := 520;
952: -- Pour all errors in po_session_gt into global tax error record
1339:
1340: d_progress := 50;
1341: -- Check if zx lines gt table is empty
1342: BEGIN
1343: SELECT COUNT(1) INTO l_line_count FROM zx_transaction_lines_gt;
1344: EXCEPTION WHEN OTHERS THEN
1345: l_line_count := 0;
1346: IF PO_LOG.d_stmt THEN
1347: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_transaction_lines_gt');
1343: SELECT COUNT(1) INTO l_line_count FROM zx_transaction_lines_gt;
1344: EXCEPTION WHEN OTHERS THEN
1345: l_line_count := 0;
1346: IF PO_LOG.d_stmt THEN
1347: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_transaction_lines_gt');
1348: END IF;
1349: END;
1350:
1351: d_progress := 60;
1349: END;
1350:
1351: d_progress := 60;
1352: IF PO_LOG.d_stmt THEN
1353: PO_LOG.stmt(d_module_base,d_progress,'Number of rows in zx_transaction_lines_gt='||l_line_count);
1354: END IF;
1355:
1356: IF (l_line_count <> 0) THEN
1357: d_progress := 70;
1458:
1459: d_progress := 150;
1460: -- Override product_type Additional Tax Attribute if not already populated
1461: -- by eTax defaulting/redefaulting API
1462: UPDATE zx_transaction_lines_gt zxlgt
1463: SET zxlgt.product_type =
1464: (SELECT DECODE(prl.purchase_basis,
1465: 'GOODS', 'GOODS',
1466: 'SERVICES')
2999:
3000: END populate_zx_headers_with_req;
3001:
3002: /* Bug 11665348: Modified the procedures populate_zx_lines_with_po and
3003: populate_zx_lines_with_rel so that they will dump the data into zx_transaction_lines_gt
3004: only for the PO shipments which are not received and not billed and not shipped.
3005: */
3006:
3007: -----------------------------------------------------------------------------
3009: --Name: populate_zx_lines_with_po
3010: --Pre-reqs:
3011: -- None
3012: --Modifies:
3013: -- ZX_TRANSACTION_LINES_GT
3014: --Locks:
3015: -- ZX_TRANSACTION_LINES_GT
3016: --Function:
3017: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
3011: -- None
3012: --Modifies:
3013: -- ZX_TRANSACTION_LINES_GT
3014: --Locks:
3015: -- ZX_TRANSACTION_LINES_GT
3016: --Function:
3017: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
3018: -- which are not received/billed
3019:
3013: -- ZX_TRANSACTION_LINES_GT
3014: --Locks:
3015: -- ZX_TRANSACTION_LINES_GT
3016: --Function:
3017: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
3018: -- which are not received/billed
3019:
3020: --Parameters:
3021: --IN:
3031: p_calling_program IN VARCHAR2
3032: ) IS
3033: BEGIN
3034:
3035: -- Populate zx_transaction_lines_gt for POs
3036: FORALL i in 1..p_po_header_id_tbl.COUNT
3037: INSERT INTO zx_transaction_lines_gt(
3038: application_id
3039: ,entity_code
3033: BEGIN
3034:
3035: -- Populate zx_transaction_lines_gt for POs
3036: FORALL i in 1..p_po_header_id_tbl.COUNT
3037: INSERT INTO zx_transaction_lines_gt(
3038: application_id
3039: ,entity_code
3040: ,event_class_code
3041: ,trx_id
3340: --Name: populate_zx_lines_with_rel
3341: --Pre-reqs:
3342: -- None
3343: --Modifies:
3344: -- ZX_TRANSACTION_LINES_GT
3345: --Locks:
3346: -- ZX_TRANSACTION_LINES_GT
3347: --Function:
3348: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
3342: -- None
3343: --Modifies:
3344: -- ZX_TRANSACTION_LINES_GT
3345: --Locks:
3346: -- ZX_TRANSACTION_LINES_GT
3347: --Function:
3348: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
3349: -- which are not received/billed
3350:
3344: -- ZX_TRANSACTION_LINES_GT
3345: --Locks:
3346: -- ZX_TRANSACTION_LINES_GT
3347: --Function:
3348: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
3349: -- which are not received/billed
3350:
3351: --Parameters:
3352: --IN:
3361: PROCEDURE populate_zx_lines_with_rel(p_po_release_id_tbl IN PO_TBL_NUMBER,
3362: p_calling_program IN VARCHAR2
3363: ) IS
3364: BEGIN
3365: -- Populate zx_transaction_lines_gt for Releases
3366: FORALL i IN 1..p_po_release_id_tbl.COUNT
3367: INSERT INTO zx_transaction_lines_gt(
3368: application_id
3369: ,entity_code
3363: ) IS
3364: BEGIN
3365: -- Populate zx_transaction_lines_gt for Releases
3366: FORALL i IN 1..p_po_release_id_tbl.COUNT
3367: INSERT INTO zx_transaction_lines_gt(
3368: application_id
3369: ,entity_code
3370: ,event_class_code
3371: ,trx_id
3654:
3655: -----------------------------------------------------------------------------
3656:
3657: /* Bug 11665348 : Creating 2 new procedures populate_zx_lines_with_po_cal and
3658: populate_zx_lines_with_rel_cal which populates the data in zx_transaction_lines_gt
3659: only when the shipments is received or billed or shipped. This has been done for these
3660: shipments to skip the call to get_default_tax_attribs as per the EB Tax suggestion in bug
3661: 11665348 to fulfill requirement by PO PM team to retain the tax on received/billed shipments.
3662: These 2 procedures uses a join for zx_lines_det_factors and po_line_locations_all
3670: --Name: populate_zx_lines_with_po_cal
3671: --Pre-reqs:
3672: -- None
3673: --Modifies:
3674: -- ZX_TRANSACTION_LINES_GT
3675: --Locks:
3676: -- ZX_TRANSACTION_LINES_GT
3677: --Function:
3678: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
3672: -- None
3673: --Modifies:
3674: -- ZX_TRANSACTION_LINES_GT
3675: --Locks:
3676: -- ZX_TRANSACTION_LINES_GT
3677: --Function:
3678: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
3679: -- which are not already populated by populate_zx_lines_with_po
3680: --Parameters:
3674: -- ZX_TRANSACTION_LINES_GT
3675: --Locks:
3676: -- ZX_TRANSACTION_LINES_GT
3677: --Function:
3678: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
3679: -- which are not already populated by populate_zx_lines_with_po
3680: --Parameters:
3681: --IN:
3682: --p_po_header_id_tbl
3691: p_calling_program IN VARCHAR2
3692: ) IS
3693: BEGIN
3694:
3695: -- Populate zx_transaction_lines_gt for POs
3696: FORALL i in 1..p_po_header_id_tbl.COUNT
3697: INSERT INTO zx_transaction_lines_gt(
3698: application_id
3699: ,entity_code
3693: BEGIN
3694:
3695: -- Populate zx_transaction_lines_gt for POs
3696: FORALL i in 1..p_po_header_id_tbl.COUNT
3697: INSERT INTO zx_transaction_lines_gt(
3698: application_id
3699: ,entity_code
3700: ,event_class_code
3701: ,trx_id
3960: AND pll.tax_attribute_update_code IS NOT NULL
3961: AND pll.tax_attribute_update_code <> 'DIST_DELETE'
3962: -- Bug 11665348
3963: AND pll.line_location_id NOT IN (SELECT trx_line_id
3964: FROM zx_transaction_lines_gt)
3965: -- end bug 11665348
3966: AND ph.po_header_id = p_po_header_id_tbl(i)
3967: -- Conditions for getting Additional Tax Attributes
3968: -- Do not put a condition on zxldet.trx_id here because that would
3997: --Name: populate_zx_lines_with_rel_cal
3998: --Pre-reqs:
3999: -- None
4000: --Modifies:
4001: -- ZX_TRANSACTION_LINES_GT
4002: --Locks:
4003: -- ZX_TRANSACTION_LINES_GT
4004: --Function:
4005: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
3999: -- None
4000: --Modifies:
4001: -- ZX_TRANSACTION_LINES_GT
4002: --Locks:
4003: -- ZX_TRANSACTION_LINES_GT
4004: --Function:
4005: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
4006: -- which are not already populated by populate_zx_lines_with_rel.
4007: --Parameters:
4001: -- ZX_TRANSACTION_LINES_GT
4002: --Locks:
4003: -- ZX_TRANSACTION_LINES_GT
4004: --Function:
4005: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
4006: -- which are not already populated by populate_zx_lines_with_rel.
4007: --Parameters:
4008: --IN:
4009: --p_po_release_id_tbl
4017: PROCEDURE populate_zx_lines_with_rel_cal(p_po_release_id_tbl IN PO_TBL_NUMBER,
4018: p_calling_program IN VARCHAR2
4019: ) IS
4020: BEGIN
4021: -- Populate zx_transaction_lines_gt for Releases
4022: FORALL i IN 1..p_po_release_id_tbl.COUNT
4023: INSERT INTO zx_transaction_lines_gt(
4024: application_id
4025: ,entity_code
4019: ) IS
4020: BEGIN
4021: -- Populate zx_transaction_lines_gt for Releases
4022: FORALL i IN 1..p_po_release_id_tbl.COUNT
4023: INSERT INTO zx_transaction_lines_gt(
4024: application_id
4025: ,entity_code
4026: ,event_class_code
4027: ,trx_id
4302: AND pll.tax_attribute_update_code IS NOT NULL
4303: AND pll.tax_attribute_update_code <> 'DIST_DELETE'
4304: -- Bug 11665348
4305: AND pll.line_location_id NOT IN (SELECT trx_line_id
4306: FROM zx_transaction_lines_gt)
4307: -- end bug 11665348
4308: AND pr.po_release_id = p_po_release_id_tbl(i)
4309: AND ph.po_header_id = pr.po_header_id
4310: AND pl.po_line_id = pll.po_line_id;
4321: --Name: populate_zx_lines_with_req
4322: --Pre-reqs:
4323: -- None
4324: --Modifies:
4325: -- ZX_TRANSACTION_LINES_GT
4326: --Locks:
4327: -- ZX_TRANSACTION_LINES_GT
4328: --Function:
4329: -- Populate ZX_TRANSACTION_LINES_GT with transaction line data
4323: -- None
4324: --Modifies:
4325: -- ZX_TRANSACTION_LINES_GT
4326: --Locks:
4327: -- ZX_TRANSACTION_LINES_GT
4328: --Function:
4329: -- Populate ZX_TRANSACTION_LINES_GT with transaction line data
4330: --Parameters:
4331: --IN:
4325: -- ZX_TRANSACTION_LINES_GT
4326: --Locks:
4327: -- ZX_TRANSACTION_LINES_GT
4328: --Function:
4329: -- Populate ZX_TRANSACTION_LINES_GT with transaction line data
4330: --Parameters:
4331: --IN:
4332: --p_requisition_header_id
4333: -- requisition_header_id of the requisition to process for tax_calculation
4365: x_conversion_date => sysdate,
4366: x_conversion_type => l_rate_type);
4367: --
4368:
4369: -- Populate zx_transaction_lines_gt for Requisitions
4370: -- Addition/Removal of any attribute entails similar change in
4371: -- populate_zx_record as well
4372: INSERT INTO zx_transaction_lines_gt(
4373: application_id
4368:
4369: -- Populate zx_transaction_lines_gt for Requisitions
4370: -- Addition/Removal of any attribute entails similar change in
4371: -- populate_zx_record as well
4372: INSERT INTO zx_transaction_lines_gt(
4373: application_id
4374: ,entity_code
4375: ,event_class_code
4376: ,trx_id
4540: ,prl.item_description --product_description
4541: --Bug 5632300. Parameter to confirm that tax classification is overridden
4542:
4543: -- Bug 14155908: When the req split is done passing the user_upd_det_factors_flag
4544: -- to zx_transaction_lines_gt as that of the parent req line's value in
4545: -- zx_lines_det_factors table.
4546: ,Decode (p_calling_program,
4547: 'REQUISITION_MODIFY', zxldet.user_upd_det_factors_flag,
4548: 'REQIMPORT', NVL2(PRL.TAX_NAME,'Y',NULL))
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;
5445: -- there are no corresponding tax lines to delete
5446: --
5447:
5448: FORALL i IN 1..p_del_shipment_table.COUNT
5449: INSERT INTO zx_transaction_lines_gt
5450: (
5451: application_id,
5452: entity_code,
5453: event_class_code,
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
5630: --Locks:
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
5636: --Function:
5666: INTO l_clear_tables
5667: FROM dual
5668: WHERE EXISTS
5669: (SELECT 'CLEAR'
5670: FROM zx_transaction_lines_gt zxlgt
5671: WHERE zxlgt.line_level_action <> 'DELETE');
5672: EXCEPTION
5673: WHEN NO_DATA_FOUND THEN
5674: l_clear_tables := 'N';
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
5710: --Locks:
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
5716: --Function:
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;
5743: d_progress := 30;
5744: DELETE ZX_VALIDATION_ERRORS_GT;
6251: PROCEDURE log_line_tax_attributes(p_module_base IN VARCHAR2,
6252: p_progress IN NUMBER) IS
6253: d_module_base CONSTANT VARCHAR2(100) := p_module_base;
6254: d_progress NUMBER := p_progress;
6255: TYPE zx_lines_type IS TABLE OF ZX_TRANSACTION_LINES_GT%ROWTYPE;
6256: l_zx_lines_tbl zx_lines_type;
6257: BEGIN
6258: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_transaction_lines_gt:');
6259:
6254: d_progress NUMBER := p_progress;
6255: TYPE zx_lines_type IS TABLE OF ZX_TRANSACTION_LINES_GT%ROWTYPE;
6256: l_zx_lines_tbl zx_lines_type;
6257: BEGIN
6258: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_transaction_lines_gt:');
6259:
6260: SELECT *
6261: BULK COLLECT INTO l_zx_lines_tbl
6262: FROM zx_transaction_lines_gt;
6258: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_transaction_lines_gt:');
6259:
6260: SELECT *
6261: BULK COLLECT INTO l_zx_lines_tbl
6262: FROM zx_transaction_lines_gt;
6263:
6264: FOR i IN 1..l_zx_lines_tbl.COUNT LOOP
6265: PO_LOG.stmt(d_module_base,d_progress,' row '||i||':');
6266: PO_LOG.stmt(d_module_base,d_progress,' application_id = '||l_zx_lines_tbl(i).application_id);
6772: FROM po_headers_all ph
6773: WHERE ph.po_header_id = p_document_id;
6774:
6775: d_progress := 30;
6776: INSERT INTO zx_transaction_lines_gt
6777: (
6778: application_id,
6779: entity_code,
6780: event_class_code,
6853: FROM po_headers_all ph
6854: WHERE ph.po_header_id = p_document_id;
6855:
6856: d_progress := 80;
6857: INSERT INTO zx_transaction_lines_gt
6858: (
6859: application_id,
6860: entity_code,
6861: event_class_code,
6971: WHERE pr.po_release_id = p_document_id
6972: AND pr.po_header_id = ph.po_header_id;
6973:
6974: d_progress := 180;
6975: INSERT INTO zx_transaction_lines_gt
6976: (
6977: application_id,
6978: entity_code,
6979: event_class_code,