458:
459: --the following cursors simply lock the records writeJobSchedule() will later modify
460: cursor c_job is
461: select 1
462: from wip_discrete_jobs
463: where wip_entity_id = p_wipEntityID
464: and organization_id = p_orgID
465: for update nowait;
466:
573: -- between resource UOM and standard HR uom code received from BOM profile value.
574:
575:
576: -- Fixed bug 5440007
577: -- Added decode clause to derive the quantity from wip_discrete_jobs only if the parameter
578: -- p_quantity is null
579: select wor.operation_seq_num,
580: wor.resource_id,
581: nvl(bdr.share_from_dept_id, bdr.department_id),
632: x_resTbls.schedFlag,
633: x_resTbls.avail24Flag,
634: x_resTbls.totalDaysUsg,
635: x_assignedUnits
636: from wip_discrete_jobs wdj,
637: wip_operations wo,
638: wip_operation_resources wor,
639: mtl_uom_conversions muc,
640: bom_department_resources bdr,
1133: --so below update is correct.
1134: l_jobStartDate := nvl(l_minResStartDate, p_anchorDate);
1135: l_jobCplDate := nvl(l_maxResEndDate, p_anchorDate);
1136:
1137: update wip_discrete_jobs
1138: set scheduled_start_date = l_jobStartDate,
1139: scheduled_completion_date = l_jobCplDate,
1140: last_update_date = l_sysdate,
1141: last_updated_by = l_userID,