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 564: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;

560:
561: d_progress := 310;
562: -- Call eTax API determine_recovery to distribute tax lines
563: BEGIN
564: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;
565: EXCEPTION WHEN OTHERS THEN
566: l_count := 0;
567: IF PO_LOG.d_stmt THEN
568: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_itm_distributions_gt');

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

564: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;
565: EXCEPTION WHEN OTHERS THEN
566: l_count := 0;
567: IF PO_LOG.d_stmt THEN
568: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_itm_distributions_gt');
569: END IF;
570: END;
571:
572: IF PO_LOG.d_stmt THEN

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

569: END IF;
570: END;
571:
572: IF PO_LOG.d_stmt THEN
573: PO_LOG.stmt(d_module_base,d_progress,'Number of rows in zx_itm_distributions_gt='||l_count);
574: END IF;
575:
576: IF (l_count <> 0) THEN
577: d_progress := 320;

Line 719: DELETE FROM zx_itm_distributions_gt

715: -- should be nulled out otherwise the header and line level action will
716: -- get passed as CREATE in the next tax calculation (ie at the time of
717: -- approve)
718: d_progress := 380;
719: DELETE FROM zx_itm_distributions_gt
720: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
721: WHERE psgt.key = l_po_session_gt_key
722: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
723: AND psgt.char3 = 'DETERMINE_RECOVERY');

Line 725: DELETE FROM zx_itm_distributions_gt

721: WHERE psgt.key = l_po_session_gt_key
722: AND psgt.char1 = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
723: AND psgt.char3 = 'DETERMINE_RECOVERY');
724: d_progress := 390;
725: DELETE FROM zx_itm_distributions_gt
726: WHERE trx_id IN (SELECT DISTINCT index_num1 FROM po_session_gt psgt
727: WHERE psgt.key = l_po_session_gt_key
728: AND psgt.char1 = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
729: AND psgt.char3 = 'DETERMINE_RECOVERY');

Line 784: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

780: AND zxdist.event_class_code =
781: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
782: AND zxdist.trx_id = pd.po_release_id)))
783: WHERE pd.po_distribution_id IN
784: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
785:
786: END IF;
787:
788: d_progress := 460;

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

837: UPDATE po_line_locations_all
838: SET tax_attribute_update_code = null,
839: original_shipment_id = null
840: WHERE tax_attribute_update_code = 'DIST_DELETE'
841: AND line_location_id IN (SELECT trx_line_id FROM zx_itm_distributions_gt);
842:
843:
844: -- bug5219124 END
845:

Line 850: FROM zx_itm_distributions_gt);

846: d_progress := 500;
847: UPDATE po_distributions_all
848: SET tax_attribute_update_code = null
849: WHERE po_distribution_id IN (SELECT trx_line_dist_id
850: FROM zx_itm_distributions_gt);
851:
852: d_progress := 510;
853:
854: -- bug5685869

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

1381:
1382: d_progress := 210;
1383: -- Call eTax API determine_recovery if zx distributions gt is not empty
1384: BEGIN
1385: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;
1386: EXCEPTION WHEN OTHERS THEN
1387: l_count := 0;
1388: IF PO_LOG.d_stmt THEN
1389: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_itm_distributions_gt');

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

1385: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;
1386: EXCEPTION WHEN OTHERS THEN
1387: l_count := 0;
1388: IF PO_LOG.d_stmt THEN
1389: PO_LOG.stmt(d_module_base,d_progress,'Exception while selecting from zx_itm_distributions_gt');
1390: END IF;
1391: END;
1392:
1393: d_progress := 220;

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

1391: END;
1392:
1393: d_progress := 220;
1394: IF PO_LOG.d_stmt THEN
1395: PO_LOG.stmt(d_module_base,d_progress,'Number of rows in zx_itm_distributions_gt='||l_count);
1396: END IF;
1397:
1398: IF (l_count <> 0) THEN
1399: d_progress := 230;

Line 1499: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

1495: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1496: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
1497: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
1498: WHERE prd.distribution_id IN
1499: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
1500:
1501: END IF; -- IF (l_count <> 0)
1502:
1503: -- If any lines were processed then update eTax repository with the line

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

1722:
1723: d_progress := 30;
1724: -- Call eTax API determine_recovery to distribute tax lines
1725: BEGIN
1726: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;
1727: EXCEPTION WHEN OTHERS THEN
1728: l_count := 0;
1729: END;
1730:

Line 1817: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

