APPS.CSI_FA_TRANSACTIONS_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_INTERFACE_LINE_ID in NUMBER,
  X_INTERFACE_HEADER_ID in NUMBER,
  X_DISTRIBUTION_ID in NUMBER,
  X_TRANSACTION_DATE in DATE,
  X_TRANSACTION_UNITS in NUMBER,
  X_TRANSACTION_COST in NUMBER,
  X_PARENT_MASS_ADDITION_ID in NUMBER,
  X_PA_ASSET_LINE_ID in NUMBER,
  X_TRANSFER_DISTRIBUTION_ID in NUMBER,
  X_RETIREMENT_ID in NUMBER,
  X_STATUS_CODE in VARCHAR2,
  X_DATE_PROCESSED in DATE,
  X_DATE_NOTIFIED in DATE,
  X_ERROR_FLAG in VARCHAR2,
  X_ERROR_TEXT in VARCHAR2,
  X_TRANSACTION_SOURCE_TYPE 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
begin
  insert into CSI_FA_TRANSACTIONS (
    INTERFACE_HEADER_ID,
    INTERFACE_LINE_ID,
    TRANSACTION_SOURCE_TYPE,
    DISTRIBUTION_ID,
    TRANSACTION_DATE,
    TRANSACTION_UNITS,
    TRANSACTION_COST,
    PARENT_MASS_ADDITION_ID,
    PA_ASSET_LINE_ID,
    TRANSFER_DISTRIBUTION_ID,
    RETIREMENT_ID,
    STATUS_CODE,
    DATE_PROCESSED,
    DATE_NOTIFIED,
    ERROR_FLAG,
    ERROR_TEXT,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN
  ) select
    X_INTERFACE_HEADER_ID,
    X_INTERFACE_LINE_ID,
    X_TRANSACTION_SOURCE_TYPE,
    X_DISTRIBUTION_ID,
    X_TRANSACTION_DATE,
    X_TRANSACTION_UNITS,
    X_TRANSACTION_COST,
    X_PARENT_MASS_ADDITION_ID,
    X_PA_ASSET_LINE_ID,
    X_TRANSFER_DISTRIBUTION_ID,
    X_RETIREMENT_ID,
    X_STATUS_CODE,
    X_DATE_PROCESSED,
    X_DATE_NOTIFIED,
    X_ERROR_FLAG,
    X_ERROR_TEXT,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN
  from SYS.dual;

Line: 74

end INSERT_ROW;

Line: 94

  cursor c1 is select
      INTERFACE_HEADER_ID,
      DISTRIBUTION_ID,
      TRANSACTION_DATE,
      TRANSACTION_UNITS,
      TRANSACTION_COST,
      PARENT_MASS_ADDITION_ID,
      PA_ASSET_LINE_ID,
      TRANSFER_DISTRIBUTION_ID,
      RETIREMENT_ID,
      STATUS_CODE,
      DATE_PROCESSED,
      DATE_NOTIFIED,
      ERROR_FLAG,
      ERROR_TEXT,
      TRANSACTION_SOURCE_TYPE
    from CSI_FA_TRANSACTIONS
    where INTERFACE_LINE_ID = X_INTERFACE_LINE_ID
    for update of INTERFACE_LINE_ID nowait;

Line: 148

procedure UPDATE_ROW (
  X_INTERFACE_LINE_ID in NUMBER,
  X_INTERFACE_HEADER_ID in NUMBER,
  X_DISTRIBUTION_ID in NUMBER,
  X_TRANSACTION_DATE in DATE,
  X_TRANSACTION_UNITS in NUMBER,
  X_TRANSACTION_COST in NUMBER,
  X_PARENT_MASS_ADDITION_ID in NUMBER,
  X_PA_ASSET_LINE_ID in NUMBER,
  X_TRANSFER_DISTRIBUTION_ID in NUMBER,
  X_RETIREMENT_ID in NUMBER,
  X_STATUS_CODE in VARCHAR2,
  X_DATE_PROCESSED in DATE,
  X_DATE_NOTIFIED in DATE,
  X_ERROR_FLAG in VARCHAR2,
  X_ERROR_TEXT in VARCHAR2,
  X_TRANSACTION_SOURCE_TYPE in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update CSI_FA_TRANSACTIONS set
    INTERFACE_HEADER_ID = X_INTERFACE_HEADER_ID,
    DISTRIBUTION_ID = X_DISTRIBUTION_ID,
    TRANSACTION_DATE = X_TRANSACTION_DATE,
    TRANSACTION_UNITS = X_TRANSACTION_UNITS,
    TRANSACTION_COST = X_TRANSACTION_COST,
    PARENT_MASS_ADDITION_ID = X_PARENT_MASS_ADDITION_ID,
    PA_ASSET_LINE_ID = X_PA_ASSET_LINE_ID,
    TRANSFER_DISTRIBUTION_ID = X_TRANSFER_DISTRIBUTION_ID,
    RETIREMENT_ID = X_RETIREMENT_ID,
    STATUS_CODE = X_STATUS_CODE,
    DATE_PROCESSED = X_DATE_PROCESSED,
    DATE_NOTIFIED = X_DATE_NOTIFIED,
    ERROR_FLAG = X_ERROR_FLAG,
    ERROR_TEXT = X_ERROR_TEXT,
    TRANSACTION_SOURCE_TYPE = X_TRANSACTION_SOURCE_TYPE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where INTERFACE_LINE_ID = X_INTERFACE_LINE_ID;

Line: 194

end UPDATE_ROW;

Line: 196

procedure DELETE_ROW (
  X_INTERFACE_LINE_ID in NUMBER
) is
begin
  delete from CSI_FA_TRANSACTIONS
  where INTERFACE_LINE_ID = X_INTERFACE_LINE_ID;

Line: 207

end DELETE_ROW;