eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on CN_CALC_FORMULAS

Line 170: v_formula_rec cn_calc_formulas%ROWTYPE;

166: v_rate_dim_tiers_tbl cn_rate_dimensions_pvt.tiers_tbl_type := cn_rate_dimensions_pvt.g_miss_tiers_tbl;
167: v_rate_table_rec cn_rate_schedules%ROWTYPE;
168: v_rate_sch_dims_tbl cn_multi_rate_schedules_pvt.dims_tbl_type := cn_multi_rate_schedules_pvt.g_miss_dims_tbl;
169: v_rate_tiers_tbl cn_multi_rate_schedules_pvt.comm_tbl_type;
170: v_formula_rec cn_calc_formulas%ROWTYPE;
171: v_input_exp_tbl cn_calc_formulas_pvt.input_tbl_type := cn_calc_formulas_pvt.g_miss_input_tbl;
172: v_rt_assign_tbl cn_calc_formulas_pvt.rt_assign_tbl_type := cn_calc_formulas_pvt.g_miss_rt_assign_tbl;
173: v_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
174: v_revenue_class_tbl cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl;

Line 171: v_input_exp_tbl cn_calc_formulas_pvt.input_tbl_type := cn_calc_formulas_pvt.g_miss_input_tbl;

167: v_rate_table_rec cn_rate_schedules%ROWTYPE;
168: v_rate_sch_dims_tbl cn_multi_rate_schedules_pvt.dims_tbl_type := cn_multi_rate_schedules_pvt.g_miss_dims_tbl;
169: v_rate_tiers_tbl cn_multi_rate_schedules_pvt.comm_tbl_type;
170: v_formula_rec cn_calc_formulas%ROWTYPE;
171: v_input_exp_tbl cn_calc_formulas_pvt.input_tbl_type := cn_calc_formulas_pvt.g_miss_input_tbl;
172: v_rt_assign_tbl cn_calc_formulas_pvt.rt_assign_tbl_type := cn_calc_formulas_pvt.g_miss_rt_assign_tbl;
173: v_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
174: v_revenue_class_tbl cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl;
175: v_rev_uplift_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl;

Line 172: v_rt_assign_tbl cn_calc_formulas_pvt.rt_assign_tbl_type := cn_calc_formulas_pvt.g_miss_rt_assign_tbl;

168: v_rate_sch_dims_tbl cn_multi_rate_schedules_pvt.dims_tbl_type := cn_multi_rate_schedules_pvt.g_miss_dims_tbl;
169: v_rate_tiers_tbl cn_multi_rate_schedules_pvt.comm_tbl_type;
170: v_formula_rec cn_calc_formulas%ROWTYPE;
171: v_input_exp_tbl cn_calc_formulas_pvt.input_tbl_type := cn_calc_formulas_pvt.g_miss_input_tbl;
172: v_rt_assign_tbl cn_calc_formulas_pvt.rt_assign_tbl_type := cn_calc_formulas_pvt.g_miss_rt_assign_tbl;
173: v_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
174: v_revenue_class_tbl cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl;
175: v_rev_uplift_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl;
176: v_trx_factor_tbl cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl;

Line 192: child_name cn_calc_formulas.name%TYPE);

188: edge_type cn_calc_edges.edge_type%TYPE,
189: parent_id cn_calc_edges.parent_id%TYPE,
190: child_id cn_calc_edges.child_id%TYPE,
191: parent_name cn_calc_sql_exps.name%TYPE,
192: child_name cn_calc_formulas.name%TYPE);
193: TYPE v_calc_edges_tbl IS TABLE OF v_calc_edges_rec INDEX BY BINARY_INTEGER;
194: g_miss_calc_edges_tbl v_calc_edges_tbl;
195: -- XML Declaration
196: v_doc dbms_xmldom.DOMDocument;

Line 222: l_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;

218: l_api_name CONSTANT VARCHAR2(30) := 'Parse_XML';
219: l_rate_dimension_id cn_rate_dimensions.rate_dimension_id%TYPE;
220: l_rate_dim_tier_id cn_rate_dim_tiers.rate_dim_tier_id%TYPE;
221: l_rate_schedule_id cn_rate_schedules.rate_schedule_id%TYPE;
222: l_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
223: l_calc_sql_exp_id cn_calc_sql_exps.calc_sql_exp_id%TYPE;
224: l_output_exp_name cn_calc_sql_exps.name%TYPE;
225: l_f_output_exp_name cn_calc_sql_exps.name%TYPE;
226: l_perf_measure_name cn_calc_sql_exps.name%TYPE;

