APPS.AP_MAP_TYPES_PKG dependencies on AP_MAP_TYPES_TL

Line 49: insert into AP_MAP_TYPES_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into AP_MAP_TYPES_TL (
50: MAP_TYPE_CODE,
51: MEANING,
52: DESCRIPTION,
53: CREATED_BY,

Line 75: from AP_MAP_TYPES_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from AP_MAP_TYPES_TL T
76: where T.MAP_TYPE_CODE = X_MAP_TYPE_CODE
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 114: from AP_MAP_TYPES_TL

110: cursor c1 is select
111: MEANING,
112: DESCRIPTION,
113: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
114: from AP_MAP_TYPES_TL
115: where MAP_TYPE_CODE = X_MAP_TYPE_CODE
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of MAP_TYPE_CODE nowait;
118: begin

Line 190: update AP_MAP_TYPES_TL set

186: if (sql%notfound) then
187: raise no_data_found;
188: end if;
189:
190: update AP_MAP_TYPES_TL set
191: MEANING = X_MEANING,
192: DESCRIPTION = X_DESCRIPTION,
193: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
194: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 212: delete from AP_MAP_TYPES_TL

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;
214:
215: if (sql%notfound) then
216: raise no_data_found;

Line 230: delete from AP_MAP_TYPES_TL T

226:
227: procedure ADD_LANGUAGE
228: is
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

Line 237: update AP_MAP_TYPES_TL T set (

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 (
238: MEANING,
239: DESCRIPTION
240: ) = (select
241: B.MEANING,

Line 243: from AP_MAP_TYPES_TL B

239: DESCRIPTION
240: ) = (select
241: B.MEANING,
242: B.DESCRIPTION
243: from AP_MAP_TYPES_TL B
244: where B.MAP_TYPE_CODE = T.MAP_TYPE_CODE
245: and B.LANGUAGE = T.SOURCE_LANG)
246: where (
247: T.MAP_TYPE_CODE,

Line 252: from AP_MAP_TYPES_TL SUBB, AP_MAP_TYPES_TL SUBT

248: T.LANGUAGE
249: ) in (select
250: SUBT.MAP_TYPE_CODE,
251: SUBT.LANGUAGE
252: from AP_MAP_TYPES_TL SUBB, AP_MAP_TYPES_TL SUBT
253: where SUBB.MAP_TYPE_CODE = SUBT.MAP_TYPE_CODE
254: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
255: and (SUBB.MEANING <> SUBT.MEANING
256: or (SUBB.MEANING is null and SUBT.MEANING is not null)

Line 263: insert into AP_MAP_TYPES_TL (

259: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
260: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
261: ));
262:
263: insert into AP_MAP_TYPES_TL (
264: MAP_TYPE_CODE,
265: MEANING,
266: DESCRIPTION,
267: CREATED_BY,

Line 285: from AP_MAP_TYPES_TL B, FND_LANGUAGES L

281: B.LAST_UPDATE_DATE,
282: B.LAST_UPDATE_LOGIN,
283: L.LANGUAGE_CODE,
284: B.SOURCE_LANG
285: from AP_MAP_TYPES_TL B, FND_LANGUAGES L
286: where L.INSTALLED_FLAG in ('I', 'B')
287: and B.LANGUAGE = userenv('LANG')
288: and not exists
289: (select NULL

Line 290: from AP_MAP_TYPES_TL T

286: where L.INSTALLED_FLAG in ('I', 'B')
287: and B.LANGUAGE = userenv('LANG')
288: and not exists
289: (select NULL
290: from AP_MAP_TYPES_TL T
291: where T.MAP_TYPE_CODE = B.MAP_TYPE_CODE
292: and T.LANGUAGE = L.LANGUAGE_CODE);
293: end ADD_LANGUAGE;
294: