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_CONTENTS_POSTUPG_PVT dependencies on ICX_CAT_ZONE_SECURE_ATTRIBUTES

Line 157: FROM icx_cat_zone_secure_attributes

153: l_err_loc := 0;
154:
155: SELECT ip_category_id
156: BULK COLLECT INTO l_category_list
157: FROM icx_cat_zone_secure_attributes
158: WHERE ZONE_ID=p_original_zone_id
159: AND SECURING_ATTRIBUTE= 'CATEGORY';
160:
161: l_err_loc := 100;

Line 256: INSERT INTO icx_cat_zone_secure_attributes

252: l_err_loc := 300;
253:
254: -- migrate over supplier restrictions, if any
255: FORALL i IN 1..p_new_zone_ids.COUNT
256: INSERT INTO icx_cat_zone_secure_attributes
257: (zone_id, securing_attribute, supplier_id, created_by, creation_date,
258: last_updated_by, last_update_date, last_update_login)
259: SELECT p_new_zone_ids(i), zone_attr.securing_attribute, zone_attr.supplier_id,
260: zone_attr.created_by, zone_attr.creation_date,

Line 262: FROM icx_cat_zone_secure_attributes zone_attr

258: last_updated_by, last_update_date, last_update_login)
259: SELECT p_new_zone_ids(i), zone_attr.securing_attribute, zone_attr.supplier_id,
260: zone_attr.created_by, zone_attr.creation_date,
261: zone_attr.last_updated_by, zone_attr.last_update_date, zone_attr.last_update_login
262: FROM icx_cat_zone_secure_attributes zone_attr
263: WHERE zone_attr.zone_id = p_old_zone_id
264: AND zone_attr.securing_attribute = 'SUPPLIER';
265:
266: l_err_loc := 400;

Line 301: INSERT INTO icx_cat_zone_secure_attributes

297: FOR i in 1..p_new_zone_ids.COUNT
298: LOOP
299: l_err_loc := 100;
300: FORALL j in 1..p_zone_categories(p_new_zone_ids(i)).COUNT
301: INSERT INTO icx_cat_zone_secure_attributes
302: (zone_id, securing_attribute, ip_category_id, created_by, creation_date,
303: last_updated_by, last_update_date, last_update_login)
304: SELECT p_new_zone_ids(i), 'CATEGORY', p_zone_categories(p_new_zone_ids(i))(j),
305: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,

Line 434: -- delete from icx_cat_zone_secure_attributes

430: WHERE content_id = p_old_zone_id;
431:
432: l_err_loc := 200;
433:
434: -- delete from icx_cat_zone_secure_attributes
435: DELETE icx_cat_zone_secure_attributes
436: WHERE zone_id=p_old_zone_id;
437:
438: l_err_loc := 300;

Line 435: DELETE icx_cat_zone_secure_attributes

431:
432: l_err_loc := 200;
433:
434: -- delete from icx_cat_zone_secure_attributes
435: DELETE icx_cat_zone_secure_attributes
436: WHERE zone_id=p_old_zone_id;
437:
438: l_err_loc := 300;
439: