eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_MASSLOAD_PUB dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 37: from wip_job_schedule_interface

33: l_success number; --8296679
34:
35: cursor c_allrows is
36: select 1
37: from wip_job_schedule_interface
38: where group_id = p_groupID
39: and process_status = wip_constants.pending
40: and process_phase = wip_constants.ml_validation
41: and load_type <> wip_constants.create_sched

Line 56: from wip_job_schedule_interface

52: load_type, --8494582
53: status_type, --8296679
54: class_code, --8296679
55: date_released --8296679
56: from wip_job_schedule_interface
57: where group_id = p_groupID
58: and process_phase = wip_constants.ml_validation
59: and process_status in (wip_constants.running, wip_constants.warning)
60: and load_type <> wip_constants.create_sched;

Line 68: from wip_discrete_jobs wdj, wip_job_schedule_interface wjsi

64: wdj.organization_id,
65: wdj.status_type,
66: wdj.class_code,
67: wdj.date_released
68: from wip_discrete_jobs wdj, wip_job_schedule_interface wjsi
69: where wjsi.group_id = p_groupID
70: and process_status in (wip_constants.running, wip_constants.warning)
71: and wjsi.wip_entity_id = wdj.wip_entity_id
72: and wdj.status_type in (wip_constants.released, wip_constants.hold);

Line 92: from wip_job_schedule_interface

88:
89: -- print the no.of discrete requests to log
90:
91: select count(*) into l_requestCount
92: from wip_job_schedule_interface
93: where group_id = p_groupID
94: and process_status = wip_constants.pending
95: and process_phase = wip_constants.ml_validation
96: and load_type <> wip_constants.create_sched;

Line 109: update wip_job_schedule_interface

105: close c_allrows;
106: end if;
107:
108: -- assign interface_id and set process_status to running
109: update wip_job_schedule_interface
110: set interface_id = wip_interface_s.nextval,
111: process_status = wip_constants.running
112: where group_id = p_groupID
113: and process_status = wip_constants.pending

Line 157: from wip_job_schedule_interface wjsi,

153: end if;
154:
155: select count(*)
156: into l_totalNum
157: from wip_job_schedule_interface wjsi,
158: wip_job_dtls_interface wjdi
159: where wjdi.parent_header_id = wjsi.header_id
160: and wjdi.group_id = wjsi.group_id
161: and wjdi.process_phase = wip_constants.ml_validation

Line 223: wip_job_schedule_interface wjsi

219: into l_wjsi_new_status_type, /*Removed old status type for bug 8494582*/
220: l_wdj_wip_entity_id,
221: l_wdj_organization_id
222: from wip_discrete_jobs wdj,
223: wip_job_schedule_interface wjsi
224: where wjsi.rowid = wjsi_rec.rowid
225: and wdj.wip_entity_id = wjsi.wip_entity_id
226: and wdj.organization_id = wjsi.organization_id
227: and wjsi.load_type in (WIP_CONSTANTS.CREATE_JOB,

Line 332: update wip_job_schedule_interface

328: end loop;
329:
330:
331:
332: update wip_job_schedule_interface
333: set process_status = wip_constants.completed,
334: process_phase = wip_constants.ml_complete
335: where group_id = p_groupID
336: and process_status in (wip_constants.running, wip_constants.warning)

Line 345: from wip_job_schedule_interface

341: commit;
342: end if;
343:
344: select count(*) into l_errRecCount
345: from wip_job_schedule_interface
346: where group_id = p_groupID
347: and process_status = wip_constants.error;
348:
349: if(l_errRecCount > 0) then

Line 409: l_load_type wip_job_schedule_interface.load_type%TYPE; --8936011

405: l_groupID number;
406: l_headerID number;
407: l_rowid rowid;
408: l_errorCode varchar2(240);
409: l_load_type wip_job_schedule_interface.load_type%TYPE; --8936011
410: l_status_type wip_job_schedule_interface.status_type%TYPE; --8936011
411: l_wip_entity_id wip_job_schedule_interface.wip_entity_id%TYPE; --8936011
412: l_organization_id wip_job_schedule_interface.organization_id%TYPE; --8936011
413: l_class_code wip_job_schedule_interface.class_code%TYPE; --8936011

Line 410: l_status_type wip_job_schedule_interface.status_type%TYPE; --8936011

406: l_headerID number;
407: l_rowid rowid;
408: l_errorCode varchar2(240);
409: l_load_type wip_job_schedule_interface.load_type%TYPE; --8936011
410: l_status_type wip_job_schedule_interface.status_type%TYPE; --8936011
411: l_wip_entity_id wip_job_schedule_interface.wip_entity_id%TYPE; --8936011
412: l_organization_id wip_job_schedule_interface.organization_id%TYPE; --8936011
413: l_class_code wip_job_schedule_interface.class_code%TYPE; --8936011
414: l_date_released wip_job_schedule_interface.date_released%TYPE; --8936011

Line 411: l_wip_entity_id wip_job_schedule_interface.wip_entity_id%TYPE; --8936011

407: l_rowid rowid;
408: l_errorCode varchar2(240);
409: l_load_type wip_job_schedule_interface.load_type%TYPE; --8936011
410: l_status_type wip_job_schedule_interface.status_type%TYPE; --8936011
411: l_wip_entity_id wip_job_schedule_interface.wip_entity_id%TYPE; --8936011
412: l_organization_id wip_job_schedule_interface.organization_id%TYPE; --8936011
413: l_class_code wip_job_schedule_interface.class_code%TYPE; --8936011
414: l_date_released wip_job_schedule_interface.date_released%TYPE; --8936011
415: l_success number; --8936011

Line 412: l_organization_id wip_job_schedule_interface.organization_id%TYPE; --8936011

408: l_errorCode varchar2(240);
409: l_load_type wip_job_schedule_interface.load_type%TYPE; --8936011
410: l_status_type wip_job_schedule_interface.status_type%TYPE; --8936011
411: l_wip_entity_id wip_job_schedule_interface.wip_entity_id%TYPE; --8936011
412: l_organization_id wip_job_schedule_interface.organization_id%TYPE; --8936011
413: l_class_code wip_job_schedule_interface.class_code%TYPE; --8936011
414: l_date_released wip_job_schedule_interface.date_released%TYPE; --8936011
415: l_success number; --8936011
416:

Line 413: l_class_code wip_job_schedule_interface.class_code%TYPE; --8936011

409: l_load_type wip_job_schedule_interface.load_type%TYPE; --8936011
410: l_status_type wip_job_schedule_interface.status_type%TYPE; --8936011
411: l_wip_entity_id wip_job_schedule_interface.wip_entity_id%TYPE; --8936011
412: l_organization_id wip_job_schedule_interface.organization_id%TYPE; --8936011
413: l_class_code wip_job_schedule_interface.class_code%TYPE; --8936011
414: l_date_released wip_job_schedule_interface.date_released%TYPE; --8936011
415: l_success number; --8936011
416:
417: cursor c_allrows is

Line 414: l_date_released wip_job_schedule_interface.date_released%TYPE; --8936011

410: l_status_type wip_job_schedule_interface.status_type%TYPE; --8936011
411: l_wip_entity_id wip_job_schedule_interface.wip_entity_id%TYPE; --8936011
412: l_organization_id wip_job_schedule_interface.organization_id%TYPE; --8936011
413: l_class_code wip_job_schedule_interface.class_code%TYPE; --8936011
414: l_date_released wip_job_schedule_interface.date_released%TYPE; --8936011
415: l_success number; --8936011
416:
417: cursor c_allrows is
418: select 1

Line 419: from wip_job_schedule_interface

415: l_success number; --8936011
416:
417: cursor c_allrows is
418: select 1
419: from wip_job_schedule_interface
420: where interface_id = p_interfaceID
421: for update nowait;
422: begin
423: x_returnStatus := fnd_api.g_ret_sts_success;

Line 439: from wip_job_schedule_interface

435: end if;
436:
437: select rowid, group_id, header_id
438: into l_rowid, l_groupID, l_headerID
439: from wip_job_schedule_interface
440: where interface_id = p_interfaceID;
441:
442: select count(*)
443: into l_totalNum

Line 444: from wip_job_schedule_interface

440: where interface_id = p_interfaceID;
441:
442: select count(*)
443: into l_totalNum
444: from wip_job_schedule_interface
445: where interface_id = p_interfaceID
446: and process_status = wip_constants.pending
447: and process_phase = wip_constants.ml_validation
448: and load_type in (wip_constants.create_job, wip_constants.create_ns_job);

Line 458: from wip_job_schedule_interface wjsi

454: end if;
455:
456: select count(*)
457: into l_totalNum
458: from wip_job_schedule_interface wjsi
459: where wjsi.group_id = l_groupID;
460:
461: if ( l_totalNum <> 1 ) then
462: fnd_message.set_name('WIP', 'WIP_WJSI_ONE_ROW');

Line 473: update wip_job_schedule_interface

469: if ( c_allrows%isopen ) then
470: close c_allrows;
471: end if;
472:
473: update wip_job_schedule_interface
474: set process_status = wip_constants.running
475: where interface_id = p_interfaceID;
476:
477: -- do the validation for those records

Line 488: from wip_job_schedule_interface

484: end if;
485:
486: select count(*)
487: into l_totalNum
488: from wip_job_schedule_interface
489: where interface_id = p_interfaceID
490: and process_status in (wip_constants.running, wip_constants.warning);
491:
492: if ( l_totalNum <> 1 ) then

Line 505: from wip_job_schedule_interface wjsi,

501: end if;
502:
503: select count(*)
504: into l_totalNum
505: from wip_job_schedule_interface wjsi,
506: wip_job_dtls_interface wjdi
507: where wjdi.parent_header_id = wjsi.header_id
508: and wjdi.group_id = wjsi.group_id
509: and wjdi.process_phase = wip_constants.ml_validation

Line 543: from wip_job_schedule_interface

539: select wip_entity_id,
540: load_type, status_type, organization_id, class_code, date_released --8936011
541: into x_wipEntityID,
542: l_load_type, l_status_type, l_organization_id, l_class_code, l_date_released --8936011
543: from wip_job_schedule_interface
544: where rowid = l_rowid;
545:
546: /* Fix 8936011: Moved this code from wip_massload_pvt.processWJSI
547: to release the job after loading operation from WJDI to populate quantity

Line 569: update wip_job_schedule_interface

565: end if;
566:
567: /* End Fix 8936011 */
568:
569: update wip_job_schedule_interface
570: set process_status = wip_constants.completed
571: where rowid = l_rowid;
572:
573: if (l_logLevel <= wip_constants.trace_logging) then

Line 645: from wip_job_schedule_interface

641: l_wjsiSerOp,
642: l_loadType,
643: l_primaryItemID,
644: l_orgID
645: from wip_job_schedule_interface
646: where rowid = p_rowid;
647:
648: if ( l_wjsiSerOp is null and l_loadType = wip_constants.resched_job ) then
649: -- due to re-exploding, we may need to clear out the serialization start op