APPS.AMS_IBA_PS_POSTINGS_B_PKG dependencies on AMS_IBA_PS_POSTINGS_TL

Line 124: INSERT INTO ams_iba_ps_postings_tl (

120: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
121: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
122:
123:
124: INSERT INTO ams_iba_ps_postings_tl (
125: created_by,
126: creation_date,
127: last_update_date,
128: last_update_login,

Line 154: FROM ams_iba_ps_postings_tl t

150: FROM fnd_languages l
151: WHERE l.installed_flag IN ('I', 'B')
152: AND NOT EXISTS
153: (SELECT null
154: FROM ams_iba_ps_postings_tl t
155: WHERE t.posting_id = DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id)
156: AND t.language = l.language_code);
157:
158: END Insert_Row;

Line 251: UPDATE ams_iba_ps_postings_tl SET

247: RAISE FND_API.G_EXC_ERROR;
248: END IF;
249:
250:
251: UPDATE ams_iba_ps_postings_tl SET
252: posting_name = decode( p_posting_name, FND_API.G_MISS_CHAR, posting_name, p_posting_name),
253: display_name = decode( p_display_name, FND_API.G_MISS_CHAR, display_name, p_posting_name),
254: posting_description = decode( p_posting_description, FND_API.G_MISS_CHAR, posting_description, p_posting_description),
255: last_update_date = SYSDATE,

Line 404: delete from AMS_IBA_PS_POSTINGS_TL T

400:
401: procedure ADD_LANGUAGE
402: is
403: begin
404: delete from AMS_IBA_PS_POSTINGS_TL T
405: where not exists
406: (select NULL
407: from AMS_IBA_PS_POSTINGS_B B
408: where B.POSTING_ID = T.POSTING_ID

Line 411: update AMS_IBA_PS_POSTINGS_TL T set (

407: from AMS_IBA_PS_POSTINGS_B B
408: where B.POSTING_ID = T.POSTING_ID
409: );
410:
411: update AMS_IBA_PS_POSTINGS_TL T set (
412: POSTING_NAME,
413: DISPLAY_NAME,
414: POSTING_DESCRIPTION
415: ) = (select

Line 419: from AMS_IBA_PS_POSTINGS_TL B

415: ) = (select
416: B.POSTING_NAME,
417: B.DISPLAY_NAME,
418: B.POSTING_DESCRIPTION
419: from AMS_IBA_PS_POSTINGS_TL B
420: where B.POSTING_ID = T.POSTING_ID
421: and B.LANGUAGE = T.SOURCE_LANG)
422: where (
423: T.POSTING_ID,

Line 428: from AMS_IBA_PS_POSTINGS_TL SUBB, AMS_IBA_PS_POSTINGS_TL SUBT

424: T.LANGUAGE
425: ) in (select
426: SUBT.POSTING_ID,
427: SUBT.LANGUAGE
428: from AMS_IBA_PS_POSTINGS_TL SUBB, AMS_IBA_PS_POSTINGS_TL SUBT
429: where SUBB.POSTING_ID = SUBT.POSTING_ID
430: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
431: and (SUBB.POSTING_NAME <> SUBT.POSTING_NAME
432: or SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME

Line 438: insert into AMS_IBA_PS_POSTINGS_TL (

434: or (SUBB.POSTING_DESCRIPTION is null and SUBT.POSTING_DESCRIPTION is not null)
435: or (SUBB.POSTING_DESCRIPTION is not null and SUBT.POSTING_DESCRIPTION is null)
436: ));
437:
438: insert into AMS_IBA_PS_POSTINGS_TL (
439: CREATED_BY,
440: CREATION_DATE,
441: LAST_UPDATE_DATE,
442: LAST_UPDATE_LOGIN,

Line 464: from AMS_IBA_PS_POSTINGS_TL B, FND_LANGUAGES L

460: B.DISPLAY_NAME,
461: B.POSTING_DESCRIPTION,
462: L.LANGUAGE_CODE,
463: B.SOURCE_LANG
464: from AMS_IBA_PS_POSTINGS_TL B, FND_LANGUAGES L
465: where L.INSTALLED_FLAG in ('I', 'B')
466: and B.LANGUAGE = userenv('LANG')
467: and not exists
468: (select NULL

Line 469: from AMS_IBA_PS_POSTINGS_TL T

465: where L.INSTALLED_FLAG in ('I', 'B')
466: and B.LANGUAGE = userenv('LANG')
467: and not exists
468: (select NULL
469: from AMS_IBA_PS_POSTINGS_TL T
470: where T.POSTING_ID = B.POSTING_ID
471: and T.LANGUAGE = L.LANGUAGE_CODE);
472: end ADD_LANGUAGE;
473: