APPS.AMW_CTRL_APPROVAL_PVT dependencies on AMW_CONTROLS_B

Line 1249: FROM amw_controls_b CTRL1 , amw_controls_b CTRL2

1245: l_old_appr_CTRL_rev_id NUMBER;
1246:
1247: CURSOR c_old_appr_CTRL(p_CTRL_rev_id In NUMBER) IS
1248: SELECT CTRL2.Control_REV_ID
1249: FROM amw_controls_b CTRL1 , amw_controls_b CTRL2
1250: WHERE CTRL1.Control_id = CTRL2.control_id
1251: AND CTRL1.control_rev_id = p_CTRL_rev_id
1252: AND CTRL2.curr_approved_flag= 'Y' and CTRL2.latest_revision_flag = 'N' ;
1253:

Line 1306: update amw_controls_b

1302: CLOSE c_old_appr_CTRL;
1303:
1304: IF ( l_update_status = 'APPROVED' ) THEN
1305: -- Update the status of the CTRL object to 'A' -- Approved
1306: update amw_controls_b
1307: set
1308: approval_status = 'A',
1309: object_version_number = object_version_number+1,
1310: curr_approved_flag = 'Y',

Line 1319: update amw_controls_b

1315:
1316:
1317: IF l_old_appr_CTRL_rev_id IS NOT NULL THEN
1318:
1319: update amw_controls_b
1320: set
1321: object_version_number = object_version_number+1,
1322: curr_approved_flag = 'N',
1323: latest_revision_flag ='N' ,

Line 1331: UPDATE amw_controls_b

1327: END IF;
1328: ELSIF ( l_update_status = 'REJECTED' ) THEN
1329: -- Update the status of the CTRL object to 'R' -- Rejected
1330: IF l_old_appr_CTRL_rev_id IS NOT NULL THEN
1331: UPDATE amw_controls_b
1332: SET object_version_number = object_version_number + 1,
1333: latest_revision_flag = 'Y'
1334: WHERE control_rev_id = l_old_appr_CTRL_rev_id;
1335:

Line 1336: UPDATE amw_controls_b

1332: SET object_version_number = object_version_number + 1,
1333: latest_revision_flag = 'Y'
1334: WHERE control_rev_id = l_old_appr_CTRL_rev_id;
1335:
1336: UPDATE amw_controls_b
1337: SET approval_status = 'R',
1338: object_version_number = object_version_number + 1,
1339: curr_approved_flag = 'N',
1340: latest_revision_flag = 'N',

Line 1345: UPDATE amw_controls_b

1341: end_date = SYSDATE
1342: WHERE control_rev_id = l_CTRL_rev_id
1343: AND object_version_number = l_object_version_number;
1344: ELSE
1345: UPDATE amw_controls_b
1346: SET approval_status = 'R',
1347: object_version_number = object_version_number + 1,
1348: curr_approved_flag = 'N',
1349: latest_revision_flag = 'Y',

Line 1356: update amw_controls_b

1352: AND object_version_number = l_object_version_number;
1353: END IF;
1354: /* mpande commented 11/25/2003 and added the above code to take care of first time rejection
1355: -- Update the status of the CTRL object to 'R' -- Rejected
1356: update amw_controls_b
1357: set
1358: approval_status = 'R',
1359: object_version_number = object_version_number+1,
1360: curr_approved_flag = 'N',

Line 1367: update amw_controls_b

1363: where control_rev_id = l_CTRL_rev_id
1364: and object_version_number = l_object_version_number ;
1365:
1366: IF l_old_appr_CTRL_rev_id IS NOT NULL THEN
1367: update amw_controls_b
1368: set
1369: object_version_number = object_version_number+1,
1370: latest_revision_flag ='Y'
1371: where control_rev_id = l_old_appr_CTRL_rev_id;

Line 1377: update amw_controls_b

1373: END IF;
1374: */
1375: ELSE
1376: -- Update the status of the CTRL object to 'D' -- Draft
1377: update amw_controls_b
1378: set
1379: approval_status = 'D',
1380: object_version_number = object_version_number+1
1381: --curr_approved_flag = 'N',