1332: UPDATE AHL_UNIT_DEFERRALS_B
1333: SET approval_status_code = 'DEFERRAL_REJECTED',
1334: object_version_number = object_version_number + 1,
1335: last_update_date = sysdate,
1336: last_updated_by = fnd_global.user_id,
1337: last_update_login = fnd_global.login_id
1338: WHERE unit_deferral_id = l_object_id;
1339: COMMIT WORK;
1340:
1333: SET approval_status_code = 'DEFERRAL_REJECTED',
1334: object_version_number = object_version_number + 1,
1335: last_update_date = sysdate,
1336: last_updated_by = fnd_global.user_id,
1337: last_update_login = fnd_global.login_id
1338: WHERE unit_deferral_id = l_object_id;
1339: COMMIT WORK;
1340:
1341: RAISE;
1353: UPDATE AHL_UNIT_DEFERRALS_B
1354: SET approval_status_code = 'DEFERRAL_REJECTED',
1355: object_version_number = object_version_number + 1,
1356: last_update_date = sysdate,
1357: last_updated_by = fnd_global.user_id,
1358: last_update_login = fnd_global.login_id
1359: WHERE unit_deferral_id = l_object_id;
1360: COMMIT WORK;
1361:
1354: SET approval_status_code = 'DEFERRAL_REJECTED',
1355: object_version_number = object_version_number + 1,
1356: last_update_date = sysdate,
1357: last_updated_by = fnd_global.user_id,
1358: last_update_login = fnd_global.login_id
1359: WHERE unit_deferral_id = l_object_id;
1360: COMMIT WORK;
1361:
1362:
1498: UPDATE AHL_UNIT_DEFERRALS_B
1499: SET approval_status_code = 'DEFERRAL_REJECTED',
1500: object_version_number = object_version_number + 1,
1501: last_update_date = sysdate,
1502: last_updated_by = fnd_global.user_id,
1503: last_update_login = fnd_global.login_id
1504: WHERE unit_deferral_id = l_object_id;
1505: COMMIT WORK;
1506:
1499: SET approval_status_code = 'DEFERRAL_REJECTED',
1500: object_version_number = object_version_number + 1,
1501: last_update_date = sysdate,
1502: last_updated_by = fnd_global.user_id,
1503: last_update_login = fnd_global.login_id
1504: WHERE unit_deferral_id = l_object_id;
1505: COMMIT WORK;
1506:
1507: RAISE;
1519: UPDATE AHL_UNIT_DEFERRALS_B
1520: SET approval_status_code = 'DEFERRAL_REJECTED',
1521: object_version_number = object_version_number + 1,
1522: last_update_date = sysdate,
1523: last_updated_by = fnd_global.user_id,
1524: last_update_login = fnd_global.login_id
1525: WHERE unit_deferral_id = l_object_id;
1526: COMMIT WORK;
1527:
1520: SET approval_status_code = 'DEFERRAL_REJECTED',
1521: object_version_number = object_version_number + 1,
1522: last_update_date = sysdate,
1523: last_updated_by = fnd_global.user_id,
1524: last_update_login = fnd_global.login_id
1525: WHERE unit_deferral_id = l_object_id;
1526: COMMIT WORK;
1527:
1528: RAISE;