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.

APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on AMW_OPINION_DETAILS

Line 559: update amw_opinion_details set opinion_value_id =eff_details_rec.control_opinion,

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:
558: if eff_details_rec.control_opinion is not null then
559: update amw_opinion_details set opinion_value_id =eff_details_rec.control_opinion,
560: summary_txt = eff_details_rec.ctrl_overall_summary,
561: description_txt = eff_details_rec.ctrl_overall_description
562: where opinion_id = v_opinions_upd_id and opinion_component_id = v_overall;
563: commit;

Line 567: update amw_opinion_details set opinion_value_id =eff_details_rec.design_effectiveness,

563: commit;
564: end if;
565:
566: if eff_details_rec.design_effectiveness is not null then
567: update amw_opinion_details set opinion_value_id =eff_details_rec.design_effectiveness,
568: summary_txt = eff_details_rec.ctrl_design_summary,
569: description_txt = eff_details_rec.ctrl_design_description
570: where opinion_id = v_opinions_upd_id and opinion_component_id = v_design;
571: commit;

Line 575: update amw_opinion_details set opinion_value_id =eff_details_rec.op_effectiveness,

571: commit;
572: end if;
573:
574: if eff_details_rec.op_effectiveness is not null then
575: update amw_opinion_details set opinion_value_id =eff_details_rec.op_effectiveness,
576: summary_txt = eff_details_rec.ctrl_operating_summary,
577: description_txt = eff_details_rec.ctrl_operating_description
578: where opinion_id = v_opinions_upd_id and opinion_component_id = v_operating;
579: commit;

Line 614: -- Inserting into amw_opinion_details table

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;
614: -- Inserting into amw_opinion_details table
615:
616: INSERT into amw_opinion_details(opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,
617: last_update_date,last_updated_by,creation_date,created_by,last_update_login,object_version_number
618: ,summary_txt,description_txt) values

