APPS.XTR_REVALUATION_DETAILS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_REVALUATION_DETAILS_ID in NUMBER,
  X_ACCOUNT_NO in VARCHAR2,
  X_REVAL_CURR_FV_AMOUNT in NUMBER,
  X_COMPLETE_FLAG in VARCHAR2,
  X_FAIR_VALUE in NUMBER,
  X_SWAP_REF in VARCHAR2,
  X_CUMM_GAIN_LOSS_AMOUNT in NUMBER,
  X_CURR_GAIN_LOSS_AMOUNT in NUMBER,
  X_SOB_FV_GAIN_LOSS_AMOUNT in NUMBER,
  X_SOB_FAIR_VALUE_AMOUNT in NUMBER,
  X_CTR_CURR_SOB_CURR_FWD_RATE in NUMBER,
  X_EXCHANGE_RATE_TWO in NUMBER,
  X_ACTION_CODE in VARCHAR2,
  X_COMPANY_CODE in VARCHAR2,
  X_CONTRACT_CODE in VARCHAR2,
  X_CURRENCYA in VARCHAR2,
  X_CURRENCYB in VARCHAR2,
  X_DEAL_NO in NUMBER,
  X_DEAL_SUBTYPE in VARCHAR2,
  X_DEAL_TYPE in VARCHAR2,
  X_EFFECTIVE_DATE in DATE,
  X_EFFECTIVE_DAYS in NUMBER,
  X_ENTERED_BY in VARCHAR2,
  X_ENTERED_ON in DATE,
  X_FACE_VALUE in NUMBER,
  X_FXO_SELL_REF_AMOUNT in NUMBER,
  X_PERIOD_FROM in DATE,
  X_PERIOD_TO in DATE,
  X_PORTFOLIO_CODE in VARCHAR2,
  X_PRODUCT_TYPE in VARCHAR2,
  X_REALISED_PL in NUMBER,
  X_REVAL_CCY in VARCHAR2,
  X_REVAL_RATE in NUMBER,
  X_TRANSACTION_NO in NUMBER,
  X_TRANSACTION_PERIOD in NUMBER,
  X_TRANSACTION_RATE in NUMBER,
  X_UNREALISED_PL in NUMBER,
  X_UPDATED_BY in VARCHAR2,
  X_UPDATED_ON in DATE,
  X_YEAR_BASIS in NUMBER,
  X_CREATED_ON in DATE,
  X_EXCHANGE_RATE_ONE in NUMBER,
  X_REALIZED_FLAG in VARCHAR2,
  X_OVERWRITE_TYPE in VARCHAR2,
  X_OVERWRITE_VALUE in NUMBER,
  X_OVERWRITE_REASON in VARCHAR2,
  X_BATCH_ID in NUMBER,
  X_CREATED_BY in NUMBER,
  X_NI_DISC_AMOUNT in NUMBER,
  X_AMOUNT_TYPE in VARCHAR2,
  X_QUANTITY in NUMBER
) is
  cursor C is select ROWID from XTR_REVALUATION_DETAILS
    where REVALUATION_DETAILS_ID = X_REVALUATION_DETAILS_ID
    ;

Line: 61

  insert into XTR_REVALUATION_DETAILS (
    ACCOUNT_NO,
    BATCH_ID,
    REVALUATION_DETAILS_ID,
    REVAL_CURR_FV_AMOUNT,
    COMPLETE_FLAG,
    FAIR_VALUE,
    SWAP_REF,
    CUMM_GAIN_LOSS_AMOUNT,
    CURR_GAIN_LOSS_AMOUNT,
    SOB_FV_GAIN_LOSS_AMOUNT,
    SOB_FAIR_VALUE_AMOUNT,
    CTR_CURR_SOB_CURR_FWD_RATE,
    EXCHANGE_RATE_TWO,
    ACTION_CODE,
    COMPANY_CODE,
    CONTRACT_CODE,
    CURRENCYA,
    CURRENCYB,
    DEAL_NO,
    DEAL_SUBTYPE,
    DEAL_TYPE,
    EFFECTIVE_DATE,
    EFFECTIVE_DAYS,
    ENTERED_BY,
    ENTERED_ON,
    FACE_VALUE,
    FXO_SELL_REF_AMOUNT,
    PERIOD_FROM,
    PERIOD_TO,
    PORTFOLIO_CODE,
    PRODUCT_TYPE,
    REALISED_PL,
    REVAL_CCY,
    REVAL_RATE,
    TRANSACTION_NO,
    TRANSACTION_PERIOD,
    TRANSACTION_RATE,
    UNREALISED_PL,
    UPDATED_BY,
    UPDATED_ON,
    YEAR_BASIS,
    CREATED_BY,
    CREATED_ON,
    EXCHANGE_RATE_ONE,
    REALIZED_FLAG,
    OVERWRITE_TYPE,
    OVERWRITE_VALUE,
    OVERWRITE_REASON,
    NI_DISC_AMOUNT,
    AMOUNT_TYPE,
    QUANTITY
  ) values
