APPS.AP_MAP_TYPES_PKG dependencies on AP_MAP_TYPES_B

Line 19: cursor C is select ROWID from AP_MAP_TYPES_B

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from AP_MAP_TYPES_B
20: where MAP_TYPE_CODE = X_MAP_TYPE_CODE
21: ;
22: begin
23: insert into AP_MAP_TYPES_B (

Line 23: insert into AP_MAP_TYPES_B (

19: cursor C is select ROWID from AP_MAP_TYPES_B
20: where MAP_TYPE_CODE = X_MAP_TYPE_CODE
21: ;
22: begin
23: insert into AP_MAP_TYPES_B (
24: MAP_TYPE_CODE,
25: FROM_APPLICATION_ID,
26: FROM_LOOKUP_TYPE,
27: TO_APPLICATION_ID,

Line 105: from AP_MAP_TYPES_B

101: FROM_LOOKUP_TYPE,
102: TO_APPLICATION_ID,
103: TO_LOOKUP_TYPE,
104: DEFAULT_LOOKUP_CODE
105: from AP_MAP_TYPES_B
106: where MAP_TYPE_CODE = X_MAP_TYPE_CODE
107: for update of MAP_TYPE_CODE nowait;
108: recinfo c%rowtype;
109:

Line 175: update AP_MAP_TYPES_B set

171: X_LAST_UPDATED_BY in NUMBER,
172: X_LAST_UPDATE_LOGIN in NUMBER
173: ) is
174: begin
175: update AP_MAP_TYPES_B set
176: FROM_APPLICATION_ID = X_FROM_APPLICATION_ID,
177: FROM_LOOKUP_TYPE = X_FROM_LOOKUP_TYPE,
178: TO_APPLICATION_ID = X_TO_APPLICATION_ID,
179: TO_LOOKUP_TYPE = X_TO_LOOKUP_TYPE,

Line 219: delete from AP_MAP_TYPES_B

215: if (sql%notfound) then
216: raise no_data_found;
217: end if;
218:
219: delete from AP_MAP_TYPES_B
220: where MAP_TYPE_CODE = X_MAP_TYPE_CODE;
221:
222: if (sql%notfound) then
223: raise no_data_found;

Line 233: from AP_MAP_TYPES_B B

229: begin
230: delete from AP_MAP_TYPES_TL T
231: where not exists
232: (select NULL
233: from AP_MAP_TYPES_B B
234: where B.MAP_TYPE_CODE = T.MAP_TYPE_CODE
235: );
236:
237: update AP_MAP_TYPES_TL T set (

Line 314: FROM ap_map_types_b

310: exception
311: when no_data_found then
312: SELECT default_lookup_code
313: INTO l_map_to_code
314: FROM ap_map_types_b
315: WHERE map_type_code = x_map_type_code;
316:
317: return l_map_to_code;
318: end GET_MAP_TO_CODE;

Line 363: from ap_map_types_b

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
363: from ap_map_types_b
364: where map_type_code = x_map_type_code;
365:
366: if is_lookup_unusable(l_to_app, l_to_type, l_default_code) then
367: update ap_map_types_b set default_lookup_code = null

Line 367: update ap_map_types_b set default_lookup_code = null

363: from ap_map_types_b
364: where map_type_code = x_map_type_code;
365:
366: if is_lookup_unusable(l_to_app, l_to_type, l_default_code) then
367: update ap_map_types_b set default_lookup_code = null
368: where map_type_code = x_map_type_code;
369: end if;
370:
371: for crec in crules loop