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.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on ICX_TBL_NUMBER

Line 73: g_resp_with_category_realms ICX_TBL_NUMBER;

69: -- Determines if installation has any item source realms
70: g_uses_item_source_realms BOOLEAN;
71:
72: -- List of all responsibilities with realms
73: g_resp_with_category_realms ICX_TBL_NUMBER;
74:
75: -- List of all responsibilities without realms
76: g_resp_without_category_realms ICX_TBL_NUMBER;
77:

Line 76: g_resp_without_category_realms ICX_TBL_NUMBER;

72: -- List of all responsibilities with realms
73: g_resp_with_category_realms ICX_TBL_NUMBER;
74:
75: -- List of all responsibilities without realms
76: g_resp_without_category_realms ICX_TBL_NUMBER;
77:
78: -- List of all responsibilities with realms
79: g_resp_with_isrc_realms ICX_TBL_NUMBER;
80:

Line 79: g_resp_with_isrc_realms ICX_TBL_NUMBER;

75: -- List of all responsibilities without realms
76: g_resp_without_category_realms ICX_TBL_NUMBER;
77:
78: -- List of all responsibilities with realms
79: g_resp_with_isrc_realms ICX_TBL_NUMBER;
80:
81: -- List of all responsibilities without realms
82: g_resp_without_isrc_realms ICX_TBL_NUMBER;
83:

Line 82: g_resp_without_isrc_realms ICX_TBL_NUMBER;

78: -- List of all responsibilities with realms
79: g_resp_with_isrc_realms ICX_TBL_NUMBER;
80:
81: -- List of all responsibilities without realms
82: g_resp_without_isrc_realms ICX_TBL_NUMBER;
83:
84:
85: -- TOP-LEVEL MIGRATE METHOD
86: ---------------------------

Line 371: g_resp_with_category_realms := ICX_TBL_NUMBER();

367:
368: l_err_loc := 200;
369:
370: -- empty starting tables
371: g_resp_with_category_realms := ICX_TBL_NUMBER();
372: g_resp_without_category_realms := ICX_TBL_NUMBER();
373: g_resp_with_isrc_realms := ICX_TBL_NUMBER();
374: g_resp_without_isrc_realms := ICX_TBL_NUMBER();
375:

Line 372: g_resp_without_category_realms := ICX_TBL_NUMBER();

368: l_err_loc := 200;
369:
370: -- empty starting tables
371: g_resp_with_category_realms := ICX_TBL_NUMBER();
372: g_resp_without_category_realms := ICX_TBL_NUMBER();
373: g_resp_with_isrc_realms := ICX_TBL_NUMBER();
374: g_resp_without_isrc_realms := ICX_TBL_NUMBER();
375:
376: l_err_loc := 300;

Line 373: g_resp_with_isrc_realms := ICX_TBL_NUMBER();

369:
370: -- empty starting tables
371: g_resp_with_category_realms := ICX_TBL_NUMBER();
372: g_resp_without_category_realms := ICX_TBL_NUMBER();
373: g_resp_with_isrc_realms := ICX_TBL_NUMBER();
374: g_resp_without_isrc_realms := ICX_TBL_NUMBER();
375:
376: l_err_loc := 300;
377:

Line 374: g_resp_without_isrc_realms := ICX_TBL_NUMBER();

370: -- empty starting tables
371: g_resp_with_category_realms := ICX_TBL_NUMBER();
372: g_resp_without_category_realms := ICX_TBL_NUMBER();
373: g_resp_with_isrc_realms := ICX_TBL_NUMBER();
374: g_resp_without_isrc_realms := ICX_TBL_NUMBER();
375:
376: l_err_loc := 300;
377:
378: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1241: l_catalog_ids ICX_TBL_NUMBER;

1237: -- selected and then passed to a migrate catalogs helper method.
1238: --
1239: PROCEDURE migrate_all_catalogs_no_realms
1240: IS
1241: l_catalog_ids ICX_TBL_NUMBER;
1242: l_store_ids ICX_TBL_NUMBER;
1243: l_new_zone_ids ICX_TBL_NUMBER;
1244:
1245: l_api_name CONSTANT VARCHAR2(30) := 'migrate_all_catalogs_no_realms';

Line 1242: l_store_ids ICX_TBL_NUMBER;

1238: --
1239: PROCEDURE migrate_all_catalogs_no_realms
1240: IS
1241: l_catalog_ids ICX_TBL_NUMBER;
1242: l_store_ids ICX_TBL_NUMBER;
1243: l_new_zone_ids ICX_TBL_NUMBER;
1244:
1245: l_api_name CONSTANT VARCHAR2(30) := 'migrate_all_catalogs_no_realms';
1246: l_err_loc PLS_INTEGER;

Line 1243: l_new_zone_ids ICX_TBL_NUMBER;

1239: PROCEDURE migrate_all_catalogs_no_realms
1240: IS
1241: l_catalog_ids ICX_TBL_NUMBER;
1242: l_store_ids ICX_TBL_NUMBER;
1243: l_new_zone_ids ICX_TBL_NUMBER;
1244:
1245: l_api_name CONSTANT VARCHAR2(30) := 'migrate_all_catalogs_no_realms';
1246: l_err_loc PLS_INTEGER;
1247: BEGIN

Line 1288: l_item_source_ids ICX_TBL_NUMBER;

1284: -- handled separately.
1285: --
1286: PROCEDURE migrate_all_isrcs_no_realms
1287: IS
1288: l_item_source_ids ICX_TBL_NUMBER;
1289: l_store_ids ICX_TBL_NUMBER;
1290: l_new_zone_ids ICX_TBL_NUMBER;
1291:
1292: l_api_name CONSTANT VARCHAR2(30) := 'migrate_all_isrcs_no_realms';

Line 1289: l_store_ids ICX_TBL_NUMBER;

1285: --
1286: PROCEDURE migrate_all_isrcs_no_realms
1287: IS
1288: l_item_source_ids ICX_TBL_NUMBER;
1289: l_store_ids ICX_TBL_NUMBER;
1290: l_new_zone_ids ICX_TBL_NUMBER;
1291:
1292: l_api_name CONSTANT VARCHAR2(30) := 'migrate_all_isrcs_no_realms';
1293: l_err_loc PLS_INTEGER;

Line 1290: l_new_zone_ids ICX_TBL_NUMBER;

1286: PROCEDURE migrate_all_isrcs_no_realms
1287: IS
1288: l_item_source_ids ICX_TBL_NUMBER;
1289: l_store_ids ICX_TBL_NUMBER;
1290: l_new_zone_ids ICX_TBL_NUMBER;
1291:
1292: l_api_name CONSTANT VARCHAR2(30) := 'migrate_all_isrcs_no_realms';
1293: l_err_loc PLS_INTEGER;
1294: BEGIN

Line 1383: l_old_content_ids ICX_TBL_NUMBER;

1379: p_item_sources_migrated IN BOOLEAN
1380: )
1381: IS
1382: -- stores all the component content data parts which to migrate
1383: l_old_content_ids ICX_TBL_NUMBER;
1384: l_content_types ICX_TBL_VARCHAR15;
1385: l_old_store_ids ICX_TBL_NUMBER;
1386: l_new_zone_ids ICX_TBL_NUMBER;
1387:

