APPS.AMS_EVENTHEADER_PVT dependencies on AMS_EVENT_HEADERS_ALL_TL

Line 525: INSERT INTO ams_event_headers_all_tl(

521: AMS_Utility_PVT.debug_message(l_full_name ||': insert TL');
522:
523: END IF;
524:
525: INSERT INTO ams_event_headers_all_tl(
526: event_header_id,
527: language,
528: last_update_date,
529: last_updated_by,

Line 554: FROM ams_event_headers_all_tl t

550: FROM fnd_languages l
551: WHERE l.installed_flag in ('I', 'B')
552: AND NOT EXISTS(
553: SELECT NULL
554: FROM ams_event_headers_all_tl t
555: WHERE t.event_header_id = l_evh_rec.event_header_id
556: AND t.language = l.language_code );
557:
558:

Line 779: DELETE FROM ams_event_headers_all_tl

775: END IF;
776: RAISE FND_API.g_exc_error;
777: END IF;
778: /*
779: DELETE FROM ams_event_headers_all_tl
780: WHERE event_header_id = p_evh_id;
781: */
782: IF (SQL%NOTFOUND) THEN
783: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 883: FROM ams_event_headers_all_tl

879: FOR UPDATE OF event_header_id NOWAIT;
880:
881: CURSOR c_evh_tl IS
882: SELECT event_header_id
883: FROM ams_event_headers_all_tl
884: WHERE event_header_id = p_evh_id
885: AND USERENV('LANG') IN (language, source_lang)
886: FOR UPDATE OF event_header_id NOWAIT;
887:

Line 1719: update ams_event_headers_all_tl set

1715:
1716: -- GDEODHAR : Sept. 26th, 2000 : Note that for MAIN Events and Agenda (SUB) items, the
1717: -- update of the TL table is the same.
1718:
1719: update ams_event_headers_all_tl set
1720: event_header_name = l_evh_rec.event_header_name,
1721: event_mktg_message = l_evh_rec.event_mktg_message,
1722: description = l_evh_rec.description,
1723: last_update_date = SYSDATE,