DBA Data[Home] [Help]

APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on CN_MULTI_RATE_SCHEDULES_PVT

Line 168: v_rate_sch_dims_tbl cn_multi_rate_schedules_pvt.dims_tbl_type := cn_multi_rate_schedules_pvt.g_miss_dims_tbl;

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;
172: v_rt_assign_tbl cn_calc_formulas_pvt.rt_assign_tbl_type := cn_calc_formulas_pvt.g_miss_rt_assign_tbl;

Line 169: v_rate_tiers_tbl cn_multi_rate_schedules_pvt.comm_tbl_type;

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;
172: v_rt_assign_tbl cn_calc_formulas_pvt.rt_assign_tbl_type := cn_calc_formulas_pvt.g_miss_rt_assign_tbl;
173: v_plan_element_rec cn_plan_element_pub.plan_element_rec_type;

Line 1116: cn_multi_rate_schedules_pvt.create_schedule(

1112: --*********************************************************************
1113: -- Import Rate Table - Rate Schedule
1114: --*********************************************************************
1115: l_rate_schedule_id := NULL;
1116: cn_multi_rate_schedules_pvt.create_schedule(
1117: p_api_version => p_api_version,
1118: p_init_msg_list => p_init_msg_list,
1119: p_commit => p_commit,
1120: p_validation_level => p_validation_level,

Line 1136: cn_multi_rate_schedules_pvt.update_rate(

1132: -- Import Rate Tiers
1133: --*********************************************************************
1134: IF (v_rate_tiers_tbl.COUNT > 0) THEN
1135: FOR i IN v_rate_tiers_tbl.FIRST..v_rate_tiers_tbl.LAST LOOP
1136: cn_multi_rate_schedules_pvt.update_rate(
1137: p_rate_schedule_id => l_rate_schedule_id,
1138: p_rate_sequence => v_rate_tiers_tbl(i).p_rate_sequence,
1139: p_commission_amount => v_rate_tiers_tbl(i).p_commission_amount,
1140: p_object_version_number => x_object_version_number,