eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on AMW_OPINIONS

Line 545: select count(*) into v_opinions_cnt from amw_opinions where

541: fnd_file.put_line (fnd_file.LOG, 'Association id is null for'||
542: eff_details_rec.ap_interface_id||' Batch Id '||p_batch_id);
543:
544: else
545: select count(*) into v_opinions_cnt from amw_opinions where
546: pk1_value = eff_details_rec.control_id and pk2_value = eff_details_rec.audit_project_id and
547: pk3_value = eff_details_rec.organization_id and pk4_value = eff_details_rec.audit_procedure_id and
548: pk5_value = eff_details_rec.task_id;
549:

Line 553: select opinion_id into v_opinions_upd_id from amw_opinions where

549:
550:
551: if v_opinions_cnt <> 0 then
552:
553: select opinion_id into v_opinions_upd_id from amw_opinions where
554: pk1_value = eff_details_rec.control_id and pk2_value = eff_details_rec.audit_project_id and
555: pk3_value = eff_details_rec.organization_id and pk4_value = eff_details_rec.audit_procedure_id and
556: pk5_value = eff_details_rec.task_id;
557:

Line 602: select AMW_OPINIONS_S2.nextval into v_opinion_id from dual;

598:
599: if eff_details_rec.control_opinion is not null then
600:
601:
602: select AMW_OPINIONS_S2.nextval into v_opinion_id from dual;
603:
604: -- Inserting into amw_opinions table
605:
606: INSERT into amw_opinions(opinion_set_id,opinion_id,object_opinion_type_id,pk1_value,pk2_value,

Line 604: -- Inserting into amw_opinions table

600:
601:
602: select AMW_OPINIONS_S2.nextval into v_opinion_id from dual;
603:
604: -- Inserting into amw_opinions table
605:
606: INSERT into amw_opinions(opinion_set_id,opinion_id,object_opinion_type_id,pk1_value,pk2_value,
607: pk3_value,pk4_value,pk5_value,party_id,authored_by,authored_date,last_update_date,last_updated_by,
608: creation_date,created_by,last_update_login) values

Line 606: INSERT into amw_opinions(opinion_set_id,opinion_id,object_opinion_type_id,pk1_value,pk2_value,

602: select AMW_OPINIONS_S2.nextval into v_opinion_id from dual;
603:
604: -- Inserting into amw_opinions table
605:
606: INSERT into amw_opinions(opinion_set_id,opinion_id,object_opinion_type_id,pk1_value,pk2_value,
607: pk3_value,pk4_value,pk5_value,party_id,authored_by,authored_date,last_update_date,last_updated_by,
608: creation_date,created_by,last_update_login) values
609: (AMW_OPINIONS_S1.nextval,v_opinion_id,v_opinion_object_id,eff_details_rec.control_id,eff_details_rec.audit_project_id,
610: 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,

Line 609: (AMW_OPINIONS_S1.nextval,v_opinion_id,v_opinion_object_id,eff_details_rec.control_id,eff_details_rec.audit_project_id,

605:
606: INSERT into amw_opinions(opinion_set_id,opinion_id,object_opinion_type_id,pk1_value,pk2_value,
607: pk3_value,pk4_value,pk5_value,party_id,authored_by,authored_date,last_update_date,last_updated_by,
608: creation_date,created_by,last_update_login) values
609: (AMW_OPINIONS_S1.nextval,v_opinion_id,v_opinion_object_id,eff_details_rec.control_id,eff_details_rec.audit_project_id,
610: 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,
611: sysdate,G_USER_ID,G_LOGIN_ID);
612:
613: commit;

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 647: select opinion_id into v_opinions_logid from amw_opinions where

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
649: pk3_value = eff_details_rec.organization_id and pk4_value = eff_details_rec.audit_procedure_id and
650: pk5_value = eff_details_rec.task_id;
651:

Line 652: select opinion_set_id into v_opinions_set_logid from amw_opinions where

648: pk1_value = eff_details_rec.control_id and pk2_value = eff_details_rec.audit_project_id and
649: pk3_value = eff_details_rec.organization_id and pk4_value = eff_details_rec.audit_procedure_id and
650: pk5_value = eff_details_rec.task_id;
651:
652: select opinion_set_id into v_opinions_set_logid from amw_opinions where
653: pk1_value = eff_details_rec.control_id and pk2_value = eff_details_rec.audit_project_id and
654: pk3_value = eff_details_rec.organization_id and pk4_value = eff_details_rec.audit_procedure_id and
655: pk5_value = eff_details_rec.task_id;
656:

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,