APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_SUPPLIES

Line 371: update msc_supplies mr

367:
368: p_job_name := get_wip_job_prefix(p_inst_id)||
369: msc_rel_wf.get_job_seq_from_source(p_inst_id);
370:
371: update msc_supplies mr
372: set implement_wip_class_code =
373: nvl(p_wip_class_code, p_item_wip_class),
374: implement_status_code =
375: nvl(implement_status_code, p_def_job_status),

Line 394: 'MSC_SUPPLIES',

390:
391: p_load_type := msc_get_name.load_type(
392: p_plan_type,
393: p_plan_id,
394: 'MSC_SUPPLIES',
395: p_transaction_id,
396: p_org_id,
397: p_inst_id,
398: p_order_type,

Line 408: update msc_supplies mr

404: null);
405:
406: IF p_order_type in (1, 2, 3, 5, 51, 53,76,77,78) THEN
407: --pabram.srp.changes added 76,77,78
408: update msc_supplies mr
409: SET implement_date = nvl(mr.implement_date,
410: decode(trunc(GREATEST(NVL(mr.firm_date,mr.new_schedule_date),
411: TRUNC(SYSDATE))),
412: trunc(mr.new_schedule_date),

Line 474: update msc_supplies mr

470: and plan_id = p_plan_id;
471:
472: if p_order_type in (5,51,76,77,78) then
473: --pabram.srp.changes added 76,77,78
474: update msc_supplies mr
475: set quantity_in_process =
476: DECODE(mr.number1,
477: -9999, mr.quantity_in_process,
478: GREATEST(0,

Line 506: update msc_supplies msrs

502: where transaction_id = p_transaction_id
503: and plan_id = p_plan_id;
504: end if; -- if p_order_type in (5,51) then
505: ELSE -- p_order_type = 13
506: update msc_supplies msrs
507: SET implement_date = nvl(msrs.implement_date,
508: msrs.last_unit_completion_date),
509: implement_daily_rate = nvl(msrs.implement_daily_rate, msrs.daily_rate),
510: implement_quantity = nvl(msrs.implement_daily_rate, msrs.daily_rate),

Line 538: update msc_supplies

534: END update_success_supplies;
535:
536: Procedure update_sup_rel_error IS
537: BEGIN
538: update msc_supplies
539: SET implement_as = NULL,
540: implement_quantity = NULL,
541: implement_date = NULL,
542: release_status = 2,

Line 653: ' and source_table = ''MSC_SUPPLIES''' ||

649: 'quantity_rate '||
650: ' from '||msc_get_name.get_order_view(p_plan_type, p_plan_id) ||
651: ' where ' || p_where_clause ||
652: ' and order_type IN (1, 2, 3, 5, 13, 51, 53, 76,77,78)'||
653: ' and source_table = ''MSC_SUPPLIES''' ||
654: ' and nvl(release_time_fence_code,-1) <> 7' ||
655: -- Shikyu items should not be processed
656: ' and nvl(release_status,2) = 2';
657: --pabram.srp.changes added 76,77,78

Line 750: msc_supplies ms

746: CURSOR child_supply_c is
747: SELECT 1
748: from msc_full_pegging mfp1,
749: msc_full_pegging mfp2,
750: msc_supplies ms
751: where mfp1.plan_id = p_plan_id
752: and mfp1.transaction_id = p_transaction_id
753: and mfp2.plan_id = mfp1.plan_id
754: and mfp2.prev_pegging_id = mfp1.pegging_id