APPS.CS_KB_SET_RECS_PKG dependencies on DUAL

Line 219: select cs_kb_set_recs_s.currval into l_set_rec_id_seq_val from dual;

215:
216: -- Make sure the id sequence is always higher than the passed
217: -- in set rec id such that there will not be duplicate solution
218: -- recommendation id's created.
219: select cs_kb_set_recs_s.currval into l_set_rec_id_seq_val from dual;
220: while ( l_set_rec_id_seq_val < p_set_rec_id ) loop
221: select cs_kb_set_recs_s.nextval into l_set_rec_id_seq_val from dual;
222: end loop;
223:

Line 221: select cs_kb_set_recs_s.nextval into l_set_rec_id_seq_val from dual;

217: -- in set rec id such that there will not be duplicate solution
218: -- recommendation id's created.
219: select cs_kb_set_recs_s.currval into l_set_rec_id_seq_val from dual;
220: while ( l_set_rec_id_seq_val < p_set_rec_id ) loop
221: select cs_kb_set_recs_s.nextval into l_set_rec_id_seq_val from dual;
222: end loop;
223:
224: l_set_rec_id := p_set_rec_id;
225: else

Line 226: select cs_kb_set_recs_s.nextval into l_set_rec_id from dual;

222: end loop;
223:
224: l_set_rec_id := p_set_rec_id;
225: else
226: select cs_kb_set_recs_s.nextval into l_set_rec_id from dual;
227: end if;
228:
229: if(P_SET_NUMBER is null) then
230: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

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;