Line 1385: l_old_store_ids ICX_TBL_NUMBER;

1381: IS
1382: -- stores all the component content data parts which to migrate
1383: l_old_content_ids ICX_TBL_NUMBER;
1384: l_content_types ICX_TBL_VARCHAR15;
1385: l_old_store_ids ICX_TBL_NUMBER;
1386: l_new_zone_ids ICX_TBL_NUMBER;
1387:
1388: -- keeps track of the store the following list of responsilbities with and
1389: -- without realms are valid for; will only query once per store to help

Line 1386: l_new_zone_ids ICX_TBL_NUMBER;

1382: -- stores all the component content data parts which to migrate
1383: l_old_content_ids ICX_TBL_NUMBER;
1384: l_content_types ICX_TBL_VARCHAR15;
1385: l_old_store_ids ICX_TBL_NUMBER;
1386: l_new_zone_ids ICX_TBL_NUMBER;
1387:
1388: -- keeps track of the store the following list of responsilbities with and
1389: -- without realms are valid for; will only query once per store to help
1390: -- performance (realms queries are quite large)

Line 1392: l_resp_with_catr_realms ICX_TBL_NUMBER;

1388: -- keeps track of the store the following list of responsilbities with and
1389: -- without realms are valid for; will only query once per store to help
1390: -- performance (realms queries are quite large)
1391: l_isrc_realms_list_for_store NUMBER;
1392: l_resp_with_catr_realms ICX_TBL_NUMBER;
1393: l_resp_with_isrc_realms ICX_TBL_NUMBER;
1394: l_resp_without_isrc_realms ICX_TBL_NUMBER;
1395:
1396: -- keeps track of all the catalogs and item sources that can be migrated

Line 1393: l_resp_with_isrc_realms ICX_TBL_NUMBER;

1389: -- without realms are valid for; will only query once per store to help
1390: -- performance (realms queries are quite large)
1391: l_isrc_realms_list_for_store NUMBER;
1392: l_resp_with_catr_realms ICX_TBL_NUMBER;
1393: l_resp_with_isrc_realms ICX_TBL_NUMBER;
1394: l_resp_without_isrc_realms ICX_TBL_NUMBER;
1395:
1396: -- keeps track of all the catalogs and item sources that can be migrated
1397: -- without realms consideration (they are all migrated in bulk)

Line 1394: l_resp_without_isrc_realms ICX_TBL_NUMBER;

1390: -- performance (realms queries are quite large)
1391: l_isrc_realms_list_for_store NUMBER;
1392: l_resp_with_catr_realms ICX_TBL_NUMBER;
1393: l_resp_with_isrc_realms ICX_TBL_NUMBER;
1394: l_resp_without_isrc_realms ICX_TBL_NUMBER;
1395:
1396: -- keeps track of all the catalogs and item sources that can be migrated
1397: -- without realms consideration (they are all migrated in bulk)
1398: l_catalog_no_catr_realms_ids ICX_TBL_NUMBER;

Line 1398: l_catalog_no_catr_realms_ids ICX_TBL_NUMBER;

1394: l_resp_without_isrc_realms ICX_TBL_NUMBER;
1395:
1396: -- keeps track of all the catalogs and item sources that can be migrated
1397: -- without realms consideration (they are all migrated in bulk)
1398: l_catalog_no_catr_realms_ids ICX_TBL_NUMBER;
1399: l_store_no_catr_realms_ids ICX_TBL_NUMBER;
1400: l_isrc_no_isrc_realms_ids ICX_TBL_NUMBER;
1401: l_store_no_isrc_realms_ids ICX_TBL_NUMBER;
1402:

Line 1399: l_store_no_catr_realms_ids ICX_TBL_NUMBER;

1395:
1396: -- keeps track of all the catalogs and item sources that can be migrated
1397: -- without realms consideration (they are all migrated in bulk)
1398: l_catalog_no_catr_realms_ids ICX_TBL_NUMBER;
1399: l_store_no_catr_realms_ids ICX_TBL_NUMBER;
1400: l_isrc_no_isrc_realms_ids ICX_TBL_NUMBER;
1401: l_store_no_isrc_realms_ids ICX_TBL_NUMBER;
1402:
1403: l_api_name CONSTANT VARCHAR2(30) := 'migrate_content_with_realms';

Line 1400: l_isrc_no_isrc_realms_ids ICX_TBL_NUMBER;

1396: -- keeps track of all the catalogs and item sources that can be migrated
1397: -- without realms consideration (they are all migrated in bulk)
1398: l_catalog_no_catr_realms_ids ICX_TBL_NUMBER;
1399: l_store_no_catr_realms_ids ICX_TBL_NUMBER;
1400: l_isrc_no_isrc_realms_ids ICX_TBL_NUMBER;
1401: l_store_no_isrc_realms_ids ICX_TBL_NUMBER;
1402:
1403: l_api_name CONSTANT VARCHAR2(30) := 'migrate_content_with_realms';
1404: l_err_loc PLS_INTEGER;

Line 1401: l_store_no_isrc_realms_ids ICX_TBL_NUMBER;

1397: -- without realms consideration (they are all migrated in bulk)
1398: l_catalog_no_catr_realms_ids ICX_TBL_NUMBER;
1399: l_store_no_catr_realms_ids ICX_TBL_NUMBER;
1400: l_isrc_no_isrc_realms_ids ICX_TBL_NUMBER;
1401: l_store_no_isrc_realms_ids ICX_TBL_NUMBER;
1402:
1403: l_api_name CONSTANT VARCHAR2(30) := 'migrate_content_with_realms';
1404: l_err_loc PLS_INTEGER;
1405:

Line 1422: l_catalog_no_catr_realms_ids := ICX_TBL_NUMBER();

1418: l_err_loc := 100;
1419:
1420: -- now, initialize the tables that keep track of any local catalogs or
1421: -- item sources that may still be migrated without regard to realms
1422: l_catalog_no_catr_realms_ids := ICX_TBL_NUMBER();
1423: l_store_no_catr_realms_ids := ICX_TBL_NUMBER();
1424: l_isrc_no_isrc_realms_ids := ICX_TBL_NUMBER();
1425: l_store_no_isrc_realms_ids := ICX_TBL_NUMBER();
1426:

Line 1423: l_store_no_catr_realms_ids := ICX_TBL_NUMBER();

1419:
1420: -- now, initialize the tables that keep track of any local catalogs or
1421: -- item sources that may still be migrated without regard to realms
1422: l_catalog_no_catr_realms_ids := ICX_TBL_NUMBER();
1423: l_store_no_catr_realms_ids := ICX_TBL_NUMBER();
1424: l_isrc_no_isrc_realms_ids := ICX_TBL_NUMBER();
1425: l_store_no_isrc_realms_ids := ICX_TBL_NUMBER();
1426:
1427: l_err_loc := 200;

Line 1424: l_isrc_no_isrc_realms_ids := ICX_TBL_NUMBER();

1420: -- now, initialize the tables that keep track of any local catalogs or
1421: -- item sources that may still be migrated without regard to realms
1422: l_catalog_no_catr_realms_ids := ICX_TBL_NUMBER();
1423: l_store_no_catr_realms_ids := ICX_TBL_NUMBER();
1424: l_isrc_no_isrc_realms_ids := ICX_TBL_NUMBER();
1425: l_store_no_isrc_realms_ids := ICX_TBL_NUMBER();
1426:
1427: l_err_loc := 200;
1428:

Line 1425: l_store_no_isrc_realms_ids := ICX_TBL_NUMBER();

1421: -- item sources that may still be migrated without regard to realms
1422: l_catalog_no_catr_realms_ids := ICX_TBL_NUMBER();
1423: l_store_no_catr_realms_ids := ICX_TBL_NUMBER();
1424: l_isrc_no_isrc_realms_ids := ICX_TBL_NUMBER();
1425: l_store_no_isrc_realms_ids := ICX_TBL_NUMBER();
1426:
1427: l_err_loc := 200;
1428:
1429: -- keep track of the current store (get_contents_to_migrate will return

Line 1667: p_catalog_ids IN ICX_TBL_NUMBER,

1663: -- be used when migrating these local catalogs.
1664: --
1665: PROCEDURE migrate_catalogs_no_realms
1666: (
1667: p_catalog_ids IN ICX_TBL_NUMBER,
1668: p_old_store_ids IN ICX_TBL_NUMBER,
1669: p_new_zone_ids IN ICX_TBL_NUMBER
1670: )
1671: IS

Line 1668: p_old_store_ids IN ICX_TBL_NUMBER,

1664: --
1665: PROCEDURE migrate_catalogs_no_realms
1666: (
1667: p_catalog_ids IN ICX_TBL_NUMBER,
1668: p_old_store_ids IN ICX_TBL_NUMBER,
1669: p_new_zone_ids IN ICX_TBL_NUMBER
1670: )
1671: IS
1672: l_security_flags ICX_TBL_VARCHAR20;

Line 1669: p_new_zone_ids IN ICX_TBL_NUMBER

1665: PROCEDURE migrate_catalogs_no_realms
1666: (
1667: p_catalog_ids IN ICX_TBL_NUMBER,
1668: p_old_store_ids IN ICX_TBL_NUMBER,
1669: p_new_zone_ids IN ICX_TBL_NUMBER
1670: )
1671: IS
1672: l_security_flags ICX_TBL_VARCHAR20;
1673: l_supplier_flags ICX_TBL_VARCHAR20;

Line 1674: l_r12_store_ids ICX_TBL_NUMBER;

1670: )
1671: IS
1672: l_security_flags ICX_TBL_VARCHAR20;
1673: l_supplier_flags ICX_TBL_VARCHAR20;
1674: l_r12_store_ids ICX_TBL_NUMBER;
1675:
1676: l_api_name CONSTANT VARCHAR2(30) := 'migrate_catalogs_no_realms';
1677: l_err_loc PLS_INTEGER;
1678: BEGIN

Line 1693: l_r12_store_ids := ICX_TBL_NUMBER();

1689:
1690: l_supplier_flags := ICX_TBL_VARCHAR20();
1691: l_supplier_flags.extend(p_old_store_ids.COUNT);
1692:
1693: l_r12_store_ids := ICX_TBL_NUMBER();
1694: l_r12_store_ids.extend(p_old_store_ids.COUNT);
1695:
1696: l_err_loc := 100;
1697:

Line 1777: p_resp_with_realms_ids IN ICX_TBL_NUMBER

1773: PROCEDURE migrate_catalog_with_realms
1774: (
1775: p_catalog_id IN NUMBER,
1776: p_old_store_id IN NUMBER,
1777: p_resp_with_realms_ids IN ICX_TBL_NUMBER
1778: )
1779: IS
1780: l_new_zone_ids ICX_TBL_NUMBER;
1781: l_resp_with_realm_values_ids ICX_TBL_NUMBER;

Line 1780: l_new_zone_ids ICX_TBL_NUMBER;

1776: p_old_store_id IN NUMBER,
1777: p_resp_with_realms_ids IN ICX_TBL_NUMBER
1778: )
1779: IS
1780: l_new_zone_ids ICX_TBL_NUMBER;
1781: l_resp_with_realm_values_ids ICX_TBL_NUMBER;
1782: l_resp_without_realms_ids ICX_TBL_NUMBER;
1783:
1784: l_api_name CONSTANT VARCHAR2(30) := 'migrate_catalog_with_realms';

Line 1781: l_resp_with_realm_values_ids ICX_TBL_NUMBER;

1777: p_resp_with_realms_ids IN ICX_TBL_NUMBER
1778: )
1779: IS
1780: l_new_zone_ids ICX_TBL_NUMBER;
1781: l_resp_with_realm_values_ids ICX_TBL_NUMBER;
1782: l_resp_without_realms_ids ICX_TBL_NUMBER;
1783:
1784: l_api_name CONSTANT VARCHAR2(30) := 'migrate_catalog_with_realms';
1785: l_err_loc PLS_INTEGER;

Line 1782: l_resp_without_realms_ids ICX_TBL_NUMBER;

1778: )
1779: IS
1780: l_new_zone_ids ICX_TBL_NUMBER;
1781: l_resp_with_realm_values_ids ICX_TBL_NUMBER;
1782: l_resp_without_realms_ids ICX_TBL_NUMBER;
1783:
1784: l_api_name CONSTANT VARCHAR2(30) := 'migrate_catalog_with_realms';
1785: l_err_loc PLS_INTEGER;
1786: BEGIN

Line 1958: p_item_source_ids IN ICX_TBL_NUMBER,

1954: -- be used when migrating these item sources.
1955: --
1956: PROCEDURE migrate_isrcs_no_realms
1957: (
1958: p_item_source_ids IN ICX_TBL_NUMBER,
1959: p_old_store_ids IN ICX_TBL_NUMBER,
1960: p_new_zone_ids IN ICX_TBL_NUMBER
1961: )
1962: IS

Line 1959: p_old_store_ids IN ICX_TBL_NUMBER,

1955: --
1956: PROCEDURE migrate_isrcs_no_realms
1957: (
1958: p_item_source_ids IN ICX_TBL_NUMBER,
1959: p_old_store_ids IN ICX_TBL_NUMBER,
1960: p_new_zone_ids IN ICX_TBL_NUMBER
1961: )
1962: IS
1963: l_security_flags ICX_TBL_VARCHAR20;

Line 1960: p_new_zone_ids IN ICX_TBL_NUMBER

1956: PROCEDURE migrate_isrcs_no_realms
1957: (
1958: p_item_source_ids IN ICX_TBL_NUMBER,
1959: p_old_store_ids IN ICX_TBL_NUMBER,
1960: p_new_zone_ids IN ICX_TBL_NUMBER
1961: )
1962: IS
1963: l_security_flags ICX_TBL_VARCHAR20;
1964: l_r12_store_ids ICX_TBL_NUMBER;

Line 1964: l_r12_store_ids ICX_TBL_NUMBER;

1960: p_new_zone_ids IN ICX_TBL_NUMBER
1961: )
1962: IS
1963: l_security_flags ICX_TBL_VARCHAR20;
1964: l_r12_store_ids ICX_TBL_NUMBER;
1965:
1966: l_api_name CONSTANT VARCHAR2(30) := 'migrate_isrcs_no_realms';
1967: l_err_loc PLS_INTEGER;
1968: BEGIN

Line 1980: l_r12_store_ids := ICX_TBL_NUMBER();

1976: -- create a corresponding list for each of the flags/ids needed
1977: l_security_flags := ICX_TBL_VARCHAR20();
1978: l_security_flags.extend(p_old_store_ids.COUNT);
1979:
1980: l_r12_store_ids := ICX_TBL_NUMBER();
1981: l_r12_store_ids.extend(p_old_store_ids.COUNT);
1982:
1983: l_err_loc := 100;
1984:

Line 2069: p_resp_with_realms_ids IN ICX_TBL_NUMBER,

2065: PROCEDURE migrate_isrc_with_realms
2066: (
2067: p_item_source_id IN NUMBER,
2068: p_old_store_id IN NUMBER,
2069: p_resp_with_realms_ids IN ICX_TBL_NUMBER,
2070: p_resp_without_realms_ids IN ICX_TBL_NUMBER
2071: )
2072: IS
2073: l_new_zone_ids ICX_TBL_NUMBER;

Line 2070: p_resp_without_realms_ids IN ICX_TBL_NUMBER

2066: (
2067: p_item_source_id IN NUMBER,
2068: p_old_store_id IN NUMBER,
2069: p_resp_with_realms_ids IN ICX_TBL_NUMBER,
2070: p_resp_without_realms_ids IN ICX_TBL_NUMBER
2071: )
2072: IS
2073: l_new_zone_ids ICX_TBL_NUMBER;
2074: l_resp_can_access_ids ICX_TBL_NUMBER;

Line 2073: l_new_zone_ids ICX_TBL_NUMBER;

2069: p_resp_with_realms_ids IN ICX_TBL_NUMBER,
2070: p_resp_without_realms_ids IN ICX_TBL_NUMBER
2071: )
2072: IS
2073: l_new_zone_ids ICX_TBL_NUMBER;
2074: l_resp_can_access_ids ICX_TBL_NUMBER;
2075: l_resps_to_secure_by ICX_TBL_NUMBER;
2076:
2077: l_api_name CONSTANT VARCHAR2(30) := 'migrate_isrc_with_realms';

Line 2074: l_resp_can_access_ids ICX_TBL_NUMBER;

2070: p_resp_without_realms_ids IN ICX_TBL_NUMBER
2071: )
2072: IS
2073: l_new_zone_ids ICX_TBL_NUMBER;
2074: l_resp_can_access_ids ICX_TBL_NUMBER;
2075: l_resps_to_secure_by ICX_TBL_NUMBER;
2076:
2077: l_api_name CONSTANT VARCHAR2(30) := 'migrate_isrc_with_realms';
2078: l_err_loc PLS_INTEGER;

Line 2075: l_resps_to_secure_by ICX_TBL_NUMBER;

2071: )
2072: IS
2073: l_new_zone_ids ICX_TBL_NUMBER;
2074: l_resp_can_access_ids ICX_TBL_NUMBER;
2075: l_resps_to_secure_by ICX_TBL_NUMBER;
2076:
2077: l_api_name CONSTANT VARCHAR2(30) := 'migrate_isrc_with_realms';
2078: l_err_loc PLS_INTEGER;
2079: BEGIN

Line 2089: l_resps_to_secure_by := ICX_TBL_NUMBER();

2085: l_err_loc := 0;
2086:
2087: -- keep a running list of responsibilities that will be secured against
2088: -- this migrated "item source" content zone
2089: l_resps_to_secure_by := ICX_TBL_NUMBER();
2090:
2091: IF (g_item_sources_to_resp_map.EXISTS(p_item_source_id)) THEN
2092:
2093: -- retrieve list of responsibilities that can access this item source

Line 2217: l_template_ids ICX_TBL_NUMBER;

2213: -- be used when migrating these item sources.
2214: --
2215: PROCEDURE migrate_templates
2216: IS
2217: l_template_ids ICX_TBL_NUMBER;
2218: l_old_store_ids ICX_TBL_NUMBER;
2219: l_r12_store_ids ICX_TBL_NUMBER;
2220:
2221: l_api_name CONSTANT VARCHAR2(30) := 'migrate_templates';

Line 2218: l_old_store_ids ICX_TBL_NUMBER;

2214: --
2215: PROCEDURE migrate_templates
2216: IS
2217: l_template_ids ICX_TBL_NUMBER;
2218: l_old_store_ids ICX_TBL_NUMBER;
2219: l_r12_store_ids ICX_TBL_NUMBER;
2220:
2221: l_api_name CONSTANT VARCHAR2(30) := 'migrate_templates';
2222: l_err_loc PLS_INTEGER;

Line 2219: l_r12_store_ids ICX_TBL_NUMBER;

2215: PROCEDURE migrate_templates
2216: IS
2217: l_template_ids ICX_TBL_NUMBER;
2218: l_old_store_ids ICX_TBL_NUMBER;
2219: l_r12_store_ids ICX_TBL_NUMBER;
2220:
2221: l_api_name CONSTANT VARCHAR2(30) := 'migrate_templates';
2222: l_err_loc PLS_INTEGER;
2223: BEGIN

Line 2244: l_r12_store_ids := ICX_TBL_NUMBER();

2240: AND templates.template_id <> 10000000;
2241:
2242: l_err_loc := 100;
2243:
2244: l_r12_store_ids := ICX_TBL_NUMBER();
2245: l_r12_store_ids.extend(l_template_ids.COUNT);
2246:
2247: l_err_loc := 200;
2248:

Line 2398: l_store_ids ICX_TBL_NUMBER;

2394: -- here, as it will be taken of specially if realms need to be considered.
2395: --
2396: PROCEDURE populate_store_security_flags
2397: IS
2398: l_store_ids ICX_TBL_NUMBER;
2399: l_security_flags ICX_TBL_VARCHAR20;
2400:
2401: l_api_name CONSTANT VARCHAR2(30) := 'populate_store_security_flags';
2402: l_err_loc PLS_INTEGER;

Line 2458: l_sources_ids ICX_TBL_NUMBER;

2454: -- catalog which is handled by the decode.
2455: --
2456: PROCEDURE populate_catalog_supplr_flags
2457: IS
2458: l_sources_ids ICX_TBL_NUMBER;
2459: l_supplier_flags ICX_TBL_VARCHAR20;
2460:
2461: l_api_name CONSTANT VARCHAR2(30) := 'populate_catalog_supplr_flags';
2462: l_err_loc PLS_INTEGER;

Line 2519: l_operator_ids ICX_TBL_NUMBER;

2515: -- details table (icx_cat_punchout_details).
2516: --
2517: PROCEDURE populate_operator_id_list
2518: IS
2519: l_operator_ids ICX_TBL_NUMBER;
2520:
2521: l_api_name CONSTANT VARCHAR2(30) := 'populate_operator_id_list';
2522: l_err_loc PLS_INTEGER;
2523: BEGIN

Line 2596: x_old_content_ids OUT NOCOPY ICX_TBL_NUMBER,

2592: PROCEDURE get_contents_to_migrate
2593: (
2594: p_catalogs_migrated IN BOOLEAN,
2595: p_item_sources_migrated IN BOOLEAN,
2596: x_old_content_ids OUT NOCOPY ICX_TBL_NUMBER,
2597: x_content_types OUT NOCOPY ICX_TBL_VARCHAR15,
2598: x_old_store_ids OUT NOCOPY ICX_TBL_NUMBER
2599: )
2600: IS

