APPS.AMS_WFTRIG_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 68

    SELECT  owner_user_id
    FROM    ams_campaigns_vl
    WHERE   campaign_id = p_activity_id ;

Line: 73

    SELECT  owner_user_id
    FROM    ams_campaign_schedules_vl
    WHERE   schedule_id = p_activity_id ;

Line: 78

    SELECT  owner_user_id
    FROM    ams_deliverables_vl
    WHERE   deliverable_id = p_activity_id ;

Line: 83

    SELECT  owner_user_id
    FROM    ams_event_headers_vl
    WHERE   event_header_id = p_activity_id ;

Line: 88

    SELECT  owner_user_id
    FROM    ams_event_offers_vl
    WHERE   event_offer_id = p_activity_id ;

Line: 93

    SELECT employee_id
    FROM   ams_jtf_rs_emp_v
    WHERE  resource_id = l_res_id ;

Line: 260

    SELECT  meaning
    FROM    ams_lookups
    WHERE   lookup_type = 'AMS_TRIGGER_ACTION_TYPE'
    AND     lookup_code = p_lookup_code
    AND     enabled_flag = 'Y' ;

Line: 386

        UPDATE  ams_triggers
        SET     process_id = TO_NUMBER(itemkey)
        WHERE   trigger_id = p_trigger_id ;

Line: 434

PROCEDURE Selector( itemtype    IN      VARCHAR2,
                    itemkey     IN      VARCHAR2,
                    actid       IN      NUMBER,
                    funcmode    IN      VARCHAR2,
                    resultout   OUT NOCOPY     VARCHAR2
                    )
  IS
   -- PL/SQL Block
  BEGIN
-- dbms_output.put_line('In Selector Function');

Line: 470

         wf_core.context (G_PKG_NAME, 'Selector', itemtype, itemkey, actid, funcmode);

Line: 472

   END Selector;

Line: 608

   SELECT  *
   FROM    ams_triggers
   WHERE   trigger_id  = l_my_trigger_id ;

Line: 617

   SELECT next_run_date_time
   FROM ams_triggers
   WHERE trigger_id = l_trigger_id;

Line: 628

UPDATE ams_triggers SET next_run_date_time = (next_run_date_time+1/360) WHERE trigger_id = l_trigger_id;

Line: 776

       UPDATE ams_triggers
             SET    last_run_date_time = l_cur_date,
                      next_run_date_time = l_sch_date,
                      user_last_run_date_time = l_user_last_run_date_time,
                      user_next_run_date_time = l_user_next_run_date_time
             WHERE  trigger_id = l_trigger_id ;

Line: 872

    SELECT repeat_stop_date_time --to_char(repeat_stop_date_time,'DD-MM-RRRR HH:MI:SS AM')
    FROM   ams_triggers
    WHERE  trigger_id = p_trig_id;

Line: 995

     SELECT chk1_type, chk1_source_code_metric_id,
            chk2_type, chk2_source_code_metric_id
     FROM   ams_trigger_checks
     WHERE  trigger_id = p_trigger_id;

Line: 1388

        UPDATE ams_triggers
        SET    process_id = null
        WHERE  trigger_id = l_trigger_id;

Line: 1459

   select list.list_name
   from ams_list_headers_vl list, ams_Act_lists act
   where list.list_header_id = act.list_header_id
   and act.list_used_by_id = p_sch_id
   and act.list_Act_Type = 'TARGET';

Line: 1473

  SELECT start_date_time, timezone_id
  FROM   ams_campaign_schedules_b
  WHERE  schedule_id = p_schedule_id;

Line: 1717

    SELECT schedule_id, notify_user_id, approver_user_id, owner_user_id, schedule_name
    FROM ams_campaign_schedules_vl
    WHERE trigger_id = l_trig_id
      AND status_code = 'AVAILABLE'
      -- soagrawa 28-apr-2003 added the following to this cursor
      AND (trig_repeat_flag IS NULL OR trig_repeat_flag = 'N');

Line: 1980

  SELECT count(1)
  FROM ams_campaign_schedules_vl
  WHERE trigger_id = l_trig_id
  AND status_code = 'AVAILABLE';

Line: 2027

    SELECT employee_id source_id
      FROM ams_jtf_rs_emp_v
     WHERE resource_id = p_user_id ;

Line: 2084

    SELECT  process_id
    FROM    ams_triggers
    WHERE   trigger_id = p_trigger_id ;

Line: 2166

    SELECT triggering_type
    FROM   ams_triggers
    WHERE  trigger_id = p_trig_id;

Line: 2256

    SELECT notify_flag
    FROM   ams_triggers
    WHERE  trigger_id = p_trig_id;

Line: 2261

    SELECT *
    FROM   ams_trigger_actions
    WHERE  trigger_id = p_trig_id
    AND    execute_action_type = 'NOTIFY';

