DBA Data[Home] [Help]

APPS.ENG_ECO_REVISION_UTIL dependencies on FND_GLOBAL

Line 358: last_updated_by = FND_GLOBAL.USER_ID,

354: SET approval_status_type = 1,
355: approval_request_date = null,
356: approval_date = null,
357: last_update_date = SYSDATE,
358: last_updated_by = FND_GLOBAL.USER_ID,
359: last_update_login = FND_GLOBAL.LOGIN_ID
360: WHERE change_id = p_Eco_Rev_Unexp_Rec.change_id;
361:
362: -- Set all "Scheduled" revised items to "Open"

Line 359: last_update_login = FND_GLOBAL.LOGIN_ID

355: approval_request_date = null,
356: approval_date = null,
357: last_update_date = SYSDATE,
358: last_updated_by = FND_GLOBAL.USER_ID,
359: last_update_login = FND_GLOBAL.LOGIN_ID
360: WHERE change_id = p_Eco_Rev_Unexp_Rec.change_id;
361:
362: -- Set all "Scheduled" revised items to "Open"
363:

Line 367: last_updated_by = FND_GLOBAL.USER_ID,

363:
364: UPDATE eng_revised_items
365: SET status_type = 1,
366: last_update_date = SYSDATE,
367: last_updated_by = FND_GLOBAL.USER_ID,
368: last_update_login = FND_GLOBAL.LOGIN_ID
369: WHERE change_id = p_Eco_Rev_Unexp_Rec.change_id
370: AND status_type = 4;
371:

Line 368: last_update_login = FND_GLOBAL.LOGIN_ID

364: UPDATE eng_revised_items
365: SET status_type = 1,
366: last_update_date = SYSDATE,
367: last_updated_by = FND_GLOBAL.USER_ID,
368: last_update_login = FND_GLOBAL.LOGIN_ID
369: WHERE change_id = p_Eco_Rev_Unexp_Rec.change_id
370: AND status_type = 4;
371:
372: end if;