APPS.BIS_PMV_PARAMETERS_PUB dependencies on AK_CUSTOM_REGIONS

Line 122: FROM ak_customizations customView, bis_ak_custom_regions bookmark

118: ) IS
119:
120: CURSOR c_custom_code_cursor IS
121: SELECT customview.customization_code, customview.customization_application_id
122: FROM ak_customizations customView, bis_ak_custom_regions bookmark
123: WHERE customView.region_code=p_region_code AND
124: customView.region_application_id=p_region_application_id AND
125: customView.customization_code=bookmark.customization_code AND
126: customView.customization_application_id=bookmark.customization_application_id AND

Line 163: delete from AK_CUSTOM_REGIONS

159: NULL;
160: END IF;
161:
162: -- delete region customization
163: delete from AK_CUSTOM_REGIONS
164: where CUSTOMIZATION_APPLICATION_ID = cr.customization_application_id
165: and CUSTOMIZATION_CODE = cr.customization_code
166: and REGION_APPLICATION_ID = p_region_application_id
167: and REGION_CODE = p_region_code;

Line 173: delete from AK_CUSTOM_REGIONS_TL

169: IF SQL%NOTFOUND THEN
170: NULL;
171: END IF;
172:
173: delete from AK_CUSTOM_REGIONS_TL
174: where CUSTOMIZATION_APPLICATION_ID = cr.customization_application_id
175: and CUSTOMIZATION_CODE = cr.customization_code
176: and REGION_APPLICATION_ID = p_region_application_id
177: and REGION_CODE = p_region_code;

Line 196: delete from BIS_AK_CUSTOM_REGIONS

192: NULL;
193: END IF;
194:
195: -- delete bis region customization
196: delete from BIS_AK_CUSTOM_REGIONS
197: where CUSTOMIZATION_APPLICATION_ID = cr.customization_application_id
198: and CUSTOMIZATION_CODE = cr.customization_code
199: and REGION_APPLICATION_ID = p_region_application_id
200: and REGION_CODE = p_region_code