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: select shift_date

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

638: from dual;
639:
640: l_stmt_num :=30;
641:
642: l_bom_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
643: l_calendar_code := get_calendar_code(p_organization_id);
644: window_end_time := get_period_end(l_calendar_code,l_current_date);
645: window_start_time := get_period_start(p_organization_id,window_end_time);
646:

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

1391: function get_client_date(p_date in Date)
1392: return date
1393: is
1394: l_converted_date date;
1395: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1396: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1397: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1398: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1399: fnd_profile.value('SERVER_TIMEZONE_ID'));

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

1392: return date
1393: is
1394: l_converted_date date;
1395: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1396: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1397: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1398: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1399: fnd_profile.value('SERVER_TIMEZONE_ID'));
1400: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');

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

1393: is
1394: l_converted_date date;
1395: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1396: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1397: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1398: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1399: fnd_profile.value('SERVER_TIMEZONE_ID'));
1400: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');
1401: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');

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

1394: l_converted_date date;
1395: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1396: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1397: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1398: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1399: fnd_profile.value('SERVER_TIMEZONE_ID'));
1400: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');
1401: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');
1402: begin

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

1395: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
1396: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1397: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1398: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1399: fnd_profile.value('SERVER_TIMEZONE_ID'));
1400: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');
1401: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');
1402: begin
1403:

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

1396: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
1397: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1398: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1399: fnd_profile.value('SERVER_TIMEZONE_ID'));
1400: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');
1401: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');
1402: begin
1403:
1404: if l_timezone_enabled and p_date is not null then

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

1397: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
1398: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
1399: fnd_profile.value('SERVER_TIMEZONE_ID'));
1400: l_client_id number := fnd_profile.value('CLIENT_TIMEZONE_ID');
1401: l_server_id number := fnd_profile.value('SERVER_TIMEZONE_ID');
1402: begin
1403:
1404: if l_timezone_enabled and p_date is not null then
1405: l_converted_date := hz_timezone_pub.convert_datetime(l_server_id,