1404: UPDATE AHL_UNIT_DEFERRALS_B
1405: SET approval_status_code = 'DEFERRAL_REJECTED',
1406: object_version_number = object_version_number + 1,
1407: last_update_date = sysdate,
1408: last_updated_by = fnd_global.user_id,
1409: last_update_login = fnd_global.login_id
1410: WHERE unit_deferral_id = l_object_id;
1411: COMMIT WORK;
1412:
1405: SET approval_status_code = 'DEFERRAL_REJECTED',
1406: object_version_number = object_version_number + 1,
1407: last_update_date = sysdate,
1408: last_updated_by = fnd_global.user_id,
1409: last_update_login = fnd_global.login_id
1410: WHERE unit_deferral_id = l_object_id;
1411: COMMIT WORK;
1412:
1413: RAISE;
1425: UPDATE AHL_UNIT_DEFERRALS_B
1426: SET approval_status_code = 'DEFERRAL_REJECTED',
1427: object_version_number = object_version_number + 1,
1428: last_update_date = sysdate,
1429: last_updated_by = fnd_global.user_id,
1430: last_update_login = fnd_global.login_id
1431: WHERE unit_deferral_id = l_object_id;
1432: COMMIT WORK;
1433:
1426: SET approval_status_code = 'DEFERRAL_REJECTED',
1427: object_version_number = object_version_number + 1,
1428: last_update_date = sysdate,
1429: last_updated_by = fnd_global.user_id,
1430: last_update_login = fnd_global.login_id
1431: WHERE unit_deferral_id = l_object_id;
1432: COMMIT WORK;
1433:
1434:
1570: UPDATE AHL_UNIT_DEFERRALS_B
1571: SET approval_status_code = 'DEFERRAL_REJECTED',
1572: object_version_number = object_version_number + 1,
1573: last_update_date = sysdate,
1574: last_updated_by = fnd_global.user_id,
1575: last_update_login = fnd_global.login_id
1576: WHERE unit_deferral_id = l_object_id;
1577: COMMIT WORK;
1578:
1571: SET approval_status_code = 'DEFERRAL_REJECTED',
1572: object_version_number = object_version_number + 1,
1573: last_update_date = sysdate,
1574: last_updated_by = fnd_global.user_id,
1575: last_update_login = fnd_global.login_id
1576: WHERE unit_deferral_id = l_object_id;
1577: COMMIT WORK;
1578:
1579: RAISE;
1591: UPDATE AHL_UNIT_DEFERRALS_B
1592: SET approval_status_code = 'DEFERRAL_REJECTED',
1593: object_version_number = object_version_number + 1,
1594: last_update_date = sysdate,
1595: last_updated_by = fnd_global.user_id,
1596: last_update_login = fnd_global.login_id
1597: WHERE unit_deferral_id = l_object_id;
1598: COMMIT WORK;
1599:
1592: SET approval_status_code = 'DEFERRAL_REJECTED',
1593: object_version_number = object_version_number + 1,
1594: last_update_date = sysdate,
1595: last_updated_by = fnd_global.user_id,
1596: last_update_login = fnd_global.login_id
1597: WHERE unit_deferral_id = l_object_id;
1598: COMMIT WORK;
1599:
1600: RAISE;