DBA Data[Home] [Help]

APPS.AMS_WFTRIG_PVT dependencies on STANDARD

Line 939: -- This Procedure will perform the check on standard item and Comparison Item

935: -- NAME
936: -- Perform_Check
937: --
938: -- PURPOSE
939: -- This Procedure will perform the check on standard item and Comparison Item
940: -- with the operator provided
941: -- It will Return - Success if the check is successful
942: -- - Failure If the check is not successful
943: -- - Error If there is an error in the Check Process

Line 3392: SELECT event_offer_name, 'STANDARD', owner_user_id

3388: FROM ams_campaign_schedules_vl
3389: WHERE schedule_id = l_trig_rec.trigger_created_for_id ;
3390:
3391: CURSOR c_eveo_eone_det IS
3392: SELECT event_offer_name, 'STANDARD', owner_user_id
3393: FROM ams_event_offers_vl
3394: WHERE event_offer_id = l_trig_rec.trigger_created_for_id ;
3395:
3396: CURSOR c_eveh_det IS

Line 3397: SELECT event_header_name, 'STANDARD', owner_user_id

3393: FROM ams_event_offers_vl
3394: WHERE event_offer_id = l_trig_rec.trigger_created_for_id ;
3395:
3396: CURSOR c_eveh_det IS
3397: SELECT event_header_name, 'STANDARD', owner_user_id
3398: FROM ams_event_headers_vl
3399: WHERE event_header_id = l_trig_rec.trigger_created_for_id ;
3400:
3401: l_monitor_obj_name VARCHAR2(240);

Line 3598: IF l_monitor_obj_priority = 'STANDARD' THEN

3594: OPEN c_timeout_det;
3595: FETCH c_timeout_det INTO l_timeout_rec ;
3596: CLOSE c_timeout_det ;
3597:
3598: IF l_monitor_obj_priority = 'STANDARD' THEN
3599: l_timeout_days := l_timeout_rec.timeout_days_std_prio ;
3600: l_priority := 50 ; -- Standard
3601: ELSIF l_monitor_obj_priority = 'LOW' THEN
3602: l_timeout_days := l_timeout_rec.timeout_days_low_prio ;

Line 3600: l_priority := 50 ; -- Standard

3596: CLOSE c_timeout_det ;
3597:
3598: IF l_monitor_obj_priority = 'STANDARD' THEN
3599: l_timeout_days := l_timeout_rec.timeout_days_std_prio ;
3600: l_priority := 50 ; -- Standard
3601: ELSIF l_monitor_obj_priority = 'LOW' THEN
3602: l_timeout_days := l_timeout_rec.timeout_days_low_prio ;
3603: l_priority := 99 ; -- Low
3604: ELSIF l_monitor_obj_priority = 'HIGH' THEN

Line 3609: l_priority := 50 ; -- standard

3605: l_timeout_days := l_timeout_rec.timeout_days_high_prio ;
3606: l_priority := 1 ; -- High
3607: ELSIF l_monitor_obj_priority = 'MEDIUM' THEN
3608: l_timeout_days := l_timeout_rec.timeout_days_medium_prio ;
3609: l_priority := 50 ; -- standard
3610: ELSE
3611: l_timeout_days := l_timeout_rec.timeout_days_medium_prio ;
3612: l_priority := 50 ; -- standard
3613: END IF;

Line 3612: l_priority := 50 ; -- standard

3608: l_timeout_days := l_timeout_rec.timeout_days_medium_prio ;
3609: l_priority := 50 ; -- standard
3610: ELSE
3611: l_timeout_days := l_timeout_rec.timeout_days_medium_prio ;
3612: l_priority := 50 ; -- standard
3613: END IF;
3614:
3615:
3616: WF_ENGINE.SetItemAttrText(itemtype => itemtype,