Line 522: select as_sales_lead_ranks_s.nextval into l_rank_id from dual;
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;
520:
521: -- get the nextval from the sequence as rank_id 522: select as_sales_lead_ranks_s.nextval into l_rank_id from dual; 523: -- this is being commented out since this occurs before now
524: --l_sales_lead_rank_rec := p_sales_lead_rank_rec;
525: l_sales_lead_rank_rec.rank_id := l_rank_id;
526: