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

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

Line: 205


   select 'x' from OKX_LOCATION_V
   where ID = p_acdv_rec.iln_id; */

Line: 287


       select 'x' from OKX_INSPECTORS_V
       where ID = p_acdv_rec.isp_id; */

Line: 429


select 'x' from OKL_INS_CLAIMS_B
where ID = p_acdv_rec.clm_id;

Line: 497


select 'x' from OKL_K_LINES_V
where ID = p_acdv_rec.kle_id;

Line: 567


    SELECT ACD.ID
    FROM   OKL_ASSET_CNDTNS ACD
          ,OKC_K_LINES_B CLE
          ,OKC_LINE_STYLES_B LSE
    WHERE  ACD.KLE_ID = p_kle_id
       AND ACD.KLE_ID = CLE.ID
       AND CLE.LSE_ID = LSE.ID
       AND LSE.LTY_CODE = 'FREE_FORM1'
       AND ACD.ID <> nvl (p_id, -99999);

Line: 660


    SELECT
            ID,
            DATE_REPORT,
            CDN_CODE,
            CLM_ID,
            ISP_ID,
            ILN_ID,
            KLE_ID,
            OBJECT_VERSION_NUMBER,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_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_Asset_Cndtns
     WHERE okl_asset_cndtns.id  = p_id;

Line: 716


              l_acd_rec.PROGRAM_UPDATE_DATE,
              l_acd_rec.ATTRIBUTE_CATEGORY,
              l_acd_rec.ATTRIBUTE1,
              l_acd_rec.ATTRIBUTE2,
              l_acd_rec.ATTRIBUTE3,
              l_acd_rec.ATTRIBUTE4,
              l_acd_rec.ATTRIBUTE5,
              l_acd_rec.ATTRIBUTE6,
              l_acd_rec.ATTRIBUTE7,
              l_acd_rec.ATTRIBUTE8,
              l_acd_rec.ATTRIBUTE9,
              l_acd_rec.ATTRIBUTE10,
              l_acd_rec.ATTRIBUTE11,
              l_acd_rec.ATTRIBUTE12,
              l_acd_rec.ATTRIBUTE13,
              l_acd_rec.ATTRIBUTE14,
              l_acd_rec.ATTRIBUTE15,
              l_acd_rec.CREATED_BY,
              l_acd_rec.CREATION_DATE,
              l_acd_rec.LAST_UPDATED_BY,
              l_acd_rec.LAST_UPDATE_DATE,
              l_acd_rec.LAST_UPDATE_LOGIN;

Line: 758


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CDN_CODE,
            ILN_ID,
            ISP_ID,
            CLM_ID,
            KLE_ID,
            DATE_REPORT,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            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
      FROM OKL_ASSET_CNDTNS
     WHERE OKL_ASSET_CNDTNS.id = p_id;

Line: 830


              l_acdv_rec.PROGRAM_UPDATE_DATE,
              l_acdv_rec.CREATED_BY,
              l_acdv_rec.CREATION_DATE,
              l_acdv_rec.LAST_UPDATED_BY,
              l_acdv_rec.LAST_UPDATE_DATE,
              l_acdv_rec.LAST_UPDATE_LOGIN;

Line: 940


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

Line: 951


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

Line: 954


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

Line: 957


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

Line: 1111


    p_to.program_update_date := p_from.program_update_date;

Line: 1130


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1131


    p_to.last_update_date := p_from.last_update_date;

Line: 1132


    p_to.last_update_login := p_from.last_update_login;

Line: 1151


    p_to.program_update_date := p_from.program_update_date;

Line: 1170


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1171


    p_to.last_update_date := p_from.last_update_date;

Line: 1172


    p_to.last_update_login := p_from.last_update_login;

Line: 1350


  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_acd_rec                      IN acd_rec_type,
    x_acd_rec                      OUT NOCOPY acd_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1359


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

Line: 1395


    INSERT INTO OKL_ASSET_CNDTNS(
        id,
        date_report,
        cdn_code,
        clm_id,
        isp_id,
        iln_id,
        kle_id,
        object_version_number,
        org_id,
        request_id,
        program_application_id,
        program_id,
        program_update_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_acd_rec.id,
        l_acd_rec.date_report,
        l_acd_rec.cdn_code,
        l_acd_rec.clm_id,
        l_acd_rec.isp_id,
        l_acd_rec.iln_id,
        l_acd_rec.kle_id,
        l_acd_rec.object_version_number,
        l_acd_rec.org_id,
      /*  l_acd_rec.request_id,
        l_acd_rec.program_application_id,
        l_acd_rec.program_id,
        l_acd_rec.program_update_date,*/
        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_acd_rec.attribute_category,
        l_acd_rec.attribute1,
        l_acd_rec.attribute2,
        l_acd_rec.attribute3,
        l_acd_rec.attribute4,
        l_acd_rec.attribute5,
        l_acd_rec.attribute6,
        l_acd_rec.attribute7,
        l_acd_rec.attribute8,
        l_acd_rec.attribute9,
        l_acd_rec.attribute10,
        l_acd_rec.attribute11,
        l_acd_rec.attribute12,
        l_acd_rec.attribute13,
        l_acd_rec.attribute14,
        l_acd_rec.attribute15,
        l_acd_rec.created_by,
        l_acd_rec.creation_date,
        l_acd_rec.last_updated_by,
        l_acd_rec.last_update_date,
        l_acd_rec.last_update_login);

Line: 1507


  END insert_row;

Line: 1511


  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_acdv_rec                     IN acdv_rec_type,
    x_acdv_rec                     OUT NOCOPY acdv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1521


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

