APPS.AMS_CONTCAMPAIGN_PVT SQL Statements

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

Line: 53

/*PROCEDURE insert_log_mesg (p_mesg IN VARCHAR2)
IS
PRAGMA AUTONOMOUS_TRANSACTION;

Line: 57

 insert into anirban_table values (p_mesg);

Line: 257

  SELECT  sql_string
  FROM     ams_discoverer_sql
  WHERE   workbook_name  = p_workbook_name
  AND     worksheet_name = p_worksheet_name
--  AND     workbook_owner_name = p_workbook_owner_name
  ORDER BY sequence_order ;

Line: 685

  SELECT ams_trigger_results_s.NEXTVAL
  FROM    dual ;

Line: 689

         SELECT COUNT(1)
         FROM   ams_trigger_results
         WHERE  trigger_result_id = p_process_id ;

Line: 706

    UPDATE ams_trigger_results
    SET
    trigger_finish_time = SYSDATE ,
    object_version_number = object_version_number + 1,
    actions_performed = p_action_taken
    WHERE trigger_result_id = p_process_id ;

Line: 735

   INSERT INTO ams_trigger_results
   (trigger_result_id

   --Standard Who Columns
   ,last_update_date
   ,last_updated_by
   ,creation_date
   ,created_by
   ,last_update_login
   ,object_version_number
   ,trigger_result_for_id
   ,arc_trigger_result_for
   ,trigger_finish_time
   ,chk1_checked_value
   ,chk2_checked_value
   ,chk2_high_value
   ,chk1_to_chk2_operator_type
   ,process_success_flag
   ,check_met_flag
   ,actions_performed
   ,notified_user
   )
   VALUES
   (
   l_result_id
   -- standard who columns
   ,SYSDATE
   ,FND_GLOBAL.User_Id
   ,SYSDATE
   ,FND_GLOBAL.User_Id
   ,FND_GLOBAL.Conc_Login_Id
   ,1          -- Object Version ID
   ,p_result_for_id
   ,'TRIG'
   ,SYSDATE
   ,p_chk1_value
   ,p_chk2_value
   ,p_chk2_high_value
   ,p_operator
   ,p_process_success
   ,p_check_met
   ,p_action_taken
   ,p_action_for_id);

Line: 784

         update ams_triggers
         set TRIGGERED_STATUS = 'DORMANT'
         where trigger_id = p_result_for_id;

Line: 788

         update ams_triggers
         set TRIGGERED_STATUS = 'TRIGGERED'
         where trigger_id = p_result_for_id;

Line: 849

               SELECT    *
               FROM    ams_triggers
              WHERE     trigger_id  = l_my_trigger_id ;

Line: 995

  AMS_Utility_PVT.debug_message(l_full_name||': Update Schedule Date');

Line: 999

  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: 1027

  AMS_Utility_PVT.debug_message(l_full_name ||': delete');

Line: 1140

        SELECT    *
       FROM      ams_trigger_checks
      WHERE     trigger_id = l_my_trigger_id  ;

Line: 1146

        SELECT    trans_actual_value,
                  trans_forecasted_value,
                  trans_committed_value,
                  metric_uom_code,
                  transaction_currency_code,
                  func_actual_value,
                  func_forecasted_value,
                  func_committed_value,
                  functional_currency_code
        FROM      ams_act_metrics_all
        WHERE     activity_metric_id = l_act_met_id ;

Line: 1159

       SELECT action_for_id
         FROM ams_trigger_Actions
   WHERE execute_Action_type = 'NOTIFY'
     AND trigger_id = l_my_trigger_id;

Line: 1393

                l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '
                  ||l_final_val||' '||l_trigger_checks.chk1_to_chk2_operator_type
               ||' '||l_trigger_checks.chk2_low_value||' AND '
               ||l_trigger_checks.chk2_high_value      ;

Line: 1400

               l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '
                   ||l_final_val||' '||l_trigger_checks.chk1_to_chk2_operator_type
               ||' '||l_trigger_checks.chk2_value  ;

Line: 1406

          l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '
              ||l_lhs_val||' '||l_trigger_checks.chk1_to_chk2_operator_type
             ||' '||l_rhs_val ;

Line: 1416

                l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '
                    ||' :b1 ' || ' BETWEEN '
                                        ||' :b2 AND :b3';

Line: 1424

      l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '
                    ||' :b1 '||l_trigger_checks.chk1_to_chk2_operator_type
               ||' :b2' ;

Line: 1435

          l_sql_stmt := 'SELECT COUNT(1) FROM dual WHERE '
              ||' :b1 '||l_trigger_checks.chk1_to_chk2_operator_type
             ||' :b2 ' ;