[Home] [Help]
21: l_logLevel number := to_number(fnd_log.g_current_runtime_level);
22: l_retStatus varchar2(1);
23: l_msg varchar2(2000); --bug#16185044: changed the length from 240 to 2000
24:
25: wjsi_row wip_job_schedule_interface%ROWTYPE;
26: l_serStartOp number := null;
27: l_defaultSer number;
28: l_startDate date;
29: l_endDate date;
60: end if;
61:
62: select *
63: into wjsi_row
64: from wip_job_schedule_interface
65: where rowid = p_rowid;
66:
67: g_wjsiJobStatus := wjsi_row.status_type; --fix for bug 16079296
68: g_wjsiClassCode := wjsi_row.class_code; --fix for bug 16079296
659: from wip_accounting_classes wac,
660: bom_operational_routings rtg,
661: bom_structures_b bom,
662: wip_parameters wp,
663: wip_job_schedule_interface wjsi
664: where wjsi.rowid = p_rowid
665: and nvl(rtg.cfm_routing_flag,2) = 2
666: and wac.class_code(+) = wjsi.class_code
667: and wac.organization_id(+) = wjsi.organization_id
712: 1,
713: wjsi.description,
714: wjsi.primary_item_id,
715: mtl_gen_object_id_s.nextval
716: from wip_job_schedule_interface wjsi
717: where wjsi.rowid = p_rowid;
718: end createWIPEntity;
719:
720:
722: l_wipEntityID number;
723: begin
724: select wip_entity_id
725: into l_wipEntityID
726: from wip_job_schedule_interface
727: where rowid = p_rowid;
728:
729: update wip_discrete_jobs wdj
730: set (last_updated_by,
938: NULL,NULL,WJ.ALTERNATE_ROUTING_DESIGNATOR)),
939: nvl(wj.wip_supply_type,wdj.wip_supply_type), -- Fix for bug 5440109
940: nvl(wj.demand_class,wdj.demand_class) -- Fix for bug 5440109
941: --Bug 5230849:End of changes for bom/alternate designator updation.
942: FROM WIP_JOB_SCHEDULE_INTERFACE WJ
943: WHERE WJ.ROWID = p_rowid)
944: WHERE WDJ.WIP_ENTITY_ID = l_wipEntityID;
945:
946: /* fix for bug 16079296 for class_code update */
994: PROGRAM_APPLICATION_ID,
995: PROGRAM_ID,
996: SYSDATE,
997: SYSDATE
998: FROM WIP_JOB_SCHEDULE_INTERFACE WJ
999: WHERE WJ.ROWID = p_rowid)
1000: WHERE WE.WIP_ENTITY_ID = l_wipEntityID;
1001: end updateWIPEntity;
1002: