APPS.CS_KB_SET_ELES_PKG dependencies on CS_KB_SET_ELES

Line 1: PACKAGE BODY CS_KB_SET_ELES_PKG AS

1: PACKAGE BODY CS_KB_SET_ELES_PKG AS
2: /* $Header: cskbseb.pls 120.1 2005/07/19 17:01:18 appldev ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in OUT NOCOPY VARCHAR2,

Line 32: cursor C is select ROWID from CS_KB_SET_ELES where SET_ID = X_SET_ID

28: X_ATTRIBUTE13 in VARCHAR2,
29: X_ATTRIBUTE14 in VARCHAR2,
30: X_ATTRIBUTE15 in VARCHAR2) IS
31:
32: cursor C is select ROWID from CS_KB_SET_ELES where SET_ID = X_SET_ID
33: AND ELEMENT_ID = X_ELEMENT_ID;
34:
35: BEGIN
36:

Line 38: insert into CS_KB_SET_ELES (

34:
35: BEGIN
36:
37:
38: insert into CS_KB_SET_ELES (
39: SET_ID,
40: ELEMENT_ID,
41: ELEMENT_ORDER,
42: ASSOC_DEGREE,

Line 132: update CS_KB_SET_ELES set

128: ) IS
129:
130: BEGIN
131:
132: update CS_KB_SET_ELES set
133:
134: ELEMENT_ORDER = X_ELEMENT_ORDER,
135: ASSOC_DEGREE = X_ASSOC_DEGREE,
136: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 180: CS_KB_SET_ELES_PKG.Update_Row(

176: else
177: l_user_id := 0;
178: end if;
179:
180: CS_KB_SET_ELES_PKG.Update_Row(
181: X_Set_Id => x_set_id,
182: X_Element_Id => x_element_id,
183: X_Element_ORDER => x_element_order,
184: X_Assoc_Degree => x_assoc_degree,

Line 191: CS_KB_SET_ELES_PKG.Insert_Row(

187: X_LAST_UPDATE_LOGIN => 0);
188:
189: exception
190: when no_data_found then
191: CS_KB_SET_ELES_PKG.Insert_Row(
192: X_Rowid => l_rowid,
193: X_Set_Id => x_set_id,
194: X_Element_Id => x_element_id,
195: X_Element_ORDER => x_element_order,

Line 210: from cs_kb_Set_eles se

206: ( set_id in number) return number as
207:
208: cursor get_min_ele_order (setid number) is
209: select se.element_id
210: from cs_kb_Set_eles se
211: where se.set_id = setid
212: order by se.element_order;
213: x_return number;
214: begin

Line 238: FROM CS_KB_SET_ELES

234:
235:
236: CURSOR set_eles_cur is
237: SELECT *
238: FROM CS_KB_SET_ELES
239: WHERE set_id = P_SET_SOURCE_ID;
240:
241: BEGIN
242:

Line 281: end CS_KB_SET_ELES_PKG;

277: END LOOP;
278: END Clone_Rows;
279:
280:
281: end CS_KB_SET_ELES_PKG;