[Home] [Help]
308: if (p_midPntOpSeqNum is not null AND
309: p_midPntResSeqNum is not null) then
310: select nvl(schedule_seq_num, resource_seq_num)
311: into x_minSchedSeqNum
312: from wip_operation_resources
313: where wip_entity_id = p_wipEntityID
314: and organization_id = p_orgID
315: and operation_seq_num = p_midPntOpSeqNum
316: and resource_seq_num = p_midPntResSeqNum;
325: and organization_id = p_orgID;
326:
327: select max(nvl(schedule_seq_num, resource_seq_num))
328: into x_maxSchedSeqNum
329: from wip_operation_resources
330: where wip_entity_id = p_wipEntityID
331: and organization_id = p_orgID
332: and operation_seq_num = x_maxOpSeqNum;
333:
337: if (p_midPntOpSeqNum is not null AND
338: p_midPntResSeqNum is not null) then
339: select nvl(schedule_seq_num, resource_seq_num)
340: into x_maxSchedSeqNum
341: from wip_operation_resources
342: where wip_entity_id = p_wipEntityID
343: and organization_id = p_orgID
344: and operation_seq_num = p_midPntOpSeqNum
345: and resource_seq_num = p_midPntResSeqNum;
358: and organization_id = p_orgID;
359:
360: select min(nvl(schedule_seq_num, resource_seq_num))
361: into x_minSchedSeqNum
362: from wip_operation_resources
363: where wip_entity_id = p_wipEntityID
364: and organization_id = p_orgID
365: and operation_seq_num = x_minOpSeqNum;
366: elsif(p_schedMethod = wip_constants.current_op) then
372: x_minOpSeqNum := p_midPntOpSeqNum;
373: x_maxOpSeqNum := p_midPntOpSeqNum;
374: select min(nvl(schedule_seq_num, resource_seq_num)), max(nvl(schedule_seq_num, resource_seq_num))
375: into x_minSchedSeqNum, x_maxSchedSeqNum
376: from wip_operation_resources
377: where wip_entity_id = p_wipEntityID
378: and organization_id = p_orgID
379: and operation_seq_num = p_midPntOpSeqNum;
380: elsif(p_schedMethod = wip_constants.current_sub_grp) then
387: x_maxOpSeqNum := p_midPntOpSeqNum;
388:
389: select min(nvl(schedule_seq_num, resource_seq_num)), max(nvl(schedule_seq_num, resource_seq_num))
390: into x_minSchedSeqNum, x_maxSchedSeqNum
391: from wip_operation_resources
392: where wip_entity_id = p_wipEntityID
393: and organization_id = p_orgID
394: and operation_seq_num = p_midPntOpSeqNum
395: and substitute_group_num = p_subGrpNum;
405: if (p_midPntOpSeqNum is not null AND
406: p_midPntResSeqNum is not null) then
407: select nvl(schedule_seq_num, resource_seq_num)
408: into x_minSchedSeqNum
409: from wip_operation_resources
410: where wip_entity_id = p_wipEntityID
411: and organization_id = p_orgID
412: and operation_seq_num = p_midPntOpSeqNum
413: and resource_seq_num = p_midPntResSeqNum;
482:
483: cursor c_resUsgs is
484: select 1
485: from wip_operation_resource_usage woru,
486: wip_operation_resources wor
487: where wor.wip_entity_id = p_wipEntityID
488: and wor.organization_id = p_orgID
489: and ( wor.operation_seq_num < p_maxOpSeqNum
490: and wor.operation_seq_num > p_minOpSeqNum
509:
510: cursor c_resInsts is
511: select 1
512: from wip_op_resource_instances wori,
513: wip_operation_resources wor
514: where wor.wip_entity_id = p_wipEntityID
515: and wor.organization_id = p_orgID
516: and ( wor.operation_seq_num < p_maxOpSeqNum
517: and wor.operation_seq_num > p_minOpSeqNum
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,
641: wip_parameters wp
642: where wp.organization_id = wdj.organization_id
779: x_returnStatus := fnd_api.g_ret_sts_success;
780:
781: --update resources
782: forall i in 1..x_resTbls.resID.count
783: update wip_operation_resources
784: set start_date = x_resTbls.startDate(i),
785: completion_date = x_resTbls.endDate(i),
786: last_update_date = l_sysdate,
787: last_updated_by = l_userID,
821: (select organization_id,
822: wip_entity_id,
823: operation_seq_num,
824: resource_seq_num
825: from wip_operation_resources wor
826: where wor.wip_entity_id = p_wipEntityID
827: and wor.organization_id = p_orgID
828: and ( wor.operation_seq_num < p_maxOpSeqNum
829: and wor.operation_seq_num > p_minOpSeqNum
927: l_progID,
928: l_sysdate
929: from wip_operation_resource_usage woru,
930: wip_op_resource_instances wori,
931: wip_operation_resources wor
932: where woru.wip_entity_id = wori.wip_entity_id
933: and woru.operation_seq_num = wori.operation_seq_num
934: and woru.resource_seq_num = wori.resource_seq_num
935: and woru.organization_id = wori.organization_id
971: l_opTbls.opSeqNum,
972: l_opTbls.startDate,
973: l_opTbls.endDate
974: from wip_operations wo,
975: wip_operation_resources wor
976: where wo.wip_entity_id = p_wipEntityID
977: and wo.organization_id = p_orgID
978: and wo.wip_entity_id = wor.wip_entity_id (+)
979: and wo.organization_id = wor.organization_id (+)
987: l_opSchYesTbls.opSeqNum,
988: l_opSchYesTbls.startDate,
989: l_opSchYesTbls.endDate
990: from wip_operations wo,
991: wip_operation_resources wor
992: where wo.wip_entity_id = p_wipEntityID
993: and wo.organization_id = p_orgID
994: and wo.wip_entity_id = wor.wip_entity_id (+)
995: and wo.organization_id = wor.organization_id (+)
1120: --now update job dates
1121: --must select from table to get resource dates b/c of partial job scheduling
1122: select min(start_date), max(completion_date)
1123: into l_minResStartDate, l_maxResEndDate
1124: from wip_operation_resources
1125: where wip_entity_id = p_wipEntityID
1126: and organization_id = p_orgID;
1127:
1128: if(l_logLevel <= wip_constants.full_logging) then