DBA Data[Home] [Help]

APPS.WIP_TIME_ENTRY_PUB dependencies on DUAL

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

674: <>
675: if l_wip_time_intf_tbl(l_counter).process_status = wip_constants.running or
676: l_wip_time_intf_tbl(l_counter).process_status = wip_constants.warning then
677: select wip_resource_actual_times_s.nextval
678: into v_wip_res_actual_times(ins_counter).time_entry_id from dual;
679: v_wip_res_actual_times(ins_counter).organization_id := l_wip_time_intf_tbl(l_counter).organization_id;
680: v_wip_res_actual_times(ins_counter).wip_entity_id := l_wip_time_intf_tbl(l_counter).wip_entity_id;
681: v_wip_res_actual_times(ins_counter).operation_seq_num := l_wip_time_intf_tbl(l_counter).operation_seq_num;
682: v_wip_res_actual_times(ins_counter).resource_id := l_wip_time_intf_tbl(l_counter).resource_id;

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

683: v_wip_res_actual_times(ins_counter).resource_seq_num := l_wip_time_intf_tbl(l_counter).resource_seq_num;
684: v_wip_res_actual_times(ins_counter).instance_id := null;
685: v_wip_res_actual_times(ins_counter).serial_number := null;
686: select decode(l_wip_time_intf_tbl(l_counter).time_entry_type,1,6,2,7,3,5)
687: into v_wip_res_actual_times(ins_counter).time_entry_mode from dual;
688: v_wip_res_actual_times(ins_counter).cost_flag := 'N';
689: v_wip_res_actual_times(ins_counter).add_to_rtg := 'N';
690: v_wip_res_actual_times(ins_counter).status_type := 2;
691: v_wip_res_actual_times(ins_counter).start_date := l_wip_time_intf_tbl(l_counter).actual_start_date;