[Home] [Help]
327: procedure populateEndPegsMFQ(p_plan_id in number,
328: p_end_demand_id in number, p_query_id in number) is
329: begin
330:
331: insert into msc_form_query (query_id,
332: last_update_date,
333: last_updated_by,
334: creation_date,
335: created_by,
359: 16, COPROD_NODE,
360: 17, COPROD_NODE,
361: 28, COPROD_NODE,
362: JOB_NODE) nodetype
363: from msc_form_query mfq,
364: msc_supplies ms
365: where mfq.query_id = p_mfq_query_id
366: and mfq.NUMBER2 = ms.sr_instance_id
367: and mfq.NUMBER1 = ms.transaction_id
371: md.sr_instance_id,
372: md.organization_id,
373: md.demand_id,
374: END_DEMAND_NODE nodetype
375: from msc_form_query mfq,
376: msc_demands md
377: where mfq.query_id = p_mfq_query_id
378: and mfq.NUMBER2 = md.sr_instance_id
379: and mfq.NUMBER1 = md.demand_id
418: v_instance_id := p_inst_id;
419: v_transaction_id := p_trx_id;
420: end if;
421:
422: insert into msc_form_query
423: (query_id, last_update_date, last_updated_by, creation_date, created_by,
424: last_update_login, number1, number2)
425: values
426: ( p_query_id, sysdate, -1, sysdate, -1, -1, v_transaction_id, v_instance_id);
574:
575: select number1, number2, number3, number4, number5, char1
576: bulk collect into v_inst_id, v_org_id, v_dept_id, v_res_id,
577: v_res_instance_id, v_serial_number
578: from msc_form_query
579: where query_id = to_number(p_list);
580:
581: for i in 1.. v_inst_id.count loop
582: populateResIntoGantt(p_query_id, l_row_index, v_one_record,p_plan_id, v_inst_id(i),
589: p_res_instance_id number default null, p_serial_number varchar2 default null,
590: p_res_name varchar2 default null, p_alt_number varchar2 default null) is
591: begin
592:
593: insert into msc_form_query ( query_id,
594: last_update_date, last_updated_by, creation_date, created_by, last_update_login,
595: number1, number2, char1, char9, number3)
596: values ( p_query_id,
597: sysdate, -1, sysdate, -1,-1,
666: begin
667:
668: select number1, number2, number3, number4, number5
669: bulk collect into v_inst_id, v_org_id, v_item_id, v_supplier_id, v_supplier_site_id
670: from msc_form_query
671: where query_id = to_number(p_list);
672:
673: for i in 1.. v_inst_id.count loop
674: populateSuppIntoGantt(p_query_id, i, v_one_record,p_plan_id,
3981:
3982: -- 2. available capacity for items with NO delivery calendar
3983: select mgq.row_index, mfq.date1, msc.capacity
3984: bulk collect into v_row_index, v_start_date, v_qty
3985: from msc_form_query mfq,
3986: msc_plans mp,
3987: msc_supplier_capacities msc,
3988: msc_item_suppliers mis,
3989: msc_gantt_query mgq
4423: exit;
4424: end if;
4425: i := i + 1;
4426:
4427: insert into msc_form_query
4428: ( query_id, last_update_date, last_updated_by, creation_date, created_by, last_update_login,
4429: date1, date2)
4430: values
4431: ( p_query_id, sysdate, -1, sysdate, -1, -1, p_temp_start, p_temp_start+1);
4811: put_line(' among res where ');
4812: l_among_mfq_query_id := getMFQSequence(l_among_mfq_query_id);
4813:
4814: put_line(' l_among_mfq_query_id '||l_among_mfq_query_id);
4815: res_where_stat := 'insert into msc_form_query(query_id, number1, number2, '
4816: ||' number3, number4, number5, char1, '
4817: ||' last_update_date, last_updated_by, creation_date, created_by) '
4818: ||' select '||l_among_mfq_query_id
4819: ||' ,sr_instance_id, organization_id, '
4826:
4827: msc_get_name.execute_dsql(res_where_stat);
4828:
4829: res_where_stat := 'select number1, number2, number3, number4, number5, char1 '
4830: ||' from msc_form_query mfq, '
4831: ||' msc_among_values mav '
4832: ||' where mfq.query_id = :p_mfq_query '
4833: ||' and mav.folder_id = :p_folder '
4834: ||' and ltrim(rtrim(mav.field_name)) = :p_res_field '
5040: l_query_id number;
5041: begin
5042:
5043: if (p_query_id is not null) then
5044: delete from msc_form_query where query_id = p_query_id;
5045: return p_query_id;
5046: end if;
5047:
5048: select msc_form_query_s.nextval
5044: delete from msc_form_query where query_id = p_query_id;
5045: return p_query_id;
5046: end if;
5047:
5048: select msc_form_query_s.nextval
5049: into l_query_id
5050: from dual;
5051: return l_query_id;
5052:
5420: l_dummy_name_data, l_dummy_id_data, p_node_type, sys_yes);
5421:
5422: select count(*)
5423: into l_alt_count
5424: from msc_form_query
5425: where query_id = to_number(l_dummy_id_data)
5426: and number1 = p_alt_resource
5427: and nvl(number2, mbp_null_value) = nvl(p_alt_resource_inst, mbp_null_value)
5428: and nvl(char1, mbp_null_value_char) = nvl(p_serial_number, mbp_null_value_char)
9724: IF pos = 0 THEN
9725: stringend := LENGTH(p_list);
9726: token := to_number(SUBSTR(p_list, stringstart, stringend - stringstart + 1));
9727: if token is not null then
9728: insert into msc_form_query(
9729: query_id, last_update_date, last_updated_by, creation_date, created_by,
9730: last_update_login, number1)
9731: values (
9732: pQueryId, trunc(sysdate), -1, trunc(sysdate), -1, -1, token );
9735: end if;
9736: stringend := pos - 1;
9737: token := to_number(substr(p_list, stringstart, stringend - stringstart + 1));
9738: if token is not null then
9739: insert into msc_form_query(
9740: query_id, last_update_date, last_updated_by, creation_date, created_by,
9741: last_update_login, number1)
9742: values (
9743: pQueryId, trunc(sysdate), -1, trunc(sysdate), -1, -1, token);
9755: sum(nvl(mfp1.allocated_quantity,0)) allocated_quantity
9756: from msc_full_pegging mfp1,
9757: msc_full_pegging mfp2,
9758: msc_gantt_query mgq,
9759: msc_form_query mfq
9760: where mfp1.plan_id = p_plan
9761: and mfp1.transaction_id = p_trx
9762: and mfq.query_id = p_mfq_query_id
9763: and mgq.query_id = p_mgq_query_id
9770: select mgq.row_index,
9771: nvl(mfp1.allocated_quantity,0) allocated_quantity
9772: from msc_full_pegging mfp1,
9773: msc_gantt_query mgq,
9774: msc_form_query mfq
9775: where mfp1.plan_id = p_plan
9776: and mfp1.transaction_id = p_trx
9777: and mfq.query_id = p_mfq_query_id
9778: and mgq.query_id = p_mgq_query_id