eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GCS_IMPACT_WRITER_PKG SQL Statements

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

Line: 7


FUNCTION GDSD_UPDATE_IMPACT( p_subscription_guid   IN RAW,
                             p_event IN OUT NOCOPY wf_event_t) return VARCHAR2
IS
    l_matching_ds           NUMBER;

Line: 38


    SELECT delta_run_id,
           balance_seg_value
    FROM   fem_intg_delta_loads
    WHERE  ledger_id     = p_ledger_id
    AND    cal_period_id = p_cal_period_id
    AND    loaded_flag   = 'Y';

Line: 48


    SELECT gbd.delta_run_id,
           gbd.period_name,
           gbd.currency_code,
           gbd.actual_flag
    FROM   gl_balances_delta gbd,
           gl_code_combinations gcc;

Line: 64


  SELECT gea.entity_id
  FROM   gcs_entities_attr gea,
         fem_cal_periods_attr fcpa
  WHERE  gea.ledger_id = p_ledger_id
  AND    gea.data_type_code = DECODE(p_bal_type_code, 'A', 'ACTUAL', 'N/A')
  AND    fcpa.attribute_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id
  AND    fcpa.version_id = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id
  AND    fcpa.cal_period_id = p_cal_period_id
  AND    fcpa.date_assign_value BETWEEN gea.effective_start_date
                                AND NVL(gea.effective_end_date, fcpa.date_assign_value);

Line: 83


  SELECT company_cost_center_org_id
  FROM   gcs_entity_cctr_orgs
  WHERE  entity_id = EntityId
  AND    1 = p_orgs_flag_param

  UNION

  SELECT child_id
  FROM   fem_cctr_orgs_hier
  WHERE  2 = p_orgs_flag_param
  AND    parent_value_set_id = p_fch_vsid
  AND    child_value_set_id = p_ledger_gvcd_value_set_id
  AND    parent_id IN ( SELECT company_cost_center_org_id
                        FROM   gcs_entity_cctr_orgs
                        WHERE  entity_id = EntityId )
  AND    hierarchy_obj_def_id = p_her_obj_def_id ;

Line: 103


  SELECT 1
  FROM   fem_companies_b
  WHERE  company_id           = p_company_id
  AND    company_display_code = p_comp_display_code;

Line: 112


      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_module || '.GDSD_UPDATE_IMPACT.begin', '<>');

Line: 121


     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'l_posting_run_id: '||l_posting_run_id);

Line: 129


  SELECT fch_gvcd.value_set_id
    INTO l_fch_gvcd_value_set_id
    FROM gcs_system_options gso,
         fem_global_vs_combo_defs fch_gvcd
   WHERE gso.fch_global_vs_combo_id  = fch_gvcd.global_vs_combo_id
     AND fch_gvcd.dimension_id       = 8;

Line: 137


     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'fch_vsid: '
                                                      || l_fch_gvcd_value_set_id);

Line: 144


  SELECT DISTINCT gjh.ledger_id,
         fcpt.cal_period_id,
         fcpt.cal_period_name,
         gvcd.value_set_id,
         decode(gvcd.value_set_id, l_fch_gvcd_value_set_id, 'MAPPED', 'UNMAPPED'),
         fsav.application_column_name
  BULK COLLECT
  INTO   l_ledger_period_bsv_info
  FROM   gl_je_batches gjb,
         fem_cal_periods_tl fcpt,
         gl_je_headers gjh,
         fem_intg_calendar_map ficm,
         fem_ledgers_attr fla,
         fem_global_vs_combo_defs gvcd,
         fnd_segment_attribute_values fsav
  WHERE  gjb.posting_run_id          = l_posting_run_id
  AND    gjb.status                  = 'P'
  AND    gjb.default_period_name     = fcpt.cal_period_name
  AND    gjb.je_batch_id             = gjh.je_batch_id
  AND    fcpt.language               = userenv('LANG')
  AND    fcpt.calendar_id            = ficm.calendar_id
  AND    fcpt.dimension_group_id     = ficm.dimension_group_id
  AND    ficm.period_set_name        = gjb.period_set_name
  AND    ficm.period_type            = gjb.accounted_period_type
  AND    fla.attribute_id            = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').attribute_id
  AND    fla.version_id              = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO').version_id
  AND    fla.ledger_id               = gjh.ledger_id
  AND    gvcd.global_vs_combo_id     = fla.dim_attribute_numeric_member
  AND    gvcd.dimension_id           = 8
  AND    fsav.id_flex_num            =  gjb.chart_of_accounts_id
  AND    fsav.segment_attribute_type = 'GL_BALANCING'
  AND    fsav.attribute_value        = 'Y'
  AND    fsav.application_id         = 101
  AND    fsav.id_flex_code           = 'GL#';