Line 2598: x_old_store_ids OUT NOCOPY ICX_TBL_NUMBER

2594: p_catalogs_migrated IN BOOLEAN,
2595: p_item_sources_migrated IN BOOLEAN,
2596: x_old_content_ids OUT NOCOPY ICX_TBL_NUMBER,
2597: x_content_types OUT NOCOPY ICX_TBL_VARCHAR15,
2598: x_old_store_ids OUT NOCOPY ICX_TBL_NUMBER
2599: )
2600: IS
2601: l_api_name CONSTANT VARCHAR2(30) := 'get_contents_to_migrate';
2602: l_err_loc PLS_INTEGER;

Line 2706: l_old_store_ids ICX_TBL_NUMBER;

2702: -- to new R12 store IDs will be populated.
2703: --
2704: PROCEDURE create_R12_stores
2705: IS
2706: l_old_store_ids ICX_TBL_NUMBER;
2707: l_r12_store_ids ICX_TBL_NUMBER;
2708:
2709: l_api_name CONSTANT VARCHAR2(30) := 'create_R12_stores';
2710: l_err_loc PLS_INTEGER;

Line 2707: l_r12_store_ids ICX_TBL_NUMBER;

2703: --
2704: PROCEDURE create_R12_stores
2705: IS
2706: l_old_store_ids ICX_TBL_NUMBER;
2707: l_r12_store_ids ICX_TBL_NUMBER;
2708:
2709: l_api_name CONSTANT VARCHAR2(30) := 'create_R12_stores';
2710: l_err_loc PLS_INTEGER;
2711: l_old_store_key NUMBER;

Line 2807: p_zone_ids IN ICX_TBL_NUMBER,

2803: -- @param p_old_store_id The 11.5.10 Store ID corresponding to the R12 store.
2804: --
2805: PROCEDURE add_zones_to_store
2806: (
2807: p_zone_ids IN ICX_TBL_NUMBER,
2808: p_r12_store_id IN NUMBER,
2809: p_old_source_id IN NUMBER,
2810: p_old_store_id IN NUMBER
2811: )

Line 2882: p_zone_ids IN ICX_TBL_NUMBER,

2878: -- @param p_old_store_ids The 11.5.10 Stores corresponding to the R12 Stores.
2879: --
2880: PROCEDURE add_zones_to_stores
2881: (
2882: p_zone_ids IN ICX_TBL_NUMBER,
2883: p_r12_store_ids IN ICX_TBL_NUMBER,
2884: p_old_source_ids IN ICX_TBL_NUMBER,
2885: p_old_store_ids IN ICX_TBL_NUMBER
2886: )

Line 2883: p_r12_store_ids IN ICX_TBL_NUMBER,

2879: --
2880: PROCEDURE add_zones_to_stores
2881: (
2882: p_zone_ids IN ICX_TBL_NUMBER,
2883: p_r12_store_ids IN ICX_TBL_NUMBER,
2884: p_old_source_ids IN ICX_TBL_NUMBER,
2885: p_old_store_ids IN ICX_TBL_NUMBER
2886: )
2887: IS

Line 2884: p_old_source_ids IN ICX_TBL_NUMBER,

2880: PROCEDURE add_zones_to_stores
2881: (
2882: p_zone_ids IN ICX_TBL_NUMBER,
2883: p_r12_store_ids IN ICX_TBL_NUMBER,
2884: p_old_source_ids IN ICX_TBL_NUMBER,
2885: p_old_store_ids IN ICX_TBL_NUMBER
2886: )
2887: IS
2888: l_api_name CONSTANT VARCHAR2(30) := 'add_zones_to_stores';

Line 2885: p_old_store_ids IN ICX_TBL_NUMBER

2881: (
2882: p_zone_ids IN ICX_TBL_NUMBER,
2883: p_r12_store_ids IN ICX_TBL_NUMBER,
2884: p_old_source_ids IN ICX_TBL_NUMBER,
2885: p_old_store_ids IN ICX_TBL_NUMBER
2886: )
2887: IS
2888: l_api_name CONSTANT VARCHAR2(30) := 'add_zones_to_stores';
2889: l_err_loc PLS_INTEGER;

Line 2962: p_smart_form_ids IN ICX_TBL_NUMBER,

2958: -- @param p_old_store_ids The corresponding 11.5.10 store IDs.
2959: --
2960: PROCEDURE add_smart_forms_to_stores
2961: (
2962: p_smart_form_ids IN ICX_TBL_NUMBER,
2963: p_r12_store_ids IN ICX_TBL_NUMBER,
2964: p_old_store_ids IN ICX_TBL_NUMBER
2965: )
2966: IS

Line 2963: p_r12_store_ids IN ICX_TBL_NUMBER,

2959: --
2960: PROCEDURE add_smart_forms_to_stores
2961: (
2962: p_smart_form_ids IN ICX_TBL_NUMBER,
2963: p_r12_store_ids IN ICX_TBL_NUMBER,
2964: p_old_store_ids IN ICX_TBL_NUMBER
2965: )
2966: IS
2967: l_api_name CONSTANT VARCHAR2(30) := 'add_smart_forms_to_stores';

Line 2964: p_old_store_ids IN ICX_TBL_NUMBER

2960: PROCEDURE add_smart_forms_to_stores
2961: (
2962: p_smart_form_ids IN ICX_TBL_NUMBER,
2963: p_r12_store_ids IN ICX_TBL_NUMBER,
2964: p_old_store_ids IN ICX_TBL_NUMBER
2965: )
2966: IS
2967: l_api_name CONSTANT VARCHAR2(30) := 'add_smart_forms_to_stores';
2968: l_err_loc PLS_INTEGER;

Line 3031: RETURN ICX_TBL_NUMBER

3027: FUNCTION get_new_zone_ids
3028: (
3029: p_num_zones IN NUMBER
3030: )
3031: RETURN ICX_TBL_NUMBER
3032: IS
3033: l_new_zone_ids ICX_TBL_NUMBER;
3034: l_api_name CONSTANT VARCHAR2(30) := 'get_new_zone_ids';
3035: l_err_loc PLS_INTEGER;

Line 3033: l_new_zone_ids ICX_TBL_NUMBER;

3029: p_num_zones IN NUMBER
3030: )
3031: RETURN ICX_TBL_NUMBER
3032: IS
3033: l_new_zone_ids ICX_TBL_NUMBER;
3034: l_api_name CONSTANT VARCHAR2(30) := 'get_new_zone_ids';
3035: l_err_loc PLS_INTEGER;
3036: BEGIN
3037:

Line 3045: l_new_zone_ids := ICX_TBL_NUMBER();

3041: END IF;
3042:
3043: l_err_loc := 0;
3044:
3045: l_new_zone_ids := ICX_TBL_NUMBER();
3046: l_new_zone_ids.extend(p_num_zones);
3047:
3048: FOR i IN 1..p_num_zones LOOP
3049:

Line 3117: p_new_zone_ids IN ICX_TBL_NUMBER,

3113: -- Please see top level note for details into the valid values of these flags.
3114: --
3115: PROCEDURE create_local_zones
3116: (
3117: p_new_zone_ids IN ICX_TBL_NUMBER,
3118: p_catalog_id IN NUMBER,
3119: p_security_flag IN VARCHAR2,
3120: p_supplier_flag IN VARCHAR2,
3121: p_category_flag IN VARCHAR2

Line 3124: l_catalog_ids ICX_TBL_NUMBER;

3120: p_supplier_flag IN VARCHAR2,
3121: p_category_flag IN VARCHAR2
3122: )
3123: IS
3124: l_catalog_ids ICX_TBL_NUMBER;
3125: l_security_flags ICX_TBL_VARCHAR20;
3126: l_supplier_flags ICX_TBL_VARCHAR20;
3127:
3128: l_api_name CONSTANT VARCHAR2(30) := 'create_local_zones';

Line 3144: l_catalog_ids := ICX_TBL_NUMBER();

3140:
3141: l_supplier_flags := ICX_TBL_VARCHAR20();
3142: l_supplier_flags.extend(p_new_zone_ids.COUNT);
3143:
3144: l_catalog_ids := ICX_TBL_NUMBER();
3145: l_catalog_ids.extend(p_new_zone_ids.COUNT);
3146:
3147: FOR i IN 1..p_new_zone_ids.COUNT LOOP
3148:

Line 3208: p_new_zone_ids IN ICX_TBL_NUMBER,

3204: -- Please see top level note for details into the valid values of these flags.
3205: --
3206: PROCEDURE create_local_zones
3207: (
3208: p_new_zone_ids IN ICX_TBL_NUMBER,
3209: p_catalog_ids IN ICX_TBL_NUMBER,
3210: p_security_flags IN ICX_TBL_VARCHAR20,
3211: p_supplier_flags IN ICX_TBL_VARCHAR20,
3212: p_category_flag IN VARCHAR2

Line 3209: p_catalog_ids IN ICX_TBL_NUMBER,

3205: --
3206: PROCEDURE create_local_zones
3207: (
3208: p_new_zone_ids IN ICX_TBL_NUMBER,
3209: p_catalog_ids IN ICX_TBL_NUMBER,
3210: p_security_flags IN ICX_TBL_VARCHAR20,
3211: p_supplier_flags IN ICX_TBL_VARCHAR20,
3212: p_category_flag IN VARCHAR2
3213: )

Line 3321: p_new_zone_ids IN ICX_TBL_NUMBER,

3317: -- Please see top level note for details into the valid values of these flags.
3318: --
3319: PROCEDURE create_local_all_content_zones
3320: (
3321: p_new_zone_ids IN ICX_TBL_NUMBER,
3322: p_category_flag IN VARCHAR2
3323: )
3324: IS
3325: l_api_name CONSTANT VARCHAR2(30) := 'create_local_all_content_zones';

Line 3404: p_new_zone_ids IN ICX_TBL_NUMBER,

3400: -- restrictions will be based.
3401: --
3402: PROCEDURE add_resp_categories_to_zone
3403: (
3404: p_new_zone_ids IN ICX_TBL_NUMBER,
3405: p_resp_ids IN ICX_TBL_NUMBER
3406: )
3407: IS
3408: l_current_zone_id NUMBER;

Line 3405: p_resp_ids IN ICX_TBL_NUMBER

3401: --
3402: PROCEDURE add_resp_categories_to_zone
3403: (
3404: p_new_zone_ids IN ICX_TBL_NUMBER,
3405: p_resp_ids IN ICX_TBL_NUMBER
3406: )
3407: IS
3408: l_current_zone_id NUMBER;
3409: l_category_ids ICX_TBL_NUMBER;

Line 3409: l_category_ids ICX_TBL_NUMBER;

3405: p_resp_ids IN ICX_TBL_NUMBER
3406: )
3407: IS
3408: l_current_zone_id NUMBER;
3409: l_category_ids ICX_TBL_NUMBER;
3410:
3411: l_zones_to_insert ICX_TBL_NUMBER;
3412: l_categories_to_insert ICX_TBL_NUMBER;
3413:

Line 3411: l_zones_to_insert ICX_TBL_NUMBER;

3407: IS
3408: l_current_zone_id NUMBER;
3409: l_category_ids ICX_TBL_NUMBER;
3410:
3411: l_zones_to_insert ICX_TBL_NUMBER;
3412: l_categories_to_insert ICX_TBL_NUMBER;
3413:
3414: l_api_name CONSTANT VARCHAR2(30) := 'add_resp_categories_to_zone';
3415: l_err_loc PLS_INTEGER;

Line 3412: l_categories_to_insert ICX_TBL_NUMBER;

3408: l_current_zone_id NUMBER;
3409: l_category_ids ICX_TBL_NUMBER;
3410:
3411: l_zones_to_insert ICX_TBL_NUMBER;
3412: l_categories_to_insert ICX_TBL_NUMBER;
3413:
3414: l_api_name CONSTANT VARCHAR2(30) := 'add_resp_categories_to_zone';
3415: l_err_loc PLS_INTEGER;
3416: BEGIN

Line 3424: l_zones_to_insert := ICX_TBL_NUMBER();

3420: END IF;
3421:
3422: l_err_loc := 0;
3423:
3424: l_zones_to_insert := ICX_TBL_NUMBER();
3425: l_categories_to_insert := ICX_TBL_NUMBER();
3426:
3427: l_err_loc := 100;
3428:

Line 3425: l_categories_to_insert := ICX_TBL_NUMBER();

3421:
3422: l_err_loc := 0;
3423:
3424: l_zones_to_insert := ICX_TBL_NUMBER();
3425: l_categories_to_insert := ICX_TBL_NUMBER();
3426:
3427: l_err_loc := 100;
3428:
3429: FOR i IN 1..p_new_zone_ids.COUNT LOOP

Line 3516: p_new_zone_ids IN ICX_TBL_NUMBER,

3512: -- Please see top level note for details into the valid values of these flags.
3513: --
3514: PROCEDURE create_item_source_zones
3515: (
3516: p_new_zone_ids IN ICX_TBL_NUMBER,
3517: p_item_source_id IN NUMBER,
3518: p_security_flag IN VARCHAR2
3519: )
3520: IS

Line 3521: l_item_source_ids ICX_TBL_NUMBER;

3517: p_item_source_id IN NUMBER,
3518: p_security_flag IN VARCHAR2
3519: )
3520: IS
3521: l_item_source_ids ICX_TBL_NUMBER;
3522: l_security_flags ICX_TBL_VARCHAR20;
3523: l_api_name CONSTANT VARCHAR2(30) := 'create_item_source_zones';
3524: l_err_loc PLS_INTEGER;
3525: BEGIN

Line 3533: l_item_source_ids := ICX_TBL_NUMBER();

3529: END IF;
3530:
3531: l_err_loc := 0;
3532:
3533: l_item_source_ids := ICX_TBL_NUMBER();
3534: l_item_source_ids.extend(p_new_zone_ids.COUNT);
3535:
3536: l_security_flags := ICX_TBL_VARCHAR20();
3537: l_security_flags.extend(p_new_zone_ids.COUNT);

Line 3588: p_new_zone_ids IN ICX_TBL_NUMBER,

3584: -- Please see top level note for details into the valid values of these flags.
3585: --
3586: PROCEDURE create_item_source_zones
3587: (
3588: p_new_zone_ids IN ICX_TBL_NUMBER,
3589: p_item_source_ids IN ICX_TBL_NUMBER,
3590: p_security_flags IN ICX_TBL_VARCHAR20
3591: )
3592: IS

