[Home] [Help]
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;
66: else
67: l_time_entry_id := p_time_entry_id;
68: end if;
69:
607: and decode(wor.scheduled_flag, null, 1, 2, 1, wor.scheduled_flag) = p_scheduled_flag
608: and wrat.start_date is not null
609: and wrat.end_date is null
610: ), 0, 1, 0)
611: from dual;
612:
613: /* max end date for yes/no labor resources */
614: cursor max_labor_end_date(p_scheduled_flag number) is
615: select max(wrat.end_date)
787: and wrat.resource_seq_num is not null;
788:
789: select greatest(nvl(l_wor_max,0), nvl(l_wrat_max,0)) + 10
790: into l_resource_seq_num
791: from dual;
792:
793: end if;
794: close resource_seq_in_wrat;
795:
1506: if( l_min_start_date_wrat is not null ) then
1507: select decode(l_min_start_date, null, l_min_start_date_wrat,
1508: least(l_min_start_date_wrat, l_min_start_date) )
1509: into l_min_start_date
1510: from dual;
1511: end if;
1512:
1513: if l_min_start_date is not null then
1514: update wip_operations set
2596:
2597: if not badge_validation then
2598: select count(1)
2599: into l_emp_clock_ins
2600: from dual
2601: where exists( select wip_entity_id
2602: from wip_resource_actual_times
2603: where organization_id = p_organization_id
2604: and employee_id = l_person_id