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 358: from ap_map_codes

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

Line 374: delete from ap_map_codes

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