(
    X_ACCOUNT_NO,
    X_BATCH_ID,
    X_REVALUATION_DETAILS_ID,
    X_REVAL_CURR_FV_AMOUNT,
    X_COMPLETE_FLAG,
    X_FAIR_VALUE,
    X_SWAP_REF,
    X_CUMM_GAIN_LOSS_AMOUNT,
    X_CURR_GAIN_LOSS_AMOUNT,
    X_SOB_FV_GAIN_LOSS_AMOUNT,
    X_SOB_FAIR_VALUE_AMOUNT,
    X_CTR_CURR_SOB_CURR_FWD_RATE,
    X_EXCHANGE_RATE_TWO,
    X_ACTION_CODE,
    X_COMPANY_CODE,
    X_CONTRACT_CODE,
    X_CURRENCYA,
    X_CURRENCYB,
    X_DEAL_NO,
    X_DEAL_SUBTYPE,
    X_DEAL_TYPE,
    X_EFFECTIVE_DATE,
    X_EFFECTIVE_DAYS,
    X_ENTERED_BY,
    X_ENTERED_ON,
    X_FACE_VALUE,
    X_FXO_SELL_REF_AMOUNT,
    X_PERIOD_FROM,
    X_PERIOD_TO,
    X_PORTFOLIO_CODE,
    X_PRODUCT_TYPE,
    X_REALISED_PL,
    X_REVAL_CCY,
    X_REVAL_RATE,
    X_TRANSACTION_NO,
    X_TRANSACTION_PERIOD,
    X_TRANSACTION_RATE,
    X_UNREALISED_PL,
    X_UPDATED_BY,
    X_UPDATED_ON,
    X_YEAR_BASIS,
    X_CREATED_BY,
    X_CREATED_ON,
    X_EXCHANGE_RATE_ONE,
    X_REALIZED_FLAG,
    X_OVERWRITE_TYPE,
    X_OVERWRITE_VALUE,
    X_OVERWRITE_REASON,
    X_NI_DISC_AMOUNT,
    X_AMOUNT_TYPE,
    X_QUANTITY
);

Line: 176

end INSERT_ROW;

Line: 216

  X_UPDATED_BY in VARCHAR2,
  X_UPDATED_ON in DATE,
  X_YEAR_BASIS in NUMBER,
  X_CREATED_ON in DATE,
  X_EXCHANGE_RATE_ONE in NUMBER,
  X_REALIZED_FLAG in VARCHAR2,
  X_OVERWRITE_TYPE in VARCHAR2,
  X_OVERWRITE_VALUE in NUMBER,
  X_OVERWRITE_REASON in VARCHAR2,
  X_BATCH_ID in NUMBER,
  X_NI_DISC_AMOUNT in NUMBER,
  X_AMOUNT_TYPE in VARCHAR2,
  X_QUANTITY in NUMBER
) is
  cursor c1 is select
      ACCOUNT_NO,
      REVAL_CURR_FV_AMOUNT,
      COMPLETE_FLAG,
      FAIR_VALUE,
      SWAP_REF,
      CUMM_GAIN_LOSS_AMOUNT,
      CURR_GAIN_LOSS_AMOUNT,
      SOB_FV_GAIN_LOSS_AMOUNT,
      SOB_FAIR_VALUE_AMOUNT,
      CTR_CURR_SOB_CURR_FWD_RATE,
      EXCHANGE_RATE_TWO,
      ACTION_CODE,
      COMPANY_CODE,
      CONTRACT_CODE,
      CURRENCYA,
      CURRENCYB,
      DEAL_NO,
      DEAL_SUBTYPE,
      DEAL_TYPE,
      EFFECTIVE_DATE,
      EFFECTIVE_DAYS,
      ENTERED_BY,
      ENTERED_ON,
      FACE_VALUE,
      FXO_SELL_REF_AMOUNT,
      PERIOD_FROM,
      PERIOD_TO,
      PORTFOLIO_CODE,
      PRODUCT_TYPE,
      REALISED_PL,
      REVAL_CCY,
      REVAL_RATE,
      TRANSACTION_NO,
      TRANSACTION_PERIOD,
      TRANSACTION_RATE,
      UNREALISED_PL,
      UPDATED_BY,
      UPDATED_ON,
      YEAR_BASIS,
      CREATED_ON,
      EXCHANGE_RATE_ONE,
      REALIZED_FLAG,
      OVERWRITE_TYPE,
      OVERWRITE_VALUE,
      OVERWRITE_REASON,
      BATCH_ID,
      NI_DISC_AMOUNT,
      AMOUNT_TYPE,
      QUANTITY
    from XTR_REVALUATION_DETAILS
    where REVALUATION_DETAILS_ID = X_REVALUATION_DETAILS_ID
    for update of REVALUATION_DETAILS_ID nowait;

