DBA Data[Home] [Help]

APPS.MSC_PHUB_FILE_PKG dependencies on DUAL

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 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);