APPS.FND_SEED_STAGE_UTIL SQL Statements

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

Line: 9

PROCEDURE insert_msg( p_msg_str IN VARCHAR2)
IS
BEGIN
  G_MSG_TAB(G_MSG_TAB.COUNT + 1) := p_msg_str;

Line: 13

END insert_msg;

Line: 15

PROCEDURE update_status( p_debug IN NUMBER,
                         p_seq IN NUMBER,
                         p_status IN NUMBER)
IS
  type csr_type IS REF CURSOR;

Line: 24

    l_str := 'UPDATE fnd_seed_stage_entity
                 SET exec_status = :1
               WHERE seq = :2';

Line: 28

    l_str := 'UPDATE fnd_seed_stage_entity_debug
                 SET exec_status = :1
               WHERE seq = :2';

Line: 35

END update_status;

Line: 47

  G_MSG_TAB.DELETE(l_max_err+1, p_msg_to);

Line: 61

  G_MSG_TAB.DELETE(p_msg_from, p_msg_to);

Line: 76

  G_MSG_TAB.DELETE;

Line: 121

G_MSG_TAB.delete;

Line: 124

    l_str := 'SELECT upload_stmt, stmt_len
              FROM fnd_seed_stage_config
              WHERE lct_file = :1
              AND proc_id = :2
              AND entity_name = ''PLSQL_WRAPPER_CODE''';

Line: 130

    l_str := 'SELECT upload_stmt, stmt_len
              FROM fnd_seed_stage_config_debug
              WHERE lct_file = :1
              AND proc_id = :2
              AND entity_name = ''PLSQL_WRAPPER_CODE''';

Line: 208

    l_str := 'SELECT exec_status
                FROM fnd_seed_stage_entity
               WHERE seq = -1
                 AND config_id = -1';

Line: 213

    l_str := 'SELECT exec_status
                FROM fnd_seed_stage_entity_debug
               WHERE seq = -1
                 AND config_id = -1';