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_PRINT_PREVIEW_PVT SQL Statements

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

Line: 101


    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,
            SECURITY_GROUP_ID
      FROM Oks_Btn_Pr
     WHERE oks_btn_pr.id        = p_id;

Line: 129


              l_btn_pr_rec.last_updated_by,
              l_btn_pr_rec.last_update_date,
              l_btn_pr_rec.trx_date,
              l_btn_pr_rec.trx_number,
              l_btn_pr_rec.trx_amount,
              l_btn_pr_rec.trx_class,
              l_btn_pr_rec.last_update_login,
              l_btn_pr_rec.security_group_id;

Line: 192


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

Line: 195


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

Line: 210


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

Line: 414


      SELECT 'x'
        FROM Fnd_Currencies
       WHERE fnd_currencies.currency_code = p_currency_code;

Line: 470


    p_to.last_updated_by := p_from.last_updated_by;

Line: 471


    p_to.last_update_date := p_from.last_update_date;

Line: 476


    p_to.last_update_login := p_from.last_update_login;

Line: 490


    p_to.last_updated_by := p_from.last_updated_by;

Line: 491


    p_to.last_update_date := p_from.last_update_date;

Line: 496


    p_to.last_update_login := p_from.last_update_login;

Line: 742


  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_btn_pr_rec                   IN btn_pr_rec_type,
    x_btn_pr_rec                   OUT NOCOPY btn_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 752


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

Line: 788


    INSERT INTO OKS_BTN_PR(
      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,
      security_group_id)
    VALUES (
      l_btn_pr_rec.id,
      l_btn_pr_rec.currency_code,
      l_btn_pr_rec.object_version_number,
      l_btn_pr_rec.created_by,
      l_btn_pr_rec.creation_date,
      l_btn_pr_rec.last_updated_by,
      l_btn_pr_rec.last_update_date,
      l_btn_pr_rec.trx_date,
      l_btn_pr_rec.trx_number,
      l_btn_pr_rec.trx_amount,
      l_btn_pr_rec.trx_class,
      l_btn_pr_rec.last_update_login,
      l_btn_pr_rec.security_group_id);

Line: 851


  END insert_row;

Line: 868


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BTN_PR
     WHERE ID = p_btn_pr_rec.id
       AND OBJECT_VERSION_NUMBER = p_btn_pr_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 875


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_BTN_PR
     WHERE ID = p_btn_pr_rec.id;

Line: 916


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 925


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1205


  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_pr_rec                   IN btn_pr_rec_type,
    x_btn_pr_rec                   OUT NOCOPY btn_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1214


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

Line: 1254


        IF (x_btn_pr_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_btn_pr_rec.last_updated_by := l_btn_pr_rec.last_updated_by;

Line: 1258


        IF (x_btn_pr_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_btn_pr_rec.last_update_date := l_btn_pr_rec.last_update_date;

Line: 1278


        IF (x_btn_pr_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_btn_pr_rec.last_update_login := l_btn_pr_rec.last_update_login;

Line: 1328


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

Line: 1377


  END update_row;

Line: 1381


  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_btn_pr_rec                   IN btn_pr_rec_type,
    x_btn_pr_rec                   OUT NOCOPY btn_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1391


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

Line: 1405


      l_btn_pr_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1406


      l_btn_pr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1407


      l_btn_pr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1442


        IF (x_btn_pr_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_btn_pr_rec.last_updated_by := l_db_btn_pr_rec.last_updated_by;

Line: 1446


        IF (x_btn_pr_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_btn_pr_rec.last_update_date := l_db_btn_pr_rec.last_update_date;

Line: 1466


        IF (x_btn_pr_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_btn_pr_rec.last_update_login := l_db_btn_pr_rec.last_update_login;

Line: 1555


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_btn_pr_rec,
      lx_btn_pr_rec
    );

Line: 1603


  END update_row;

Line: 1607


  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_btn_pr_tbl                   IN btn_pr_tbl_type,
    x_btn_pr_tbl                   OUT NOCOPY btn_pr_tbl_type,
    px_error_tbl                   IN OUT NOCOPY ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1618


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

Line: 1632


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_btn_pr_rec                   => p_btn_pr_tbl(i),
            x_btn_pr_rec                   => x_btn_pr_tbl(i));

Line: 1700


  END update_row;

Line: 1705


  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_btn_pr_tbl                   IN btn_pr_tbl_type,
    x_btn_pr_tbl                   OUT NOCOPY btn_pr_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1715


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

Line: 1722


      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_btn_pr_tbl                   => p_btn_pr_tbl,
        x_btn_pr_tbl                   => x_btn_pr_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1764


  END update_row;

Line: 1772


  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_pr_rec                   IN btn_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1780


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

Line: 1795


    DELETE FROM OKS_BTN_PR
     WHERE ID = p_btn_pr_rec.id;

Line: 1831


  END delete_row;

Line: 1835


  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_btn_pr_rec                   IN btn_pr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1844


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

Line: 1867


    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_btn_pr_rec
    );

Line: 1912


  END delete_row;

Line: 1916


  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_btn_pr_tbl                   IN btn_pr_tbl_type,
    px_error_tbl                   IN OUT NOCOPY ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1926


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

Line: 1940


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_btn_pr_rec                   => p_btn_pr_tbl(i));

Line: 2007


  END delete_row;

Line: 2012


  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_btn_pr_tbl                   IN btn_pr_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2021


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

Line: 2028


      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_btn_pr_tbl                   => p_btn_pr_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2069


  END delete_row;