APPS.GCS_AGGREGATION_DYN_BUILD_PKG SQL Statements

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

Line: 326

  PROCEDURE insert_full_entry_lines(
    p_entry_id           NUMBER,
    p_stat_entry_id      NUMBER,
    p_cons_entity_id     NUMBER,
    p_hierarchy_id       NUMBER,
    p_relationship_id    NUMBER,
    p_cal_period_id      NUMBER,
    p_period_end_date    DATE,
    p_currency_code      VARCHAR2,
    p_balance_type_code  VARCHAR2,
    p_dataset_code       NUMBER)
  IS
    fn_name               VARCHAR2(30) := ''INSERT_FULL_ENTRY_LINES'';

Line: 348

      SELECT child_entity_id,
             gcs_utility_pkg.get_org_id(child_entity_id, hierarchy_id) org_id
      FROM  gcs_cons_relationships
      WHERE hierarchy_id = p_hierarchy_id
      AND   parent_entity_id = p_cons_entity_id
      AND   actual_ownership_flag = ''Y'';

Line: 366

    SELECT balance_by_org_flag
    INTO   l_bal_by_org_flag
    FROM   gcs_hierarchies_b
    WHERE  hierarchy_id = p_hierarchy_id;

Line: 383

      INSERT /*+ APPEND */ INTO GCS_ENTRY_LINES
        (entry_id, line_type_code,
         company_cost_center_org_id, line_item_id, intercompany_id,
';

Line: 405

         last_update_date, last_updated_by, last_update_login)
      SELECT
        decode(currency_code, ''STAT'', p_stat_entry_id, p_entry_id), null,
        company_cost_center_org_id, line_item_id, intercompany_id,
';

Line: 479

      SELECT specific_intercompany_id
      INTO   l_intercompany_id
      FROM   GCS_CATEGORIES_B
      WHERE  category_code = ''AGGREGATION'';

Line: 511

      INSERT INTO gcs_entry_lines_gt
        (entry_id, line_item_id, company_cost_center_org_id, intercompany_id,
';

Line: 531

      SELECT
        decode(currency_code, ''STAT'', p_stat_entry_id, p_entry_id),
        fb.line_item_id,
';

Line: 632

    UPDATE gcs_entry_lines_gt gelg
       SET company_cost_center_org_id = l_default_org_id,
           intercompany_id = DECODE(intercompany_id, company_cost_center_org_id,
                                    DECODE(l_intercompany_id, NULL, l_default_org_id),
                                    intercompany_id)
     WHERE (
';

Line: 655

                   SELECT
' || g_subqry_grp;

Line: 680

                               SELECT     gcr.curr_treatment_id
                                     FROM gcs_cons_relationships gcr
                               START WITH gcr.hierarchy_id = p_hierarchy_id
                                      AND gcr.parent_entity_id =
                                                              p_cons_entity_id
                                      AND gcr.actual_ownership_flag = ''Y''
                                      AND p_period_end_date
                                             BETWEEN gcr.start_date
                                                 AND NVL (gcr.end_date,
                                                          p_period_end_date
                                                         )
                               CONNECT BY PRIOR gcr.child_entity_id =
                                                          gcr.parent_entity_id
                                      AND gcr.hierarchy_id = p_hierarchy_id
                                      AND gcr.actual_ownership_flag = ''Y''
                                      AND p_period_end_date
                                             BETWEEN gcr.start_date
                                                 AND NVL (gcr.end_date,
                                                          p_period_end_date
                                                         ))
                   GROUP BY
' || g_subqry_grp ||'  line_item_id, cr2.child_entity_id);

Line: 703

         INSERT /*+ append */INTO gcs_entry_lines
                     (entry_id, company_cost_center_org_id, line_item_id,
                      intercompany_id,
 ';

Line: 725

                      creation_date, created_by, last_update_date,
                      last_updated_by, last_update_login)
            SELECT   entry_id, company_cost_center_org_id, line_item_id,
                     intercompany_id,
 ';

Line: 778

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

Line: 801

  END insert_full_entry_lines;