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_CAMP_SCHEDULE_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 119: SELECT ams_campaign_schedules_b_s.NEXTVAL

115: l_dummy NUMBER;
116:
117: l_schedule_rec schedule_rec_type := p_schedule_rec ;
118: CURSOR c_id IS
119: SELECT ams_campaign_schedules_b_s.NEXTVAL
120: FROM dual;
121:
122: CURSOR c_id_exists (l_id IN NUMBER) IS
123: SELECT 1 FROM dual

Line 124: WHERE EXISTS (SELECT 1 FROM AMS_CAMPAIGN_SCHEDULES_B

120: FROM dual;
121:
122: CURSOR c_id_exists (l_id IN NUMBER) IS
123: SELECT 1 FROM dual
124: WHERE EXISTS (SELECT 1 FROM AMS_CAMPAIGN_SCHEDULES_B
125: WHERE SCHEDULE_ID = l_id);
126:
127: --CURSOR c_trig_exists (l_schedule_id IN NUMBER) IS
128: -- SELECT 1 FROM dual

Line 129: -- WHERE EXISTS (SELECT 1 FROM ams_campaign_schedules_b

125: WHERE SCHEDULE_ID = l_id);
126:
127: --CURSOR c_trig_exists (l_schedule_id IN NUMBER) IS
128: -- SELECT 1 FROM dual
129: -- WHERE EXISTS (SELECT 1 FROM ams_campaign_schedules_b
130: -- WHERE campaign_id = p_schedule_rec.campaign_id
131: -- AND trigger_id = p_schedule_rec.trigger_id
132: -- AND schedule_id <> l_schedule_id );
133:

Line 410: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Insert_Row)

406:
407: -- Debug Message
408: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler source :'||p_schedule_rec.source_code); END IF;
409:
410: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Insert_Row)
411: AMS_CAMPAIGN_SCHEDULES_B_PKG.Insert_Row(
412: px_schedule_id => l_schedule_id,
413: -- modified by soagrawa on 12-jun-2002 for ATT bug# 2376329
414: p_last_update_date => SYSDATE,

Line 411: AMS_CAMPAIGN_SCHEDULES_B_PKG.Insert_Row(

407: -- Debug Message
408: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler source :'||p_schedule_rec.source_code); END IF;
409:
410: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Insert_Row)
411: AMS_CAMPAIGN_SCHEDULES_B_PKG.Insert_Row(
412: px_schedule_id => l_schedule_id,
413: -- modified by soagrawa on 12-jun-2002 for ATT bug# 2376329
414: p_last_update_date => SYSDATE,
415: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 783: FROM ams_campaign_schedules_b

779: -- Start: added by anchaudh for trigger related validation on 27-jun-2003.
780: CURSOR c_get_trig_schedule_details(schedule_id IN NUMBER) IS
781: SELECT status_code, triggerable_flag, trigger_id,
782: trig_repeat_flag, tgrp_exclude_prev_flag, activity_type_code
783: FROM ams_campaign_schedules_b
784: WHERE schedule_id = p_schedule_rec.schedule_id ;
785: -- End: added by anchaudh for trigger related validation on 27-jun-2003.
786:
787: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Camp_Schedule';

Line 1202: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Update_Row)

1198:
1199: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler sched : '||to_char(p_schedule_rec.schedule_id));
1200: END IF;
1201:
1202: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Update_Row)
1203: AMS_CAMPAIGN_SCHEDULES_B_PKG.Update_Row(
1204: p_schedule_id => p_schedule_rec.schedule_id,
1205: p_last_update_date => SYSDATE,
1206: p_last_updated_by => G_USER_ID,

Line 1203: AMS_CAMPAIGN_SCHEDULES_B_PKG.Update_Row(

1199: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler sched : '||to_char(p_schedule_rec.schedule_id));
1200: END IF;
1201:
1202: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Update_Row)
1203: AMS_CAMPAIGN_SCHEDULES_B_PKG.Update_Row(
1204: p_schedule_id => p_schedule_rec.schedule_id,
1205: p_last_update_date => SYSDATE,
1206: p_last_updated_by => G_USER_ID,
1207: p_creation_date => SYSDATE,

Line 1475: FROM ams_campaign_schedules_b

1471: l_object_version_number NUMBER;
1472:
1473: CURSOR c_camp_schedule IS
1474: SELECT campaign_id, schedule_id, status_code,use_parent_code_flag,source_code
1475: FROM ams_campaign_schedules_b
1476: WHERE schedule_id = p_schedule_id
1477: AND object_version_number = p_object_version_number ;
1478:
1479: l_schedule_id NUMBER;

Line 1488: FROM ams_campaign_schedules_b

1484: l_source_code VARCHAR2(30);
1485:
1486: CURSOR c_camp IS
1487: SELECT 1
1488: FROM ams_campaign_schedules_b
1489: WHERE campaign_id = l_campaign_id
1490: AND active_flag = 'Y' ;
1491:
1492:

Line 1540: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Delete_Row)

1536: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1537: END IF;
1538:
1539: -- Delete schedule only if the status is new.
1540: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Delete_Row)
1541: IF l_status_code = 'NEW' THEN
1542: AMS_CAMPAIGN_SCHEDULES_B_PKG.Delete_Row(p_schedule_id => p_schedule_id);
1543: ELSE
1544: UPDATE ams_campaign_schedules_b

