APPS.CS_KNOWLEDGE_GRP dependencies on CS_KB_SET_LINKS

Line 103: l_ret := CS_KB_SET_LINKS_PKG.Delete_Set_Link_W_Obj_Code(

99: end if;
100: -- -- -- -- begin delete set_link -- -- -- -- --
101: x_return_status := FND_API.G_RET_STS_SUCCESS;
102:
103: l_ret := CS_KB_SET_LINKS_PKG.Delete_Set_Link_W_Obj_Code(
104: p_set_id, p_object_code, p_other_id);
105: -- -- -- -- end delete set_link -- -- --
106:
107: FND_MSG_PUB.Count_And_Get(

Line 694: P_SET_LINK_REC IN CS_KB_SET_LINKS%ROWTYPE,

690: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
691: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
692: X_MSG_COUNT OUT NOCOPY NUMBER,
693: X_MSG_DATA OUT NOCOPY VARCHAR2,
694: P_SET_LINK_REC IN CS_KB_SET_LINKS%ROWTYPE,
695: X_SET_LINK_ID OUT NOCOPY NUMBER
696: ) IS
697: l_api_name CONSTANT varchar2(30) := 'Create_Set_Link';
698: l_api_version CONSTANT number := 1.0;

Line 725: CS_KB_SET_LINKS_PKG.Create_Set_Link(

721: END IF;
722:
723: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
724:
725: CS_KB_SET_LINKS_PKG.Create_Set_Link(
726: P_LINK_TYPE => p_set_link_rec.link_type,
727: P_OBJECT_CODE => p_set_link_rec.object_code,
728: P_SET_ID => p_set_link_rec.set_id,
729: P_OTHER_ID => p_set_link_rec.other_id,

Line 807: p_set_link_rec in CS_KB_SET_LINKS%ROWTYPE

803: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
804: x_return_status OUT NOCOPY varchar2,
805: x_msg_count OUT NOCOPY number,
806: x_msg_data OUT NOCOPY varchar2,
807: p_set_link_rec in CS_KB_SET_LINKS%ROWTYPE
808: ) is
809: l_api_name CONSTANT varchar2(30) := 'Update_Set_Link';
810: l_api_version CONSTANT number := 1.0;
811: l_date date;

Line 834: l_sta := CS_KB_SET_LINKS_PKG.Update_Set_Link(

830: x_return_status := FND_API.G_RET_STS_SUCCESS;
831:
832: -- -- -- -- begin my code -- -- -- -- --
833:
834: l_sta := CS_KB_SET_LINKS_PKG.Update_Set_Link(
835: p_set_link_rec.link_id,
836: p_set_link_rec.link_type,
837: p_set_link_rec.object_code,
838: p_set_link_rec.set_id,

Line 857: if(l_sta<>CS_KB_SET_LINKS_PKG.OKAY_STATUS) then

853: p_set_link_rec.attribute13,
854: p_set_link_rec.attribute14,
855: p_set_link_rec.attribute15
856: );
857: if(l_sta<>CS_KB_SET_LINKS_PKG.OKAY_STATUS) then
858: raise FND_API.G_EXC_UNEXPECTED_ERROR;
859: end if;
860:
861: -- -- -- -- end of code -- -- --

Line 1612: DELETE /*+ index(l) */ FROM CS_KB_SET_LINKS l

1608:
1609: END IF;
1610: ELSE
1611:
1612: DELETE /*+ index(l) */ FROM CS_KB_SET_LINKS l
1613: WHERE l.Object_Code = P_OBJECT_TYPE
1614: AND l.Other_id IN ( SELECT /*+ no_unnest no_semijoin cardinality(10) */ t.Object_id
1615: FROM JTF_OBJECT_PURGE_PARAM_TMP t
1616: WHERE nvl(t.purge_status, 'S') <> 'E'