APPS.WIP_TIME_ENTRY_PUB dependencies on WIP_RESOURCE_ACTUAL_TIMES

Line 460: type t_wip_res_actual_times is table of wip_resource_actual_times%rowtype index by binary_integer;

456: l_counter number;
457: l_error_count number :=0;
458: l_stmt_num number;
459: ins_counter number;
460: type t_wip_res_actual_times is table of wip_resource_actual_times%rowtype index by binary_integer;
461: v_wip_res_actual_times t_wip_res_actual_times;
462:
463: type t_interface_id is table of wip_time_entry_interface.interface_id%type index by binary_integer;
464: type t_process_status is table of wip_time_entry_interface.process_status%type index by binary_integer;

Line 745: select wip_resource_actual_times_s.nextval

741: -- Bug 12614160.
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;

Line 790: -- insert into wip_resource_actual_times table

786: if (g_logLevel <= wip_constants.trace_logging) then
787: wip_ws_util.trace_log('Before Inserting records in Actual Times Table');
788: end if;
789:
790: -- insert into wip_resource_actual_times table
791: forall ins_index in v_wip_res_actual_times.first..v_wip_res_actual_times.last
792: INSERT into WIP_RESOURCE_ACTUAL_TIMES values v_wip_res_actual_times(ins_index);
793:
794: if (g_logLevel <= wip_constants.trace_logging) then

Line 792: INSERT into WIP_RESOURCE_ACTUAL_TIMES values v_wip_res_actual_times(ins_index);

788: end if;
789:
790: -- insert into wip_resource_actual_times table
791: forall ins_index in v_wip_res_actual_times.first..v_wip_res_actual_times.last
792: INSERT into WIP_RESOURCE_ACTUAL_TIMES values v_wip_res_actual_times(ins_index);
793:
794: if (g_logLevel <= wip_constants.trace_logging) then
795: wip_ws_util.trace_log('After Inserting records in Actual Times Table');
796: end if;

Line 975: from wip_resource_actual_times

971:
972: /* If this query returns count as 1 then employee has already shifted in. */
973: select count(1)
974: into l_count
975: from wip_resource_actual_times
976: where organization_id = l_org_id
977: and employee_id = p_employee_id
978: and wip_entity_id is null
979: and time_entry_mode = 8