Line 1542: AMS_CAMPAIGN_SCHEDULES_B_PKG.Delete_Row(p_schedule_id => p_schedule_id);

1538:
1539: -- Delete schedule only if the status is new.
1540: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Delete_Row)
1541: IF l_status_code = 'NEW' THEN
1542: AMS_CAMPAIGN_SCHEDULES_B_PKG.Delete_Row(p_schedule_id => p_schedule_id);
1543: ELSE
1544: UPDATE ams_campaign_schedules_b
1545: SET object_version_number = object_version_number + 1 ,
1546: active_flag = 'N'

Line 1544: UPDATE ams_campaign_schedules_b

1540: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Delete_Row)
1541: IF l_status_code = 'NEW' THEN
1542: AMS_CAMPAIGN_SCHEDULES_B_PKG.Delete_Row(p_schedule_id => p_schedule_id);
1543: ELSE
1544: UPDATE ams_campaign_schedules_b
1545: SET object_version_number = object_version_number + 1 ,
1546: active_flag = 'N'
1547: WHERE schedule_id = p_schedule_id
1548: AND object_version_number = p_object_version_number ;

Line 1668: FROM AMS_CAMPAIGN_SCHEDULES_B

1664: l_SCHEDULE_ID NUMBER;
1665:
1666: CURSOR c_Camp_Schedule IS
1667: SELECT SCHEDULE_ID
1668: FROM AMS_CAMPAIGN_SCHEDULES_B
1669: WHERE SCHEDULE_ID = p_SCHEDULE_ID
1670: AND object_version_number = p_object_version
1671: FOR UPDATE NOWAIT;
1672: BEGIN

Line 1793: 'ams_campaign_schedules_b',

1789: x_return_status := FND_API.g_ret_sts_success;
1790:
1791: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1792: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1793: 'ams_campaign_schedules_b',
1794: 'schedule_id = ' || p_schedule_rec.schedule_id
1795: );
1796: IF l_valid_flag = FND_API.g_false THEN
1797: AMS_Utility_PVT.Error_Message('AMS_CSCH_ID_DUPLICATE');

Line 1806: 'ams_campaign_schedules_b',

1802:
1803: -- added by soagrawa on 11-jan-2002
1804: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1805: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1806: 'ams_campaign_schedules_b',
1807: 'related_event_id = ' || p_schedule_rec.related_event_id
1808: );
1809: IF l_valid_flag = FND_API.g_false THEN
1810: AMS_Utility_PVT.Error_Message('AMS_EVO_DUPLICATE_ID');