APPS.WIP_WS_TIME_ENTRY dependencies on FND_PROFILE

Line 61: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');

57: BEGIN
58: l_status_type := 1; --pending
59: l_process_status := 2; --inserted
60: l_object_version_num := 1; --new record
61: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
62: l_return_status := 'U';
63:
64: if p_time_entry_id is null then
65: select WIP_RESOURCE_ACTUAL_TIMES_S.nextval into l_time_entry_id from dual;

Line 308: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');

304: BEGIN
305: l_object_version_num := p_object_version_num;
306: l_start_date := p_start_date;
307: l_process_status := 3; --updated
308: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
309: l_return_status := 'U';
310:
311: l_time_uom_flag := is_time_uom(p_uom_code);
312:

Line 558: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');

554: is
555: l_uom_code varchar2(3);
556: l_date date;
557: Begin
558: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
559: l_date := sysdate;
560:
561: update wip_resource_actual_times t
562: set

Line 636: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');

632: l_date date;
633: l_uom_code varchar2(10);
634: Begin
635:
636: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
637:
638: /* scheduled yes/no resource */
639: l_scheduled_flag := 1;
640:

Line 1293: muc.uom_code = fnd_profile.value('BOM:HOUR_UOM_CODE') and

1289: mtl_uom_conversions muc2
1290: where (muc.uom_class = muc2.uom_class and
1291: nvl(muc.disable_date, sysdate + 1) > sysdate) and
1292: nvl(muc2.disable_date, sysdate + 1) > sysdate and
1293: muc.uom_code = fnd_profile.value('BOM:HOUR_UOM_CODE') and
1294: muc2.uom_code = p_uom_code;
1295: BEGIN
1296: open time_based_uom_cursor;
1297: fetch time_based_uom_cursor into l_uom_class;

Line 1855: fnd_profile.value('BOM:HOUR_UOM_CODE'),

1851: values
1852: (WIP_RESOURCE_ACTUAL_TIMES_S.nextval,p_org_id,
1853: null,null,null,null,null,null,8,'N','N',null,
1854: sysdate,null,null,null,
1855: fnd_profile.value('BOM:HOUR_UOM_CODE'),
1856: l_person_id,1,fnd_global.user_id,
1857: sysdate,fnd_global.user_id,sysdate,
1858: fnd_global.login_id,1,null,null,null,
1859: null,null);

Line 2030: fnd_profile.value('BOM:HOUR_UOM_CODE'),

2026: values
2027: (WIP_RESOURCE_ACTUAL_TIMES_S.nextval,p_org_id,
2028: null,null,null,null,null,null,8,'N','N',null,
2029: sysdate,null,null,null,
2030: fnd_profile.value('BOM:HOUR_UOM_CODE'),
2031: p_wip_employee_id,1,fnd_global.user_id,
2032: sysdate,fnd_global.user_id,sysdate,
2033: fnd_global.login_id,1,null,null,null,
2034: null,null);

Line 2409: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');

2405: and end_date is null;
2406: BEGIN
2407: l_clock_status := 'U';
2408: l_process_status := 3; --updated
2409: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
2410:
2411: open clock_out_test_cursor;
2412: fetch clock_out_test_cursor into l_object_version_num,
2413: l_start_date;