APPS.AMS_UTILITY_PVT dependencies on AMS_ACT_LOGS

Line 535: l_act_log_id ams_act_logs.activity_log_id%TYPE;

531: )
532: IS
533: PRAGMA AUTONOMOUS_TRANSACTION;
534: x_rowid VARCHAR2(30);
535: l_act_log_id ams_act_logs.activity_log_id%TYPE;
536: l_log_tran_id ams_act_logs.log_transaction_id%TYPE;
537:
538: CURSOR c_log_seq IS
539: SELECT ams_act_logs_s.NEXTVAL,

Line 536: l_log_tran_id ams_act_logs.log_transaction_id%TYPE;

532: IS
533: PRAGMA AUTONOMOUS_TRANSACTION;
534: x_rowid VARCHAR2(30);
535: l_act_log_id ams_act_logs.activity_log_id%TYPE;
536: l_log_tran_id ams_act_logs.log_transaction_id%TYPE;
537:
538: CURSOR c_log_seq IS
539: SELECT ams_act_logs_s.NEXTVAL,
540: ams_act_logs_transaction_id_s.NEXTVAL

Line 539: SELECT ams_act_logs_s.NEXTVAL,

535: l_act_log_id ams_act_logs.activity_log_id%TYPE;
536: l_log_tran_id ams_act_logs.log_transaction_id%TYPE;
537:
538: CURSOR c_log_seq IS
539: SELECT ams_act_logs_s.NEXTVAL,
540: ams_act_logs_transaction_id_s.NEXTVAL
541: FROM DUAL;
542:
543: CURSOR c_log(l_my_log_id VARCHAR2) IS

Line 540: ams_act_logs_transaction_id_s.NEXTVAL

536: l_log_tran_id ams_act_logs.log_transaction_id%TYPE;
537:
538: CURSOR c_log_seq IS
539: SELECT ams_act_logs_s.NEXTVAL,
540: ams_act_logs_transaction_id_s.NEXTVAL
541: FROM DUAL;
542:
543: CURSOR c_log(l_my_log_id VARCHAR2) IS
544: SELECT rowid

Line 545: FROM ams_act_logs

541: FROM DUAL;
542:
543: CURSOR c_log(l_my_log_id VARCHAR2) IS
544: SELECT rowid
545: FROM ams_act_logs
546: WHERE activity_log_id = l_my_log_id;
547:
548: BEGIN
549:

Line 566: INSERT INTO ams_act_logs (

562: FETCH c_log_seq INTO l_act_log_id,l_log_tran_id ;
563: CLOSE c_log_seq;
564:
565:
566: INSERT INTO ams_act_logs (
567: activity_log_id
568: -- standard who columns
569: ,last_update_date
570: ,last_updated_by