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

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

Line: 44


    SELECT  ID,
            OBJECT_VERSION_NUMBER,
            NUMBER_OF_UNITS,
            TQL_ID,
            KLE_ID,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15
      FROM OKL_TXD_QUOTE_LINE_DTLS
     WHERE OKL_TXD_QUOTE_LINE_DTLS.id = p_id;

Line: 93


              l_tqdv_rec.program_update_date,
              l_tqdv_rec.created_by,
              l_tqdv_rec.creation_date,
              l_tqdv_rec.last_updated_by,
              l_tqdv_rec.last_update_date,
              l_tqdv_rec.last_update_login,
              l_tqdv_rec.attribute_category,
              l_tqdv_rec.attribute1,
              l_tqdv_rec.attribute2,
              l_tqdv_rec.attribute3,
              l_tqdv_rec.attribute4,
              l_tqdv_rec.attribute5,
              l_tqdv_rec.attribute6,
              l_tqdv_rec.attribute7,
              l_tqdv_rec.attribute8,
              l_tqdv_rec.attribute9,
              l_tqdv_rec.attribute10,
              l_tqdv_rec.attribute11,
              l_tqdv_rec.attribute12,
              l_tqdv_rec.attribute13,
              l_tqdv_rec.attribute14,
              l_tqdv_rec.attribute15;

Line: 153


    SELECT  ID,
            OBJECT_VERSION_NUMBER,
            NUMBER_OF_UNITS,
            KLE_ID,
            TQL_ID,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15
      FROM Okl_Txd_Quote_Line_Dtls
     WHERE okl_txd_quote_line_dtls.id = p_id;

Line: 202


              l_tqd_rec.program_update_date,
              l_tqd_rec.created_by,
              l_tqd_rec.creation_date,
              l_tqd_rec.last_updated_by,
              l_tqd_rec.last_update_date,
              l_tqd_rec.last_update_login,
              l_tqd_rec.attribute_category,
              l_tqd_rec.attribute1,
              l_tqd_rec.attribute2,
              l_tqd_rec.attribute3,
              l_tqd_rec.attribute4,
              l_tqd_rec.attribute5,
              l_tqd_rec.attribute6,
              l_tqd_rec.attribute7,
              l_tqd_rec.attribute8,
              l_tqd_rec.attribute9,
              l_tqd_rec.attribute10,
              l_tqd_rec.attribute11,
              l_tqd_rec.attribute12,
              l_tqd_rec.attribute13,
              l_tqd_rec.attribute14,
              l_tqd_rec.attribute15;

Line: 289


    IF (l_tqdv_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
      l_tqdv_rec.program_update_date := NULL;

Line: 298


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

Line: 301


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

Line: 304


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

Line: 440


    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT 'x'
    FROM Okl_Txl_Quote_Lines_V
    WHERE okl_txl_quote_lines_v.id = p_tql_id);

Line: 505


    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT 'x'
    FROM Okl_k_lines_V kle
    WHERE kle.id = p_kle_id);

Line: 638


    p_to.program_update_date := p_from.program_update_date;

Line: 641


    p_to.last_updated_by := p_from.last_updated_by;

Line: 642


    p_to.last_update_date := p_from.last_update_date;

Line: 643


    p_to.last_update_login := p_from.last_update_login;

Line: 673


    p_to.program_update_date := p_from.program_update_date;

Line: 676


    p_to.last_updated_by := p_from.last_updated_by;

Line: 677


    p_to.last_update_date := p_from.last_update_date;

Line: 678


    p_to.last_update_login := p_from.last_update_login;

Line: 842


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tqd_rec                      IN tqd_rec_type,
    x_tqd_rec                      OUT NOCOPY tqd_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 851


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

Line: 884


    INSERT INTO OKL_TXD_QUOTE_LINE_DTLS(
      id,
      object_version_number,
      number_of_units,
      kle_id,
      tql_id,
      org_id,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15)
    VALUES (
      l_tqd_rec.id,
      l_tqd_rec.object_version_number,
      l_tqd_rec.number_of_units,
      l_tqd_rec.kle_id,
      l_tqd_rec.tql_id,
      l_tqd_rec.org_id,
      decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
      decode(FND_GLOBAL.PROG_APPL_ID, -1, NULL, FND_GLOBAL.PROG_APPL_ID),
      decode(FND_GLOBAL.CONC_PROGRAM_ID, -1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
      decode(FND_GLOBAL.CONC_REQUEST_ID, -1, NULL, SYSDATE),
      l_tqd_rec.created_by,
      l_tqd_rec.creation_date,
      l_tqd_rec.last_updated_by,
      l_tqd_rec.last_update_date,
      l_tqd_rec.last_update_login,
      l_tqd_rec.attribute_category,
      l_tqd_rec.attribute1,
      l_tqd_rec.attribute2,
      l_tqd_rec.attribute3,
      l_tqd_rec.attribute4,
      l_tqd_rec.attribute5,
      l_tqd_rec.attribute6,
      l_tqd_rec.attribute7,
      l_tqd_rec.attribute8,
      l_tqd_rec.attribute9,
      l_tqd_rec.attribute10,
      l_tqd_rec.attribute11,
      l_tqd_rec.attribute12,
      l_tqd_rec.attribute13,
      l_tqd_rec.attribute14,
      l_tqd_rec.attribute15);

Line: 976


  END insert_row;

Line: 980


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tqdv_rec                     IN tqdv_rec_type,
    x_tqdv_rec                     OUT NOCOPY tqdv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 990


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

Line: 1005


      l_tqdv_rec.LAST_UPDATE_DATE := l_tqdv_rec.CREATION_DATE;

Line: 1006


      l_tqdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1007


      l_tqdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1071


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_tqd_rec,
      lx_tqd_rec
    );

