APPS.AMV_D_ENTITIES_PKG dependencies on AMV_D_ENTITIES_B

Line 95: cursor C is select ROWID from AMV_D_ENTITIES_B

91: X_LAST_UPDATE_DATE in DATE,
92: X_LAST_UPDATED_BY in NUMBER,
93: X_LAST_UPDATE_LOGIN in NUMBER
94: ) is
95: cursor C is select ROWID from AMV_D_ENTITIES_B
96: where ENTITY_ID = X_ENTITY_ID
97: ;
98: begin
99: insert into AMV_D_ENTITIES_B (

Line 99: insert into AMV_D_ENTITIES_B (

95: cursor C is select ROWID from AMV_D_ENTITIES_B
96: where ENTITY_ID = X_ENTITY_ID
97: ;
98: begin
99: insert into AMV_D_ENTITIES_B (
100: ENTITY_ID,
101: OBJECT_VERSION_NUMBER,
102: APPLICATION_ID,
103: STATUS,

Line 181: from AMV_D_ENTITIES_B

177: APPLICATION_ID,
178: STATUS,
179: TABLE_NAME,
180: USAGE_INDICATOR
181: from AMV_D_ENTITIES_B
182: where ENTITY_ID = X_ENTITY_ID
183: for update of ENTITY_ID nowait;
184: recinfo c%rowtype;
185:

Line 245: update AMV_D_ENTITIES_B set

241: X_LAST_UPDATED_BY in NUMBER,
242: X_LAST_UPDATE_LOGIN in NUMBER
243: ) is
244: begin
245: update AMV_D_ENTITIES_B set
246: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
247: APPLICATION_ID = X_APPLICATION_ID,
248: STATUS = X_STATUS,
249: TABLE_NAME = X_TABLE_NAME,

Line 286: delete from AMV_D_ENTITIES_B

282: if (sql%notfound) then
283: raise no_data_found;
284: end if;
285:
286: delete from AMV_D_ENTITIES_B
287: where ENTITY_ID = X_ENTITY_ID;
288:
289: if (sql%notfound) then
290: raise no_data_found;

Line 300: from AMV_D_ENTITIES_B B

296: begin
297: delete from AMV_D_ENTITIES_TL T
298: where not exists
299: (select NULL
300: from AMV_D_ENTITIES_B B
301: where B.ENTITY_ID = T.ENTITY_ID
302: );
303:
304: update AMV_D_ENTITIES_TL T set (