Line: 2418

    SELECT execute_schedule_flag
    FROM   ams_triggers
    WHERE  trigger_id = p_trig_id;

Line: 2531

   SELECT ams_campaign_schedules_s.NEXTVAL
   FROM   dual;

Line: 2535

   SELECT *
   from   ams_campaign_schedules_vl
   where  schedule_id = l_sched_id;

Line: 2543

    SELECT schedule_id, notify_user_id, approver_user_id, owner_user_id, schedule_name
    FROM ams_campaign_schedules_vl
    WHERE schedule_id = p_schedule_id;

Line: 2550

  select distinct nvl(orig_csch_id, schedule_id) AS id, count(*) AS total
  from ams_Campaign_schedules_b
  where trigger_id = l_trig_id
       and status_code = 'AVAILABLE'
       and trig_repeat_flag = 'Y'
  group by nvl(orig_csch_id, schedule_id);

Line: 2560

  select schedule_id
  from ams_campaign_schedules_b
  where creation_date = (select max(creation_date)
                              from ams_campaign_schedules_b
                             where nvl(orig_csch_id, schedule_id) = p_schedule_id);

Line: 2568

  select schedule_name
    from ams_Campaign_schedules_vl
   where schedule_id = ( select nvl(orig_csch_id, schedule_id)
                           From ams_campaign_Schedules_b
                           where schedule_id = p_schedule_id);

Line: 2606

   l_schedules_to_update      JTF_NUMBER_TABLE  := JTF_NUMBER_TABLE()         ;

Line: 2610

   SELECT repeat_frequency_type, repeat_every_x_frequency
     FROM ams_Triggers
    WHERE trigger_id = p_trigger_id;

Line: 2616

       SELECT actual_exec_end_date
       FROM   ams_campaigns_all_b
       WHERE  campaign_id = p_campaign_id ;

Line: 3277

       UPDATE ams_triggers
          SET process_id = to_number(l_new_item_key)
        WHERE trigger_id = l_trigger_id;

Line: 3354

      SELECT employee_id
      FROM   ams_jtf_rs_emp_v
      WHERE  resource_id = l_res_id ;

Line: 3359

       SELECT *
       -- modified by soagrawa
       -- FROM   ams_triggers
       FROM   ams_triggers_vl
       WHERE  trigger_id = l_trigger_id ;

Line: 3367

       SELECT *
       FROM   ams_trigger_checks
       WHERE  trigger_id = l_trigger_id ;

Line: 3373

       SELECT *
       FROM   ams_trigger_actions
       WHERE  trigger_id = l_trigger_id
       AND    execute_action_type = 'NOTIFY';

Line: 3382

    SELECT campaign_name, priority, owner_user_id
    FROM   ams_campaigns_vl
    WHERE  campaign_id = l_trig_rec.trigger_created_for_id ;

Line: 3387

    SELECT schedule_name, priority, owner_user_id
    FROM   ams_campaign_schedules_vl
    WHERE  schedule_id = l_trig_rec.trigger_created_for_id ;

Line: 3392

    SELECT event_offer_name, 'STANDARD', owner_user_id
    FROM   ams_event_offers_vl
    WHERE  event_offer_id = l_trig_rec.trigger_created_for_id ;

Line: 3397

    SELECT event_header_name, 'STANDARD', owner_user_id
    FROM   ams_event_headers_vl
    WHERE  event_header_id = l_trig_rec.trigger_created_for_id ;

Line: 3407

       SELECT met.metrics_name metrics_name,act.act_metric_used_by_id metric_used_by_id,
              act.arc_act_metric_used_by metric_used_by
       FROM   ams_metrics_vl met,ams_act_metrics_all act
       WHERE  met.metric_id = act.metric_id
       AND    act.activity_metric_id = l_metric_id ;

Line: 3415

     SELECT   timeout_days_low_prio,
              timeout_days_std_prio,
              timeout_days_high_prio,
              timeout_days_medium_prio
     FROM     ams_approval_rules
     WHERE    arc_approval_for_object = l_trig_rec.arc_trigger_created_for;

Line: 3445

       UPDATE  ams_triggers
       SET     process_id = TO_NUMBER(itemkey)
       WHERE   trigger_id = l_trigger_id ;

Line: 3668

    SELECT 1
    FROM   ams_triggers
    WHERE  trigger_id = p_trig_id;

Line: 3790

     write_msg('purge_history','History for all triggers that have ended more than '||trig_end_date_days||' days is being deleted...');

Line: 3793

   Delete from ams_trigger_results
   where trigger_result_for_id in
   		   (SELECT  trigger_id
		   FROM ams_triggers
		   WHERE (repeat_stop_date_time + trig_end_date_days) < sysdate);