50: where organization_id = p_organization_id;
51:
52: wip_ws_util.trace_log('Launching Import Time Entry Records for Organization: '||l_org_code);
53:
54: g_user_id := fnd_global.user_id;
55: g_user_login_id := fnd_global.login_id;
56: g_program_appl_id := fnd_global.prog_appl_id;
57: g_request_id := fnd_global.conc_request_id;
58: g_program_id := fnd_global.conc_program_id;
51:
52: wip_ws_util.trace_log('Launching Import Time Entry Records for Organization: '||l_org_code);
53:
54: g_user_id := fnd_global.user_id;
55: g_user_login_id := fnd_global.login_id;
56: g_program_appl_id := fnd_global.prog_appl_id;
57: g_request_id := fnd_global.conc_request_id;
58: g_program_id := fnd_global.conc_program_id;
59: g_logLevel := FND_LOG.g_current_runtime_level;
52: wip_ws_util.trace_log('Launching Import Time Entry Records for Organization: '||l_org_code);
53:
54: g_user_id := fnd_global.user_id;
55: g_user_login_id := fnd_global.login_id;
56: g_program_appl_id := fnd_global.prog_appl_id;
57: g_request_id := fnd_global.conc_request_id;
58: g_program_id := fnd_global.conc_program_id;
59: g_logLevel := FND_LOG.g_current_runtime_level;
60:
53:
54: g_user_id := fnd_global.user_id;
55: g_user_login_id := fnd_global.login_id;
56: g_program_appl_id := fnd_global.prog_appl_id;
57: g_request_id := fnd_global.conc_request_id;
58: g_program_id := fnd_global.conc_program_id;
59: g_logLevel := FND_LOG.g_current_runtime_level;
60:
61: l_stmt_num := 20;
54: g_user_id := fnd_global.user_id;
55: g_user_login_id := fnd_global.login_id;
56: g_program_appl_id := fnd_global.prog_appl_id;
57: g_request_id := fnd_global.conc_request_id;
58: g_program_id := fnd_global.conc_program_id;
59: g_logLevel := FND_LOG.g_current_runtime_level;
60:
61: l_stmt_num := 20;
62:
220:
221: update wip_time_entry_interface
222: set process_status = wip_constants.running,
223: organization_id = nvl(organization_id,p_organization_id),
224: request_id = fnd_global.conc_request_id,
225: program_id = fnd_global.conc_program_id,
226: program_application_id = fnd_global.prog_appl_id,
227: program_update_date = sysdate,
228: last_updated_by = fnd_global.user_id,
221: update wip_time_entry_interface
222: set process_status = wip_constants.running,
223: organization_id = nvl(organization_id,p_organization_id),
224: request_id = fnd_global.conc_request_id,
225: program_id = fnd_global.conc_program_id,
226: program_application_id = fnd_global.prog_appl_id,
227: program_update_date = sysdate,
228: last_updated_by = fnd_global.user_id,
229: last_update_date = sysdate,
222: set process_status = wip_constants.running,
223: organization_id = nvl(organization_id,p_organization_id),
224: request_id = fnd_global.conc_request_id,
225: program_id = fnd_global.conc_program_id,
226: program_application_id = fnd_global.prog_appl_id,
227: program_update_date = sysdate,
228: last_updated_by = fnd_global.user_id,
229: last_update_date = sysdate,
230: last_update_login = fnd_global.login_id
224: request_id = fnd_global.conc_request_id,
225: program_id = fnd_global.conc_program_id,
226: program_application_id = fnd_global.prog_appl_id,
227: program_update_date = sysdate,
228: last_updated_by = fnd_global.user_id,
229: last_update_date = sysdate,
230: last_update_login = fnd_global.login_id
231: where
232: process_status = wip_constants.pending
226: program_application_id = fnd_global.prog_appl_id,
227: program_update_date = sysdate,
228: last_updated_by = fnd_global.user_id,
229: last_update_date = sysdate,
230: last_update_login = fnd_global.login_id
231: where
232: process_status = wip_constants.pending
233: and (organization_id = p_organization_id or
234: organization_code = (select mp.organization_code
762: v_wip_res_actual_times(ins_counter).duration := l_wip_time_intf_tbl(l_counter).duration;
763: v_wip_res_actual_times(ins_counter).uom_code := l_wip_time_intf_tbl(l_counter).uom_code;
764: v_wip_res_actual_times(ins_counter).employee_id := l_wip_time_intf_tbl(l_counter).employee_id;
765: v_wip_res_actual_times(ins_counter).process_status := 1;
766: v_wip_res_actual_times(ins_counter).created_by := fnd_global.user_id;
767: v_wip_res_actual_times(ins_counter).creation_date := sysdate;
768: v_wip_res_actual_times(ins_counter).last_updated_by := fnd_global.user_id;
769: v_wip_res_actual_times(ins_counter).last_update_date := sysdate;
770: v_wip_res_actual_times(ins_counter).last_update_login := fnd_global.login_id;
764: v_wip_res_actual_times(ins_counter).employee_id := l_wip_time_intf_tbl(l_counter).employee_id;
765: v_wip_res_actual_times(ins_counter).process_status := 1;
766: v_wip_res_actual_times(ins_counter).created_by := fnd_global.user_id;
767: v_wip_res_actual_times(ins_counter).creation_date := sysdate;
768: v_wip_res_actual_times(ins_counter).last_updated_by := fnd_global.user_id;
769: v_wip_res_actual_times(ins_counter).last_update_date := sysdate;
770: v_wip_res_actual_times(ins_counter).last_update_login := fnd_global.login_id;
771: v_wip_res_actual_times(ins_counter).object_version_number := 1;
772: v_wip_res_actual_times(ins_counter).action_flag := nvl(l_wip_time_intf_tbl(l_counter).action_flag,1);
766: v_wip_res_actual_times(ins_counter).created_by := fnd_global.user_id;
767: v_wip_res_actual_times(ins_counter).creation_date := sysdate;
768: v_wip_res_actual_times(ins_counter).last_updated_by := fnd_global.user_id;
769: v_wip_res_actual_times(ins_counter).last_update_date := sysdate;
770: v_wip_res_actual_times(ins_counter).last_update_login := fnd_global.login_id;
771: v_wip_res_actual_times(ins_counter).object_version_number := 1;
772: v_wip_res_actual_times(ins_counter).action_flag := nvl(l_wip_time_intf_tbl(l_counter).action_flag,1);
773: v_wip_res_actual_times(ins_counter).request_id := fnd_global.conc_request_id;
774: v_wip_res_actual_times(ins_counter).program_id := fnd_global.conc_program_id;
769: v_wip_res_actual_times(ins_counter).last_update_date := sysdate;
770: v_wip_res_actual_times(ins_counter).last_update_login := fnd_global.login_id;
771: v_wip_res_actual_times(ins_counter).object_version_number := 1;
772: v_wip_res_actual_times(ins_counter).action_flag := nvl(l_wip_time_intf_tbl(l_counter).action_flag,1);
773: v_wip_res_actual_times(ins_counter).request_id := fnd_global.conc_request_id;
774: v_wip_res_actual_times(ins_counter).program_id := fnd_global.conc_program_id;
775: v_wip_res_actual_times(ins_counter).program_application_id := fnd_global.prog_appl_id;
776: v_wip_res_actual_times(ins_counter).program_update_date := sysdate;
777: ins_counter := ins_counter+1;
770: v_wip_res_actual_times(ins_counter).last_update_login := fnd_global.login_id;
771: v_wip_res_actual_times(ins_counter).object_version_number := 1;
772: v_wip_res_actual_times(ins_counter).action_flag := nvl(l_wip_time_intf_tbl(l_counter).action_flag,1);
773: v_wip_res_actual_times(ins_counter).request_id := fnd_global.conc_request_id;
774: v_wip_res_actual_times(ins_counter).program_id := fnd_global.conc_program_id;
775: v_wip_res_actual_times(ins_counter).program_application_id := fnd_global.prog_appl_id;
776: v_wip_res_actual_times(ins_counter).program_update_date := sysdate;
777: ins_counter := ins_counter+1;
778: end if;
771: v_wip_res_actual_times(ins_counter).object_version_number := 1;
772: v_wip_res_actual_times(ins_counter).action_flag := nvl(l_wip_time_intf_tbl(l_counter).action_flag,1);
773: v_wip_res_actual_times(ins_counter).request_id := fnd_global.conc_request_id;
774: v_wip_res_actual_times(ins_counter).program_id := fnd_global.conc_program_id;
775: v_wip_res_actual_times(ins_counter).program_application_id := fnd_global.prog_appl_id;
776: v_wip_res_actual_times(ins_counter).program_update_date := sysdate;
777: ins_counter := ins_counter+1;
778: end if;
779: v_process_status(pop_counter) := l_wip_time_intf_tbl(l_counter).process_status;