Line 3589: p_item_source_ids IN ICX_TBL_NUMBER,

3585: --
3586: PROCEDURE create_item_source_zones
3587: (
3588: p_new_zone_ids IN ICX_TBL_NUMBER,
3589: p_item_source_ids IN ICX_TBL_NUMBER,
3590: p_security_flags IN ICX_TBL_VARCHAR20
3591: )
3592: IS
3593: l_encrypted_password VARCHAR2(100); -- length in icx_por_item_sources

Line 3770: l_old_operator_ids ICX_TBL_NUMBER;

3766: -- upgrading of item source catalogs from pre-R12.
3767: --
3768: PROCEDURE update_exchange_punchouts
3769: IS
3770: l_old_operator_ids ICX_TBL_NUMBER;
3771: l_new_parent_ids ICX_TBL_NUMBER;
3772:
3773: l_api_name CONSTANT VARCHAR2(30) := 'update_exchange_punchouts';
3774: l_err_loc PLS_INTEGER;

Line 3771: l_new_parent_ids ICX_TBL_NUMBER;

3767: --
3768: PROCEDURE update_exchange_punchouts
3769: IS
3770: l_old_operator_ids ICX_TBL_NUMBER;
3771: l_new_parent_ids ICX_TBL_NUMBER;
3772:
3773: l_api_name CONSTANT VARCHAR2(30) := 'update_exchange_punchouts';
3774: l_err_loc PLS_INTEGER;
3775: BEGIN

Line 3791: l_new_parent_ids := ICX_TBL_NUMBER();

3787: WHERE operator_id IS NOT NULL;
3788: l_err_loc := 100;
3789:
3790: -- create a list of the new zones IDs which will replace old operator IDs
3791: l_new_parent_ids := ICX_TBL_NUMBER();
3792: l_new_parent_ids.extend(l_old_operator_ids.COUNT);
3793: l_err_loc := 200;
3794:
3795: -- populate the list from mapping created when creating the content zones

Line 3862: p_new_zone_ids IN ICX_TBL_NUMBER,

3858: -- not require adding any relationships (is skipped).
3859: --
3860: PROCEDURE secure_zones_by_store_orgs
3861: (
3862: p_new_zone_ids IN ICX_TBL_NUMBER,
3863: p_old_store_ids IN ICX_TBL_NUMBER,
3864: p_security_flags IN ICX_TBL_VARCHAR20
3865: )
3866: IS

Line 3863: p_old_store_ids IN ICX_TBL_NUMBER,

3859: --
3860: PROCEDURE secure_zones_by_store_orgs
3861: (
3862: p_new_zone_ids IN ICX_TBL_NUMBER,
3863: p_old_store_ids IN ICX_TBL_NUMBER,
3864: p_security_flags IN ICX_TBL_VARCHAR20
3865: )
3866: IS
3867: l_api_name CONSTANT VARCHAR2(30) := 'secure_zones_by_store_orgs';

Line 3933: p_new_zone_ids IN ICX_TBL_NUMBER,

3929: -- @param p_resp_ids List of the corresponding responsibilities to secure by.
3930: --
3931: PROCEDURE secure_zones_by_resps
3932: (
3933: p_new_zone_ids IN ICX_TBL_NUMBER,
3934: p_resp_ids IN ICX_TBL_NUMBER
3935: )
3936: IS
3937: l_api_name CONSTANT VARCHAR2(30) := 'secure_zones_by_resps';

Line 3934: p_resp_ids IN ICX_TBL_NUMBER

3930: --
3931: PROCEDURE secure_zones_by_resps
3932: (
3933: p_new_zone_ids IN ICX_TBL_NUMBER,
3934: p_resp_ids IN ICX_TBL_NUMBER
3935: )
3936: IS
3937: l_api_name CONSTANT VARCHAR2(30) := 'secure_zones_by_resps';
3938: l_err_loc PLS_INTEGER;

Line 3999: p_resp_ids IN ICX_TBL_NUMBER

3995: --
3996: PROCEDURE secure_zone_by_resps
3997: (
3998: p_new_zone_id IN NUMBER,
3999: p_resp_ids IN ICX_TBL_NUMBER
4000: )
4001: IS
4002: l_new_zone_ids ICX_TBL_NUMBER;
4003: l_api_name CONSTANT VARCHAR2(30) := 'secure_zone_by_resps';

Line 4002: l_new_zone_ids ICX_TBL_NUMBER;

3998: p_new_zone_id IN NUMBER,
3999: p_resp_ids IN ICX_TBL_NUMBER
4000: )
4001: IS
4002: l_new_zone_ids ICX_TBL_NUMBER;
4003: l_api_name CONSTANT VARCHAR2(30) := 'secure_zone_by_resps';
4004: l_err_loc PLS_INTEGER;
4005: BEGIN
4006:

Line 4014: l_new_zone_ids := ICX_TBL_NUMBER();

4010: END IF;
4011:
4012: l_err_loc := 0;
4013:
4014: l_new_zone_ids := ICX_TBL_NUMBER();
4015: l_new_zone_ids.extend(p_resp_ids.COUNT);
4016:
4017: l_err_loc := 100;
4018:

Line 4053: l_item_source_ids ICX_TBL_NUMBER;

4049: -- populated. This is done via populate_resp_with_isrc_realms().
4050: --
4051: PROCEDURE populate_isrcs_to_resp_map
4052: IS
4053: l_item_source_ids ICX_TBL_NUMBER;
4054: l_resp_list_ids ICX_TBL_NUMBER;
4055:
4056: l_api_name CONSTANT VARCHAR2(30) := 'populate_isrcs_to_resp_map';
4057: l_err_loc PLS_INTEGER;

Line 4054: l_resp_list_ids ICX_TBL_NUMBER;

4050: --
4051: PROCEDURE populate_isrcs_to_resp_map
4052: IS
4053: l_item_source_ids ICX_TBL_NUMBER;
4054: l_resp_list_ids ICX_TBL_NUMBER;
4055:
4056: l_api_name CONSTANT VARCHAR2(30) := 'populate_isrcs_to_resp_map';
4057: l_err_loc PLS_INTEGER;
4058: l_isrc_key NUMBER;

Line 4088: l_resp_list_ids := ICX_TBL_NUMBER();

4084: END IF;
4085:
4086: ELSE
4087:
4088: l_resp_list_ids := ICX_TBL_NUMBER();
4089: l_err_loc := 300;
4090:
4091: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4092: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 4165: RETURN ICX_TBL_NUMBER

4161: FUNCTION get_catr_realm_values_cached
4162: (
4163: p_resp_id IN NUMBER
4164: )
4165: RETURN ICX_TBL_NUMBER
4166: IS
4167: l_realm_values ICX_TBL_NUMBER;
4168: l_api_name CONSTANT VARCHAR2(30) := 'get_catr_realm_values_cached';
4169: l_err_loc PLS_INTEGER;

Line 4167: l_realm_values ICX_TBL_NUMBER;

