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.OKC_CPS_PVT SQL Statements

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

Line: 30


  		select 'x'
  		from OKC_PROCESS_DEFS_B
  		where ID = p_cpsv_rec.pdf_id;

Line: 106


  		select 'x'
  		from OKC_K_HEADERS_B
  		where ID = p_cpsv_rec.chr_id;

Line: 167


  		select 'x'
  		from FND_USER_VIEW
  		where USER_ID = p_cpsv_rec.user_id;

Line: 229


  		select 'x'
  		from OKC_CHANGE_REQUESTS_B
  		where ID = p_cpsv_rec.crt_id;

Line: 418


    SELECT
            ID,
            PDF_ID,
            CHR_ID,
            USER_ID,
            CRT_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            PROCESS_ID,
            IN_PROCESS_YN,
            LAST_UPDATE_LOGIN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15
      FROM Okc_K_Processes
     WHERE okc_k_processes.id   = p_id;

Line: 465


              l_cps_rec.LAST_UPDATED_BY,
              l_cps_rec.LAST_UPDATE_DATE,
              l_cps_rec.PROCESS_ID,
              l_cps_rec.IN_PROCESS_YN,
              l_cps_rec.LAST_UPDATE_LOGIN,
              l_cps_rec.ATTRIBUTE_CATEGORY,
              l_cps_rec.ATTRIBUTE1,
              l_cps_rec.ATTRIBUTE2,
              l_cps_rec.ATTRIBUTE3,
              l_cps_rec.ATTRIBUTE4,
              l_cps_rec.ATTRIBUTE5,
              l_cps_rec.ATTRIBUTE6,
              l_cps_rec.ATTRIBUTE7,
              l_cps_rec.ATTRIBUTE8,
              l_cps_rec.ATTRIBUTE9,
              l_cps_rec.ATTRIBUTE10,
              l_cps_rec.ATTRIBUTE11,
              l_cps_rec.ATTRIBUTE12,
              l_cps_rec.ATTRIBUTE13,
              l_cps_rec.ATTRIBUTE14,
              l_cps_rec.ATTRIBUTE15;

Line: 506


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            PDF_ID,
            CHR_ID,
            USER_ID,
            CRT_ID,
            PROCESS_ID,
            IN_PROCESS_YN,
            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 Okc_K_Processes_V
     WHERE okc_k_processes_v.id = p_id;

Line: 571


              l_cpsv_rec.LAST_UPDATED_BY,
              l_cpsv_rec.LAST_UPDATE_DATE,
              l_cpsv_rec.LAST_UPDATE_LOGIN;

Line: 670


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

Line: 673


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

Line: 676


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

Line: 797


		select count(1)
		from okc_k_processes cps, okc_process_defs_b pdfb
		where cps.pdf_id = pdfb.id
		and cps.chr_id = p_cpsv_rec.chr_id
		and pdfb.usage='APPROVE' and pdfb.pdf_type='WPS'
		and cps.id <> p_cpsv_rec.id;

Line: 811


		SELECT 'x'
		FROM   okc_k_processes cps
		WHERE  chr_id = p_cpsv_rec.CHR_ID
		AND    crt_id IS NULL
		AND    pdf_id = p_cpsv_rec.PDF_ID
		AND    id <> NVL(p_cpsv_rec.ID,-9999);

Line: 824


		SELECT 'x'
		FROM   okc_k_processes cps
		WHERE  chr_id IS NULL
		AND    crt_id = p_cpsv_rec.CRT_ID
		AND    pdf_id = p_cpsv_rec.PDF_ID
		AND    id <> NVL(p_cpsv_rec.ID,-9999);

Line: 910


    p_to.last_updated_by := p_from.last_updated_by;

Line: 911


    p_to.last_update_date := p_from.last_update_date;

Line: 914


    p_to.last_update_login := p_from.last_update_login;

Line: 945


    p_to.last_updated_by := p_from.last_updated_by;

Line: 946


    p_to.last_update_date := p_from.last_update_date;

Line: 949


    p_to.last_update_login := p_from.last_update_login;

Line: 1129


  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_cps_rec                      IN cps_rec_type,
    x_cps_rec                      OUT NOCOPY cps_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1138


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

Line: 1174


    INSERT INTO OKC_K_PROCESSES(
        id,
        pdf_id,
        chr_id,
        user_id,
        crt_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        process_id,
        in_process_yn,
        last_update_login,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15)
      VALUES (
        l_cps_rec.id,
        l_cps_rec.pdf_id,
        l_cps_rec.chr_id,
        l_cps_rec.user_id,
        l_cps_rec.crt_id,
        l_cps_rec.object_version_number,
        l_cps_rec.created_by,
        l_cps_rec.creation_date,
        l_cps_rec.last_updated_by,
        l_cps_rec.last_update_date,
        l_cps_rec.process_id,
        l_cps_rec.in_process_yn,
        l_cps_rec.last_update_login,
        l_cps_rec.attribute_category,
        l_cps_rec.attribute1,
        l_cps_rec.attribute2,
        l_cps_rec.attribute3,
        l_cps_rec.attribute4,
        l_cps_rec.attribute5,
        l_cps_rec.attribute6,
        l_cps_rec.attribute7,
        l_cps_rec.attribute8,
        l_cps_rec.attribute9,
        l_cps_rec.attribute10,
        l_cps_rec.attribute11,
        l_cps_rec.attribute12,
        l_cps_rec.attribute13,
        l_cps_rec.attribute14,
        l_cps_rec.attribute15);

Line: 1268


  END insert_row;

Line: 1272


  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_cpsv_rec                     IN cpsv_rec_type,
    x_cpsv_rec                     OUT NOCOPY cpsv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1282


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

Line: 1299


      l_cpsv_rec.LAST_UPDATE_DATE := l_cpsv_rec.CREATION_DATE;

Line: 1300


      l_cpsv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1301


      l_cpsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1369


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cps_rec,
      lx_cps_rec
    );

Line: 1417


  END insert_row;

Line: 1421


  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_cpsv_tbl                     IN cpsv_tbl_type,
    x_cpsv_tbl                     OUT NOCOPY cpsv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1431


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

Line: 1441


        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_cpsv_rec                     => p_cpsv_tbl(i),
          x_cpsv_rec                     => x_cpsv_tbl(i));

Line: 1494


  END insert_row;

Line: 1512


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_K_PROCESSES
     WHERE ID = p_cps_rec.id
       AND OBJECT_VERSION_NUMBER in (p_cps_rec.object_version_number,
							  OKC_API.G_MISS_NUM)
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1520


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_K_PROCESSES
    WHERE ID = p_cps_rec.id;

Line: 1561


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1570


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1768


  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_cps_rec                      IN cps_rec_type,
    x_cps_rec                      OUT NOCOPY cps_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1777


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

