eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_MEDIA_PVT dependencies on AMS_MEDIA_CHANNELS

Line 16: -- AMS_MEDIA_CHANNELS:

12: -- Check_Media_FK_Items
13: -- Check_Media_Lookup_Items
14: -- Check_Media_Flag_Items
15: --
16: -- AMS_MEDIA_CHANNELS:
17: -- Check_MediaChannel_Req_Items
18: -- Check_MediaChannel_UK_Items
19: -- Check_MediaChannel_FK_Items
20: -- Check_MediaChl_Lookup_Items

Line 1673: SELECT ams_media_channels_s.NEXTVAL

1669: l_dummy NUMBER;
1670: l_return_status VARCHAR2(1);
1671:
1672: CURSOR c_seq IS
1673: SELECT ams_media_channels_s.NEXTVAL
1674: FROM dual;
1675:
1676: CURSOR c_id_exists (x_id IN NUMBER) IS
1677: SELECT 1

Line 1680: FROM ams_media_channels

1676: CURSOR c_id_exists (x_id IN NUMBER) IS
1677: SELECT 1
1678: FROM dual
1679: WHERE EXISTS (SELECT 1
1680: FROM ams_media_channels
1681: WHERE media_channel_id = x_id);
1682:
1683: BEGIN
1684: --------------------- initialize -----------------------

Line 1784: INSERT INTO ams_media_channels (

1780:
1781: AMS_Utility_PVT.debug_message (l_full_name || ': '||l_mediachl_rec.active_to_date);
1782: END IF;
1783:
1784: INSERT INTO ams_media_channels (
1785: media_channel_id,
1786: last_update_date,
1787: last_updated_by,
1788: creation_date,

Line 1984: UPDATE ams_media_channels

1980: END IF;
1981:
1982: -- Modified by ptendulk on 30Dec1999
1983: -- Check Obj Version Number before Updating
1984: UPDATE ams_media_channels
1985: SET
1986: last_update_date = SYSDATE,
1987: last_updated_by = FND_GLOBAL.user_id,
1988: last_update_login = FND_GLOBAL.conc_login_id,

Line 2088: FROM ams_campaigns_all_b A, ams_media_channels B -- Perf fix use all_b

2084: SELECT 1
2085: FROM DUAL
2086: WHERE EXISTS(
2087: SELECT A.campaign_id
2088: FROM ams_campaigns_all_b A, ams_media_channels B -- Perf fix use all_b
2089: WHERE A.active_flag = 'Y'
2090: AND A.arc_channel_from = 'CHLS'
2091: AND A.media_id = B.media_id
2092: AND A.channel_id = B.channel_id

Line 2098: FROM ams_campaign_schedules_b a, ams_media_channels b

2094:
2095: -- Bug fix:2089112. Added by rrajesh on 10/31/01
2096: CURSOR c_check_schedule_association IS
2097: SELECT marketing_medium_id
2098: FROM ams_campaign_schedules_b a, ams_media_channels b
2099: WHERE a.marketing_medium_id = b.channel_id
2100: -- Added by dbiswas 12/31/02 to allow removal of medium from activity
2101: AND a.activity_id = b.media_id
2102: -- end change 12/31/02

Line 2173: DELETE FROM ams_media_channels

2169:
2170: AMS_Utility_PVT.debug_message (l_full_name || ': Delete');
2171: END IF;
2172:
2173: DELETE FROM ams_media_channels
2174: WHERE media_channel_id = p_mediachl_id;
2175:
2176: IF (SQL%NOTFOUND) THEN
2177: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

Line 2269: FROM ams_media_channels

2265: -- and perform comparison in the body and raise the
2266: -- exception there.
2267: CURSOR c_lock IS
2268: SELECT object_version_number
2269: FROM ams_media_channels
2270: WHERE media_channel_id = p_mediachl_id
2271: AND object_version_number = p_object_version
2272: FOR UPDATE NOWAIT;
2273: BEGIN

Line 2716: FROM ams_media_channels

2712: )
2713: IS
2714: CURSOR c_mediachl IS
2715: SELECT *
2716: FROM ams_media_channels
2717: WHERE media_channel_id = p_mediachl_rec.media_channel_id;
2718:
2719: l_mediachl_rec c_mediachl%ROWTYPE;
2720: BEGIN

Line 2824: FROM ams_media_channels

2820: -- soagrawa 15-jan-2002
2821: -- added the following two cursors
2822: CURSOR c_check_uniqueness_create(p_media_id IN NUMBER, p_channel_id IN NUMBER) IS
2823: SELECT count(*)
2824: FROM ams_media_channels
2825: WHERE media_id = p_media_id
2826: AND channel_id = p_channel_id
2827: AND active_from_date <= sysdate
2828: AND (active_to_date IS NULL OR active_to_date > SYSDATE) ;

Line 2832: FROM ams_media_channels

2828: AND (active_to_date IS NULL OR active_to_date > SYSDATE) ;
2829:
2830: CURSOR c_check_uniqueness_update(p_media_id IN NUMBER, p_channel_id IN NUMBER, p_media_channel_id IN NUMBER) IS
2831: SELECT count(*)
2832: FROM ams_media_channels
2833: WHERE media_id = p_media_id
2834: AND channel_id = p_channel_id
2835: AND media_channel_id <> p_media_channel_id
2836: AND active_from_date <= sysdate

Line 2865: 'ams_media_channels',

2861: AMS_Utility_PVT.debug_message('Check_MediaChannel_UK_Items >'||p_mediachl_rec.channel_id);
2862: END IF;
2863: /*
2864: l_valid_flag := AMS_Utility_PVT.check_uniqueness (
2865: 'ams_media_channels',
2866: 'media_id = ' || p_mediachl_rec.media_id
2867: || ' AND channel_id = ' || p_mediachl_rec.channel_id
2868: -- following two where clauses added by soagrawa on 15-jan-2002
2869: -- to keep it consistent with the query in AmsGetChannel.java checkMedChan()

Line 2916: 'ams_media_channels',

2912: -- uniqueness check excludes the current
2913: -- record.
2914: /*
2915: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
2916: 'ams_media_channels',
2917: 'media_id = ' || p_mediachl_rec.media_id
2918: || ' AND channel_id = ' || p_mediachl_rec.channel_id
2919: || ' AND media_channel_id <> ' || p_mediachl_rec.media_channel_id
2920: -- following two where clauses added by soagrawa on 15-jan-2002