4163: p_resp_id IN NUMBER
4164: )
4165: RETURN ICX_TBL_NUMBER
4166: IS
4167: l_realm_values ICX_TBL_NUMBER;
4168: l_api_name CONSTANT VARCHAR2(30) := 'get_catr_realm_values_cached';
4169: l_err_loc PLS_INTEGER;
4170: BEGIN
4171:

Line 4235: RETURN ICX_TBL_NUMBER

4231: (
4232: p_resp_id IN NUMBER,
4233: p_realm_type IN VARCHAR2
4234: )
4235: RETURN ICX_TBL_NUMBER
4236: IS
4237: l_realm_values ICX_TBL_NUMBER;
4238: l_api_name CONSTANT VARCHAR2(30) := 'get_realm_values_for_resp';
4239: l_err_loc PLS_INTEGER;

Line 4237: l_realm_values ICX_TBL_NUMBER;

4233: p_realm_type IN VARCHAR2
4234: )
4235: RETURN ICX_TBL_NUMBER
4236: IS
4237: l_realm_values ICX_TBL_NUMBER;
4238: l_api_name CONSTANT VARCHAR2(30) := 'get_realm_values_for_resp';
4239: l_err_loc PLS_INTEGER;
4240: BEGIN
4241:

Line 4309: p_resp_with_realms_ids IN ICX_TBL_NUMBER

4305: -- @return List of responsibilities with realms and have categories values.
4306: --
4307: FUNCTION filter_out_no_category_resps
4308: (
4309: p_resp_with_realms_ids IN ICX_TBL_NUMBER
4310: )
4311: RETURN ICX_TBL_NUMBER
4312: IS
4313: l_resp_with_realm_values_ids ICX_TBL_NUMBER;

Line 4311: RETURN ICX_TBL_NUMBER

4307: FUNCTION filter_out_no_category_resps
4308: (
4309: p_resp_with_realms_ids IN ICX_TBL_NUMBER
4310: )
4311: RETURN ICX_TBL_NUMBER
4312: IS
4313: l_resp_with_realm_values_ids ICX_TBL_NUMBER;
4314: l_category_ids ICX_TBL_NUMBER;
4315:

Line 4313: l_resp_with_realm_values_ids ICX_TBL_NUMBER;

4309: p_resp_with_realms_ids IN ICX_TBL_NUMBER
4310: )
4311: RETURN ICX_TBL_NUMBER
4312: IS
4313: l_resp_with_realm_values_ids ICX_TBL_NUMBER;
4314: l_category_ids ICX_TBL_NUMBER;
4315:
4316: l_api_name CONSTANT VARCHAR2(30) := 'filter_out_no_category_resps';
4317: l_err_loc PLS_INTEGER;

Line 4314: l_category_ids ICX_TBL_NUMBER;

4310: )
4311: RETURN ICX_TBL_NUMBER
4312: IS
4313: l_resp_with_realm_values_ids ICX_TBL_NUMBER;
4314: l_category_ids ICX_TBL_NUMBER;
4315:
4316: l_api_name CONSTANT VARCHAR2(30) := 'filter_out_no_category_resps';
4317: l_err_loc PLS_INTEGER;
4318: BEGIN

Line 4324: l_resp_with_realm_values_ids := ICX_TBL_NUMBER();

4320: l_err_loc := 0;
4321:
4322: -- initialize as BULK COLLECT will always initialize variables, so keep this
4323: -- consistent so we can check COUNT rather than NULL to determine emptyness
4324: l_resp_with_realm_values_ids := ICX_TBL_NUMBER();
4325:
4326: FOR i IN 1..p_resp_with_realms_ids.COUNT LOOP
4327:
4328: l_category_ids :=

Line 4389: RETURN ICX_TBL_NUMBER

4385: FUNCTION get_all_resps_with_realms
4386: (
4387: p_realm_type IN VARCHAR2
4388: )
4389: RETURN ICX_TBL_NUMBER
4390: IS
4391: l_all_resp_with_realms_ids ICX_TBL_NUMBER;
4392: l_api_name CONSTANT VARCHAR2(30) := 'get_all_resps_with_realms';
4393: l_err_loc PLS_INTEGER;

Line 4391: l_all_resp_with_realms_ids ICX_TBL_NUMBER;

4387: p_realm_type IN VARCHAR2
4388: )
4389: RETURN ICX_TBL_NUMBER
4390: IS
4391: l_all_resp_with_realms_ids ICX_TBL_NUMBER;
4392: l_api_name CONSTANT VARCHAR2(30) := 'get_all_resps_with_realms';
4393: l_err_loc PLS_INTEGER;
4394: BEGIN
4395:

Line 4473: RETURN ICX_TBL_NUMBER

4469: FUNCTION get_all_resps_without_realms
4470: (
4471: p_realm_type IN VARCHAR2
4472: )
4473: RETURN ICX_TBL_NUMBER
4474: IS
4475: l_all_resp_without_realms_ids ICX_TBL_NUMBER;
4476: l_api_name CONSTANT VARCHAR2(30) := 'get_all_resps_without_realms';
4477: l_err_loc PLS_INTEGER;

Line 4475: l_all_resp_without_realms_ids ICX_TBL_NUMBER;

4471: p_realm_type IN VARCHAR2
4472: )
4473: RETURN ICX_TBL_NUMBER
4474: IS
4475: l_all_resp_without_realms_ids ICX_TBL_NUMBER;
4476: l_api_name CONSTANT VARCHAR2(30) := 'get_all_resps_without_realms';
4477: l_err_loc PLS_INTEGER;
4478: BEGIN
4479:

Line 4568: RETURN ICX_TBL_NUMBER

4564: (
4565: p_realm_type IN VARCHAR2,
4566: p_old_store_id IN NUMBER
4567: )
4568: RETURN ICX_TBL_NUMBER
4569: IS
4570: l_resp_with_realms_ids ICX_TBL_NUMBER;
4571: l_api_name CONSTANT VARCHAR2(30) := 'get_resps_with_realms_store';
4572: l_err_loc PLS_INTEGER;

Line 4570: l_resp_with_realms_ids ICX_TBL_NUMBER;

4566: p_old_store_id IN NUMBER
4567: )
4568: RETURN ICX_TBL_NUMBER
4569: IS
4570: l_resp_with_realms_ids ICX_TBL_NUMBER;
4571: l_api_name CONSTANT VARCHAR2(30) := 'get_resps_with_realms_store';
4572: l_err_loc PLS_INTEGER;
4573: BEGIN
4574:

Line 4698: RETURN ICX_TBL_NUMBER

4694: (
4695: p_realm_type IN VARCHAR2,
4696: p_old_store_id IN NUMBER
4697: )
4698: RETURN ICX_TBL_NUMBER
4699: IS
4700: l_resp_without_realms_ids ICX_TBL_NUMBER;
4701: l_api_name CONSTANT VARCHAR2(30) := 'get_resps_without_realms_store';
4702: l_err_loc PLS_INTEGER;

Line 4700: l_resp_without_realms_ids ICX_TBL_NUMBER;

4696: p_old_store_id IN NUMBER
4697: )
4698: RETURN ICX_TBL_NUMBER
4699: IS
4700: l_resp_without_realms_ids ICX_TBL_NUMBER;
4701: l_api_name CONSTANT VARCHAR2(30) := 'get_resps_without_realms_store';
4702: l_err_loc PLS_INTEGER;
4703: BEGIN
4704: