APPS.CST_MGD_INFL_ADJUSTMENT_CP SQL Statements

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

Line: 46

  SELECT
    COUNT(*)
  FROM cst_mgd_infl_adj_per_statuses
  WHERE organization_ID = c_org_id
    AND acct_period_id  = c_acct_period_id
    AND status = 'PROCESS';

Line: 125

  SELECT
    COUNT(1)
  INTO
    l_status
  FROM
    CST_MGD_INFL_ADJ_PER_STATUSES a
  , ORG_ACCT_PERIODS b
  WHERE a.Organization_ID = p_org_id
    AND a.Acct_Period_ID  = p_acct_period_id
    AND a.Status          = 'FINAL'
    AND b.Acct_Period_ID  = p_acct_period_id
    AND b.Organization_ID = p_org_id
    AND b.Open_Flag       = 'N'
    AND b.Period_Close_Date IS NOT NULL;

Line: 203

  SELECT
    Price_Index_Value/100
  INTO
    x_inflation_index_value
  FROM
    FA_PRICE_INDEX_VALUES a
  , FA_PRICE_INDEXES b
  , ORG_ACCT_PERIODS c
  WHERE c.Acct_Period_ID   = p_acct_period_id
    AND c.Organization_ID  = p_org_id
    AND b.Price_Index_Name = p_inflation_index
    AND a.Price_Index_ID   = b.Price_Index_ID
    AND a.From_Date        = c.Period_Start_Date
    AND a.To_Date          = c.Schedule_Close_Date
    AND c.Open_Flag        = 'N';

Line: 258

  SELECT
    default_cost_group_id
   FROM MTL_PARAMETERS
  WHERE organization_id = p_org_id;

Line: 350

  SELECT
    DISTINCT inventory_item_id
  FROM
    cst_period_close_summary
  WHERE acct_period_id  = c_acct_period_id
    AND organization_id = c_organization_id
    AND cost_group_id   = c_cost_group_id
    AND CST_MGD_INFL_ADJUSTMENT_PVT.Infl_Item_Category(inventory_item_id
                                                      ,c_organization_id
                                                      ,c_category_set_id
                                                      ,c_category_id
                                                      ) = 'Y'
  UNION
  SELECT
    DISTINCT inventory_item_id
  FROM
    mtl_per_close_dtls
  WHERE acct_period_id  = c_acct_period_id
    AND organization_id = c_organization_id
    AND cost_group_id   = c_cost_group_id
    AND CST_MGD_INFL_ADJUSTMENT_PVT.Infl_Item_Category(inventory_item_id
                                                      ,c_organization_id
                                                      ,c_category_set_id
                                                      ,c_category_id
                                                      ) = 'Y';

Line: 402

  SELECT WMS_ENABLED_FLAG
  INTO l_wms_enabled_flag
  FROM MTL_PARAMETERS
  WHERE ORGANIZATION_ID = p_org_id;

Line: 505

  DELETE FROM
    CST_MGD_INFL_ADJUSTED_COSTS
  WHERE Organization_ID   = p_org_id
    AND Acct_Period_ID    = p_acct_period_id
    AND Country_Code      = p_country_code
    AND Historical_Flag   = 'N';

Line: 512

  DELETE FROM
    CST_MGD_INFL_TSF_ORG_ENTRIES
  WHERE Organization_ID   = p_org_id
    AND Acct_Period_ID    = p_acct_period_id
    AND Country_Code      = p_country_code;

Line: 524

  DELETE FROM
    CST_MGD_INFL_ADJ_PER_STATUSES
  WHERE organization_id = p_org_id
    AND acct_period_id  = p_acct_period_id
    AND status  = 'PROCESS';

Line: 582

       l_inflation_adjustment_rec.last_update_date       := SYSDATE;

Line: 583

       l_inflation_adjustment_rec.last_updated_by        :=
         NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);

Line: 588

       l_inflation_adjustment_rec.last_update_login      :=
         TO_NUMBER(fnd_profile.value('LOGIN_ID'));

Line: 596

       l_inflation_adjustment_rec.program_update_date    := SYSDATE;

Line: 721

  SELECT
    User_JE_Category_Name
  INTO
    x_user_category_name
  FROM
    GL_JE_CATEGORIES
  WHERE JE_Category_Name = p_je_category_name;

Line: 758

  SELECT
    User_JE_Source_Name
  INTO
    x_user_source_name
  FROM
    GL_JE_SOURCES
  WHERE JE_Source_Name = p_je_source_name;

Line: 824

  SELECT
    ADJ.Inventory_Item_ID
  , ADJ.Inventory_Adj_Acct_CR
  , ADJ.Inventory_Adj_Acct_DR
  , ADJ.Monetary_Corr_Acct_CR
  , ADJ.Sales_Cost_Acct_DR
  FROM
    CST_MGD_INFL_ADJUSTED_COSTS ADJ
  , MTL_SYSTEM_ITEMS SYS
  WHERE ADJ.Country_Code      = p_country_code
    AND ADJ.Acct_Period_ID    = p_acct_period_id
    AND ADJ.Organization_ID   = p_org_id
    AND ADJ.Inventory_Item_ID = SYS.Inventory_Item_ID
    AND SYS.Organization_ID   = p_org_id;

Line: 955

  CST_MGD_INFL_ADJUSTMENT_PVT.Update_Infl_Period_Status
  ( p_org_id         => p_org_id
  , p_acct_period_id => p_acct_period_id
  , x_return_status  => l_return_status
  );