DBA Data[Home] [Help]

APPS.CN_CHK_PLAN_ELEMENT_PKG dependencies on CN_CALC_SQL_EXPS_PVT

Line 2775: nt cn_calc_sql_exps_pvt.num_tbl_type;

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);
2777: l_calc_sql_exp VARCHAR2 (4000);
2778: l_parent_start_date DATE;
2779: l_parent_end_date DATE;

Line 2786: cn_calc_sql_exps_pvt.get_dependent_plan_elts (p_api_version => 1.0,

2782: rs VARCHAR2 (50);
2783: mc NUMBER;
2784: md VARCHAR2 (50);
2785: BEGIN
2786: cn_calc_sql_exps_pvt.get_dependent_plan_elts (p_api_version => 1.0,
2787: p_node_type => 'F',
2788: p_node_id => x_calc_formula_id,
2789: x_plan_elt_id_tbl => nt,
2790: x_return_status => rs,