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_ITM_DISTRIBUTIONS_GT

Line 629: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;

625:
626: d_progress := 310;
627: -- Call eTax API determine_recovery to distribute tax lines
628: BEGIN
629: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;
630: EXCEPTION WHEN OTHERS THEN
631: l_count := 0;
632: IF PO_LOG.d_stmt THEN
633: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_itm_distributions_gt');

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

629: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;
630: EXCEPTION WHEN OTHERS THEN
631: l_count := 0;
632: IF PO_LOG.d_stmt THEN
633: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_itm_distributions_gt');
634: END IF;
635: END;
636:
637: IF PO_LOG.d_stmt THEN

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

634: END IF;
635: END;
636:
637: IF PO_LOG.d_stmt THEN
638: PO_LOG.stmt(d_module_base,d_progress,'Number of rows in zx_itm_distributions_gt='||l_count);
639: END IF;
640:
641: IF (l_count <> 0) THEN
642: d_progress := 320;

Line 784: DELETE FROM zx_itm_distributions_gt

780: -- should be nulled out otherwise the header and line level action will
781: -- get passed as CREATE in the next tax calculation (ie at the time of
782: -- approve)
783: d_progress := 380;
784: DELETE FROM zx_itm_distributions_gt
785: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
786: WHERE psgt.key = l_po_session_gt_key
787: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
788: AND psgt.char3 = 'DETERMINE_RECOVERY');

Line 790: DELETE FROM zx_itm_distributions_gt

786: WHERE psgt.key = l_po_session_gt_key
787: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
788: AND psgt.char3 = 'DETERMINE_RECOVERY');
789: d_progress := 390;
790: DELETE FROM zx_itm_distributions_gt
791: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
792: WHERE psgt.key = l_po_session_gt_key
793: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
794: AND psgt.char3 = 'DETERMINE_RECOVERY');

Line 857: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

853: last_updated_by = fnd_global.user_id,
854: last_update_login = fnd_global.login_id
855: --Bug 10305728 end
856: WHERE pd.po_distribution_id IN
857: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
858:
859: END IF;
860:
861: d_progress := 460;

Line 914: AND line_location_id IN (SELECT trx_line_id FROM zx_itm_distributions_gt);

910: UPDATE po_line_locations_all
911: SET tax_attribute_update_code = null,
912: original_shipment_id = null
913: WHERE tax_attribute_update_code = 'DIST_DELETE'
914: AND line_location_id IN (SELECT trx_line_id FROM zx_itm_distributions_gt);
915:
916:
917: -- bug5219124 END
918:

Line 923: FROM zx_itm_distributions_gt);

919: d_progress := 500;
920: UPDATE po_distributions_all
921: SET tax_attribute_update_code = null
922: WHERE po_distribution_id IN (SELECT trx_line_dist_id
923: FROM zx_itm_distributions_gt);
924:
925: d_progress := 510;
926:
927: -- bug5685869

Line 1554: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;

1550:
1551: d_progress := 210;
1552: -- Call eTax API determine_recovery if zx distributions gt is not empty
1553: BEGIN
1554: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;
1555: EXCEPTION WHEN OTHERS THEN
1556: l_count := 0;
1557: IF PO_LOG.d_stmt THEN
1558: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_itm_distributions_gt');

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

1554: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;
1555: EXCEPTION WHEN OTHERS THEN
1556: l_count := 0;
1557: IF PO_LOG.d_stmt THEN
1558: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_itm_distributions_gt');
1559: END IF;
1560: END;
1561:
1562: d_progress := 220;

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

1560: END;
1561:
1562: d_progress := 220;
1563: IF PO_LOG.d_stmt THEN
1564: PO_LOG.stmt(d_module_base,d_progress,'Number of rows in zx_itm_distributions_gt='||l_count);
1565: END IF;
1566:
1567: IF (l_count <> 0) THEN
1568: d_progress := 230;

Line 1668: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

1664: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1665: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
1666: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
1667: WHERE prd.distribution_id IN
1668: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
1669:
1670: END IF; -- IF (l_count <> 0)
1671:
1672: -- If any lines were processed then update eTax repository with the line

Line 1895: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;

1891:
1892: d_progress := 30;
1893: -- Call eTax API determine_recovery to distribute tax lines
1894: BEGIN
1895: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;
1896: EXCEPTION WHEN OTHERS THEN
1897: l_count := 0;
1898: END;
1899:

Line 1991: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

1987: last_updated_by = fnd_global.user_id,
1988: last_update_login = fnd_global.login_id
1989: --Bug 10305728 end
1990: WHERE pd.po_distribution_id IN
1991: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
1992:
1993: /* Bug 6157632 Start */
1994: UPDATE po_line_locations_all pll
1995: SET pll.taxable_flag =

Line 2016: pll.line_location_id IN (SELECT line_location_id FROM po_distributions_all pd,zx_itm_distributions_gt zi WHERE pd.po_distribution_id=zi.trx_line_dist_id);

2012: last_updated_by = fnd_global.user_id,
2013: last_update_login = fnd_global.login_id
2014: --Bug 10305728 end
2015: WHERE
2016: pll.line_location_id IN (SELECT line_location_id FROM po_distributions_all pd,zx_itm_distributions_gt zi WHERE pd.po_distribution_id=zi.trx_line_dist_id);
2017: /* Bug 6157632 End */
2018: END IF;
2019:
2020: d_progress := 60;

Line 2029: FROM zx_itm_distributions_gt);

2025: last_updated_by = fnd_global.user_id,
2026: last_update_login = fnd_global.login_id
2027: --Bug 10305728 end
2028: WHERE po_distribution_id IN (SELECT trx_line_dist_id
2029: FROM zx_itm_distributions_gt);
2030:
2031: IF (PO_LOG.d_proc) THEN
2032: PO_LOG.proc_end(d_module_base);
2033: PO_LOG.proc_end(d_module_base, 'x_return_status', x_return_status);

Line 2129: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;

2125:
2126: d_progress := 30;
2127: -- Call eTax API determine_recovery to distribute tax lines
2128: BEGIN
2129: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;
2130: EXCEPTION WHEN OTHERS THEN
2131: l_count := 0;
2132: END;
2133:

Line 2221: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

2217: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2218: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2219: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)
2220: WHERE pd.po_distribution_id IN
2221: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
2222:
2223: /* Bug 6157632 Start */
2224: UPDATE po_line_locations_all pll
2225: SET pll.taxable_flag =

Line 2240: pll.line_location_id IN (SELECT line_location_id FROM po_distributions_all pd,zx_itm_distributions_gt zi WHERE pd.po_distribution_id=zi.trx_line_dist_id);

2236: 0, 'N',
2237: 'Y'
2238: )
2239: WHERE
2240: pll.line_location_id IN (SELECT line_location_id FROM po_distributions_all pd,zx_itm_distributions_gt zi WHERE pd.po_distribution_id=zi.trx_line_dist_id);
2241: /* Bug 6157632 End */
2242:
2243:
2244: END IF;

Line 2250: FROM zx_itm_distributions_gt);

2246: d_progress := 60;
2247: UPDATE po_distributions_all
2248: SET tax_attribute_update_code = null
2249: WHERE po_distribution_id IN (SELECT trx_line_dist_id
2250: FROM zx_itm_distributions_gt);
2251:
2252: IF (PO_LOG.d_proc) THEN
2253: PO_LOG.proc_end(d_module_base);
2254: PO_LOG.proc_end(d_module_base, 'x_return_status', x_return_status);

Line 2351: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;

2347:
2348: d_progress := 30;
2349: -- Call eTax API determine_recovery if zx distributions gt is not empty
2350: BEGIN
2351: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;
2352: EXCEPTION WHEN OTHERS THEN
2353: l_count := 0;
2354: END;
2355:

Line 2443: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

2439: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2440: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2441: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
2442: WHERE prd.distribution_id IN
2443: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
2444:
2445: END IF; -- IF (l_count <> 0)
2446:
2447: IF (PO_LOG.d_proc) THEN

Line 4590: -- ZX_ITM_DISTRIBUTIONS_GT

4586: --Name: populate_zx_dists_with_po
4587: --Pre-reqs:
4588: -- None
4589: --Modifies:
4590: -- ZX_ITM_DISTRIBUTIONS_GT
4591: --Locks:
4592: -- ZX_ITM_DISTRIBUTIONS_GT
4593: --Function:
4594: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data

Line 4592: -- ZX_ITM_DISTRIBUTIONS_GT

4588: -- None
4589: --Modifies:
4590: -- ZX_ITM_DISTRIBUTIONS_GT
4591: --Locks:
4592: -- ZX_ITM_DISTRIBUTIONS_GT
4593: --Function:
4594: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data
4595: --Parameters:
4596: --IN:

Line 4594: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data

4590: -- ZX_ITM_DISTRIBUTIONS_GT
4591: --Locks:
4592: -- ZX_ITM_DISTRIBUTIONS_GT
4593: --Function:
4594: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data
4595: --Parameters:
4596: --IN:
4597: --p_po_header_id_tbl
4598: -- PL/SQL table with list of po_header_id's to process for tax_calculation

Line 4609: -- Populate ZX_ITM_DISTRIBUTIONS_GT with all such distributions for which:

4605: PROCEDURE populate_zx_dists_with_po(p_po_header_id_tbl IN PO_TBL_NUMBER,
4606: p_calling_program IN VARCHAR2
4607: ) IS
4608: BEGIN
4609: -- Populate ZX_ITM_DISTRIBUTIONS_GT with all such distributions for which:
4610: -- 1. A sibling distribution was changed OR
4611: -- 2. There was a change at a parent level (header, line, shipment) OR
4612: -- 3. A distribution was deleted, hence its shipment is marked as 'DIST_DELETE'
4613: -- All the above cases are in one sql so that the same distribution is not

Line 4617: INSERT INTO zx_itm_distributions_gt(

4613: -- All the above cases are in one sql so that the same distribution is not
4614: -- populated twice, hence the OR conditions
4615:
4616: FORALL i in 1..p_po_header_id_tbl.COUNT
4617: INSERT INTO zx_itm_distributions_gt(
4618: application_id
4619: ,entity_code
4620: ,event_class_code
4621: ,trx_id

Line 4692: -- ZX_ITM_DISTRIBUTIONS_GT

4688: --Name: populate_all_dists_po
4689: --Pre-reqs:
4690: -- None
4691: --Modifies:
4692: -- ZX_ITM_DISTRIBUTIONS_GT
4693: --Locks:
4694: -- ZX_ITM_DISTRIBUTIONS_GT
4695: --Function:
4696: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data

Line 4694: -- ZX_ITM_DISTRIBUTIONS_GT

4690: -- None
4691: --Modifies:
4692: -- ZX_ITM_DISTRIBUTIONS_GT
4693: --Locks:
4694: -- ZX_ITM_DISTRIBUTIONS_GT
4695: --Function:
4696: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data
4697: --Parameters:
4698: --IN:

Line 4696: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data

4692: -- ZX_ITM_DISTRIBUTIONS_GT
4693: --Locks:
4694: -- ZX_ITM_DISTRIBUTIONS_GT
4695: --Function:
4696: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data
4697: --Parameters:
4698: --IN:
4699: --p_po_header_id
4700: -- po_header_id to process

Line 4707: -- Populate ZX_ITM_DISTRIBUTIONS_GT with all distributions of the given PO

4703: --End of Comments
4704: -----------------------------------------------------------------------------
4705: PROCEDURE populate_all_dists_po(p_po_header_id IN NUMBER) IS
4706: BEGIN
4707: -- Populate ZX_ITM_DISTRIBUTIONS_GT with all distributions of the given PO
4708:
4709: INSERT INTO zx_itm_distributions_gt(
4710: application_id
4711: ,entity_code

Line 4709: INSERT INTO zx_itm_distributions_gt(

4705: PROCEDURE populate_all_dists_po(p_po_header_id IN NUMBER) IS
4706: BEGIN
4707: -- Populate ZX_ITM_DISTRIBUTIONS_GT with all distributions of the given PO
4708:
4709: INSERT INTO zx_itm_distributions_gt(
4710: application_id
4711: ,entity_code
4712: ,event_class_code
4713: ,trx_id

Line 4787: -- ZX_ITM_DISTRIBUTIONS_GT

4783: --Name: populate_zx_dists_with_rel
4784: --Pre-reqs:
4785: -- None
4786: --Modifies:
4787: -- ZX_ITM_DISTRIBUTIONS_GT
4788: --Locks:
4789: -- ZX_ITM_DISTRIBUTIONS_GT
4790: --Function:
4791: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data

Line 4789: -- ZX_ITM_DISTRIBUTIONS_GT

4785: -- None
4786: --Modifies:
4787: -- ZX_ITM_DISTRIBUTIONS_GT
4788: --Locks:
4789: -- ZX_ITM_DISTRIBUTIONS_GT
4790: --Function:
4791: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data
4792: --Parameters:
4793: --IN:

Line 4791: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data

4787: -- ZX_ITM_DISTRIBUTIONS_GT
4788: --Locks:
4789: -- ZX_ITM_DISTRIBUTIONS_GT
4790: --Function:
4791: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data
4792: --Parameters:
4793: --IN:
4794: --p_po_release_id_tbl
4795: -- PL/SQL table with list of po_release_id's to process for tax_calculation

Line 4806: -- Populate ZX_ITM_DISTRIBUTIONS_GT with all such distributions for which:

4802: PROCEDURE populate_zx_dists_with_rel(p_po_release_id_tbl IN PO_TBL_NUMBER,
4803: p_calling_program IN VARCHAR2
4804: ) IS
4805: BEGIN
4806: -- Populate ZX_ITM_DISTRIBUTIONS_GT with all such distributions for which:
4807: -- 1. A sibling distribution was changed OR
4808: -- 2. There was a change at a parent level (header, line, shipment) OR
4809: -- 3. A distribution was deleted, hence its shipment is marked as 'DIST_DELETE'
4810: -- All the above cases are in one sql so that the same distribution is not

Line 4814: INSERT INTO zx_itm_distributions_gt(

4810: -- All the above cases are in one sql so that the same distribution is not
4811: -- populated twice, hence the OR conditions
4812:
4813: FORALL i in 1..p_po_release_id_tbl.COUNT
4814: INSERT INTO zx_itm_distributions_gt(
4815: application_id
4816: ,entity_code
4817: ,event_class_code
4818: ,trx_id

Line 4889: -- ZX_ITM_DISTRIBUTIONS_GT

4885: --Name: populate_all_dists_rel
4886: --Pre-reqs:
4887: -- None
4888: --Modifies:
4889: -- ZX_ITM_DISTRIBUTIONS_GT
4890: --Locks:
4891: -- ZX_ITM_DISTRIBUTIONS_GT
4892: --Function:
4893: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data

Line 4891: -- ZX_ITM_DISTRIBUTIONS_GT

4887: -- None
4888: --Modifies:
4889: -- ZX_ITM_DISTRIBUTIONS_GT
4890: --Locks:
4891: -- ZX_ITM_DISTRIBUTIONS_GT
4892: --Function:
4893: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data
4894: --Parameters:
4895: --IN:

Line 4893: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data

4889: -- ZX_ITM_DISTRIBUTIONS_GT
4890: --Locks:
4891: -- ZX_ITM_DISTRIBUTIONS_GT
4892: --Function:
4893: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data
4894: --Parameters:
4895: --IN:
4896: --p_po_release_id
4897: -- po_release_id to process

Line 4904: -- Populate ZX_ITM_DISTRIBUTIONS_GT with all distributions of the given Release

4900: --End of Comments
4901: -----------------------------------------------------------------------------
4902: PROCEDURE populate_all_dists_rel(p_po_release_id IN NUMBER) IS
4903: BEGIN
4904: -- Populate ZX_ITM_DISTRIBUTIONS_GT with all distributions of the given Release
4905:
4906: INSERT INTO zx_itm_distributions_gt(
4907: application_id
4908: ,entity_code

Line 4906: INSERT INTO zx_itm_distributions_gt(

4902: PROCEDURE populate_all_dists_rel(p_po_release_id IN NUMBER) IS
4903: BEGIN
4904: -- Populate ZX_ITM_DISTRIBUTIONS_GT with all distributions of the given Release
4905:
4906: INSERT INTO zx_itm_distributions_gt(
4907: application_id
4908: ,entity_code
4909: ,event_class_code
4910: ,trx_id

Line 4996: INSERT INTO zx_itm_distributions_gt(

4992: p_calling_program IN VARCHAR2
4993: ) IS
4994: BEGIN
4995: -- Populate zx distributions table with requisition distributions data
4996: INSERT INTO zx_itm_distributions_gt(
4997: application_id
4998: ,entity_code
4999: ,event_class_code
5000: ,trx_id

Line 5627: -- ZX_ITM_DISTRIBUTIONS_GT

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:
5631: -- ZX_TRX_HEADERS_GT

Line 5633: -- ZX_ITM_DISTRIBUTIONS_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:
5637: -- Wipe out all data from ZX Global Temporary tables used in PO transaction

Line 5707: -- ZX_ITM_DISTRIBUTIONS_GT

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:
5711: -- ZX_TRX_HEADERS_GT

Line 5713: -- ZX_ITM_DISTRIBUTIONS_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:
5717: -- Wipe out all data from ZX Global Temporary tables

Line 5742: DELETE ZX_ITM_DISTRIBUTIONS_GT;

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;
5745: d_progress := 40;
5746: DELETE ZX_ERRORS_GT;

Line 6362: TYPE zx_dists_type IS TABLE OF ZX_ITM_DISTRIBUTIONS_GT%ROWTYPE;

6358: PROCEDURE log_dist_tax_attributes(p_module_base IN VARCHAR2,
6359: p_progress IN NUMBER) IS
6360: d_module_base CONSTANT VARCHAR2(100) := p_module_base;
6361: d_progress NUMBER := p_progress;
6362: TYPE zx_dists_type IS TABLE OF ZX_ITM_DISTRIBUTIONS_GT%ROWTYPE;
6363: l_zx_dists_tbl zx_dists_type;
6364: BEGIN
6365: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_itm_distributions_gt:');
6366:

Line 6365: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_itm_distributions_gt:');

6361: d_progress NUMBER := p_progress;
6362: TYPE zx_dists_type IS TABLE OF ZX_ITM_DISTRIBUTIONS_GT%ROWTYPE;
6363: l_zx_dists_tbl zx_dists_type;
6364: BEGIN
6365: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_itm_distributions_gt:');
6366:
6367: SELECT *
6368: BULK COLLECT INTO l_zx_dists_tbl
6369: FROM zx_itm_distributions_gt;

Line 6369: FROM zx_itm_distributions_gt;

6365: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_itm_distributions_gt:');
6366:
6367: SELECT *
6368: BULK COLLECT INTO l_zx_dists_tbl
6369: FROM zx_itm_distributions_gt;
6370:
6371: FOR i IN 1..l_zx_dists_tbl.COUNT LOOP
6372: PO_LOG.stmt(d_module_base,d_progress,' row '||i||':');
6373: PO_LOG.stmt(d_module_base,d_progress,' application_id = '||l_zx_dists_tbl(i).application_id);