APPS.IES_TRANSACTION_SEGMENTS_PKG SQL Statements

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

Line: 15

    'SELECT max(segment_id)
       FROM ies_trans_segments
      WHERE transaction_id = :id' using p_transaction_id;

Line: 35

        transactionId := ies_transaction_util_pkg.insert_transaction(p_user_id, p_dscript_id);

Line: 37

        ies_transaction_util_pkg.update_transaction(p_transaction_id, 2, empty_clob(), p_user_id);

Line: 41

    execute immediate 'select ies_trans_segments_s.nextval from dual' into seqval;

Line: 43

    sqlStmt := 'insert into ies_trans_segments
                                   (segment_id,
                                    transaction_id,
                                    created_by,
                                    creation_date,
                                    start_time)
                            values (:seq,
                                    :p_transaction_id,
                                    :p_user_id,
                                    :1,
                                    :2)';

Line: 60

   PROCEDURE update_Segment (p_transaction_id IN NUMBER,
                             p_status IN NUMBER,
                             p_restart_clob IN CLOB,
                             p_user_id IN NUMBER) IS
    sqlstmt   VARCHAR2(2000);

Line: 68

    ies_transaction_util_pkg.update_transaction(p_transaction_id,
                                            p_status,
                                            p_restart_clob,
                                            p_user_id);

Line: 72

    sqlStmt := 'update ies_trans_segments set end_time = :1,
                                               last_update_date = :2,
                                               last_updated_by = :3 where segment_id = :id';