APPS.GCS_CONS_ENG_RUNS_PKG SQL Statements

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

Line: 8

  PROCEDURE	insert_row	(	p_run_name		IN VARCHAR2,
  					p_hierarchy_id		IN NUMBER,
  					p_process_method_code	IN VARCHAR2,
  					p_run_entity_id		IN NUMBER,
  					p_cal_period_id		IN NUMBER,
  					p_balance_type_code	IN VARCHAR2,
  					p_parent_entity_id	IN NUMBER,
  					p_item_key		IN VARCHAR2,
					p_request_id		IN NUMBER)

  IS PRAGMA AUTONOMOUS_TRANSACTION;

Line: 22

      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INSERT_ROW', '<>');

Line: 25

    INSERT INTO gcs_cons_eng_runs
    (
    	RUN_NAME,
    	HIERARCHY_ID,
    	PROCESS_METHOD,
    	RUN_ENTITY_ID,
    	CAL_PERIOD_ID,
    	BALANCE_TYPE_CODE,
    	STATUS_CODE,
    	OBJECT_VERSION_NUMBER,
    	CREATION_DATE,
    	CREATED_BY,
    	LAST_UPDATED_BY,
    	LAST_UPDATE_DATE,
    	LAST_UPDATE_LOGIN,
    	PARENT_ENTITY_ID,
    	ITEM_KEY,
	LOCKED_FLAG,
	IMPACTED_FLAG,
        MOST_RECENT_FLAG,
    -- Bugfix 3692336 : Add the START_TIME for the Consolidation Process
        START_TIME,
    -- Bugfix 4269147 : Added request_id
        REQUEST_ID

    )
    VALUES
    (
    	p_run_name,
    	p_hierarchy_id,
    	p_process_method_code,
    	p_run_entity_id,
    	p_cal_period_id,
    	p_balance_type_code,
    	'IN_PROGRESS',
    	1,
    	sysdate,
    	fnd_global.user_id,
    	fnd_global.user_id,
    	sysdate,
    	fnd_global.login_id,
    	p_parent_entity_id,
    	p_item_key,
	'N',
	'N',
	'N',
	sysdate,
        p_request_id
    );

Line: 76

      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INSERT_ROW', '<>');

Line: 83

  PROCEDURE	update_status	(	p_run_name		IN VARCHAR2,
  					p_most_recent_flag	IN VARCHAR2,
  					p_status_code		IN VARCHAR2,
  					p_run_entity_id		IN NUMBER,
					p_end_time		IN DATE)

  IS PRAGMA AUTONOMOUS_TRANSACTION;

Line: 93

      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_STATUS', '<>');

Line: 96

    UPDATE gcs_cons_eng_runs
    SET    most_recent_flag	=	p_most_recent_flag,
    	   status_code		=	NVL(p_status_code,status_code),
	   end_time		=	NVL(p_end_time,end_time),
	   last_update_date	=	sysdate,
	   last_updated_by	=	FND_GLOBAL.USER_ID
    WHERE  run_name		=	p_run_name
    AND	   run_entity_id	=	p_run_entity_id;

Line: 106

      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_STATUS', '<>');