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 261: update wip_time_entry_interface wtei

257:
258: l_stmt_num := 57;
259: /* Added for to default employee_id for contingent Workers
260: No need as we don't currently support Emp and CW having same badge in same org from MES UI.
261: update wip_time_entry_interface wtei
262: set wtei.employee_id = ( select bre.person_id
263: from per_all_people_f papf,
264: bom_resource_employees bre
265: where papf.person_id = bre.person_id

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

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

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

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;
465: type t_error is table of wip_time_entry_interface.error%type index by binary_integer;
466:
467: v_interface_id t_interface_id;
468: v_process_status t_process_status;

Line 465: type t_error is table of wip_time_entry_interface.error%type 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;
465: type t_error is table of wip_time_entry_interface.error%type index by binary_integer;
466:
467: v_interface_id t_interface_id;
468: v_process_status t_process_status;
469: v_error t_error;

Line 798: -- update back wip_time_entry_interface table

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;
797:
798: -- update back wip_time_entry_interface table
799: forall upd_index in v_interface_id.first..v_interface_id.last
800: update wip_time_entry_interface set
801: process_status = decode(v_process_status(upd_index),
802: wip_constants.running,wip_constants.completed,v_process_status(upd_index) ),

Line 800: update wip_time_entry_interface set

796: end if;
797:
798: -- update back wip_time_entry_interface table
799: forall upd_index in v_interface_id.first..v_interface_id.last
800: update wip_time_entry_interface set
801: process_status = decode(v_process_status(upd_index),
802: wip_constants.running,wip_constants.completed,v_process_status(upd_index) ),
803: error = v_error(upd_index),
804: last_update_date = sysdate