APPS.GL_ELIM_GEN_PKG SQL Statements

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

Line: 27

    PROCEDURE insert_elim_history (
                X_request_id            NUMBER,
                X_elimination_set_id    NUMBER,
                X_ledger_id      	NUMBER,
                X_period_name           VARCHAR2
    ) IS
    elim_run_id   NUMBER;

Line: 35

	LOCK TABLE GL_ELIMINATION_HISTORY IN SHARE UPDATE MODE;

Line: 37

        SELECT GL_ELIM_HISTORY_S.nextval
          INTO elim_run_id
          FROM dual;

Line: 41

	INSERT INTO gl_elimination_history
	(
                elimination_run_id,
		request_id,
		elimination_set_id,
		ledger_id,
		status_code,
		period_name,
		creation_date,
		created_by,
		last_update_date,
		last_updated_by,
		last_update_login
	)
    	VALUES
	(
                elim_run_id,
		X_request_id,
		X_elimination_set_id,
		X_ledger_id,
		'GS',
		X_period_name,
		SYSDATE,
		to_number(fnd_profile.value('USER_ID')),
		SYSDATE,
		to_number(fnd_profile.value('USER_ID')),
		to_number(fnd_profile.value('LOGIN_ID'))
	);

Line: 76

        		'GL_ELIM_GEN_PKG.insert_elim_history');

Line: 78

    END insert_elim_history;