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_POR_ITEM_SOURCES

Line 294: AND object_name = 'ICX_POR_ITEM_SOURCES';

290: SELECT 1
291: INTO exists_catalogs_data
292: FROM all_objects
293: WHERE owner = l_icx_schema_name
294: AND object_name = 'ICX_POR_ITEM_SOURCES';
295: l_err_loc := 200;
296:
297: SELECT 1
298: INTO exists_catalogs_data

Line 299: FROM icx_por_item_sources

295: l_err_loc := 200;
296:
297: SELECT 1
298: INTO exists_catalogs_data
299: FROM icx_por_item_sources
300: WHERE rownum = 1;
301: l_err_loc := 300;
302:
303: EXCEPTION

Line 618: FROM icx_por_item_sources_tl

614:
615: DELETE FROM icx_cat_content_zones_tl
616: WHERE zone_id = 2
617: AND EXISTS (SELECT 1
618: FROM icx_por_item_sources_tl
619: WHERE item_source_id = 10000001);
620: l_err_loc := 100;
621:
622: INSERT INTO icx_cat_content_zones_tl

Line 629: FROM icx_por_item_sources_tl

625: last_update_login)
626: SELECT 2, language, source_lang, item_source_name, description,
627: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
628: fnd_global.login_id
629: FROM icx_por_item_sources_tl
630: WHERE item_source_id = 10000001;
631: l_err_loc := 200;
632:
633: -- check for the existence of local catalogs (meaning 11.5.9 and later)

Line 1257: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc

1253: l_err_loc := 0;
1254:
1255: SELECT sources.item_source_id, sc.store_id, ICX_CAT_CONTENT_ZONES_S.NEXTVAL
1256: BULK COLLECT INTO l_catalog_ids, l_store_ids, l_new_zone_ids
1257: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc
1258: WHERE sources.type = 'LOCAL'
1259: AND sources.item_source_id = sc.item_source_id(+);
1260: l_err_loc := 100;
1261:

Line 1304: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc

1300: l_err_loc := 0;
1301:
1302: SELECT sources.item_source_id, sc.store_id, ICX_CAT_CONTENT_ZONES_S.NEXTVAL
1303: BULK COLLECT INTO l_item_source_ids, l_store_ids, l_new_zone_ids
1304: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc
1305: WHERE sources.type IN ('EXTERNAL', 'DISTSRCH', 'INFO')
1306: AND sources.item_source_id = sc.item_source_id(+);
1307: l_err_loc := 100;
1308:

Line 2310: FROM icx_por_item_sources

2306: SELECT 1
2307: INTO l_exists_local_catalogs
2308: FROM dual
2309: WHERE exists (SELECT item_source_id
2310: FROM icx_por_item_sources
2311: WHERE type = 'LOCAL');
2312: l_err_loc := 100;
2313:
2314: EXCEPTION

Line 2360: FROM icx_por_item_sources

2356: SELECT 1
2357: INTO l_exists_item_sources
2358: FROM dual
2359: WHERE exists (SELECT item_source_id
2360: FROM icx_por_item_sources
2361: WHERE type IN ('EXTERNAL', 'DISTSRCH', 'INFO'));
2362: l_err_loc := 100;
2363:
2364: EXCEPTION

Line 2476: FROM icx_por_item_sources sources, icx_cat_item_src_details details

2472: nvl2(details.supplier_id, 'INCLUDE',
2473: DECODE(sources.protocol_supported,
2474: 'LOCAL_BASE', 'INCLUDE_ALL', 'EXCLUDE_ALL'))
2475: BULK COLLECT INTO l_sources_ids, l_supplier_flags
2476: FROM icx_por_item_sources sources, icx_cat_item_src_details details
2477: WHERE sources.type = 'LOCAL'
2478: AND sources.item_source_id = details.item_source_id(+);
2479:
2480: l_err_loc := 100;

Line 2535: FROM icx_por_item_sources

2531: BEGIN
2532:
2533: SELECT distinct operator_id
2534: BULK COLLECT INTO l_operator_ids
2535: FROM icx_por_item_sources
2536: WHERE operator_id IS NOT NULL;
2537:
2538: l_err_loc := 100;
2539:

Line 2618: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc

2614: l_err_loc := 100;
2615:
2616: SELECT sources.item_source_id, sources.type, sc.store_id
2617: BULK COLLECT INTO x_old_content_ids, x_content_types, x_old_store_ids
2618: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc
2619: WHERE sources.item_source_id = sc.item_source_id(+)
2620: AND sources.type <> 'CNTRCTR'
2621: ORDER BY sc.store_id;
2622:

Line 2636: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc

2632: l_err_loc := 200;
2633:
2634: SELECT sources.item_source_id, sources.type, sc.store_id
2635: BULK COLLECT INTO x_old_content_ids, x_content_types, x_old_store_ids
2636: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc
2637: WHERE sources.item_source_id = sc.item_source_id(+)
2638: AND sources.type IN ('EXTERNAL', 'DISTSRCH', 'INFO')
2639: ORDER BY sc.store_id;
2640:

Line 2654: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc

2650: l_err_loc := 300;
2651:
2652: SELECT sources.item_source_id, sources.type, sc.store_id
2653: BULK COLLECT INTO x_old_content_ids, x_content_types, x_old_store_ids
2654: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc
2655: WHERE sources.item_source_id = sc.item_source_id(+)
2656: AND sources.type = 'LOCAL'
2657: ORDER BY sc.store_id;
2658:

Line 3239: FROM icx_por_item_sources sources

3235: DECODE(g_site_approved_pricing, 'Y', 'N',
3236: nvl(sources.include_internal_source_flag, 'Y')),
3237: 'N', fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
3238: fnd_global.login_id
3239: FROM icx_por_item_sources sources
3240: WHERE sources.item_source_id = p_catalog_ids(i);
3241:
3242: l_err_loc := 100;
3243:

Line 3253: FROM icx_por_item_sources sources, icx_por_item_sources_tl sources_tl

3249: SELECT p_new_zone_ids(i), sources_tl.language, sources_tl.source_lang,
3250: sources_tl.item_source_name, sources_tl.description,
3251: sources_tl.ctx_keywords, sources.image_url, fnd_global.user_id,
3252: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3253: FROM icx_por_item_sources sources, icx_por_item_sources_tl sources_tl
3254: WHERE sources.item_source_id = p_catalog_ids(i)
3255: AND sources_tl.item_source_id = sources.item_source_id;
3256:
3257: l_err_loc := 200;

Line 3299: -- where the "All Local Content" is not already seeded in icx_por_item_sources.

3295:
3296:
3297: -- Similar to "create_local_zones," this method will create new local content
3298: -- zones. However, this is done for the special case for pre-11.5.9 upgrades
3299: -- where the "All Local Content" is not already seeded in icx_por_item_sources.
3300: -- In this case, the local zones must be created from hard-coded values.
3301: --
3302: -- Note: This method should be called ONLY when there are realms involved.
3303: -- Values have been hard-coded accordingly. In the non-realms case,

Line 3593: l_encrypted_password VARCHAR2(100); -- length in icx_por_item_sources

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
3595: l_api_name CONSTANT VARCHAR2(30) := 'create_item_source_zones';
3596: l_err_loc PLS_INTEGER;
3597: BEGIN

Line 3617: FROM icx_por_item_sources sources

3613: 'INFO', 'INFORMATIONAL'),
3614: sources.url, p_security_flags(i),
3615: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
3616: fnd_global.login_id
3617: FROM icx_por_item_sources sources
3618: WHERE sources.item_source_id = p_item_source_ids(i);
3619:
3620: l_err_loc := 100;
3621:

Line 3632: FROM icx_por_item_sources sources, icx_por_item_sources_tl sources_tl

3628: sources_tl.item_source_name, sources_tl.description,
3629: sources_tl.ctx_keywords, sources.image_url,
3630: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
3631: fnd_global.login_id
3632: FROM icx_por_item_sources sources, icx_por_item_sources_tl sources_tl
3633: WHERE sources.item_source_id = p_item_source_ids(i)
3634: AND sources_tl.item_source_id = sources.item_source_id;
3635:
3636: l_err_loc := 200;

Line 3660: FROM icx_por_item_sources

3656: party_site_id, operator_id, authenticated_key, user_info_flag,
3657: lock_item_flag, icx_session_servlet_flag, operation_allowed,
3658: negotiated_by_preparer_flag, fnd_global.user_id, sysdate,
3659: fnd_global.user_id, sysdate, fnd_global.login_id
3660: FROM icx_por_item_sources
3661: WHERE item_source_id = p_item_source_ids(i)
3662: AND type IN ('EXTERNAL', 'DISTSRCH');
3663:
3664: l_err_loc := 300;

Line 3673: FROM icx_por_item_sources s, icx_cat_item_src_details d

3669: (zone_id, attribute_name, attribute_value, created_by, creation_date,
3670: last_updated_by, last_update_date, last_update_login)
3671: SELECT p_new_zone_ids(i), d.name, d.value, fnd_global.user_id,
3672: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3673: FROM icx_por_item_sources s, icx_cat_item_src_details d
3674: WHERE s.item_source_id = p_item_source_ids(i)
3675: AND s.type = 'DISTSRCH'
3676: AND s.item_source_id = d.item_source_id;
3677:

Line 3687: FROM icx_por_item_sources

3683: FOR i IN 1..p_new_zone_ids.COUNT LOOP
3684:
3685: SELECT password
3686: INTO l_encrypted_password
3687: FROM icx_por_item_sources
3688: WHERE item_source_id = p_item_source_ids(i);
3689:
3690: -- skip the cases where the password is NULL
3691: IF (l_encrypted_password IS NOT NULL) THEN

Line 3786: FROM icx_por_item_sources

3782:
3783: -- retrieve all the operator_id values that must be updated
3784: SELECT distinct operator_id
3785: BULK COLLECT INTO l_old_operator_ids
3786: FROM icx_por_item_sources
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