[Home] [Help]
2032: l_p_plan_element_rec plan_element_rec_type;
2033: l_p_revenue_class_rec_tbl revenue_class_rec_tbl_type;
2034: l_p_rev_uplift_rec_tbl rev_uplift_rec_tbl_type;
2035:
2036: l_p_rev_uplift_rec_tbl1 cn_quota_rule_uplift_pvt.quota_rule_uplift_tbl_type;
2037:
2038: l_p_trx_factor_rec_tbl trx_factor_rec_tbl_type;
2039: l_p_period_quotas_rec_tbl period_quotas_rec_tbl_type;
2040: l_p_rt_quota_asgns_rec_tbl rt_quota_asgns_rec_tbl_type;
2513: x_return_status => x_return_status,
2514: x_msg_count => x_msg_count,
2515: x_msg_data => x_msg_data,
2516: p_quota_name => l_p_plan_element_rec.NAME,
2517: p_rev_uplift_rec_tbl => l_p_rev_uplift_rec_tbl1,--cn_quota_rule_uplift_pvt.quota_rule_uplift_tbl_type
2518: x_loading_status => x_loading_status
2519: );
2520:
2521: -- Raise an Error if the Status is not success
2778: l_p_quota_name_old VARCHAR2 (80);
2779: l_p_revenue_class_rec_tbl revenue_class_rec_tbl_type;
2780: l_p_rev_uplift_rec_tbl rev_uplift_rec_tbl_type;
2781:
2782: l_p_rev_uplift_rec_tbl1 cn_quota_rule_uplift_pvt.quota_rule_uplift_tbl_type;
2783:
2784: l_p_trx_factor_rec_tbl trx_factor_rec_tbl_type;
2785: l_p_period_quotas_rec_tbl period_quotas_rec_tbl_type;
2786: l_p_rt_quota_asgns_rec_tbl rt_quota_asgns_rec_tbl_type;
3759: l_p_quota_name cn_quotas.NAME%TYPE;
3760: l_p_revenue_class_rec_tbl revenue_class_rec_tbl_type;
3761: l_p_rev_uplift_rec_tbl rev_uplift_rec_tbl_type;
3762:
3763: l_p_rev_uplift_rec_tbl1 cn_quota_rule_uplift_pvt.quota_rule_uplift_tbl_type;
3764:
3765: l_p_rt_quota_asgns_rec_tbl rt_quota_asgns_rec_tbl_type;
3766: l_oai_array jtf_usr_hks.oai_data_array_type;
3767: l_bind_data_id NUMBER;