APPS.AMW_CM_EVENT_LISTNER_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 29

select entity_name,pk1_value,pk2_value,pk3_value
into ename, pk1, pk2, pk3
from eng_change_subjects
where change_id = p_ChangeId
and change_line_id is null
and subject_level=1;

Line: 88

procedure UPDATE_APPROVAL_STATUS(
   p_change_id 			in number
  ,p_base_change_mgmt_type_code in varchar2
  ,p_new_approval_status_code   in varchar2
  ,p_workflow_status_code	in varchar2
  ,x_return_status		out nocopy varchar2
  ,x_msg_count			out nocopy number
  ,x_msg_data 			out nocopy varchar2
)
is
   dummy1  varchar2(100);

Line: 117

   select entity_name,pk1_value,pk2_value,pk3_value
     into l_ename, l_pk1, l_pk2, l_pk3
     from eng_change_subjects
    where change_id = p_change_id
      and change_line_id is null
      and subject_level=1;

Line: 172

      /* update the Engagement status */
      IF l_sign_off_status = 'APPROVED' THEN
        UPDATE AMW_AUDIT_PROJECTS
        SET audit_project_status = 'SIGN',
            sign_off_status = 'APPROVED'
        WHERE AUDIT_PROJECT_ID = l_audit_project_id
          AND AUDIT_PROJECT_STATUS = 'ACTI';

Line: 179

      ELSE  /* Update the signOffStatus. */
        UPDATE AMW_AUDIT_PROJECTS
        SET sign_off_status = l_sign_off_status
        WHERE AUDIT_PROJECT_ID = l_audit_project_id;

Line: 196

end UPDATE_APPROVAL_STATUS;