Line 248: l_child_id cn_calc_formulas.calc_formula_id%TYPE;

244: l_quota_asgn_count NUMBER;
245: l_rev_class_least_count NUMBER;
246: l_rt_fm_notexist_count NUMBER;
247:
248: l_child_id cn_calc_formulas.calc_formula_id%TYPE;
249: l_child_name cn_calc_formulas.name%TYPE;
250: l_parent_name cn_calc_sql_exps.name%TYPE;
251: l_formula_pkg_source VARCHAR2(30);
252: l_formula_pkg_target VARCHAR2(30);

Line 249: l_child_name cn_calc_formulas.name%TYPE;

245: l_rev_class_least_count NUMBER;
246: l_rt_fm_notexist_count NUMBER;
247:
248: l_child_id cn_calc_formulas.calc_formula_id%TYPE;
249: l_child_name cn_calc_formulas.name%TYPE;
250: l_parent_name cn_calc_sql_exps.name%TYPE;
251: l_formula_pkg_source VARCHAR2(30);
252: l_formula_pkg_target VARCHAR2(30);
253: l_source_org_id NUMBER;

Line 264: l_formula_name_source cn_calc_formulas.name%TYPE;

260: l_open_p_sql NUMBER;
261: l_close_p_sql NUMBER;
262: l_quota_id cn_quotas.quota_id%TYPE;
263: l_failed_plan_name VARCHAR2(2000);
264: l_formula_name_source cn_calc_formulas.name%TYPE;
265: l_pe_source_name cn_quotas.name%TYPE;
266: l_pe_num NUMBER := 0;
267: l_pe_count NUMBER;
268: l_ee_count NUMBER;

Line 481: FROM cn_calc_formulas

477:
478: -- Get Formula Information
479: IF g_miss_calc_edges_tbl(i).parent_name = v_expression_rec.name THEN
480: SELECT COUNT(name) INTO l_formula_name_count
481: FROM cn_calc_formulas
482: WHERE name = g_miss_calc_edges_tbl(i).child_name
483: AND org_id = p_org_id;
484: IF l_formula_name_count = 0 THEN
485: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_MISS');

Line 493: FROM cn_calc_formulas

489: l_sql_fail_count := 1;
490: EXIT;
491: ELSE
492: SELECT calc_formula_id INTO g_miss_calc_edges_tbl(i).child_id
493: FROM cn_calc_formulas
494: WHERE name = g_miss_calc_edges_tbl(i).child_name
495: AND org_id = p_org_id;
496: END IF;
497: l_formula_pkg_target := 'cn_formula_'||g_miss_calc_edges_tbl(i).child_id||'_'||p_org_id||'_pkg';

Line 1097: FROM cn_calc_formulas

1093: p_prefix => p_prefix);
1094:
1095: -- Check if Formula already exists in the Target Instance
1096: SELECT COUNT(name) INTO l_reuse_count
1097: FROM cn_calc_formulas
1098: WHERE name = v_name_node_value_new
1099: AND org_id = p_org_id;
1100:
1101: --If Formula exists then do not Insert otherwise insert a new Record.

Line 1349: cn_calc_formulas_pvt.create_formula(

1345: -- Import Formula
1346: --**********************************************
1347: l_calc_formula_id := Null;
1348: v_formula_rec.calc_formula_id := NULL;
1349: cn_calc_formulas_pvt.create_formula(
1350: p_api_version => p_api_version,
1351: p_init_msg_list => p_init_msg_list,
1352: p_commit => p_commit,
1353: p_validation_level => p_validation_level,

Line 1611: FROM cn_calc_formulas

1607: p_org_id => p_org_id,
1608: p_type => 'FORMULA',
1609: p_prefix => p_prefix);
1610: SELECT COUNT(name) INTO l_formula_name_count
1611: FROM cn_calc_formulas
1612: WHERE name = v_plan_element_rec.calc_formula_name
1613: AND org_id = p_org_id;
1614: IF l_formula_name_count = 0 THEN
1615: l_sql_fail_count := 1;

Line 2002: FROM cn_calc_formulas

1998: p_type => 'FORMULA',
1999: p_prefix => p_prefix);
2000: -- Check for Formula Name existence in Target System
2001: SELECT COUNT(name) INTO l_formula_name_count
2002: FROM cn_calc_formulas
2003: WHERE name = v_rt_quota_asgns_tbl(i).calc_formula_name
2004: AND org_id = p_org_id;
2005: END IF;
2006: -- If Rate Table does not exist, do not create Plan Element