APPS.IES_TRANSACTION_UTIL_PKG SQL Statements

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

Line: 8

  PROCEDURE delete_old_data(p_transaction_Id IN NUMBER) IS
     panelDataStmt VARCHAR2(2000);

Line: 12

     questionDataStmt := 'delete from ies_question_data where transaction_id = :1';

Line: 15

     panelDataStmt := 'delete from ies_panel_data where transaction_id = :1';

Line: 27

    'SELECT nvl(status, 0)
       FROM ies_transactions
      WHERE transaction_id = :id for update' using p_transaction_id;

Line: 58

    'SELECT restart_data
       FROM ies_transactions
      WHERE transaction_id = :id' using p_transaction_Id;

Line: 67

  PROCEDURE Update_Transaction(p_transaction_Id in number) IS
    sqlstmt   VARCHAR2(2000);

Line: 70

    sqlStmt := 'update ies_transactions set status = null where transaction_id = :id';

Line: 74

  PROCEDURE Update_Transaction(p_transaction_Id in number,
                               p_status IN NUMBER,
                               p_restart_clob IN CLOB,
                               p_user_id IN NUMBER) IS
    sqlstmt   VARCHAR2(2000);

Line: 80

    delete_Old_Data(p_transaction_Id);

Line: 81

    sqlStmt := 'update ies_transactions set status = :1,
                                      restart_data = :2,
                                  last_update_date = sysdate,
                                  end_time = sysdate,
                                  last_updated_by = :3 where transaction_id = :id';

Line: 89

  FUNCTION insert_transaction(p_user_Id IN NUMBER,
                               p_dscript_Id IN NUMBER) RETURN NUMBER IS
    transactionId NUMBER;

Line: 94

    SELECT ies_transactions_s.nextval INTO transactionId FROM dual;

Line: 96

    sqlstmt := 'insert into ies_transactions(transaction_id, created_by, creation_date, agent_id, dscript_id, start_time)
                         values(:1, :2, sysdate, :3, :4, sysdate)';