APPS.MSC_PHUB_PKG dependencies on MSC_PLAN_ORGANIZATIONS

Line 1899: --populate msc_plan_organizations one row for each org from msc_instance_orgs where sr_instance_id = p_sr_instance_id;

1895: );
1896: end loop;
1897: commit;
1898:
1899: --populate msc_plan_organizations one row for each org from msc_instance_orgs where sr_instance_id = p_sr_instance_id;
1900: msc_phub_util.log('Populating msc_plan_organizations');
1901: delete from msc_plan_organizations
1902: where plan_id=-1;
1903: commit;

Line 1900: msc_phub_util.log('Populating msc_plan_organizations');

1896: end loop;
1897: commit;
1898:
1899: --populate msc_plan_organizations one row for each org from msc_instance_orgs where sr_instance_id = p_sr_instance_id;
1900: msc_phub_util.log('Populating msc_plan_organizations');
1901: delete from msc_plan_organizations
1902: where plan_id=-1;
1903: commit;
1904:

Line 1901: delete from msc_plan_organizations

1897: commit;
1898:
1899: --populate msc_plan_organizations one row for each org from msc_instance_orgs where sr_instance_id = p_sr_instance_id;
1900: msc_phub_util.log('Populating msc_plan_organizations');
1901: delete from msc_plan_organizations
1902: where plan_id=-1;
1903: commit;
1904:
1905: insert into msc_plan_organizations(

Line 1905: insert into msc_plan_organizations(

1901: delete from msc_plan_organizations
1902: where plan_id=-1;
1903: commit;
1904:
1905: insert into msc_plan_organizations(
1906: plan_id,
1907: organization_id,
1908: sr_instance_id,
1909: organization_code,