APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on CN_RATE_DIMENSIONS

Line 165: v_rate_dimension_rec cn_rate_dimensions%ROWTYPE;

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;
169: v_rate_tiers_tbl cn_multi_rate_schedules_pvt.comm_tbl_type;

Line 166: v_rate_dim_tiers_tbl cn_rate_dimensions_pvt.tiers_tbl_type := cn_rate_dimensions_pvt.g_miss_tiers_tbl;

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;
169: v_rate_tiers_tbl cn_multi_rate_schedules_pvt.comm_tbl_type;
170: v_formula_rec cn_calc_formulas%ROWTYPE;

Line 219: l_rate_dimension_id cn_rate_dimensions.rate_dimension_id%TYPE;

215: v_node_sibling_Previous dbms_xmldom.DOMNode;
216: --Other Declaration
217: l_api_version NUMBER := 1.0;
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;

Line 823: FROM cn_rate_dimensions

819: p_prefix => p_prefix);
820:
821: -- Check if Rate Dimension already exists in the Target Instance
822: SELECT COUNT(name) INTO l_reuse_count
823: FROM cn_rate_dimensions
824: WHERE name = v_name_node_value_new
825: AND org_id = p_org_id;
826:
827: --If Rate Dimension exists then do not Insert, Else insert a new record.

Line 918: cn_rate_dimensions_pvt.create_dimension(

914: --*********************************************************************
915: -- Import Rate Dimension and Rate Dim Tiers
916: --*********************************************************************
917: l_rate_dimension_id := NULL;
918: cn_rate_dimensions_pvt.create_dimension(
919: p_api_version => p_api_version,
920: p_init_msg_list => p_init_msg_list,
921: p_commit => p_commit,
922: p_validation_level => p_validation_level,

Line 1060: FROM cn_rate_dimensions

1056: v_rate_sch_dims_tbl(i).rate_dim_sequence
1057: := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'RateDimSequence'),0)));
1058:
1059: SELECT COUNT(name) INTO l_rate_dim_name_count
1060: FROM cn_rate_dimensions
1061: WHERE name = v_rate_sch_dims_tbl(i).rate_dim_name
1062: AND org_id = p_org_id;
1063:
1064: IF l_rate_dim_name_count = 0 THEN

Line 1069: FROM cn_rate_dimensions

1065: l_sql_fail_count := 1;
1066: EXIT;
1067: ELSE
1068: SELECT rate_dimension_id INTO v_rate_sch_dims_tbl(i).rate_dimension_id
1069: FROM cn_rate_dimensions
1070: WHERE name = v_rate_sch_dims_tbl(i).rate_dim_name
1071: AND org_id = p_org_id;
1072: END IF;
1073: END LOOP;