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 1837: -- check if we need to update the cn_srp_period_quotas ext table. If yes, update the table

1833: -- cn_period_quotas_pkg.DELETE_RECORD (p_plan_element.quota_id);
1834: cn_period_quotas_pkg.distribute_target (p_plan_element.quota_id);
1835: END IF;
1836: -- Commented out for Bug 4722521------------------------------------------------
1837: -- check if we need to update the cn_srp_period_quotas ext table. If yes, update the table
1838: -- if the new assignement is external package, we do not do anything
1839: IF p_plan_element.quota_type_code <> 'EXTERNAL'
1840: THEN
1841: -- if the old assignement is external package, we wipe out the ext table and re-insert the record

Line 1855: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('DELETE',

1851: IF l_number_dim > 1
1852: THEN
1853: FOR l_srp_period_quota_id IN c_srp_period_quota_csr (l_old_plan_element.quota_id)
1854: LOOP
1855: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('DELETE',
1856: l_srp_period_quota_id.srp_period_quota_id,
1857: l_old_plan_element.org_id
1858: );
1859: END LOOP;

Line 1863: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('INSERT',

1859: END LOOP;
1860:
1861: FOR l_srp_period_quota_id IN c_srp_period_quota_csr (l_old_plan_element.quota_id)
1862: LOOP
1863: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('INSERT',
1864: l_srp_period_quota_id.srp_period_quota_id,
1865: l_old_plan_element.org_id,
1866: l_number_dim
1867: );

Line 1888: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('DELETE',

1884: IF l_number_dim_new < l_number_dim_old
1885: THEN
1886: FOR l_srp_period_quota_id IN c_srp_period_quota_csr (l_old_plan_element.quota_id)
1887: LOOP
1888: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('DELETE',
1889: l_srp_period_quota_id.srp_period_quota_id,
1890: l_old_plan_element.org_id
1891: );
1892: END LOOP;

Line 1900: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('INSERT',

1896: IF l_number_dim_new > 1
1897: THEN
1898: FOR l_srp_period_quota_id IN c_srp_period_quota_csr (l_old_plan_element.quota_id)
1899: LOOP
1900: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('INSERT',
1901: l_srp_period_quota_id.srp_period_quota_id,
1902: l_old_plan_element.org_id,
1903: l_number_dim_new
1904: );