APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_SRP_PERIOD_QUOTAS

Line 2806: FROM cn_srp_period_quotas

2802: pe_quota_id cn_quotas.quota_id%TYPE
2803: )
2804: IS
2805: SELECT srp_period_quota_id,org_id
2806: FROM cn_srp_period_quotas
2807: WHERE quota_id = pe_quota_id;
2808:
2809: l_number_dim_old NUMBER;
2810: l_number_dim_new NUMBER;

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

3089: THEN
3090: RAISE fnd_api.g_exc_error;
3091: END IF;
3092:
3093: -- check if we need to update the cn_srp_period_quotas ext table. If yes, update the table
3094:
3095: -- if the new assignement is external package, we do not do anything
3096: IF l_pe_rec.quota_type_code <> 'EXTERNAL'
3097: THEN

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;