[Home] [Help]
326: procedure populateEndPegsMFQ(p_plan_id in number,
327: p_end_demand_id in number, p_query_id in number) is
328: begin
329:
330: insert into msc_form_query (query_id,
331: last_update_date,
332: last_updated_by,
333: creation_date,
334: created_by,
358: 16, COPROD_NODE,
359: 17, COPROD_NODE,
360: 28, COPROD_NODE,
361: JOB_NODE) nodetype
362: from msc_form_query mfq,
363: msc_supplies ms
364: where mfq.query_id = p_mfq_query_id
365: and mfq.NUMBER2 = ms.sr_instance_id
366: and mfq.NUMBER1 = ms.transaction_id
370: md.sr_instance_id,
371: md.organization_id,
372: md.demand_id,
373: END_DEMAND_NODE nodetype
374: from msc_form_query mfq,
375: msc_demands md
376: where mfq.query_id = p_mfq_query_id
377: and mfq.NUMBER2 = md.sr_instance_id
378: and mfq.NUMBER1 = md.demand_id
417: v_instance_id := p_inst_id;
418: v_transaction_id := p_trx_id;
419: end if;
420:
421: insert into msc_form_query
422: (query_id, last_update_date, last_updated_by, creation_date, created_by,
423: last_update_login, number1, number2)
424: values
425: ( p_query_id, sysdate, -1, sysdate, -1, -1, v_transaction_id, v_instance_id);
573:
574: select number1, number2, number3, number4, number5, char1
575: bulk collect into v_inst_id, v_org_id, v_dept_id, v_res_id,
576: v_res_instance_id, v_serial_number
577: from msc_form_query
578: where query_id = to_number(p_list);
579:
580: for i in 1.. v_inst_id.count loop
581: populateResIntoGantt(p_query_id, l_row_index, v_one_record,p_plan_id, v_inst_id(i),
588: p_res_instance_id number default null, p_serial_number varchar2 default null,
589: p_res_name varchar2 default null, p_alt_number varchar2 default null) is
590: begin
591:
592: insert into msc_form_query ( query_id,
593: last_update_date, last_updated_by, creation_date, created_by, last_update_login,
594: number1, number2, char1, char9, number3)
595: values ( p_query_id,
596: sysdate, -1, sysdate, -1,-1,
665: begin
666:
667: select number1, number2, number3, number4, number5
668: bulk collect into v_inst_id, v_org_id, v_item_id, v_supplier_id, v_supplier_site_id
669: from msc_form_query
670: where query_id = to_number(p_list);
671:
672: for i in 1.. v_inst_id.count loop
673: populateSuppIntoGantt(p_query_id, i, v_one_record,p_plan_id,
3976:
3977: -- 2. available capacity for items with NO delivery calendar
3978: select mgq.row_index, mfq.date1, msc.capacity
3979: bulk collect into v_row_index, v_start_date, v_qty
3980: from msc_form_query mfq,
3981: msc_plans mp,
3982: msc_supplier_capacities msc,
3983: msc_item_suppliers mis,
3984: msc_gantt_query mgq
4418: exit;
4419: end if;
4420: i := i + 1;
4421:
4422: insert into msc_form_query
4423: ( query_id, last_update_date, last_updated_by, creation_date, created_by, last_update_login,
4424: date1, date2)
4425: values
4426: ( p_query_id, sysdate, -1, sysdate, -1, -1, p_temp_start, p_temp_start+1);
4806: put_line(' among res where ');
4807: l_among_mfq_query_id := getMFQSequence(l_among_mfq_query_id);
4808:
4809: put_line(' l_among_mfq_query_id '||l_among_mfq_query_id);
4810: res_where_stat := 'insert into msc_form_query(query_id, number1, number2, '
4811: ||' number3, number4, number5, char1, '
4812: ||' last_update_date, last_updated_by, creation_date, created_by) '
4813: ||' select '||l_among_mfq_query_id
4814: ||' ,sr_instance_id, organization_id, '
4821:
4822: msc_get_name.execute_dsql(res_where_stat);
4823:
4824: res_where_stat := 'select number1, number2, number3, number4, number5, char1 '
4825: ||' from msc_form_query mfq, '
4826: ||' msc_among_values mav '
4827: ||' where mfq.query_id = :p_mfq_query '
4828: ||' and mav.folder_id = :p_folder '
4829: ||' and ltrim(rtrim(mav.field_name)) = :p_res_field '
5035: l_query_id number;
5036: begin
5037:
5038: if (p_query_id is not null) then
5039: delete from msc_form_query where query_id = p_query_id;
5040: return p_query_id;
5041: end if;
5042:
5043: select msc_form_query_s.nextval
5039: delete from msc_form_query where query_id = p_query_id;
5040: return p_query_id;
5041: end if;
5042:
5043: select msc_form_query_s.nextval
5044: into l_query_id
5045: from dual;
5046: return l_query_id;
5047:
5415: l_dummy_name_data, l_dummy_id_data, p_node_type, sys_yes);
5416:
5417: select count(*)
5418: into l_alt_count
5419: from msc_form_query
5420: where query_id = to_number(l_dummy_id_data)
5421: and number1 = p_alt_resource
5422: and nvl(number2, mbp_null_value) = nvl(p_alt_resource_inst, mbp_null_value)
5423: and nvl(char1, mbp_null_value_char) = nvl(p_serial_number, mbp_null_value_char)
9719: IF pos = 0 THEN
9720: stringend := LENGTH(p_list);
9721: token := to_number(SUBSTR(p_list, stringstart, stringend - stringstart + 1));
9722: if token is not null then
9723: insert into msc_form_query(
9724: query_id, last_update_date, last_updated_by, creation_date, created_by,
9725: last_update_login, number1)
9726: values (
9727: pQueryId, trunc(sysdate), -1, trunc(sysdate), -1, -1, token );
9730: end if;
9731: stringend := pos - 1;
9732: token := to_number(substr(p_list, stringstart, stringend - stringstart + 1));
9733: if token is not null then
9734: insert into msc_form_query(
9735: query_id, last_update_date, last_updated_by, creation_date, created_by,
9736: last_update_login, number1)
9737: values (
9738: pQueryId, trunc(sysdate), -1, trunc(sysdate), -1, -1, token);
9750: sum(nvl(mfp1.allocated_quantity,0)) allocated_quantity
9751: from msc_full_pegging mfp1,
9752: msc_full_pegging mfp2,
9753: msc_gantt_query mgq,
9754: msc_form_query mfq
9755: where mfp1.plan_id = p_plan
9756: and mfp1.transaction_id = p_trx
9757: and mfq.query_id = p_mfq_query_id
9758: and mgq.query_id = p_mgq_query_id
9765: select mgq.row_index,
9766: nvl(mfp1.allocated_quantity,0) allocated_quantity
9767: from msc_full_pegging mfp1,
9768: msc_gantt_query mgq,
9769: msc_form_query mfq
9770: where mfp1.plan_id = p_plan
9771: and mfp1.transaction_id = p_trx
9772: and mfq.query_id = p_mfq_query_id
9773: and mgq.query_id = p_mgq_query_id