DBA Data[Home] [Help]

APPS.GCS_CONS_ENG_RUN_DTLS_PKG SQL Statements

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

Line: 6

  PROCEDURE	insert_row	(	p_run_detail_id			OUT NOCOPY NUMBER,
  					p_run_name			IN VARCHAR2,
  					p_consolidation_entity_id	IN NUMBER,
  					p_category_code			IN VARCHAR2,
  					p_child_entity_id		IN NUMBER,
  					p_contra_child_entity_id	IN NUMBER,
  					p_rule_id			IN NUMBER,
  					p_entry_id			IN NUMBER,
  					p_stat_entry_id			IN NUMBER,
  					p_request_error_code		IN VARCHAR2,
  					p_bp_request_error_code		IN VARCHAR2,
  					p_pre_prop_entry_id		IN NUMBER,
  					p_pre_prop_stat_entry_id	IN NUMBER,
  					p_cons_relationship_id		IN NUMBER)

  IS PRAGMA AUTONOMOUS_TRANSACTION;
Line: 26

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

    INSERT INTO gcs_cons_eng_run_dtls
    (
    	RUN_DETAIL_ID,
    	RUN_NAME,
    	CONSOLIDATION_ENTITY_ID,
    	CATEGORY_CODE,
    	CHILD_ENTITY_ID,
    	CONTRA_CHILD_ENTITY_ID,
    	RULE_ID,
    	ENTRY_ID,
    	STAT_ENTRY_ID,
    	REQUEST_ERROR_CODE,
    	BP_REQUEST_ERROR_CODE,
    	PRE_PROP_ENTRY_ID,
    	PRE_PROP_STAT_ENTRY_ID,
    	CONS_RELATIONSHIP_ID,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	CREATION_DATE,
	CREATED_BY,
	LAST_UPDATE_LOGIN
    )
    VALUES
    (
    	gcs_cons_eng_run_dtls_s.nextval,
    	p_run_name,
    	p_consolidation_entity_id,
    	p_category_code,
    	p_child_entity_id,
    	p_contra_child_entity_id,
    	p_rule_id,
    	p_entry_id,
    	p_stat_entry_id,
    	p_request_error_code,
    	p_bp_request_error_code,
    	p_pre_prop_entry_id,
    	p_pre_prop_stat_entry_id,
    	p_cons_relationship_id,
	sysdate,
  	FND_GLOBAL.USER_ID,
	sysdate,
	FND_GLOBAL.USER_ID,
	FND_GLOBAL.LOGIN_ID
    )
    RETURNING run_detail_id INTO p_run_detail_id;
Line: 77

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

  PROCEDURE	update_entry_headers(	p_run_detail_id			IN NUMBER,
  					p_entry_id			IN NUMBER,
  					p_stat_entry_id			IN NUMBER 	DEFAULT NULL,
  					p_pre_prop_entry_id		IN NUMBER	DEFAULT NULL,
  					p_pre_prop_stat_entry_id	IN NUMBER	DEFAULT NULL,
  					p_request_error_code		IN VARCHAR2	DEFAULT NULL,
  					p_bp_request_error_code		IN VARCHAR2	DEFAULT NULL
  					)
  IS

  BEGIN

    IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL 	<=	FND_LOG.LEVEL_PROCEDURE) THEN
      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_ENTRY_HEADERS', '<>');
Line: 101

    UPDATE gcs_cons_eng_run_dtls
    SET    entry_id			=	NVL(p_entry_id, entry_id),
    	   stat_entry_id		=	NVL(p_stat_entry_id, stat_entry_id),
    	   pre_prop_entry_id		=	NVL(p_pre_prop_entry_id, pre_prop_entry_id),
    	   pre_prop_stat_entry_id	=	NVL(p_pre_prop_stat_entry_id, pre_prop_stat_entry_id),
    	   request_error_code		=	NVL(p_request_error_code, request_error_code),
    	   bp_request_error_code	=	NVL(p_bp_request_error_code, bp_request_error_code),
	   last_update_date		=	sysdate,
	   last_updated_by		=	FND_GLOBAL.user_id
    WHERE  run_detail_id		=	p_run_detail_id;
Line: 113

      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_ENTRY_HEADERS', '<>');
Line: 119

  PROCEDURE	update_entry_headers_async(	p_run_detail_id			IN NUMBER,
  						p_entry_id			IN NUMBER	DEFAULT NULL,
  						p_stat_entry_id			IN NUMBER 	DEFAULT NULL,
  						p_pre_prop_entry_id		IN NUMBER	DEFAULT NULL,
  						p_pre_prop_stat_entry_id	IN NUMBER	DEFAULT NULL,
  						p_request_error_code		IN VARCHAR2	DEFAULT NULL,
  						p_bp_request_error_code		IN VARCHAR2	DEFAULT NULL
  					)
  IS PRAGMA AUTONOMOUS_TRANSACTION;
Line: 131

      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_ENTRY_HEADERS_ASYNC', '<>');
Line: 134

    UPDATE gcs_cons_eng_run_dtls
    SET    entry_id			=	NVL(p_entry_id, entry_id),
    	   stat_entry_id		=	NVL(p_stat_entry_id, stat_entry_id),
    	   pre_prop_entry_id		=	NVL(p_pre_prop_entry_id, pre_prop_entry_id),
    	   pre_prop_stat_entry_id	=	NVL(p_pre_prop_stat_entry_id, pre_prop_stat_entry_id),
    	   request_error_code		=	NVL(p_request_error_code, request_error_code),
    	   bp_request_error_code	=	NVL(p_bp_request_error_code, bp_request_error_code),
	   last_update_date		=	sysdate,
	   last_updated_by		=	FND_GLOBAL.USER_ID
    WHERE  run_detail_id		=	p_run_detail_id;
Line: 146

      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_ENTRY_HEADERS_ASYNC', '<>');
Line: 174

    SELECT count(request_error_code)
    INTO   l_row_count
    FROM   gcs_cons_eng_run_dtls
    WHERE  run_name                 =       p_run_name
    AND    consolidation_entity_id  =       p_consolidation_entity_id
    AND    child_entity_id          IS NOT NULL
    AND    category_code            =       p_category_code;
Line: 183

      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_CATEGORY_STATUS', 'Number of rows : ' || l_row_count);
Line: 189

      SELECT count(request_error_code)
      INTO   l_warning_row_count
      FROM   gcs_cons_eng_run_dtls
      WHERE  run_name                       	=       p_run_name
      AND    consolidation_entity_id        	=       p_consolidation_entity_id
      AND    child_entity_id                	IS NOT NULL
      AND    category_code          		=       p_category_code
      AND    NVL(request_error_code,'X')    	NOT IN  ('COMPLETED','NOT_APPLICABLE');
Line: 199

      FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_CATEGORY_STATUS', 'Warning Row Count	:       '  || l_warning_row_count);
Line: 210

      FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_CATEGORY_STATUS', 'Status Code		:	'  || l_status_code);
Line: 219

  PROCEDURE	update_category_status(	p_run_name			IN VARCHAR2,
  					p_consolidation_entity_id	IN NUMBER,
  					p_category_code			IN VARCHAR2,
  					p_status			IN VARCHAR2)
  IS PRAGMA AUTONOMOUS_TRANSACTION;
Line: 234

      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_CATEGORY_STATUS', '<>');
Line: 238

      FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_CATEGORY_STATUS', 'Run Name		:	'  || p_run_name);
Line: 239

      FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_CATEGORY_STATUS', 'Consolidation Entity	:	'  || p_consolidation_entity_id);
Line: 240

      FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_CATEGORY_STATUS', 'Category Code	:	'  || p_category_code);
Line: 241

      FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_CATEGORY_STATUS', 'Status		:	'  || p_status);
Line: 258

       UPDATE gcs_cons_eng_run_dtls
       SET    request_error_code  =       l_status_code,
              last_update_date    =       sysdate,
              last_updated_by     =       FND_GLOBAL.LOGIN_ID
       WHERE  run_name                    =       p_run_name
       AND    category_code               =       l_category_code
       AND    consolidation_entity_id     =       p_consolidation_entity_id
       AND    child_entity_id             IS NULL;
Line: 276

     UPDATE gcs_cons_eng_run_dtls
     SET    request_error_code	= 	l_status_code,
  	    last_update_date	=	sysdate,
	    last_updated_by	=	FND_GLOBAL.LOGIN_ID
     WHERE  run_name			=	p_run_name
     AND    category_code		=	p_category_code
     AND    consolidation_entity_id	=	p_consolidation_entity_id
     AND    child_entity_id		IS NULL;
Line: 288

      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_CATEGORY_STATUS', '<>');
Line: 293

  PROCEDURE	update_detail_requests(	p_run_detail_id			IN NUMBER,
  					p_run_process_code		IN VARCHAR2
  					)

  IS

  BEGIN

    IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL 	<=	FND_LOG.LEVEL_PROCEDURE) THEN
      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_DETAIL_REQUESTS', '<>');
Line: 306

      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_DETAIL_REQUESTS', '<>');
Line: 321

      INSERT INTO gcs_cons_eng_run_dtls
      (
	run_detail_id,
	run_name,
	consolidation_entity_id,
	category_code,
	child_entity_id,
	contra_child_entity_id,
	rule_id,
	entry_id,
	stat_entry_id,
	request_error_code,
	bp_request_error_code,
	cons_relationship_id,
	last_update_date,
	last_updated_by,
	creation_date,
	created_by,
	last_update_login
      )
      SELECT  gcs_cons_eng_run_dtls_s.nextval,
	      p_current_run_name,
	      consolidation_entity_id,
	      category_code,
	      child_entity_id,
	      contra_child_entity_id,
	      rule_id,
	      entry_id,
	      stat_entry_id,
	      request_error_code,
	      bp_request_error_code,
	      cons_relationship_id,
	      sysdate,
	      FND_GLOBAL.USER_ID,
              sysdate,
	      FND_GLOBAL.USER_ID,
	      FND_GLOBAL.LOGIN_ID
      FROM    gcs_cons_eng_run_dtls
      WHERE   run_name  		=	p_prior_run_name
      AND     child_entity_id		=	p_entity_id
      AND     category_code		IN	(select category_code
						 from 	gcs_categories_b
						 where 	target_entity_code	=	'CHILD'
						 and	category_type_code	<>	'PROCESS');
Line: 367

      DELETE FROM gcs_cons_eng_run_dtls
      WHERE  run_name			=	p_current_run_name
      AND    consolidation_entity_id	=	p_entity_id
      AND    category_code		IN	(select category_code
						 from   gcs_categories_b
						 where  target_entity_code	IN ('ELIMINATION', 'PARENT'))
      AND    child_entity_id		IS	NULL;
Line: 375

      INSERT INTO gcs_cons_eng_run_dtls
      (
	run_detail_id,
	run_name,
	consolidation_entity_id,
	category_code,
	child_entity_id,
	contra_child_entity_id,
	rule_id,
	entry_id,
	stat_entry_id,
	request_error_code,
	bp_request_error_code,
	pre_prop_entry_id,
	pre_prop_stat_entry_id,
	cons_relationship_id,
	last_update_date,
	last_updated_by,
	creation_date,
	created_by,
	last_update_login
      )
      SELECT gcs_cons_eng_run_dtls_s.nextval,
             p_current_run_name,
	     consolidation_entity_id,
	     category_code,
	     child_entity_id,
	     contra_child_entity_id,
	     rule_id,
	     entry_id,
	     stat_entry_id,
	     request_error_code,
	     bp_request_error_code,
	     pre_prop_entry_id,
	     pre_prop_stat_entry_id,
	     cons_relationship_id,
	     sysdate,
	     FND_GLOBAL.USER_ID,
	     sysdate,
	     FND_GLOBAL.USER_ID,
	     FND_GLOBAL.LOGIN_ID
      FROM   gcs_cons_eng_run_dtls
      WHERE  run_name			=       p_prior_run_name
      AND    consolidation_entity_id	=	p_entity_id
      AND    category_code		IN	(select category_code
						 from   gcs_categories_b
						 where  target_entity_code	IN	('ELIMINATION', 'PARENT'));