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 705: FROM cn_rate_dimensions

701: p_prefix => p_prefix);
702:
703: -- Check if Rate Dimension already exists in the Target Instance
704: SELECT COUNT(name) INTO l_reuse_count
705: FROM cn_rate_dimensions
706: WHERE name = v_name_node_value_new
707: AND org_id = p_org_id;
708:
709: --If Rate Dimension exists then do not Insert, Else insert a new record.

Line 800: cn_rate_dimensions_pvt.create_dimension(

796: --*********************************************************************
797: -- Import Rate Dimension and Rate Dim Tiers
798: --*********************************************************************
799: l_rate_dimension_id := NULL;
800: cn_rate_dimensions_pvt.create_dimension(
801: p_api_version => p_api_version,
802: p_init_msg_list => p_init_msg_list,
803: p_commit => p_commit,
804: p_validation_level => p_validation_level,

Line 942: FROM cn_rate_dimensions

938: v_rate_sch_dims_tbl(i).rate_dim_sequence
939: := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'RateDimSequence'),0)));
940:
941: SELECT COUNT(name) INTO l_rate_dim_name_count
942: FROM cn_rate_dimensions
943: WHERE name = v_rate_sch_dims_tbl(i).rate_dim_name
944: AND org_id = p_org_id;
945:
946: IF l_rate_dim_name_count = 0 THEN

Line 951: FROM cn_rate_dimensions

947: l_sql_fail_count := 1;
948: EXIT;
949: ELSE
950: SELECT rate_dimension_id INTO v_rate_sch_dims_tbl(i).rate_dimension_id
951: FROM cn_rate_dimensions
952: WHERE name = v_rate_sch_dims_tbl(i).rate_dim_name
953: AND org_id = p_org_id;
954: END IF;
955: END LOOP;