[Home] [Help]
849: DELETE FROM icx_cat_content_zones_tl
850: WHERE zone_id = 1;
851: l_err_loc := 200;
852:
853: -- there are nothing seeded into icx_cat_secure_contents for the seeded
854: -- content zone, so nothing to handle in that table
855:
856: -- remove all links to stores, if any
857: DELETE FROM icx_cat_store_contents
1022: SET zone_id = 1
1023: WHERE zone_id = l_promoted_zone_id;
1024: l_err_loc := 300;
1025:
1026: UPDATE icx_cat_secure_contents
1027: SET content_id = 1
1028: WHERE content_id = l_promoted_zone_id;
1029: l_err_loc := 400;
1030:
3875: l_err_loc := 0;
3876:
3877: -- secure the content zones with the orgs that were set on the old stores
3878: FORALL i IN 1..p_new_zone_ids.COUNT
3879: INSERT INTO icx_cat_secure_contents
3880: (content_id, org_id, secure_by, created_by, creation_date, last_updated_by,
3881: last_update_date, last_update_login)
3882: SELECT p_new_zone_ids(i), oa.org_id, 'OPERATING_UNIT', fnd_global.user_id,
3883: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3944:
3945: l_err_loc := 0;
3946:
3947: FORALL i IN 1..p_resp_ids.COUNT
3948: INSERT INTO icx_cat_secure_contents
3949: (content_id, responsibility_id, secure_by, created_by, creation_date,
3950: last_updated_by, last_update_date, last_update_login)
3951: SELECT p_new_zone_ids(i), p_resp_ids(i), 'RESPONSIBILITY',
3952: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,