Line: 187


         FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'l_ledger_period_bsv_index: '
                                                          || l_ledger_period_bsv_index);

Line: 189


         FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'ledger_id: '
                                                          || l_ledger_period_bsv_info(l_ledger_period_bsv_index).ledger_id);

Line: 191


         FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'cal_period_id: '
                                                          || l_ledger_period_bsv_info(l_ledger_period_bsv_index).cal_period_id);

Line: 193


         FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'cal_period_name: '
                                                          || l_ledger_period_bsv_info(l_ledger_period_bsv_index).cal_period_name);

Line: 195


         FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'ledger_gvcd_value_set_id: '
                                                          || l_ledger_period_bsv_info(l_ledger_period_bsv_index).ledger_gvcd_value_set_id);

Line: 197


         FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'map_flag: '
                                                          || l_ledger_period_bsv_info(l_ledger_period_bsv_index).map_flag);

Line: 199


         FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'segment_column: '
                                                          || l_ledger_period_bsv_info(l_ledger_period_bsv_index).segment_column);

Line: 211


         l_inner_query :='SELECT gbd.delta_run_id, gbd.period_name, '||
                        '       gbd.currency_code, gbd.actual_flag ' ||
                        ' FROM  gl_balances_delta gbd,' ||
                        '       gl_code_combinations gcc '||
                        ' WHERE gbd.period_name = :period  '||
                        ' AND   gbd.ledger_id = :ledger' ||
                        ' AND   gcc.code_combination_id = gbd.code_combination_id '||
                        ' AND   gcc.' ||
                        l_ledger_period_bsv_info(l_ledger_period_bsv_index).segment_column ||
                        '= :balseg' ||
                        ' AND   gbd.delta_run_id > :DeltaRunId';

Line: 247


                     SELECT object_definition_id
                     INTO   l_her_obj_def_id
                     FROM   fem_object_definition_b fodb,
                            fem_xdim_dimensions fxd,
                            fem_cal_periods_attr fcpa
                     WHERE  fodb.object_id     = fxd.default_mvs_hierarchy_obj_id
                     AND    dimension_id       = 8
                     AND    fcpa.attribute_id  = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id
                     AND    fcpa.version_id    = gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id
                     AND    fcpa.cal_period_id = l_ledger_period_bsv_info(l_ledger_period_bsv_index).cal_period_id
                     AND    fcpa.date_assign_value BETWEEN effective_start_date AND effective_end_date;

Line: 263


                        FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'l_her_obj_def_id: '||l_her_obj_def_id);

Line: 275


                     SELECT dim_attribute_numeric_member
                     INTO   l_company_id
                     FROM   fem_cctr_orgs_attr fda
                     WHERE  fda.company_cost_center_org_id = rec_list_of_orgs.company_cost_center_org_id
                     AND    fda.attribute_id               = gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
                     AND    fda.version_id                 = gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id;

Line: 283


                        FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'l_company_id: '||l_company_id);

Line: 295


                         UPDATE gcs_data_sub_dtls
                         SET    status_code       = 'IMPACTED'
                         WHERE  cal_period_id     = l_ledger_period_bsv_info(l_ledger_period_bsv_index).cal_period_id
                         AND    entity_id         = rec_entity.entity_id
                         AND    currency_code     = row_inner_rec.currency_code
                         AND    most_recent_flag  = 'Y'
                         AND    balance_type_code = decode(row_inner_rec.actual_flag,'A','ACTUAL','N/A')
                         --Start Bugfix 5569620
                         RETURNING load_id INTO l_load_id;

Line: 306


                         GCS_CONS_MONITOR_PKG.update_data_status ( p_load_id => l_load_id );

Line: 312


                               FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'Data Submission Impacted for: ');

Line: 313


                               FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'Balance Type Code: '||row_inner_rec.actual_flag);

Line: 314


                               FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'Cal Period Id: '||l_ledger_period_bsv_info(l_ledger_period_bsv_index).cal_period_id);

Line: 315


                               FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'Entity Id: '||rec_entity.entity_id);

Line: 316


                               FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_module || '.GDSD_UPDATE_IMPACT', 'Currency Code: '||row_inner_rec.currency_code);

Line: 336


      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_module || '.GDSD_UPDATE_IMPACT.end', '<>');

Line: 345


                    FND_LOG.STRING(FND_LOG.LEVEL_ERROR, g_module || '.GDSD_UPDATE_IMPACT.end', SUBSTR(SQLERRM, 1, 255));

Line: 350


END GDSD_UPDATE_IMPACT;