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_LOG_DETAILS

Line 685: -- Inserting into amw_opinion_log_details table

681:
682:
683: if v_overall_detail_logid is not null then
684:
685: -- Inserting into amw_opinion_log_details table
686:
687:
688: INSERT into amw_opinion_log_details(opinion_log_id,opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,
689: last_update_date,last_updated_by,creation_date,created_by,last_update_login,object_version_number

Line 688: INSERT into amw_opinion_log_details(opinion_log_id,opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,

684:
685: -- Inserting into amw_opinion_log_details table
686:
687:
688: INSERT into amw_opinion_log_details(opinion_log_id,opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,
689: last_update_date,last_updated_by,creation_date,created_by,last_update_login,object_version_number
690: ,summary_txt,description_txt,opinion_log_detail_id) values
691: (v_opinion_log_id,v_overall_detail_logid,v_opinions_logid,v_overall,eff_details_rec.control_opinion,
692: 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 693: ,AMW_OPINION_LOG_DETAILS_S.nextval);

689: last_update_date,last_updated_by,creation_date,created_by,last_update_login,object_version_number
690: ,summary_txt,description_txt,opinion_log_detail_id) values
691: (v_opinion_log_id,v_overall_detail_logid,v_opinions_logid,v_overall,eff_details_rec.control_opinion,
692: sysdate,G_USER_ID,sysdate,G_USER_ID,G_LOGIN_ID,1,eff_details_rec.ctrl_overall_summary,eff_details_rec.ctrl_overall_description
693: ,AMW_OPINION_LOG_DETAILS_S.nextval);
694:
695: commit;
696:
697: if v_design_detail_logid is not null then

Line 699: INSERT into amw_opinion_log_details(opinion_log_id,opinion_log_detail_id,opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,

695: commit;
696:
697: if v_design_detail_logid is not null then
698:
699: INSERT into amw_opinion_log_details(opinion_log_id,opinion_log_detail_id,opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,
700: last_update_date,last_updated_by,creation_date,created_by,last_update_login,object_version_number
701: ,summary_txt,description_txt) values
702: (v_opinion_log_id,AMW_OPINION_LOG_DETAILS_S.nextval,v_design_detail_logid,v_opinions_logid,v_design,eff_details_rec.design_effectiveness,
703: 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 702: (v_opinion_log_id,AMW_OPINION_LOG_DETAILS_S.nextval,v_design_detail_logid,v_opinions_logid,v_design,eff_details_rec.design_effectiveness,

698:
699: INSERT into amw_opinion_log_details(opinion_log_id,opinion_log_detail_id,opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,
700: last_update_date,last_updated_by,creation_date,created_by,last_update_login,object_version_number
701: ,summary_txt,description_txt) values
702: (v_opinion_log_id,AMW_OPINION_LOG_DETAILS_S.nextval,v_design_detail_logid,v_opinions_logid,v_design,eff_details_rec.design_effectiveness,
703: sysdate,G_USER_ID,sysdate,G_USER_ID,G_LOGIN_ID,1,eff_details_rec.ctrl_design_summary,eff_details_rec.ctrl_design_description);
704: commit;
705:
706: end if;

Line 710: INSERT into amw_opinion_log_details(opinion_log_id,opinion_log_detail_id,opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,

706: end if;
707:
708: if v_operating_detail_logid is not null then
709:
710: INSERT into amw_opinion_log_details(opinion_log_id,opinion_log_detail_id,opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,
711: last_update_date,last_updated_by,creation_date,created_by,last_update_login,object_version_number
712: ,summary_txt,description_txt) values
713: (v_opinion_log_id,AMW_OPINION_LOG_DETAILS_S.nextval,v_operating_detail_logid,v_opinions_logid,v_operating,eff_details_rec.op_effectiveness,
714: 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 713: (v_opinion_log_id,AMW_OPINION_LOG_DETAILS_S.nextval,v_operating_detail_logid,v_opinions_logid,v_operating,eff_details_rec.op_effectiveness,

709:
710: INSERT into amw_opinion_log_details(opinion_log_id,opinion_log_detail_id,opinion_detail_id,opinion_id,opinion_component_id,opinion_value_id,
711: last_update_date,last_updated_by,creation_date,created_by,last_update_login,object_version_number
712: ,summary_txt,description_txt) values
713: (v_opinion_log_id,AMW_OPINION_LOG_DETAILS_S.nextval,v_operating_detail_logid,v_opinions_logid,v_operating,eff_details_rec.op_effectiveness,
714: sysdate,G_USER_ID,sysdate,G_USER_ID,G_LOGIN_ID,1,eff_details_rec.ctrl_operating_summary,eff_details_rec.ctrl_operating_description);
715: commit;
716:
717: end if;