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

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

Line: 101


    SELECT
            ID,
            BATCH_ID,
            PARAM_NAME,
            OBJECT_VERSION_NUMBER,
            PARAM_TYPE_CODE,
            PARAM_VALUE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Xmlp_Params
     WHERE okl_xmlp_params.id   = p_id;

Line: 162


              l_xmp_rec.last_updated_by,
              l_xmp_rec.last_update_date,
              l_xmp_rec.last_update_login;

Line: 278


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

Line: 281


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

Line: 284


    IF (l_xmp_rec.last_update_login = OKL_API.G_MISS_CHAR ) THEN
      l_xmp_rec.last_update_login := NULL;

Line: 383


  SELECT 1
  FROM FND_LOOKUPS
  WHERE LOOKUP_TYPE = 'OKL_ECC_DATA_TYPE'
  AND LOOKUP_CODE = l_param_type_code;

Line: 537


    p_to.last_updated_by := p_from.last_updated_by;

Line: 538


    p_to.last_update_date := p_from.last_update_date;

Line: 539


    p_to.last_update_login := p_from.last_update_login;

Line: 761


  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_xmp_rec                      IN xmp_rec_type,
    x_xmp_rec                      OUT NOCOPY xmp_rec_type) IS

    l_prog_name                    VARCHAR2(61);

Line: 771


    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row (rec)';

Line: 788


    l_prog_name := G_PKG_NAME||'.insert_row (Rec)';

Line: 810


    INSERT INTO OKL_XMLP_PARAMS(
      id,
      batch_id,
      param_name,
      object_version_number,
      param_type_code,
      param_value,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_xmp_rec.id,
      l_xmp_rec.batch_id,
      l_xmp_rec.param_name,
      l_xmp_rec.object_version_number,
      l_xmp_rec.param_type_code,
      l_xmp_rec.param_value,
      l_xmp_rec.attribute_category,
      l_xmp_rec.attribute1,
      l_xmp_rec.attribute2,
      l_xmp_rec.attribute3,
      l_xmp_rec.attribute4,
      l_xmp_rec.attribute5,
      l_xmp_rec.attribute6,
      l_xmp_rec.attribute7,
      l_xmp_rec.attribute8,
      l_xmp_rec.attribute9,
      l_xmp_rec.attribute10,
      l_xmp_rec.attribute11,
      l_xmp_rec.attribute12,
      l_xmp_rec.attribute13,
      l_xmp_rec.attribute14,
      l_xmp_rec.attribute15,
      G_USER_ID,
      SYSDATE,
      G_USER_ID,
      SYSDATE,
      G_LOGIN_ID);

Line: 891


  END insert_row;

Line: 896


  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_xmp_rec          IN xmp_rec_type,
    x_xmp_rec          OUT NOCOPY xmp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 906


    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row (REC)';

Line: 911


    l_prog_name := G_PKG_NAME||'.insert_row (REC)';

Line: 915


    SELECT okl_xmp_seq.nextval INTO l_xmp_rec.id FROM DUAL;

Line: 919


    SELECT okl_xmp_batch_seq.nextval INTO l_xmp_rec.batch_id FROM DUAL;

Line: 938


    insert_row (
            p_init_msg_list   => OKL_API.G_FALSE,
            x_return_status   => l_return_status,
            x_msg_count       => x_msg_count,
            x_msg_data        => x_msg_data,
            p_xmp_rec         => l_xmp_rec,
            x_xmp_rec         => x_xmp_rec);

Line: 974


  END insert_row;

Line: 979


  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_xmp_tbl          IN xmp_tbl_type,
    x_xmp_tbl          OUT NOCOPY xmp_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 990


    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row (TBL)';

Line: 996


    l_prog_name := G_PKG_NAME||'.insert_row (TBL)';

Line: 999


    SELECT okl_xmp_batch_seq.nextval INTO l_batch_id FROM DUAL;

Line: 1008


        insert_row (
	    p_api_version     => p_api_version,
            p_init_msg_list   => OKL_API.G_FALSE,
            x_return_status   => l_return_status,
            x_msg_count       => x_msg_count,
            x_msg_data        => x_msg_data,
            p_xmp_rec         => l_xmp_rec,
            x_xmp_rec         => x_xmp_tbl(i));

Line: 1050


  END insert_row;

Line: 1068


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_XMLP_PARAMS
     WHERE ID = p_xmp_rec.id
       AND OBJECT_VERSION_NUMBER = p_xmp_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1075


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_XMLP_PARAMS
     WHERE ID = p_xmp_rec.id;

Line: 1118


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1127


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1373


  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_xmp_rec                      IN xmp_rec_type,
    x_xmp_rec                      OUT NOCOPY xmp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1382


    l_api_name                     CONSTANT VARCHAR2(30) := 'update_row (rec)';

Line: 1498


        IF (x_xmp_rec.last_updated_by IS NULL)
        THEN
          x_xmp_rec.last_updated_by := l_xmp_rec.last_updated_by;

Line: 1502


        IF (x_xmp_rec.last_update_date IS NULL)
        THEN
          x_xmp_rec.last_update_date := l_xmp_rec.last_update_date;

Line: 1506


        IF (x_xmp_rec.last_update_login IS NULL)
        THEN
          x_xmp_rec.last_update_login := l_xmp_rec.last_update_login;

Line: 1527


    l_prog_name := G_PKG_NAME||'.update_row (rec)';

Line: 1554


    UPDATE OKL_XMLP_PARAMS
    SET BATCH_ID = l_def_xmp_rec.batch_id,
        PARAM_NAME = l_def_xmp_rec.param_name,
        OBJECT_VERSION_NUMBER = l_def_xmp_rec.object_version_number,
        PARAM_TYPE_CODE = l_def_xmp_rec.param_type_code,
        PARAM_VALUE = l_def_xmp_rec.param_value,
        ATTRIBUTE_CATEGORY = l_def_xmp_rec.attribute_category,
        ATTRIBUTE1 = l_def_xmp_rec.attribute1,
        ATTRIBUTE2 = l_def_xmp_rec.attribute2,
        ATTRIBUTE3 = l_def_xmp_rec.attribute3,
        ATTRIBUTE4 = l_def_xmp_rec.attribute4,
        ATTRIBUTE5 = l_def_xmp_rec.attribute5,
        ATTRIBUTE6 = l_def_xmp_rec.attribute6,
        ATTRIBUTE7 = l_def_xmp_rec.attribute7,
        ATTRIBUTE8 = l_def_xmp_rec.attribute8,
        ATTRIBUTE9 = l_def_xmp_rec.attribute9,
        ATTRIBUTE10 = l_def_xmp_rec.attribute10,
        ATTRIBUTE11 = l_def_xmp_rec.attribute11,
        ATTRIBUTE12 = l_def_xmp_rec.attribute12,
        ATTRIBUTE13 = l_def_xmp_rec.attribute13,
        ATTRIBUTE14 = l_def_xmp_rec.attribute14,
        ATTRIBUTE15 = l_def_xmp_rec.attribute15,
        CREATED_BY = l_def_xmp_rec.created_by,
        CREATION_DATE = l_def_xmp_rec.creation_date,
        LAST_UPDATED_BY = l_def_xmp_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_xmp_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_xmp_rec.last_update_login
    WHERE ID = l_def_xmp_rec.id;

Line: 1607


  END update_row;

Line: 1611


  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_xmp_rec                      IN xmp_rec_type,
    x_xmp_rec                      OUT NOCOPY xmp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1621


    l_api_name                     CONSTANT VARCHAR2(30) := 'update_row (rec)';

Line: 1636


      l_xmp_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1637


      l_xmp_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1638


      l_xmp_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1752


        IF (x_xmp_rec.last_updated_by IS NULL)
        THEN
          x_xmp_rec.last_updated_by := l_xmp_rec.last_updated_by;

Line: 1756


        IF (x_xmp_rec.last_update_date IS NULL)
        THEN
          x_xmp_rec.last_update_date := l_xmp_rec.last_update_date;

Line: 1760


        IF (x_xmp_rec.last_update_login IS NULL)
        THEN
          x_xmp_rec.last_update_login := l_xmp_rec.last_update_login;

Line: 1780


    l_prog_name := G_PKG_NAME||'.update_row (rec)';

Line: 1846


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_xmp_rec,
      lx_xmp_rec
    );

Line: 1884


  END update_row;

Line: 1888


  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_xmp_tbl                      IN xmp_tbl_type,
    x_xmp_tbl                      OUT NOCOPY xmp_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1899


    l_api_name                     CONSTANT VARCHAR2(30) := 'update_row (tbl)';

Line: 1903


    l_prog_name := G_PKG_NAME||'.update_row (tbl)';

Line: 1915


          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_xmp_rec                      => p_xmp_tbl(i),
            x_xmp_rec                      => x_xmp_tbl(i));

Line: 1973


  END update_row;

Line: 1978


  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_xmp_tbl                      IN xmp_tbl_type,
    x_xmp_tbl                      OUT NOCOPY xmp_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1988


    l_api_name                     CONSTANT VARCHAR2(30) := 'update_row (tbl)';

Line: 1994


    l_prog_name := G_PKG_NAME||'.update_row (tbl)';

Line: 2000


        update_row (
            p_api_version     => p_api_version,
            p_init_msg_list   => OKL_API.G_FALSE,
            x_return_status   => l_return_status,
            x_msg_count       => x_msg_count,
            x_msg_data        => x_msg_data,
            p_xmp_rec         => p_xmp_tbl(i),
            x_xmp_rec         => x_xmp_tbl(i));

Line: 2041


  END update_row;

Line: 2049


  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_xmp_rec                      IN xmp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2057


    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_row (rec)';

Line: 2063


    l_prog_name := G_PKG_NAME||'.delete_row (rec)';

Line: 2074


    DELETE FROM OKL_XMLP_PARAMS
     WHERE ID = p_xmp_rec.id;

Line: 2100


  END delete_row;

Line: 2104


  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_xmp_rec                      IN xmp_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2113


    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_row (rec)';

Line: 2119


    l_prog_name := G_PKG_NAME||'.delete_row (rec)';

Line: 2139


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

Line: 2174


  END delete_row;

Line: 2178


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2188


    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_row (tbl)';

Line: 2192


    l_prog_name := G_PKG_NAME||'.delete_row (tbl)';

Line: 2204


          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_xmp_rec                      => p_xmp_tbl(i));

Line: 2261


  END delete_row;

Line: 2266


  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_xmp_tbl                      IN xmp_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2275


    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_row (tbl)';

Line: 2280


    l_prog_name := G_PKG_NAME||'.delete_row (tbl)';

Line: 2284


      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_xmp_tbl                      => p_xmp_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2315


  END delete_row;