APPS.AMS_DELIVERABLE_PVT dependencies on AMS_DELIVERABLES_ALL_TL

Line 568: INSERT INTO ams_deliverables_all_tl(

564: l_deliv_Rec.setup_id,
565: l_deliv_Rec.email_content_type
566: );
567:
568: INSERT INTO ams_deliverables_all_tl(
569: deliverable_id,
570: language,
571: last_update_date,
572: last_updated_by,

Line 595: FROM ams_deliverables_all_tl t

591: FROM fnd_languages l
592: WHERE l.installed_flag in ('I', 'B')
593: AND NOT EXISTS(
594: SELECT NULL
595: FROM ams_deliverables_all_tl t
596: WHERE t.deliverable_id = l_deliv_rec.deliverable_id
597: AND t.language = l.language_code );
598:
599: l_obj_type := 'DELV';

Line 1014: DELETE FROM ams_deliverables_all_tl

1010: END IF;
1011: RAISE FND_API.g_exc_error;
1012: END IF;
1013:
1014: DELETE FROM ams_deliverables_all_tl
1015: WHERE deliverable_id = p_deliv_id;
1016:
1017: IF (SQL%NOTFOUND) THEN
1018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1116: FROM ams_deliverables_all_tl

1112: FOR UPDATE OF deliverable_id NOWAIT;
1113:
1114: CURSOR c_deliv_tl IS
1115: SELECT deliverable_id
1116: FROM ams_deliverables_all_tl
1117: WHERE deliverable_id = p_deliv_id
1118: AND USERENV('LANG') IN (language, source_lang)
1119: FOR UPDATE OF deliverable_id NOWAIT;
1120:

Line 1942: UPDATE ams_deliverables_all_tl

1938: IF (AMS_DEBUG_HIGH_ON) THEN
1939:
1940: ams_utility_pvt.debug_message (l_full_name ||' end of update 1 ');
1941: END IF;
1942: UPDATE ams_deliverables_all_tl
1943: SET deliverable_name = l_deliv_rec.deliverable_name,
1944: description = l_deliv_rec.description,
1945: last_update_date = SYSDATE,
1946: last_updated_by = FND_GLOBAL.user_id,