APPS.GCS_RAISE_EVENT_PKG SQL Statements

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

Line: 77

    SELECT  to_char(date_assign_value, 'DD-MM-RR')
    INTO    l_cal_period_end_date
    FROM    fem_cal_periods_attr
    WHERE   attribute_id 	= l_end_date_attribute_id
    AND	    version_id		= l_end_date_version_id
    AND	    cal_period_id	= p_cal_period_id;

Line: 86

    UPDATE gcs_cons_eng_runs
    SET    most_recent_flag	=	'X'
    WHERE  most_recent_flag	=	'Y'
    AND	   run_entity_id	=	p_consolidation_entity
    AND	   hierarchy_id		=	p_consolidation_hierarchy
    AND	   cal_period_id	=       p_cal_period_id
    AND	   balance_type_code	=	p_balance_type_code;

Line: 94

    UPDATE gcs_cons_eng_runs gcer
    SET    gcer.most_recent_flag	=	'X'
    WHERE  gcer.most_recent_flag	=	'Y'
    AND	   gcer.hierarchy_id		=	p_consolidation_hierarchy
    AND	   gcer.cal_period_id		=	p_cal_period_id
    AND	   gcer.balance_type_code	=	p_balance_type_code
    AND    EXISTS 			(SELECT 'X'
					 FROM   gcs_cons_relationships gcr
					 WHERE  gcr.child_entity_id = gcer.run_entity_id
  					 START WITH gcr.parent_entity_id = p_consolidation_entity
				         AND    gcr.hierarchy_id	 = p_consolidation_hierarchy
  					 AND    TO_DATE(l_cal_period_end_date, 'DD-MM-RR')
							BETWEEN gcr.start_date AND     NVL(gcr.end_date,
										       TO_DATE(l_cal_period_end_date, 'DD-MM-RR'))
					 CONNECT BY PRIOR gcr.child_entity_id = gcr.parent_entity_id
					 AND    gcr.hierarchy_id	 = p_consolidation_hierarchy
 					 -- Bugfix 4122843: Added dominant parent flag condition
					 AND	gcr.dominant_parent_flag = 'Y'
                                         AND    TO_DATE(l_cal_period_end_date, 'DD-MM-RR')
                                                        BETWEEN gcr.start_date AND     NVL(gcr.end_date,
                                                                                       TO_DATE(l_cal_period_end_date, 'DD-MM-RR')));

Line: 161

  SELECT entity_name || ' on ' || to_char(sysdate, 'DD-MM-RR HH24:MI:SS')
  INTO   l_event_key
  FROM   fem_entities_vl
  WHERE  entity_id 	=	p_consolidation_entity;

Line: 166

  SELECT  to_char(date_assign_value, 'DD-MM-RR')
  INTO    l_cal_period_end_date
  FROM    fem_cal_periods_attr
  WHERE   attribute_id 	= l_end_date_attribute_id
  AND	  version_id	= l_end_date_version_id
  AND	  cal_period_id	= p_cal_period_id;

Line: 173

  GCS_CONS_ENG_RUNS_PKG.insert_row
  (
  	p_run_name		=>	p_run_identifier,
  	p_hierarchy_id		=>	p_consolidation_hierarchy,
  	p_process_method_code	=>	NVL(p_process_method, 'FULL'),
  	p_run_entity_id		=>	p_consolidation_entity,
  	p_cal_period_id		=>	p_cal_period_id,
  	p_balance_type_code	=>	p_balance_type_code,
	p_parent_entity_id	=>	-1,
	p_item_key		=>	l_event_key,
	p_request_id		=>	-1
  );

Line: 190

  UPDATE gcs_cons_eng_runs
  SET    most_recent_flag	=	'X'
  WHERE  most_recent_flag	=	'Y'
  AND	 run_entity_id		=	p_consolidation_entity
  AND	 hierarchy_id		=	p_consolidation_hierarchy
  AND	 cal_period_id		=       p_cal_period_id
  AND	 balance_type_code	=	p_balance_type_code;

Line: 198

  UPDATE gcs_cons_eng_runs gcer
  SET    gcer.most_recent_flag	=	'X'
  WHERE  gcer.most_recent_flag	=	'Y'
  AND	 gcer.hierarchy_id	=	p_consolidation_hierarchy
  AND	 gcer.cal_period_id	=	p_cal_period_id
  AND	 gcer.balance_type_code	=	p_balance_type_code
  AND    EXISTS 			(SELECT 'X'
					 FROM   gcs_cons_relationships gcr
					 WHERE  gcr.child_entity_id = gcer.run_entity_id
  					 START WITH gcr.parent_entity_id = p_consolidation_entity
				         AND    gcr.hierarchy_id	 = p_consolidation_hierarchy
  					 AND    TO_DATE(l_cal_period_end_date, 'DD-MM-RR')
							BETWEEN gcr.start_date AND     NVL(gcr.end_date,
										       TO_DATE(l_cal_period_end_date, 'DD-MM-RR'))
					 CONNECT BY PRIOR gcr.child_entity_id = gcr.parent_entity_id
					 -- Bugfix 4122843: Added dominant parent flag
					 AND	gcr.dominant_parent_flag = 'Y'
					 AND    gcr.hierarchy_id	 = p_consolidation_hierarchy
                                         AND    TO_DATE(l_cal_period_end_date, 'DD-MM-RR')
                                                        BETWEEN gcr.start_date AND     NVL(gcr.end_date,
                                                                                       TO_DATE(l_cal_period_end_date, 'DD-MM-RR')));

Line: 289

      SELECT 1
      INTO   l_process_identifier_exists
      FROM   gcs_cons_eng_runs
      WHERE  run_name=p_run_identifier;

Line: 295

        SELECT gcs_cons_eng_run_dtls_s.NEXTVAL
        INTO   p_run_identifier
        FROM   dual;

Line: 328

        SELECT value_set_name
        INTO   l_value_set_name
        FROM   fem_value_sets_vl
        WHERE  value_set_id  = l_dimension_info(l_column_name).associated_value_set_id;

Line: 365

      SELECT  source_dataset_code
      INTO    l_source_dataset_code
      FROM    gcs_data_type_codes_b
      WHERE   data_type_code      =   p_balance_type_code;

Line: 370

      SELECT  dataset_code
      INTO    l_hierarchy_dataset_code
      FROM    gcs_dataset_codes
      WHERE   hierarchy_id        =   p_consolidation_hierarchy
      AND     balance_type_code   =   p_balance_type_code;

Line: 400

    SELECT  to_char(date_assign_value, 'DD-MM-RR')
    INTO    l_cal_period_end_date
    FROM    fem_cal_periods_attr
    WHERE   attribute_id  = l_end_date_attribute_id
    AND     version_id    = l_end_date_version_id
    AND     cal_period_id = p_cal_period_id;

Line: 411

      UPDATE gcs_cons_eng_runs
      SET    most_recent_flag       =       'X'
      WHERE  most_recent_flag       =       'Y'
      AND    run_entity_id          =       p_consolidation_entity
      AND    hierarchy_id           =       p_consolidation_hierarchy
      AND    cal_period_id          =       p_cal_period_id
      AND    balance_type_code      =       p_balance_type_code;

Line: 419

      UPDATE gcs_cons_eng_runs gcer
      SET    gcer.most_recent_flag  =       'X'
      WHERE  gcer.most_recent_flag  =       'Y'
      AND    gcer.hierarchy_id      =       p_consolidation_hierarchy
      AND    gcer.cal_period_id     =       p_cal_period_id
      AND    gcer.balance_type_code =       p_balance_type_code
      AND    EXISTS                         (SELECT 'X'
                                             FROM   gcs_cons_relationships gcr
                                             WHERE  gcr.child_entity_id = gcer.run_entity_id
                                             START WITH gcr.parent_entity_id = p_consolidation_entity
                                             AND    gcr.hierarchy_id         = p_consolidation_hierarchy
                                             AND    TO_DATE(l_cal_period_end_date, 'DD-MM-RR')
                                                        BETWEEN gcr.start_date AND     NVL(gcr.end_date,
                                                                                       TO_DATE(l_cal_period_end_date, 'DD-MM-RR'))
                                             CONNECT BY PRIOR gcr.child_entity_id = gcr.parent_entity_id
					     --Bugfix 4122843: Added dominant parent flag condition
					     AND    gcr.dominant_parent_flag = 'Y'
                                             AND    gcr.hierarchy_id         = p_consolidation_hierarchy
                                             AND    TO_DATE(l_cal_period_end_date, 'DD-MM-RR')
                                                        BETWEEN gcr.start_date AND     NVL(gcr.end_date,
                                                                                       TO_DATE(l_cal_period_end_date, 'DD-MM-RR')));

Line: 444

   SELECT entity_name || ' (' || FND_GLOBAL.CONC_REQUEST_ID || ')'
   INTO   l_event_key
   FROM   fem_entities_vl
   WHERE  entity_id      =       p_consolidation_entity;

Line: 451

   GCS_CONS_ENG_RUNS_PKG.insert_row
   (
     p_run_name              =>      p_run_identifier,
     p_hierarchy_id          =>      p_consolidation_hierarchy,
     p_process_method_code   =>      NVL(p_process_method, 'FULL'),
     p_run_entity_id         =>      p_consolidation_entity,
     p_cal_period_id         =>      p_cal_period_id,
     p_balance_type_code     =>      p_balance_type_code,
     p_parent_entity_id      =>      -1,
     p_item_key              =>      l_event_key,
     p_request_id	     =>	     FND_GLOBAL.CONC_REQUEST_ID
   );

Line: 465

   INSERT INTO gcs_flattened_relns
   (run_name,
    parent_entity_id,
    child_entity_id,
    creation_date,
    created_by,
    last_update_date,
    last_updated_by,
    last_update_login,
    object_version_number,
    --Bugfix 5091093: Added consolidation type code
    consolidation_type_code
   )
   SELECT     p_run_identifier,
              p_consolidation_entity,
              gcr.child_entity_id,
              sysdate,
              fnd_global.user_id,
              sysdate,
              fnd_global.user_id,
              fnd_global.login_id,
              1,
              gtb.consolidation_type_code
   FROM        gcs_cons_relationships gcr,
    --Bugfix 5091093: Added join for consolidation type code
               gcs_treatments_b gtb
   WHERE       gtb.treatment_id(+)         =    gcr.treatment_id
   START WITH  gcr.parent_entity_id        =    p_consolidation_entity
   AND         gcr.hierarchy_id            =    p_consolidation_hierarchy
   --Bugfix 5192720: Added dominant parent flag join condition
   AND         gcr.dominant_parent_flag    =    'Y'
   AND         TO_DATE(l_cal_period_end_date, 'DD-MM-RR')
               BETWEEN gcr.start_date AND NVL(gcr.end_date,  TO_DATE(l_cal_period_end_date, 'DD-MM-RR'))
   CONNECT BY  PRIOR gcr.child_entity_id   =    gcr.parent_entity_id
   AND         gcr.hierarchy_id            =    p_consolidation_hierarchy
   AND         gcr.dominant_parent_flag    =    'Y'
   AND         TO_DATE(l_cal_period_end_date, 'DD-MM-RR')
               BETWEEN gcr.start_date AND NVL(gcr.end_date,  TO_DATE(l_cal_period_end_date, 'DD-MM-RR'));

Line: 535

      UPDATE gcs_cons_eng_runs
      SET    most_recent_flag       =       'Y'
      WHERE  most_recent_flag       =       'X'
      AND    run_entity_id          =       p_consolidation_entity
      AND    hierarchy_id           =       p_consolidation_hierarchy
      AND    cal_period_id          =       p_cal_period_id
      AND    balance_type_code      =       p_balance_type_code;

Line: 543

      UPDATE gcs_cons_eng_runs gcer
      SET    gcer.most_recent_flag  =       'Y'
      WHERE  gcer.most_recent_flag  =       'X'
      AND    gcer.hierarchy_id      =       p_consolidation_hierarchy
      AND    gcer.cal_period_id     =       p_cal_period_id
      AND    gcer.balance_type_code =       p_balance_type_code
      AND    EXISTS                         (SELECT 'X'
                                             FROM   gcs_cons_relationships gcr
                                             WHERE  gcr.child_entity_id = gcer.run_entity_id
                                             START WITH gcr.parent_entity_id = p_consolidation_entity
                                             AND    gcr.hierarchy_id         = p_consolidation_hierarchy
                                             AND    TO_DATE(l_cal_period_end_date, 'DD-MM-RR')
                                                        BETWEEN gcr.start_date AND     NVL(gcr.end_date,
                                                                                       TO_DATE(l_cal_period_end_date, 'DD-MM-RR'))
                                             CONNECT BY PRIOR gcr.child_entity_id = gcr.parent_entity_id
                                             --Bugfix 4122843: Added dominant parent flag condition
                                             AND    gcr.dominant_parent_flag = 'Y'
                                             AND    gcr.hierarchy_id         = p_consolidation_hierarchy
                                             AND    TO_DATE(l_cal_period_end_date, 'DD-MM-RR')
                                                        BETWEEN gcr.start_date AND     NVL(gcr.end_date,
                                                                                       TO_DATE(l_cal_period_end_date, 'DD-MM-RR')));