APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_SRP_PERIOD_QUOTAS

Line 1652: FROM cn_srp_period_quotas

1648: pe_quota_id cn_quotas.quota_id%TYPE
1649: )
1650: IS
1651: SELECT srp_period_quota_id
1652: FROM cn_srp_period_quotas
1653: WHERE quota_id = pe_quota_id;
1654:
1655: g_last_update_date DATE := SYSDATE;
1656: g_last_updated_by NUMBER := fnd_global.user_id;

Line 1861: -- check if we need to update the cn_srp_period_quotas ext table. If yes, update the table

1857: -- cn_period_quotas_pkg.DELETE_RECORD (p_plan_element.quota_id);
1858: cn_period_quotas_pkg.distribute_target (p_plan_element.quota_id);
1859: END IF;
1860: -- Commented out for Bug 4722521------------------------------------------------
1861: -- check if we need to update the cn_srp_period_quotas ext table. If yes, update the table
1862: -- if the new assignement is external package, we do not do anything
1863: IF p_plan_element.quota_type_code <> 'EXTERNAL'
1864: THEN
1865: -- if the old assignement is external package, we wipe out the ext table and re-insert the record

Line 1879: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('DELETE',

1875: IF l_number_dim > 1
1876: THEN
1877: FOR l_srp_period_quota_id IN c_srp_period_quota_csr (l_old_plan_element.quota_id)
1878: LOOP
1879: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('DELETE',
1880: l_srp_period_quota_id.srp_period_quota_id,
1881: l_old_plan_element.org_id
1882: );
1883: END LOOP;

Line 1887: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('INSERT',

1883: END LOOP;
1884:
1885: FOR l_srp_period_quota_id IN c_srp_period_quota_csr (l_old_plan_element.quota_id)
1886: LOOP
1887: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('INSERT',
1888: l_srp_period_quota_id.srp_period_quota_id,
1889: l_old_plan_element.org_id,
1890: l_number_dim
1891: );

Line 1912: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('DELETE',

1908: IF l_number_dim_new < l_number_dim_old
1909: THEN
1910: FOR l_srp_period_quota_id IN c_srp_period_quota_csr (l_old_plan_element.quota_id)
1911: LOOP
1912: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('DELETE',
1913: l_srp_period_quota_id.srp_period_quota_id,
1914: l_old_plan_element.org_id
1915: );
1916: END LOOP;

Line 1924: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('INSERT',

1920: IF l_number_dim_new > 1
1921: THEN
1922: FOR l_srp_period_quota_id IN c_srp_period_quota_csr (l_old_plan_element.quota_id)
1923: LOOP
1924: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('INSERT',
1925: l_srp_period_quota_id.srp_period_quota_id,
1926: l_old_plan_element.org_id,
1927: l_number_dim_new
1928: );