APPS.CSI_FA_HEADERS_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_HEADER_ID in NUMBER,
  X_FA_ASSET_ID in NUMBER,
  X_FEEDER_SYSTEM_NAME in VARCHAR2,
  X_STATUS_CODE in VARCHAR2,
  X_FA_BOOK_TYPE_CODE 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_HEADERS (
    INTERFACE_HEADER_ID,
    FA_ASSET_ID,
    FA_BOOK_TYPE_CODE,
    FEEDER_SYSTEM_NAME,
    STATUS_CODE,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN
  ) select
    X_INTERFACE_HEADER_ID,
    X_FA_ASSET_ID,
    X_FA_BOOK_TYPE_CODE,
    X_FEEDER_SYSTEM_NAME,
    X_STATUS_CODE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN
  from SYS.dual;

Line: 41

end INSERT_ROW;

Line: 50

  cursor c1 is select
      FA_ASSET_ID,
      FEEDER_SYSTEM_NAME,
      STATUS_CODE,
      FA_BOOK_TYPE_CODE
    from CSI_FA_HEADERS
    where INTERFACE_HEADER_ID = X_INTERFACE_HEADER_ID
    for update of INTERFACE_HEADER_ID nowait;

Line: 75

procedure UPDATE_ROW (
  X_INTERFACE_HEADER_ID in NUMBER,
  X_FA_ASSET_ID in NUMBER,
  X_FEEDER_SYSTEM_NAME in VARCHAR2,
  X_STATUS_CODE in VARCHAR2,
  X_FA_BOOK_TYPE_CODE 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_HEADERS set
    FA_ASSET_ID = X_FA_ASSET_ID,
    FEEDER_SYSTEM_NAME = X_FEEDER_SYSTEM_NAME,
    STATUS_CODE = X_STATUS_CODE,
    FA_BOOK_TYPE_CODE = X_FA_BOOK_TYPE_CODE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where INTERFACE_HEADER_ID = X_INTERFACE_HEADER_ID;

Line: 100

end UPDATE_ROW;

Line: 102

procedure DELETE_ROW (
  X_INTERFACE_HEADER_ID in NUMBER
) is
begin
  delete from CSI_FA_HEADERS
  where INTERFACE_HEADER_ID = X_INTERFACE_HEADER_ID;

Line: 113

end DELETE_ROW;