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 2777: cn_quota_assign_pvt.create_quota_assign(

2773: l_quota_asgn_count := 0;
2774: FOR i IN v_quota_assign_tbl.FIRST..v_quota_assign_tbl.LAST LOOP
2775: IF (v_quota_assign_tbl(i).start_date <= NVL(v_comp_plan_rec.end_date,v_quota_assign_tbl(i).start_date) AND
2776: NVL(v_quota_assign_tbl(i).end_date,v_comp_plan_rec.start_date) >= v_comp_plan_rec.start_date) THEN
2777: cn_quota_assign_pvt.create_quota_assign(
2778: p_api_version => p_api_version,
2779: p_init_msg_list => p_init_msg_list,
2780: p_commit => p_commit,
2781: p_validation_level => p_validation_level,