eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_BTN_PVT SQL Statements

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

Line: 43


    SELECT
            ID,
            CURRENCY_CODE,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            TRX_DATE,
            TRX_NUMBER,
            TRX_AMOUNT,
            TRX_CLASS,
            LAST_UPDATE_LOGIN
      FROM Oks_Bill_Transactions
     WHERE oks_bill_transactions.id = p_id;

Line: 70


              l_btn_rec.LAST_UPDATED_BY,
              l_btn_rec.LAST_UPDATE_DATE,
              l_btn_rec.TRX_DATE,
              l_btn_rec.TRX_NUMBER,
              l_btn_rec.TRX_AMOUNT,
              l_btn_rec.TRX_CLASS,
              l_btn_rec.LAST_UPDATE_LOGIN;

Line: 97


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            TRX_DATE,
            TRX_NUMBER,
            TRX_AMOUNT,
            TRX_CLASS,
            CURRENCY_CODE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Oks_Bill_Transactions_V
     WHERE oks_bill_transactions_v.id = p_id;

Line: 128


              l_btnv_rec.LAST_UPDATED_BY,
              l_btnv_rec.LAST_UPDATE_DATE,
              l_btnv_rec.LAST_UPDATE_LOGIN;

Line: 176


    IF (l_btnv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_btnv_rec.last_updated_by := NULL;

Line: 179


    IF (l_btnv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_btnv_rec.last_update_date := NULL;

Line: 182


    IF (l_btnv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_btnv_rec.last_update_login := NULL;

Line: 742


    p_to.last_updated_by := p_from.last_updated_by;

Line: 743


    p_to.last_update_date := p_from.last_update_date;

Line: 748


    p_to.last_update_login := p_from.last_update_login;

Line: 760


    p_to.last_updated_by := p_from.last_updated_by;

Line: 761


    p_to.last_update_date := p_from.last_update_date;

Line: 766


    p_to.last_update_login := p_from.last_update_login;

Line: 919


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_btn_rec                      IN btn_rec_type,
    x_btn_rec                      OUT NOCOPY btn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 928


    l_api_name                     CONSTANT VARCHAR2(30) := 'TRANSACTIONS_insert_row';

Line: 964


    INSERT INTO OKS_BILL_TRANSACTIONS(
        id,
        currency_code,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        trx_date,
        trx_number,
        trx_amount,
        trx_class,
        last_update_login)
      VALUES (
        l_btn_rec.id,
        l_btn_rec.currency_code,
        l_btn_rec.object_version_number,
        l_btn_rec.created_by,
        l_btn_rec.creation_date,
        l_btn_rec.last_updated_by,
        l_btn_rec.last_update_date,
        l_btn_rec.trx_date,
        l_btn_rec.trx_number,
        l_btn_rec.trx_amount,
        l_btn_rec.trx_class,
        l_btn_rec.last_update_login);

Line: 1024


  END insert_row;

Line: 1028


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_btnv_rec                     IN btnv_rec_type,
    x_btnv_rec                     OUT NOCOPY btnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1038


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';

Line: 1054


      l_btnv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1055


      l_btnv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1056


      l_btnv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1120


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_btn_rec,
      lx_btn_rec
    );

Line: 1168


  END insert_row;

Line: 1172


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_btnv_tbl                     IN btnv_tbl_type,
    x_btnv_tbl                     OUT NOCOPY btnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1182


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';

Line: 1191


        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_btnv_rec                     => p_btnv_tbl(i),
          x_btnv_rec                     => x_btnv_tbl(i));

Line: 1234


  END insert_row;

Line: 1252


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BILL_TRANSACTIONS
     WHERE ID = p_btn_rec.id
       AND OBJECT_VERSION_NUMBER = p_btn_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1259


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BILL_TRANSACTIONS
    WHERE ID = p_btn_rec.id;

Line: 1300


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1309


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1496


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_btn_rec                      IN btn_rec_type,
    x_btn_rec                      OUT NOCOPY btn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1505


    l_api_name                     CONSTANT VARCHAR2(30) := 'TRANSACTIONS_update_row';

Line: 1547


      IF (x_btn_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_btn_rec.last_updated_by := l_btn_rec.last_updated_by;

Line: 1551


      IF (x_btn_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_btn_rec.last_update_date := l_btn_rec.last_update_date;

Line: 1571


      IF (x_btn_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_btn_rec.last_update_login := l_btn_rec.last_update_login;

Line: 1615


    UPDATE  OKS_BILL_TRANSACTIONS
    SET CURRENCY_CODE = l_def_btn_rec.currency_code,
        OBJECT_VERSION_NUMBER = l_def_btn_rec.object_version_number,
        CREATED_BY = l_def_btn_rec.created_by,
        CREATION_DATE = l_def_btn_rec.creation_date,
        LAST_UPDATED_BY = l_def_btn_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_btn_rec.last_update_date,
        TRX_DATE = l_def_btn_rec.trx_date,
        TRX_NUMBER = l_def_btn_rec.trx_number,
        TRX_AMOUNT = l_def_btn_rec.trx_amount,
        TRX_CLASS = l_def_btn_rec.trx_class,
        LAST_UPDATE_LOGIN = l_def_btn_rec.last_update_login
    WHERE ID = l_def_btn_rec.id;

Line: 1662


  END update_row;

Line: 1666


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_btnv_rec                     IN btnv_rec_type,
    x_btnv_rec                     OUT NOCOPY btnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1676


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';

Line: 1690


      l_btnv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1691


      l_btnv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1692


      l_btnv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1748


      IF (x_btnv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_btnv_rec.last_updated_by := l_btnv_rec.last_updated_by;

Line: 1752


      IF (x_btnv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_btnv_rec.last_update_date := l_btnv_rec.last_update_date;

Line: 1756


      IF (x_btnv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_btnv_rec.last_update_login := l_btnv_rec.last_update_login;

Line: 1827


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_btn_rec,
      lx_btn_rec
    );

Line: 1874


  END update_row;

Line: 1878


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_btnv_tbl                     IN btnv_tbl_type,
    x_btnv_tbl                     OUT NOCOPY btnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1888


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';

Line: 1897


        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_btnv_rec                     => p_btnv_tbl(i),
          x_btnv_rec                     => x_btnv_tbl(i));

Line: 1940


  END update_row;

Line: 1948


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_btn_rec                      IN btn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1956


    l_api_name                     CONSTANT VARCHAR2(30) := 'TRANSACTIONS_delete_row';

Line: 1970


    DELETE FROM OKS_BILL_TRANSACTIONS
     WHERE ID = l_btn_rec.id;

Line: 2005


  END delete_row;

Line: 2009


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_btnv_rec                     IN btnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2018


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';

Line: 2042


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_btn_rec
    );

Line: 2086


  END delete_row;

Line: 2090


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_btnv_tbl                     IN btnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2099


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';

Line: 2108


        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_btnv_rec                     => p_btnv_tbl(i));

Line: 2150


  END delete_row;

Line: 2153


PROCEDURE INSERT_ROW_UPG(p_btnv_tbl     btnv_tbl_type) IS

  l_tabsize NUMBER := p_btnv_tbl.COUNT;

Line: 2166


  in_last_updated_by                OKC_DATATYPES.NumberTabTyp;

Line: 2167


  in_last_update_date               OKC_DATATYPES.DateTabTyp;

Line: 2168


  in_last_update_login              OKC_DATATYPES.NumberTabTyp;

Line: 2189


    in_last_updated_by          (j) := p_btnv_tbl(i).last_updated_by;

Line: 2190


    in_last_update_date         (j) := p_btnv_tbl(i).last_update_date;

Line: 2191


    in_last_update_login        (j) := p_btnv_tbl(i).last_update_login;

Line: 2198


    INSERT
      INTO OKS_BILL_TRANSACTIONS
      (
        id,
        object_version_number,
        trx_date,
        trx_number,
        trx_amount,
        trx_class,
        currency_code,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login
      )
     VALUES
     (
        in_id(i),
        in_object_version_number(i),
        in_trx_date(i),
        in_trx_number(i),
        in_trx_amount(i),
        in_trx_class(i),
        in_currency_code(i),
        in_created_by(i),
        in_creation_date(i),
        in_last_updated_by(i),
        in_last_update_date(i),
        in_last_update_login(i)
     );

Line: 2233


END INSERT_ROW_UPG;