APPS.AMS_IBA_PL_PLACEMENTS_B_PKG dependencies on AMS_IBA_PL_PLACEMENTS_TL

Line 116: insert into AMS_IBA_PL_PLACEMENTS_TL (

112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
113: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
114: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
115:
116: insert into AMS_IBA_PL_PLACEMENTS_TL (
117: PLACEMENT_ID,
118: NAME,
119: DESCRIPTION,
120: CREATED_BY,

Line 144: FROM ams_iba_pl_placements_tl t

140: FROM fnd_languages l
141: WHERE l.installed_flag IN ('I', 'B')
142: AND NOT EXISTS
143: (SELECT NULL
144: FROM ams_iba_pl_placements_tl t
145: WHERE t.placement_id = DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id)
146: AND t.language = l.language_code);
147:
148: END Insert_Row;

Line 221: UPDATE ams_iba_pl_placements_tl SET

217: IF (SQL%NOTFOUND) THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: END IF;
220:
221: UPDATE ams_iba_pl_placements_tl SET
222: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
223: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
224: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
225: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 259: DELETE FROM ams_iba_pl_placements_tl

255: p_placement_id NUMBER)
256: IS
257: BEGIN
258:
259: DELETE FROM ams_iba_pl_placements_tl
260: WHERE placement_id = p_placement_id;
261:
262: If (SQL%NOTFOUND) then
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 279: delete from AMS_IBA_PL_PLACEMENTS_TL T

275:
276: procedure ADD_LANGUAGE
277: is
278: begin
279: delete from AMS_IBA_PL_PLACEMENTS_TL T
280: where not exists
281: (select NULL
282: from AMS_IBA_PL_PLACEMENTS_B B
283: where B.PLACEMENT_ID = T.PLACEMENT_ID

Line 286: update AMS_IBA_PL_PLACEMENTS_TL T set (

282: from AMS_IBA_PL_PLACEMENTS_B B
283: where B.PLACEMENT_ID = T.PLACEMENT_ID
284: );
285:
286: update AMS_IBA_PL_PLACEMENTS_TL T set (
287: NAME,
288: description
289: ) = (select
290: B.NAME,

Line 292: from AMS_IBA_PL_PLACEMENTS_TL B

288: description
289: ) = (select
290: B.NAME,
291: B.description
292: from AMS_IBA_PL_PLACEMENTS_TL B
293: where B.PLACEMENT_ID = T.PLACEMENT_ID
294: and B.LANGUAGE = T.SOURCE_LANG)
295: where (
296: T.PLACEMENT_ID,

Line 301: from AMS_IBA_PL_PLACEMENTS_TL SUBB, AMS_IBA_PL_PLACEMENTS_TL SUBT

297: T.LANGUAGE
298: ) in (select
299: SUBT.PLACEMENT_ID,
300: SUBT.LANGUAGE
301: from AMS_IBA_PL_PLACEMENTS_TL SUBB, AMS_IBA_PL_PLACEMENTS_TL SUBT
302: where SUBB.PLACEMENT_ID = SUBT.PLACEMENT_ID
303: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
304: and (SUBB.NAME <> SUBT.NAME
305: or SUBB.LANGUAGE <> SUBT.LANGUAGE

Line 308: insert into AMS_IBA_PL_PLACEMENTS_TL (

304: and (SUBB.NAME <> SUBT.NAME
305: or SUBB.LANGUAGE <> SUBT.LANGUAGE
306: ));
307:
308: insert into AMS_IBA_PL_PLACEMENTS_TL (
309: OBJECT_VERSION_NUMBER,
310: CREATED_BY,
311: CREATION_DATE,
312: LAST_UPDATED_BY,

Line 332: from AMS_IBA_PL_PLACEMENTS_TL B, FND_LANGUAGES L

328: B.NAME,
329: B.DESCRIPTION,
330: L.LANGUAGE_CODE,
331: B.SOURCE_LANG
332: from AMS_IBA_PL_PLACEMENTS_TL B, FND_LANGUAGES L
333: where L.INSTALLED_FLAG in ('I', 'B')
334: and B.LANGUAGE = userenv('LANG')
335: and not exists
336: (select NULL

Line 337: from AMS_IBA_PL_PLACEMENTS_TL T

333: where L.INSTALLED_FLAG in ('I', 'B')
334: and B.LANGUAGE = userenv('LANG')
335: and not exists
336: (select NULL
337: from AMS_IBA_PL_PLACEMENTS_TL T
338: where T.PLACEMENT_ID = B.PLACEMENT_ID
339: and T.LANGUAGE = L.LANGUAGE_CODE);
340: end ADD_LANGUAGE;
341: