APPS.CS_KB_SET_ELE_TYPES_PKG dependencies on CS_KB_SET_ELE_TYPES

Line 1: PACKAGE BODY CS_KB_SET_ELE_TYPES_PKG AS

1: PACKAGE BODY CS_KB_SET_ELE_TYPES_PKG AS
2: /* $Header: cskbsetb.pls 115.15 2003/11/19 23:39:36 mkettle ship $ */
3:
4: function Create_Set_Ele_Type(
5: P_SET_TYPE_ID in NUMBER,

Line 40: insert into CS_KB_SET_ELE_TYPES (

36: l_date := sysdate;
37: l_created_by := fnd_global.user_id;
38: l_login := fnd_global.login_id;
39:
40: insert into CS_KB_SET_ELE_TYPES (
41: SET_TYPE_ID,
42: ELEMENT_TYPE_ID,
43: ELEMENT_TYPE_ORDER,
44: OPTIONAL_FLAG,

Line 138: update CS_KB_SET_ELE_TYPES set

134: l_date := sysdate;
135: l_updated_by := fnd_global.user_id;
136: l_login := fnd_global.login_id;
137:
138: update CS_KB_SET_ELE_TYPES set
139: ELEMENT_TYPE_ORDER = P_ELEMENT_TYPE_ORDER,
140: OPTIONAL_FLAG = P_OPTIONAL_FLAG,
141: LAST_UPDATE_DATE = l_date,
142: LAST_UPDATED_BY = l_updated_by,

Line 207: delete from CS_KB_SET_ELE_TYPES

203: -- raise FND_API.G_EXC_ERROR;
204: return ERROR_STATUS;
205: end if;
206:
207: delete from CS_KB_SET_ELE_TYPES
208: where SET_TYPE_ID = P_SET_TYPE_ID
209: and ELEMENT_TYPE_ID = P_ELEMENT_TYPE_ID;
210:
211: if (sql%notfound) then

Line 248: cursor C is select ROWID from CS_KB_SET_ELE_TYPES where SET_TYPE_ID = X_SET_TYPE_ID

244: X_ATTRIBUTE13 in VARCHAR2,
245: X_ATTRIBUTE14 in VARCHAR2,
246: X_ATTRIBUTE15 in VARCHAR2) IS
247:
248: cursor C is select ROWID from CS_KB_SET_ELE_TYPES where SET_TYPE_ID = X_SET_TYPE_ID
249: AND ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID;
250:
251: BEGIN
252:

Line 254: insert into CS_KB_SET_ELE_TYPES (

250:
251: BEGIN
252:
253:
254: insert into CS_KB_SET_ELE_TYPES (
255: SET_TYPE_ID,
256: ELEMENT_TYPE_ID,
257: ELEMENT_TYPE_ORDER,
258: OPTIONAL_FLAG,

Line 348: update CS_KB_SET_ELE_TYPES set

344: ) IS
345:
346: BEGIN
347:
348: update CS_KB_SET_ELE_TYPES set
349:
350: ELEMENT_TYPE_ORDER = X_ELEMENT_TYPE_ORDER,
351: OPTIONAL_FLAG = X_OPTIONAL_FLAG,
352: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 396: CS_KB_SET_ELE_TYPES_PKG.Update_Row(

392: else
393: l_user_id := 0;
394: end if;
395:
396: CS_KB_SET_ELE_TYPES_PKG.Update_Row(
397: X_Set_Type_Id => x_set_type_id,
398: X_Element_Type_Id => x_element_type_id,
399: X_ELEMENT_TYPE_ORDER => x_element_type_order,
400: X_OPTIONAL_FLAG => x_optional_flag,

Line 407: CS_KB_SET_ELE_TYPES_PKG.Insert_Row(

403: X_LAST_UPDATE_LOGIN => 0);
404:
405: exception
406: when no_data_found then
407: CS_KB_SET_ELE_TYPES_PKG.Insert_Row(
408: X_Rowid => l_rowid,
409: X_SET_TYPE_ID => x_set_type_id,
410: X_ELEMENT_TYPE_ID => x_element_type_id,
411: X_ELEMENT_TYPE_ORDER => x_element_type_order,

Line 421: end CS_KB_SET_ELE_TYPES_PKG;

417: X_LAST_UPDATE_LOGIN => 0);
418:
419: end;
420:
421: end CS_KB_SET_ELE_TYPES_PKG;