eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 4062: last_updated_by = fnd_global.user_id,

4058: -- update validation errors.
4059: UPDATE AHL_UNIT_DEFERRALS_TL
4060: SET approver_notes = substrb(l_error_msg,1,4000),
4061: last_update_date = sysdate,
4062: last_updated_by = fnd_global.user_id,
4063: last_update_login = fnd_global.login_id,
4064: source_lang = userenv('LANG')
4065: WHERE unit_deferral_id = l_object_id
4066: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line 4063: last_update_login = fnd_global.login_id,

4059: UPDATE AHL_UNIT_DEFERRALS_TL
4060: SET approver_notes = substrb(l_error_msg,1,4000),
4061: last_update_date = sysdate,
4062: last_updated_by = fnd_global.user_id,
4063: last_update_login = fnd_global.login_id,
4064: source_lang = userenv('LANG')
4065: WHERE unit_deferral_id = l_object_id
4066: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
4067:

Line 4072: last_updated_by = fnd_global.user_id,

4068: UPDATE AHL_UNIT_DEFERRALS_B
4069: SET approval_status_code = 'DEFERRAL_REJECTED',
4070: object_version_number = object_version_number + 1,
4071: last_update_date = sysdate,
4072: last_updated_by = fnd_global.user_id,
4073: last_update_login = fnd_global.login_id
4074: WHERE unit_deferral_id = l_object_id;
4075: COMMIT WORK;
4076:

Line 4073: last_update_login = fnd_global.login_id

