DBA Data[Home] [Help]

APPS.CN_CALC_FORMULAS_PVT dependencies on CN_CALC_SQL_EXPS_PVT

Line 614: l_plan_elt_tbl CN_CALC_SQL_EXPS_PVT.NUM_TBL_TYPE;

610: l_update_count NUMBER := 0;
611: l_srp_prd_quota_ext_id cn_srp_period_quotas_ext.srp_period_quota_ext_id%TYPE;
612: l_num_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
613: l_count_formula_input NUMBER := 0;
614: l_plan_elt_tbl CN_CALC_SQL_EXPS_PVT.NUM_TBL_TYPE;
615:
616: /* Start - R12 Notes History */
617: l_formula_name VARCHAR2(30);
618: l_old_formula_name VARCHAR2(30);

Line 1366: cn_calc_sql_exps_pvt.get_dependent_plan_elts

1362: check_modeling(p_calc_formula_id, p_cumulative_flag, p_output_exp_id, p_f_output_exp_id);
1363: end if;
1364:
1365: -- make sure this formula wouldn't be involved in a cycle
1366: cn_calc_sql_exps_pvt.get_dependent_plan_elts
1367: (p_api_version => 1.0,
1368: p_node_type => 'F',
1369: p_node_id => p_calc_formula_id,
1370: x_plan_elt_id_tbl => l_plan_elt_tbl,