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

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

Line: 101


    SELECT
            ID,
            QUOTE_LINE_TYPE_CODE,
            ORG_ID,
            STY_ID,
            INVOICABLE_YN,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM OKL_QUOTE_LINE_STRM
     WHERE OKL_QUOTE_LINE_STRM.id = p_id;

Line: 130


              l_qlsv_rec.last_updated_by,
              l_qlsv_rec.last_update_date,
              l_qlsv_rec.last_update_login;

Line: 174


    SELECT
            ID,
            QUOTE_LINE_TYPE_CODE,
            ORG_ID,
            STY_ID,
            INVOICABLE_YN,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Quote_Line_Strm
     WHERE okl_quote_line_strm.id = p_id;

Line: 203


              l_qls_rec.last_updated_by,
              l_qls_rec.last_update_date,
              l_qls_rec.last_update_login;

Line: 271


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

Line: 274


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

Line: 277


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

Line: 526


      SELECT 'x'
        FROM Fnd_Lookups flk
       WHERE flk.lookup_code = p_lookup_code
         AND flk.lookup_type = 'OKL_QUOTE_LINE_TYPE';

Line: 533


      SELECT 'x'
        FROM Okl_Strm_Type_V
       WHERE okl_strm_type_v.id   = p_id;

Line: 596


      SELECT 'x'
      FROM   OKL_QUOTE_LINE_STRM
      WHERE  quote_line_type_code =  p_qlsv_rec.quote_line_type_code
      AND    sty_id               =  p_qlsv_rec.sty_id
      AND    id                   <> NVL(p_qlsv_rec.id, -99999);

Line: 662


    p_to.last_updated_by := p_from.last_updated_by;

Line: 663


    p_to.last_update_date := p_from.last_update_date;

Line: 664


    p_to.last_update_login := p_from.last_update_login;

Line: 679


    p_to.last_updated_by := p_from.last_updated_by;

Line: 680


    p_to.last_update_date := p_from.last_update_date;

Line: 681


    p_to.last_update_login := p_from.last_update_login;

Line: 927


  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_qls_rec                      IN qls_rec_type,
    x_qls_rec                      OUT NOCOPY qls_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 936


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

Line: 972


    INSERT INTO OKL_QUOTE_LINE_STRM(
      id,
      quote_line_type_code,
      org_id,
      sty_id,
      invoicable_yn,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_qls_rec.id,
      l_qls_rec.quote_line_type_code,
      l_qls_rec.org_id,
      l_qls_rec.sty_id,
      l_qls_rec.invoicable_yn,
      l_qls_rec.object_version_number,
      l_qls_rec.created_by,
      l_qls_rec.creation_date,
      l_qls_rec.last_updated_by,
      l_qls_rec.last_update_date,
      l_qls_rec.last_update_login);

Line: 1031


  END insert_row;

Line: 1035


  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_qlsv_rec                     IN qlsv_rec_type,
    x_qlsv_rec                     OUT NOCOPY qlsv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1045


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

Line: 1061


      l_qlsv_rec.LAST_UPDATE_DATE := l_qlsv_rec.CREATION_DATE;

Line: 1062


      l_qlsv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1063


      l_qlsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1132


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_qls_rec,
      lx_qls_rec
    );

Line: 1181


  END insert_row;

Line: 1185


  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_qlsv_tbl                     IN qlsv_tbl_type,
    x_qlsv_tbl                     OUT NOCOPY qlsv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1196


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

Line: 1210


          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_qlsv_rec                     => p_qlsv_tbl(i),
            x_qlsv_rec                     => x_qlsv_tbl(i));

Line: 1278


  END insert_row;

Line: 1283


  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_qlsv_tbl                     IN qlsv_tbl_type,
    x_qlsv_tbl                     OUT NOCOPY qlsv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1293


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

Line: 1300


      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_qlsv_tbl                     => p_qlsv_tbl,
        x_qlsv_tbl                     => x_qlsv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1342


  END insert_row;

Line: 1360


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_QUOTE_LINE_STRM
     WHERE ID = p_qls_rec.id
       AND OBJECT_VERSION_NUMBER = p_qls_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1367


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_QUOTE_LINE_STRM
     WHERE ID = p_qls_rec.id;

Line: 1408


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1417


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1697


  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_qls_rec                      IN qls_rec_type,
    x_qls_rec                      OUT NOCOPY qls_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1706


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

Line: 1758


        IF (x_qls_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_qls_rec.last_updated_by := l_qls_rec.last_updated_by;

Line: 1762


        IF (x_qls_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_qls_rec.last_update_date := l_qls_rec.last_update_date;

Line: 1766


        IF (x_qls_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_qls_rec.last_update_login := l_qls_rec.last_update_login;

Line: 1812


    UPDATE OKL_QUOTE_LINE_STRM
    SET QUOTE_LINE_TYPE_CODE = l_def_qls_rec.quote_line_type_code,
        ORG_ID = l_def_qls_rec.org_id,
        STY_ID = l_def_qls_rec.sty_id,
        INVOICABLE_YN = l_def_qls_rec.invoicable_yn,
        OBJECT_VERSION_NUMBER = l_def_qls_rec.object_version_number,
        CREATED_BY = l_def_qls_rec.created_by,
        CREATION_DATE = l_def_qls_rec.creation_date,
        LAST_UPDATED_BY = l_def_qls_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_qls_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_qls_rec.last_update_login
    WHERE ID = l_def_qls_rec.id;

Line: 1859


  END update_row;

Line: 1863


  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_qlsv_rec                     IN qlsv_rec_type,
    x_qlsv_rec                     OUT NOCOPY qlsv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1873


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

Line: 1888


      l_qlsv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1889


      l_qlsv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1890


      l_qlsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1937


        IF (x_qlsv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_qlsv_rec.last_updated_by := l_db_qlsv_rec.last_updated_by;

Line: 1941


        IF (x_qlsv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_qlsv_rec.last_update_date := l_db_qlsv_rec.last_update_date;

Line: 1945


        IF (x_qlsv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_qlsv_rec.last_update_login := l_db_qlsv_rec.last_update_login;

Line: 2030


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_qls_rec,
      lx_qls_rec
    );

Line: 2078


  END update_row;

Line: 2082


  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_qlsv_tbl                     IN qlsv_tbl_type,
    x_qlsv_tbl                     OUT NOCOPY qlsv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2093


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

Line: 2107


          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_qlsv_rec                     => p_qlsv_tbl(i),
            x_qlsv_rec                     => x_qlsv_tbl(i));

Line: 2175


  END update_row;

Line: 2180


  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_qlsv_tbl                     IN qlsv_tbl_type,
    x_qlsv_tbl                     OUT NOCOPY qlsv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2190


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

Line: 2197


      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_qlsv_tbl                     => p_qlsv_tbl,
        x_qlsv_tbl                     => x_qlsv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2239


  END update_row;

Line: 2247


  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_qls_rec                      IN qls_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2255


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

Line: 2270


    DELETE FROM OKL_QUOTE_LINE_STRM
     WHERE ID = p_qls_rec.id;

Line: 2306


  END delete_row;

Line: 2310


  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_qlsv_rec                     IN qlsv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2319


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

Line: 2343


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

Line: 2388


  END delete_row;

Line: 2392


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2402


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

Line: 2416


          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_qlsv_rec                     => p_qlsv_tbl(i));

Line: 2483


  END delete_row;

Line: 2488


  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_qlsv_tbl                     IN qlsv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2497


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

Line: 2504


      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_qlsv_tbl                     => p_qlsv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2545


  END delete_row;