DBA Data[Home] [Help]

APPS.XDO_DS_DEFINITIONS_PKG dependencies on XDO_DS_DEFINITIONS_B

Line 35: cursor C is select ROWID from XDO_DS_DEFINITIONS_B

31: X_LAST_UPDATE_DATE in DATE,
32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is select ROWID from XDO_DS_DEFINITIONS_B
36: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
37: and DATA_SOURCE_CODE = X_DATA_SOURCE_CODE
38: ;
39: begin

Line 40: insert into XDO_DS_DEFINITIONS_B (

36: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
37: and DATA_SOURCE_CODE = X_DATA_SOURCE_CODE
38: ;
39: begin
40: insert into XDO_DS_DEFINITIONS_B (
41: APPLICATION_SHORT_NAME,
42: DATA_SOURCE_CODE,
43: DATA_SOURCE_STATUS,
44: START_DATE,

Line 189: from XDO_DS_DEFINITIONS_B

185: ATTRIBUTE12,
186: ATTRIBUTE13,
187: ATTRIBUTE14,
188: ATTRIBUTE15
189: from XDO_DS_DEFINITIONS_B
190: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
191: and DATA_SOURCE_CODE = X_DATA_SOURCE_CODE
192: for update of APPLICATION_SHORT_NAME nowait;
193: recinfo c%rowtype;

Line 303: update XDO_DS_DEFINITIONS_B set

299: X_LAST_UPDATED_BY in NUMBER,
300: X_LAST_UPDATE_LOGIN in NUMBER
301: ) is
302: begin
303: update XDO_DS_DEFINITIONS_B set
304: DATA_SOURCE_STATUS = X_DATA_SOURCE_STATUS,
305: START_DATE = X_START_DATE,
306: END_DATE = X_END_DATE,
307: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 363: delete from XDO_DS_DEFINITIONS_B

359: if (sql%notfound) then
360: raise no_data_found;
361: end if;
362:
363: delete from XDO_DS_DEFINITIONS_B
364: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
365: and DATA_SOURCE_CODE = X_DATA_SOURCE_CODE;
366:
367: if (sql%notfound) then

Line 378: from XDO_DS_DEFINITIONS_B B

374: begin
375: delete from XDO_DS_DEFINITIONS_TL T
376: where not exists
377: (select NULL
378: from XDO_DS_DEFINITIONS_B B
379: where B.APPLICATION_SHORT_NAME = T.APPLICATION_SHORT_NAME
380: and B.DATA_SOURCE_CODE = T.DATA_SOURCE_CODE
381: );
382:

Line 553: from xdo_ds_definitions_b

549:
550: begin
551: select LAST_UPDATED_BY, LAST_UPDATE_DATE
552: into db_luby, db_ludate
553: from xdo_ds_definitions_b
554: where data_source_code=x_data_source_code
555: and application_short_name = X_APPLICATION_SHORT_NAME;
556:
557: -- Update record, honoring customization mode.