APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on AMW_OPINIONS_LOG

Line 644: select AMW_OPINIONS_LOG_S.nextval into v_opinion_log_id from dual;

640: commit;
641:
642: -- Inserting into Opinion Log Tables
643:
644: select AMW_OPINIONS_LOG_S.nextval into v_opinion_log_id from dual;
645:
646:
647: select opinion_id into v_opinions_logid from amw_opinions where
648: pk1_value = eff_details_rec.control_id and pk2_value = eff_details_rec.audit_project_id and

Line 671: -- Inserting into amw_opinions_log table

667:
668: if v_opinions_logid is not null then
669:
670:
671: -- Inserting into amw_opinions_log table
672:
673: INSERT into amw_opinions_log(opinion_log_id,opinion_set_id,opinion_id,object_opinion_type_id,pk1_value,pk2_value,
674: pk3_value,pk4_value,pk5_value,party_id,authored_by,authored_date,last_update_date,last_updated_by,
675: creation_date,created_by,last_update_login) values

Line 673: INSERT into amw_opinions_log(opinion_log_id,opinion_set_id,opinion_id,object_opinion_type_id,pk1_value,pk2_value,

669:
670:
671: -- Inserting into amw_opinions_log table
672:
673: INSERT into amw_opinions_log(opinion_log_id,opinion_set_id,opinion_id,object_opinion_type_id,pk1_value,pk2_value,
674: pk3_value,pk4_value,pk5_value,party_id,authored_by,authored_date,last_update_date,last_updated_by,
675: creation_date,created_by,last_update_login) values
676: (v_opinion_log_id,v_opinions_set_logid,v_opinions_logid,v_opinion_object_id,eff_details_rec.control_id,eff_details_rec.audit_project_id,
677: eff_details_rec.organization_id,eff_details_rec.audit_procedure_id,eff_details_rec.task_id,v_party_id,G_LOGIN_ID,sysdate,sysdate,G_USER_ID,