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_R12_CAT_UPG_VAL_PVT dependencies on PO_R12_CAT_UPG_TYPES

Line 60: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

56: l_api_name CONSTANT VARCHAR2(30) := 'validate_org_ids';
57: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
58: l_progress VARCHAR2(3) := '000';
59:
60: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
61: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
62:
63: l_err_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
64: l_err_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 61: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

57: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
58: l_progress VARCHAR2(3) := '000';
59:
60: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
61: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
62:
63: l_err_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
64: l_err_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
65: i NUMBER;

Line 63: l_err_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

59:
60: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
61: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
62:
63: l_err_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
64: l_err_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
65: i NUMBER;
66:
67: l_ou_name HR_ALL_ORGANIZATION_UNITS_TL.name%TYPE;

Line 64: l_err_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

60: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
61: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
62:
63: l_err_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
64: l_err_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
65: i NUMBER;
66:
67: l_ou_name HR_ALL_ORGANIZATION_UNITS_TL.name%TYPE;
68:

Line 470: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

466: l_progress VARCHAR2(3) := '000';
467:
468: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
469:
470: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
471: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
472: l_err_currency_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
473:
474: l_index NUMBER;

Line 471: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

467:
468: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
469:
470: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
471: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
472: l_err_currency_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
473:
474: l_index NUMBER;
475: i NUMBER;

Line 472: l_err_currency_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;

468: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
469:
470: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
471: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
472: l_err_currency_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
473:
474: l_index NUMBER;
475: i NUMBER;
476: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 476: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

472: l_err_currency_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
473:
474: l_index NUMBER;
475: i NUMBER;
476: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
477: BEGIN
478: l_progress := '010';
479: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
480:

Line 623: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

619: l_progress VARCHAR2(3) := '000';
620:
621: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
622:
623: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
624: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
625: l_vendor_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
626: l_vendor_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
627: l_vendor_site_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 624: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

620:
621: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
622:
623: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
624: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
625: l_vendor_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
626: l_vendor_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
627: l_vendor_site_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
628: l_vendor_site_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;

Line 625: l_vendor_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

621: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
622:
623: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
624: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
625: l_vendor_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
626: l_vendor_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
627: l_vendor_site_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
628: l_vendor_site_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
629: l_vendor_contact_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 626: l_vendor_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;

622:
623: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
624: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
625: l_vendor_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
626: l_vendor_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
627: l_vendor_site_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
628: l_vendor_site_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
629: l_vendor_contact_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
630:

Line 627: l_vendor_site_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

623: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
624: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
625: l_vendor_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
626: l_vendor_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
627: l_vendor_site_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
628: l_vendor_site_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
629: l_vendor_contact_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
630:
631: l_return_status VARCHAR2(1);

Line 628: l_vendor_site_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;

624: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
625: l_vendor_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
626: l_vendor_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
627: l_vendor_site_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
628: l_vendor_site_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
629: l_vendor_contact_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
630:
631: l_return_status VARCHAR2(1);
632: l_msg_count NUMBER;

Line 629: l_vendor_contact_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

625: l_vendor_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
626: l_vendor_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
627: l_vendor_site_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
628: l_vendor_site_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
629: l_vendor_contact_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
630:
631: l_return_status VARCHAR2(1);
632: l_msg_count NUMBER;
633: l_msg_data VARCHAR2(2000);

Line 637: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

633: l_msg_data VARCHAR2(2000);
634: l_ccr_status VARCHAR2(1);
635: l_error_code NUMBER;
636:
637: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
638: l_index NUMBER;
639: i NUMBER;
640:
641: -- If the profile option 'Enable Transaction Code' is set to 'Yes',

Line 1168: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1164: l_progress VARCHAR2(3) := '000';
1165:
1166: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1167:
1168: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1169: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1170: l_err_ship_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1171:
1172: l_index NUMBER;

Line 1169: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1165:
1166: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1167:
1168: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1169: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1170: l_err_ship_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1171:
1172: l_index NUMBER;
1173: i NUMBER;

Line 1170: l_err_ship_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1166: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1167:
1168: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1169: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1170: l_err_ship_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1171:
1172: l_index NUMBER;
1173: i NUMBER;
1174: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 1174: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1170: l_err_ship_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1171:
1172: l_index NUMBER;
1173: i NUMBER;
1174: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1175:
1176: l_location_name HR_LOCATIONS_ALL_TL.location_code%TYPE;
1177: BEGIN
1178: l_progress := '010';

Line 1366: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1362: l_progress VARCHAR2(3) := '000';
1363:
1364: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1365:
1366: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1367: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1368: l_err_bill_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1369:
1370: l_index NUMBER;

