APPS.AMS_CAMPAIGNRULES_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 323: FROM ams_campaign_schedules_b

319: SELECT 1
320: FROM DUAL
321: WHERE EXISTS(
322: SELECT 1
323: FROM ams_campaign_schedules_b
324: WHERE campaign_id = p_campaign_id
325: AND active_flag = 'Y'
326: AND use_parent_code_flag = 'Y' );
327:

Line 1845: FROM ams_campaign_schedules_b

1841:
1842: CURSOR c_csch IS
1843: SELECT start_date_time AS start_date,
1844: end_date_time AS end_date
1845: FROM ams_campaign_schedules_b
1846: WHERE campaign_id = p_camp_id
1847: -- Following line of code is added by ptendulk on 25-May-2001
1848: AND active_flag = 'Y' ;
1849:

Line 3432: FROM ams_campaign_schedules_b

3428: ) IS
3429:
3430: CURSOR c_schedule IS
3431: SELECT schedule_id , object_version_number
3432: FROM ams_campaign_schedules_b
3433: WHERE campaign_id = p_campaign_id
3434: AND (status_code = 'COMPLETED' OR status_code = 'CANCELLED') ;
3435:
3436: l_schedule_id NUMBER ;

Line 3447: UPDATE ams_campaign_schedules_b

3443: LOOP
3444: FETCH c_schedule INTO l_schedule_id, l_obj_version;
3445: EXIT WHEN c_schedule%NOTFOUND ;
3446:
3447: UPDATE ams_campaign_schedules_b
3448: SET status_code = 'ARCHIVED',
3449: user_status_id = l_user_status_id ,
3450: status_date = SYSDATE ,
3451: object_version_number = l_obj_version + 1

Line 3686: FROM ams_campaign_schedules_b

3682: PROCEDURE Cancel_Schedule(p_campaign_id IN NUMBER) IS
3683:
3684: CURSOR c_schedule IS
3685: SELECT schedule_id,object_version_number,status_code
3686: FROM ams_campaign_schedules_b
3687: WHERE campaign_id = p_campaign_id
3688: AND status_code <> 'CANCELLED' ;
3689:
3690: l_schedule_id NUMBER ;

Line 3703: UPDATE ams_campaign_schedules_b

3699: FETCH c_schedule INTO l_schedule_id,l_obj_version,l_status_code ;
3700: EXIT WHEN c_schedule%NOTFOUND ;
3701: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_CAMPAIGN_SCHEDULE_STATUS',l_status_code,'CANCELLED') THEN
3702: -- Can cancel the schedule
3703: UPDATE ams_campaign_schedules_b
3704: SET status_code = 'CANCELLED',
3705: status_date = SYSDATE,
3706: user_status_id = l_status_id,
3707: object_version_number = object_version_number + 1

Line 3734: FROM ams_campaign_schedules_b

3730: PROCEDURE Cancel_Schedule(p_campaign_id IN NUMBER) IS
3731:
3732: CURSOR c_schedule IS
3733: SELECT count(*)
3734: FROM ams_campaign_schedules_b
3735: WHERE campaign_id = p_campaign_id
3736: AND status_code <> 'CANCELLED'
3737: AND status_code <> 'ARCHIVED';
3738:

Line 3962: FROM ams_campaign_schedules_b

3958:
3959: CURSOR c_schedule IS
3960: -- soagrawa added columns to this cursor on 15-may-2003 for bug# 2962164
3961: SELECT schedule_id,object_version_number,status_code, activity_type_code, related_event_id, source_code
3962: FROM ams_campaign_schedules_b
3963: WHERE campaign_id = p_campaign_id
3964: -- asaha added more status check for bug 3142886
3965: AND status_code NOT IN ('COMPLETED','CANCELLED','CLOSED','ARCHIVED') ;
3966:

Line 3970: FROM ams_campaign_schedules_b

3966:
3967: -- new cursor created by asaha for bug 3132886
3968: CURSOR c_completed_schedule IS
3969: SELECT count(*)
3970: FROM ams_campaign_schedules_b
3971: WHERE campaign_id = p_campaign_id
3972: AND status_code IN ('COMPLETED','CLOSED') ;
3973:
3974: -- mayjain 11-Oct-2005 Bug 4401237

Line 3977: FROM ams_campaign_schedules_b

3973:
3974: -- mayjain 11-Oct-2005 Bug 4401237
3975: CURSOR c_no_of_schedules IS
3976: SELECT count(1)
3977: FROM ams_campaign_schedules_b
3978: WHERE campaign_id = p_campaign_id ;
3979:
3980: l_schedule_id NUMBER ;
3981: l_obj_version NUMBER ;

Line 4006: UPDATE ams_campaign_schedules_b

4002: AMS_Utility_PVT.debug_message('MAYANK: l_obj_version is *' || l_obj_version ||'*');
4003: END IF;
4004:
4005: -- Can complete the schedule
4006: UPDATE ams_campaign_schedules_b
4007: SET status_code = 'COMPLETED',
4008: status_date = SYSDATE,
4009: user_status_id = l_status_id,
4010: object_version_number = object_version_number + 1

Line 4384: FROM ams_campaign_schedules_b

4380: PROCEDURE Check_Close_Campaign(p_campaign_id IN NUMBER) IS
4381:
4382: CURSOR c_no_of_open_schedules IS
4383: SELECT count(1)
4384: FROM ams_campaign_schedules_b
4385: WHERE campaign_id = p_campaign_id
4386: AND status_code IN ('ACTIVE','AVAILABLE');
4387:
4388: l_no_open_scheds NUMBER;