Line: 345

          AND ((tlinfo.UPDATED_BY = X_UPDATED_BY)
               OR ((tlinfo.UPDATED_BY is null) AND (X_UPDATED_BY is null)))
          AND ((tlinfo.UPDATED_ON = X_UPDATED_ON)
               OR ((tlinfo.UPDATED_ON is null) AND (X_UPDATED_ON is null)))
          AND ((tlinfo.YEAR_BASIS = X_YEAR_BASIS)
               OR ((tlinfo.YEAR_BASIS is null) AND (X_YEAR_BASIS is null)))
          AND (tlinfo.CREATED_ON = X_CREATED_ON)
          AND ((tlinfo.EXCHANGE_RATE_ONE = X_EXCHANGE_RATE_ONE)
               OR ((tlinfo.EXCHANGE_RATE_ONE is null) AND (X_EXCHANGE_RATE_ONE is null)))
          AND ((tlinfo.REALIZED_FLAG = X_REALIZED_FLAG)
               OR ((tlinfo.REALIZED_FLAG is null) AND (X_REALIZED_FLAG is null)))
          AND ((tlinfo.OVERWRITE_TYPE = X_OVERWRITE_TYPE)
               OR ((tlinfo.OVERWRITE_TYPE is null) AND (X_OVERWRITE_TYPE is null)))
          AND ((tlinfo.OVERWRITE_VALUE = X_OVERWRITE_VALUE)
               OR ((tlinfo.OVERWRITE_VALUE is null) AND (X_OVERWRITE_VALUE is null)))
          AND ((tlinfo.OVERWRITE_REASON = X_OVERWRITE_REASON)
               OR ((tlinfo.OVERWRITE_REASON is null) AND (X_OVERWRITE_REASON is null)))
      ) then
        null;

Line: 372

procedure UPDATE_ROW (
  X_REVALUATION_DETAILS_ID in NUMBER,
  X_ACCOUNT_NO in VARCHAR2,
  X_REVAL_CURR_FV_AMOUNT in NUMBER,
  X_COMPLETE_FLAG in VARCHAR2,
  X_FAIR_VALUE in NUMBER,
  X_SWAP_REF in VARCHAR2,
  X_CUMM_GAIN_LOSS_AMOUNT in NUMBER,
  X_CURR_GAIN_LOSS_AMOUNT in NUMBER,
  X_SOB_FV_GAIN_LOSS_AMOUNT in NUMBER,
  X_SOB_FAIR_VALUE_AMOUNT in NUMBER,
  X_CTR_CURR_SOB_CURR_FWD_RATE in NUMBER,
  X_EXCHANGE_RATE_TWO in NUMBER,
  X_ACTION_CODE in VARCHAR2,
  X_COMPANY_CODE in VARCHAR2,
  X_CONTRACT_CODE in VARCHAR2,
  X_CURRENCYA in VARCHAR2,
  X_CURRENCYB in VARCHAR2,
  X_DEAL_NO in NUMBER,
  X_DEAL_SUBTYPE in VARCHAR2,
  X_DEAL_TYPE in VARCHAR2,
  X_EFFECTIVE_DATE in DATE,
  X_EFFECTIVE_DAYS in NUMBER,
  X_ENTERED_BY in VARCHAR2,
  X_ENTERED_ON in DATE,
  X_FACE_VALUE in NUMBER,
  X_FXO_SELL_REF_AMOUNT in NUMBER,
  X_PERIOD_FROM in DATE,
  X_PERIOD_TO in DATE,
  X_PORTFOLIO_CODE in VARCHAR2,
  X_PRODUCT_TYPE in VARCHAR2,
  X_REALISED_PL in NUMBER,
  X_REVAL_CCY in VARCHAR2,
  X_REVAL_RATE in NUMBER,
  X_TRANSACTION_NO in NUMBER,
  X_TRANSACTION_PERIOD in NUMBER,
  X_TRANSACTION_RATE in NUMBER,
  X_UNREALISED_PL in NUMBER,
  X_UPDATED_BY in VARCHAR2,
  X_UPDATED_ON in DATE,
  X_YEAR_BASIS in NUMBER,
  X_CREATED_ON in DATE,
  X_EXCHANGE_RATE_ONE in NUMBER,
  X_REALIZED_FLAG in VARCHAR2,
  X_OVERWRITE_TYPE in VARCHAR2,
  X_OVERWRITE_VALUE in NUMBER,
  X_OVERWRITE_REASON in VARCHAR2,
  X_BATCH_ID in NUMBER,
  X_NI_DISC_AMOUNT in NUMBER,
  X_AMOUNT_TYPE in VARCHAR2,
  X_QUANTITY in NUMBER
) is
begin
  update XTR_REVALUATION_DETAILS set
    ACCOUNT_NO = X_ACCOUNT_NO,
    REVAL_CURR_FV_AMOUNT = X_REVAL_CURR_FV_AMOUNT,
    COMPLETE_FLAG = X_COMPLETE_FLAG,
    FAIR_VALUE = X_FAIR_VALUE,
    SWAP_REF = X_SWAP_REF,
    CUMM_GAIN_LOSS_AMOUNT = X_CUMM_GAIN_LOSS_AMOUNT,
    CURR_GAIN_LOSS_AMOUNT = X_CURR_GAIN_LOSS_AMOUNT,
    SOB_FV_GAIN_LOSS_AMOUNT = X_SOB_FV_GAIN_LOSS_AMOUNT,
    SOB_FAIR_VALUE_AMOUNT = X_SOB_FAIR_VALUE_AMOUNT,
    CTR_CURR_SOB_CURR_FWD_RATE = X_CTR_CURR_SOB_CURR_FWD_RATE,
    EXCHANGE_RATE_TWO = X_EXCHANGE_RATE_TWO,
    ACTION_CODE = X_ACTION_CODE,
    COMPANY_CODE = X_COMPANY_CODE,
    CONTRACT_CODE = X_CONTRACT_CODE,
    CURRENCYA = X_CURRENCYA,
    CURRENCYB = X_CURRENCYB,
    DEAL_NO = X_DEAL_NO,
    DEAL_SUBTYPE = X_DEAL_SUBTYPE,
    DEAL_TYPE = X_DEAL_TYPE,
    EFFECTIVE_DATE = X_EFFECTIVE_DATE,
    EFFECTIVE_DAYS = X_EFFECTIVE_DAYS,
    ENTERED_BY = X_ENTERED_BY,
    ENTERED_ON = X_ENTERED_ON,
    FACE_VALUE = X_FACE_VALUE,
    FXO_SELL_REF_AMOUNT = X_FXO_SELL_REF_AMOUNT,
    PERIOD_FROM = X_PERIOD_FROM,
    PERIOD_TO = X_PERIOD_TO,
    PORTFOLIO_CODE = X_PORTFOLIO_CODE,
    PRODUCT_TYPE = X_PRODUCT_TYPE,
    REALISED_PL = X_REALISED_PL,
    REVAL_CCY = X_REVAL_CCY,
    REVAL_RATE = X_REVAL_RATE,
    TRANSACTION_NO = X_TRANSACTION_NO,
    TRANSACTION_PERIOD = X_TRANSACTION_PERIOD,
    TRANSACTION_RATE = X_TRANSACTION_RATE,
    UNREALISED_PL = X_UNREALISED_PL,
    UPDATED_BY = X_UPDATED_BY,
    UPDATED_ON = X_UPDATED_ON,
    YEAR_BASIS = X_YEAR_BASIS,
    CREATED_ON = X_CREATED_ON,
    EXCHANGE_RATE_ONE = X_EXCHANGE_RATE_ONE,
    REALIZED_FLAG = X_REALIZED_FLAG,
    OVERWRITE_TYPE = X_OVERWRITE_TYPE,
    OVERWRITE_VALUE = X_OVERWRITE_VALUE,
    OVERWRITE_REASON = X_OVERWRITE_REASON,
    BATCH_ID = X_BATCH_ID,
    NI_DISC_AMOUNT = X_NI_DISC_AMOUNT,
    AMOUNT_TYPE = X_AMOUNT_TYPE,
    QUANTITY = X_QUANTITY
  where REVALUATION_DETAILS_ID = X_REVALUATION_DETAILS_ID;

Line: 480

end UPDATE_ROW;

Line: 482

procedure DELETE_ROW (
  X_REVALUATION_DETAILS_ID in NUMBER
) is
begin
  delete from XTR_REVALUATION_DETAILS
  where REVALUATION_DETAILS_ID = X_REVALUATION_DETAILS_ID;

Line: 493

end DELETE_ROW;