APPS.CS_KB_CONTEXTS_PKG dependencies on CS_KB_CONTEXTS

Line 1: package body CS_KB_CONTEXTS_PKG as

1: package body CS_KB_CONTEXTS_PKG as
2: /* $Header: cskbconb.pls 120.3 2006/04/28 11:35:28 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_CONTEXTS_PKG

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

Line 47: cursor C is select ROWID from CS_KB_CONTEXTS

43: X_LAST_UPDATE_DATE in DATE,
44: X_LAST_UPDATED_BY in NUMBER,
45: X_LAST_UPDATE_LOGIN in NUMBER
46: ) is
47: cursor C is select ROWID from CS_KB_CONTEXTS
48: where CONTEXT_ID = X_CONTEXT_ID;
49: begin
50: insert into CS_KB_CONTEXTS (
51: CONTEXT_ID,

Line 50: insert into CS_KB_CONTEXTS (

46: ) is
47: cursor C is select ROWID from CS_KB_CONTEXTS
48: where CONTEXT_ID = X_CONTEXT_ID;
49: begin
50: insert into CS_KB_CONTEXTS (
51: CONTEXT_ID,
52: CONTEXT_TYPE,
53: CONTEXT_VALUE,
54: CONTEXT_VALUE2,

Line 168: from CS_KB_CONTEXTS

164: ATTRIBUTE12,
165: ATTRIBUTE13,
166: ATTRIBUTE14,
167: ATTRIBUTE15
168: from CS_KB_CONTEXTS
169: where CONTEXT_ID = X_CONTEXT_ID
170: for update of CONTEXT_ID nowait;
171:
172: recinfo c%rowtype;

Line 264: update CS_KB_CONTEXTS set

260: X_LAST_UPDATED_BY in NUMBER,
261: X_LAST_UPDATE_LOGIN in NUMBER
262: ) is
263: begin
264: update CS_KB_CONTEXTS set
265: CONTEXT_TYPE = X_CONTEXT_TYPE,
266: CONTEXT_VALUE = X_CONTEXT_VALUE,
267: CONTEXT_VALUE2 = X_CONTEXT_VALUE2,
268: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 303: delete from CS_KB_CONTEXTS

299: X_CONTEXT_ID in NUMBER
300: ) is
301: begin
302:
303: delete from CS_KB_CONTEXTS
304: where CONTEXT_ID = X_CONTEXT_ID;
305:
306: if (sql%notfound) then
307: raise no_data_found;

Line 368: FROM CS_KB_CONTEXTS

364: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
365: BEGIN
366: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER
367: INTO db_luby, db_ludate, db_ovn
368: FROM CS_KB_CONTEXTS
369: WHERE CONTEXT_ID = X_CONTEXT_ID;
370:
371: -- Test for customization and version
372: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 476: end CS_KB_CONTEXTS_PKG;

472: end if;
473:
474: END LOAD_SEED_ROW;
475:
476: end CS_KB_CONTEXTS_PKG;