3787: l_evh_rec evh_rec_type;
3788: l_system_status_code p_evh_rec.system_status_code%TYPE ;
3789:
3790: CURSOR c_program IS
3791: SELECT status_code FROM ams_campaigns_v
3792: WHERE campaign_id = p_evh_rec.program_id;
3793:
3794: BEGIN
3795: x_return_status := FND_API.g_ret_sts_success;
3830: l_start_date DATE;
3831: l_end_date DATE;
3832:
3833: CURSOR c_program IS
3834: SELECT actual_exec_start_date , actual_exec_end_date FROM ams_campaigns_vl
3835: WHERE campaign_id = p_evh_rec.program_id;
3836:
3837: CURSOR c_eveo IS
3838: SELECT event_start_date AS start_date,