APPS.AMS_MEDIA_PKG dependencies on AMS_MEDIA_B

Line 35: cursor C is select ROWID from AMS_MEDIA_B

31: X_LAST_UPDATE_DATE in DATE,
32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is select ROWID from AMS_MEDIA_B
36: where MEDIA_ID = X_MEDIA_ID
37: ;
38: begin
39: insert into AMS_MEDIA_B (

Line 39: insert into AMS_MEDIA_B (

35: cursor C is select ROWID from AMS_MEDIA_B
36: where MEDIA_ID = X_MEDIA_ID
37: ;
38: begin
39: insert into AMS_MEDIA_B (
40: MEDIA_ID,
41: OBJECT_VERSION_NUMBER,
42: MEDIA_TYPE_CODE,
43: INBOUND_FLAG,

Line 167: update AMS_MEDIA_B set

163: X_LAST_UPDATED_BY in NUMBER,
164: X_LAST_UPDATE_LOGIN in NUMBER
165: ) is
166: begin
167: update AMS_MEDIA_B set
168: -- OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER ,
169: MEDIA_TYPE_CODE = X_MEDIA_TYPE_CODE,
170: INBOUND_FLAG = X_INBOUND_FLAG
171: -- removed by soagrawa for bug# 2740393 on 08-jan-2003

Line 234: delete from AMS_MEDIA_B

230: if (sql%notfound) then
231: raise no_data_found;
232: end if;
233:
234: delete from AMS_MEDIA_B
235: where MEDIA_ID = X_MEDIA_ID;
236:
237: if (sql%notfound) then
238: raise no_data_found;

Line 248: from AMS_MEDIA_B B

244: begin
245: delete from AMS_MEDIA_TL T
246: where not exists
247: (select NULL
248: from AMS_MEDIA_B B
249: where B.MEDIA_ID = T.MEDIA_ID
250: );
251:
252: update AMS_MEDIA_TL T set (

Line 363: from AMS_MEDIA_B

359: l_db_luby_id NUMBER;
360:
361: cursor c_db_data_details is
362: select last_updated_by, nvl(object_version_number,1)
363: from AMS_MEDIA_B
364: where media_id = X_MEDIA_ID;
365:
366: cursor c_chk_mda_exists is
367: select 'x'

Line 368: from AMS_MEDIA_B

364: where media_id = X_MEDIA_ID;
365:
366: cursor c_chk_mda_exists is
367: select 'x'
368: from AMS_MEDIA_B
369: where media_id = X_MEDIA_ID;
370:
371: cursor c_get_mdaid is
372: select AMS_MEDIA_B_S.nextval

Line 372: select AMS_MEDIA_B_S.nextval

368: from AMS_MEDIA_B
369: where media_id = X_MEDIA_ID;
370:
371: cursor c_get_mdaid is
372: select AMS_MEDIA_B_S.nextval
373: from dual;
374:
375: BEGIN
376: