DBA Data[Home] [Help]

APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_RT_QUOTA_ASGNS_PKG

Line 718: cn_rt_quota_asgns_pkg.DELETE_RECORD (x_quota_id => p_pe_rec_old.quota_id, x_calc_formula_id => NULL, x_rt_quota_asgn_id => NULL);

714: -- and end Date then insert through a batch by calling the Table Handler
715: IF NVL (p_pe_rec_old.calc_formula_id, 0) <> NVL (p_pe_rec.calc_formula_id, 0)
716: THEN
717: -- Call the Table Handler to Delete the Old Period quotas
718: cn_rt_quota_asgns_pkg.DELETE_RECORD (x_quota_id => p_pe_rec_old.quota_id, x_calc_formula_id => NULL, x_rt_quota_asgn_id => NULL);
719: END IF;
720:
721: IF p_rt_quota_asgns_rec_tbl.COUNT = 0
722: THEN

Line 729: cn_rt_quota_asgns_pkg.INSERT_RECORD (x_quota_id => p_pe_rec.quota_id, x_calc_formula_id => p_pe_rec.calc_formula_id);

725: -- if called from public api then we need to insert defaults
726: -- else the defaults are inserted by direct rate tables assignment calls
727: --IF p_pe_rec.call_type = cn_plan_element_pvt.g_public_api
728: --THEN
729: cn_rt_quota_asgns_pkg.INSERT_RECORD (x_quota_id => p_pe_rec.quota_id, x_calc_formula_id => p_pe_rec.calc_formula_id);
730: --END IF;
731: END IF;
732: -- if the rt_table_count is > 0 and the quota type is FORMULA
733: ELSIF p_rt_quota_asgns_rec_tbl.COUNT > 0

Line 1499: cn_rt_quota_asgns_pkg.INSERT_RECORD (x_quota_id => p_plan_element.quota_id, x_calc_formula_id => p_plan_element.calc_formula_id);

1495:
1496: IF p_plan_element.quota_status <> cn_plan_element_pvt.g_new_status
1497: THEN
1498: -- Call the Rate_quotas Procedure to create rate quota Assigns
1499: cn_rt_quota_asgns_pkg.INSERT_RECORD (x_quota_id => p_plan_element.quota_id, x_calc_formula_id => p_plan_element.calc_formula_id);
1500: END IF;
1501:
1502: -- Raise an Error if the Status is Failedx
1503: IF (x_return_status <> fnd_api.g_ret_sts_success)