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_PLANCOPY_UTIL_PVT

Line 68: cn_plancopy_util_pvt.convert_blob_to_xmltype (

64:
65: -- Populating CLOB and XMLType Columns of cn_copy_requests_all
66: -- Plan Copy Import Request only populates the BLOB column.
67: -- Calling Common Utility Package for conversion to CLOB and XMLType
68: cn_plancopy_util_pvt.convert_blob_to_xmltype (
69: p_api_version => 1.0,
70: p_init_msg_list => FND_API.G_FALSE,
71: p_commit => FND_API.G_FALSE,
72: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 399: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(

395: -- Attach prefix to the Name Value
396: -- v_name_node_value_new := p_prefix || v_name_node_value;
397:
398: -- Call common utility package for name length check
399: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(
400: p_name => v_name_node_value,
401: p_org_id => p_org_id,
402: p_type => 'EXPRESSION',
403: p_prefix => p_prefix);

Line 477: g_miss_calc_edges_tbl(i).parent_name := cn_plancopy_util_pvt.check_name_length(

473: := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'EdgeType'),0)));
474: g_miss_calc_edges_tbl(i).parent_name
475: := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'ParentName'),0)));
476: -- Call common utility package for name length check
477: g_miss_calc_edges_tbl(i).parent_name := cn_plancopy_util_pvt.check_name_length(
478: p_name => g_miss_calc_edges_tbl(i).parent_name,
479: p_org_id => p_org_id,
480: p_type => 'EXPRESSION',
481: p_prefix => p_prefix);

Line 490: g_miss_calc_edges_tbl(i).child_name := cn_plancopy_util_pvt.check_name_length(

486: IF g_miss_calc_edges_tbl(i).edge_type = 'FE' THEN
487: -- Storing old name of the formula in source system
488: l_formula_name_source := g_miss_calc_edges_tbl(i).child_name;
489: -- Call common utility package for name length check
490: g_miss_calc_edges_tbl(i).child_name := cn_plancopy_util_pvt.check_name_length(
491: p_name => g_miss_calc_edges_tbl(i).child_name,
492: p_org_id => p_org_id,
493: p_type => 'FORMULA',
494: p_prefix => p_prefix);

Line 535: g_miss_calc_edges_tbl(i).child_name := cn_plancopy_util_pvt.check_name_length(

531: IF g_miss_calc_edges_tbl(i).edge_type = 'EE' THEN
532: -- Storing old name of the formula in source system
533: l_exp_name_source := g_miss_calc_edges_tbl(i).child_name;
534: -- Call common utility package for name length check
535: g_miss_calc_edges_tbl(i).child_name := cn_plancopy_util_pvt.check_name_length(
536: p_name => g_miss_calc_edges_tbl(i).child_name,
537: p_org_id => p_org_id,
538: p_type => 'EXPRESSION',
539: p_prefix => p_prefix);

Line 682: CN_PLANCOPY_UTIL_PVT.update_existing_expression(

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(
683: p_api_version => p_api_version
684: , p_init_msg_list => p_init_msg_list
685: , p_commit => p_commit
686: , p_validation_level => p_validation_level

Line 815: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(

811: -- Attach prefix to the Name Value
812: -- v_name_node_value_new := p_prefix || v_name_node_value;
813:
814: -- Call common utility package for name length check
815: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(
816: p_name => v_name_node_value,
817: p_org_id => p_org_id,
818: p_type => 'RATEDIMENSION',
819: p_prefix => p_prefix);

Line 869: g_miss_rate_dim_exp_tbl(i).min_exp_name := cn_plancopy_util_pvt.check_name_length(

865: g_miss_rate_dim_exp_tbl(i).max_exp_name := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'MaxExpName'),0)));
866:
867: IF g_miss_rate_dim_exp_tbl(i).min_exp_name IS NOT NULL THEN
868: -- Call common utility package for name length check
869: g_miss_rate_dim_exp_tbl(i).min_exp_name := cn_plancopy_util_pvt.check_name_length(
870: p_name => g_miss_rate_dim_exp_tbl(i).min_exp_name,
871: p_org_id => p_org_id,
872: p_type => 'EXPRESSION',
873: p_prefix => p_prefix);

Line 891: g_miss_rate_dim_exp_tbl(i).max_exp_name := cn_plancopy_util_pvt.check_name_length(

887: END IF;
888: END IF;
889: IF g_miss_rate_dim_exp_tbl(i).max_exp_name IS NOT NULL THEN
890: -- Call common utility package for name length check
891: g_miss_rate_dim_exp_tbl(i).max_exp_name := cn_plancopy_util_pvt.check_name_length(
892: p_name => g_miss_rate_dim_exp_tbl(i).max_exp_name,
893: p_org_id => p_org_id,
894: p_type => 'EXPRESSION',
895: p_prefix => p_prefix);

Line 1005: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(

1001: v_name_node_value := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(v_name_node,0)));
1002:
1003: -- Attach prefix to the Name Value
1004: -- Call common utility package for name length check
1005: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(
1006: p_name => v_name_node_value,
1007: p_org_id => p_org_id,
1008: p_type => 'RATETABLE',
1009: p_prefix => p_prefix);

Line 1051: v_rate_sch_dims_tbl(i).rate_dim_name := cn_plancopy_util_pvt.check_name_length(

1047: -- Get the Rate Dim Tier Values
1048: v_rate_sch_dims_tbl(i).rate_dim_name
1049: := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'RateDimensionName'),0)));
1050: -- Call common utility package for name length check
1051: v_rate_sch_dims_tbl(i).rate_dim_name := cn_plancopy_util_pvt.check_name_length(
1052: p_name => v_rate_sch_dims_tbl(i).rate_dim_name,
1053: p_org_id => p_org_id,
1054: p_type => 'RATEDIMENSION',
1055: p_prefix => p_prefix);

Line 1212: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(

1208: -- Attach prefix to the Name Value
1209: -- v_name_node_value_new := p_prefix || v_name_node_value;
1210:
1211: -- Call common utility package for name length check
1212: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(
1213: p_name => v_name_node_value,
1214: p_org_id => p_org_id,
1215: p_type => 'FORMULA',
1216: p_prefix => p_prefix);

Line 1269: l_output_exp_name := cn_plancopy_util_pvt.check_name_length(

1265: IF l_output_exp_name IS NULL THEN
1266: l_sql_fail_count := 1;
1267: ELSE
1268: -- Call common utility package for name length check
1269: l_output_exp_name := cn_plancopy_util_pvt.check_name_length(
1270: p_name => l_output_exp_name,
1271: p_org_id => p_org_id,
1272: p_type => 'EXPRESSION',
1273: p_prefix => p_prefix);

Line 1291: l_f_output_exp_name := cn_plancopy_util_pvt.check_name_length(

1287: END IF;
1288:
1289: IF l_f_output_exp_name IS NOT NULL THEN
1290: -- Call common utility package for name length check
1291: l_f_output_exp_name := cn_plancopy_util_pvt.check_name_length(
1292: p_name => l_f_output_exp_name,
1293: p_org_id => p_org_id,
1294: p_type => 'EXPRESSION',
1295: p_prefix => p_prefix);

Line 1313: l_perf_measure_name := cn_plancopy_util_pvt.check_name_length(

1309: END IF;
1310:
1311: IF l_perf_measure_name IS NOT NULL THEN
1312: -- Call common utility package for name length check
1313: l_perf_measure_name := cn_plancopy_util_pvt.check_name_length(
1314: p_name => l_perf_measure_name,
1315: p_org_id => p_org_id,
1316: p_type => 'EXPRESSION',
1317: p_prefix => p_prefix);

Line 1372: v_input_exp_tbl(i).calc_exp_name := cn_plancopy_util_pvt.check_name_length(

1368: l_sql_fail_count := 1;
1369: EXIT;
1370: ELSE
1371: -- Call common utility package for name length check
1372: v_input_exp_tbl(i).calc_exp_name := cn_plancopy_util_pvt.check_name_length(
1373: p_name => v_input_exp_tbl(i).calc_exp_name,
1374: p_org_id => p_org_id,
1375: p_type => 'EXPRESSION',
1376: p_prefix => p_prefix);

Line 1395: v_input_exp_tbl(i).f_calc_exp_name := cn_plancopy_util_pvt.check_name_length(

1391: END IF;
1392:
1393: IF v_input_exp_tbl(i).f_calc_exp_name IS NOT NULL THEN
1394: -- Call common utility package for name length check
1395: v_input_exp_tbl(i).f_calc_exp_name := cn_plancopy_util_pvt.check_name_length(
1396: p_name => v_input_exp_tbl(i).f_calc_exp_name,
1397: p_org_id => p_org_id,
1398: p_type => 'EXPRESSION',
1399: p_prefix => p_prefix);

Line 1474: v_rt_assign_tbl(i).rate_schedule_name := cn_plancopy_util_pvt.check_name_length(

1470: l_sql_fail_count := 1;
1471: EXIT;
1472: ELSE
1473: -- Call common utility package for name length check
1474: v_rt_assign_tbl(i).rate_schedule_name := cn_plancopy_util_pvt.check_name_length(
1475: p_name => v_rt_assign_tbl(i).rate_schedule_name,
1476: p_org_id => p_org_id,
1477: p_type => 'RATETABLE',
1478: p_prefix => p_prefix);

Line 1654: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(

1650: -- Get the Plan Element Name Value
1651: v_name_node_value := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(v_name_node,0)));
1652: -- Attach prefix to the Name Value
1653: -- Call common utility package for name length check
1654: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(
1655: p_name => v_name_node_value,
1656: p_org_id => p_org_id,
1657: p_type => 'PLANELEMENT',
1658: p_prefix => p_prefix);

Line 1811: v_plan_element_rec.calc_formula_name := cn_plancopy_util_pvt.check_name_length(

1807:
1808: -- Check for Formula Name in Target System.
1809: IF v_plan_element_rec.element_type = 'FORMULA' THEN
1810: -- Call common utility package for name length check
1811: v_plan_element_rec.calc_formula_name := cn_plancopy_util_pvt.check_name_length(
1812: p_name => v_plan_element_rec.calc_formula_name,
1813: p_org_id => p_org_id,
1814: p_type => 'FORMULA',
1815: p_prefix => p_prefix);

Line 2293: v_rt_quota_asgns_tbl(i).rate_schedule_name := cn_plancopy_util_pvt.check_name_length(

2289: := to_date(dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'EndDateOld'),0))),'YYYY-MM-DD');
2290: -- Other Attributes End
2291:
2292: -- Call common utility package for name length check
2293: v_rt_quota_asgns_tbl(i).rate_schedule_name := cn_plancopy_util_pvt.check_name_length(
2294: p_name => v_rt_quota_asgns_tbl(i).rate_schedule_name,
2295: p_org_id => p_org_id,
2296: p_type => 'RATETABLE',
2297: p_prefix => p_prefix);

Line 2307: v_rt_quota_asgns_tbl(i).calc_formula_name := cn_plancopy_util_pvt.check_name_length(

2303:
2304: -- Call common utility package for name length check
2305: -- Only if quota type is 'FORMULA'
2306: IF v_plan_element_rec.element_type = 'FORMULA' THEN
2307: v_rt_quota_asgns_tbl(i).calc_formula_name := cn_plancopy_util_pvt.check_name_length(
2308: p_name => v_rt_quota_asgns_tbl(i).calc_formula_name,
2309: p_org_id => p_org_id,
2310: p_type => 'FORMULA',
2311: p_prefix => p_prefix);

Line 2605: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(

2601: -- Get the Compensation Plan Name Value
2602: v_name_node_value := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(v_name_node,0)));
2603: -- Attach prefix to the Name Value
2604: -- Call common utility package for name length check
2605: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(
2606: p_name => v_name_node_value,
2607: p_org_id => p_org_id,
2608: p_type => 'PLAN',
2609: p_prefix => p_prefix);

Line 2733: v_quota_assign_tbl(i).name := cn_plancopy_util_pvt.check_name_length(

2729: v_quota_assign_tbl(i).description := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'Description'),0)));
2730: v_quota_assign_tbl(i).quota_sequence := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'QuotaSequence'),0)));
2731:
2732: -- Call common utility package for name length check
2733: v_quota_assign_tbl(i).name := cn_plancopy_util_pvt.check_name_length(
2734: p_name => v_quota_assign_tbl(i).name,
2735: p_org_id => p_org_id,
2736: p_type => 'PLANELEMENT',
2737: p_prefix => p_prefix);