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:

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

355: p_other_id);
356: FETCH Count_Links_to_Soln_Ver into l_links_to_soln_ver_ct;
357: CLOSE Count_Links_to_Soln_Ver;
358: IF ( l_links_to_soln_ver_ct = 0 ) THEN
359: select cs_kb_set_links_s.nextval into l_other_link_id from dual;
360: CS_KB_SET_LINKS_PKG.Insert_Row(
361: X_Rowid => l_other_rowid,
362: X_Link_Id => l_other_link_id,
363: X_Link_type => p_link_type,