DBA Data[Home] [Help]

APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_PERIOD_QUOTAS_PKG

Line 1168: cn_period_quotas_pkg.DELETE_RECORD (p_pe_rec_old.quota_id);

1164: /*OR
1165: Nvl(p_pe_rec_old.calc_formula_id,0) <> Nvl(p_pe_rec.calc_formula_id,0)*/
1166: THEN
1167: -- Call the Table Handler to Delete the Old Period quotas
1168: cn_period_quotas_pkg.DELETE_RECORD (p_pe_rec_old.quota_id);
1169: -- Check the ITD flag
1170: -- 2462767, we do not check for formula ID anymore,IF p_pe_rec.calc_formula_id IS NOT NULL THEN
1171: -- clku, enhancement 2380234
1172: --IF Nvl(cn_api.get_itd_flag(p_pe_rec.calc_formula_id),'N') = 'Y'

Line 1174: cn_period_quotas_pkg.distribute_target (p_pe_rec.quota_id);

1170: -- 2462767, we do not check for formula ID anymore,IF p_pe_rec.calc_formula_id IS NOT NULL THEN
1171: -- clku, enhancement 2380234
1172: --IF Nvl(cn_api.get_itd_flag(p_pe_rec.calc_formula_id),'N') = 'Y'
1173: -- THEN
1174: cn_period_quotas_pkg.distribute_target (p_pe_rec.quota_id);
1175:
1176: -- if count is zero create the default period quotas.
1177: IF p_period_quotas_rec_tbl.COUNT > 0
1178: THEN

Line 1282: cn_period_quotas_pkg.distribute_target (p_pe_rec.quota_id);

1278: --IF Nvl(cn_api.get_itd_flag(p_pe_rec.calc_formula_id),'N') = 'Y' THEN
1279: -- if count is zero create the default period quotas.
1280: IF p_period_quotas_rec_tbl.COUNT = 0
1281: THEN
1282: cn_period_quotas_pkg.distribute_target (p_pe_rec.quota_id);
1283: ELSE
1284: -- if count is > 0 then create the period quotas with the
1285: -- customised values.
1286: l_tmp := p_period_quotas_rec_tbl.COUNT;