APPS.GL_ELIMINATION_SETS_PKG SQL Statements

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

Line: 26

      SELECT gl_elimination_sets_s.NEXTVAL
      FROM dual;

Line: 126

       SELECT 1
       FROM DUAL
       WHERE EXISTS (SELECT 1
                   FROM  gl_elimination_sets
                   WHERE name = X_name
		   AND   ledger_id = X_ledgerid
                   AND   ((X_rowid IS NULL) OR (rowid <> X_rowid)));

Line: 173

  FUNCTION allow_delete_record( X_setid NUMBER ) RETURN BOOLEAN IS

    counter NUMBER;

Line: 178

       SELECT 1
       FROM DUAL
       WHERE EXISTS (SELECT 1
                     FROM  gl_elimination_sets
                     WHERE elimination_set_id = X_setid
  		     AND   track_elimination_status_flag = 'Y'
		     AND   last_executed_period IS NOT NULL);

Line: 206

          'gl_elimination_sets_pkg.allow_delete_record');

Line: 208

  END allow_delete_record;

Line: 251

  CURSOR C IS SELECT
	        elimination_set_id,
		name,
		ledger_id,
		track_elimination_status_flag,
		start_date_active,
		end_date_active,
		elimination_company,
		last_executed_period,
		description,
		attribute1,
		attribute2,
		attribute3,
		attribute4,
		attribute5,
		attribute6,
		attribute7,
		attribute8,
		attribute9,
		attribute10,
		attribute11,
		attribute12,
		attribute13,
		attribute14,
		attribute15,
		context,
		security_flag
    FROM GL_ELIMINATION_SETS
    WHERE ROWID = X_Rowid
    FOR UPDATE OF elimination_set_id NOWAIT;

Line: 288

      fnd_message.set_name('FND', 'FORM_RECORD_DELETED');