APPS.GL_JOURNAL_IMPORT_PKG SQL Statements

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

Line: 40

      ' AS SELECT * FROM GL_INTERFACE WHERE ROWNUM < 1';

Line: 151

      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: 161

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

Line: 172

      SELECT gl_interface_control_s.NEXTVAL
      INTO group_id
      FROM DUAL;

Line: 178

      SELECT gl_journal_import_s.NEXTVAL
      INTO interface_run_id
      FROM DUAL;

Line: 183

    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);