APPS.AMV_I_PERSPECTIVES_PKG dependencies on AMV_I_PERSPECTIVES_B

Line 75: cursor C is select ROWID from AMV_I_PERSPECTIVES_B

71: X_LAST_UPDATE_DATE in DATE,
72: X_LAST_UPDATED_BY in NUMBER,
73: X_LAST_UPDATE_LOGIN in NUMBER
74: ) is
75: cursor C is select ROWID from AMV_I_PERSPECTIVES_B
76: where PERSPECTIVE_ID = X_PERSPECTIVE_ID
77: ;
78: begin
79: insert into AMV_I_PERSPECTIVES_B (

Line 79: insert into AMV_I_PERSPECTIVES_B (

75: cursor C is select ROWID from AMV_I_PERSPECTIVES_B
76: where PERSPECTIVE_ID = X_PERSPECTIVE_ID
77: ;
78: begin
79: insert into AMV_I_PERSPECTIVES_B (
80: PERSPECTIVE_ID,
81: OBJECT_VERSION_NUMBER,
82: CREATION_DATE,
83: CREATED_BY,

Line 145: from AMV_I_PERSPECTIVES_B

141: X_DESCRIPTION in VARCHAR2
142: ) is
143: cursor c is
144: select OBJECT_VERSION_NUMBER
145: from AMV_I_PERSPECTIVES_B
146: where PERSPECTIVE_ID = X_PERSPECTIVE_ID
147: for update of PERSPECTIVE_ID nowait;
148: recinfo c%rowtype;
149:

Line 200: update AMV_I_PERSPECTIVES_B set

196: X_LAST_UPDATE_LOGIN in NUMBER
197: ) is
198: l_sql_statement VARCHAR2(2000);
199: begin
200: update AMV_I_PERSPECTIVES_B set
201: OBJECT_VERSION_NUMBER = decode(X_OBJECT_VERSION_NUMBER,
202: FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER + 1,
203: X_OBJECT_VERSION_NUMBER),
204: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 244: delete from AMV_I_PERSPECTIVES_B

240: if (sql%notfound) then
241: raise no_data_found;
242: end if;
243:
244: delete from AMV_I_PERSPECTIVES_B
245: where PERSPECTIVE_ID = X_PERSPECTIVE_ID;
246:
247: if (sql%notfound) then
248: raise no_data_found;

Line 258: from AMV_I_PERSPECTIVES_B B

254: begin
255: delete from AMV_I_PERSPECTIVES_TL T
256: where not exists
257: (select NULL
258: from AMV_I_PERSPECTIVES_B B
259: where B.PERSPECTIVE_ID = T.PERSPECTIVE_ID
260: );
261:
262: update AMV_I_PERSPECTIVES_TL T set (