[Home] [Help]
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;
126: else
127: l_time_entry_id := p_time_entry_id;
128: end if;
129:
824: and decode(wor.scheduled_flag, null, 1, 2, 1, wor.scheduled_flag) = p_scheduled_flag
825: and wrat.start_date is not null
826: and wrat.end_date is null
827: ), 0, 1, 0)
828: from dual;
829:
830: /* max end date for yes/no labor resources */
831: cursor max_labor_end_date(p_scheduled_flag number) is
832: select max(wrat.end_date)
1024: and wrat.resource_seq_num is not null;
1025:
1026: select greatest(nvl(l_wor_max,0), nvl(l_wrat_max,0)) + 10
1027: into l_resource_seq_num
1028: from dual;
1029:
1030: end if;
1031: close resource_seq_in_wrat;
1032:
1844: if( l_min_start_date_wrat is not null ) then
1845: select decode(l_min_start_date, null, l_min_start_date_wrat,
1846: least(l_min_start_date_wrat, l_min_start_date) )
1847: into l_min_start_date
1848: from dual;
1849: end if;
1850:
1851: if l_min_start_date is not null then
1852: update wip_operations set
3340:
3341: if not badge_validation then
3342: select count(1)
3343: into l_emp_clock_ins
3344: from dual
3345: where exists( select wip_entity_id
3346: from wip_resource_actual_times
3347: where organization_id = p_organization_id
3348: and employee_id = l_person_id