APPS.CS_KB_CTXT_REPO_MAPS_PKG dependencies on CS_KB_CTXT_REPO_MAPS_B

Line 48: cursor C is select ROWID from CS_KB_CTXT_REPO_MAPS_B

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_CTXT_REPO_MAPS_B
49: where MAP_ID = X_MAP_ID
50: ;
51: begin
52: insert into CS_KB_CTXT_REPO_MAPS_B (

Line 52: insert into CS_KB_CTXT_REPO_MAPS_B (

48: cursor C is select ROWID from CS_KB_CTXT_REPO_MAPS_B
49: where MAP_ID = X_MAP_ID
50: ;
51: begin
52: insert into CS_KB_CTXT_REPO_MAPS_B (
53: MAP_ID,
54: REPOSITORY_ID,
55: CONTEXT_ID,
56: MAPPING_ORDER,

Line 199: from CS_KB_CTXT_REPO_MAPS_B

195: ATTRIBUTE12,
196: ATTRIBUTE13,
197: ATTRIBUTE14,
198: ATTRIBUTE15
199: from CS_KB_CTXT_REPO_MAPS_B
200: where MAP_ID = X_MAP_ID
201: for update of MAP_ID nowait;
202: recinfo c%rowtype;
203:

Line 312: update CS_KB_CTXT_REPO_MAPS_B set

308: X_LAST_UPDATED_BY in NUMBER,
309: X_LAST_UPDATE_LOGIN in NUMBER
310: ) is
311: begin
312: update CS_KB_CTXT_REPO_MAPS_B set
313: REPOSITORY_ID = X_REPOSITORY_ID,
314: CONTEXT_ID = X_CONTEXT_ID,
315: MAPPING_ORDER = X_MAPPING_ORDER,
316: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 369: delete from CS_KB_CTXT_REPO_MAPS_B

365: if (sql%notfound) then
366: raise no_data_found;
367: end if;
368:
369: delete from CS_KB_CTXT_REPO_MAPS_B
370: where MAP_ID = X_MAP_ID;
371:
372: if (sql%notfound) then
373: raise no_data_found;

Line 383: from CS_KB_CTXT_REPO_MAPS_B B

379: begin
380: delete from CS_KB_CTXT_REPO_MAPS_TL T
381: where not exists
382: (select NULL
383: from CS_KB_CTXT_REPO_MAPS_B B
384: where B.MAP_ID = T.MAP_ID
385: );
386:
387: update CS_KB_CTXT_REPO_MAPS_TL T set (

Line 473: FROM CS_KB_CTXT_REPO_MAPS_B

469: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
470: BEGIN
471: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER
472: INTO db_luby, db_ludate, db_ovn
473: FROM CS_KB_CTXT_REPO_MAPS_B
474: WHERE MAP_ID = X_MAP_ID;
475:
476: -- Test for customization and version
477: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,