1813: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1814: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1815: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE)
1816: WHERE pd.po_distribution_id IN
1817: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
1818:
1819: /* Bug 6157632 Start */
1820: UPDATE po_line_locations_all pll
1821: SET pll.taxable_flag =

Line 1836: 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);

1832: 0, 'N',
1833: 'Y'
1834: )
1835: WHERE
1836: 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);
1837: /* Bug 6157632 End */
1838: END IF;
1839:
1840: d_progress := 60;

Line 1844: FROM zx_itm_distributions_gt);

1840: d_progress := 60;
1841: UPDATE po_distributions_all
1842: SET tax_attribute_update_code = null
1843: WHERE po_distribution_id IN (SELECT trx_line_dist_id
1844: FROM zx_itm_distributions_gt);
1845:
1846: IF (PO_LOG.d_proc) THEN
1847: PO_LOG.proc_end(d_module_base);
1848: PO_LOG.proc_end(d_module_base, 'x_return_status', x_return_status);

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

1940:
1941: d_progress := 30;
1942: -- Call eTax API determine_recovery to distribute tax lines
1943: BEGIN
1944: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;
1945: EXCEPTION WHEN OTHERS THEN
1946: l_count := 0;
1947: END;
1948:

Line 2036: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

2032: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2033: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2034: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)
2035: WHERE pd.po_distribution_id IN
2036: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
2037:
2038: /* Bug 6157632 Start */
2039: UPDATE po_line_locations_all pll
2040: SET pll.taxable_flag =

Line 2055: 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);

2051: 0, 'N',
2052: 'Y'
2053: )
2054: WHERE
2055: 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);
2056: /* Bug 6157632 End */
2057:
2058:
2059: END IF;

Line 2065: FROM zx_itm_distributions_gt);

2061: d_progress := 60;
2062: UPDATE po_distributions_all
2063: SET tax_attribute_update_code = null
2064: WHERE po_distribution_id IN (SELECT trx_line_dist_id
2065: FROM zx_itm_distributions_gt);
2066:
2067: IF (PO_LOG.d_proc) THEN
2068: PO_LOG.proc_end(d_module_base);
2069: PO_LOG.proc_end(d_module_base, 'x_return_status', x_return_status);

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

2162:
2163: d_progress := 30;
2164: -- Call eTax API determine_recovery if zx distributions gt is not empty
2165: BEGIN
2166: SELECT COUNT(1) INTO l_count FROM zx_itm_distributions_gt;
2167: EXCEPTION WHEN OTHERS THEN
2168: l_count := 0;
2169: END;
2170:

Line 2258: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

2254: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2255: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2256: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
2257: WHERE prd.distribution_id IN
2258: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
2259:
2260: END IF; -- IF (l_count <> 0)
2261:
2262: IF (PO_LOG.d_proc) THEN

Line 3706: -- ZX_ITM_DISTRIBUTIONS_GT

3702: --Name: populate_zx_dists_with_po
3703: --Pre-reqs:
3704: -- None
3705: --Modifies:
3706: -- ZX_ITM_DISTRIBUTIONS_GT
3707: --Locks:
3708: -- ZX_ITM_DISTRIBUTIONS_GT
3709: --Function:
3710: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data

Line 3708: -- ZX_ITM_DISTRIBUTIONS_GT

3704: -- None
3705: --Modifies:
3706: -- ZX_ITM_DISTRIBUTIONS_GT
3707: --Locks:
3708: -- ZX_ITM_DISTRIBUTIONS_GT
3709: --Function:
3710: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data
3711: --Parameters:
3712: --IN:

Line 3710: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data

3706: -- ZX_ITM_DISTRIBUTIONS_GT
3707: --Locks:
3708: -- ZX_ITM_DISTRIBUTIONS_GT
3709: --Function:
3710: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data
3711: --Parameters:
3712: --IN:
3713: --p_po_header_id_tbl
3714: -- PL/SQL table with list of po_header_id's to process for tax_calculation

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

3721: PROCEDURE populate_zx_dists_with_po(p_po_header_id_tbl IN PO_TBL_NUMBER,
3722: p_calling_program IN VARCHAR2
3723: ) IS
3724: BEGIN
3725: -- Populate ZX_ITM_DISTRIBUTIONS_GT with all such distributions for which:
3726: -- 1. A sibling distribution was changed OR
3727: -- 2. There was a change at a parent level (header, line, shipment) OR
3728: -- 3. A distribution was deleted, hence its shipment is marked as 'DIST_DELETE'
3729: -- All the above cases are in one sql so that the same distribution is not

