943: ,l_evo_rec.NUMBER_OF_ATTENDEES /* Hornet : added for imeeting integration*/
944: ,l_evo_rec.EVENT_PURPOSE_CODE /* Hornet */
945: );
946:
947: INSERT INTO ams_event_offers_all_tl(
948: event_offer_id,
949: language,
950: last_update_date,
951: last_updated_by,
972: FROM fnd_languages l
973: WHERE l.installed_flag in ('I', 'B')
974: AND NOT EXISTS(
975: SELECT NULL
976: FROM ams_event_offers_all_tl t
977: WHERE t.event_offer_id = l_evo_rec.event_offer_id
978: AND t.language = l.language_code );
979:
980: x_evo_id := l_evo_rec.event_offer_id;
1354: FOR UPDATE OF event_offer_id NOWAIT;
1355:
1356: CURSOR c_evo_tl IS
1357: SELECT event_offer_id
1358: FROM ams_event_offers_all_tl
1359: WHERE event_offer_id = p_evo_id
1360: AND USERENV('LANG') IN (language, source_lang)
1361: FOR UPDATE OF event_offer_id NOWAIT;
1362:
2752:
2753: -- GDEODHAR : Sept. 26th, 2000 : Note that for MAIN Events and Agenda (SUB) items, the
2754: -- update of the TL table is the same.
2755:
2756: update ams_event_offers_all_tl set
2757: event_offer_name = l_evo_rec.event_offer_name,
2758: event_mktg_message = l_evo_rec.event_mktg_message,
2759: description = l_evo_rec.description,
2760: last_update_date = SYSDATE,