Line 1367: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1363:
1364: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1365:
1366: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1367: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1368: l_err_bill_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1369:
1370: l_index NUMBER;
1371: i NUMBER;

Line 1368: l_err_bill_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1364: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1365:
1366: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1367: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1368: l_err_bill_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1369:
1370: l_index NUMBER;
1371: i NUMBER;
1372: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 1372: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1368: l_err_bill_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1369:
1370: l_index NUMBER;
1371: i NUMBER;
1372: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1373:
1374: l_location_name HR_LOCATIONS_ALL_TL.location_code%TYPE;
1375: BEGIN
1376: l_progress := '010';

Line 1631: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1627: l_progress VARCHAR2(3) := '000';
1628:
1629: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1630:
1631: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1632: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1633: l_err_fob_lookup_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1634:
1635: l_index NUMBER;

Line 1632: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1628:
1629: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1630:
1631: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1632: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1633: l_err_fob_lookup_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1634:
1635: l_index NUMBER;
1636: i NUMBER;

Line 1633: l_err_fob_lookup_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

1629: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1630:
1631: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1632: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1633: l_err_fob_lookup_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1634:
1635: l_index NUMBER;
1636: i NUMBER;
1637: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 1637: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1633: l_err_fob_lookup_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1634:
1635: l_index NUMBER;
1636: i NUMBER;
1637: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1638:
1639: l_lookup_meaning PO_LOOKUP_CODES.displayed_field%TYPE;
1640: BEGIN
1641: l_progress := '010';

Line 1766: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1762: l_progress VARCHAR2(3) := '000';
1763:
1764: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1765:
1766: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1767: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1768: l_err_ship_via_luc_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1769:
1770: l_index NUMBER;

Line 1767: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1763:
1764: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1765:
1766: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1767: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1768: l_err_ship_via_luc_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1769:
1770: l_index NUMBER;
1771: i NUMBER;

Line 1768: l_err_ship_via_luc_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

1764: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1765:
1766: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1767: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1768: l_err_ship_via_luc_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1769:
1770: l_index NUMBER;
1771: i NUMBER;
1772: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 1772: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1768: l_err_ship_via_luc_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1769:
1770: l_index NUMBER;
1771: i NUMBER;
1772: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1773: BEGIN
1774: l_progress := '010';
1775: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1776: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Validating a defaulted field -- SHIP_VIA_LOOKUP_CODE (freight_carrier)'); END IF;

Line 1890: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1886: l_progress VARCHAR2(3) := '000';
1887:
1888: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1889:
1890: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1891: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1892: l_err_freight_terms_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1893:
1894: l_index NUMBER;

Line 1891: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1887:
1888: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1889:
1890: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1891: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1892: l_err_freight_terms_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1893:
1894: l_index NUMBER;
1895: i NUMBER;

Line 1892: l_err_freight_terms_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

1888: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1889:
1890: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1891: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1892: l_err_freight_terms_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1893:
1894: l_index NUMBER;
1895: i NUMBER;
1896: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 1896: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1892: l_err_freight_terms_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1893:
1894: l_index NUMBER;
1895: i NUMBER;
1896: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1897:
1898: l_lookup_meaning PO_LOOKUP_CODES.displayed_field%TYPE;
1899: BEGIN
1900: l_progress := '010';

Line 2091: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2087: l_progress VARCHAR2(3) := '000';
2088:
2089: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2090:
2091: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2092: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2093: l_err_terms_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2094:
2095: l_index NUMBER;

Line 2092: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2088:
2089: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2090:
2091: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2092: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2093: l_err_terms_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2094:
2095: l_index NUMBER;
2096: i NUMBER;

Line 2093: l_err_terms_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2089: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2090:
2091: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2092: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2093: l_err_terms_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2094:
2095: l_index NUMBER;
2096: i NUMBER;
2097: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 2097: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2093: l_err_terms_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2094:
2095: l_index NUMBER;
2096: i NUMBER;
2097: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2098:
2099: l_terms_name AP_TERMS_TL.name%TYPE;
2100: BEGIN
2101: l_progress := '010';

Line 2227: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2223: l_progress VARCHAR2(3) := '000';
2224:
2225: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2226:
2227: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2228: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2229: l_err_shipping_control_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
2230:
2231: l_index NUMBER;

Line 2228: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2224:
2225: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2226:
2227: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2228: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2229: l_err_shipping_control_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
2230:
2231: l_index NUMBER;
2232: i NUMBER;

Line 2229: l_err_shipping_control_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;