Line: 1537


      l_acdv_rec.LAST_UPDATE_DATE := l_acdv_rec.CREATION_DATE;

Line: 1538


      l_acdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1539


      l_acdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1608


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_acd_rec,
      lx_acd_rec
    );

Line: 1660


  END insert_row;

Line: 1664


  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_acdv_tbl                     IN acdv_tbl_type,
    x_acdv_tbl                     OUT NOCOPY acdv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1674


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

Line: 1687


        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_acdv_rec                     => p_acdv_tbl(i),
          x_acdv_rec                     => x_acdv_tbl(i));

Line: 1746


  END insert_row;

Line: 1764


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ASSET_CNDTNS
     WHERE ID = p_acd_rec.id
       AND OBJECT_VERSION_NUMBER = p_acd_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1771


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ASSET_CNDTNS
    WHERE ID = p_acd_rec.id;

Line: 1816


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1825


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2040


  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_acd_rec                      IN acd_rec_type,
    x_acd_rec                      OUT NOCOPY acd_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2049


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

Line: 2119


      IF (x_acd_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_acd_rec.program_update_date := l_acd_rec.program_update_date;

Line: 2195


      IF (x_acd_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_acd_rec.last_updated_by := l_acd_rec.last_updated_by;

Line: 2199


      IF (x_acd_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_acd_rec.last_update_date := l_acd_rec.last_update_date;

Line: 2203


      IF (x_acd_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_acd_rec.last_update_login := l_acd_rec.last_update_login;

Line: 2247


    UPDATE  OKL_ASSET_CNDTNS
    SET DATE_REPORT = l_def_acd_rec.date_report,
        CDN_CODE = l_def_acd_rec.cdn_code,
        CLM_ID = l_def_acd_rec.clm_id,
        ISP_ID = l_def_acd_rec.isp_id,
        ILN_ID = l_def_acd_rec.iln_id,
        KLE_ID = l_def_acd_rec.kle_id,
        OBJECT_VERSION_NUMBER = l_def_acd_rec.object_version_number,
        ORG_ID = l_def_acd_rec.org_id,
       /* REQUEST_ID = l_def_acd_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_acd_rec.program_application_id,
        PROGRAM_ID = l_def_acd_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_acd_rec.program_update_date,*/
        REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_acd_rec.request_id),
        PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_acd_rec.program_application_id),
        PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_acd_rec.program_id),
        PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_acd_rec.program_update_date,SYSDATE),
        ATTRIBUTE_CATEGORY = l_def_acd_rec.attribute_category,
        ATTRIBUTE1 = l_def_acd_rec.attribute1,
        ATTRIBUTE2 = l_def_acd_rec.attribute2,
        ATTRIBUTE3 = l_def_acd_rec.attribute3,
        ATTRIBUTE4 = l_def_acd_rec.attribute4,
        ATTRIBUTE5 = l_def_acd_rec.attribute5,
        ATTRIBUTE6 = l_def_acd_rec.attribute6,
        ATTRIBUTE7 = l_def_acd_rec.attribute7,
        ATTRIBUTE8 = l_def_acd_rec.attribute8,
        ATTRIBUTE9 = l_def_acd_rec.attribute9,
        ATTRIBUTE10 = l_def_acd_rec.attribute10,
        ATTRIBUTE11 = l_def_acd_rec.attribute11,
        ATTRIBUTE12 = l_def_acd_rec.attribute12,
        ATTRIBUTE13 = l_def_acd_rec.attribute13,
        ATTRIBUTE14 = l_def_acd_rec.attribute14,
        ATTRIBUTE15 = l_def_acd_rec.attribute15,
        CREATED_BY = l_def_acd_rec.created_by,
        CREATION_DATE = l_def_acd_rec.creation_date,
        LAST_UPDATED_BY = l_def_acd_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_acd_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_acd_rec.last_update_login
    WHERE ID = l_def_acd_rec.id;

Line: 2324


  END update_row;

Line: 2328


  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_acdv_rec                     IN acdv_rec_type,
    x_acdv_rec                     OUT NOCOPY acdv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2338


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

Line: 2352


      l_acdv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2353


      l_acdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2354


      l_acdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2486


      IF (x_acdv_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_acdv_rec.program_update_date := l_acdv_rec.program_update_date;

Line: 2498


      IF (x_acdv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_acdv_rec.last_updated_by := l_acdv_rec.last_updated_by;

Line: 2502


      IF (x_acdv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_acdv_rec.last_update_date := l_acdv_rec.last_update_date;

Line: 2506


      IF (x_acdv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_acdv_rec.last_update_login := l_acdv_rec.last_update_login;

Line: 2577


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_acd_rec,
      lx_acd_rec
    );

Line: 2628


  END update_row;

Line: 2632


  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_acdv_tbl                     IN acdv_tbl_type,
    x_acdv_tbl                     OUT NOCOPY acdv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2642


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

Line: 2655


        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_acdv_rec                     => p_acdv_tbl(i),
          x_acdv_rec                     => x_acdv_tbl(i));

Line: 2714


  END update_row;

Line: 2722


  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_acd_rec                      IN acd_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2730


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

Line: 2744


    DELETE FROM OKL_ASSET_CNDTNS
     WHERE ID = l_acd_rec.id;

Line: 2783


  END delete_row;

Line: 2787


  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_acdv_rec                     IN acdv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2796


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

Line: 2820


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

Line: 2868


  END delete_row;

Line: 2872


  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_acdv_tbl                     IN acdv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2881


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

Line: 2894


        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_acdv_rec                     => p_acdv_tbl(i));

Line: 2952


  END delete_row;