APPS.CS_KB_AUTOLINK_USAGES_PKG dependencies on CS_KB_AUTOLINK_USAGES

Line 1: package body CS_KB_AUTOLINK_USAGES_PKG as

1: package body CS_KB_AUTOLINK_USAGES_PKG as
2: /* $Header: cskbalub.pls 120.0 2005/07/13 10:20:18 appldev noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_AUTOLINK_USAGE_ID in NUMBER,

Line 18: cursor C is select ROWID from CS_KB_AUTOLINK_USAGES

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from CS_KB_AUTOLINK_USAGES
19: where AUTOLINK_USAGE_ID = X_AUTOLINK_USAGE_ID
20: ;
21: begin
22: insert into CS_KB_AUTOLINK_USAGES (

Line 22: insert into CS_KB_AUTOLINK_USAGES (

18: cursor C is select ROWID from CS_KB_AUTOLINK_USAGES
19: where AUTOLINK_USAGE_ID = X_AUTOLINK_USAGE_ID
20: ;
21: begin
22: insert into CS_KB_AUTOLINK_USAGES (
23: AUTOLINK_USAGE_ID,
24: AUTOLINK_ID,
25: OBJECT_CODE,
26: SEQUENCE_NUMBER,

Line 76: from CS_KB_AUTOLINK_USAGES

72: SEQUENCE_NUMBER,
73: START_DATE_ACTIVE,
74: END_DATE_ACTIVE,
75: OBJECT_VERSION_NUMBER
76: from CS_KB_AUTOLINK_USAGES
77: where AUTOLINK_USAGE_ID = X_AUTOLINK_USAGE_ID
78: for update of AUTOLINK_USAGE_ID nowait;
79: recinfo c%rowtype;
80:

Line 122: update CS_KB_AUTOLINK_USAGES set

118: X_LAST_UPDATED_BY in NUMBER,
119: X_LAST_UPDATE_LOGIN in NUMBER
120: ) is
121: begin
122: update CS_KB_AUTOLINK_USAGES set
123: AUTOLINK_ID = X_AUTOLINK_ID,
124: OBJECT_CODE = X_OBJECT_CODE,
125: SEQUENCE_NUMBER = X_SEQUENCE_NUMBER,
126: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 144: delete from CS_KB_AUTOLINK_USAGES

140: procedure DELETE_ROW (
141: X_AUTOLINK_USAGE_ID in NUMBER
142: ) is
143: begin
144: delete from CS_KB_AUTOLINK_USAGES
145: where AUTOLINK_USAGE_ID = X_AUTOLINK_USAGE_ID;
146:
147: if (sql%notfound) then
148: raise no_data_found;

Line 152: end CS_KB_AUTOLINK_USAGES_PKG;

148: raise no_data_found;
149: end if;
150: end DELETE_ROW;
151:
152: end CS_KB_AUTOLINK_USAGES_PKG;