APPS.WIP_MASSLOAD_PUB dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 36: from wip_job_schedule_interface

32: l_wdj_organization_id NUMBER;/*Added for bug 6641029*/
33:
34: cursor c_allrows is
35: select 1
36: from wip_job_schedule_interface
37: where group_id = p_groupID
38: and process_status = wip_constants.pending
39: and process_phase = wip_constants.ml_validation
40: and load_type <> wip_constants.create_sched

Line 47: from wip_job_schedule_interface

43: cursor c_wjsi is
44: select rowid,
45: header_id,
46: interface_id
47: from wip_job_schedule_interface
48: where group_id = p_groupID
49: and process_phase = wip_constants.ml_validation
50: and process_status in (wip_constants.running, wip_constants.warning)
51: and load_type <> wip_constants.create_sched;

Line 70: from wip_job_schedule_interface

66:
67: -- print the no.of discrete requests to log
68:
69: select count(*) into l_requestCount
70: from wip_job_schedule_interface
71: where group_id = p_groupID
72: and process_status = wip_constants.pending
73: and process_phase = wip_constants.ml_validation
74: and load_type <> wip_constants.create_sched;

Line 87: update wip_job_schedule_interface

83: close c_allrows;
84: end if;
85:
86: -- assign interface_id and set process_status to running
87: update wip_job_schedule_interface
88: set interface_id = wip_interface_s.nextval,
89: process_status = wip_constants.running
90: where group_id = p_groupID
91: and process_status = wip_constants.pending

Line 124: from wip_job_schedule_interface wjsi,

120: end if;
121:
122: select count(*)
123: into l_totalNum
124: from wip_job_schedule_interface wjsi,
125: wip_job_dtls_interface wjdi
126: where wjdi.parent_header_id = wjsi.header_id
127: and wjdi.group_id = wjsi.group_id
128: and wjdi.process_phase = wip_constants.ml_validation

Line 170: wip_job_schedule_interface wjsi

166: l_wjsi_new_status_type,
167: l_wdj_wip_entity_id,
168: l_wdj_organization_id
169: from wip_discrete_jobs wdj,
170: wip_job_schedule_interface wjsi
171: where wjsi.rowid = wjsi_rec.rowid
172: and wdj.wip_entity_id = wjsi.wip_entity_id
173: and wdj.organization_id = wjsi.organization_id
174: and wjsi.load_type in (WIP_CONSTANTS.CREATE_JOB,

Line 205: update wip_job_schedule_interface

201: end if;
202: end;
203: end loop;
204:
205: update wip_job_schedule_interface
206: set process_status = wip_constants.completed,
207: process_phase = wip_constants.ml_complete
208: where group_id = p_groupID
209: and process_status in (wip_constants.running, wip_constants.warning)

Line 218: from wip_job_schedule_interface

214: commit;
215: end if;
216:
217: select count(*) into l_errRecCount
218: from wip_job_schedule_interface
219: where group_id = p_groupID
220: and process_status = wip_constants.error;
221:
222: if(l_errRecCount > 0) then

Line 276: from wip_job_schedule_interface

272: l_errorCode varchar2(240);
273:
274: cursor c_allrows is
275: select 1
276: from wip_job_schedule_interface
277: where interface_id = p_interfaceID
278: for update nowait;
279: begin
280: x_returnStatus := fnd_api.g_ret_sts_success;

Line 296: from wip_job_schedule_interface

292: end if;
293:
294: select rowid, group_id, header_id
295: into l_rowid, l_groupID, l_headerID
296: from wip_job_schedule_interface
297: where interface_id = p_interfaceID;
298:
299: select count(*)
300: into l_totalNum

Line 301: from wip_job_schedule_interface

297: where interface_id = p_interfaceID;
298:
299: select count(*)
300: into l_totalNum
301: from wip_job_schedule_interface
302: where interface_id = p_interfaceID
303: and process_status = wip_constants.pending
304: and process_phase = wip_constants.ml_validation
305: and load_type in (wip_constants.create_job, wip_constants.create_ns_job);

Line 315: from wip_job_schedule_interface wjsi

311: end if;
312:
313: select count(*)
314: into l_totalNum
315: from wip_job_schedule_interface wjsi
316: where wjsi.group_id = l_groupID;
317:
318: if ( l_totalNum <> 1 ) then
319: fnd_message.set_name('WIP', 'WIP_WJSI_ONE_ROW');

Line 330: update wip_job_schedule_interface

326: if ( c_allrows%isopen ) then
327: close c_allrows;
328: end if;
329:
330: update wip_job_schedule_interface
331: set process_status = wip_constants.running
332: where interface_id = p_interfaceID;
333:
334: -- do the validation for those records

Line 345: from wip_job_schedule_interface

341: end if;
342:
343: select count(*)
344: into l_totalNum
345: from wip_job_schedule_interface
346: where interface_id = p_interfaceID
347: and process_status in (wip_constants.running, wip_constants.warning);
348:
349: if ( l_totalNum <> 1 ) then

Line 362: from wip_job_schedule_interface wjsi,

358: end if;
359:
360: select count(*)
361: into l_totalNum
362: from wip_job_schedule_interface wjsi,
363: wip_job_dtls_interface wjdi
364: where wjdi.parent_header_id = wjsi.header_id
365: and wjdi.group_id = wjsi.group_id
366: and wjdi.process_phase = wip_constants.ml_validation

Line 398: from wip_job_schedule_interface

394: end if;
395:
396: select wip_entity_id
397: into x_wipEntityID
398: from wip_job_schedule_interface
399: where rowid = l_rowid;
400:
401: update wip_job_schedule_interface
402: set process_status = wip_constants.completed

Line 401: update wip_job_schedule_interface

397: into x_wipEntityID
398: from wip_job_schedule_interface
399: where rowid = l_rowid;
400:
401: update wip_job_schedule_interface
402: set process_status = wip_constants.completed
403: where rowid = l_rowid;
404:
405: if (l_logLevel <= wip_constants.trace_logging) then

Line 478: from wip_job_schedule_interface

474: l_wjsiSerOp,
475: l_loadType,
476: l_primaryItemID,
477: l_orgID
478: from wip_job_schedule_interface
479: where rowid = p_rowid;
480:
481: if ( l_wjsiSerOp is null and l_loadType = wip_constants.resched_job ) then
482: -- due to re-exploding, we may need to clear out the serialization start op