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_SQL_EXPS

Line 164: v_expression_rec cn_calc_sql_exps%ROWTYPE;

160: p_object_count IN NUMBER,
161: x_import_status OUT NOCOPY VARCHAR2)IS
162:
163: -- Table Record Declaration
164: v_expression_rec cn_calc_sql_exps%ROWTYPE;
165: v_rate_dimension_rec cn_rate_dimensions%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;

Line 182: (min_exp_name cn_calc_sql_exps.name%TYPE,

178: v_period_quotas_tbl cn_plan_element_pub.period_quotas_rec_tbl_type := cn_plan_element_pub.g_miss_period_quotas_rec_tbl;
179: v_comp_plan_rec cn_comp_plan_pvt.comp_plan_rec_type;
180: v_quota_assign_tbl cn_quota_assign_pvt.quota_assign_tbl_type := cn_quota_assign_pvt.g_miss_quota_assign_rec_tb;
181: TYPE v_rate_dim_exp_rec IS RECORD
182: (min_exp_name cn_calc_sql_exps.name%TYPE,
183: max_exp_name cn_calc_sql_exps.name%TYPE);
184: TYPE v_rate_dim_exp_tbl IS TABLE OF v_rate_dim_exp_rec INDEX BY BINARY_INTEGER;
185: g_miss_rate_dim_exp_tbl v_rate_dim_exp_tbl;
186: TYPE v_calc_edges_rec IS RECORD(

Line 183: max_exp_name cn_calc_sql_exps.name%TYPE);

179: v_comp_plan_rec cn_comp_plan_pvt.comp_plan_rec_type;
180: v_quota_assign_tbl cn_quota_assign_pvt.quota_assign_tbl_type := cn_quota_assign_pvt.g_miss_quota_assign_rec_tb;
181: TYPE v_rate_dim_exp_rec IS RECORD
182: (min_exp_name cn_calc_sql_exps.name%TYPE,
183: max_exp_name cn_calc_sql_exps.name%TYPE);
184: TYPE v_rate_dim_exp_tbl IS TABLE OF v_rate_dim_exp_rec INDEX BY BINARY_INTEGER;
185: g_miss_rate_dim_exp_tbl v_rate_dim_exp_tbl;
186: TYPE v_calc_edges_rec IS RECORD(
187: calc_edge_id cn_calc_edges.calc_edge_id%TYPE := NULL,

Line 191: parent_name cn_calc_sql_exps.name%TYPE,

187: calc_edge_id cn_calc_edges.calc_edge_id%TYPE := NULL,
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

Line 223: l_calc_sql_exp_id cn_calc_sql_exps.calc_sql_exp_id%TYPE;

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;
227: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;

Line 224: l_output_exp_name cn_calc_sql_exps.name%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;
227: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
228: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;

Line 225: l_f_output_exp_name cn_calc_sql_exps.name%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;
227: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
228: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
229: l_pmt_group_code NUMBER;

Line 226: l_perf_measure_name cn_calc_sql_exps.name%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;
227: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
228: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
229: l_pmt_group_code NUMBER;
230: l_rev_class_name cn_revenue_classes.name%TYPE;

Line 250: l_parent_name cn_calc_sql_exps.name%TYPE;

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;
254: l_open NUMBER;

Line 294: l_exp_name_source cn_calc_sql_exps.name%TYPE;

290:
291: l_period_name cn_period_statuses.period_name%TYPE;
292: l_period_exist_count NUMBER;
293: l_period_end_date DATE;
294: l_exp_name_source cn_calc_sql_exps.name%TYPE;
295: l_period_id cn_period_statuses.period_id%TYPE;
296: --defined by Naren to fix bug 13606519
297:
298: l_quota_count NUMBER:=0;

Line 407: FROM cn_calc_sql_exps

403: p_prefix => p_prefix);
404:
405: -- Check if Expression already exists in the Target Instance
406: SELECT COUNT(name) INTO l_reuse_count
407: FROM cn_calc_sql_exps
408: WHERE name = v_name_node_value_new
409: AND org_id = p_org_id;
410:
411: --Additional condition to check the expressioin exist in the target is valid or not

Line 416: FROM cn_calc_sql_exps

412:
413: IF l_reuse_count>0 THEN
414:
415: SELECT status INTO v_expression_rec.status
416: FROM cn_calc_sql_exps
417: WHERE name=v_name_node_value_new
418: AND org_id=p_org_id;
419:
420: IF v_expression_rec.status <>'VALID' THEN

Line 545: FROM cn_calc_sql_exps

541: := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'ChildId'),0)));
542: -- Get Formula Information
543: IF g_miss_calc_edges_tbl(i).parent_name = v_expression_rec.name THEN
544: SELECT COUNT(name) INTO l_exp_name_count
545: FROM cn_calc_sql_exps
546: WHERE name = g_miss_calc_edges_tbl(i).child_name
547: AND org_id = p_org_id;
548: IF l_exp_name_count = 0 THEN
549: fnd_message.set_name ('CN' , 'CN_COPY_EXP_EXP_MISS');

