DBA Data[Home] [Help]

APPS.CS_KB_SET_LINKS_PKG dependencies on DUAL

Line 33: select cs_kb_set_links_s.nextval into l_id from dual;

29:
30: -- Copying data with previous set id to new set_id.
31: for rec_link in l_link_csr loop
32: -- dtian: use table handler instead
33: select cs_kb_set_links_s.nextval into l_id from dual;
34:
35: CS_KB_SET_LINKS_PKG.Insert_Row(
36: X_Rowid => l_rowid,
37: X_Link_Id => l_id,

Line 274: select cs_kb_set_links_s.nextval into l_id from dual;

270: -- End of Validation
271:
272: --prepare data, then insert new set link
273: IF( x_link_id is null ) THEN
274: select cs_kb_set_links_s.nextval into l_id from dual;
275: ELSE
276: l_id := x_link_id;
277: END IF;
278: --Start of Bugfix8513725

Line 383: select cs_kb_set_links_s.nextval into l_other_link_id from dual;

379: End ;
380: --End Of Bugfix8513725
381:
382: IF ( l_links_to_soln_ver_ct = 0 ) THEN
383: select cs_kb_set_links_s.nextval into l_other_link_id from dual;
384: CS_KB_SET_LINKS_PKG.Insert_Row(
385: X_Rowid => l_other_rowid,
386: X_Link_Id => l_other_link_id,
387: X_Link_type => p_link_type,