eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_WS_LABOR_METRIC_PUB dependencies on FND_PROFILE

Line 31: and muc1.uom_code = fnd_profile.value('BOM:HOUR_UOM_CODE')

27: mtl_uom_conversions muc2
28: where (muc1.uom_class = muc2.uom_class
29: and nvl(muc1.disable_date, sysdate + 1) > sysdate)
30: and nvl(muc2.disable_date, sysdate + 1) > sysdate
31: and muc1.uom_code = fnd_profile.value('BOM:HOUR_UOM_CODE')
32: and muc2.uom_code = p_uom_code;
33: begin
34: open time_based_uom_cursor;
35: fetch time_based_uom_cursor into l_uom_class;

Line 123: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND

119: is
120: l_eff_date Date;
121: l_converted_date date;
122: l_calendar_code varchar2(50);
123: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
124: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
125: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
126: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
127: fnd_profile.value('SERVER_TIMEZONE_ID'));

Line 124: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND

120: l_eff_date Date;
121: l_converted_date date;
122: l_calendar_code varchar2(50);
123: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
124: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
125: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
126: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
127: fnd_profile.value('SERVER_TIMEZONE_ID'));
128: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');

Line 125: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND

121: l_converted_date date;
122: l_calendar_code varchar2(50);
123: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
124: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
125: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
126: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
127: fnd_profile.value('SERVER_TIMEZONE_ID'));
128: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');
129: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');

Line 126: fnd_profile.value('CLIENT_TIMEZONE_ID') <>

122: l_calendar_code varchar2(50);
123: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
124: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
125: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
126: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
127: fnd_profile.value('SERVER_TIMEZONE_ID'));
128: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');
129: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');
130: begin

Line 127: fnd_profile.value('SERVER_TIMEZONE_ID'));

123: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
124: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
125: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
126: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
127: fnd_profile.value('SERVER_TIMEZONE_ID'));
128: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');
129: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');
130: begin
131: l_calendar_code := get_calendar_code(p_org_id);

Line 128: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');

124: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
125: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
126: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
127: fnd_profile.value('SERVER_TIMEZONE_ID'));
128: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');
129: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');
130: begin
131: l_calendar_code := get_calendar_code(p_org_id);
132: begin

Line 129: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');

125: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
126: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
127: fnd_profile.value('SERVER_TIMEZONE_ID'));
128: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');
129: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');
130: begin
131: l_calendar_code := get_calendar_code(p_org_id);
132: begin
133: --Fix for bug 11847040, must consider the time component too so that the date will be properly converted

Line 668: l_bom_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');

664: from dual;
665:
666: l_stmt_num :=30;
667:
668: l_bom_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
669: l_calendar_code := get_calendar_code(p_organization_id);
670: window_end_time := get_period_end(l_calendar_code,l_current_date);
671: window_start_time := get_period_start(p_organization_id,window_end_time);
672:

Line 1493: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND

1489: function get_client_date(p_date in Date)
1490: return date
1491: is
1492: l_converted_date date;
1493: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1494: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1495: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1496: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1497: fnd_profile.value('SERVER_TIMEZONE_ID'));

Line 1494: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND

1490: return date
1491: is
1492: l_converted_date date;
1493: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1494: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1495: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1496: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1497: fnd_profile.value('SERVER_TIMEZONE_ID'));
1498: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');

Line 1495: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND

1491: is
1492: l_converted_date date;
1493: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1494: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1495: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1496: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1497: fnd_profile.value('SERVER_TIMEZONE_ID'));
1498: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');
1499: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');

Line 1496: fnd_profile.value('CLIENT_TIMEZONE_ID') <>

1492: l_converted_date date;
1493: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1494: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1495: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1496: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1497: fnd_profile.value('SERVER_TIMEZONE_ID'));
1498: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');
1499: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');
1500: begin

Line 1497: fnd_profile.value('SERVER_TIMEZONE_ID'));

1493: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1494: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1495: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1496: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1497: fnd_profile.value('SERVER_TIMEZONE_ID'));
1498: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');
1499: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');
1500: begin
1501:

Line 1498: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');

1494: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1495: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1496: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1497: fnd_profile.value('SERVER_TIMEZONE_ID'));
1498: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');
1499: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');
1500: begin
1501:
1502: if l_timezone_enabled and p_date is not null then

Line 1499: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');

1495: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1496: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1497: fnd_profile.value('SERVER_TIMEZONE_ID'));
1498: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');
1499: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');
1500: begin
1501:
1502: if l_timezone_enabled and p_date is not null then
1503: l_converted_date := hz_timezone_pub.convert_datetime(l_server_id,