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.OKL_TMG_PVT SQL Statements

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

Line: 102


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            BCH_ID,
            TMG_MESSAGE_NAME,
            TMG_APPLICATION_ID,
            TMG_LANGUAGE_CODE,
            MESSAGE_TEXT,
            TRX_ID,
            TRX_SOURCE_TABLE,
            SEQUENCE_NUMBER,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            TMG_RUN -- RMUNJULU 3018641 Added Column
      FROM Okl_Trx_Msgs_V
     WHERE okl_trx_msgs_v.id    = p_id;

Line: 145


              l_tmgv_rec.program_update_date,
              l_tmgv_rec.created_by,
              l_tmgv_rec.creation_date,
              l_tmgv_rec.last_updated_by,
              l_tmgv_rec.last_update_date,
              l_tmgv_rec.last_update_login,
              l_tmgv_rec.tmg_run; -- RMUNJULU 3018641 Added Column

Line: 198


    SELECT
            ID,
            SEQUENCE_NUMBER,
            TRX_ID,
            TRX_SOURCE_TABLE,
            BCH_ID,
            TMG_LANGUAGE_CODE,
            TMG_MESSAGE_NAME,
            TMG_APPLICATION_ID,
            MESSAGE_TEXT,
            OBJECT_VERSION_NUMBER,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            TMG_RUN -- RMUNJULU 3018641 Added Column
      FROM Okl_Trx_Msgs
     WHERE okl_trx_msgs.id      = p_id;

Line: 241


              l_tmg_rec.program_update_date,
              l_tmg_rec.created_by,
              l_tmg_rec.creation_date,
              l_tmg_rec.last_updated_by,
              l_tmg_rec.last_update_date,
              l_tmg_rec.last_update_login,
              l_tmg_rec.tmg_run; -- RMUNJULU 3018641 Added Column

Line: 332


    IF (l_tmgv_rec.program_update_date = OKL_API.G_MISS_DATE ) THEN
      l_tmgv_rec.program_update_date := NULL;

