APPS.IES_NEW_END_OF_SCRIPT_PKG SQL Statements

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

Line: 137

     insertStmt varchar2(4000);

Line: 143

     EXECUTE IMMEDIATE 'SELECT IES_FOOTPRINTING_DATA_S.nextval  FROM dual' INTO seqval;

Line: 145

     insertStmt := 'INSERT INTO IES_FOOTPRINTING_DATA( FOOTPRINTING_DATA_ID   ,
                                    created_by           ,
                                    creation_date        ,
                                    elapsed_time         ,
                                    sequence_number      ,
                                    panel_data_id)
                         VALUES    ( :seq,
                                     :1,
                                     :2,
                                     :3,
                                     :4,
                                     :5)';

Line: 157

         EXECUTE immediate insertStmt using  seqval, agentId, sysdate,
                                             elapsedTime, seq+1, panelDataId;

Line: 161

  PROCEDURE insertFootprintData
  (
     p_element                        IN     xmldom.DOMElement,
     panel_data_id                    IN     number,
     interactionId                    IN     number,
     agentId                          IN     number
  ) IS

    --element xmlDom.DOMElement;

Line: 202

     insertStmt varchar2(4000);

Line: 212

     EXECUTE IMMEDIATE 'SELECT ies_question_data_s.nextval  FROM dual' INTO seqval;

Line: 214

     insertStmt := 'INSERT INTO ies_question_data( question_data_id     ,
                                    created_by           ,
                                    creation_date        ,
                                    transaction_id       ,
                                    question_id          ,
                                    lookup_id            ,
                                    answer_id            ,
                                    freeform_string      ,
                                    panel_data_id)
                         VALUES    ( :seq ,
                                     :1,
                                     :2,
                                     :3,
                                     :4,
                                     :5,
                                     :6,
                                     :7,
                                     :8)';

Line: 232

     EXECUTE immediate insertStmt using  seqval  ,
                              agentId            ,
                              sysdate            ,
                              intId              ,
                              question_id        ,
                              lookup_id          ,
                              answer_id          ,
                              string_val,
                              panelDataId;

Line: 243

  PROCEDURE insertIESQuestionData
  (
     p_element                        IN     xmldom.DOMElement,
     panel_data_id                    IN     number,
     interactionId                    IN     number,
     agentId                          IN     number
  ) IS

    --element xmlDom.DOMElement;

Line: 285

    deleted_status     NUMBER;

Line: 289

    insertStmt varchar2(4000);

Line: 296

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

Line: 298

    EXECUTE IMMEDIATE 'SELECT ies_panel_data_s.nextval  FROM dual' INTO seqval;

Line: 300

    insertStmt := 'INSERT INTO ies_panel_data( panel_data_id        ,
                                 created_by           ,
                                 creation_date        ,
                                 panel_id             ,
                                 transaction_id       ,
                                 elapsed_time         ,
                                 sequence_number      ,
                                 deleted_status       )
                     VALUES    ( :seq ,
                                 :1,
                                 :2,
                                 :3,
                                 :4,
                                 :5,
                                 :6,
                                 :7) returning panel_data_id INTO :8';

Line: 316

     execute immediate insertStmt using seqval,
                                 agentId,
                                 sysdate,
                                 panel_id,
                                 intid,
                                 nullval,
                                 sequence_num,
                                 deleted_status returning INTO id;

Line: 327

         insertFootprintData(fp_element, id, intId, agentId);

Line: 334

         insertIESQuestionData(qd_element, id, intId, agentId);

Line: 341

  PROCEDURE insertIESPanelData
  (
     p_element                        IN     varchar2
  ) IS

    parser  xmlparser.parser;