[Home] [Help]
1: PACKAGE BODY cn_plan_element_pvt AS
2: /*$Header: cnvpeb.pls 120.24 2007/11/14 15:40:42 hanaraya ship $*/
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_PLAN_ELEMENT_PVT';
4:
5: -- Returns a plan element record type given a quota_id
1: PACKAGE BODY cn_plan_element_pvt AS
2: /*$Header: cnvpeb.pls 120.24 2007/11/14 15:40:42 hanaraya ship $*/
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_PLAN_ELEMENT_PVT';
4:
5: -- Returns a plan element record type given a quota_id
6: FUNCTION get_plan_element (
7: p_quota_id NUMBER
723: IF p_pe_rec.calc_formula_id IS NOT NULL AND NVL (p_pe_rec_old.calc_formula_id, 0) <> NVL (p_pe_rec.calc_formula_id, 0)
724: THEN
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;
1075: END IF;
1076: END IF;
1077:
1078: -- verify that the columns below are valid when not new
1079: IF p_plan_element.quota_status = cn_plan_element_pvt.g_new_status
1080: THEN
1081: RETURN;
1082: END IF;
1083:
1492: -- Record inserted successfully
1493: -- insert the periods given that we always have a start and end date
1494: cn_period_quotas_pkg.distribute_target (p_plan_element.quota_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;
2851: END IF;
2852:
2853: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2854: END validate_plan_element;
2855: END cn_plan_element_pvt;