APPS.AMS_MEDIA_PVT dependencies on AMS_MEDIA_VL

Line 9: -- AMS_MEDIA_VL:

5: -- PACKAGE
6: -- AMS_Media_PVT
7: --
8: -- PROCEDURES
9: -- AMS_MEDIA_VL:
10: -- Check_Media_Req_Items
11: -- Check_Media_UK_Items
12: -- Check_Media_FK_Items
13: -- Check_Media_Lookup_Items

Line 1285: FROM ams_media_vl

1281: )
1282: IS
1283: CURSOR c_media IS
1284: SELECT *
1285: FROM ams_media_vl
1286: WHERE media_id = p_media_rec.media_id;
1287: --
1288: -- This is the only exception for using %ROWTYPE.
1289: -- We are selecting from the VL view, which may

Line 1480: FROM ams_media_vl

1476: l_count NUMBER ;
1477:
1478: CURSOR c_name_unique_cr (p_media_name IN VARCHAR2) IS
1479: SELECT COUNT(1)
1480: FROM ams_media_vl
1481: WHERE UPPER(media_name) = UPPER(p_media_name) ;
1482:
1483: CURSOR c_name_unique_up (p_media_name IN VARCHAR2, p_media_id IN NUMBER) IS
1484: SELECT COUNT(1)

Line 1485: FROM ams_media_vl

1481: WHERE UPPER(media_name) = UPPER(p_media_name) ;
1482:
1483: CURSOR c_name_unique_up (p_media_name IN VARCHAR2, p_media_id IN NUMBER) IS
1484: SELECT COUNT(1)
1485: FROM ams_media_vl
1486: WHERE UPPER(media_name) = UPPER(p_media_name)
1487: AND media_id <> p_media_id ;
1488: -- end 11/07
1489:

Line 1524: -- 'ams_media_vl',

1520: FETCH c_name_unique_cr INTO l_count ;
1521: CLOSE c_name_unique_cr ;
1522:
1523: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness (
1524: -- 'ams_media_vl',
1525: -- 'media_name = ''' || p_media_rec.media_name || ''''
1526: -- );
1527: ELSE
1528: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness (

Line 1529: -- 'ams_media_vl',

1525: -- 'media_name = ''' || p_media_rec.media_name || ''''
1526: -- );
1527: ELSE
1528: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness (
1529: -- 'ams_media_vl',
1530: -- 'media_name = ''' || p_media_rec.media_name ||
1531: -- ''' AND media_id <> ' || p_media_rec.media_id
1532: -- );
1533: OPEN c_name_unique_up(p_media_rec.media_name,p_media_rec.media_id) ;