Line 557: FROM cn_calc_sql_exps

553: l_sql_fail_count := 1;
554: EXIT;
555: ELSE
556: SELECT calc_sql_exp_id INTO g_miss_calc_edges_tbl(i).child_id
557: FROM cn_calc_sql_exps
558: WHERE name = g_miss_calc_edges_tbl(i).child_name
559: AND org_id = p_org_id;
560: END IF;
561: v_expression_rec.expression_disp := REPLACE(v_expression_rec.expression_disp,l_exp_name_source,g_miss_calc_edges_tbl(i).child_name);

Line 678: FROM cn_calc_sql_exps

674: l_calc_sql_exp_id := NULL;
675: x_object_version_number:=0;
676:
677: SELECT calc_sql_exp_id,object_version_number INTO l_calc_sql_exp_id, x_object_version_number
678: FROM cn_calc_sql_exps
679: WHERE name = v_name_node_value_new
680: AND org_id = p_org_id;
681:
682: CN_PLANCOPY_UTIL_PVT.update_existing_expression(

Line 735: cn_calc_sql_exps_pvt.create_expression(

731: --*********************************************************************
732: -- Import Expression
733: --*********************************************************************
734: l_calc_sql_exp_id := NULL;
735: cn_calc_sql_exps_pvt.create_expression(
736: p_api_version => p_api_version,
737: p_init_msg_list => p_init_msg_list,
738: p_commit => p_commit,
739: p_validation_level => p_validation_level,

Line 875: FROM cn_calc_sql_exps

871: p_org_id => p_org_id,
872: p_type => 'EXPRESSION',
873: p_prefix => p_prefix);
874: SELECT COUNT(name) INTO l_exp_name_count
875: FROM cn_calc_sql_exps
876: WHERE name = g_miss_rate_dim_exp_tbl(i).min_exp_name
877: AND org_id = p_org_id;
878:
879: IF l_exp_name_count = 0 THEN

Line 884: FROM cn_calc_sql_exps

880: l_sql_fail_count := 1;
881: EXIT;
882: ELSE
883: SELECT calc_sql_exp_id INTO v_rate_dim_tiers_tbl(i).min_exp_id
884: FROM cn_calc_sql_exps
885: WHERE name = g_miss_rate_dim_exp_tbl(i).min_exp_name
886: AND org_id = p_org_id;
887: END IF;
888: END IF;

Line 898: FROM cn_calc_sql_exps

894: p_type => 'EXPRESSION',
895: p_prefix => p_prefix);
896:
897: SELECT COUNT(name) INTO l_exp_name_count
898: FROM cn_calc_sql_exps
899: WHERE name = g_miss_rate_dim_exp_tbl(i).max_exp_name
900: AND org_id = p_org_id;
901: IF l_exp_name_count = 0 THEN
902: l_sql_fail_count := 1;

Line 906: FROM cn_calc_sql_exps

902: l_sql_fail_count := 1;
903: EXIT;
904: ELSE
905: SELECT calc_sql_exp_id INTO v_rate_dim_tiers_tbl(i).max_exp_id
906: FROM cn_calc_sql_exps
907: WHERE name = g_miss_rate_dim_exp_tbl(i).max_exp_name
908: AND org_id = p_org_id;
909: END IF;
910: END IF;

Line 1276: FROM cn_calc_sql_exps

1272: p_type => 'EXPRESSION',
1273: p_prefix => p_prefix);
1274:
1275: SELECT COUNT(name) INTO l_exp_name_count
1276: FROM cn_calc_sql_exps
1277: WHERE name = l_output_exp_name
1278: AND org_id = p_org_id;
1279:
1280: IF l_exp_name_count = 0 THEN

