DBA Data[Home] [Help]

APPS.WIP_JSI_UTILS dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 55: from wip_job_schedule_interface

51: x_final_process_status := WIP_CONSTANTS.ERROR ;
52:
53: select group_id,header_id
54: into x_group_id, x_header_id
55: from wip_job_schedule_interface
56: where rowid = current_rowid;
57:
58: -- Change process_status of detail records to error.
59:

Line 70: update wip_job_schedule_interface

66: -- Use new utilities to load errors into interface errors table.
67:
68: WIP_INTERFACE_ERR_Utils.load_errors;
69:
70: update wip_job_schedule_interface
71: set
72: process_phase = current_process_phase,
73: process_status = x_final_process_status,
74: last_update_date = sysdate

Line 181: 'select 1 from wip_job_schedule_interface WJSI ' ||

177: request_matches_condition (p_where_clause in varchar2) return boolean
178: is
179:
180: x_statement varchar2(2000) :=
181: 'select 1 from wip_job_schedule_interface WJSI ' ||
182: 'where rowid = :x_row_id and ' ||
183: replace(p_where_clause, ' ', ' ') ;
184:
185: x_cursor_id integer ;

Line 257: 'update wip_job_schedule_interface WJSI ' ||

253:
254: begin
255:
256: x_statement :=
257: 'update wip_job_schedule_interface WJSI ' ||
258: 'set ' || p_column || ' = ' ||
259: replace(p_default_value_expression, ' ', ' ') || ' ' ||
260: 'where rowid = :x_row_id and ' ||
261: p_column || ' is null and ' ||