DBA Data[Home] [Help]

APPS.AHL_MATERIALS_GRP dependencies on FND_GLOBAL

Line 408: last_updated_by = fnd_global.user_id,

404: -- Now update AHL_SCHEDULE_MATERIALS table with requested_date as l_requested_date
405: UPDATE AHL_SCHEDULE_MATERIALS
406: SET requested_date = trunc(l_requested_date),
407: last_update_date = sysdate,
408: last_updated_by = fnd_global.user_id,
409: last_update_login = fnd_global.login_id
410: WHERE scheduled_material_id = l_scheduled_material_id;
411: i := i + 1;
412: END LOOP;

Line 409: last_update_login = fnd_global.login_id

405: UPDATE AHL_SCHEDULE_MATERIALS
406: SET requested_date = trunc(l_requested_date),
407: last_update_date = sysdate,
408: last_updated_by = fnd_global.user_id,
409: last_update_login = fnd_global.login_id
410: WHERE scheduled_material_id = l_scheduled_material_id;
411: i := i + 1;
412: END LOOP;
413: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 446: last_updated_by = fnd_global.user_id,

442: END IF;
443: UPDATE AHL_SCHEDULE_MATERIALS
444: SET inventory_item_id = p_alt_item_tbl(i).ALTERNATE_ITEM_ID,
445: last_update_date = sysdate,
446: last_updated_by = fnd_global.user_id,
447: last_update_login = fnd_global.login_id
448: WHERE scheduled_material_id = l_scheduled_material_id;
449: ELSE
450: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 447: last_update_login = fnd_global.login_id

443: UPDATE AHL_SCHEDULE_MATERIALS
444: SET inventory_item_id = p_alt_item_tbl(i).ALTERNATE_ITEM_ID,
445: last_update_date = sysdate,
446: last_updated_by = fnd_global.user_id,
447: last_update_login = fnd_global.login_id
448: WHERE scheduled_material_id = l_scheduled_material_id;
449: ELSE
450: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
451: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'No Matching Schedule Material record found');