Line 1284: FROM cn_calc_sql_exps

1280: IF l_exp_name_count = 0 THEN
1281: l_sql_fail_count := 1;
1282: ELSE
1283: SELECT calc_sql_exp_id INTO v_formula_rec.output_exp_id
1284: FROM cn_calc_sql_exps
1285: WHERE name = l_output_exp_name
1286: AND org_id = p_org_id;
1287: END IF;
1288:

Line 1298: FROM cn_calc_sql_exps

1294: p_type => 'EXPRESSION',
1295: p_prefix => p_prefix);
1296:
1297: SELECT COUNT(name) INTO l_exp_name_count
1298: FROM cn_calc_sql_exps
1299: WHERE name = l_f_output_exp_name
1300: AND org_id = p_org_id;
1301: IF l_exp_name_count = 0 THEN
1302: l_sql_fail_count := 1;

Line 1305: FROM cn_calc_sql_exps

1301: IF l_exp_name_count = 0 THEN
1302: l_sql_fail_count := 1;
1303: ELSE
1304: SELECT calc_sql_exp_id INTO v_formula_rec.f_output_exp_id
1305: FROM cn_calc_sql_exps
1306: WHERE name = l_f_output_exp_name
1307: AND org_id = p_org_id;
1308: END IF;
1309: END IF;

Line 1320: FROM cn_calc_sql_exps

1316: p_type => 'EXPRESSION',
1317: p_prefix => p_prefix);
1318:
1319: SELECT COUNT(name) INTO l_exp_name_count
1320: FROM cn_calc_sql_exps
1321: WHERE name = l_perf_measure_name
1322: AND org_id = p_org_id;
1323:
1324: IF l_exp_name_count = 0 THEN

Line 1328: FROM cn_calc_sql_exps

1324: IF l_exp_name_count = 0 THEN
1325: l_sql_fail_count := 1;
1326: ELSE
1327: SELECT calc_sql_exp_id INTO v_formula_rec.perf_measure_id
1328: FROM cn_calc_sql_exps
1329: WHERE name = l_perf_measure_name
1330: AND org_id = p_org_id;
1331: END IF;
1332: END IF;

Line 1379: FROM cn_calc_sql_exps

1375: p_type => 'EXPRESSION',
1376: p_prefix => p_prefix);
1377:
1378: SELECT COUNT(name) INTO l_exp_name_count
1379: FROM cn_calc_sql_exps
1380: WHERE name = v_input_exp_tbl(i).calc_exp_name
1381: AND org_id = p_org_id;
1382: IF l_exp_name_count = 0 THEN
1383: l_sql_fail_count := 1;

Line 1387: FROM cn_calc_sql_exps

1383: l_sql_fail_count := 1;
1384: EXIT;
1385: ELSE
1386: SELECT calc_sql_exp_id INTO v_input_exp_tbl(i).calc_sql_exp_id
1387: FROM cn_calc_sql_exps
1388: WHERE name = v_input_exp_tbl(i).calc_exp_name
1389: AND org_id = p_org_id;
1390: END IF;
1391: END IF;

Line 1402: FROM cn_calc_sql_exps

1398: p_type => 'EXPRESSION',
1399: p_prefix => p_prefix);
1400:
1401: SELECT COUNT(name) INTO l_exp_name_count
1402: FROM cn_calc_sql_exps
1403: WHERE name = v_input_exp_tbl(i).f_calc_exp_name
1404: AND org_id = p_org_id;
1405:
1406: IF l_exp_name_count = 0 THEN

Line 1411: FROM cn_calc_sql_exps_all

1407: l_sql_fail_count := 1;
1408: EXIT;
1409: ELSE
1410: SELECT calc_sql_exp_id INTO v_input_exp_tbl(i).f_calc_sql_exp_id
1411: FROM cn_calc_sql_exps_all
1412: WHERE name = v_input_exp_tbl(i).f_calc_exp_name
1413: AND org_id = p_org_id;
1414: END IF;
1415: END IF;