APPS.AMS_DELIVERABLE_PVT dependencies on AMS_DELIVERABLES_ALL_TL

Line 555: INSERT INTO ams_deliverables_all_tl(

551: l_deliv_Rec.setup_id,
552: l_deliv_Rec.email_content_type
553: );
554:
555: INSERT INTO ams_deliverables_all_tl(
556: deliverable_id,
557: language,
558: last_update_date,
559: last_updated_by,

Line 582: FROM ams_deliverables_all_tl t

578: FROM fnd_languages l
579: WHERE l.installed_flag in ('I', 'B')
580: AND NOT EXISTS(
581: SELECT NULL
582: FROM ams_deliverables_all_tl t
583: WHERE t.deliverable_id = l_deliv_rec.deliverable_id
584: AND t.language = l.language_code );
585:
586: l_obj_type := 'DELV';

Line 1001: DELETE FROM ams_deliverables_all_tl

997: END IF;
998: RAISE FND_API.g_exc_error;
999: END IF;
1000:
1001: DELETE FROM ams_deliverables_all_tl
1002: WHERE deliverable_id = p_deliv_id;
1003:
1004: IF (SQL%NOTFOUND) THEN
1005: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1103: FROM ams_deliverables_all_tl

1099: FOR UPDATE OF deliverable_id NOWAIT;
1100:
1101: CURSOR c_deliv_tl IS
1102: SELECT deliverable_id
1103: FROM ams_deliverables_all_tl
1104: WHERE deliverable_id = p_deliv_id
1105: AND USERENV('LANG') IN (language, source_lang)
1106: FOR UPDATE OF deliverable_id NOWAIT;
1107:

Line 1929: UPDATE ams_deliverables_all_tl

1925: IF (AMS_DEBUG_HIGH_ON) THEN
1926:
1927: ams_utility_pvt.debug_message (l_full_name ||' end of update 1 ');
1928: END IF;
1929: UPDATE ams_deliverables_all_tl
1930: SET deliverable_name = l_deliv_rec.deliverable_name,
1931: description = l_deliv_rec.description,
1932: last_update_date = SYSDATE,
1933: last_updated_by = FND_GLOBAL.user_id,