APPS.CN_UPGRADE_PE_FORMULA_PKG dependencies on CN_CALC_FORMULAS_PVT

Line 347: l_input_tbl cn_calc_formulas_pvt.input_tbl_type;

343: l_status VARCHAR2 (30);
344: l_formula_status VARCHAR2 (30);
345: l_calc_formula_id NUMBER (15);
346: l_process_audit_id NUMBER;
347: l_input_tbl cn_calc_formulas_pvt.input_tbl_type;
348: BEGIN
349: l_input_tbl (1).calc_sql_exp_id := get_input ('discount_percentage/100', p_org_id);
350: l_input_tbl (1).rate_dim_sequence := 1;
351: cn_calc_formulas_pvt.create_formula (p_api_version => 1.0,

Line 351: cn_calc_formulas_pvt.create_formula (p_api_version => 1.0,

347: l_input_tbl cn_calc_formulas_pvt.input_tbl_type;
348: BEGIN
349: l_input_tbl (1).calc_sql_exp_id := get_input ('discount_percentage/100', p_org_id);
350: l_input_tbl (1).rate_dim_sequence := 1;
351: cn_calc_formulas_pvt.create_formula (p_api_version => 1.0,
352: p_generate_packages => fnd_api.g_false,
353: p_name => 'Discount Option Formula',
354: p_description => '',
355: p_formula_type => 'C',

Line 414: l_input_tbl cn_calc_formulas_pvt.input_tbl_type;

410: l_sql_select VARCHAR (500);
411: l_sql_from VARCHAR2 (500);
412: l_piped_sql_from VARCHAR2 (500);
413: l_exp_disp VARCHAR2 (500);
414: l_input_tbl cn_calc_formulas_pvt.input_tbl_type;
415: l_perf_measure_name VARCHAR2 (80);
416:
417: CURSOR l_quota_csr
418: IS

Line 672: cn_calc_formulas_pvt.create_formula (p_api_version => 1.0,

668: l_piped_sql_from,
669: l_output_exp_id);
670: l_input_tbl (1).calc_sql_exp_id := l_input_exp_id;
671: l_input_tbl (1).rate_dim_sequence := 1;
672: cn_calc_formulas_pvt.create_formula (p_api_version => 1.0,
673: p_generate_packages => fnd_api.g_false,
674: p_name => l_formula_name,
675: p_description => '',
676: p_formula_type => 'C',