4069: SET approval_status_code = 'DEFERRAL_REJECTED',
4070: object_version_number = object_version_number + 1,
4071: last_update_date = sysdate,
4072: last_updated_by = fnd_global.user_id,
4073: last_update_login = fnd_global.login_id
4074: WHERE unit_deferral_id = l_object_id;
4075: COMMIT WORK;
4076:
4077: /*

Line 4098: last_updated_by = fnd_global.user_id,

4094: -- update validation errors.
4095: UPDATE AHL_UNIT_DEFERRALS_TL
4096: SET approver_notes = substrb(l_error_msg,1,4000),
4097: last_update_date = sysdate,
4098: last_updated_by = fnd_global.user_id,
4099: last_update_login = fnd_global.login_id,
4100: source_lang = userenv('LANG')
4101: WHERE unit_deferral_id = l_object_id
4102: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line 4099: last_update_login = fnd_global.login_id,

4095: UPDATE AHL_UNIT_DEFERRALS_TL
4096: SET approver_notes = substrb(l_error_msg,1,4000),
4097: last_update_date = sysdate,
4098: last_updated_by = fnd_global.user_id,
4099: last_update_login = fnd_global.login_id,
4100: source_lang = userenv('LANG')
4101: WHERE unit_deferral_id = l_object_id
4102: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
4103:

Line 4108: last_updated_by = fnd_global.user_id,

4104: UPDATE AHL_UNIT_DEFERRALS_B
4105: SET approval_status_code = 'DEFERRAL_REJECTED',
4106: object_version_number = object_version_number + 1,
4107: last_update_date = sysdate,
4108: last_updated_by = fnd_global.user_id,
4109: last_update_login = fnd_global.login_id
4110: WHERE unit_deferral_id = l_object_id;
4111:
4112: COMMIT WORK;

Line 4109: last_update_login = fnd_global.login_id

4105: SET approval_status_code = 'DEFERRAL_REJECTED',
4106: object_version_number = object_version_number + 1,
4107: last_update_date = sysdate,
4108: last_updated_by = fnd_global.user_id,
4109: last_update_login = fnd_global.login_id
4110: WHERE unit_deferral_id = l_object_id;
4111:
4112: COMMIT WORK;
4113:

Line 4323: LAST_UPDATED_BY = fnd_global.user_id,

4319: -- update validation errors.
4320: UPDATE AHL_UNIT_DEFERRALS_TL
4321: SET approver_notes = substrb(l_error_msg,1,4000),
4322: LAST_UPDATE_DATE = sysdate,
4323: LAST_UPDATED_BY = fnd_global.user_id,
4324: LAST_UPDATE_LOGIN = fnd_global.login_id,
4325: SOURCE_LANG = userenv('LANG')
4326: WHERE unit_deferral_id = l_object_id
4327: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line 4324: LAST_UPDATE_LOGIN = fnd_global.login_id,

4320: UPDATE AHL_UNIT_DEFERRALS_TL
4321: SET approver_notes = substrb(l_error_msg,1,4000),
4322: LAST_UPDATE_DATE = sysdate,
4323: LAST_UPDATED_BY = fnd_global.user_id,
4324: LAST_UPDATE_LOGIN = fnd_global.login_id,
4325: SOURCE_LANG = userenv('LANG')
4326: WHERE unit_deferral_id = l_object_id
4327: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
4328:

Line 4333: last_updated_by = fnd_global.user_id,

4329: UPDATE AHL_UNIT_DEFERRALS_B
4330: SET approval_status_code = 'DEFERRAL_REJECTED',
4331: object_version_number = object_version_number + 1,
4332: last_update_date = sysdate,
4333: last_updated_by = fnd_global.user_id,
4334: last_update_login = fnd_global.login_id
4335: WHERE unit_deferral_id = l_object_id;
4336:
4337: COMMIT WORK;

Line 4334: last_update_login = fnd_global.login_id

4330: SET approval_status_code = 'DEFERRAL_REJECTED',
4331: object_version_number = object_version_number + 1,
4332: last_update_date = sysdate,
4333: last_updated_by = fnd_global.user_id,
4334: last_update_login = fnd_global.login_id
4335: WHERE unit_deferral_id = l_object_id;
4336:
4337: COMMIT WORK;
4338:

Line 4358: LAST_UPDATED_BY = fnd_global.user_id,

4354: -- update validation errors.
4355: UPDATE AHL_UNIT_DEFERRALS_TL
4356: SET approver_notes = substrb(l_error_msg,1,4000),
4357: LAST_UPDATE_DATE = sysdate,
4358: LAST_UPDATED_BY = fnd_global.user_id,
4359: LAST_UPDATE_LOGIN = fnd_global.login_id,
4360: SOURCE_LANG = userenv('LANG')
4361: WHERE unit_deferral_id = l_object_id
4362: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line 4359: LAST_UPDATE_LOGIN = fnd_global.login_id,

4355: UPDATE AHL_UNIT_DEFERRALS_TL
4356: SET approver_notes = substrb(l_error_msg,1,4000),
4357: LAST_UPDATE_DATE = sysdate,
4358: LAST_UPDATED_BY = fnd_global.user_id,
4359: LAST_UPDATE_LOGIN = fnd_global.login_id,
4360: SOURCE_LANG = userenv('LANG')
4361: WHERE unit_deferral_id = l_object_id
4362: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
4363:

Line 4368: last_updated_by = fnd_global.user_id,

4364: UPDATE AHL_UNIT_DEFERRALS_B
4365: SET approval_status_code = 'DEFERRAL_REJECTED',
4366: object_version_number = object_version_number + 1,
4367: last_update_date = sysdate,
4368: last_updated_by = fnd_global.user_id,
4369: last_update_login = fnd_global.login_id
4370: WHERE unit_deferral_id = l_object_id;
4371: COMMIT WORK;
4372:

Line 4369: last_update_login = fnd_global.login_id

4365: SET approval_status_code = 'DEFERRAL_REJECTED',
4366: object_version_number = object_version_number + 1,
4367: last_update_date = sysdate,
4368: last_updated_by = fnd_global.user_id,
4369: last_update_login = fnd_global.login_id
4370: WHERE unit_deferral_id = l_object_id;
4371: COMMIT WORK;
4372:
4373: RAISE;