DBA Data[Home] [Help]

APPS.XDP_ADAPTER_TYPES_PKG dependencies on XDP_ADAPTER_TYPES_B

Line 22: cursor C is select ROWID from XDP_ADAPTER_TYPES_B

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: cursor C is select ROWID from XDP_ADAPTER_TYPES_B
23: where ADAPTER_TYPE = X_ADAPTER_TYPE
24: ;
25: begin
26: insert into XDP_ADAPTER_TYPES_B (

Line 26: insert into XDP_ADAPTER_TYPES_B (

22: cursor C is select ROWID from XDP_ADAPTER_TYPES_B
23: where ADAPTER_TYPE = X_ADAPTER_TYPE
24: ;
25: begin
26: insert into XDP_ADAPTER_TYPES_B (
27: ADAPTER_TYPE,
28: ADAPTER_CLASS,
29: BASE_ADAPTER_TYPE,
30: APPLICATION_MODE,

Line 123: from XDP_ADAPTER_TYPES_B

119: MAX_BUFFER_SIZE,
120: CMD_LINE_OPTIONS,
121: CMD_LINE_ARGS,
122: OBJECT_VERSION_NUMBER
123: from XDP_ADAPTER_TYPES_B
124: where ADAPTER_TYPE = X_ADAPTER_TYPE
125: for update of ADAPTER_TYPE nowait;
126: recinfo c%rowtype;
127:

Line 197: update XDP_ADAPTER_TYPES_B set

193: X_LAST_UPDATED_BY in NUMBER,
194: X_LAST_UPDATE_LOGIN in NUMBER
195: ) is
196: begin
197: update XDP_ADAPTER_TYPES_B set
198: ADAPTER_CLASS = X_ADAPTER_CLASS,
199: BASE_ADAPTER_TYPE = X_BASE_ADAPTER_TYPE,
200: APPLICATION_MODE = X_APPLICATION_MODE,
201: INBOUND_REQUIRED_FLAG = X_INBOUND_REQUIRED_FLAG,

Line 241: delete from XDP_ADAPTER_TYPES_B

237: if (sql%notfound) then
238: raise no_data_found;
239: end if;
240:
241: delete from XDP_ADAPTER_TYPES_B
242: where ADAPTER_TYPE = X_ADAPTER_TYPE;
243:
244: if (sql%notfound) then
245: raise no_data_found;

Line 255: from XDP_ADAPTER_TYPES_B B

251: begin
252: delete from XDP_ADAPTER_TYPES_TL T
253: where not exists
254: (select NULL
255: from XDP_ADAPTER_TYPES_B B
256: where B.ADAPTER_TYPE = T.ADAPTER_TYPE
257: );
258:
259: update XDP_ADAPTER_TYPES_TL T set (