APPS.AMV_D_ENT_ATTRIBUTES_PKG dependencies on AMV_D_ENT_ATTRIBUTES_B

Line 114: cursor C is select ROWID from AMV_D_ENT_ATTRIBUTES_B

110: X_LAST_UPDATE_DATE in DATE,
111: X_LAST_UPDATED_BY in NUMBER,
112: X_LAST_UPDATE_LOGIN in NUMBER
113: ) is
114: cursor C is select ROWID from AMV_D_ENT_ATTRIBUTES_B
115: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
116: ;
117: begin
118: insert into AMV_D_ENT_ATTRIBUTES_B (

Line 118: insert into AMV_D_ENT_ATTRIBUTES_B (

114: cursor C is select ROWID from AMV_D_ENT_ATTRIBUTES_B
115: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
116: ;
117: begin
118: insert into AMV_D_ENT_ATTRIBUTES_B (
119: ATTRIBUTE_ID,
120: OBJECT_VERSION_NUMBER,
121: ENTITY_ID,
122: DATA_TYPE,

Line 220: from AMV_D_ENT_ATTRIBUTES_B

216: VALIDATION_TYPE,
217: RANGE_LOW_VALUE,
218: RANGE_HIGH_VALUE,
219: FUNCTION_CALL
220: from AMV_D_ENT_ATTRIBUTES_B
221: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
222: for update of ATTRIBUTE_ID nowait;
223: recinfo c%rowtype;
224:

Line 298: update AMV_D_ENT_ATTRIBUTES_B set

294: X_LAST_UPDATED_BY in NUMBER,
295: X_LAST_UPDATE_LOGIN in NUMBER
296: ) is
297: begin
298: update AMV_D_ENT_ATTRIBUTES_B set
299: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
300: ENTITY_ID = X_ENTITY_ID,
301: DATA_TYPE = X_DATA_TYPE,
302: STATUS = X_STATUS,

Line 344: delete from AMV_D_ENT_ATTRIBUTES_B

340: if (sql%notfound) then
341: raise no_data_found;
342: end if;
343:
344: delete from AMV_D_ENT_ATTRIBUTES_B
345: where ATTRIBUTE_ID = X_ATTRIBUTE_ID;
346:
347: if (sql%notfound) then
348: raise no_data_found;

Line 358: from AMV_D_ENT_ATTRIBUTES_B B

354: begin
355: delete from AMV_D_ENT_ATTRIBUTES_TL T
356: where not exists
357: (select NULL
358: from AMV_D_ENT_ATTRIBUTES_B B
359: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
360: );
361:
362: update AMV_D_ENT_ATTRIBUTES_TL T set (