APPS.BIS_PMV_PARAMETERS_PUB dependencies on AK_CUSTOM_REGION_ITEMS

Line 142: delete from AK_CUSTOM_REGION_ITEMS

138: CLOSE c_custom_code_cursor;
139: END IF;
140: FOR cr IN c_custom_code_cursor LOOP
141: -- delete region items customization
142: delete from AK_CUSTOM_REGION_ITEMS
143: where CUSTOMIZATION_APPLICATION_ID = cr.customization_application_id
144: and CUSTOMIZATION_CODE = cr.customization_code
145: and REGION_APPLICATION_ID = p_region_application_id
146: and REGION_CODE = p_region_code;

Line 152: delete from AK_CUSTOM_REGION_ITEMS_TL

148: IF SQL%NOTFOUND THEN
149: NULL;
150: END IF;
151:
152: delete from AK_CUSTOM_REGION_ITEMS_TL
153: where CUSTOMIZATION_APPLICATION_ID = cr.customization_application_id
154: and CUSTOMIZATION_CODE = cr.customization_code
155: and REGION_APPLICATION_ID = p_region_application_id
156: and REGION_CODE = p_region_code;