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

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

Line: 101


    SELECT
	ID,
	OBJECT_VERSION_NUMBER,
	CODE,
	DESCRIPTION,
	SHORT_DESCRIPTION,
	FROM_DATE,
	TO_DATE,
	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_POOL_TYPES_V
     WHERE OKL_POOL_TYPES_V.id = p_id;

Line: 164


	l_potv_rec.last_updated_by,
	l_potv_rec.last_update_date,
	l_potv_rec.last_update_login;

Line: 208


    SELECT
	ID,
	OBJECT_VERSION_NUMBER,
	CODE,
	DESCRIPTION,
	SHORT_DESCRIPTION,
	FROM_DATE,
	TO_DATE,
	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_pool_types
     WHERE okl_pool_types.id = p_id;

Line: 271


	l_pot_rec.last_updated_by,
	l_pot_rec.last_update_date,
	l_pot_rec.last_update_login;

Line: 392


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

Line: 395


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

Line: 398


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

Line: 622


    p_to.last_updated_by := p_from.last_updated_by;

Line: 623


    p_to.last_update_date := p_from.last_update_date;

Line: 624


    p_to.last_update_login := p_from.last_update_login;

Line: 656


    p_to.last_updated_by := p_from.last_updated_by;

Line: 657


    p_to.last_update_date := p_from.last_update_date;

Line: 658


    p_to.last_update_login := p_from.last_update_login;

Line: 904


  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_pot_rec                      IN pot_rec_type,
    x_pot_rec                      OUT NOCOPY pot_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 913


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

Line: 949


    INSERT INTO okl_pool_types(
	ID,
	OBJECT_VERSION_NUMBER,
	CODE,
	DESCRIPTION,
	SHORT_DESCRIPTION,
	FROM_DATE,
	TO_DATE,
	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_pot_rec.id,
	l_pot_rec.object_version_number,
	l_pot_rec.code,
	l_pot_rec.description,
	l_pot_rec.short_description,
	l_pot_rec.from_date,
	l_pot_rec.TO_DATE,
	l_pot_rec.attribute_category,
	l_pot_rec.attribute1,
	l_pot_rec.attribute2,
	l_pot_rec.attribute3,
	l_pot_rec.attribute4,
	l_pot_rec.attribute5,
	l_pot_rec.attribute6,
	l_pot_rec.attribute7,
	l_pot_rec.attribute8,
	l_pot_rec.attribute9,
	l_pot_rec.attribute10,
	l_pot_rec.attribute11,
	l_pot_rec.attribute12,
	l_pot_rec.attribute13,
	l_pot_rec.attribute14,
	l_pot_rec.attribute15,
	l_pot_rec.created_by,
	l_pot_rec.creation_date,
	l_pot_rec.last_updated_by,
	l_pot_rec.last_update_date,
	l_pot_rec.last_update_login);

Line: 1042


  END insert_row;

Line: 1046


  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_potv_rec                     IN potv_rec_type,
    x_potv_rec                     OUT NOCOPY potv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1056


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

Line: 1072


      l_potv_rec.LAST_UPDATE_DATE := l_potv_rec.CREATION_DATE;

Line: 1073


      l_potv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1074


      l_potv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1138


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pot_rec,
      lx_pot_rec
    );

Line: 1187


  END insert_row;

Line: 1191


  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_potv_tbl                     IN potv_tbl_type,
    x_potv_tbl                     OUT NOCOPY potv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1202


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

Line: 1216


          insert_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_potv_rec                     => p_potv_tbl(i),
            x_potv_rec                     => x_potv_tbl(i));

Line: 1284


  END insert_row;

Line: 1289


  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_potv_tbl                     IN potv_tbl_type,
    x_potv_tbl                     OUT NOCOPY potv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1299


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

Line: 1306


      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_potv_tbl                     => p_potv_tbl,
        x_potv_tbl                     => x_potv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1348


  END insert_row;

Line: 1366


    SELECT OBJECT_VERSION_NUMBER
      FROM okl_pool_types
     WHERE ID = p_pot_rec.id
       AND OBJECT_VERSION_NUMBER = p_pot_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1373


    SELECT OBJECT_VERSION_NUMBER
      FROM okl_pool_types
     WHERE ID = p_pot_rec.id;

Line: 1414


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1423


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1703


  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_pot_rec                      IN pot_rec_type,
    x_pot_rec                      OUT NOCOPY pot_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1712


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

