APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on ICX_CAT_PUNCHOUT_ZONE_DETAILS

Line 3640: INSERT INTO icx_cat_punchout_zone_details

3636: l_err_loc := 200;
3637:
3638: -- migrate values into punchout zone details for those type of item sources
3639: FORALL i IN 1..p_new_zone_ids.COUNT
3640: INSERT INTO icx_cat_punchout_zone_details
3641: (zone_id, protocol_supported, user_name, company_name, company_number,
3642: supplier_name, supplier_number, ecgateway_map_key1, vendor_id,
3643: vendor_site_id, encoding, party_site_id, parent_zone_id, authenticated_key,
3644: user_info_flag, lock_item_flag, retain_session_flag, operation_allowed,

Line 3821: UPDATE icx_cat_punchout_zone_details

3817: END LOOP;
3818:
3819: -- now update all the downloaded punchout zones with the new zone IDs
3820: FORALL i IN 1..l_old_operator_ids.COUNT
3821: UPDATE icx_cat_punchout_zone_details
3822: SET parent_zone_id = l_new_parent_ids(i)
3823: WHERE parent_zone_id = l_old_operator_ids(i);
3824: l_err_loc := 200;
3825: