APPS.OZF_UTILITY_PVT dependencies on AMS_ACT_LOGS

Line 574: l_act_log_id ams_act_logs.activity_log_id%TYPE;

570: )
571: IS
572: PRAGMA AUTONOMOUS_TRANSACTION;
573: x_rowid VARCHAR2(30);
574: l_act_log_id ams_act_logs.activity_log_id%TYPE;
575: l_log_tran_id ams_act_logs.log_transaction_id%TYPE;
576:
577: CURSOR c_log_seq IS
578: SELECT ams_act_logs_s.NEXTVAL,

Line 575: l_log_tran_id ams_act_logs.log_transaction_id%TYPE;

571: IS
572: PRAGMA AUTONOMOUS_TRANSACTION;
573: x_rowid VARCHAR2(30);
574: l_act_log_id ams_act_logs.activity_log_id%TYPE;
575: l_log_tran_id ams_act_logs.log_transaction_id%TYPE;
576:
577: CURSOR c_log_seq IS
578: SELECT ams_act_logs_s.NEXTVAL,
579: ams_act_logs_transaction_id_s.NEXTVAL

Line 578: SELECT ams_act_logs_s.NEXTVAL,

574: l_act_log_id ams_act_logs.activity_log_id%TYPE;
575: l_log_tran_id ams_act_logs.log_transaction_id%TYPE;
576:
577: CURSOR c_log_seq IS
578: SELECT ams_act_logs_s.NEXTVAL,
579: ams_act_logs_transaction_id_s.NEXTVAL
580: FROM DUAL;
581:
582: CURSOR c_log(l_my_log_id VARCHAR2) IS

Line 579: ams_act_logs_transaction_id_s.NEXTVAL

575: l_log_tran_id ams_act_logs.log_transaction_id%TYPE;
576:
577: CURSOR c_log_seq IS
578: SELECT ams_act_logs_s.NEXTVAL,
579: ams_act_logs_transaction_id_s.NEXTVAL
580: FROM DUAL;
581:
582: CURSOR c_log(l_my_log_id VARCHAR2) IS
583: SELECT rowid

Line 584: FROM ams_act_logs

580: FROM DUAL;
581:
582: CURSOR c_log(l_my_log_id VARCHAR2) IS
583: SELECT rowid
584: FROM ams_act_logs
585: WHERE activity_log_id = l_my_log_id;
586:
587: BEGIN
588:

Line 605: INSERT INTO ams_act_logs (

601: FETCH c_log_seq INTO l_act_log_id,l_log_tran_id ;
602: CLOSE c_log_seq;
603:
604:
605: INSERT INTO ams_act_logs (
606: activity_log_id
607: -- standard who columns
608: ,last_update_date
609: ,last_updated_by