APPS.MSC_PHUB_FILE_PKG dependencies on MSC_PLANS

Line 580: select msc_plans_s.nextval into l_pi.plan_id from dual;

576: if (nvl(p_validate_only, msc_phub_pkg.sys_yes) = msc_phub_pkg.sys_yes) then
577: return;
578: end if;
579:
580: select msc_plans_s.nextval into l_pi.plan_id from dual;
581: else
582: begin
583: select plan_id, plan_type
584: into l_pi.plan_id, l_plan_type2

Line 587: from msc_plans

583: select plan_id, plan_type
584: into l_pi.plan_id, l_plan_type2
585: from
586: (select plan_id, compile_designator, plan_type
587: from msc_plans
588: union
589: select das.scenario_id, substr(das.scenario_name, 1, 50), 10
590: from msd_dp_ascp_scenarios_v das, msd_dem_transfer_query tq
591: where das.demand_plan_id=5555555

Line 613: from msc_plans p, msc_designators d

609: raise e_prepare_context;
610: end if;
611:
612: select count(*) into n
613: from msc_plans p, msc_designators d
614: where p.plan_id=l_pi.plan_id
615: and p.sr_instance_id=d.sr_instance_id
616: and p.compile_designator=d.designator
617: and p.organization_id=d.organization_id;

Line 774: select msc_plans_s.nextval into l_plan_id from dual;

770: errbuf := null;
771:
772: select plan_name into l_plan_name from msc_apcc_upload where transfer_id=p_transfer_id;
773:
774: select msc_plans_s.nextval into l_plan_id from dual;
775:
776: /*
777: l_plan_id := msc_manage_plan_partitions.get_plan(
778: l_plan_name, l_return_status, errbuf);

Line 795: insert into msc_plans (

791: raise e_create_plan;
792: end if;
793: */
794:
795: insert into msc_plans (
796: plan_id,
797: compile_designator,
798: description,
799: plan_type,