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:
296: TYPE v_pe_exp_rec IS RECORD
297: (old_pe_name cn_quotas.name%TYPE,
298: new_pe_name cn_quotas.name%TYPE,

Line 400: FROM cn_calc_sql_exps

396: p_prefix => p_prefix);
397:
398: -- Check if Expression already exists in the Target Instance
399: SELECT COUNT(name) INTO l_reuse_count
400: FROM cn_calc_sql_exps
401: WHERE name = v_name_node_value_new
402: AND org_id = p_org_id;
403:
404: --If Expression exists then do not Insert otherwise insert a new Record.

Line 521: FROM cn_calc_sql_exps

517: := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'ChildId'),0)));
518: -- Get Formula Information
519: IF g_miss_calc_edges_tbl(i).parent_name = v_expression_rec.name THEN
520: SELECT COUNT(name) INTO l_exp_name_count
521: FROM cn_calc_sql_exps
522: WHERE name = g_miss_calc_edges_tbl(i).child_name
523: AND org_id = p_org_id;
524: IF l_exp_name_count = 0 THEN
525: fnd_message.set_name ('CN' , 'CN_COPY_EXP_EXP_MISS');

Line 533: FROM cn_calc_sql_exps

529: l_sql_fail_count := 1;
530: EXIT;
531: ELSE
532: SELECT calc_sql_exp_id INTO g_miss_calc_edges_tbl(i).child_id
533: FROM cn_calc_sql_exps
534: WHERE name = g_miss_calc_edges_tbl(i).child_name
535: AND org_id = p_org_id;
536: END IF;
537: v_expression_rec.expression_disp := REPLACE(v_expression_rec.expression_disp,l_exp_name_source,g_miss_calc_edges_tbl(i).child_name);

Line 621: cn_calc_sql_exps_pvt.create_expression(

617: --*********************************************************************
618: -- Import Expression
619: --*********************************************************************
620: l_calc_sql_exp_id := NULL;
621: cn_calc_sql_exps_pvt.create_expression(
622: p_api_version => p_api_version,
623: p_init_msg_list => p_init_msg_list,
624: p_commit => p_commit,
625: p_validation_level => p_validation_level,

Line 757: FROM cn_calc_sql_exps

753: p_org_id => p_org_id,
754: p_type => 'EXPRESSION',
755: p_prefix => p_prefix);
756: SELECT COUNT(name) INTO l_exp_name_count
757: FROM cn_calc_sql_exps
758: WHERE name = g_miss_rate_dim_exp_tbl(i).min_exp_name
759: AND org_id = p_org_id;
760:
761: IF l_exp_name_count = 0 THEN

Line 766: FROM cn_calc_sql_exps

762: l_sql_fail_count := 1;
763: EXIT;
764: ELSE
765: SELECT calc_sql_exp_id INTO v_rate_dim_tiers_tbl(i).min_exp_id
766: FROM cn_calc_sql_exps
767: WHERE name = g_miss_rate_dim_exp_tbl(i).min_exp_name
768: AND org_id = p_org_id;
769: END IF;
770: END IF;

Line 780: FROM cn_calc_sql_exps

776: p_type => 'EXPRESSION',
777: p_prefix => p_prefix);
778:
779: SELECT COUNT(name) INTO l_exp_name_count
780: FROM cn_calc_sql_exps
781: WHERE name = g_miss_rate_dim_exp_tbl(i).max_exp_name
782: AND org_id = p_org_id;
783: IF l_exp_name_count = 0 THEN
784: l_sql_fail_count := 1;

Line 788: FROM cn_calc_sql_exps

784: l_sql_fail_count := 1;
785: EXIT;
786: ELSE
787: SELECT calc_sql_exp_id INTO v_rate_dim_tiers_tbl(i).max_exp_id
788: FROM cn_calc_sql_exps
789: WHERE name = g_miss_rate_dim_exp_tbl(i).max_exp_name
790: AND org_id = p_org_id;
791: END IF;
792: END IF;

Line 1137: FROM cn_calc_sql_exps

