APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on CN_RATE_SCHEDULES

Line 167: v_rate_table_rec cn_rate_schedules%ROWTYPE;

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;
171: v_input_exp_tbl cn_calc_formulas_pvt.input_tbl_type := cn_calc_formulas_pvt.g_miss_input_tbl;

Line 221: l_rate_schedule_id cn_rate_schedules.rate_schedule_id%TYPE;

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;
224: l_output_exp_name cn_calc_sql_exps.name%TYPE;
225: l_f_output_exp_name cn_calc_sql_exps.name%TYPE;

Line 1013: FROM cn_rate_schedules

1009: p_prefix => p_prefix);
1010:
1011: -- Check if Rate Table already exists in the Target Instance
1012: SELECT COUNT(name) INTO l_reuse_count
1013: FROM cn_rate_schedules
1014: WHERE name = v_name_node_value_new
1015: AND org_id = p_org_id;
1016:
1017: --If Rate Table exists then do not Insert otherwise insert a new Record.

Line 1481: FROM cn_rate_schedules

1477: p_type => 'RATETABLE',
1478: p_prefix => p_prefix);
1479:
1480: SELECT COUNT(name) INTO l_rate_schedule_name_count
1481: FROM cn_rate_schedules
1482: WHERE name = v_rt_assign_tbl(i).rate_schedule_name
1483: AND org_id = p_org_id;
1484:
1485: IF l_rate_schedule_name_count = 0 THEN

Line 1490: FROM cn_rate_schedules

1486: l_sql_fail_count := 1;
1487: EXIT;
1488: ELSE
1489: SELECT rate_schedule_id INTO v_rt_assign_tbl(i).rate_schedule_id
1490: FROM cn_rate_schedules
1491: WHERE name = v_rt_assign_tbl(i).rate_schedule_name
1492: AND org_id = p_org_id;
1493: END IF;
1494: END IF;

Line 2300: FROM cn_rate_schedules

2296: p_type => 'RATETABLE',
2297: p_prefix => p_prefix);
2298: -- Check for Rate Table Name existence in Target System
2299: SELECT COUNT(name) INTO l_rate_schedule_name_count
2300: FROM cn_rate_schedules
2301: WHERE name = v_rt_quota_asgns_tbl(i).rate_schedule_name
2302: AND org_id = p_org_id;
2303:
2304: -- Call common utility package for name length check