APPS.XTR_GAIN_LOSS_DNM_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_ROWID in OUT NOCOPY VARCHAR2,
  X_GAIN_LOSS_DNM_ID in NUMBER,
  X_BATCH_ID in NUMBER,
  X_COMPANY_CODE in VARCHAR2,
  X_DEAL_NUMBER in NUMBER,
  X_TRANSACTION_NUMBER in NUMBER,
  X_DATE_TYPE in VARCHAR2,
  X_AMOUNT in NUMBER,
  X_AMOUNT_TYPE in VARCHAR2,
  X_ACTION in VARCHAR2,
  X_CURRENCY in VARCHAR2,
  X_JOURNAL_DATE in DATE,
  X_REVAL_EFF_FLAG in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
  cursor C is select ROWID from XTR_GAIN_LOSS_DNM
    where GAIN_LOSS_DNM_ID = X_GAIN_LOSS_DNM_ID
    ;

Line: 28

  insert into XTR_GAIN_LOSS_DNM (
    LAST_UPDATE_LOGIN,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    COMPANY_CODE,
    DEAL_NUMBER,
    TRANSACTION_NUMBER,
    DATE_TYPE,
    AMOUNT,
    AMOUNT_TYPE,
    ACTION,
    CURRENCY,
    JOURNAL_DATE,
    CREATION_DATE,
    CREATED_BY,
    GAIN_LOSS_DNM_ID,
    BATCH_ID,
    REVAL_EFF_FLAG
  ) VALUES
  ( X_LAST_UPDATE_LOGIN,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_COMPANY_CODE,
    X_DEAL_NUMBER,
    X_TRANSACTION_NUMBER,
    X_DATE_TYPE,
    X_AMOUNT,
    X_AMOUNT_TYPE,
    X_ACTION,
    X_CURRENCY,
    X_JOURNAL_DATE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_GAIN_LOSS_DNM_ID,
    X_BATCH_ID,
    X_REVAL_EFF_FLAG);

Line: 73

end INSERT_ROW;

Line: 89

  cursor c1 is select
      COMPANY_CODE,
      DEAL_NUMBER,
      TRANSACTION_NUMBER,
      DATE_TYPE,
      AMOUNT,
      AMOUNT_TYPE,
      ACTION,
      CURRENCY,
      JOURNAL_DATE,
      BATCH_ID,
      REVAL_EFF_FLAG
    from XTR_GAIN_LOSS_DNM
    where GAIN_LOSS_DNM_ID = X_GAIN_LOSS_DNM_ID
    for update of GAIN_LOSS_DNM_ID nowait;

Line: 138

procedure UPDATE_ROW (
  X_GAIN_LOSS_DNM_ID in NUMBER,
  X_BATCH_ID in NUMBER,
  X_COMPANY_CODE in VARCHAR2,
  X_DEAL_NUMBER in NUMBER,
  X_TRANSACTION_NUMBER in NUMBER,
  X_DATE_TYPE in VARCHAR2,
  X_AMOUNT in NUMBER,
  X_AMOUNT_TYPE in VARCHAR2,
  X_ACTION in VARCHAR2,
  X_CURRENCY in VARCHAR2,
  X_JOURNAL_DATE in DATE,
  X_REVAL_EFF_FLAG in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update XTR_GAIN_LOSS_DNM set
    COMPANY_CODE = X_COMPANY_CODE,
    DEAL_NUMBER = X_DEAL_NUMBER,
    TRANSACTION_NUMBER = X_TRANSACTION_NUMBER,
    DATE_TYPE = X_DATE_TYPE,
    AMOUNT = X_AMOUNT,
    AMOUNT_TYPE = X_AMOUNT_TYPE,
    ACTION = X_ACTION,
    CURRENCY = X_CURRENCY,
    JOURNAL_DATE = X_JOURNAL_DATE,
    BATCH_ID = X_BATCH_ID,
    REVAL_EFF_FLAG = X_REVAL_EFF_FLAG,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where GAIN_LOSS_DNM_ID = X_GAIN_LOSS_DNM_ID;

Line: 176

end UPDATE_ROW;

Line: 178

procedure DELETE_ROW (
  X_GAIN_LOSS_DNM_ID in NUMBER
) is
begin
  delete from XTR_GAIN_LOSS_DNM
  where GAIN_LOSS_DNM_ID = X_GAIN_LOSS_DNM_ID;

Line: 189

end DELETE_ROW;