APPS.CS_KB_ELE_TYPE_LINKS_PKG dependencies on CS_KB_ELE_TYPE_LINKS

Line 1: PACKAGE BODY CS_KB_ELE_TYPE_LINKS_PKG AS

1: PACKAGE BODY CS_KB_ELE_TYPE_LINKS_PKG AS
2: /* $Header: cskbetlb.pls 115.13 2003/12/08 23:22:03 alawang ship $ */
3:
4:
5: function Create_Element_Type_Link(

Line 37: from cs_kb_ele_type_links

33: l_rowid varchar2(30);
34:
35: CURSOR Check_Link_Exists IS
36: select count(*)
37: from cs_kb_ele_type_links
38: where object_code = p_object_code
39: and element_type_id = p_element_type_id
40: and other_code = p_other_code
41: and (other_id = p_other_id or (other_id is null and p_other_id is null));

Line 45: from cs_kb_ele_type_links

41: and (other_id = p_other_id or (other_id is null and p_other_id is null));
42:
43: CURSOR Get_Current_Link_ID IS
44: select link_id
45: from cs_kb_ele_type_links
46: where object_code = p_object_code
47: and element_type_id = p_element_type_id
48: and other_code = p_other_code
49: and (other_id = p_other_id or (other_id is null and p_other_id is null));

Line 72: select cs_kb_ele_type_links_s.nextval into l_id from dual;

68: if(l_count <= 0) then
69: begin
70: --prepare data, then insert new element
71:
72: select cs_kb_ele_type_links_s.nextval into l_id from dual;
73: l_date := sysdate;
74: l_created_by := fnd_global.user_id;
75: l_login := fnd_global.login_id;
76:

Line 77: CS_KB_ELE_TYPE_LINKS_PKG.Insert_Row(

73: l_date := sysdate;
74: l_created_by := fnd_global.user_id;
75: l_login := fnd_global.login_id;
76:
77: CS_KB_ELE_TYPE_LINKS_PKG.Insert_Row(
78: X_Rowid => l_rowid,
79: X_Link_Id => l_id,
80: X_Link_type => p_link_type,
81: X_Object_Code => p_object_code,

Line 164: CS_KB_ELE_TYPE_LINKS_PKG.Update_Row(

160: l_date := sysdate;
161: l_updated_by := fnd_global.user_id;
162: l_login := fnd_global.login_id;
163:
164: CS_KB_ELE_TYPE_LINKS_PKG.Update_Row(
165: X_Link_Id => p_link_id,
166: X_Link_type => p_link_type,
167: X_Object_Code => p_object_code,
168: X_Element_Type_Id => p_element_type_id,

Line 207: delete from CS_KB_ELE_TYPE_LINKS

203:
204: begin
205: if (P_LINK_ID is null ) then return ERROR_STATUS; end if;
206:
207: delete from CS_KB_ELE_TYPE_LINKS
208: where LINK_ID = P_LINK_ID;
209:
210: if (sql%notfound) then
211: raise no_data_found;

Line 250: cursor C is select ROWID from CS_KB_ELE_TYPE_LINKS where LINK_ID = X_LINK_ID;

246: X_ATTRIBUTE13 in VARCHAR2,
247: X_ATTRIBUTE14 in VARCHAR2,
248: X_ATTRIBUTE15 in VARCHAR2) IS
249:
250: cursor C is select ROWID from CS_KB_ELE_TYPE_LINKS where LINK_ID = X_LINK_ID;
251:
252: BEGIN
253:
254:

Line 255: insert into CS_KB_ELE_TYPE_LINKS (

251:
252: BEGIN
253:
254:
255: insert into CS_KB_ELE_TYPE_LINKS (
256: LINK_ID,
257: LINK_TYPE,
258: OBJECT_CODE,
259: ELEMENT_TYPE_ID,

Line 355: update CS_KB_ELE_TYPE_LINKS set

351: )IS
352:
353: BEGIN
354:
355: update CS_KB_ELE_TYPE_LINKS set
356:
357: LINK_TYPE = X_LINK_TYPE,
358: OBJECT_CODE = X_OBJECT_CODE,
359: ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID,

Line 408: CS_KB_ELE_TYPE_LINKS_PKG.Update_Row(

404: else
405: l_user_id := 0;
406: end if;
407:
408: CS_KB_ELE_TYPE_LINKS_PKG.Update_Row(
409: X_LINK_ID => X_LINK_ID,
410: X_LINK_TYPE => X_LINK_TYPE,
411: X_OBJECT_CODE => X_OBJECT_CODE,
412: X_ELEMENT_TYPE_ID => X_ELEMENT_TYPE_ID,

Line 421: CS_KB_ELE_TYPE_LINKS_PKG.Insert_Row(

417: X_LAST_UPDATE_LOGIN => 0);
418:
419: exception
420: when no_data_found then
421: CS_KB_ELE_TYPE_LINKS_PKG.Insert_Row(
422: X_Rowid => l_rowid,
423: X_Link_ID => x_link_id,
424: X_Link_Type => x_link_type,
425: X_Object_Code => x_object_code,

Line 437: end CS_KB_ELE_TYPE_LINKS_PKG;

433: X_LAST_UPDATE_LOGIN => 0);
434:
435: end;
436:
437: end CS_KB_ELE_TYPE_LINKS_PKG;