1826: UPDATE ahl_mel_cdl_headers
1827: SET status_code = l_next_status,
1828: object_version_number = l_object_ovn + 1,
1829: last_update_date = sysdate,
1830: last_updated_by = fnd_global.user_id,
1831: last_update_login = fnd_global.login_id
1832: WHERE mel_cdl_header_id = l_object_id;
1833:
1834: IF (l_mel_cdl_rec.version_number > 1)
1827: SET status_code = l_next_status,
1828: object_version_number = l_object_ovn + 1,
1829: last_update_date = sysdate,
1830: last_updated_by = fnd_global.user_id,
1831: last_update_login = fnd_global.login_id
1832: WHERE mel_cdl_header_id = l_object_id;
1833:
1834: IF (l_mel_cdl_rec.version_number > 1)
1835: THEN
1849: UPDATE ahl_mel_cdl_headers
1850: SET expired_date = l_prev_expired_date,
1851: object_version_number = object_version_number + 1,
1852: last_update_date = sysdate,
1853: last_updated_by = fnd_global.user_id,
1854: last_update_login = fnd_global.login_id
1855: WHERE mel_cdl_header_id = l_prev_mel_cdl_header_id;
1856: END IF;
1857:
1850: SET expired_date = l_prev_expired_date,
1851: object_version_number = object_version_number + 1,
1852: last_update_date = sysdate,
1853: last_updated_by = fnd_global.user_id,
1854: last_update_login = fnd_global.login_id
1855: WHERE mel_cdl_header_id = l_prev_mel_cdl_header_id;
1856: END IF;
1857:
1858: resultout := 'COMPLETE:SUCCESS';
2031: UPDATE ahl_mel_cdl_headers
2032: SET status_code = l_next_status,
2033: object_version_number = l_object_ovn + 1,
2034: last_update_date = sysdate,
2035: last_updated_by = fnd_global.user_id,
2036: last_update_login = fnd_global.login_id
2037: WHERE mel_cdl_header_id = l_object_id;
2038:
2039: resultout := 'COMPLETE:SUCCESS';
2032: SET status_code = l_next_status,
2033: object_version_number = l_object_ovn + 1,
2034: last_update_date = sysdate,
2035: last_updated_by = fnd_global.user_id,
2036: last_update_login = fnd_global.login_id
2037: WHERE mel_cdl_header_id = l_object_id;
2038:
2039: resultout := 'COMPLETE:SUCCESS';
2040: RETURN;
4064: UPDATE AHL_UNIT_DEFERRALS_B
4065: SET approval_status_code = 'DEFERRAL_REJECTED',
4066: object_version_number = object_version_number + 1,
4067: last_update_date = sysdate,
4068: last_updated_by = fnd_global.user_id,
4069: last_update_login = fnd_global.login_id
4070: WHERE unit_deferral_id = l_object_id;
4071:
4072: COMMIT WORK;
4065: SET approval_status_code = 'DEFERRAL_REJECTED',
4066: object_version_number = object_version_number + 1,
4067: last_update_date = sysdate,
4068: last_updated_by = fnd_global.user_id,
4069: last_update_login = fnd_global.login_id
4070: WHERE unit_deferral_id = l_object_id;
4071:
4072: COMMIT WORK;
4073: