APPS.WIP_TIME_ENTRY_PUB dependencies on WIP_RESOURCE_ACTUAL_TIMES

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

409: l_counter number;
410: l_error_count number :=0;
411: l_stmt_num number;
412: ins_counter number;
413: type t_wip_res_actual_times is table of wip_resource_actual_times%rowtype index by binary_integer;
414: v_wip_res_actual_times t_wip_res_actual_times;
415:
416: type t_interface_id is table of wip_time_entry_interface.interface_id%type index by binary_integer;
417: type t_process_status is table of wip_time_entry_interface.process_status%type index by binary_integer;

Line 677: select wip_resource_actual_times_s.nextval

673: l_stmt_num :=200;
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;

Line 722: -- insert into wip_resource_actual_times table

718: if (g_logLevel <= wip_constants.trace_logging) then
719: wip_ws_util.trace_log('Before Inserting records in Actual Times Table');
720: end if;
721:
722: -- insert into wip_resource_actual_times table
723: forall ins_index in v_wip_res_actual_times.first..v_wip_res_actual_times.last
724: INSERT into WIP_RESOURCE_ACTUAL_TIMES values v_wip_res_actual_times(ins_index);
725:
726: if (g_logLevel <= wip_constants.trace_logging) then

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

720: end if;
721:
722: -- insert into wip_resource_actual_times table
723: forall ins_index in v_wip_res_actual_times.first..v_wip_res_actual_times.last
724: INSERT into WIP_RESOURCE_ACTUAL_TIMES values v_wip_res_actual_times(ins_index);
725:
726: if (g_logLevel <= wip_constants.trace_logging) then
727: wip_ws_util.trace_log('After Inserting records in Actual Times Table');
728: end if;

Line 907: from wip_resource_actual_times

903:
904: /* If this query returns count as 1 then employee has already shifted in. */
905: select count(1)
906: into l_count
907: from wip_resource_actual_times
908: where organization_id = l_org_id
909: and employee_id = p_employee_id
910: and wip_entity_id is null
911: and time_entry_mode = 8