DBA Data[Home] [Help]

APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_SRP_PERIOD_QUOTAS_PKG

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