294: (
295: l_trig_rec.trigger_id
296: -- standard who columns
297: ,SYSDATE
298: ,FND_GLOBAL.User_Id
299: ,SYSDATE
300: ,FND_GLOBAL.User_Id
301: ,FND_GLOBAL.Conc_Login_Id
302:
296: -- standard who columns
297: ,SYSDATE
298: ,FND_GLOBAL.User_Id
299: ,SYSDATE
300: ,FND_GLOBAL.User_Id
301: ,FND_GLOBAL.Conc_Login_Id
302:
303: ,1 -- Object Version Number
304: ,l_trig_rec.process_id
297: ,SYSDATE
298: ,FND_GLOBAL.User_Id
299: ,SYSDATE
300: ,FND_GLOBAL.User_Id
301: ,FND_GLOBAL.Conc_Login_Id
302:
303: ,1 -- Object Version Number
304: ,l_trig_rec.process_id
305: ,l_trig_rec.trigger_created_for_id
351: VALUES
352: (l_trig_rec.trigger_id
353: ,USERENV('LANG')
354: ,SYSDATE
355: ,FND_GLOBAL.User_Id
356: ,SYSDATE
357: ,FND_GLOBAL.User_Id
358: ,FND_GLOBAL.Conc_Login_Id
359: ,USERENV('LANG')
353: ,USERENV('LANG')
354: ,SYSDATE
355: ,FND_GLOBAL.User_Id
356: ,SYSDATE
357: ,FND_GLOBAL.User_Id
358: ,FND_GLOBAL.Conc_Login_Id
359: ,USERENV('LANG')
360: ,l_trig_rec.trigger_name
361: ,l_trig_rec.description
354: ,SYSDATE
355: ,FND_GLOBAL.User_Id
356: ,SYSDATE
357: ,FND_GLOBAL.User_Id
358: ,FND_GLOBAL.Conc_Login_Id
359: ,USERENV('LANG')
360: ,l_trig_rec.trigger_name
361: ,l_trig_rec.description
362: -- removed by soagrawa on 24-sep-2001
380: SELECT
381: l_trig_rec.trigger_id,
382: l.language_code,
383: SYSDATE,
384: FND_GLOBAL.user_id,
385: SYSDATE,
386: FND_GLOBAL.user_id,
387: FND_GLOBAL.conc_login_id,
388: USERENV('LANG'),
382: l.language_code,
383: SYSDATE,
384: FND_GLOBAL.user_id,
385: SYSDATE,
386: FND_GLOBAL.user_id,
387: FND_GLOBAL.conc_login_id,
388: USERENV('LANG'),
389: l_trig_rec.trigger_name,
390: l_trig_rec.description
383: SYSDATE,
384: FND_GLOBAL.user_id,
385: SYSDATE,
386: FND_GLOBAL.user_id,
387: FND_GLOBAL.conc_login_id,
388: USERENV('LANG'),
389: l_trig_rec.trigger_name,
390: l_trig_rec.description
391: FROM fnd_languages l
1145:
1146: UPDATE ams_triggers
1147: SET
1148: last_update_date = SYSDATE
1149: ,last_updated_by = FND_GLOBAL.user_id
1150: ,last_update_login = FND_GLOBAL.conc_login_id
1151: ,object_version_number = l_trig_rec.object_version_number + 1
1152: ,process_id = l_trig_rec.process_id
1153: ,trigger_created_for_id = l_trig_rec.trigger_created_for_id
1146: UPDATE ams_triggers
1147: SET
1148: last_update_date = SYSDATE
1149: ,last_updated_by = FND_GLOBAL.user_id
1150: ,last_update_login = FND_GLOBAL.conc_login_id
1151: ,object_version_number = l_trig_rec.object_version_number + 1
1152: ,process_id = l_trig_rec.process_id
1153: ,trigger_created_for_id = l_trig_rec.trigger_created_for_id
1154: ,arc_trigger_created_for = l_trig_rec.arc_trigger_created_for
1189:
1190: UPDATE ams_triggers_tl
1191: SET
1192: last_update_date = SYSDATE,
1193: last_upated_by = FND_GLOBAL.user_id,
1194: creation_date = SYSDATE,
1195: created_by = FND_GLOBAL.user_id,
1196: last_update_login = FND_GLOBAL.user_id,
1197: source_lang = USERENV('LANG'),
1191: SET
1192: last_update_date = SYSDATE,
1193: last_upated_by = FND_GLOBAL.user_id,
1194: creation_date = SYSDATE,
1195: created_by = FND_GLOBAL.user_id,
1196: last_update_login = FND_GLOBAL.user_id,
1197: source_lang = USERENV('LANG'),
1198: trigger_name = l_trig_rec.trigger_name,
1199: description = l_trig_rec.description
1192: last_update_date = SYSDATE,
1193: last_upated_by = FND_GLOBAL.user_id,
1194: creation_date = SYSDATE,
1195: created_by = FND_GLOBAL.user_id,
1196: last_update_login = FND_GLOBAL.user_id,
1197: source_lang = USERENV('LANG'),
1198: trigger_name = l_trig_rec.trigger_name,
1199: description = l_trig_rec.description
1200: -- removed by soagrawa on 24-sep-2001