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

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

Line: 30


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

Line: 90


  		select 'x'
  		from OKC_K_LINES_B
  		where ID = p_gvev_rec.cle_id;

Line: 150


  		select 'x'
  		from OKC_K_HEADERS_B
  		where ID = p_gvev_rec.chr_id_referred;

Line: 210


  		select 'x'
  		from OKC_K_LINES_B
  		where ID = p_gvev_rec.cle_id_referred;

Line: 270


  		select 'x'
  		from OKX_AGREEMENTS_V
  		where AGREEMENT_ID = p_gvev_rec.isa_agreement_id;

Line: 404


    SELECT
            ID,
            DNZ_CHR_ID,
            CHR_ID,
            CLE_ID,
            CHR_ID_REFERRED,
            CLE_ID_REFERRED,
            ISA_AGREEMENT_ID,
            COPIED_ONLY_YN,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Governances
     WHERE okc_governances.id   = p_id;

Line: 439


              l_gve_rec.LAST_UPDATED_BY,
              l_gve_rec.LAST_UPDATE_DATE,
              l_gve_rec.LAST_UPDATE_LOGIN;

Line: 462


    SELECT
            ID,
            DNZ_CHR_ID,
            ISA_AGREEMENT_ID,
            OBJECT_VERSION_NUMBER,
            CHR_ID,
            CLE_ID,
            CHR_ID_REFERRED,
            CLE_ID_REFERRED,
            COPIED_ONLY_YN,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Governances_V
     WHERE okc_governances_v.id = p_id;

Line: 497


              l_gvev_rec.LAST_UPDATED_BY,
              l_gvev_rec.LAST_UPDATE_DATE,
              l_gvev_rec.LAST_UPDATE_LOGIN;

Line: 551


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

Line: 554


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

Line: 557


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

Line: 736


    p_to.last_updated_by := p_from.last_updated_by;

Line: 737


    p_to.last_update_date := p_from.last_update_date;

Line: 738


    p_to.last_update_login := p_from.last_update_login;

Line: 756


    p_to.last_updated_by := p_from.last_updated_by;

Line: 757


    p_to.last_update_date := p_from.last_update_date;

Line: 758


    p_to.last_update_login := p_from.last_update_login;

Line: 922


  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_gve_rec                      IN gve_rec_type,
    x_gve_rec                      OUT NOCOPY gve_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 931


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

Line: 967


    INSERT INTO OKC_GOVERNANCES(
        id,
        dnz_chr_id,
        chr_id,
        cle_id,
        chr_id_referred,
        cle_id_referred,
        isa_agreement_id,
        copied_only_yn,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_gve_rec.id,
        l_gve_rec.dnz_chr_id,
        l_gve_rec.chr_id,
        l_gve_rec.cle_id,
        l_gve_rec.chr_id_referred,
        l_gve_rec.cle_id_referred,
        l_gve_rec.isa_agreement_id,
        l_gve_rec.copied_only_yn,
        l_gve_rec.object_version_number,
        l_gve_rec.created_by,
        l_gve_rec.creation_date,
        l_gve_rec.last_updated_by,
        l_gve_rec.last_update_date,
        l_gve_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 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_gvev_rec                     IN gvev_rec_type,
    x_gvev_rec                     OUT NOCOPY gvev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1045


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

Line: 1061


      l_gvev_rec.LAST_UPDATE_DATE := l_gvev_rec.CREATION_DATE;

Line: 1062


      l_gvev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1063


      l_gvev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1130


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_gve_rec,
      lx_gve_rec
    );

Line: 1178


  END insert_row;

Line: 1182


  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_gvev_tbl                     IN gvev_tbl_type,
    x_gvev_tbl                     OUT NOCOPY gvev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1192


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

Line: 1202


        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_gvev_rec                     => p_gvev_tbl(i),
          x_gvev_rec                     => x_gvev_tbl(i));

Line: 1255


  END insert_row;

Line: 1273


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_GOVERNANCES
     WHERE ID = p_gve_rec.id
       AND OBJECT_VERSION_NUMBER = p_gve_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1280


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_GOVERNANCES
    WHERE ID = p_gve_rec.id;

Line: 1321


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1330


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1528


  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_gve_rec                      IN gve_rec_type,
    x_gve_rec                      OUT NOCOPY gve_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1537


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

Line: 1603


      IF (x_gve_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_gve_rec.last_updated_by := l_gve_rec.last_updated_by;

Line: 1607


      IF (x_gve_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_gve_rec.last_update_date := l_gve_rec.last_update_date;

Line: 1611


      IF (x_gve_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_gve_rec.last_update_login := l_gve_rec.last_update_login;

Line: 1655


    UPDATE  OKC_GOVERNANCES
    SET DNZ_CHR_ID = l_def_gve_rec.dnz_chr_id,
        CHR_ID = l_def_gve_rec.chr_id,
        CLE_ID = l_def_gve_rec.cle_id,
        CHR_ID_REFERRED = l_def_gve_rec.chr_id_referred,
        CLE_ID_REFERRED = l_def_gve_rec.cle_id_referred,
        ISA_AGREEMENT_ID = l_def_gve_rec.isa_agreement_id,
        COPIED_ONLY_YN = l_def_gve_rec.copied_only_yn,
        OBJECT_VERSION_NUMBER = l_def_gve_rec.object_version_number,
        CREATED_BY = l_def_gve_rec.created_by,
        CREATION_DATE = l_def_gve_rec.creation_date,
        LAST_UPDATED_BY = l_def_gve_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_gve_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_gve_rec.last_update_login
    WHERE ID = l_def_gve_rec.id;

Line: 1704


  END update_row;

Line: 1708


  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_gvev_rec                     IN gvev_rec_type,
    x_gvev_rec                     OUT NOCOPY gvev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1718


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

Line: 1732


      l_gvev_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1733


      l_gvev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1734


      l_gvev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1798


      IF (x_gvev_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_gvev_rec.last_updated_by := l_gvev_rec.last_updated_by;

Line: 1802


      IF (x_gvev_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_gvev_rec.last_update_date := l_gvev_rec.last_update_date;

Line: 1806


      IF (x_gvev_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_gvev_rec.last_update_login := l_gvev_rec.last_update_login;

Line: 1880


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_gve_rec,
      lx_gve_rec
    );

Line: 1927


  END update_row;

Line: 1931


  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_gvev_tbl                     IN gvev_tbl_type,
    x_gvev_tbl                     OUT NOCOPY gvev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1941


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

Line: 1951


        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_gvev_rec                     => p_gvev_tbl(i),
          x_gvev_rec                     => x_gvev_tbl(i));

Line: 2004


  END update_row;

Line: 2012


  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_gve_rec                      IN gve_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2020


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

Line: 2034


    DELETE FROM OKC_GOVERNANCES
     WHERE ID = l_gve_rec.id;

Line: 2069


  END delete_row;

Line: 2073


  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_gvev_rec                     IN gvev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2082


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

Line: 2106


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

Line: 2150


  END delete_row;

Line: 2154


  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_gvev_tbl                     IN gvev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2163


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

Line: 2173


        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_gvev_rec                     => p_gvev_tbl(i));

Line: 2225


  END delete_row;

Line: 2230


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

Line: 2245


  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;

Line: 2246


  in_last_update_date              OKC_DATATYPES.DateTabTyp;

Line: 2247


  in_last_update_login             OKC_DATATYPES.NumberTabTyp;

Line: 2285


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

Line: 2286


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

Line: 2287


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

Line: 2293


    INSERT
      INTO OKC_GOVERNANCES
      (
        id,
        dnz_chr_id,
        chr_id,
        cle_id,
        chr_id_referred,
        cle_id_referred,
        isa_agreement_id,
        copied_only_yn,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login
     )
     VALUES (
        in_id(i),
        in_dnz_chr_id(i),
        in_chr_id(i),
        in_cle_id(i),
        in_chr_id_referred(i),
        in_cle_id_referred(i),
        in_isa_agreement_id(i),
        in_copied_only_yn(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_last_update_login(i)
     );

Line: 2342


END INSERT_ROW_UPG;

Line: 2356


INSERT INTO okc_governances_h
  (
      major_version,
      id,
      dnz_chr_id,
      chr_id,
      cle_id,
      chr_id_referred,
      cle_id_referred,
      isa_agreement_id,
      copied_only_yn,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
)
  SELECT
      p_major_version,
      id,
      dnz_chr_id,
      chr_id,
      cle_id,
      chr_id_referred,
      cle_id_referred,
      isa_agreement_id,
      copied_only_yn,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
  FROM okc_governances
WHERE dnz_chr_id = p_chr_id;

Line: 2422


INSERT INTO okc_governances
  (
      id,
      dnz_chr_id,
      chr_id,
      cle_id,
      chr_id_referred,
      cle_id_referred,
      isa_agreement_id,
      copied_only_yn,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
)
  SELECT
      id,
      dnz_chr_id,
      chr_id,
      cle_id,
      chr_id_referred,
      cle_id_referred,
      isa_agreement_id,
      copied_only_yn,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
  FROM okc_governances_h
WHERE dnz_chr_id = p_chr_id
  AND major_version = p_major_version;