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 505: FROM cn_calc_formulas

501:
502: -- Get Formula Information
503: IF g_miss_calc_edges_tbl(i).parent_name = v_expression_rec.name THEN
504: SELECT COUNT(name) INTO l_formula_name_count
505: FROM cn_calc_formulas
506: WHERE name = g_miss_calc_edges_tbl(i).child_name
507: AND org_id = p_org_id;
508: IF l_formula_name_count = 0 THEN
509: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_MISS');

Line 517: FROM cn_calc_formulas

513: l_sql_fail_count := 1;
514: EXIT;
515: ELSE
516: SELECT calc_formula_id INTO g_miss_calc_edges_tbl(i).child_id
517: FROM cn_calc_formulas
518: WHERE name = g_miss_calc_edges_tbl(i).child_name
519: AND org_id = p_org_id;
520: END IF;
521: l_formula_pkg_target := 'cn_formula_'||g_miss_calc_edges_tbl(i).child_id||'_'||p_org_id||'_pkg';

Line 1220: FROM cn_calc_formulas

1216: p_prefix => p_prefix);
1217:
1218: -- Check if Formula already exists in the Target Instance
1219: SELECT COUNT(name) INTO l_reuse_count
1220: FROM cn_calc_formulas
1221: WHERE name = v_name_node_value_new
1222: AND org_id = p_org_id;
1223:
1224: --If Formula exists then do not Insert otherwise insert a new Record.

Line 1228: FROM cn_calc_formulas

1224: --If Formula exists then do not Insert otherwise insert a new Record.
1225: IF l_reuse_count > 0 THEN
1226:
1227: SELECT formula_status INTO v_formula_rec.formula_status
1228: FROM cn_calc_formulas
1229: WHERE name=v_name_node_value_new
1230: AND org_id = p_org_id;
1231:
1232: IF v_formula_rec.formula_status = 'COMPLETE' THEN

Line 1511: cn_calc_formulas_pvt.create_formula(

1507: -- Import Formula
1508: --**********************************************
1509: l_calc_formula_id := Null;
1510: v_formula_rec.calc_formula_id := NULL;
1511: cn_calc_formulas_pvt.create_formula(
1512: p_api_version => p_api_version,
1513: p_init_msg_list => p_init_msg_list,
1514: p_commit => p_commit,
1515: p_validation_level => p_validation_level,

Line 1817: FROM cn_calc_formulas

1813: p_org_id => p_org_id,
1814: p_type => 'FORMULA',
1815: p_prefix => p_prefix);
1816: SELECT COUNT(name) INTO l_formula_name_count
1817: FROM cn_calc_formulas
1818: WHERE name = v_plan_element_rec.calc_formula_name
1819: AND org_id = p_org_id;
1820: IF l_formula_name_count = 0 THEN
1821: l_sql_fail_count := 1;

Line 2314: FROM cn_calc_formulas

2310: p_type => 'FORMULA',
2311: p_prefix => p_prefix);
2312: -- Check for Formula Name existence in Target System
2313: SELECT COUNT(name) INTO l_formula_name_count
2314: FROM cn_calc_formulas
2315: WHERE name = v_rt_quota_asgns_tbl(i).calc_formula_name
2316: AND org_id = p_org_id;
2317: END IF;
2318: -- If Rate Table does not exist, do not create Plan Element