DBA Data[Home] [Help]

APPS.AHL_MEL_CDL_APPROVALS_PVT dependencies on FND_GLOBAL

Line 1830: last_updated_by = fnd_global.user_id,

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)

Line 1831: last_update_login = fnd_global.login_id

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

Line 1853: last_updated_by = fnd_global.user_id,

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:

Line 1854: last_update_login = fnd_global.login_id

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';

Line 2035: last_updated_by = fnd_global.user_id,

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';

Line 2036: last_update_login = fnd_global.login_id

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;

Line 4068: last_updated_by = fnd_global.user_id,

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;

Line 4069: last_update_login = fnd_global.login_id

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: