APPS.CST_MGD_INFL_ADJUSTMENT_PUB SQL Statements

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

Line: 34

  INSERT INTO
    CST_MGD_INFL_ADJ_PER_STATUSES(
      Organization_ID
    , Acct_Period_ID
    , Last_Update_Date
    , Last_Updated_By
    , Creation_Date
    , Created_By
    , Last_Update_Login
    , Request_ID
    , Program_Application_ID
    , Program_ID
    , Program_Update_Date
    , STATUS
    )
  VALUES(
      p_org_id
    , p_acct_period_id
    , SYSDATE
    , NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
    , SYSDATE
    , NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
    , TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))
    , TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID'))
    , TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID'))
    , TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID'))
    , SYSDATE
    , 'FINAL'
    );

Line: 117

  DELETE FROM CST_MGD_INFL_ADJ_PER_STATUSES
  WHERE ORGANIZATION_ID = l_historical_infl_adj_rec.organization_id
    AND ACCT_PERIOD_ID  = l_historical_infl_adj_rec.acct_period_id;

Line: 141

  CST_MGD_INFL_ADJUSTMENT_PVT.Insert_Inflation_Adj
  ( p_inflation_adjustment_rec => l_historical_infl_adj_rec
  );

Line: 164

    DELETE FROM CST_MGD_INFL_ADJUSTED_COSTS
    WHERE Organization_ID = l_historical_infl_adj_rec.organization_id
      AND Acct_Period_ID  = l_historical_infl_adj_rec.acct_period_id;

Line: 175

    DELETE FROM CST_MGD_INFL_ADJUSTED_COSTS
    WHERE Organization_ID = l_historical_infl_adj_rec.organization_id
      AND Acct_Period_ID  = l_historical_infl_adj_rec.acct_period_id;

Line: 186

    DELETE FROM CST_MGD_INFL_ADJUSTED_COSTS
    WHERE Organization_ID = l_historical_infl_adj_rec.organization_id
      AND Acct_Period_ID  = l_historical_infl_adj_rec.acct_period_id;

Line: 218

PROCEDURE Delete_All_Historical_Costs (
  p_api_version_number IN  NUMBER
, p_init_msg_list      IN  VARCHAR2 := FND_API.G_FALSE
, x_return_status      OUT NOCOPY VARCHAR2
, x_msg_count          OUT NOCOPY NUMBER
, x_msg_data           OUT NOCOPY VARCHAR2
)
IS
l_return_status      VARCHAR2(1);

Line: 228

L_API_NAME           CONSTANT VARCHAR2(30) := 'Delete_All_Historical_Costs';

Line: 248

  DELETE FROM CST_MGD_INFL_ADJUSTED_COSTS;

Line: 250

  DELETE FROM CST_MGD_INFL_TSF_ORG_ENTRIES;

Line: 252

  DELETE FROM CST_MGD_INFL_ADJ_PER_STATUSES;

Line: 276

      , 'Delete_All_Historical_Costs'
      );

Line: 285

END Delete_All_Historical_Costs;