[Home] [Help]
175: /*
176: and number2 not in
177: (select mon.to_op_seq_num
178: from msc_operation_networks mon,
179: msc_resource_requirements mrr
180: where mrr.plan_id = x_plan_id
181: and mrr.sr_instance_id = x_inst_id
182: and mrr.supply_id = x_supply_id
183: and mrr.end_date is not null
202: mon.to_op_seq_num,
203: mgq2.row_index to_index,
204: mon.dependency_type
205: from msc_operation_networks mon,
206: msc_resource_requirements mrr,
207: msc_gantt_query mgq1,
208: msc_gantt_query mgq2
209: where mrr.plan_id = x_plan_id
210: and mrr.sr_instance_id = x_inst_id
242: ms.transaction_id, ms.sr_instance_id,
243: mrr.operation_seq_num, mrr.routing_sequence_id)) critical_flag,
244: mrr.operation_seq_num,
245: mrr.resource_seq_num
246: from msc_resource_requirements mrr,
247: msc_supplies ms
248: where mrr.plan_id = x_plan_id
249: and mrr.sr_instance_id = x_instance_id
250: and mrr.organization_id = x_org_id
880: mrr.supply_id, mrr.sr_instance_id,
881: mrr.operation_seq_num, mrr.routing_sequence_id) critical_flag,
882: mro.operation_description op_desc,
883: mrr.start_date
884: from msc_resource_requirements mrr,
885: msc_routing_operations mro
886: where mrr.plan_id = g_plan_id
887: and mrr.sr_instance_id = p_instance_id
888: and mrr.organization_id = p_org_id
934: l_inst_id(i), l_org_id(i), l_critical_flag(i));
935: end loop; -- }
936: end insertOpJobFromMDIntoMFQ;
937:
938: -- if op exists in msc_demand but not in msc_resource_requirements,
939: -- show the op in the closest next op or prev op
940: procedure moveDmdOp(p_supply_id number) is
941:
942: v_op msc_gantt_utils.number_arr;
1198: l_dup_row_index number;
1199:
1200: cursor c_check_op_in_mrr (p_plan number, p_supply number) is
1201: select 1
1202: from msc_resource_requirements
1203: where plan_id = p_plan
1204: and supply_id = p_supply
1205: and nvl(parent_id,2) = 2;
1206:
1918: select distinct mrr.sr_instance_id, mrr.organization_id, mrr.supply_id
1919: bulk collect into v_inst_id, v_org_id, v_trx_id
1920: from msc_gantt_query mgq,
1921: msc_gantt_dtl_query mgdq,
1922: msc_resource_requirements mrr
1923: where mgq.query_id = p_from_query_id
1924: and mgq.row_index = p_from_index
1925: and mgq.query_id = mgdq.query_id
1926: and mgq.row_index = mgdq.row_index
1959: select distinct mrr.sr_instance_id, mrr.organization_id, mrr.supply_id
1960: bulk collect into v_inst_id, v_org_id, v_trx_id
1961: from msc_gantt_query mgq,
1962: msc_gantt_dtl_query mgdq,
1963: msc_resource_requirements mrr
1964: where mgq.query_id = p_from_query_id
1965: and mgq.row_index = p_from_index
1966: and mgq.query_id = mgdq.query_id
1967: and mgq.row_index = mgdq.row_index
2451: begin
2452: if ( p_node_type = RES_NODE ) then
2453: select count(*)
2454: into l_child_count
2455: from msc_resource_requirements mrr,
2456: msc_resource_instance_reqs mrir
2457: where mrr.plan_id = g_plan_id
2458: and mrr.sr_instance_id = p_inst_id
2459: and mrr.transaction_id = p_trx_id
2471: end if;
2472:
2473: select mrr.resource_hours
2474: into l_res_hours
2475: from msc_resource_requirements mrr
2476: where mrr.plan_id = g_plan_id
2477: and mrr.sr_instance_id = p_inst_id
2478: and mrr.transaction_id = p_trx_id
2479: for update of mrr.resource_hours nowait;
2477: and mrr.sr_instance_id = p_inst_id
2478: and mrr.transaction_id = p_trx_id
2479: for update of mrr.resource_hours nowait;
2480:
2481: update msc_resource_requirements
2482: set status =0,
2483: applied=2,
2484: assigned_units = p_assigned_units_hours
2485: where plan_id = g_plan_id
2502:
2503: if ( p_node_type = RES_NODE ) then
2504: select mrr.resource_hours
2505: into l_res_hours
2506: from msc_resource_requirements mrr
2507: where mrr.plan_id = g_plan_id
2508: and mrr.sr_instance_id = p_inst_id
2509: and mrr.transaction_id = p_trx_id
2510: for update of mrr.resource_hours nowait;
2508: and mrr.sr_instance_id = p_inst_id
2509: and mrr.transaction_id = p_trx_id
2510: for update of mrr.resource_hours nowait;
2511:
2512: update msc_resource_requirements
2513: set status =0,
2514: applied=2,
2515: resource_hours = p_resource_hours
2516: where plan_id = g_plan_id
2668: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2669: mfp2.demand_id, mfp2.sr_instance_id
2670: from msc_full_pegging mfp2,
2671: msc_full_pegging mfp,
2672: msc_resource_requirements mrr,
2673: msc_form_query mfq
2674: where mfq.query_id = v_mfq_from_query_id
2675: and mrr.plan_id = p_plan_id
2676: and mrr.sr_instance_id = mfq.number2
2718: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2719: mfp2.demand_id, mfp2.sr_instance_id
2720: from msc_full_pegging mfp2,
2721: msc_full_pegging mfp,
2722: msc_resource_requirements mrr
2723: where mrr.plan_id = p_plan_id
2724: and mrr.sr_instance_id = l_inst_id
2725: and mrr.organization_id = l_org_id
2726: and mrr.department_id = l_dept_id
2771: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2772: mfp2.demand_id, mfp2.sr_instance_id
2773: from msc_full_pegging mfp2,
2774: msc_full_pegging mfp,
2775: msc_resource_requirements mrr,
2776: msc_form_query mfq
2777: where mfq.query_id = v_mfq_from_query_id
2778: and mrr.plan_id = p_plan_id
2779: and mrr.sr_instance_id = mfq.number2
2817:
2818: cursor c_supp_view_date2 is
2819: select min(msr.consumption_date) start_date
2820: from msc_supplier_requirements msr,
2821: msc_resource_requirements mrr
2822: where mrr.plan_id = g_plan_id
2823: and mrr.transaction_id = p_trx_id
2824: and msr.plan_id = mrr.plan_id
2825: and msr.sr_instance_id = mrr.sr_instance_id
2826: and msr.supply_id = mrr.supply_id;
2827:
2828: cursor c_res_view_date1 is
2829: select min(nvl(mrr.firm_start_date,mrr.start_date)) start_date
2830: from msc_resource_requirements mrr
2831: where mrr.plan_id = g_plan_id
2832: and mrr.supply_id = p_trx_id;
2833:
2834: cursor c_res_view_date2 is
2832: and mrr.supply_id = p_trx_id;
2833:
2834: cursor c_res_view_date2 is
2835: select min(nvl(mrr.firm_start_date,mrr.start_date)) start_date
2836: from msc_resource_requirements mrr
2837: where mrr.plan_id = g_plan_id
2838: and mrr.transaction_id = p_trx_id;
2839:
2840: l_date date;