DBA Data[Home] [Help]

APPS.WIP_TIME_ENTRY_PUB dependencies on FND_GLOBAL

Line 54: g_user_id := fnd_global.user_id;

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;

Line 55: g_user_login_id := fnd_global.login_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;

Line 56: g_program_appl_id := fnd_global.prog_appl_id;

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:

Line 57: g_request_id := fnd_global.conc_request_id;

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;

Line 58: g_program_id := fnd_global.conc_program_id;

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:

Line 224: request_id = fnd_global.conc_request_id,

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,

Line 225: program_id = fnd_global.conc_program_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,

Line 226: program_application_id = fnd_global.prog_appl_id,

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

Line 228: last_updated_by = fnd_global.user_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

Line 230: last_update_login = fnd_global.login_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
233: and (organization_id = p_organization_id or
234: organization_code = (select mp.organization_code

Line 698: v_wip_res_actual_times(ins_counter).created_by := fnd_global.user_id;

694: v_wip_res_actual_times(ins_counter).duration := l_wip_time_intf_tbl(l_counter).duration;
695: v_wip_res_actual_times(ins_counter).uom_code := l_wip_time_intf_tbl(l_counter).uom_code;
696: v_wip_res_actual_times(ins_counter).employee_id := l_wip_time_intf_tbl(l_counter).employee_id;
697: v_wip_res_actual_times(ins_counter).process_status := 1;
698: v_wip_res_actual_times(ins_counter).created_by := fnd_global.user_id;
699: v_wip_res_actual_times(ins_counter).creation_date := sysdate;
700: v_wip_res_actual_times(ins_counter).last_updated_by := fnd_global.user_id;
701: v_wip_res_actual_times(ins_counter).last_update_date := sysdate;
702: v_wip_res_actual_times(ins_counter).last_update_login := fnd_global.login_id;

Line 700: v_wip_res_actual_times(ins_counter).last_updated_by := fnd_global.user_id;

696: v_wip_res_actual_times(ins_counter).employee_id := l_wip_time_intf_tbl(l_counter).employee_id;
697: v_wip_res_actual_times(ins_counter).process_status := 1;
698: v_wip_res_actual_times(ins_counter).created_by := fnd_global.user_id;
699: v_wip_res_actual_times(ins_counter).creation_date := sysdate;
700: v_wip_res_actual_times(ins_counter).last_updated_by := fnd_global.user_id;
701: v_wip_res_actual_times(ins_counter).last_update_date := sysdate;
702: v_wip_res_actual_times(ins_counter).last_update_login := fnd_global.login_id;
703: v_wip_res_actual_times(ins_counter).object_version_number := 1;
704: v_wip_res_actual_times(ins_counter).action_flag := l_wip_time_intf_tbl(l_counter).action_flag;

Line 702: v_wip_res_actual_times(ins_counter).last_update_login := fnd_global.login_id;

698: v_wip_res_actual_times(ins_counter).created_by := fnd_global.user_id;
699: v_wip_res_actual_times(ins_counter).creation_date := sysdate;
700: v_wip_res_actual_times(ins_counter).last_updated_by := fnd_global.user_id;
701: v_wip_res_actual_times(ins_counter).last_update_date := sysdate;
702: v_wip_res_actual_times(ins_counter).last_update_login := fnd_global.login_id;
703: v_wip_res_actual_times(ins_counter).object_version_number := 1;
704: v_wip_res_actual_times(ins_counter).action_flag := l_wip_time_intf_tbl(l_counter).action_flag;
705: v_wip_res_actual_times(ins_counter).request_id := fnd_global.conc_request_id;
706: v_wip_res_actual_times(ins_counter).program_id := fnd_global.conc_program_id;

Line 705: v_wip_res_actual_times(ins_counter).request_id := fnd_global.conc_request_id;

701: v_wip_res_actual_times(ins_counter).last_update_date := sysdate;
702: v_wip_res_actual_times(ins_counter).last_update_login := fnd_global.login_id;
703: v_wip_res_actual_times(ins_counter).object_version_number := 1;
704: v_wip_res_actual_times(ins_counter).action_flag := l_wip_time_intf_tbl(l_counter).action_flag;
705: v_wip_res_actual_times(ins_counter).request_id := fnd_global.conc_request_id;
706: v_wip_res_actual_times(ins_counter).program_id := fnd_global.conc_program_id;
707: v_wip_res_actual_times(ins_counter).program_application_id := fnd_global.prog_appl_id;
708: v_wip_res_actual_times(ins_counter).program_update_date := sysdate;
709: ins_counter := ins_counter+1;

Line 706: v_wip_res_actual_times(ins_counter).program_id := fnd_global.conc_program_id;

702: v_wip_res_actual_times(ins_counter).last_update_login := fnd_global.login_id;
703: v_wip_res_actual_times(ins_counter).object_version_number := 1;
704: v_wip_res_actual_times(ins_counter).action_flag := l_wip_time_intf_tbl(l_counter).action_flag;
705: v_wip_res_actual_times(ins_counter).request_id := fnd_global.conc_request_id;
706: v_wip_res_actual_times(ins_counter).program_id := fnd_global.conc_program_id;
707: v_wip_res_actual_times(ins_counter).program_application_id := fnd_global.prog_appl_id;
708: v_wip_res_actual_times(ins_counter).program_update_date := sysdate;
709: ins_counter := ins_counter+1;
710: end if;

Line 707: v_wip_res_actual_times(ins_counter).program_application_id := fnd_global.prog_appl_id;

703: v_wip_res_actual_times(ins_counter).object_version_number := 1;
704: v_wip_res_actual_times(ins_counter).action_flag := l_wip_time_intf_tbl(l_counter).action_flag;
705: v_wip_res_actual_times(ins_counter).request_id := fnd_global.conc_request_id;
706: v_wip_res_actual_times(ins_counter).program_id := fnd_global.conc_program_id;
707: v_wip_res_actual_times(ins_counter).program_application_id := fnd_global.prog_appl_id;
708: v_wip_res_actual_times(ins_counter).program_update_date := sysdate;
709: ins_counter := ins_counter+1;
710: end if;
711: v_process_status(pop_counter) := l_wip_time_intf_tbl(l_counter).process_status;