APPS.AMW_RISK_APPROVAL_PVT dependencies on AMW_RISKS_B

Line 1110: FROM amw_risks_b risk1, amw_risks_b risk2

1106: l_approver_id NUMBER;
1107: l_old_appr_risk_rev_id NUMBER;
1108: CURSOR c_old_appr_risk (p_risk_rev_id IN NUMBER) IS
1109: SELECT risk2.risk_rev_id
1110: FROM amw_risks_b risk1, amw_risks_b risk2
1111: WHERE risk1.risk_id = risk2.risk_id
1112: AND risk1.risk_rev_id = p_risk_rev_id
1113: AND risk2.curr_approved_flag = 'Y'
1114: AND risk2.latest_revision_flag = 'N';

Line 1156: UPDATE amw_risks_b

1152: INTO l_old_appr_risk_rev_id;
1153: CLOSE c_old_appr_risk;
1154: IF (l_update_status = 'APPROVED') THEN
1155: -- Update the status of the Risk object to 'A' -- Approved
1156: UPDATE amw_risks_b
1157: SET approval_status = 'A',
1158: object_version_number = object_version_number + 1,
1159: curr_approved_flag = 'Y',
1160: latest_revision_flag = 'Y',

Line 1165: UPDATE amw_risks_b

1161: approval_date = SYSDATE
1162: WHERE risk_rev_id = l_risk_rev_id
1163: AND object_version_number = l_object_version_number;
1164: IF l_old_appr_risk_rev_id IS NOT NULL THEN
1165: UPDATE amw_risks_b
1166: SET object_version_number = object_version_number + 1,
1167: curr_approved_flag = 'N',
1168: latest_revision_flag = 'N',
1169: end_date = SYSDATE

Line 1176: UPDATE amw_risks_b

1172: ELSIF (l_update_status = 'REJECTED') THEN
1173:
1174: -- Update the status of the CTRL object to 'R' -- Rejected
1175: IF l_old_appr_risk_rev_id IS NOT NULL THEN
1176: UPDATE amw_risks_b
1177: SET object_version_number = object_version_number + 1,
1178: latest_revision_flag = 'Y'
1179: WHERE risk_rev_id = l_old_appr_risk_rev_id;
1180: UPDATE amw_risks_b

Line 1180: UPDATE amw_risks_b

1176: UPDATE amw_risks_b
1177: SET object_version_number = object_version_number + 1,
1178: latest_revision_flag = 'Y'
1179: WHERE risk_rev_id = l_old_appr_risk_rev_id;
1180: UPDATE amw_risks_b
1181: SET approval_status = 'R',
1182: object_version_number = object_version_number + 1,
1183: curr_approved_flag = 'N',
1184: latest_revision_flag = 'N',

Line 1189: UPDATE amw_risks_b

1185: end_date = SYSDATE
1186: WHERE risk_rev_id = l_risk_rev_id
1187: AND object_version_number = l_object_version_number;
1188: ELSE
1189: UPDATE amw_risks_b
1190: SET approval_status = 'R',
1191: object_version_number = object_version_number + 1,
1192: curr_approved_flag = 'N',
1193: latest_revision_flag = 'Y',

Line 1200: UPDATE amw_risks_b

1196: AND object_version_number = l_object_version_number;
1197: END IF;
1198: ELSE
1199: -- Update the status of the Risk object to 'D' -- Draft
1200: UPDATE amw_risks_b
1201: SET approval_status = 'D',
1202: object_version_number = object_version_number + 1
1203: --curr_approved_flag = 'N',
1204: --latest_revision_flag ='Y'