APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_RT_QUOTA_ASGNS

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 737: /*cn_rt_quota_asgns_pvt.update_rt_quota_asgns (p_api_version => p_api_version,

733: ELSIF p_rt_quota_asgns_rec_tbl.COUNT > 0
734: THEN
735: -- call create_rt_quota_asgns_pvt package to validate and create
736: -- the rate Quota Assigns
737: /*cn_rt_quota_asgns_pvt.update_rt_quota_asgns (p_api_version => p_api_version,
738: p_init_msg_list => 'T',
739: p_commit => p_commit,
740: p_validation_level => p_validation_level,
741: x_return_status => x_return_status,

Line 748: cn_rt_quota_asgns_pvt.update_rt_quota_asgns (p_api_version => p_api_version,

744: p_quota_name => p_quota_name,
745: p_rt_quota_asgns_rec_tbl => p_rt_quota_asgns_rec_tbl,
746: x_loading_status => x_loading_status
747: );*/
748: cn_rt_quota_asgns_pvt.update_rt_quota_asgns (p_api_version => p_api_version,
749: p_init_msg_list => 'T',
750: p_commit => p_commit,
751: p_validation_level => p_validation_level,
752: x_return_status => x_return_status,

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)

Line 2498: FROM cn_rt_quota_asgns qa

2494: pe_quota_id cn_quotas.quota_id%TYPE
2495: )
2496: IS
2497: SELECT qa.rate_schedule_id
2498: FROM cn_rt_quota_asgns qa
2499: WHERE qa.quota_id = pe_quota_id;
2500:
2501: CURSOR c_rt_formula_csr (
2502: pe_quota_id cn_quotas.quota_id%TYPE,

Line 2503: pe_rate_schedule_id cn_rt_quota_asgns.rate_schedule_id%TYPE

2499: WHERE qa.quota_id = pe_quota_id;
2500:
2501: CURSOR c_rt_formula_csr (
2502: pe_quota_id cn_quotas.quota_id%TYPE,
2503: pe_rate_schedule_id cn_rt_quota_asgns.rate_schedule_id%TYPE
2504: )
2505: IS
2506: SELECT rtq.calc_formula_id
2507: FROM cn_rt_quota_asgns rtq

Line 2507: FROM cn_rt_quota_asgns rtq

2503: pe_rate_schedule_id cn_rt_quota_asgns.rate_schedule_id%TYPE
2504: )
2505: IS
2506: SELECT rtq.calc_formula_id
2507: FROM cn_rt_quota_asgns rtq
2508: WHERE rtq.quota_id = pe_quota_id AND rtq.rate_schedule_id = pe_rate_schedule_id;
2509:
2510: CURSOR c_formula_input_csr (
2511: pe_calc_formula_id cn_formula_inputs.calc_formula_id%TYPE

Line 2596: FROM cn_rt_quota_asgns rqa,

2592: CURSOR rt_quota_asgns_curs
2593: IS
2594: SELECT rqa.rate_schedule_id,
2595: rs.NAME
2596: FROM cn_rt_quota_asgns rqa,
2597: cn_rate_schedules rs
2598: WHERE rqa.quota_id = p_quota_id AND rqa.rate_schedule_id = rs.rate_schedule_id;
2599:
2600: CURSOR rules

Line 2722: FROM cn_rt_quota_asgns

2718: IF l_plan_element.quota_type_code IN ('FORMULA', 'EXTERNAL')
2719: THEN
2720: SELECT COUNT (1)
2721: INTO l_tmp
2722: FROM cn_rt_quota_asgns
2723: WHERE quota_id = p_quota_id;
2724:
2725: IF (l_tmp = 0)
2726: THEN