DBA Data[Home] [Help]

APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on ICX_CAT_ZONE_SECURE_ATTRIBUTES

Line 3261: INSERT INTO icx_cat_zone_secure_attributes

3257: l_err_loc := 200;
3258:
3259: -- migrate over supplier restrictions, if any
3260: FORALL i IN 1..p_catalog_ids.COUNT
3261: INSERT INTO icx_cat_zone_secure_attributes
3262: (zone_id, securing_attribute, supplier_id, created_by, creation_date,
3263: last_updated_by, last_update_date, last_update_login)
3264: SELECT p_new_zone_ids(i), 'SUPPLIER', supplier_id, fnd_global.user_id,
3265: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id

Line 3458: INSERT INTO icx_cat_zone_secure_attributes

3454:
3455: -- then, for all the responsibility, zone, and categories tuples, add
3456: -- them all as rows in the secure attributes table
3457: FORALL i IN 1..l_zones_to_insert.COUNT
3458: INSERT INTO icx_cat_zone_secure_attributes
3459: (zone_id, securing_attribute, ip_category_id, created_by, creation_date,
3460: last_updated_by, last_update_date, last_update_login)
3461: SELECT l_zones_to_insert(i), 'CATEGORY', l_categories_to_insert(i),
3462: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,