APPS.OZF_UTILITY_PVT dependencies on AMS_ACT_LOGS

Line 591: l_act_log_id ams_act_logs.activity_log_id%TYPE;

587: )
588: IS
589: PRAGMA AUTONOMOUS_TRANSACTION;
590: x_rowid VARCHAR2(30);
591: l_act_log_id ams_act_logs.activity_log_id%TYPE;
592: l_log_tran_id ams_act_logs.log_transaction_id%TYPE;
593:
594: CURSOR c_log_seq IS
595: SELECT ams_act_logs_s.NEXTVAL,

Line 592: l_log_tran_id ams_act_logs.log_transaction_id%TYPE;

588: IS
589: PRAGMA AUTONOMOUS_TRANSACTION;
590: x_rowid VARCHAR2(30);
591: l_act_log_id ams_act_logs.activity_log_id%TYPE;
592: l_log_tran_id ams_act_logs.log_transaction_id%TYPE;
593:
594: CURSOR c_log_seq IS
595: SELECT ams_act_logs_s.NEXTVAL,
596: ams_act_logs_transaction_id_s.NEXTVAL

Line 595: SELECT ams_act_logs_s.NEXTVAL,

591: l_act_log_id ams_act_logs.activity_log_id%TYPE;
592: l_log_tran_id ams_act_logs.log_transaction_id%TYPE;
593:
594: CURSOR c_log_seq IS
595: SELECT ams_act_logs_s.NEXTVAL,
596: ams_act_logs_transaction_id_s.NEXTVAL
597: FROM DUAL;
598:
599: CURSOR c_log(l_my_log_id VARCHAR2) IS

Line 596: ams_act_logs_transaction_id_s.NEXTVAL

592: l_log_tran_id ams_act_logs.log_transaction_id%TYPE;
593:
594: CURSOR c_log_seq IS
595: SELECT ams_act_logs_s.NEXTVAL,
596: ams_act_logs_transaction_id_s.NEXTVAL
597: FROM DUAL;
598:
599: CURSOR c_log(l_my_log_id VARCHAR2) IS
600: SELECT rowid

Line 601: FROM ams_act_logs

597: FROM DUAL;
598:
599: CURSOR c_log(l_my_log_id VARCHAR2) IS
600: SELECT rowid
601: FROM ams_act_logs
602: WHERE activity_log_id = l_my_log_id;
603:
604: BEGIN
605:

Line 622: INSERT INTO ams_act_logs (

618: FETCH c_log_seq INTO l_act_log_id,l_log_tran_id ;
619: CLOSE c_log_seq;
620:
621:
622: INSERT INTO ams_act_logs (
623: activity_log_id
624: -- standard who columns
625: ,last_update_date
626: ,last_updated_by