APPS.GL_JOURNAL_IMPORT_PKG SQL Statements

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

Line: 31

    SELECT oracle_username into apps_schema FROM fnd_oracle_userid where read_only_flag = 'U';

Line: 47

      ' AS SELECT * FROM ' || apps_schema || '.GL_INTERFACE WHERE ROWNUM < 1';

Line: 186

      SELECT je_source_name
      INTO je_source_name
      FROM gl_je_sources
      WHERE user_je_source_name
        = populate_interface_control.user_je_source_name;

Line: 196

    IF (processed_data_action NOT IN (SAVE_DATA, DELETE_DATA,
                                      DROP_INTERFACE_TABLE, NULL)) THEN
      RAISE INVALID_PROCESSED_ACTION;

Line: 207

      SELECT gl_interface_control_s.NEXTVAL
      INTO group_id
      FROM DUAL;

Line: 213

      SELECT gl_journal_import_s.NEXTVAL
      INTO interface_run_id
      FROM DUAL;

Line: 218

    INSERT INTO gl_interface_control
    (status, je_source_name,
     group_id, set_of_books_id,
     interface_run_id, interface_table_name, processed_table_code)
    VALUES
    ('S', populate_interface_control.je_source_name,
     populate_interface_control.group_id,
     populate_interface_control.set_of_books_id,
     populate_interface_control.interface_run_id,
     table_name, processed_data_action);