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 392: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(

388: -- Attach prefix to the Name Value
389: -- v_name_node_value_new := p_prefix || v_name_node_value;
390:
391: -- Call common utility package for name length check
392: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(
393: p_name => v_name_node_value,
394: p_org_id => p_org_id,
395: p_type => 'EXPRESSION',
396: p_prefix => p_prefix);

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

449: := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'EdgeType'),0)));
450: g_miss_calc_edges_tbl(i).parent_name
451: := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'ParentName'),0)));
452: -- Call common utility package for name length check
453: g_miss_calc_edges_tbl(i).parent_name := cn_plancopy_util_pvt.check_name_length(
454: p_name => g_miss_calc_edges_tbl(i).parent_name,
455: p_org_id => p_org_id,
456: p_type => 'EXPRESSION',
457: p_prefix => p_prefix);

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

462: IF g_miss_calc_edges_tbl(i).edge_type = 'FE' THEN
463: -- Storing old name of the formula in source system
464: l_formula_name_source := g_miss_calc_edges_tbl(i).child_name;
465: -- Call common utility package for name length check
466: g_miss_calc_edges_tbl(i).child_name := cn_plancopy_util_pvt.check_name_length(
467: p_name => g_miss_calc_edges_tbl(i).child_name,
468: p_org_id => p_org_id,
469: p_type => 'FORMULA',
470: p_prefix => p_prefix);

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

507: IF g_miss_calc_edges_tbl(i).edge_type = 'EE' THEN
508: -- Storing old name of the formula in source system
509: l_exp_name_source := g_miss_calc_edges_tbl(i).child_name;
510: -- Call common utility package for name length check
511: g_miss_calc_edges_tbl(i).child_name := cn_plancopy_util_pvt.check_name_length(
512: p_name => g_miss_calc_edges_tbl(i).child_name,
513: p_org_id => p_org_id,
514: p_type => 'EXPRESSION',
515: p_prefix => p_prefix);

Line 697: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(

693: -- Attach prefix to the Name Value
694: -- v_name_node_value_new := p_prefix || v_name_node_value;
695:
696: -- Call common utility package for name length check
697: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(
698: p_name => v_name_node_value,
699: p_org_id => p_org_id,
700: p_type => 'RATEDIMENSION',
701: p_prefix => p_prefix);

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

747: 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)));
748:
749: IF g_miss_rate_dim_exp_tbl(i).min_exp_name IS NOT NULL THEN
750: -- Call common utility package for name length check
751: g_miss_rate_dim_exp_tbl(i).min_exp_name := cn_plancopy_util_pvt.check_name_length(
752: p_name => g_miss_rate_dim_exp_tbl(i).min_exp_name,
753: p_org_id => p_org_id,
754: p_type => 'EXPRESSION',
755: p_prefix => p_prefix);

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

769: END IF;
770: END IF;
771: IF g_miss_rate_dim_exp_tbl(i).max_exp_name IS NOT NULL THEN
772: -- Call common utility package for name length check
773: g_miss_rate_dim_exp_tbl(i).max_exp_name := cn_plancopy_util_pvt.check_name_length(
774: p_name => g_miss_rate_dim_exp_tbl(i).max_exp_name,
775: p_org_id => p_org_id,
776: p_type => 'EXPRESSION',
777: p_prefix => p_prefix);

Line 887: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(

883: v_name_node_value := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(v_name_node,0)));
884:
885: -- Attach prefix to the Name Value
886: -- Call common utility package for name length check
887: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(
888: p_name => v_name_node_value,
889: p_org_id => p_org_id,
890: p_type => 'RATETABLE',
891: p_prefix => p_prefix);

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

929: -- Get the Rate Dim Tier Values
930: v_rate_sch_dims_tbl(i).rate_dim_name
931: := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'RateDimensionName'),0)));
932: -- Call common utility package for name length check
933: v_rate_sch_dims_tbl(i).rate_dim_name := cn_plancopy_util_pvt.check_name_length(
934: p_name => v_rate_sch_dims_tbl(i).rate_dim_name,
935: p_org_id => p_org_id,
936: p_type => 'RATEDIMENSION',
937: p_prefix => p_prefix);

