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

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

Line: 43


    SELECT
            ID,
            PDT_ID,
            TEMPLATE_NAME,
            -- mvasudev, 05/13/2002
            TEMPLATE_PATH,
            --
            VERSION,
            START_DATE,
            OBJECT_VERSION_NUMBER,
            END_DATE,
            DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Prd_Price_Tmpls
     WHERE okl_prd_price_tmpls.id = p_id;

Line: 82


              l_pit_rec.LAST_UPDATED_BY,
              l_pit_rec.LAST_UPDATE_DATE,
              l_pit_rec.LAST_UPDATE_LOGIN;

Line: 105


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            PDT_ID,
            TEMPLATE_NAME,
            -- mvasudev , 05/13/2002
	    TEMPLATE_PATH,
	    --
	    VERSION,
            START_DATE,
            END_DATE,
            DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Prd_Price_Tmpls_V
     WHERE okl_prd_price_tmpls_v.id = p_id;

Line: 144


              l_pitv_rec.LAST_UPDATED_BY,
              l_pitv_rec.LAST_UPDATE_DATE,
              l_pitv_rec.LAST_UPDATE_LOGIN;

Line: 200


    IF (l_pitv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
      l_pitv_rec.last_updated_by := NULL;

Line: 203


    IF (l_pitv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
      l_pitv_rec.last_update_date := NULL;

Line: 206


    IF (l_pitv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
      l_pitv_rec.last_update_login := NULL;

Line: 387


  SELECT '1'
    FROM OKL_PRODUCTS_V
   WHERE OKL_PRODUCTS_V.id = p_id;

Line: 620


  SELECT '1'
  FROM OKL_PRD_PRICE_TMPLS_V
  WHERE  pdt_id =  p_rec.pdt_id
    AND  version = p_rec.version
    AND  id     <> NVL(p_rec.id,-9999);

Line: 1020


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1021


    p_to.last_update_date := p_from.last_update_date;

Line: 1022


    p_to.last_update_login := p_from.last_update_login;

Line: 1042


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1043


    p_to.last_update_date := p_from.last_update_date;

Line: 1044


    p_to.last_update_login := p_from.last_update_login;

Line: 1217


  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_pit_rec                      IN pit_rec_type,
    x_pit_rec                      OUT NOCOPY pit_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1226


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

Line: 1262


    INSERT INTO OKL_PRD_PRICE_TMPLS(
        id,
        pdt_id,
        template_name,
        -- mvasudev , 05/13/2002
        template_path,
        --
        version,
        start_date,
        object_version_number,
        end_date,
        description,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_pit_rec.id,
        l_pit_rec.pdt_id,
        l_pit_rec.template_name,
	-- mvasudev , 05/13/2002
	l_pit_rec.template_path,
	--
        l_pit_rec.version,
        l_pit_rec.start_date,
        l_pit_rec.object_version_number,
        l_pit_rec.end_date,
        l_pit_rec.description,
        l_pit_rec.created_by,
        l_pit_rec.creation_date,
        l_pit_rec.last_updated_by,
        l_pit_rec.last_update_date,
        l_pit_rec.last_update_login);

Line: 1330


  END insert_row;

Line: 1334


  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_pitv_rec                     IN pitv_rec_type,
    x_pitv_rec                     OUT NOCOPY pitv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1344


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

Line: 1360


      l_pitv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1361


      l_pitv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1362


      l_pitv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1434


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_pit_rec,
      lx_pit_rec
    );

Line: 1485


  END insert_row;

Line: 1489


  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_pitv_tbl                     IN pitv_tbl_type,
    x_pitv_tbl                     OUT NOCOPY pitv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1499


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

Line: 1514


        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_pitv_rec                     => p_pitv_tbl(i),
          x_pitv_rec                     => x_pitv_tbl(i));

Line: 1573


  END insert_row;

Line: 1591


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_PRD_PRICE_TMPLS
     WHERE ID = p_pit_rec.id
       AND OBJECT_VERSION_NUMBER = p_pit_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1598


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_PRD_PRICE_TMPLS
    WHERE ID = p_pit_rec.id;

Line: 1639


      Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1648


      Okc_Api.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);

Line: 1853


  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_pit_rec                      IN pit_rec_type,
    x_pit_rec                      OUT NOCOPY pit_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1862


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

Line: 1930


      IF (x_pit_rec.last_updated_by = Okc_Api.G_MISS_NUM)
      THEN
        x_pit_rec.last_updated_by := l_pit_rec.last_updated_by;

Line: 1934


      IF (x_pit_rec.last_update_date = Okc_Api.G_MISS_DATE)
      THEN
        x_pit_rec.last_update_date := l_pit_rec.last_update_date;

Line: 1938


      IF (x_pit_rec.last_update_login = Okc_Api.G_MISS_NUM)
      THEN
        x_pit_rec.last_update_login := l_pit_rec.last_update_login;

Line: 1982


    UPDATE  OKL_PRD_PRICE_TMPLS
    SET PDT_ID = l_def_pit_rec.pdt_id,
        TEMPLATE_NAME = l_def_pit_rec.template_name,
        TEMPLATE_PATH = l_def_pit_rec.template_path,
        VERSION = l_def_pit_rec.version,
        START_DATE = l_def_pit_rec.start_date,
        OBJECT_VERSION_NUMBER = l_def_pit_rec.object_version_number,
        END_DATE = l_def_pit_rec.end_date,
        DESCRIPTION = l_def_pit_rec.description,
        CREATED_BY = l_def_pit_rec.created_by,
        CREATION_DATE = l_def_pit_rec.creation_date,
        LAST_UPDATED_BY = l_def_pit_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_pit_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_pit_rec.last_update_login
    WHERE ID = l_def_pit_rec.id;

Line: 2031


  END update_row;

Line: 2035


  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_pitv_rec                     IN pitv_rec_type,
    x_pitv_rec                     OUT NOCOPY pitv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2045


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

Line: 2059


      l_pitv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2060


      l_pitv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2061


      l_pitv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2127


      IF (x_pitv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
      THEN
        x_pitv_rec.last_updated_by := l_pitv_rec.last_updated_by;

Line: 2131


      IF (x_pitv_rec.last_update_date = Okc_Api.G_MISS_DATE)
      THEN
        x_pitv_rec.last_update_date := l_pitv_rec.last_update_date;

Line: 2135


      IF (x_pitv_rec.last_update_login = Okc_Api.G_MISS_NUM)
      THEN
        x_pitv_rec.last_update_login := l_pitv_rec.last_update_login;

Line: 2206


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_pit_rec,
      lx_pit_rec
    );

Line: 2253


  END update_row;

Line: 2257


  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_pitv_tbl                     IN pitv_tbl_type,
    x_pitv_tbl                     OUT NOCOPY pitv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2267


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

Line: 2281


        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_pitv_rec                     => p_pitv_tbl(i),
          x_pitv_rec                     => x_pitv_tbl(i));

Line: 2338


  END update_row;

Line: 2346


  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_pit_rec                      IN pit_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2354


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

Line: 2368


    DELETE FROM OKL_PRD_PRICE_TMPLS
     WHERE ID = l_pit_rec.id;

Line: 2403


  END delete_row;

Line: 2407


  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_pitv_rec                     IN pitv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2416


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

Line: 2440


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_pit_rec
    );

Line: 2484


  END delete_row;

Line: 2488


  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_pitv_tbl                     IN pitv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2497


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

Line: 2511


        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_pitv_rec                     => p_pitv_tbl(i));

Line: 2567


  END delete_row;