APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_SRP_PERIOD_QUOTAS_PKG

Line 3112: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('DELETE', l_srp_period_quota_id.srp_period_quota_id,l_srp_period_quota_id.org_id);

3108: IF l_number_dim > 1
3109: THEN
3110: FOR l_srp_period_quota_id IN c_srp_period_quota_csr (l_pe_rec_old.quota_id)
3111: LOOP
3112: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('DELETE', l_srp_period_quota_id.srp_period_quota_id,l_srp_period_quota_id.org_id);
3113: END LOOP;
3114:
3115: FOR l_srp_period_quota_id IN c_srp_period_quota_csr (l_pe_rec_old.quota_id)
3116: LOOP

Line 3117: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('INSERT', l_srp_period_quota_id.srp_period_quota_id,l_srp_period_quota_id.org_id, l_number_dim);

3113: END LOOP;
3114:
3115: FOR l_srp_period_quota_id IN c_srp_period_quota_csr (l_pe_rec_old.quota_id)
3116: LOOP
3117: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('INSERT', l_srp_period_quota_id.srp_period_quota_id,l_srp_period_quota_id.org_id, l_number_dim);
3118: END LOOP;
3119: END IF;
3120: ELSIF l_pe_rec.calc_formula_id <> l_pe_rec_old.calc_formula_id
3121: THEN

Line 3138: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('DELETE', l_srp_period_quota_id.srp_period_quota_id,l_srp_period_quota_id.org_id);

3134: IF l_number_dim_new < l_number_dim_old
3135: THEN
3136: FOR l_srp_period_quota_id IN c_srp_period_quota_csr (l_pe_rec_old.quota_id)
3137: LOOP
3138: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('DELETE', l_srp_period_quota_id.srp_period_quota_id,l_srp_period_quota_id.org_id);
3139: END LOOP;
3140: END IF;
3141:
3142: -- if reduce # dims to 1, then no longer need _ext records

Line 3147: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('INSERT',

3143: IF l_number_dim_new > 1
3144: THEN
3145: FOR l_srp_period_quota_id IN c_srp_period_quota_csr (l_pe_rec_old.quota_id)
3146: LOOP
3147: cn_srp_period_quotas_pkg.populate_srp_period_quotas_ext ('INSERT',
3148: l_srp_period_quota_id.srp_period_quota_id,
3149: l_number_dim_new
3150: );
3151: END LOOP;