Line 1089: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(

1085: -- Attach prefix to the Name Value
1086: -- v_name_node_value_new := p_prefix || v_name_node_value;
1087:
1088: -- Call common utility package for name length check
1089: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(
1090: p_name => v_name_node_value,
1091: p_org_id => p_org_id,
1092: p_type => 'FORMULA',
1093: p_prefix => p_prefix);

Line 1130: l_output_exp_name := cn_plancopy_util_pvt.check_name_length(

1126: IF l_output_exp_name IS NULL THEN
1127: l_sql_fail_count := 1;
1128: ELSE
1129: -- Call common utility package for name length check
1130: l_output_exp_name := cn_plancopy_util_pvt.check_name_length(
1131: p_name => l_output_exp_name,
1132: p_org_id => p_org_id,
1133: p_type => 'EXPRESSION',
1134: p_prefix => p_prefix);

Line 1152: l_f_output_exp_name := cn_plancopy_util_pvt.check_name_length(

1148: END IF;
1149:
1150: IF l_f_output_exp_name IS NOT NULL THEN
1151: -- Call common utility package for name length check
1152: l_f_output_exp_name := cn_plancopy_util_pvt.check_name_length(
1153: p_name => l_f_output_exp_name,
1154: p_org_id => p_org_id,
1155: p_type => 'EXPRESSION',
1156: p_prefix => p_prefix);

Line 1174: l_perf_measure_name := cn_plancopy_util_pvt.check_name_length(

1170: END IF;
1171:
1172: IF l_perf_measure_name IS NOT NULL THEN
1173: -- Call common utility package for name length check
1174: l_perf_measure_name := cn_plancopy_util_pvt.check_name_length(
1175: p_name => l_perf_measure_name,
1176: p_org_id => p_org_id,
1177: p_type => 'EXPRESSION',
1178: p_prefix => p_prefix);

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

1229: l_sql_fail_count := 1;
1230: EXIT;
1231: ELSE
1232: -- Call common utility package for name length check
1233: v_input_exp_tbl(i).calc_exp_name := cn_plancopy_util_pvt.check_name_length(
1234: p_name => v_input_exp_tbl(i).calc_exp_name,
1235: p_org_id => p_org_id,
1236: p_type => 'EXPRESSION',
1237: p_prefix => p_prefix);

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

1252: END IF;
1253:
1254: IF v_input_exp_tbl(i).f_calc_exp_name IS NOT NULL THEN
1255: -- Call common utility package for name length check
1256: v_input_exp_tbl(i).f_calc_exp_name := cn_plancopy_util_pvt.check_name_length(
1257: p_name => v_input_exp_tbl(i).f_calc_exp_name,
1258: p_org_id => p_org_id,
1259: p_type => 'EXPRESSION',
1260: p_prefix => p_prefix);

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

1308: l_sql_fail_count := 1;
1309: EXIT;
1310: ELSE
1311: -- Call common utility package for name length check
1312: v_rt_assign_tbl(i).rate_schedule_name := cn_plancopy_util_pvt.check_name_length(
1313: p_name => v_rt_assign_tbl(i).rate_schedule_name,
1314: p_org_id => p_org_id,
1315: p_type => 'RATETABLE',
1316: p_prefix => p_prefix);

Line 1492: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(

1488: -- Get the Plan Element Name Value
1489: v_name_node_value := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(v_name_node,0)));
1490: -- Attach prefix to the Name Value
1491: -- Call common utility package for name length check
1492: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(
1493: p_name => v_name_node_value,
1494: p_org_id => p_org_id,
1495: p_type => 'PLANELEMENT',
1496: p_prefix => p_prefix);

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

1601:
1602: -- Check for Formula Name in Target System.
1603: IF v_plan_element_rec.element_type = 'FORMULA' THEN
1604: -- Call common utility package for name length check
1605: v_plan_element_rec.calc_formula_name := cn_plancopy_util_pvt.check_name_length(
1606: p_name => v_plan_element_rec.calc_formula_name,
1607: p_org_id => p_org_id,
1608: p_type => 'FORMULA',
1609: p_prefix => p_prefix);

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

1977: := to_date(dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'EndDateOld'),0))),'YYYY-MM-DD');
1978: -- Other Attributes End
1979:
1980: -- Call common utility package for name length check
1981: v_rt_quota_asgns_tbl(i).rate_schedule_name := cn_plancopy_util_pvt.check_name_length(
1982: p_name => v_rt_quota_asgns_tbl(i).rate_schedule_name,
1983: p_org_id => p_org_id,
1984: p_type => 'RATETABLE',
1985: p_prefix => p_prefix);

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

1991:
1992: -- Call common utility package for name length check
1993: -- Only if quota type is 'FORMULA'
1994: IF v_plan_element_rec.element_type = 'FORMULA' THEN
1995: v_rt_quota_asgns_tbl(i).calc_formula_name := cn_plancopy_util_pvt.check_name_length(
1996: p_name => v_rt_quota_asgns_tbl(i).calc_formula_name,
1997: p_org_id => p_org_id,
1998: p_type => 'FORMULA',
1999: p_prefix => p_prefix);

Line 2248: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(

2244: -- Get the Compensation Plan Name Value
2245: v_name_node_value := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(v_name_node,0)));
2246: -- Attach prefix to the Name Value
2247: -- Call common utility package for name length check
2248: v_name_node_value_new := cn_plancopy_util_pvt.check_name_length(
2249: p_name => v_name_node_value,
2250: p_org_id => p_org_id,
2251: p_type => 'PLAN',
2252: p_prefix => p_prefix);

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

2350: 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)));
2351: 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)));
2352:
2353: -- Call common utility package for name length check
2354: v_quota_assign_tbl(i).name := cn_plancopy_util_pvt.check_name_length(
2355: p_name => v_quota_assign_tbl(i).name,
2356: p_org_id => p_org_id,
2357: p_type => 'PLANELEMENT',
2358: p_prefix => p_prefix);