APPS.CS_KB_REPOSITORIES_PKG dependencies on CS_KB_REPOSITORIES

Line 1: package body CS_KB_REPOSITORIES_PKG as

1: package body CS_KB_REPOSITORIES_PKG as
2: /* $Header: cskbrepb.pls 120.1 2005/08/09 16:20:19 mkettle noship $ */
3: /*=======================================================================+
4: | Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA|
5: | All rights reserved. |

Line 9: | PL/SQL body for package: CS_KB_REPOSITORIES_PKG

5: | All rights reserved. |
6: +=======================================================================+
7: | FILENAME
8: | DESCRIPTION
9: | PL/SQL body for package: CS_KB_REPOSITORIES_PKG
10: |
11: | History:
12: | 04 Apr 05 Matt Kettle Created
13: | 05 Aug 05 Matt Kettle Added Load_Seed_Row

Line 48: cursor C is select ROWID from CS_KB_REPOSITORIES

44: X_LAST_UPDATE_DATE in DATE,
45: X_LAST_UPDATED_BY in NUMBER,
46: X_LAST_UPDATE_LOGIN in NUMBER
47: ) is
48: cursor C is select ROWID from CS_KB_REPOSITORIES
49: where REPOSITORY_ID = X_REPOSITORY_ID;
50: begin
51: insert into CS_KB_REPOSITORIES (
52: OBJECT_VERSION_NUMBER,

Line 51: insert into CS_KB_REPOSITORIES (

47: ) is
48: cursor C is select ROWID from CS_KB_REPOSITORIES
49: where REPOSITORY_ID = X_REPOSITORY_ID;
50: begin
51: insert into CS_KB_REPOSITORIES (
52: OBJECT_VERSION_NUMBER,
53: ATTRIBUTE_CATEGORY,
54: ATTRIBUTE1,
55: ATTRIBUTE2,

Line 173: from CS_KB_REPOSITORIES

169: RESULT_REGION,
170: SEARCH_RESULT_VO,
171: SEARCH_RESULT_COUNT_VO,
172: UPDATABLE
173: from CS_KB_REPOSITORIES
174: where REPOSITORY_ID = X_REPOSITORY_ID
175: for update of REPOSITORY_ID nowait;
176:
177: recinfo c%rowtype;

Line 269: update CS_KB_REPOSITORIES set

265: X_LAST_UPDATED_BY in NUMBER,
266: X_LAST_UPDATE_LOGIN in NUMBER
267: ) is
268: begin
269: update CS_KB_REPOSITORIES set
270: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
271: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
272: ATTRIBUTE1 = X_ATTRIBUTE1,
273: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 309: delete from CS_KB_REPOSITORIES

305: X_REPOSITORY_ID in NUMBER
306: ) is
307: begin
308:
309: delete from CS_KB_REPOSITORIES
310: where REPOSITORY_ID = X_REPOSITORY_ID;
311:
312: if (sql%notfound) then
313: raise no_data_found;

Line 355: FROM CS_KB_REPOSITORIES

351: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
352: BEGIN
353: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER
354: INTO db_luby, db_ludate, db_ovn
355: FROM CS_KB_REPOSITORIES
356: WHERE REPOSITORY_ID = X_REPOSITORY_ID;
357:
358: -- Test for customization and version
359: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 464: end CS_KB_REPOSITORIES_PKG;

460: end if;
461:
462: END LOAD_SEED_ROW;
463:
464: end CS_KB_REPOSITORIES_PKG;