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

Line 363: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

359: -- (SELECT 'Corresponding PO Line exists'
360: -- FROM PO_LINES_ALL POL
361: -- WHERE POL.po_line_id = POTLP.po_line_id);
362:
363: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
364: l_err_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
365: l_return_status VARCHAR2(100);
366: l_intf_hdr_id_list DBMS_SQL.NUMBER_TABLE;
367: BEGIN

Line 364: l_err_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

360: -- FROM PO_LINES_ALL POL
361: -- WHERE POL.po_line_id = POTLP.po_line_id);
362:
363: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
364: l_err_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
365: l_return_status VARCHAR2(100);
366: l_intf_hdr_id_list DBMS_SQL.NUMBER_TABLE;
367: BEGIN
368: l_progress := '010';

Line 947: l_err_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

943: AND headers.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW
944: AND headers.action IN (PO_R12_CAT_UPG_PVT.g_action_header_create, 'UPDATE', 'DELETE');
945:
946: l_doc_headers_table record_of_headers_type;
947: l_err_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
948: l_count NUMBER := NULL;
949: BEGIN
950: l_progress := '010';
951: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 1315: p_valid_po_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1311: --End of Comments
1312: --------------------------------------------------------------------------------
1313: PROCEDURE copy_cpa_attachments
1314: (
1315: p_valid_po_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1316: , p_valid_intf_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1317: , p_valid_cpa_references IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1318: , p_valid_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1319: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

Line 1316: , p_valid_intf_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1312: --------------------------------------------------------------------------------
1313: PROCEDURE copy_cpa_attachments
1314: (
1315: p_valid_po_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1316: , p_valid_intf_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1317: , p_valid_cpa_references IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1318: , p_valid_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1319: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1320: , x_doc_headers_rec IN OUT NOCOPY record_of_headers_type

Line 1317: , p_valid_cpa_references IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1313: PROCEDURE copy_cpa_attachments
1314: (
1315: p_valid_po_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1316: , p_valid_intf_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1317: , p_valid_cpa_references IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1318: , p_valid_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1319: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1320: , x_doc_headers_rec IN OUT NOCOPY record_of_headers_type
1321: , x_remaining_val_po_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

Line 1318: , p_valid_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1314: (
1315: p_valid_po_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1316: , p_valid_intf_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1317: , p_valid_cpa_references IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1318: , p_valid_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1319: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1320: , x_doc_headers_rec IN OUT NOCOPY record_of_headers_type
1321: , x_remaining_val_po_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1322: , x_remaining_val_intf_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

Line 1319: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1315: p_valid_po_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1316: , p_valid_intf_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1317: , p_valid_cpa_references IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1318: , p_valid_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1319: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1320: , x_doc_headers_rec IN OUT NOCOPY record_of_headers_type
1321: , x_remaining_val_po_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1322: , x_remaining_val_intf_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1323: , x_remaining_val_vndr_site_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

Line 1321: , x_remaining_val_po_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1317: , p_valid_cpa_references IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1318: , p_valid_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1319: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1320: , x_doc_headers_rec IN OUT NOCOPY record_of_headers_type
1321: , x_remaining_val_po_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1322: , x_remaining_val_intf_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1323: , x_remaining_val_vndr_site_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1324: )
1325: IS

Line 1322: , x_remaining_val_intf_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1318: , p_valid_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1319: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1320: , x_doc_headers_rec IN OUT NOCOPY record_of_headers_type
1321: , x_remaining_val_po_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1322: , x_remaining_val_intf_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1323: , x_remaining_val_vndr_site_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1324: )
1325: IS
1326: l_api_name CONSTANT VARCHAR2(30) := 'copy_cpa_attachments';

Line 1323: , x_remaining_val_vndr_site_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1319: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1320: , x_doc_headers_rec IN OUT NOCOPY record_of_headers_type
1321: , x_remaining_val_po_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1322: , x_remaining_val_intf_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1323: , x_remaining_val_vndr_site_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1324: )
1325: IS
1326: l_api_name CONSTANT VARCHAR2(30) := 'copy_cpa_attachments';
1327: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 1334: l_is_attach_err_intf_hdr_id PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR1;

1330: i NUMBER;
1331: j NUMBER;
1332: l_count NUMBER := 0;
1333: l_err_count NUMBER;
1334: l_is_attach_err_intf_hdr_id PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR1;
1335:
1336: BEGIN
1337: l_progress := '010';
1338: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 1484: p_valid_po_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1480: --End of Comments
1481: --------------------------------------------------------------------------------
1482: PROCEDURE manage_copy_cpa
1483: (
1484: p_valid_po_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1485: , p_valid_intf_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1486: , p_valid_cpa_references IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1487: , p_valid_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1488: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

Line 1485: , p_valid_intf_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1481: --------------------------------------------------------------------------------
1482: PROCEDURE manage_copy_cpa
1483: (
1484: p_valid_po_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1485: , p_valid_intf_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1486: , p_valid_cpa_references IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1487: , p_valid_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1488: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1489: , x_doc_headers_rec IN OUT NOCOPY record_of_headers_type

Line 1486: , p_valid_cpa_references IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1482: PROCEDURE manage_copy_cpa
1483: (
1484: p_valid_po_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1485: , p_valid_intf_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1486: , p_valid_cpa_references IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1487: , p_valid_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1488: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1489: , x_doc_headers_rec IN OUT NOCOPY record_of_headers_type
1490: , x_remaining_val_po_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

Line 1487: , p_valid_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1483: (
1484: p_valid_po_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1485: , p_valid_intf_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1486: , p_valid_cpa_references IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1487: , p_valid_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1488: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1489: , x_doc_headers_rec IN OUT NOCOPY record_of_headers_type
1490: , x_remaining_val_po_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1491: , x_remaining_val_intf_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

Line 1488: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1484: p_valid_po_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1485: , p_valid_intf_hdr_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1486: , p_valid_cpa_references IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1487: , p_valid_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1488: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1489: , x_doc_headers_rec IN OUT NOCOPY record_of_headers_type
1490: , x_remaining_val_po_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1491: , x_remaining_val_intf_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1492: , x_remaining_val_vndr_site_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

Line 1490: , x_remaining_val_po_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1486: , p_valid_cpa_references IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1487: , p_valid_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1488: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1489: , x_doc_headers_rec IN OUT NOCOPY record_of_headers_type
1490: , x_remaining_val_po_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1491: , x_remaining_val_intf_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1492: , x_remaining_val_vndr_site_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1493: )
1494: IS

Line 1491: , x_remaining_val_intf_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1487: , p_valid_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1488: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1489: , x_doc_headers_rec IN OUT NOCOPY record_of_headers_type
1490: , x_remaining_val_po_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1491: , x_remaining_val_intf_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1492: , x_remaining_val_vndr_site_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1493: )
1494: IS
1495: l_api_name CONSTANT VARCHAR2(30) := 'manage_copy_cpa';

Line 1492: , x_remaining_val_vndr_site_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1488: , p_valid_vndr_site_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1489: , x_doc_headers_rec IN OUT NOCOPY record_of_headers_type
1490: , x_remaining_val_po_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1491: , x_remaining_val_intf_hdr_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1492: , x_remaining_val_vndr_site_ids IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1493: )
1494: IS
1495: l_api_name CONSTANT VARCHAR2(30) := 'manage_copy_cpa';
1496: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 1793: l_remaining_val_po_hdr_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1789: l_num_valid_headers NUMBER;
1790:
1791: l_return_status VARCHAR2(1);
1792:
1793: l_remaining_val_po_hdr_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1794: l_remaining_val_intf_hdr_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1795: l_remaining_val_vndr_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1796: BEGIN
1797: l_progress := '010';

Line 1794: l_remaining_val_intf_hdr_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1790:
1791: l_return_status VARCHAR2(1);
1792:
1793: l_remaining_val_po_hdr_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1794: l_remaining_val_intf_hdr_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1795: l_remaining_val_vndr_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1796: BEGIN
1797: l_progress := '010';
1798: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 1795: l_remaining_val_vndr_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1791: l_return_status VARCHAR2(1);
1792:
1793: l_remaining_val_po_hdr_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1794: l_remaining_val_intf_hdr_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1795: l_remaining_val_vndr_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1796: BEGIN
1797: l_progress := '010';
1798: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1799:

Line 2523: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2519: l_progress VARCHAR2(3) := '000';
2520:
2521: l_return_status VARCHAR2(1);
2522:
2523: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2524: l_po_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2525: BEGIN
2526: l_progress := '010';
2527: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 2524: l_po_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2520:
2521: l_return_status VARCHAR2(1);
2522:
2523: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2524: l_po_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2525: BEGIN
2526: l_progress := '010';
2527: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2528:

Line 2847: l_err_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2843: AND lines.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW
2844: AND lines.action IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE', 'DELETE');
2845:
2846: l_doc_lines_table record_of_lines_type;
2847: l_err_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2848: l_count NUMBER := NULL;
2849: BEGIN
2850: l_progress := '010';
2851: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 3250: , x_process_code_list IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25

3246: --------------------------------------------------------------------------------
3247: PROCEDURE get_hdr_process_code_list
3248: (
3249: p_doc_lines_rec IN record_of_lines_type
3250: , x_process_code_list IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25
3251: )
3252: IS
3253: l_api_name CONSTANT VARCHAR2(30) := 'get_hdr_process_code_list';
3254: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 3259: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

3255: l_progress VARCHAR2(3) := '000';
3256:
3257: l_key PO_SESSION_GT.key%TYPE;
3258: i NUMBER;
3259: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3260: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3261: l_process_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
3262: l_index NUMBER;
3263: BEGIN

Line 3260: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

3256:
3257: l_key PO_SESSION_GT.key%TYPE;
3258: i NUMBER;
3259: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3260: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3261: l_process_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
3262: l_index NUMBER;
3263: BEGIN
3264: l_progress := '010';

Line 3261: l_process_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

3257: l_key PO_SESSION_GT.key%TYPE;
3258: i NUMBER;
3259: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3260: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3261: l_process_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
3262: l_index NUMBER;
3263: BEGIN
3264: l_progress := '010';
3265: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 3365: l_max_po_line_num PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

3361: l_api_name CONSTANT VARCHAR2(30) := 'insert_doc_lines';
3362: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
3363: l_progress VARCHAR2(3) := '000';
3364:
3365: l_max_po_line_num PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3366:
3367: l_valid_lines record_of_lines_type;
3368: l_count NUMBER;
3369: l_key PO_SESSION_GT.key%TYPE;

Line 3371: l_process_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

3367: l_valid_lines record_of_lines_type;
3368: l_count NUMBER;
3369: l_key PO_SESSION_GT.key%TYPE;
3370: i NUMBER;
3371: l_process_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
3372: BEGIN
3373: l_progress := '010';
3374: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
3375:

Line 3996: l_po_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER; --Bug#4731494

3992: IS
3993: l_api_name CONSTANT VARCHAR2(30) := 'update_doc_lines';
3994: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
3995: l_progress VARCHAR2(3) := '000';
3996: l_po_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER; --Bug#4731494
3997: BEGIN
3998: l_progress := '010';
3999: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
4000:

Line 4163: l_po_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

4159: l_api_name CONSTANT VARCHAR2(30) := 'delete_doc_lines';
4160: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
4161: l_progress VARCHAR2(3) := '000';
4162:
4163: l_po_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4164:
4165: BEGIN
4166: l_progress := '010';
4167: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 7872: , x_org_id_list IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

7868: (
7869: p_batch_id IN NUMBER
7870: , p_batch_size IN NUMBER
7871: , p_validate_only_mode IN VARCHAR2
7872: , x_org_id_list IN OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
7873: )
7874: IS
7875: l_api_name CONSTANT VARCHAR2(30) := 'get_distinct_orgs';
7876: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;