Line: 1113


  END insert_row;

Line: 1117


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tqdv_tbl                     IN tqdv_tbl_type,
    x_tqdv_tbl                     OUT NOCOPY tqdv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1127


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

Line: 1135


        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_tqdv_rec       => p_tqdv_tbl(i),
                    x_tqdv_rec       => x_tqdv_tbl(i));

Line: 1182


  END insert_row;

Line: 1199


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TXD_QUOTE_LINE_DTLS
     WHERE ID = p_tqd_rec.id
       AND OBJECT_VERSION_NUMBER = p_tqd_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1206


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TXD_QUOTE_LINE_DTLS
     WHERE ID = p_tqd_rec.id;

Line: 1246


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1255


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1431


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tqd_rec                      IN tqd_rec_type,
    x_tqd_rec                      OUT NOCOPY tqd_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1440


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

Line: 1495


        IF (x_tqd_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_tqd_rec.program_update_date := l_tqd_rec.program_update_date;

Line: 1507


        IF (x_tqd_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_tqd_rec.last_updated_by := l_tqd_rec.last_updated_by;

Line: 1511


        IF (x_tqd_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_tqd_rec.last_update_date := l_tqd_rec.last_update_date;

Line: 1515


        IF (x_tqd_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_tqd_rec.last_update_login := l_tqd_rec.last_update_login;

Line: 1625


    UPDATE OKL_TXD_QUOTE_LINE_DTLS
    SET OBJECT_VERSION_NUMBER = l_def_tqd_rec.object_version_number,
        NUMBER_OF_UNITS = l_def_tqd_rec.number_of_units,
        KLE_ID = l_def_tqd_rec.kle_id,
        TQL_ID = l_def_tqd_rec.tql_id,
        ORG_ID = l_def_tqd_rec.org_id,
        REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,
                 FND_GLOBAL.CONC_REQUEST_ID),l_def_tqd_rec.request_id),
        PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,
                 FND_GLOBAL.PROG_APPL_ID),l_def_tqd_rec.program_application_id),
        PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,
                 FND_GLOBAL.CONC_PROGRAM_ID),l_def_tqd_rec.program_id),
        PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,
                 SYSDATE),NULL,l_def_tqd_rec.program_update_date,SYSDATE),
        CREATED_BY = l_def_tqd_rec.created_by,
        CREATION_DATE = l_def_tqd_rec.creation_date,
        LAST_UPDATED_BY = l_def_tqd_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_tqd_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_tqd_rec.last_update_login,
        ATTRIBUTE_CATEGORY = l_def_tqd_rec.attribute_category,
        ATTRIBUTE1 = l_def_tqd_rec.attribute1,
        ATTRIBUTE2 = l_def_tqd_rec.attribute2,
        ATTRIBUTE3 = l_def_tqd_rec.attribute3,
        ATTRIBUTE4 = l_def_tqd_rec.attribute4,
        ATTRIBUTE5 = l_def_tqd_rec.attribute5,
        ATTRIBUTE6 = l_def_tqd_rec.attribute6,
        ATTRIBUTE7 = l_def_tqd_rec.attribute7,
        ATTRIBUTE8 = l_def_tqd_rec.attribute8,
        ATTRIBUTE9 = l_def_tqd_rec.attribute9,
        ATTRIBUTE10 = l_def_tqd_rec.attribute10,
        ATTRIBUTE11 = l_def_tqd_rec.attribute11,
        ATTRIBUTE12 = l_def_tqd_rec.attribute12,
        ATTRIBUTE13 = l_def_tqd_rec.attribute13,
        ATTRIBUTE14 = l_def_tqd_rec.attribute14,
        ATTRIBUTE15 = l_def_tqd_rec.attribute15
    WHERE ID = l_def_tqd_rec.id;

Line: 1688


  END update_row;

Line: 1692


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tqdv_rec                     IN tqdv_rec_type,
    x_tqdv_rec                     OUT NOCOPY tqdv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1702


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

Line: 1716


      l_tqdv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1717


      l_tqdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1718


      l_tqdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1773


        IF (x_tqdv_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_tqdv_rec.program_update_date := l_db_tqdv_rec.program_update_date;

Line: 1785


        IF (x_tqdv_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_tqdv_rec.last_updated_by := l_db_tqdv_rec.last_updated_by;

Line: 1789


        IF (x_tqdv_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_tqdv_rec.last_update_date := l_db_tqdv_rec.last_update_date;

Line: 1793


        IF (x_tqdv_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_tqdv_rec.last_update_login := l_db_tqdv_rec.last_update_login;

Line: 1942


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_tqd_rec,
      lx_tqd_rec
    );

Line: 1983


  END update_row;

Line: 1987


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tqdv_tbl                     IN tqdv_tbl_type,
    x_tqdv_tbl                     OUT NOCOPY tqdv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1997


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

Line: 2005


        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_tqdv_rec       => p_tqdv_tbl(i),
                    x_tqdv_rec       => x_tqdv_tbl(i));

Line: 2052


  END update_row;

Line: 2059


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tqd_rec                      IN tqd_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2067


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

Line: 2081


    DELETE FROM OKL_TXD_QUOTE_LINE_DTLS
    WHERE ID = p_tqd_rec.id;

Line: 2109


  END delete_row;

Line: 2113


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tqdv_rec                     IN tqdv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2122


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

Line: 2145


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

Line: 2183


  END delete_row;

Line: 2187


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tqdv_tbl                     IN tqdv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2196


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

Line: 2204


        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_tqdv_rec       => p_tqdv_tbl(i));

Line: 2251


  END delete_row;