Line: 1831


      IF (x_cps_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_cps_rec.last_updated_by := l_cps_rec.last_updated_by;

Line: 1835


      IF (x_cps_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cps_rec.last_update_date := l_cps_rec.last_update_date;

Line: 1847


      IF (x_cps_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_cps_rec.last_update_login := l_cps_rec.last_update_login;

Line: 1955


    UPDATE  OKC_K_PROCESSES
    SET PDF_ID = l_def_cps_rec.pdf_id,
        CHR_ID = l_def_cps_rec.chr_id,
        USER_ID = l_def_cps_rec.user_id,
        CRT_ID = l_def_cps_rec.crt_id,
        OBJECT_VERSION_NUMBER = l_def_cps_rec.object_version_number,
        CREATED_BY = l_def_cps_rec.created_by,
        CREATION_DATE = l_def_cps_rec.creation_date,
        LAST_UPDATED_BY = l_def_cps_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cps_rec.last_update_date,
        PROCESS_ID = l_def_cps_rec.process_id,
        IN_PROCESS_YN = l_def_cps_rec.in_process_yn,
        LAST_UPDATE_LOGIN = l_def_cps_rec.last_update_login,
        ATTRIBUTE_CATEGORY = l_def_cps_rec.attribute_category,
        ATTRIBUTE1 = l_def_cps_rec.attribute1,
        ATTRIBUTE2 = l_def_cps_rec.attribute2,
        ATTRIBUTE3 = l_def_cps_rec.attribute3,
        ATTRIBUTE4 = l_def_cps_rec.attribute4,
        ATTRIBUTE5 = l_def_cps_rec.attribute5,
        ATTRIBUTE6 = l_def_cps_rec.attribute6,
        ATTRIBUTE7 = l_def_cps_rec.attribute7,
        ATTRIBUTE8 = l_def_cps_rec.attribute8,
        ATTRIBUTE9 = l_def_cps_rec.attribute9,
        ATTRIBUTE10 = l_def_cps_rec.attribute10,
        ATTRIBUTE11 = l_def_cps_rec.attribute11,
        ATTRIBUTE12 = l_def_cps_rec.attribute12,
        ATTRIBUTE13 = l_def_cps_rec.attribute13,
        ATTRIBUTE14 = l_def_cps_rec.attribute14,
        ATTRIBUTE15 = l_def_cps_rec.attribute15
    WHERE ID = l_def_cps_rec.id;

Line: 2019


  END update_row;

Line: 2023


  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_cpsv_rec                     IN cpsv_rec_type,
    x_cpsv_rec                     OUT NOCOPY cpsv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2033


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

Line: 2047


      l_cpsv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2048


      l_cpsv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2049


      l_cpsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2173


      IF (x_cpsv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_cpsv_rec.last_updated_by := l_cpsv_rec.last_updated_by;

Line: 2177


      IF (x_cpsv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cpsv_rec.last_update_date := l_cpsv_rec.last_update_date;

Line: 2181


      IF (x_cpsv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_cpsv_rec.last_update_login := l_cpsv_rec.last_update_login;

Line: 2255


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cps_rec,
      lx_cps_rec
    );

Line: 2302


  END update_row;

Line: 2306


  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_cpsv_tbl                     IN cpsv_tbl_type,
    x_cpsv_tbl                     OUT NOCOPY cpsv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2316


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

Line: 2326


        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_cpsv_rec                     => p_cpsv_tbl(i),
          x_cpsv_rec                     => x_cpsv_tbl(i));

Line: 2379


  END update_row;

Line: 2387


  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_cps_rec                      IN cps_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2395


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

Line: 2409


    DELETE FROM OKC_K_PROCESSES
     WHERE ID = l_cps_rec.id;

Line: 2444


  END delete_row;

Line: 2448


  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_cpsv_rec                     IN cpsv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2457


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

Line: 2481


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

Line: 2525


  END delete_row;

Line: 2529


  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_cpsv_tbl                     IN cpsv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2538


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

Line: 2548


        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_cpsv_rec                     => p_cpsv_tbl(i));

Line: 2600


  END delete_row;

Line: 2605


PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_cpsv_tbl cpsv_tbl_type) IS
  l_tabsize NUMBER := p_cpsv_tbl.COUNT;

Line: 2635


  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;

Line: 2636


  in_last_update_date              OKC_DATATYPES.DateTabTyp;

Line: 2637


  in_last_update_login             OKC_DATATYPES.NumberTabTyp;

Line: 2689


    in_last_updated_by          (j) := p_cpsv_tbl(i).last_updated_by;

Line: 2690


    in_last_update_date         (j) := p_cpsv_tbl(i).last_update_date;

Line: 2691


    in_last_update_login        (j) := p_cpsv_tbl(i).last_update_login;

Line: 2698


    INSERT
      INTO OKC_K_PROCESSES
      (
        id,
        pdf_id,
        chr_id,
        user_id,
        crt_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        process_id,
        in_process_yn,
        last_update_login,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15
     )
     VALUES (
        in_id(i),
        in_pdf_id(i),
        in_chr_id(i),
        in_user_id(i),
        in_crt_id(i),
        in_object_version_number(i),
        in_created_by(i),
        in_creation_date(i),
        in_last_updated_by(i),
        in_last_update_date(i),
        in_process_id(i),
        in_in_process_yn(i),
        in_last_update_login(i),
        in_attribute_category(i),
        in_attribute1(i),
        in_attribute2(i),
        in_attribute3(i),
        in_attribute4(i),
        in_attribute5(i),
        in_attribute6(i),
        in_attribute7(i),
        in_attribute8(i),
        in_attribute9(i),
        in_attribute10(i),
        in_attribute11(i),
        in_attribute12(i),
        in_attribute13(i),
        in_attribute14(i),
        in_attribute15(i)
     );

Line: 2777


END INSERT_ROW_UPG;

Line: 2791


INSERT INTO okc_k_processes_h
  (
      major_version,
      id,
      pdf_id,
      chr_id,
      user_id,
      crt_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      process_id,
      in_process_yn,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
)
  SELECT
      p_major_version,
      id,
      pdf_id,
      chr_id,
      user_id,
      crt_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      process_id,
      in_process_yn,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
  FROM okc_k_processes
 WHERE chr_id = p_chr_id;

Line: 2887


INSERT INTO okc_k_processes
  (
      id,
      pdf_id,
      chr_id,
      user_id,
      crt_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      process_id,
      in_process_yn,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
)
  SELECT
      id,
      pdf_id,
      chr_id,
      user_id,
      crt_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      process_id,
      in_process_yn,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
  FROM okc_k_processes_h
 WHERE chr_id = p_chr_id
  AND major_version = p_major_version;