2225: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2226:
2227: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2228: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2229: l_err_shipping_control_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
2230:
2231: l_index NUMBER;
2232: i NUMBER;
2233: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 2233: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2229: l_err_shipping_control_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
2230:
2231: l_index NUMBER;
2232: i NUMBER;
2233: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2234:
2235: l_lookup_meaning PO_LOOKUP_CODES.displayed_field%TYPE;
2236: BEGIN
2237: l_progress := '010';

Line 2363: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2359: l_progress VARCHAR2(3) := '000';
2360:
2361: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2362:
2363: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2364: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2365: l_err_rate_type_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
2366:
2367: l_index NUMBER;

Line 2364: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2360:
2361: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2362:
2363: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2364: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2365: l_err_rate_type_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
2366:
2367: l_index NUMBER;
2368: i NUMBER;

Line 2365: l_err_rate_type_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;

2361: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2362:
2363: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2364: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2365: l_err_rate_type_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
2366:
2367: l_index NUMBER;
2368: i NUMBER;
2369: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 2369: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2365: l_err_rate_type_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
2366:
2367: l_index NUMBER;
2368: i NUMBER;
2369: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2370: BEGIN
2371: l_progress := '010';
2372: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2373:

Line 2668: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2664: l_progress VARCHAR2(3) := '000';
2665:
2666: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2667:
2668: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2669: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2670: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2671: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2672:

Line 2669: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2665:
2666: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2667:
2668: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2669: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2670: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2671: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2672:
2673: l_index NUMBER;

Line 2670: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2666: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2667:
2668: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2669: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2670: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2671: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2672:
2673: l_index NUMBER;
2674: i NUMBER;

Line 2671: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2667:
2668: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2669: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2670: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2671: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2672:
2673: l_index NUMBER;
2674: i NUMBER;
2675: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 2675: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2671: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2672:
2673: l_index NUMBER;
2674: i NUMBER;
2675: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2676: BEGIN
2677: l_progress := '010';
2678: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2679:

Line 2806: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2802: l_progress VARCHAR2(3) := '000';
2803:
2804: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2805:
2806: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2807: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2808: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2809: l_item_description_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
2810:

Line 2807: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2803:
2804: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2805:
2806: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2807: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2808: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2809: l_item_description_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
2810:
2811: l_index NUMBER;

Line 2808: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2804: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2805:
2806: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2807: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2808: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2809: l_item_description_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
2810:
2811: l_index NUMBER;
2812: i NUMBER;

Line 2809: l_item_description_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;

2805:
2806: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2807: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2808: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2809: l_item_description_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
2810:
2811: l_index NUMBER;
2812: i NUMBER;
2813: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 2813: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2809: l_item_description_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
2810:
2811: l_index NUMBER;
2812: i NUMBER;
2813: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2814: BEGIN
2815: l_progress := '010';
2816: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2817:

Line 2933: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2929: l_progress VARCHAR2(3) := '000';
2930:
2931: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2932:
2933: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2934: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2935: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2936: l_unit_of_measure_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
2937: l_uom_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;

Line 2934: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2930:
2931: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2932:
2933: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2934: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2935: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2936: l_unit_of_measure_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
2937: l_uom_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
2938:

Line 2935: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2931: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2932:
2933: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2934: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2935: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2936: l_unit_of_measure_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
2937: l_uom_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
2938:
2939: l_index NUMBER;

Line 2936: l_unit_of_measure_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

2932:
2933: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2934: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2935: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2936: l_unit_of_measure_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
2937: l_uom_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
2938:
2939: l_index NUMBER;
2940: i NUMBER;

Line 2937: l_uom_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;

2933: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2934: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2935: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2936: l_unit_of_measure_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
2937: l_uom_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
2938:
2939: l_index NUMBER;
2940: i NUMBER;
2941: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 2941: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2937: l_uom_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
2938:
2939: l_index NUMBER;
2940: i NUMBER;
2941: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2942: BEGIN
2943: l_progress := '010';
2944: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2945:

Line 3192: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

3188: l_progress VARCHAR2(3) := '000';
3189:
3190: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
3191:
3192: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3193: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3194: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3195: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3196: l_item_revision_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;

Line 3193: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

3189:
3190: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
3191:
3192: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3193: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3194: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3195: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3196: l_item_revision_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
3197:

Line 3194: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

3190: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
3191:
3192: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3193: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3194: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3195: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3196: l_item_revision_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
3197:
3198: l_index NUMBER;

Line 3195: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

3191:
3192: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3193: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3194: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3195: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3196: l_item_revision_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
3197:
3198: l_index NUMBER;
3199: i NUMBER;

Line 3196: l_item_revision_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;

3192: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3193: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3194: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3195: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3196: l_item_revision_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
3197:
3198: l_index NUMBER;
3199: i NUMBER;
3200: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 3200: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

