APPS.OKE_OBJECT_ATTRIBUTES_PKG dependencies on OKE_OBJECT_ATTRIBUTES_B

Line 22: cursor C is select ROWID from OKE_OBJECT_ATTRIBUTES_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 OKE_OBJECT_ATTRIBUTES_B
23: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
24: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
25: ;
26: begin

Line 27: insert into OKE_OBJECT_ATTRIBUTES_B (

23: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
24: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
25: ;
26: begin
27: insert into OKE_OBJECT_ATTRIBUTES_B (
28: DATABASE_OBJECT_NAME,
29: ATTRIBUTE_CODE,
30: DATATYPE,
31: SECURABLE_FLAG,

Line 123: from OKE_OBJECT_ATTRIBUTES_B

119: VIEW_COLUMN_FLAG,
120: FORM_ITEM_FLAG,
121: ATTRIBUTE_GROUP_CODE,
122: PARENT_ATTRIBUTE_CODE
123: from OKE_OBJECT_ATTRIBUTES_B
124: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
125: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
126: for update of DATABASE_OBJECT_NAME nowait;
127: recinfo c%rowtype;

Line 200: update OKE_OBJECT_ATTRIBUTES_B set

196: X_LAST_UPDATED_BY in NUMBER,
197: X_LAST_UPDATE_LOGIN in NUMBER
198: ) is
199: begin
200: update OKE_OBJECT_ATTRIBUTES_B set
201: DATATYPE = X_DATATYPE,
202: SECURABLE_FLAG = X_SECURABLE_FLAG,
203: QUERYABLE_FLAG = X_QUERYABLE_FLAG,
204: VIEW_COLUMN_FLAG = X_VIEW_COLUMN_FLAG,

Line 247: delete from OKE_OBJECT_ATTRIBUTES_B

243: if (sql%notfound) then
244: raise no_data_found;
245: end if;
246:
247: delete from OKE_OBJECT_ATTRIBUTES_B
248: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
249: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
250:
251: if (sql%notfound) then

Line 262: from OKE_OBJECT_ATTRIBUTES_B B

258: begin
259: delete from OKE_OBJECT_ATTRIBUTES_TL T
260: where not exists
261: (select NULL
262: from OKE_OBJECT_ATTRIBUTES_B B
263: where B.DATABASE_OBJECT_NAME = T.DATABASE_OBJECT_NAME
264: and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
265: );
266: