DBA Data[Home] [Help]

APPS.GMO_VBATCH_TASK_PVT dependencies on FND_GLOBAL

Line 29: l_hour_um := fnd_profile.value_specific(name => 'BOM:HOUR_UOM_CODE',user_id => FND_GLOBAL.USER_ID);

25: l_hour_um varchar2(100);
26: missing_profile_option exception;
27: uom_conversion_err exception;
28: BEGIN
29: l_hour_um := fnd_profile.value_specific(name => 'BOM:HOUR_UOM_CODE',user_id => FND_GLOBAL.USER_ID);
30: IF (l_hour_um IS NULL) THEN
31: RAISE missing_profile_option;
32: END IF;
33: IF l_hour_um <> p_trans_um THEN

Line 102: l_hour_um := fnd_profile.value_specific(name => 'BOM:HOUR_UOM_CODE',user_id => FND_GLOBAL.USER_ID);

98: missing_profile_option exception;
99: uom_conversion_err exception;
100: BEGIN
101: l_usage_time := (p_end_date - p_start_date) * 24;
102: l_hour_um := fnd_profile.value_specific(name => 'BOM:HOUR_UOM_CODE',user_id => FND_GLOBAL.USER_ID);
103: IF (l_hour_um IS NULL) THEN
104: RAISE missing_profile_option;
105: END IF;
106: IF l_hour_um <> p_trans_um THEN

Line 1407: l_lot_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1403: if (p_lot_rec(4) is not null) then
1404: l_lot_rec.EXPIRATION_DATE := fnd_date.displaydt_to_date(p_lot_rec(4), FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE);
1405: end if;
1406: l_lot_rec.LAST_UPDATE_DATE := sysdate;
1407: l_lot_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1408: l_lot_rec.CREATION_DATE := sysdate;
1409: l_lot_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1410: l_lot_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1411: /*

Line 1409: l_lot_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1405: end if;
1406: l_lot_rec.LAST_UPDATE_DATE := sysdate;
1407: l_lot_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1408: l_lot_rec.CREATION_DATE := sysdate;
1409: l_lot_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1410: l_lot_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1411: /*
1412: inv_lot_api_pub.create_inv_lot
1413: (

Line 1410: l_lot_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1406: l_lot_rec.LAST_UPDATE_DATE := sysdate;
1407: l_lot_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1408: l_lot_rec.CREATION_DATE := sysdate;
1409: l_lot_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1410: l_lot_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1411: /*
1412: inv_lot_api_pub.create_inv_lot
1413: (
1414: p_lot_rec => l_lot_rec