DBA Data[Home] [Help]

APPS.AMS_MEDIA_PKG dependencies on AMS_MEDIA_PKG

Line 1: package body AMS_MEDIA_PKG as

1: package body AMS_MEDIA_PKG as
2: /* $Header: amslmdab.pls 115.8 2004/01/30 01:38:34 asaha ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_MEDIA_ID in NUMBER,

Line 395: AMS_MEDIA_PKG.INSERT_ROW(

391: else
392: l_media_id := X_MEDIA_ID;
393: end if;
394: l_obj_verno := 1;
395: AMS_MEDIA_PKG.INSERT_ROW(
396: X_ROWID => l_row_id,
397: X_MEDIA_ID => l_media_id,
398: X_OBJECT_VERSION_NUMBER => l_obj_verno,
399: X_MEDIA_TYPE_CODE => X_MEDIA_TYPE_CODE,

Line 434: AMS_MEDIA_PKG.UPDATE_ROW(

430: fetch c_db_data_details into l_db_luby_id,l_obj_verno;
431: close c_db_data_details;
432:
433: if ( l_db_luby_id IN (1, 2, 0)) then
434: AMS_MEDIA_PKG.UPDATE_ROW(
435: X_MEDIA_ID => X_MEDIA_ID,
436: X_OBJECT_VERSION_NUMBER => l_obj_verno + 1,
437: X_MEDIA_TYPE_CODE => X_MEDIA_TYPE_CODE,
438: X_INBOUND_FLAG => X_INBOUND_FLAG,

Line 467: end AMS_MEDIA_PKG;

463: end if;
464: end if;
465: END LOAD_ROW;
466:
467: end AMS_MEDIA_PKG;