APPS.AP_MAP_TYPES_PKG dependencies on AP_MAP_CODES

Line 209: delete from AP_MAP_CODES

205: procedure DELETE_ROW (
206: X_MAP_TYPE_CODE in VARCHAR2
207: ) is
208: begin
209: delete from AP_MAP_CODES
210: where MAP_TYPE_CODE = X_MAP_TYPE_CODE;
211:
212: delete from AP_MAP_TYPES_TL
213: where MAP_TYPE_CODE = X_MAP_TYPE_CODE;

Line 305: FROM ap_map_codes

301: l_map_to_code VARCHAR2(30);
302: begin
303: SELECT to_lookup_code
304: INTO l_map_to_code
305: FROM ap_map_codes
306: WHERE map_type_code = x_map_type_code
307: AND from_lookup_code = x_map_from_code;
308:
309: return l_map_to_code;

Line 346: exception -- Bug#14593997 if the value doesn't exist, delete it from ap_map_codes

342: return true;
343: else
344: return false;
345: end if;
346: exception -- Bug#14593997 if the value doesn't exist, delete it from ap_map_codes
347: when no_data_found then
348: return true;
349: end IS_LOOKUP_UNUSABLE;
350:

Line 361: from ap_map_codes

357: l_from_app number;
358: l_from_type varchar2(30);
359:
360: cursor crules is select from_lookup_code, to_lookup_code
361: from ap_map_codes
362: where map_type_code = x_map_type_code;
363: BEGIN
364: select from_application_id, from_lookup_type, to_application_id, to_lookup_type, default_lookup_code
365: into l_from_app, l_from_type, l_to_app, l_to_type, l_default_code

Line 377: delete from ap_map_codes

373:
374: for crec in crules loop
375: if is_lookup_unusable(l_to_app, l_to_type, crec.to_lookup_code) or
376: is_lookup_unusable(l_from_app, l_from_type, crec.from_lookup_code) then
377: delete from ap_map_codes
378: where map_type_code = x_map_type_code
379: and from_lookup_code = crec.from_lookup_code;
380: end if;
381: end loop;