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

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

Line: 66


    CURSOR c_pk_csr IS SELECT okl_report_trx_params_s.NEXTVAL FROM DUAL;

Line: 107


    SELECT
            TRX_PARAMETER_ID,
            REPORT_ID,
            TRY_ID,
            STY_ID,
            ADD_SUBSTRACT_CODE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Report_Trx_Params
     WHERE okl_report_trx_params.trx_parameter_id = p_trx_parameter_id;

Line: 134


              l_rtp_rec.last_updated_by,
              l_rtp_rec.last_update_date,
              l_rtp_rec.last_update_login;

Line: 199


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

Line: 202


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

Line: 205


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

Line: 331


	SELECT 1
	FROM OKL_REPORT_TRX_PARAMS
	WHERE REPORT_ID = p_report_id
	AND TRY_ID = p_try_id
	AND STY_ID = p_sty_id
	AND TRX_PARAMETER_ID <> p_trx_param_id;

Line: 342


	SELECT STY_ID
	FROM OKL_REPORT_TRX_PARAMS
	WHERE REPORT_ID = p_report_id
	AND TRY_ID = p_try_id
	AND TRX_PARAMETER_ID <> p_trx_param_id;

Line: 349


       SELECT 1
       FROM FND_LOOKUPS
       WHERE LOOKUP_TYPE = 'OKL_REPORT_TRX_ACTIVITY'
       AND LOOKUP_CODE = p_add_sub_code;

Line: 730


  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_rtp_rec                      IN rtp_rec_type,
    x_rtp_rec                      OUT NOCOPY rtp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 740


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

Line: 754


      l_rtp_rec.LAST_UPDATE_DATE := l_rtp_rec.CREATION_DATE;

Line: 755


      l_rtp_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 756


      l_rtp_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 812


    INSERT INTO OKL_REPORT_TRX_PARAMS(
      trx_parameter_id,
      report_id,
      try_id,
      sty_id,
      add_substract_code,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_def_rtp_rec.trx_parameter_id,
      l_def_rtp_rec.report_id,
      l_def_rtp_rec.try_id,
      l_def_rtp_rec.sty_id,
      l_def_rtp_rec.add_substract_code,
      l_def_rtp_rec.created_by,
      l_def_rtp_rec.creation_date,
      l_def_rtp_rec.last_updated_by,
      l_def_rtp_rec.last_update_date,
      l_def_rtp_rec.last_update_login);

Line: 869


  END insert_row;

Line: 873


  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_rtp_tbl                      IN rtp_tbl_type,
    x_rtp_tbl                      OUT NOCOPY rtp_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 884


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

Line: 898


          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_rtp_rec                      => p_rtp_tbl(i),
            x_rtp_rec                      => x_rtp_tbl(i));

Line: 966


  END insert_row;

Line: 971


  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_rtp_tbl                      IN rtp_tbl_type,
    x_rtp_tbl                      OUT NOCOPY rtp_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 981


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

Line: 988


      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_rtp_tbl                      => p_rtp_tbl,
        x_rtp_tbl                      => x_rtp_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1030


  END insert_row;

Line: 1047


    SELECT *
      FROM OKL_REPORT_TRX_PARAMS
     WHERE TRX_PARAMETER_ID = p_rtp_rec.trx_parameter_id
    FOR UPDATE NOWAIT;

Line: 1083


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1367


  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_rtp_rec                      IN rtp_rec_type,
    x_rtp_rec                      OUT NOCOPY rtp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1376


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

Line: 1417


        IF x_rtp_rec.last_updated_by IS NULL OR x_rtp_rec.last_updated_by = OKL_API.G_MISS_NUM THEN
          x_rtp_rec.last_updated_by := l_rtp_rec.last_updated_by;

Line: 1420


        IF x_rtp_rec.last_update_date IS NULL OR x_rtp_rec.last_update_date = OKL_API.G_MISS_DATE THEN
          x_rtp_rec.last_update_date := l_rtp_rec.last_update_date;

Line: 1423


        IF x_rtp_rec.last_update_login = OKL_API.G_MISS_NUM THEN
          x_rtp_rec.last_update_login := l_rtp_rec.last_update_login;

Line: 1467


    UPDATE OKL_REPORT_TRX_PARAMS
    SET REPORT_ID = l_def_rtp_rec.report_id,
        TRY_ID = l_def_rtp_rec.try_id,
        STY_ID = l_def_rtp_rec.sty_id,
        ADD_SUBSTRACT_CODE = l_def_rtp_rec.add_substract_code,
        CREATED_BY = l_def_rtp_rec.created_by,
        CREATION_DATE = l_def_rtp_rec.creation_date,
        LAST_UPDATED_BY = l_def_rtp_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_rtp_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_rtp_rec.last_update_login
    WHERE TRX_PARAMETER_ID = l_def_rtp_rec.trx_parameter_id;

Line: 1513


  END update_row;

Line: 1517


  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_rtp_rec                      IN rtp_rec_type,
    x_rtp_rec                      OUT NOCOPY rtp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1527


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

Line: 1541


      l_rtp_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1542


      l_rtp_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1543


      l_rtp_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1583


        IF x_rtp_rec.last_updated_by IS NULL OR x_rtp_rec.last_updated_by = OKL_API.G_MISS_NUM THEN
          x_rtp_rec.last_updated_by := l_db_rtp_rec.last_updated_by;

Line: 1586


        IF x_rtp_rec.last_update_date IS NULL OR x_rtp_rec.last_update_date = OKL_API.G_MISS_DATE THEN
          x_rtp_rec.last_update_date := l_db_rtp_rec.last_update_date;

Line: 1589


        IF x_rtp_rec.last_update_login = OKL_API.G_MISS_NUM THEN
          x_rtp_rec.last_update_login := l_db_rtp_rec.last_update_login;

Line: 1673


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_rtp_rec,
      lx_rtp_rec
    );

Line: 1720


  END update_row;

Line: 1724


  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_rtp_tbl                      IN rtp_tbl_type,
    x_rtp_tbl                      OUT NOCOPY rtp_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1735


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

Line: 1749


          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_rtp_rec                      => p_rtp_tbl(i),
            x_rtp_rec                      => x_rtp_tbl(i));

Line: 1817


  END update_row;

Line: 1822


  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_rtp_tbl                      IN rtp_tbl_type,
    x_rtp_tbl                      OUT NOCOPY rtp_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1832


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

Line: 1839


      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_rtp_tbl                      => p_rtp_tbl,
        x_rtp_tbl                      => x_rtp_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1881


  END update_row;

Line: 1889


  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_rtp_rec                      IN rtp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1897


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

Line: 1912


    DELETE FROM OKL_REPORT_TRX_PARAMS
     WHERE TRX_PARAMETER_ID = p_rtp_rec.trx_parameter_id;

Line: 1948


  END delete_row;

Line: 1952


  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_rtp_rec                      IN rtp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1961


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

Line: 1983


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

Line: 2028


  END delete_row;

Line: 2032


  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_rtp_tbl                      IN rtp_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2042


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

Line: 2056


          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_rtp_rec                      => p_rtp_tbl(i));

Line: 2123


  END delete_row;

Line: 2128


  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_rtp_tbl                      IN rtp_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2137


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

Line: 2144


      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_rtp_tbl                      => p_rtp_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2185


  END delete_row;