Line: 1833


        IF (x_pot_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_pot_rec.last_updated_by := l_pot_rec.last_updated_by;

Line: 1837


        IF (x_pot_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_pot_rec.last_update_date := l_pot_rec.last_update_date;

Line: 1841


        IF (x_pot_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_pot_rec.last_update_login := l_pot_rec.last_update_login;

Line: 1887


    UPDATE okl_pool_types
    SET OBJECT_VERSION_NUMBER = l_def_pot_rec.object_version_number,
        CODE = l_def_pot_rec.code,
        DESCRIPTION = l_def_pot_rec.description,
        SHORT_DESCRIPTION = l_def_pot_rec.short_description,
        FROM_DATE         = l_def_pot_rec.from_date,
        TO_DATE           = l_def_pot_rec.TO_DATE,
        ATTRIBUTE_CATEGORY = l_def_pot_rec.attribute_category,
        ATTRIBUTE1 = l_def_pot_rec.attribute1,
        ATTRIBUTE2 = l_def_pot_rec.attribute2,
        ATTRIBUTE3 = l_def_pot_rec.attribute3,
        ATTRIBUTE4 = l_def_pot_rec.attribute4,
        ATTRIBUTE5 = l_def_pot_rec.attribute5,
        ATTRIBUTE6 = l_def_pot_rec.attribute6,
        ATTRIBUTE7 = l_def_pot_rec.attribute7,
        ATTRIBUTE8 = l_def_pot_rec.attribute8,
        ATTRIBUTE9 = l_def_pot_rec.attribute9,
        ATTRIBUTE10 = l_def_pot_rec.attribute10,
        ATTRIBUTE11 = l_def_pot_rec.attribute11,
        ATTRIBUTE12 = l_def_pot_rec.attribute12,
        ATTRIBUTE13 = l_def_pot_rec.attribute13,
        ATTRIBUTE14 = l_def_pot_rec.attribute14,
        ATTRIBUTE15 = l_def_pot_rec.attribute15,
        CREATED_BY = l_def_pot_rec.created_by,
        CREATION_DATE = l_def_pot_rec.creation_date,
        LAST_UPDATED_BY = l_def_pot_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_pot_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_pot_rec.last_update_login
    WHERE ID = l_def_pot_rec.id;

Line: 1951


  END update_row;

Line: 1955


  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_potv_rec                     IN potv_rec_type,
    x_potv_rec                     OUT NOCOPY potv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1965


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

Line: 1980


      l_potv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1981


      l_potv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1982


      l_potv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2101


        IF (x_potv_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_potv_rec.last_updated_by := l_db_potv_rec.last_updated_by;

Line: 2105


        IF (x_potv_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_potv_rec.last_update_date := l_db_potv_rec.last_update_date;

Line: 2109


        IF (x_potv_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_potv_rec.last_update_login := l_db_potv_rec.last_update_login;

Line: 2197


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pot_rec,
      lx_pot_rec
    );

Line: 2245


  END update_row;

Line: 2249


  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_potv_tbl                     IN potv_tbl_type,
    x_potv_tbl                     OUT NOCOPY potv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2260


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

Line: 2274


          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_potv_rec                     => p_potv_tbl(i),
            x_potv_rec                     => x_potv_tbl(i));

Line: 2342


  END update_row;

Line: 2347


  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_potv_tbl                     IN potv_tbl_type,
    x_potv_tbl                     OUT NOCOPY potv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2357


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

Line: 2364


      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_potv_tbl                     => p_potv_tbl,
        x_potv_tbl                     => x_potv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2406


  END update_row;

Line: 2414


  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_pot_rec                      IN pot_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2422


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

Line: 2437


    DELETE FROM okl_pool_types
     WHERE ID = p_pot_rec.id;

Line: 2473


  END delete_row;

Line: 2477


  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_potv_rec                     IN potv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2486


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

Line: 2510


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

Line: 2555


  END delete_row;

Line: 2559


  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_potv_tbl                     IN potv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2569


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

Line: 2583


          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_potv_rec                     => p_potv_tbl(i));

Line: 2650


  END delete_row;

Line: 2655


  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_potv_tbl                     IN potv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2664


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

Line: 2671


      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_potv_tbl                     => p_potv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2712


  END delete_row;