APPS.IES_END_OF_SCRIPT_PKG SQL Statements

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

Line: 66

       'SELECT answer_id
          FROM ies_answers
         WHERE lookup_id = :lkp_id
           AND answer_value = :ans_val
           AND answer_display_value = :ans_disp_val' using lookup_id, string_val, display_val;

Line: 75

     INSERT INTO ies_question_data( question_data_id     ,
                                    created_by           ,
                                    creation_date        ,
                                    transaction_id       ,
                                    question_id          ,
                                    lookup_id            ,
                                    answer_id            ,
                                    freeform_string      )
                         VALUES    ( ies_question_data_s.nextval ,
                                     agentId            ,
                                     sysdate            ,
                                     intId              ,
                                     question_id        ,
                                     lookup_id          ,
                                     answer_id          ,
                                     string_val );

Line: 93

  PROCEDURE insertIESQuestionData
  (
     p_element                        IN     varchar2
  ) IS

    parser  xmlparser.parser;

Line: 136

  PROCEDURE insertIESQuestionData (p_element IN CLOB ) IS
    parser  xmlparser.parser;

Line: 174

  END insertIESQuestionData;

Line: 182

    deleted_status     NUMBER;

Line: 188

     deleted_Status  := getProperty(element, 'DeletedStatus');

Line: 190

     INSERT INTO ies_panel_data( panel_data_id        ,
                                 created_by           ,
                                 creation_date        ,
                                 panel_id             ,
                                 transaction_id       ,
                                 elapsed_time         ,
                                 sequence_number      ,
                                 deleted_status       )
                     VALUES    ( ies_panel_data_s.nextval ,
                                 agentId                  ,
                                 sysdate                  ,
                                 panel_id               ,
                                 intid                  ,
                                 elapsed_time           ,
                                 sequence_num           ,
                                 deleted_status         );

Line: 208

  PROCEDURE insertIESPanelData
  (
     p_element                        IN     varchar2
  ) IS

    parser  xmlparser.parser;

Line: 251

  PROCEDURE insertIESPanelData (p_element IN CLOB ) IS
    parser  xmlparser.parser;

Line: 290

  PROCEDURE updateIESTransactions(interactionId IN NUMBER) IS
  begin

    UPDATE ies_transactions SET end_time = sysdate WHERE transaction_id = interactionId;