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_VARCHAR20

Line 1672: l_security_flags ICX_TBL_VARCHAR20;

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;
1674: l_r12_store_ids ICX_TBL_NUMBER;
1675:
1676: l_api_name CONSTANT VARCHAR2(30) := 'migrate_catalogs_no_realms';

Line 1673: l_supplier_flags ICX_TBL_VARCHAR20;

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;
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;

Line 1687: l_security_flags := ICX_TBL_VARCHAR20();

1683:
1684: l_err_loc := 0;
1685:
1686: -- create a corresponding list for each of the flags/ids needed
1687: l_security_flags := ICX_TBL_VARCHAR20();
1688: l_security_flags.extend(p_old_store_ids.COUNT);
1689:
1690: l_supplier_flags := ICX_TBL_VARCHAR20();
1691: l_supplier_flags.extend(p_old_store_ids.COUNT);

Line 1690: l_supplier_flags := ICX_TBL_VARCHAR20();

1686: -- create a corresponding list for each of the flags/ids needed
1687: l_security_flags := ICX_TBL_VARCHAR20();
1688: l_security_flags.extend(p_old_store_ids.COUNT);
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);

Line 1963: l_security_flags ICX_TBL_VARCHAR20;

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;
1965:
1966: l_api_name CONSTANT VARCHAR2(30) := 'migrate_isrcs_no_realms';
1967: l_err_loc PLS_INTEGER;

Line 1977: l_security_flags := ICX_TBL_VARCHAR20();

1973:
1974: l_err_loc := 0;
1975:
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);

Line 2399: l_security_flags ICX_TBL_VARCHAR20;

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;
2403: BEGIN

Line 2459: l_supplier_flags ICX_TBL_VARCHAR20;

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;
2463: BEGIN

Line 3125: l_security_flags ICX_TBL_VARCHAR20;

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';
3129: l_err_loc PLS_INTEGER;

Line 3126: l_supplier_flags ICX_TBL_VARCHAR20;

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';
3129: l_err_loc PLS_INTEGER;
3130: BEGIN

Line 3138: l_security_flags := ICX_TBL_VARCHAR20();

3134: END IF;
3135:
3136: l_err_loc := 0;
3137:
3138: l_security_flags := ICX_TBL_VARCHAR20();
3139: l_security_flags.extend(p_new_zone_ids.COUNT);
3140:
3141: l_supplier_flags := ICX_TBL_VARCHAR20();
3142: l_supplier_flags.extend(p_new_zone_ids.COUNT);

Line 3141: l_supplier_flags := ICX_TBL_VARCHAR20();

3137:
3138: l_security_flags := ICX_TBL_VARCHAR20();
3139: l_security_flags.extend(p_new_zone_ids.COUNT);
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);

Line 3210: p_security_flags IN ICX_TBL_VARCHAR20,

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: )
3214: IS

Line 3211: p_supplier_flags IN ICX_TBL_VARCHAR20,

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: )
3214: IS
3215: l_api_name CONSTANT VARCHAR2(30) := 'create_local_zones';

Line 3522: l_security_flags ICX_TBL_VARCHAR20;

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
3526:

Line 3536: l_security_flags := ICX_TBL_VARCHAR20();

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);
3538:
3539: l_err_loc := 100;
3540:

Line 3590: p_security_flags IN ICX_TBL_VARCHAR20

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
3594: l_decrypted_password VARCHAR2(2048); -- length in icx_call decrypt method

Line 3864: p_security_flags IN ICX_TBL_VARCHAR20

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';
3868: l_err_loc PLS_INTEGER;