DBA Data[Home] [Help]

APPS.AMS_CPYUTILITY_PVT dependencies on AMS_ACT_LOGS

Line 397: SELECT ams_Act_logs_transaction_id_s.nextval

393: PROCEDURE insert_log_mesg (x_transaction_id OUT NOCOPY NUMBER)
394: IS
395: PRAGMA AUTONOMOUS_TRANSACTION;
396: BEGIN
397: SELECT ams_Act_logs_transaction_id_s.nextval
398: into x_transaction_id
399: FROM DUAL;
400: IF g_index <> 0
401: THEN

Line 404: INSERT INTO ams_act_logs

400: IF g_index <> 0
401: THEN
402: FOR i IN 1 .. g_index
403: LOOP
404: INSERT INTO ams_act_logs
405: (
406: activity_log_id,
407: last_update_date,
408: last_updated_by,

Line 419: ams_act_logs_s.nextval,

415: log_message_text,
416: log_message_type
417: )
418: VALUES (
419: ams_act_logs_s.nextval,
420: SYSDATE,
421: fnd_global.user_id,
422: SYSDATE,
423: fnd_global.user_id,