Line 3733: INSERT INTO zx_itm_distributions_gt(

3729: -- All the above cases are in one sql so that the same distribution is not
3730: -- populated twice, hence the OR conditions
3731:
3732: FORALL i in 1..p_po_header_id_tbl.COUNT
3733: INSERT INTO zx_itm_distributions_gt(
3734: application_id
3735: ,entity_code
3736: ,event_class_code
3737: ,trx_id

Line 3808: -- ZX_ITM_DISTRIBUTIONS_GT

3804: --Name: populate_all_dists_po
3805: --Pre-reqs:
3806: -- None
3807: --Modifies:
3808: -- ZX_ITM_DISTRIBUTIONS_GT
3809: --Locks:
3810: -- ZX_ITM_DISTRIBUTIONS_GT
3811: --Function:
3812: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data

Line 3810: -- ZX_ITM_DISTRIBUTIONS_GT

3806: -- None
3807: --Modifies:
3808: -- ZX_ITM_DISTRIBUTIONS_GT
3809: --Locks:
3810: -- ZX_ITM_DISTRIBUTIONS_GT
3811: --Function:
3812: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data
3813: --Parameters:
3814: --IN:

Line 3812: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data

3808: -- ZX_ITM_DISTRIBUTIONS_GT
3809: --Locks:
3810: -- ZX_ITM_DISTRIBUTIONS_GT
3811: --Function:
3812: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data
3813: --Parameters:
3814: --IN:
3815: --p_po_header_id
3816: -- po_header_id to process

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

3819: --End of Comments
3820: -----------------------------------------------------------------------------
3821: PROCEDURE populate_all_dists_po(p_po_header_id IN NUMBER) IS
3822: BEGIN
3823: -- Populate ZX_ITM_DISTRIBUTIONS_GT with all distributions of the given PO
3824:
3825: INSERT INTO zx_itm_distributions_gt(
3826: application_id
3827: ,entity_code

Line 3825: INSERT INTO zx_itm_distributions_gt(

3821: PROCEDURE populate_all_dists_po(p_po_header_id IN NUMBER) IS
3822: BEGIN
3823: -- Populate ZX_ITM_DISTRIBUTIONS_GT with all distributions of the given PO
3824:
3825: INSERT INTO zx_itm_distributions_gt(
3826: application_id
3827: ,entity_code
3828: ,event_class_code
3829: ,trx_id

Line 3894: -- ZX_ITM_DISTRIBUTIONS_GT

3890: --Name: populate_zx_dists_with_rel
3891: --Pre-reqs:
3892: -- None
3893: --Modifies:
3894: -- ZX_ITM_DISTRIBUTIONS_GT
3895: --Locks:
3896: -- ZX_ITM_DISTRIBUTIONS_GT
3897: --Function:
3898: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data

Line 3896: -- ZX_ITM_DISTRIBUTIONS_GT

3892: -- None
3893: --Modifies:
3894: -- ZX_ITM_DISTRIBUTIONS_GT
3895: --Locks:
3896: -- ZX_ITM_DISTRIBUTIONS_GT
3897: --Function:
3898: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data
3899: --Parameters:
3900: --IN:

Line 3898: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data

3894: -- ZX_ITM_DISTRIBUTIONS_GT
3895: --Locks:
3896: -- ZX_ITM_DISTRIBUTIONS_GT
3897: --Function:
3898: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data
3899: --Parameters:
3900: --IN:
3901: --p_po_release_id_tbl
3902: -- PL/SQL table with list of po_release_id's to process for tax_calculation

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

3909: PROCEDURE populate_zx_dists_with_rel(p_po_release_id_tbl IN PO_TBL_NUMBER,
3910: p_calling_program IN VARCHAR2
3911: ) IS
3912: BEGIN
3913: -- Populate ZX_ITM_DISTRIBUTIONS_GT with all such distributions for which:
3914: -- 1. A sibling distribution was changed OR
3915: -- 2. There was a change at a parent level (header, line, shipment) OR
3916: -- 3. A distribution was deleted, hence its shipment is marked as 'DIST_DELETE'
3917: -- All the above cases are in one sql so that the same distribution is not

Line 3921: INSERT INTO zx_itm_distributions_gt(

3917: -- All the above cases are in one sql so that the same distribution is not
3918: -- populated twice, hence the OR conditions
3919:
3920: FORALL i in 1..p_po_release_id_tbl.COUNT
3921: INSERT INTO zx_itm_distributions_gt(
3922: application_id
3923: ,entity_code
3924: ,event_class_code
3925: ,trx_id

Line 3996: -- ZX_ITM_DISTRIBUTIONS_GT

3992: --Name: populate_all_dists_rel
3993: --Pre-reqs:
3994: -- None
3995: --Modifies:
3996: -- ZX_ITM_DISTRIBUTIONS_GT
3997: --Locks:
3998: -- ZX_ITM_DISTRIBUTIONS_GT
3999: --Function:
4000: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data

Line 3998: -- ZX_ITM_DISTRIBUTIONS_GT

3994: -- None
3995: --Modifies:
3996: -- ZX_ITM_DISTRIBUTIONS_GT
3997: --Locks:
3998: -- ZX_ITM_DISTRIBUTIONS_GT
3999: --Function:
4000: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data
4001: --Parameters:
4002: --IN:

Line 4000: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data

3996: -- ZX_ITM_DISTRIBUTIONS_GT
3997: --Locks:
3998: -- ZX_ITM_DISTRIBUTIONS_GT
3999: --Function:
4000: -- Populate ZX_ITM_DISTRIBUTIONS_GT with transaction distribution data
4001: --Parameters:
4002: --IN:
4003: --p_po_release_id
4004: -- po_release_id to process

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

4007: --End of Comments
4008: -----------------------------------------------------------------------------
4009: PROCEDURE populate_all_dists_rel(p_po_release_id IN NUMBER) IS
4010: BEGIN
4011: -- Populate ZX_ITM_DISTRIBUTIONS_GT with all distributions of the given Release
4012:
4013: INSERT INTO zx_itm_distributions_gt(
4014: application_id
4015: ,entity_code

Line 4013: INSERT INTO zx_itm_distributions_gt(

4009: PROCEDURE populate_all_dists_rel(p_po_release_id IN NUMBER) IS
4010: BEGIN
4011: -- Populate ZX_ITM_DISTRIBUTIONS_GT with all distributions of the given Release
4012:
4013: INSERT INTO zx_itm_distributions_gt(
4014: application_id
4015: ,entity_code
4016: ,event_class_code
4017: ,trx_id

Line 4103: INSERT INTO zx_itm_distributions_gt(

4099: p_calling_program IN VARCHAR2
4100: ) IS
4101: BEGIN
4102: -- Populate zx distributions table with requisition distributions data
4103: INSERT INTO zx_itm_distributions_gt(
4104: application_id
4105: ,entity_code
4106: ,event_class_code
4107: ,trx_id

Line 4732: -- ZX_ITM_DISTRIBUTIONS_GT

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

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

Line 4812: -- ZX_ITM_DISTRIBUTIONS_GT

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

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

Line 4847: DELETE ZX_ITM_DISTRIBUTIONS_GT;

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;
4850: d_progress := 40;
4851: DELETE ZX_ERRORS_GT;

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

5462: PROCEDURE log_dist_tax_attributes(p_module_base IN VARCHAR2,
5463: p_progress IN NUMBER) IS
5464: d_module_base CONSTANT VARCHAR2(100) := p_module_base;
5465: d_progress NUMBER := p_progress;
5466: TYPE zx_dists_type IS TABLE OF ZX_ITM_DISTRIBUTIONS_GT%ROWTYPE;
5467: l_zx_dists_tbl zx_dists_type;
5468: BEGIN
5469: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_itm_distributions_gt:');
5470:

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

5465: d_progress NUMBER := p_progress;
5466: TYPE zx_dists_type IS TABLE OF ZX_ITM_DISTRIBUTIONS_GT%ROWTYPE;
5467: l_zx_dists_tbl zx_dists_type;
5468: BEGIN
5469: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_itm_distributions_gt:');
5470:
5471: SELECT *
5472: BULK COLLECT INTO l_zx_dists_tbl
5473: FROM zx_itm_distributions_gt;

Line 5473: FROM zx_itm_distributions_gt;

5469: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_itm_distributions_gt:');
5470:
5471: SELECT *
5472: BULK COLLECT INTO l_zx_dists_tbl
5473: FROM zx_itm_distributions_gt;
5474:
5475: FOR i IN 1..l_zx_dists_tbl.COUNT LOOP
5476: PO_LOG.stmt(d_module_base,d_progress,' row '||i||':');
5477: PO_LOG.stmt(d_module_base,d_progress,' application_id = '||l_zx_dists_tbl(i).application_id);