APPS.AMV_I_CONTENT_TYPES_PKG dependencies on AMV_I_CONTENT_TYPES_B

Line 76: cursor C is select ROWID from AMV_I_CONTENT_TYPES_B

72: X_LAST_UPDATE_DATE in DATE,
73: X_LAST_UPDATED_BY in NUMBER,
74: X_LAST_UPDATE_LOGIN in NUMBER
75: ) is
76: cursor C is select ROWID from AMV_I_CONTENT_TYPES_B
77: where CONTENT_TYPE_ID = X_CONTENT_TYPE_ID
78: ;
79: begin
80: insert into AMV_I_CONTENT_TYPES_B (

Line 80: insert into AMV_I_CONTENT_TYPES_B (

76: cursor C is select ROWID from AMV_I_CONTENT_TYPES_B
77: where CONTENT_TYPE_ID = X_CONTENT_TYPE_ID
78: ;
79: begin
80: insert into AMV_I_CONTENT_TYPES_B (
81: CONTENT_TYPE_ID,
82: OBJECT_VERSION_NUMBER,
83: CREATION_DATE,
84: CREATED_BY,

Line 146: from AMV_I_CONTENT_TYPES_B

142: X_DESCRIPTION in VARCHAR2
143: ) is
144: cursor c is select
145: OBJECT_VERSION_NUMBER
146: from AMV_I_CONTENT_TYPES_B
147: where CONTENT_TYPE_ID = X_CONTENT_TYPE_ID
148: for update of CONTENT_TYPE_ID nowait;
149: recinfo c%rowtype;
150:

Line 202: update AMV_I_CONTENT_TYPES_B set

198: X_LAST_UPDATED_BY in NUMBER,
199: X_LAST_UPDATE_LOGIN in NUMBER
200: ) is
201: begin
202: update AMV_I_CONTENT_TYPES_B set
203: OBJECT_VERSION_NUMBER = decode(X_OBJECT_VERSION_NUMBER,
204: FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER + 1,
205: X_OBJECT_VERSION_NUMBER),
206: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 245: delete from AMV_I_CONTENT_TYPES_B

241: if (sql%notfound) then
242: raise no_data_found;
243: end if;
244:
245: delete from AMV_I_CONTENT_TYPES_B
246: where CONTENT_TYPE_ID = X_CONTENT_TYPE_ID;
247:
248: if (sql%notfound) then
249: raise no_data_found;

Line 259: from AMV_I_CONTENT_TYPES_B B

255: begin
256: delete from AMV_I_CONTENT_TYPES_TL T
257: where not exists
258: (select NULL
259: from AMV_I_CONTENT_TYPES_B B
260: where B.CONTENT_TYPE_ID = T.CONTENT_TYPE_ID
261: );
262:
263: update AMV_I_CONTENT_TYPES_TL T set (