DBA Data[Home] [Help]

APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on CN_QUOTA_ASSIGN_PVT

Line 180: v_quota_assign_tbl cn_quota_assign_pvt.quota_assign_tbl_type := cn_quota_assign_pvt.g_miss_quota_assign_rec_tb;

176: v_trx_factor_tbl cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl;
177: v_rt_quota_asgns_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type := cn_plan_element_pub.g_miss_rt_quota_asgns_rec_tbl;
178: v_period_quotas_tbl cn_plan_element_pub.period_quotas_rec_tbl_type := cn_plan_element_pub.g_miss_period_quotas_rec_tbl;
179: v_comp_plan_rec cn_comp_plan_pvt.comp_plan_rec_type;
180: v_quota_assign_tbl cn_quota_assign_pvt.quota_assign_tbl_type := cn_quota_assign_pvt.g_miss_quota_assign_rec_tb;
181: TYPE v_rate_dim_exp_rec IS RECORD
182: (min_exp_name cn_calc_sql_exps.name%TYPE,
183: max_exp_name cn_calc_sql_exps.name%TYPE);
184: TYPE v_rate_dim_exp_tbl IS TABLE OF v_rate_dim_exp_rec INDEX BY BINARY_INTEGER;

Line 2398: cn_quota_assign_pvt.create_quota_assign(

2394: l_quota_asgn_count := 0;
2395: FOR i IN v_quota_assign_tbl.FIRST..v_quota_assign_tbl.LAST LOOP
2396: IF (v_quota_assign_tbl(i).start_date <= NVL(v_comp_plan_rec.end_date,v_quota_assign_tbl(i).start_date) AND
2397: NVL(v_quota_assign_tbl(i).end_date,v_comp_plan_rec.start_date) >= v_comp_plan_rec.start_date) THEN
2398: cn_quota_assign_pvt.create_quota_assign(
2399: p_api_version => p_api_version,
2400: p_init_msg_list => p_init_msg_list,
2401: p_commit => p_commit,
2402: p_validation_level => p_validation_level,