APPS.CN_CHK_PLAN_ELEMENT_PKG dependencies on CN_CALC_FORMULAS

Line 2522: RETURN cn_calc_formulas.NAME%TYPE

2518: --| ---------------------------------------------------------------------+
2519: FUNCTION get_calc_formula_name (
2520: p_calc_formula_id NUMBER
2521: )
2522: RETURN cn_calc_formulas.NAME%TYPE
2523: IS
2524: l_cf_name cn_calc_formulas.NAME%TYPE;
2525: BEGIN
2526: SELECT NAME

Line 2524: l_cf_name cn_calc_formulas.NAME%TYPE;

2520: p_calc_formula_id NUMBER
2521: )
2522: RETURN cn_calc_formulas.NAME%TYPE
2523: IS
2524: l_cf_name cn_calc_formulas.NAME%TYPE;
2525: BEGIN
2526: SELECT NAME
2527: INTO l_cf_name
2528: FROM cn_calc_formulas

Line 2528: FROM cn_calc_formulas

2524: l_cf_name cn_calc_formulas.NAME%TYPE;
2525: BEGIN
2526: SELECT NAME
2527: INTO l_cf_name
2528: FROM cn_calc_formulas
2529: WHERE calc_formula_id = p_calc_formula_id;
2530:
2531: RETURN l_cf_name;
2532: EXCEPTION

Line 2545: RETURN cn_calc_formulas.calc_formula_id%TYPE

2541: FUNCTION get_calc_formula_id (
2542: p_calc_formula_name VARCHAR2,
2543: p_org_id NUMBER
2544: )
2545: RETURN cn_calc_formulas.calc_formula_id%TYPE
2546: IS
2547: l_cf_id cn_calc_formulas.calc_formula_id%TYPE;
2548: BEGIN
2549: SELECT calc_formula_id

Line 2547: l_cf_id cn_calc_formulas.calc_formula_id%TYPE;

2543: p_org_id NUMBER
2544: )
2545: RETURN cn_calc_formulas.calc_formula_id%TYPE
2546: IS
2547: l_cf_id cn_calc_formulas.calc_formula_id%TYPE;
2548: BEGIN
2549: SELECT calc_formula_id
2550: INTO l_cf_id
2551: FROM cn_calc_formulas

Line 2551: FROM cn_calc_formulas

2547: l_cf_id cn_calc_formulas.calc_formula_id%TYPE;
2548: BEGIN
2549: SELECT calc_formula_id
2550: INTO l_cf_id
2551: FROM cn_calc_formulas
2552: WHERE NAME = p_calc_formula_name and org_id = p_org_id;
2553:
2554: RETURN l_cf_id;
2555: EXCEPTION

Line 2771: l_parent_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;

2767: x_parent_start_date IN DATE,
2768: x_parent_end_date IN DATE
2769: )
2770: IS
2771: l_parent_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
2772: l_child_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
2773: parent_quota_id NUMBER;
2774: child_quota_id NUMBER;
2775: nt cn_calc_sql_exps_pvt.num_tbl_type;

Line 2772: l_child_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;

2768: x_parent_end_date IN DATE
2769: )
2770: IS
2771: l_parent_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
2772: l_child_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
2773: parent_quota_id NUMBER;
2774: child_quota_id NUMBER;
2775: nt cn_calc_sql_exps_pvt.num_tbl_type;
2776: new_ss VARCHAR2 (4000);

Line 2863: l_formula_type cn_calc_formulas.formula_type%TYPE;

2859: IS
2860: l_loading_status VARCHAR2 (100);
2861: x_return_status VARCHAR2 (100);
2862: x_loading_status VARCHAR2 (100);
2863: l_formula_type cn_calc_formulas.formula_type%TYPE;
2864: l_api_name VARCHAR2 (100) := 'validate_formula';
2865: l_calc_name cn_calc_formulas.NAME%TYPE;
2866: BEGIN
2867:

Line 2865: l_calc_name cn_calc_formulas.NAME%TYPE;

2861: x_return_status VARCHAR2 (100);
2862: x_loading_status VARCHAR2 (100);
2863: l_formula_type cn_calc_formulas.formula_type%TYPE;
2864: l_api_name VARCHAR2 (100) := 'validate_formula';
2865: l_calc_name cn_calc_formulas.NAME%TYPE;
2866: BEGIN
2867:
2868: -- Validate the Quota Type with the Respective Column
2869: -- Check if the quota type is formula then the formula name must be not null

Line 2877: FROM cn_calc_formulas

2873:
2874: BEGIN
2875: SELECT NAME
2876: INTO l_calc_name
2877: FROM cn_calc_formulas
2878: WHERE calc_formula_id = p_plan_element.calc_formula_id;
2879: EXCEPTION
2880: WHEN NO_DATA_FOUND
2881: THEN

Line 2941: FROM cn_calc_formulas

2937: THEN
2938: BEGIN
2939: SELECT formula_type
2940: INTO l_formula_type
2941: FROM cn_calc_formulas
2942: WHERE calc_formula_id = p_plan_element.calc_formula_id;
2943: EXCEPTION
2944: WHEN NO_DATA_FOUND
2945: THEN