Line 616: INSERT into amw_opinion_details(opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,

612:
613: commit;
614: -- Inserting into amw_opinion_details table
615:
616: INSERT into amw_opinion_details(opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,
617: last_update_date,last_updated_by,creation_date,created_by,last_update_login,object_version_number
618: ,summary_txt,description_txt) values
619: (AMW_OPINION_DETAILS_S1.nextval,v_opinion_id,v_overall,eff_details_rec.control_opinion,
620: sysdate,G_USER_ID,sysdate,G_USER_ID,G_LOGIN_ID,1,eff_details_rec.ctrl_overall_summary,eff_details_rec.ctrl_overall_description);

Line 619: (AMW_OPINION_DETAILS_S1.nextval,v_opinion_id,v_overall,eff_details_rec.control_opinion,

615:
616: INSERT into amw_opinion_details(opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,
617: last_update_date,last_updated_by,creation_date,created_by,last_update_login,object_version_number
618: ,summary_txt,description_txt) values
619: (AMW_OPINION_DETAILS_S1.nextval,v_opinion_id,v_overall,eff_details_rec.control_opinion,
620: sysdate,G_USER_ID,sysdate,G_USER_ID,G_LOGIN_ID,1,eff_details_rec.ctrl_overall_summary,eff_details_rec.ctrl_overall_description);
621:
622: commit;
623: INSERT into amw_opinion_details(opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,

Line 623: INSERT into amw_opinion_details(opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,

619: (AMW_OPINION_DETAILS_S1.nextval,v_opinion_id,v_overall,eff_details_rec.control_opinion,
620: sysdate,G_USER_ID,sysdate,G_USER_ID,G_LOGIN_ID,1,eff_details_rec.ctrl_overall_summary,eff_details_rec.ctrl_overall_description);
621:
622: commit;
623: INSERT into amw_opinion_details(opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,
624: last_update_date,last_updated_by,creation_date,created_by,last_update_login,object_version_number
625: ,summary_txt,description_txt) values
626: (AMW_OPINION_DETAILS_S1.nextval,v_opinion_id,v_design,eff_details_rec.design_effectiveness,
627: sysdate,G_USER_ID,sysdate,G_USER_ID,G_LOGIN_ID,1,eff_details_rec.ctrl_design_summary,eff_details_rec.ctrl_design_description);

Line 626: (AMW_OPINION_DETAILS_S1.nextval,v_opinion_id,v_design,eff_details_rec.design_effectiveness,

622: commit;
623: INSERT into amw_opinion_details(opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,
624: last_update_date,last_updated_by,creation_date,created_by,last_update_login,object_version_number
625: ,summary_txt,description_txt) values
626: (AMW_OPINION_DETAILS_S1.nextval,v_opinion_id,v_design,eff_details_rec.design_effectiveness,
627: sysdate,G_USER_ID,sysdate,G_USER_ID,G_LOGIN_ID,1,eff_details_rec.ctrl_design_summary,eff_details_rec.ctrl_design_description);
628: commit;
629:
630: INSERT into amw_opinion_details(opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,

Line 630: INSERT into amw_opinion_details(opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,

626: (AMW_OPINION_DETAILS_S1.nextval,v_opinion_id,v_design,eff_details_rec.design_effectiveness,
627: sysdate,G_USER_ID,sysdate,G_USER_ID,G_LOGIN_ID,1,eff_details_rec.ctrl_design_summary,eff_details_rec.ctrl_design_description);
628: commit;
629:
630: INSERT into amw_opinion_details(opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,
631: last_update_date,last_updated_by,creation_date,created_by,last_update_login,object_version_number
632: ,summary_txt,description_txt) values
633: (AMW_OPINION_DETAILS_S1.nextval,v_opinion_id,v_operating,eff_details_rec.op_effectiveness,
634: sysdate,G_USER_ID,sysdate,G_USER_ID,G_LOGIN_ID,1,eff_details_rec.ctrl_operating_summary,eff_details_rec.ctrl_operating_description);

Line 633: (AMW_OPINION_DETAILS_S1.nextval,v_opinion_id,v_operating,eff_details_rec.op_effectiveness,

629:
630: INSERT into amw_opinion_details(opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,
631: last_update_date,last_updated_by,creation_date,created_by,last_update_login,object_version_number
632: ,summary_txt,description_txt) values
633: (AMW_OPINION_DETAILS_S1.nextval,v_opinion_id,v_operating,eff_details_rec.op_effectiveness,
634: sysdate,G_USER_ID,sysdate,G_USER_ID,G_LOGIN_ID,1,eff_details_rec.ctrl_operating_summary,eff_details_rec.ctrl_operating_description);
635: commit;
636:
637: end if;

Line 658: select opinion_detail_id into v_overall_detail_logid from amw_opinion_details

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:
657:
658: select opinion_detail_id into v_overall_detail_logid from amw_opinion_details
659: where opinion_id = v_opinions_logid and opinion_component_id = v_overall;
660:
661: select opinion_detail_id into v_design_detail_logid from amw_opinion_details
662: where opinion_id = v_opinions_logid and opinion_component_id = v_design;

Line 661: select opinion_detail_id into v_design_detail_logid from amw_opinion_details

657:
658: select opinion_detail_id into v_overall_detail_logid from amw_opinion_details
659: where opinion_id = v_opinions_logid and opinion_component_id = v_overall;
660:
661: select opinion_detail_id into v_design_detail_logid from amw_opinion_details
662: where opinion_id = v_opinions_logid and opinion_component_id = v_design;
663:
664: select opinion_detail_id into v_operating_detail_logid from amw_opinion_details
665: where opinion_id = v_opinions_logid and opinion_component_id = v_operating;

Line 664: select opinion_detail_id into v_operating_detail_logid from amw_opinion_details

660:
661: select opinion_detail_id into v_design_detail_logid from amw_opinion_details
662: where opinion_id = v_opinions_logid and opinion_component_id = v_design;
663:
664: select opinion_detail_id into v_operating_detail_logid from amw_opinion_details
665: where opinion_id = v_opinions_logid and opinion_component_id = v_operating;
666:
667:
668: if v_opinions_logid is not null then