APPS.AHL_MEL_CDL_APPROVALS_PVT dependencies on AHL_UNIT_DEFERRALS_TL

Line 3890: UPDATE AHL_UNIT_DEFERRALS_TL

3886: itemkey => itemkey,
3887: aname => 'APPROVER NOTE'
3888: );
3889:
3890: UPDATE AHL_UNIT_DEFERRALS_TL
3891: SET approver_notes = l_approver_note,
3892: SOURCE_LANG = userenv('LANG')
3893: WHERE unit_deferral_id = l_object_id
3894: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line 4059: UPDATE AHL_UNIT_DEFERRALS_TL

4055: );
4056: END IF;
4057:
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,

Line 4095: UPDATE AHL_UNIT_DEFERRALS_TL

4091:
4092: l_error_msg := SQLCODE || ': ' || SQLERRM;
4093:
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,

Line 4320: UPDATE AHL_UNIT_DEFERRALS_TL

4316: );
4317: resultout := 'COMPLETE:ERROR';
4318:
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,

Line 4355: UPDATE AHL_UNIT_DEFERRALS_TL

4351: );
4352:
4353: l_error_msg := SQLCODE || ': ' || SQLERRM;
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,