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 1258: l_lot_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1254: if (p_lot_rec(4) is not null) then
1255: l_lot_rec.EXPIRATION_DATE := fnd_date.displaydt_to_date(p_lot_rec(4), FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE);
1256: end if;
1257: l_lot_rec.LAST_UPDATE_DATE := sysdate;
1258: l_lot_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1259: l_lot_rec.CREATION_DATE := sysdate;
1260: l_lot_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1261: l_lot_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1262: /*

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

1256: end if;
1257: l_lot_rec.LAST_UPDATE_DATE := sysdate;
1258: l_lot_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1259: l_lot_rec.CREATION_DATE := sysdate;
1260: l_lot_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1261: l_lot_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1262: /*
1263: inv_lot_api_pub.create_inv_lot
1264: (

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

1257: l_lot_rec.LAST_UPDATE_DATE := sysdate;
1258: l_lot_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1259: l_lot_rec.CREATION_DATE := sysdate;
1260: l_lot_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1261: l_lot_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1262: /*
1263: inv_lot_api_pub.create_inv_lot
1264: (
1265: p_lot_rec => l_lot_rec