APPS.CS_KB_SET_USED_SUMS_PKG dependencies on CS_KB_SET_USED_SUMS

Line 1: PACKAGE BODY CS_KB_SET_USED_SUMS_PKG AS

1: PACKAGE BODY CS_KB_SET_USED_SUMS_PKG AS
2: /* $Header: cskbsusb.pls 115.3 2002/02/01 17:24:29 pkm ship $ */
3:
4: function Create_Set_Used_Sum(
5: P_SET_ID in NUMBER,

Line 39: insert into CS_KB_SET_USED_SUMS (

35: l_date := sysdate;
36: l_created_by := fnd_global.user_id;
37: l_login := fnd_global.login_id;
38:
39: insert into CS_KB_SET_USED_SUMS (
40: SET_ID,
41: DEF_ID,
42: USED_COUNT,
43: CREATION_DATE,

Line 134: update CS_KB_SET_USED_SUMS set

130: l_date := sysdate;
131: l_updated_by := fnd_global.user_id;
132: l_login := fnd_global.login_id;
133:
134: update CS_KB_SET_USED_SUMS set
135: USED_COUNT = P_USED_COUNT,
136: LAST_UPDATE_DATE = l_date,
137: LAST_UPDATED_BY = l_updated_by,
138: LAST_UPDATE_LOGIN = l_login,

Line 179: delete from CS_KB_SET_USED_SUMS

175: ) return number is
176: begin
177: if (P_SET_ID is null OR P_DEF_ID is null) then return ERROR_STATUS; end if;
178:
179: delete from CS_KB_SET_USED_SUMS
180: where SET_ID = P_SET_ID AND DEF_ID = P_DEF_ID;
181:
182:
183: if (sql%notfound) then

Line 193: end CS_KB_SET_USED_SUMS_PKG;

189:
190: end Delete_Set_Used_Sum;
191:
192:
193: end CS_KB_SET_USED_SUMS_PKG;