DBA Data[Home] [Help]

APPS.WIP_TIME_ENTRY_PUB dependencies on DUAL

Line 746: into v_wip_res_actual_times(ins_counter).time_entry_id from dual;

742: <>
743: if l_wip_time_intf_tbl(l_counter).process_status = wip_constants.running or
744: l_wip_time_intf_tbl(l_counter).process_status = wip_constants.warning then
745: select wip_resource_actual_times_s.nextval
746: into v_wip_res_actual_times(ins_counter).time_entry_id from dual;
747: v_wip_res_actual_times(ins_counter).organization_id := l_wip_time_intf_tbl(l_counter).organization_id;
748: v_wip_res_actual_times(ins_counter).wip_entity_id := l_wip_time_intf_tbl(l_counter).wip_entity_id;
749: v_wip_res_actual_times(ins_counter).operation_seq_num := l_wip_time_intf_tbl(l_counter).operation_seq_num;
750: v_wip_res_actual_times(ins_counter).resource_id := l_wip_time_intf_tbl(l_counter).resource_id;

Line 755: into v_wip_res_actual_times(ins_counter).time_entry_mode from dual;

751: v_wip_res_actual_times(ins_counter).resource_seq_num := l_wip_time_intf_tbl(l_counter).resource_seq_num;
752: v_wip_res_actual_times(ins_counter).instance_id := l_instance_id;
753: v_wip_res_actual_times(ins_counter).serial_number := null;
754: select decode(l_wip_time_intf_tbl(l_counter).time_entry_type,1,6,2,7,3,5)
755: into v_wip_res_actual_times(ins_counter).time_entry_mode from dual;
756: v_wip_res_actual_times(ins_counter).cost_flag := 'N';
757: v_wip_res_actual_times(ins_counter).add_to_rtg := 'N';
758: v_wip_res_actual_times(ins_counter).status_type := 2;
759: v_wip_res_actual_times(ins_counter).start_date := l_wip_time_intf_tbl(l_counter).actual_start_date;