DBA Data[Home] [Help]

APPS.CS_KB_SET_LINKS_PKG dependencies on CS_KB_SET_LINKS_PKG

Line 1: PACKAGE BODY CS_KB_SET_LINKS_PKG AS

1: PACKAGE BODY CS_KB_SET_LINKS_PKG AS
2: /* $Header: cskbslb.pls 120.1 2005/07/27 19:05:29 appldev ship $ */
3:
4: --
5: -- Clone_link is to duplicate all data with previous verion set_id to new set_id

Line 35: CS_KB_SET_LINKS_PKG.Insert_Row(

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,
38: X_Link_type => REC_LINK.LINK_TYPE,
39: X_Object_Code => REC_LINK.OBJECT_CODE,

Line 283: CS_KB_SET_LINKS_PKG.Insert_Row(

279: l_date := sysdate;
280: l_created_by := fnd_global.user_id;
281: l_login := fnd_global.login_id;
282:
283: CS_KB_SET_LINKS_PKG.Insert_Row(
284: X_Rowid => l_rowid,
285: X_Link_Id => l_id,
286: X_Link_type => p_link_type,
287: X_Object_Code => p_object_code,

Line 314: CS_KB_SET_LINKS_PKG.Raise_Solution_Linked_Event(

310: X_ATTRIBUTE15 => P_ATTRIBUTE15
311: );
312:
313: -- Raise Business Event when a solution is linked
314: CS_KB_SET_LINKS_PKG.Raise_Solution_Linked_Event(
315: p_set_id => p_set_id,
316: p_object_code => p_object_code,
317: p_object_id => p_other_id,
318: p_link_id => l_id,

Line 360: CS_KB_SET_LINKS_PKG.Insert_Row(

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,
364: X_Object_Code => p_object_code,

Line 795: CS_KB_SET_LINKS_PKG.Update_Row(

791: l_date := sysdate;
792: l_updated_by := fnd_global.user_id;
793: l_login := fnd_global.login_id;
794:
795: CS_KB_SET_LINKS_PKG.Update_Row(
796: X_Link_Id => p_link_id,
797: X_Link_type => p_link_type,
798: X_Object_Code => p_object_code,
799: X_Set_Id => p_set_id,

Line 822: CS_KB_SET_LINKS_PKG.Raise_Soln_Link_Updated_Event(

818: X_ATTRIBUTE14 => P_ATTRIBUTE14,
819: X_ATTRIBUTE15 => P_ATTRIBUTE15);
820:
821: -- Raise Business Event when a solution link is updated
822: CS_KB_SET_LINKS_PKG.Raise_Soln_Link_Updated_Event(
823: p_set_id => p_set_id,
824: p_object_code => p_object_code,
825: p_object_id => p_other_id,
826: p_link_id => p_link_id,

Line 854: CS_KB_SET_LINKS_PKG.Update_Row(

850: CLOSE Get_Link_To_Published_Ver;
851: END IF;
852: IF ( l_other_link_id is not null
853: and l_other_link_id <> p_link_id ) THEN
854: CS_KB_SET_LINKS_PKG.Update_Row(
855: X_Link_Id => l_other_link_id,
856: X_Link_type => p_link_type,
857: X_Object_Code => p_object_code,
858: X_Set_Id => l_other_soln_id,

Line 1451: end CS_KB_SET_LINKS_PKG;

1447:
1448: end Raise_Soln_Link_Updated_Event;
1449:
1450:
1451: end CS_KB_SET_LINKS_PKG;