APPS.CS_KB_ELEMENT_LINKS_PKG dependencies on CS_KB_ELEMENT_LINKS

Line 1: PACKAGE BODY CS_KB_ELEMENT_LINKS_PKG AS

1: PACKAGE BODY CS_KB_ELEMENT_LINKS_PKG AS
2: /* $Header: cskbellb.pls 120.0 2005/06/01 14:43:12 appldev noship $ */
3:
4: function Create_Element_Link(
5: P_LINK_TYPE in VARCHAR,

Line 45: select cs_kb_element_links_s.nextval into l_id from dual;

41: end if;
42:
43: --prepare data, then insert new element
44:
45: select cs_kb_element_links_s.nextval into l_id from dual;
46: l_date := sysdate;
47: l_created_by := fnd_global.user_id;
48: l_login := fnd_global.login_id;
49:

Line 50: CS_KB_ELEMENT_LINKS_PKG.Insert_Row(

46: l_date := sysdate;
47: l_created_by := fnd_global.user_id;
48: l_login := fnd_global.login_id;
49:
50: CS_KB_ELEMENT_LINKS_PKG.Insert_Row(
51: X_Rowid => l_rowid,
52: X_Link_Id => l_id,
53: X_Link_type => p_link_type,
54: X_Object_Code => p_object_code,

Line 133: CS_KB_ELEMENT_LINKS_PKG.Update_Row(

129: l_date := sysdate;
130: l_updated_by := fnd_global.user_id;
131: l_login := fnd_global.login_id;
132:
133: CS_KB_ELEMENT_LINKS_PKG.Update_Row(
134: X_Link_Id => p_link_id,
135: X_Link_type => p_link_type,
136: X_Object_Code => p_object_code,
137: X_Element_Id => p_element_id,

Line 186: DELETE FROM CS_KB_ELEMENT_LINKS where Element_Id = p_element_id

182: --goto error_found;
183: end if;
184:
185:
186: DELETE FROM CS_KB_ELEMENT_LINKS where Element_Id = p_element_id
187: and Object_Code = p_object_code
188: and Other_Id = p_other_id;
189:
190: return OKAY_STATUS;

Line 204: delete from CS_KB_ELEMENT_LINKS

200:
201: begin
202: if (P_LINK_ID is null ) then return ERROR_STATUS; end if;
203:
204: delete from CS_KB_ELEMENT_LINKS
205: where LINK_ID = P_LINK_ID;
206:
207: return OKAY_STATUS;
208: <>

Line 242: cursor C is select ROWID from CS_KB_ELEMENT_LINKS where LINK_ID = X_LINK_ID;

238: X_ATTRIBUTE13 in VARCHAR2,
239: X_ATTRIBUTE14 in VARCHAR2,
240: X_ATTRIBUTE15 in VARCHAR2) IS
241:
242: cursor C is select ROWID from CS_KB_ELEMENT_LINKS where LINK_ID = X_LINK_ID;
243:
244:
245: BEGIN
246:

Line 247: insert into CS_KB_ELEMENT_LINKS (

243:
244:
245: BEGIN
246:
247: insert into CS_KB_ELEMENT_LINKS (
248: LINK_ID,
249: LINK_TYPE,
250: OBJECT_CODE,
251: ELEMENT_ID,

Line 344: update CS_KB_ELEMENT_LINKS set

340: ) IS
341:
342: BEGIN
343:
344: update CS_KB_ELEMENT_LINKS set
345:
346: LINK_TYPE = X_LINK_TYPE,
347: OBJECT_CODE = X_OBJECT_CODE,
348: ELEMENT_ID = X_ELEMENT_ID,

Line 378: end CS_KB_ELEMENT_LINKS_PKG;

374:
375: END UPDATE_ROW;
376:
377:
378: end CS_KB_ELEMENT_LINKS_PKG;