1133: p_type => 'EXPRESSION',
1134: p_prefix => p_prefix);
1135:
1136: SELECT COUNT(name) INTO l_exp_name_count
1137: FROM cn_calc_sql_exps
1138: WHERE name = l_output_exp_name
1139: AND org_id = p_org_id;
1140:
1141: IF l_exp_name_count = 0 THEN

Line 1145: FROM cn_calc_sql_exps

1141: IF l_exp_name_count = 0 THEN
1142: l_sql_fail_count := 1;
1143: ELSE
1144: SELECT calc_sql_exp_id INTO v_formula_rec.output_exp_id
1145: FROM cn_calc_sql_exps
1146: WHERE name = l_output_exp_name
1147: AND org_id = p_org_id;
1148: END IF;
1149:

Line 1159: FROM cn_calc_sql_exps

1155: p_type => 'EXPRESSION',
1156: p_prefix => p_prefix);
1157:
1158: SELECT COUNT(name) INTO l_exp_name_count
1159: FROM cn_calc_sql_exps
1160: WHERE name = l_f_output_exp_name
1161: AND org_id = p_org_id;
1162: IF l_exp_name_count = 0 THEN
1163: l_sql_fail_count := 1;

Line 1166: FROM cn_calc_sql_exps

1162: IF l_exp_name_count = 0 THEN
1163: l_sql_fail_count := 1;
1164: ELSE
1165: SELECT calc_sql_exp_id INTO v_formula_rec.f_output_exp_id
1166: FROM cn_calc_sql_exps
1167: WHERE name = l_f_output_exp_name
1168: AND org_id = p_org_id;
1169: END IF;
1170: END IF;

Line 1181: FROM cn_calc_sql_exps

1177: p_type => 'EXPRESSION',
1178: p_prefix => p_prefix);
1179:
1180: SELECT COUNT(name) INTO l_exp_name_count
1181: FROM cn_calc_sql_exps
1182: WHERE name = l_perf_measure_name
1183: AND org_id = p_org_id;
1184:
1185: IF l_exp_name_count = 0 THEN

Line 1189: FROM cn_calc_sql_exps

1185: IF l_exp_name_count = 0 THEN
1186: l_sql_fail_count := 1;
1187: ELSE
1188: SELECT calc_sql_exp_id INTO v_formula_rec.perf_measure_id
1189: FROM cn_calc_sql_exps
1190: WHERE name = l_perf_measure_name
1191: AND org_id = p_org_id;
1192: END IF;
1193: END IF;

Line 1240: FROM cn_calc_sql_exps

1236: p_type => 'EXPRESSION',
1237: p_prefix => p_prefix);
1238:
1239: SELECT COUNT(name) INTO l_exp_name_count
1240: FROM cn_calc_sql_exps
1241: WHERE name = v_input_exp_tbl(i).calc_exp_name
1242: AND org_id = p_org_id;
1243: IF l_exp_name_count = 0 THEN
1244: l_sql_fail_count := 1;

Line 1248: FROM cn_calc_sql_exps

1244: l_sql_fail_count := 1;
1245: EXIT;
1246: ELSE
1247: SELECT calc_sql_exp_id INTO v_input_exp_tbl(i).calc_sql_exp_id
1248: FROM cn_calc_sql_exps
1249: WHERE name = v_input_exp_tbl(i).calc_exp_name
1250: AND org_id = p_org_id;
1251: END IF;
1252: END IF;

Line 1263: FROM cn_calc_sql_exps

1259: p_type => 'EXPRESSION',
1260: p_prefix => p_prefix);
1261:
1262: SELECT COUNT(name) INTO l_exp_name_count
1263: FROM cn_calc_sql_exps
1264: WHERE name = v_input_exp_tbl(i).f_calc_exp_name
1265: AND org_id = p_org_id;
1266:
1267: IF l_exp_name_count = 0 THEN

Line 1272: FROM cn_calc_sql_exps_all

1268: l_sql_fail_count := 1;
1269: EXIT;
1270: ELSE
1271: SELECT calc_sql_exp_id INTO v_input_exp_tbl(i).f_calc_sql_exp_id
1272: FROM cn_calc_sql_exps_all
1273: WHERE name = v_input_exp_tbl(i).f_calc_exp_name
1274: AND org_id = p_org_id;
1275: END IF;
1276: END IF;