APPS.GCS_AGGREGATION_PKG SQL Statements

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

Line: 27

  PROCEDURE insert_prop_entry_lines(
    p_prop_entry_id      NUMBER,
    p_full_entry_id      NUMBER,
    p_ownership_percent  NUMBER,
    p_curr_round_factor  NUMBER)
  IS
    fn_name               VARCHAR2(30) := 'INSERT_PROP_ENTRY_LINES';

Line: 44

    INSERT INTO GCS_ENTRY_LINES gel1
	(entry_id, line_type_code,
	 company_cost_center_org_id, financial_elem_id, product_id,
	 natural_account_id, channel_id, line_item_id, project_id,
	 customer_id, intercompany_id, task_id,
	 user_dim1_id, user_dim2_id, user_dim3_id, user_dim4_id,
	 user_dim5_id, user_dim6_id, user_dim7_id, user_dim8_id,
	 user_dim9_id, user_dim10_id,
	 xtd_balance_e, ytd_balance_e,
	 ptd_debit_balance_e, ptd_credit_balance_e,
	 ytd_debit_balance_e, ytd_credit_balance_e,
	 creation_date, created_by,
	 last_update_date, last_updated_by, last_update_login)
    SELECT
	p_prop_entry_id, line_type_code,
	company_cost_center_org_id, financial_elem_id, product_id,
	natural_account_id, channel_id, line_item_id, project_id,
	customer_id, intercompany_id, task_id,
	user_dim1_id, user_dim2_id, user_dim3_id, user_dim4_id,
	user_dim5_id, user_dim6_id, user_dim7_id, user_dim8_id,
	user_dim9_id, user_dim10_id,
	round((xtd_balance_e * p_ownership_percent / 100) /
	      p_curr_round_factor) * p_curr_round_factor,
	round((ytd_balance_e * p_ownership_percent / 100) /
	      p_curr_round_factor) * p_curr_round_factor,
	round((ptd_debit_balance_e * p_ownership_percent / 100) /
	      p_curr_round_factor) * p_curr_round_factor,
	round((ptd_credit_balance_e * p_ownership_percent / 100) /
	      p_curr_round_factor) * p_curr_round_factor,
	round((ytd_debit_balance_e * p_ownership_percent / 100) /
	      p_curr_round_factor) * p_curr_round_factor,
	round((ytd_credit_balance_e * p_ownership_percent / 100) /
	      p_curr_round_factor) * p_curr_round_factor,
	sysdate, created_by,
	sysdate, last_updated_by, last_update_login
    FROM   GCS_ENTRY_LINES gel2
    WHERE  gel2.entry_id = p_full_entry_id;

Line: 85

                     'Inserted ' || to_char(SQL%ROWCOUNT) || ' row(s)');

Line: 108

  END insert_prop_entry_lines;

Line: 235

    GCS_AGGREGATION_DYNAMIC_PKG.insert_full_entry_lines(
      p_entry_id,
      p_stat_entry_id,
      p_cons_entity_id,
      p_hierarchy_id,
      p_relationship_id,
      p_cal_period_id,
      p_period_end_date,
      p_cons_entity_curr,
      p_balance_type_code,
      p_dataset_code);

Line: 249

      insert_prop_entry_lines(p_prop_entry_id,
                              p_entry_id,
                              p_ownership_percent,
                              p_curr_round_factor);

Line: 255

        insert_prop_entry_lines(p_stat_prop_entry_id,
                                p_stat_entry_id,
                                p_ownership_percent,
                                p_stat_round_factor);

Line: 370

    SELECT currency_code
    INTO   l_cons_entity_curr
    FROM   GCS_ENTITY_CONS_ATTRS
    WHERE  hierarchy_id = p_hierarchy_id
    AND    entity_id = p_cons_entity_id;

Line: 377

    SELECT nvl(min(gt.consolidation_type_code), 'FULL'),
           min(gcr.ownership_percent)
    INTO   l_consolidation_type, l_ownership_percent
    FROM   GCS_CONS_RELATIONSHIPS gcr,
           GCS_TREATMENTS_B gt
    WHERE  gcr.cons_relationship_id = p_relationship_id
    AND    gcr.actual_ownership_flag = 'Y'
    AND    gt.treatment_id = gcr.treatment_id;

Line: 388

      SELECT nvl(minimum_accountable_unit, power(10, -precision))
      INTO   l_curr_round_factor
      FROM   FND_CURRENCIES
      WHERE  currency_code = l_cons_entity_curr;

Line: 395

        SELECT nvl(minimum_accountable_unit, power(10, -precision))
        INTO   l_stat_round_factor
        FROM   FND_CURRENCIES
        WHERE  currency_code = 'STAT';

Line: 426

      GCS_CONS_ENG_RUN_DTLS_PKG.update_entry_headers(p_run_detail_id,
                                                     l_prop_entry_id,
                                                     l_stat_prop_entry_id,
                                                     l_entry_id,
                                                     l_stat_entry_id);

Line: 433

      GCS_CONS_ENG_RUN_DTLS_PKG.update_entry_headers(p_run_detail_id,
                                                     l_entry_id,
                                                     l_stat_entry_id);