APPS.XDP_ADAPTER_TYPE_ATTRS_PKG dependencies on XDP_ADAPTER_TYPE_ATTRS_B

Line 19: cursor C is select ROWID from XDP_ADAPTER_TYPE_ATTRS_B

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from XDP_ADAPTER_TYPE_ATTRS_B
20: where ADAPTER_TYPE_ATTRS_ID = X_ADAPTER_TYPE_ATTRS_ID
21: ;
22: begin
23: insert into XDP_ADAPTER_TYPE_ATTRS_B (

Line 23: insert into XDP_ADAPTER_TYPE_ATTRS_B (

19: cursor C is select ROWID from XDP_ADAPTER_TYPE_ATTRS_B
20: where ADAPTER_TYPE_ATTRS_ID = X_ADAPTER_TYPE_ATTRS_ID
21: ;
22: begin
23: insert into XDP_ADAPTER_TYPE_ATTRS_B (
24: ADAPTER_TYPE_ATTRS_ID,
25: ADAPTER_TYPE,
26: ATTRIBUTE_NAME,
27: DEFAULT_VALUE,

Line 103: from XDP_ADAPTER_TYPE_ATTRS_B

99: ADAPTER_TYPE,
100: ATTRIBUTE_NAME,
101: DEFAULT_VALUE,
102: OBJECT_VERSION_NUMBER
103: from XDP_ADAPTER_TYPE_ATTRS_B
104: where ADAPTER_TYPE_ATTRS_ID = X_ADAPTER_TYPE_ATTRS_ID
105: for update of ADAPTER_TYPE_ATTRS_ID nowait;
106: recinfo c%rowtype;
107:

Line 166: update XDP_ADAPTER_TYPE_ATTRS_B set

162: X_LAST_UPDATED_BY in NUMBER,
163: X_LAST_UPDATE_LOGIN in NUMBER
164: ) is
165: begin
166: update XDP_ADAPTER_TYPE_ATTRS_B set
167: ADAPTER_TYPE = X_ADAPTER_TYPE,
168: ATTRIBUTE_NAME = X_ATTRIBUTE_NAME,
169: DEFAULT_VALUE = X_DEFAULT_VALUE,
170: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 206: delete from XDP_ADAPTER_TYPE_ATTRS_B

202: if (sql%notfound) then
203: raise no_data_found;
204: end if;
205:
206: delete from XDP_ADAPTER_TYPE_ATTRS_B
207: where ADAPTER_TYPE_ATTRS_ID = X_ADAPTER_TYPE_ATTRS_ID;
208:
209: if (sql%notfound) then
210: raise no_data_found;

Line 220: from XDP_ADAPTER_TYPE_ATTRS_B B

216: begin
217: delete from XDP_ADAPTER_TYPE_ATTRS_TL T
218: where not exists
219: (select NULL
220: from XDP_ADAPTER_TYPE_ATTRS_B B
221: where B.ADAPTER_TYPE_ATTRS_ID = T.ADAPTER_TYPE_ATTRS_ID
222: );
223:
224: update XDP_ADAPTER_TYPE_ATTRS_TL T set (