3196: l_item_revision_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
3197:
3198: l_index NUMBER;
3199: i NUMBER;
3200: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3201: BEGIN
3202: l_progress := '010';
3203: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
3204:

Line 3514: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

3510: l_progress VARCHAR2(3) := '000';
3511:
3512: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
3513:
3514: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3515: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3516: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3517: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3518: l_category_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 3515: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

3511:
3512: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
3513:
3514: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3515: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3516: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3517: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3518: l_category_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3519: l_category_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR2000;

Line 3516: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

3512: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
3513:
3514: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3515: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3516: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3517: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3518: l_category_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3519: l_category_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR2000;
3520:

Line 3517: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

3513:
3514: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3515: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3516: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3517: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3518: l_category_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3519: l_category_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR2000;
3520:
3521: l_index NUMBER;

Line 3518: l_category_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

3514: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3515: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3516: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3517: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3518: l_category_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3519: l_category_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR2000;
3520:
3521: l_index NUMBER;
3522: i NUMBER;

Line 3519: l_category_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR2000;

3515: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3516: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3517: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3518: l_category_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3519: l_category_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR2000;
3520:
3521: l_index NUMBER;
3522: i NUMBER;
3523: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 3523: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

3519: l_category_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR2000;
3520:
3521: l_index NUMBER;
3522: i NUMBER;
3523: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3524:
3525: l_validate_flag MTL_CATEGORY_SETS_V.validate_flag%TYPE;
3526: l_category_set_id MTL_CATEGORY_SETS_V.category_set_id%TYPE;
3527:

Line 4136: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

4132: l_api_name CONSTANT VARCHAR2(30) := 'validate_create_action';
4133: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
4134: l_progress VARCHAR2(3) := '000';
4135:
4136: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4137: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4138: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4139: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4140: BEGIN

Line 4137: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

4133: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
4134: l_progress VARCHAR2(3) := '000';
4135:
4136: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4137: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4138: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4139: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4140: BEGIN
4141: l_progress := '010';

Line 4138: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

4134: l_progress VARCHAR2(3) := '000';
4135:
4136: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4137: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4138: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4139: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4140: BEGIN
4141: l_progress := '010';
4142: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 4139: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

4135:
4136: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4137: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4138: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4139: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4140: BEGIN
4141: l_progress := '010';
4142: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
4143:

Line 4622: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

4618: l_api_name CONSTANT VARCHAR2(30) := 'validate_add_action';
4619: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
4620: l_progress VARCHAR2(3) := '000';
4621:
4622: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4623: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4624: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4625: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4626: BEGIN

Line 4623: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

4619: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
4620: l_progress VARCHAR2(3) := '000';
4621:
4622: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4623: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4624: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4625: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4626: BEGIN
4627: l_progress := '010';

Line 4624: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

4620: l_progress VARCHAR2(3) := '000';
4621:
4622: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4623: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4624: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4625: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4626: BEGIN
4627: l_progress := '010';
4628: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 4625: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

4621:
4622: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4623: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4624: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4625: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4626: BEGIN
4627: l_progress := '010';
4628: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
4629:

Line 4853: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

4849: l_api_name CONSTANT VARCHAR2(30) := 'validate_update_action';
4850: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
4851: l_progress VARCHAR2(3) := '000';
4852:
4853: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4854: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4855: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4856: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4857: BEGIN

Line 4854: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

4850: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
4851: l_progress VARCHAR2(3) := '000';
4852:
4853: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4854: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4855: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4856: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4857: BEGIN
4858: l_progress := '010';

Line 4855: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

4851: l_progress VARCHAR2(3) := '000';
4852:
4853: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4854: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4855: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4856: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4857: BEGIN
4858: l_progress := '010';
4859: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 4856: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

4852:
4853: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4854: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4855: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4856: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4857: BEGIN
4858: l_progress := '010';
4859: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
4860:

Line 5189: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

5185: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_action';
5186: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
5187: l_progress VARCHAR2(3) := '000';
5188:
5189: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5190: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5191: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5192: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5193:

Line 5190: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

5186: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
5187: l_progress VARCHAR2(3) := '000';
5188:
5189: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5190: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5191: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5192: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5193:
5194: l_base_language FND_LANGUAGES.language_code%TYPE;

Line 5191: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

5187: l_progress VARCHAR2(3) := '000';
5188:
5189: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5190: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5191: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5192: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5193:
5194: l_base_language FND_LANGUAGES.language_code%TYPE;
5195: BEGIN

Line 5192: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

5188:
5189: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5190: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5191: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5192: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5193:
5194: l_base_language FND_LANGUAGES.language_code%TYPE;
5195: BEGIN
5196: l_progress := '010';