APPS.WIP_WS_TIME_ENTRY dependencies on FND_PROFILE

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

117: end if;
118: l_status_type := 1; --pending
119: l_process_status := 2; --inserted
120: l_object_version_num := 1; --new record
121: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
122: l_return_status := 'U';
123:
124: if p_time_entry_id is null then
125: select WIP_RESOURCE_ACTUAL_TIMES_S.nextval into l_time_entry_id from dual;

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

381: end if;
382: l_object_version_num := p_object_version_num;
383: l_start_date := p_start_date;
384: l_process_status := 3; --updated
385: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
386: l_return_status := 'U';
387:
388: l_time_uom_flag := is_time_uom(p_uom_code);
389:

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

763: if(x_return_status <> fnd_api.g_ret_sts_success) then
764: raise fnd_api.g_exc_unexpected_error;
765: end if;
766: end if;
767: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
768: l_date := sysdate;
769:
770: update wip_resource_actual_times t
771: set

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

863: if(x_return_status <> fnd_api.g_ret_sts_success) then
864: raise fnd_api.g_exc_unexpected_error;
865: end if;
866: end if;
867: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
868:
869: /* scheduled yes/no resource */
870: l_scheduled_flag := 1;
871:

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

1582: mtl_uom_conversions muc2
1583: where (muc.uom_class = muc2.uom_class and
1584: nvl(muc.disable_date, sysdate + 1) > sysdate) and
1585: nvl(muc2.disable_date, sysdate + 1) > sysdate and
1586: muc.uom_code = fnd_profile.value('BOM:HOUR_UOM_CODE') and
1587: muc2.uom_code = p_uom_code;
1588: BEGIN
1589: open time_based_uom_cursor;
1590: fetch time_based_uom_cursor into l_uom_class;

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

2345: values
2346: (WIP_RESOURCE_ACTUAL_TIMES_S.nextval,p_org_id,
2347: null,null,null,null,null,null,8,'N','N',null,
2348: sysdate,null,null,null,
2349: fnd_profile.value('BOM:HOUR_UOM_CODE'),
2350: l_person_id,1,fnd_global.user_id,
2351: sysdate,fnd_global.user_id,sysdate,
2352: fnd_global.login_id,1,null,null,null,
2353: null,null);

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

2578: values
2579: (WIP_RESOURCE_ACTUAL_TIMES_S.nextval,p_org_id,
2580: null,null,null,null,null,null,8,'N','N',null,
2581: sysdate,null,null,null,
2582: fnd_profile.value('BOM:HOUR_UOM_CODE'),
2583: p_wip_employee_id,1,fnd_global.user_id,
2584: sysdate,fnd_global.user_id,sysdate,
2585: fnd_global.login_id,1,null,null,null,
2586: null,null);

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

3089: end if;
3090: end if;
3091: l_clock_status := 'U';
3092: l_process_status := 3; --updated
3093: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
3094:
3095: open clock_out_test_cursor;
3096: fetch clock_out_test_cursor into l_object_version_num,
3097: l_start_date;