APPS.WIP_TIME_ENTRY_PUB dependencies on WIP_TIME_ENTRY_INTERFACE

Line 33: from wip_time_entry_interface

29: v_wip_time_intf t_wip_time_intf;
30:
31: cursor running_intf_records(org_id Number) is
32: select *
33: from wip_time_entry_interface
34: where process_status = wip_constants.running
35: and organization_id = org_id;
36:
37: e_null_org_id exception;

Line 80: update wip_time_entry_interface

76: fnd_message.set_name('WIP','WIP_INVALID_SHIFT_PREF');
77: fnd_message.set_token('ORG', to_char(l_org_code));
78: l_err_msg := fnd_message.get;
79:
80: update wip_time_entry_interface
81: set process_status = wip_constants.error,
82: error = l_err_msg,
83: request_id = g_request_id,
84: program_id = g_program_id,

Line 124: update wip_time_entry_interface

120: fnd_message.set_name('WIP','WIP_INVALID_CLOCK_PREF');
121: fnd_message.set_token('ORG', to_char(l_org_code));
122: l_err_msg := fnd_message.get;
123:
124: update wip_time_entry_interface
125: set process_status = wip_constants.error,
126: error = l_err_msg,
127: request_id = g_request_id,
128: program_id = g_program_id,

Line 163: update wip_time_entry_interface

159:
160: fnd_message.set_name('WIP','WIP_AAH_IMPORT_NOT_ALLOWED');
161: l_err_msg := fnd_message.get;
162:
163: update wip_time_entry_interface
164: set process_status = wip_constants.error,
165: error = l_err_msg,
166: request_id = g_request_id,
167: program_id = g_program_id,

Line 194: update wip_time_entry_interface

190:
191: fnd_message.set_name('WIP','WIP_DLH_IMPORT_NOT_ALLOWED');
192: l_err_msg := fnd_message.get;
193:
194: update wip_time_entry_interface
195: set process_status = wip_constants.error,
196: error = l_err_msg,
197: request_id = g_request_id,
198: program_id = g_program_id,

Line 221: update wip_time_entry_interface

217:
218: end if;
219: l_stmt_num := 50;
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,

Line 240: update wip_time_entry_interface wtei

236: where mp.organization_id = p_organization_id));
237:
238: l_stmt_num := 55;
239: /* Added for Bug 6908314. This SQL will default employee_id from badge_id. */
240: update wip_time_entry_interface wtei
241: set wtei.employee_id = ( select bre.person_id
242: from per_all_people_f papf,
243: bom_resource_employees bre
244: where papf.person_id = bre.person_id

Line 416: type t_interface_id is table of wip_time_entry_interface.interface_id%type index by binary_integer;

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;
418: type t_error is table of wip_time_entry_interface.error%type index by binary_integer;
419:
420: v_interface_id t_interface_id;

Line 417: type t_process_status is table of wip_time_entry_interface.process_status%type index by binary_integer;

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;
418: type t_error is table of wip_time_entry_interface.error%type index by binary_integer;
419:
420: v_interface_id t_interface_id;
421: v_process_status t_process_status;

Line 418: type t_error is table of wip_time_entry_interface.error%type 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;
418: type t_error is table of wip_time_entry_interface.error%type index by binary_integer;
419:
420: v_interface_id t_interface_id;
421: v_process_status t_process_status;
422: v_error t_error;

Line 730: -- update back wip_time_entry_interface table

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;
729:
730: -- update back wip_time_entry_interface table
731: forall upd_index in v_interface_id.first..v_interface_id.last
732: update wip_time_entry_interface set
733: process_status = decode(v_process_status(upd_index),
734: wip_constants.running,wip_constants.completed,v_process_status(upd_index) ),

Line 732: update wip_time_entry_interface set

728: end if;
729:
730: -- update back wip_time_entry_interface table
731: forall upd_index in v_interface_id.first..v_interface_id.last
732: update wip_time_entry_interface set
733: process_status = decode(v_process_status(upd_index),
734: wip_constants.running,wip_constants.completed,v_process_status(upd_index) ),
735: error = v_error(upd_index),
736: last_update_date = sysdate