Line: 341


    IF (l_tmgv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_tmgv_rec.last_updated_by := NULL;

Line: 344


    IF (l_tmgv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_tmgv_rec.last_update_date := NULL;

Line: 347


    IF (l_tmgv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_tmgv_rec.last_update_login := NULL;

Line: 514


      SELECT 'x'
        FROM Okl_Billing_Charges_V
       WHERE okl_billing_charges_v.id = p_id;

Line: 522


      SELECT 'x'
        FROM Fnd_New_Messages
       WHERE fnd_new_messages.application_id = p_application_id
         AND fnd_new_messages.message_name = p_message_name
         AND fnd_new_messages.language_code = p_language_code;

Line: 609


    p_to.program_update_date := p_from.program_update_date;

Line: 612


    p_to.last_updated_by := p_from.last_updated_by;

Line: 613


    p_to.last_update_date := p_from.last_update_date;

Line: 614


    p_to.last_update_login := p_from.last_update_login;

Line: 638


    p_to.program_update_date := p_from.program_update_date;

Line: 641


    p_to.last_updated_by := p_from.last_updated_by;

Line: 642


    p_to.last_update_date := p_from.last_update_date;

Line: 643


    p_to.last_update_login := p_from.last_update_login;

Line: 894


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmg_rec                      IN tmg_rec_type,
    x_tmg_rec                      OUT NOCOPY tmg_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 903


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

Line: 939


    INSERT INTO OKL_TRX_MSGS(
      id,
      sequence_number,
      trx_id,
      trx_source_table,
      bch_id,
      tmg_language_code,
      tmg_message_name,
      tmg_application_id,
      message_text,
      object_version_number,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      tmg_run -- RMUNJULU 3018641 Added Column
    )
    VALUES (
      l_tmg_rec.id,
      l_tmg_rec.sequence_number,
      l_tmg_rec.trx_id,
      l_tmg_rec.trx_source_table,
      l_tmg_rec.bch_id,
      l_tmg_rec.tmg_language_code,
      l_tmg_rec.tmg_message_name,
      l_tmg_rec.tmg_application_id,
      l_tmg_rec.message_text,
      l_tmg_rec.object_version_number,
      l_tmg_rec.request_id,
      l_tmg_rec.program_application_id,
      l_tmg_rec.program_id,
      l_tmg_rec.program_update_date,
      l_tmg_rec.created_by,
      l_tmg_rec.creation_date,
      l_tmg_rec.last_updated_by,
      l_tmg_rec.last_update_date,
      l_tmg_rec.last_update_login,
      l_tmg_rec.tmg_run -- RMUNJULU 3018641 Added Column
      );

Line: 1018


  END insert_row;

Line: 1022


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmgv_rec                     IN tmgv_rec_type,
    x_tmgv_rec                     OUT NOCOPY tmgv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1032


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

Line: 1048


      l_tmgv_rec.LAST_UPDATE_DATE := l_tmgv_rec.CREATION_DATE;

Line: 1049


      l_tmgv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1050


      l_tmgv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1114


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_tmg_rec,
      lx_tmg_rec
    );

Line: 1163


  END insert_row;

Line: 1167


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmgv_tbl                     IN tmgv_tbl_type,
    x_tmgv_tbl                     OUT NOCOPY tmgv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1178


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

Line: 1192


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_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_tmgv_rec                     => p_tmgv_tbl(i),
            x_tmgv_rec                     => x_tmgv_tbl(i));

Line: 1260


  END insert_row;

Line: 1265


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmgv_tbl                     IN tmgv_tbl_type,
    x_tmgv_tbl                     OUT NOCOPY tmgv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1275


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

Line: 1282


      insert_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_tmgv_tbl                     => p_tmgv_tbl,
        x_tmgv_tbl                     => x_tmgv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1324


  END insert_row;

Line: 1342


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TRX_MSGS
     WHERE ID = p_tmg_rec.id
       AND OBJECT_VERSION_NUMBER = p_tmg_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1349


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TRX_MSGS
     WHERE ID = p_tmg_rec.id;

Line: 1390


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1399


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1680


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmg_rec                      IN tmg_rec_type,
    x_tmg_rec                      OUT NOCOPY tmg_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1689


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

Line: 1761


        IF (x_tmg_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_tmg_rec.program_update_date := l_tmg_rec.program_update_date;

Line: 1773


        IF (x_tmg_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_tmg_rec.last_updated_by := l_tmg_rec.last_updated_by;

Line: 1777


        IF (x_tmg_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_tmg_rec.last_update_date := l_tmg_rec.last_update_date;

Line: 1781


        IF (x_tmg_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_tmg_rec.last_update_login := l_tmg_rec.last_update_login;

Line: 1834


    UPDATE OKL_TRX_MSGS
    SET SEQUENCE_NUMBER = l_def_tmg_rec.sequence_number,
        TRX_ID = l_def_tmg_rec.trx_id,
        TRX_SOURCE_TABLE = l_def_tmg_rec.trx_source_table,
        BCH_ID = l_def_tmg_rec.bch_id,
        TMG_LANGUAGE_CODE = l_def_tmg_rec.tmg_language_code,
        TMG_MESSAGE_NAME = l_def_tmg_rec.tmg_message_name,
        TMG_APPLICATION_ID = l_def_tmg_rec.tmg_application_id,
        MESSAGE_TEXT = l_def_tmg_rec.message_text,
        OBJECT_VERSION_NUMBER = l_def_tmg_rec.object_version_number,
        REQUEST_ID = l_def_tmg_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_tmg_rec.program_application_id,
        PROGRAM_ID = l_def_tmg_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_tmg_rec.program_update_date,
        CREATED_BY = l_def_tmg_rec.created_by,
        CREATION_DATE = l_def_tmg_rec.creation_date,
        LAST_UPDATED_BY = l_def_tmg_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_tmg_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_tmg_rec.last_update_login,
        TMG_RUN = l_def_tmg_rec.tmg_run -- RMUNJULU 3018641 Added code
    WHERE ID = l_def_tmg_rec.id;

Line: 1890


  END update_row;

Line: 1895


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmgv_rec                     IN tmgv_rec_type,
    x_tmgv_rec                     OUT NOCOPY tmgv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1905


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

Line: 1920


      l_tmgv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1921


      l_tmgv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1922


      l_tmgv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1989


        IF (x_tmgv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_tmgv_rec.program_update_date := l_db_tmgv_rec.program_update_date;

Line: 2001


        IF (x_tmgv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_tmgv_rec.last_updated_by := l_db_tmgv_rec.last_updated_by;

Line: 2005


        IF (x_tmgv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_tmgv_rec.last_update_date := l_db_tmgv_rec.last_update_date;

Line: 2009


        IF (x_tmgv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_tmgv_rec.last_update_login := l_db_tmgv_rec.last_update_login;

Line: 2101


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_tmg_rec,
      lx_tmg_rec
    );

Line: 2149


  END update_row;

Line: 2153


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmgv_tbl                     IN tmgv_tbl_type,
    x_tmgv_tbl                     OUT NOCOPY tmgv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2164


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

Line: 2178


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_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_tmgv_rec                     => p_tmgv_tbl(i),
            x_tmgv_rec                     => x_tmgv_tbl(i));

Line: 2246


  END update_row;

Line: 2251


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmgv_tbl                     IN tmgv_tbl_type,
    x_tmgv_tbl                     OUT NOCOPY tmgv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2261


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

Line: 2268


      update_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_tmgv_tbl                     => p_tmgv_tbl,
        x_tmgv_tbl                     => x_tmgv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2310


  END update_row;

Line: 2318


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmg_rec                      IN tmg_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2326


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

Line: 2341


    DELETE FROM OKL_TRX_MSGS
     WHERE ID = p_tmg_rec.id;

Line: 2377


  END delete_row;

Line: 2381


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmgv_rec                     IN tmgv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2390


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

Line: 2414


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

Line: 2459


  END delete_row;

Line: 2463


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmgv_tbl                     IN tmgv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2473


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

Line: 2487


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_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_tmgv_rec                     => p_tmgv_tbl(i));

Line: 2554


  END delete_row;

Line: 2559


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmgv_tbl                     IN tmgv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2568


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

Line: 2575


      delete_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_tmgv_tbl                     => p_tmgv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2616


  END delete_row;