APPS.AMS_MEDIA_PVT dependencies on AMS_MEDIA_B

Line 188: SELECT ams_media_b_s.NEXTVAL

184: l_dummy NUMBER;
185: l_return_status VARCHAR2(1);
186:
187: CURSOR c_seq IS
188: SELECT ams_media_b_s.NEXTVAL
189: FROM dual;
190:
191: CURSOR c_id_exists (x_id IN NUMBER) IS
192: SELECT 1

Line 195: FROM ams_media_b

191: CURSOR c_id_exists (x_id IN NUMBER) IS
192: SELECT 1
193: FROM dual
194: WHERE EXISTS (SELECT 1
195: FROM ams_media_b
196: WHERE media_id = x_id);
197:
198: BEGIN
199: --------------------- initialize -----------------------

Line 313: INSERT INTO ams_media_b (

309:
310: --
311: -- Insert into mutli-language supported table.
312: --
313: INSERT INTO ams_media_b (
314: media_id,
315:
316: -- standard who columns
317: last_update_date,

Line 582: UPDATE ams_media_b

578: END IF;
579:
580: -- Modified by ptendulk on 30Dec1999
581: -- Check Obj Version Number before Updating
582: UPDATE ams_media_b
583: SET
584: last_update_date = SYSDATE,
585: last_updated_by = FND_GLOBAL.User_Id,
586: last_update_login = FND_GLOBAL.Conc_Login_Id,

Line 822: DELETE FROM ams_media_b

818: END IF;
819: RAISE FND_API.g_exc_error;
820: END IF;
821:
822: DELETE FROM ams_media_b
823: WHERE media_id = p_media_id
824: AND object_version_number = p_object_version;
825:
826: -------------------- finish --------------------------

Line 912: FROM ams_media_b

908: -- and perform comparison in the body and raise the
909: -- exception there.
910: CURSOR c_lock IS
911: SELECT object_version_number
912: FROM ams_media_b
913: WHERE media_id = p_media_id
914: AND object_version_number = p_object_version
915: FOR UPDATE NOWAIT;
916: BEGIN

Line 1501: 'ams_media_b',

1497: IF p_validation_mode = JTF_PLSQL_API.g_create
1498: AND p_media_rec.media_id IS NOT NULL
1499: THEN
1500: IF AMS_Utility_PVT.check_uniqueness(
1501: 'ams_media_b',
1502: 'media_id = ' || p_media_rec.media_id
1503: ) = FND_API.g_false
1504: THEN
1505: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

Line 2968: 'ams_media_b',

2964: --
2965: -- MEDIA_ID
2966: IF p_mediachl_rec.media_id <> FND_API.g_miss_num THEN
2967: IF AMS_Utility_PVT.check_fk_exists (
2968: 'ams_media_b',
2969: 'media_id',
2970: p_mediachl_rec.media_id
2971: ) = FND_API.g_false
2972: THEN