APPS.AMW_CONTROLS_PAGE_PKG dependencies on AMW_CONTROLS_B

Line 903: FROM amw_controls_b CTRL1 , amw_controls_b CTRL2

899: )
900: IS
901: CURSOR c_old_appr_CTRL(p_CTRL_rev_id In NUMBER) IS
902: SELECT CTRL2.Control_REV_ID
903: FROM amw_controls_b CTRL1 , amw_controls_b CTRL2
904: WHERE CTRL1.Control_id = CTRL2.control_id
905: AND CTRL1.control_rev_id = p_CTRL_rev_id
906: AND CTRL2.curr_approved_flag= 'Y'
907: and CTRL2.latest_revision_flag = 'N';

Line 939: update amw_controls_b

935: OPEN c_old_appr_CTRL(P_CONTROL_REV_ID) ;
936: FETCH c_old_appr_CTRL INTO l_old_appr_CTRL_rev_id;
937: CLOSE c_old_appr_CTRL;
938:
939: update amw_controls_b
940: set approval_status='A'
941: --,object_version_number=object_version_number+1
942: ,curr_approved_flag='Y'
943: ,latest_revision_flag ='Y'

Line 951: UPDATE AMW_CONTROLS_B

947: ,LAST_UPDATE_LOGIN=G_LOGIN_ID
948: where control_rev_id=P_CONTROL_REV_ID;
949:
950: IF (l_old_appr_CTRL_rev_id IS NOT NULL) THEN
951: UPDATE AMW_CONTROLS_B
952: SET END_DATE=SYSDATE
953: ,CURR_APPROVED_FLAG='N'
954: ,LATEST_REVISION_FLAG='N'
955: --,OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1