APPS.CS_KB_SET_USED_HISTS_PKG dependencies on CS_KB_SET_USED_HISTS

Line 1: PACKAGE BODY CS_KB_SET_USED_HISTS_PKG AS

1: PACKAGE BODY CS_KB_SET_USED_HISTS_PKG AS
2: /* $Header: cskbsuhb.pls 115.4 2002/02/01 17:24:27 pkm ship $ */
3:
4: function Create_Set_Used_History(
5: P_SET_ID in NUMBER,

Line 39: insert into CS_KB_SET_USED_HISTS (

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_HISTS (
40: SET_ID,
41: HISTORY_ID,
42: USED_TYPE,
43: CREATION_DATE,

Line 134: update CS_KB_SET_USED_HISTS 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_HISTS set
135: USED_TYPE = P_USED_TYPE,
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_HISTS

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

Line 193: end CS_KB_SET_USED_HISTS_PKG;

189:
190: end Delete_Set_Used_History;
191:
192:
193: end CS_KB_SET_USED_HISTS_PKG;