APPS.AMS_CAMP_SCHEDULE_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_VL

Line 776: FROM ams_campaign_schedules_vl

772: IS
773:
774: CURSOR c_get_camp_schedule(schedule_id IN NUMBER) IS
775: SELECT *
776: FROM ams_campaign_schedules_vl
777: WHERE schedule_id = p_schedule_rec.schedule_id ;
778:
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

Line 2503: FROM ams_campaign_schedules_vl

2499: )
2500: IS
2501: CURSOR c_schedule IS
2502: SELECT *
2503: FROM ams_campaign_schedules_vl
2504: WHERE schedule_id = p_schedule_rec.schedule_id;
2505:
2506: l_schedule_rec c_schedule%ROWTYPE;
2507:

Line 3224: FROM ams_campaign_schedules_vl

3220:
3221: CURSOR c_sch_name IS
3222: SELECT 1 from dual
3223: WHERE EXISTS (SELECT *
3224: FROM ams_campaign_schedules_vl
3225: WHERE campaign_id = p_complete_rec.campaign_id
3226: AND UPPER(schedule_name) = UPPER(p_complete_rec.schedule_name)) ;
3227:
3228: CURSOR c_sch_name_updt IS

Line 3231: FROM ams_campaign_schedules_vl

3227:
3228: CURSOR c_sch_name_updt IS
3229: SELECT 1 from dual
3230: WHERE EXISTS (SELECT *
3231: FROM ams_campaign_schedules_vl
3232: WHERE campaign_id = p_complete_rec.campaign_id
3233: AND UPPER(schedule_name) = UPPER(p_complete_rec.schedule_name)
3234: AND schedule_id <> p_complete_rec.schedule_id ) ;
3235: l_dummy NUMBER ;

Line 3385: --l_table_name := 'ams_campaign_schedules_vl' ;

3381: -- Check Schedule_Name
3382: IF p_schedule_rec.campaign_id <> FND_API.g_miss_num OR
3383: p_schedule_rec.schedule_name <> FND_API.g_miss_char
3384: THEN
3385: --l_table_name := 'ams_campaign_schedules_vl' ;
3386: --l_where_clause := 'campaign_id = '||p_complete_rec.campaign_id ;
3387: --l_where_clause := l_where_clause || ' AND UPPER(schedule_name) = '''||UPPER(p_complete_rec.schedule_name)||'''' ;
3388:
3389: --IF p_validation_mode = JTF_PLSQL_API.g_update THEN

Line 3742: FROM ams_campaign_schedules_vl

3738: security_group_id,
3739: schedule_name,
3740: description,
3741: null,null,NULL --related source stuff
3742: FROM ams_campaign_schedules_vl
3743: WHERE schedule_id = sch_id;
3744: */
3745: CURSOR fetch_sch_details (sch_id NUMBER) IS
3746: SELECT * FROM ams_campaign_schedules_vl

Line 3746: SELECT * FROM ams_campaign_schedules_vl

3742: FROM ams_campaign_schedules_vl
3743: WHERE schedule_id = sch_id;
3744: */
3745: CURSOR fetch_sch_details (sch_id NUMBER) IS
3746: SELECT * FROM ams_campaign_schedules_vl
3747: WHERE schedule_id = sch_id ;
3748:
3749: CURSOR fetch_event_details (event_id NUMBER) IS
3750: SELECT * FROM ams_event_offers_vl