APPS.CS_KB_SET_RECS_PKG dependencies on CS_KB_SET_REC_ORDER_S

Line 275: select cs_kb_set_rec_order_s.nextval into l_set_order from dual;

271: -- If the solution recommendation order parameter (p_set_order)
272: -- is null, generate a new order number from the sequence.
273: -- Otherwise, validate that the passed order is not a duplicate.
274: if( p_set_order is null ) then
275: select cs_kb_set_rec_order_s.nextval into l_set_order from dual;
276: else
277: l_set_order := p_set_order;
278: select count(*) into l_count from cs_kb_set_recs
279: where set_order = l_set_order;

Line 292: select cs_kb_set_rec_order_s.currval into l_order_seq_val from dual;

288:
289: -- Make sure the order sequence is always higher than the passed
290: -- in order number such that newly recommended solutions are always
291: -- at the end of the recommendation list.
292: select cs_kb_set_rec_order_s.currval into l_order_seq_val from dual;
293: while ( l_order_seq_val < l_set_order ) loop
294: select cs_kb_set_rec_order_s.nextval into l_order_seq_val from dual;
295: end loop;
296: end if;

Line 294: select cs_kb_set_rec_order_s.nextval into l_order_seq_val from dual;

290: -- in order number such that newly recommended solutions are always
291: -- at the end of the recommendation list.
292: select cs_kb_set_rec_order_s.currval into l_order_seq_val from dual;
293: while ( l_order_seq_val < l_set_order ) loop
294: select cs_kb_set_rec_order_s.nextval into l_order_seq_val from dual;
295: end loop;
296: end if;
297:
298: l_date := sysdate;