APPS.WIP_MASSLOAD_PVT dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 19: wjsi_row wip_job_schedule_interface%ROWTYPE;

15: l_logLevel number := to_number(fnd_log.g_current_runtime_level);
16: l_retStatus varchar2(1);
17: l_msg varchar2(240);
18:
19: wjsi_row wip_job_schedule_interface%ROWTYPE;
20: l_serStartOp number := null;
21: l_defaultSer number;
22: l_startDate date;
23: l_endDate date;

Line 53: from wip_job_schedule_interface

49: end if;
50:
51: select *
52: into wjsi_row
53: from wip_job_schedule_interface
54: where rowid = p_rowid;
55:
56: if ( l_logLevel <= wip_constants.trace_logging ) then
57: wip_logger.log('Interface id: ' || wjsi_row.interface_id || ' load type is: ' || wjsi_row.load_type,

Line 513: wip_job_schedule_interface wjsi

509: from wip_accounting_classes wac,
510: bom_operational_routings rtg,
511: bom_bill_of_materials bom,
512: wip_parameters wp,
513: wip_job_schedule_interface wjsi
514: where wjsi.rowid = p_rowid
515: and nvl(rtg.cfm_routing_flag,2) = 2
516: and wac.class_code(+) = wjsi.class_code
517: and wac.organization_id(+) = wjsi.organization_id

Line 566: from wip_job_schedule_interface wjsi

562: 1,
563: wjsi.description,
564: wjsi.primary_item_id,
565: mtl_gen_object_id_s.nextval
566: from wip_job_schedule_interface wjsi
567: where wjsi.rowid = p_rowid;
568: end createWIPEntity;
569:
570:

Line 576: from wip_job_schedule_interface

572: l_wipEntityID number;
573: begin
574: select wip_entity_id
575: into l_wipEntityID
576: from wip_job_schedule_interface
577: where rowid = p_rowid;
578:
579: update wip_discrete_jobs wdj
580: set (last_updated_by,

Line 792: FROM WIP_JOB_SCHEDULE_INTERFACE WJ

788: NULL,NULL,WJ.ALTERNATE_ROUTING_DESIGNATOR)),
789: nvl(wj.wip_supply_type,wdj.wip_supply_type), -- Fix for bug 5440109
790: nvl(wj.demand_class,wdj.demand_class) -- Fix for bug 5440109
791: --Bug 5230849:End of changes for bom/alternate designator updation.
792: FROM WIP_JOB_SCHEDULE_INTERFACE WJ
793: WHERE WJ.ROWID = p_rowid)
794: WHERE WDJ.WIP_ENTITY_ID = l_wipEntityID;
795:
796: UPDATE WIP_ENTITIES WE

Line 813: FROM WIP_JOB_SCHEDULE_INTERFACE WJ

809: PROGRAM_APPLICATION_ID,
810: PROGRAM_ID,
811: SYSDATE,
812: SYSDATE
813: FROM WIP_JOB_SCHEDULE_INTERFACE WJ
814: WHERE WJ.ROWID = p_rowid)
815: WHERE WE.WIP_ENTITY_ID = l_wipEntityID;
816: end updateWIPEntity;
817: