DBA Data[Home] [Help]

APPS.GMO_VBATCH_TASK_PVT dependencies on FND_PROFILE

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