DBA Data[Home] [Help]

APPS.OKC_RMP_PVT SQL Statements

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

Line: 32

/*      SELECT 'x'
        FROM OKC_RULE_GROUPS_V rgpv
       WHERE rgpv.ID = p_rmpv_rec.RGP_ID;
Line: 36

    select 'x'
    from 	okc_rule_groups_b RGP
    where RGP.id = p_rmpv_rec.rgp_id
      and RGP.rgd_code in (
	select SRD.rgd_code
	from okc_rg_role_defs RRD
	, okc_subclass_rg_defs SRD
	, okc_k_headers_b KHD
	where RRD.id = p_rmpv_rec.rrd_id
    	and SRD.id = RRD.srd_id
	and KHD.id = p_rmpv_rec.dnz_chr_id
	and SRD.SCS_CODE = KHD.SCS_CODE)
;
Line: 125

      SELECT 'x'
        FROM OKC_RG_ROLE_DEFS rrdv
       WHERE rrdv.SRE_ID IN
             (SELECT srev.ID
                FROM OKC_SUBCLASS_ROLES srev,
                     OKC_SUBCLASSES_B scsv,
                     OKC_K_HEADERS_B chrv
               WHERE srev.SCS_CODE = scsv.CODE
                 AND scsv.CODE     = chrv.SCS_CODE
                 AND chrv.ID       = p_rmpv_rec.dnz_chr_id)
         AND rrdv.ID   = p_rmpv_rec.RRD_ID;
Line: 213

/*      SELECT 'x'
        FROM OKC_K_PARTY_ROLES_V cplv
       WHERE cplv.RLE_CODE IN
             (SELECT srev.RLE_CODE
                FROM OKC_SUBCLASS_ROLES_B srev,
                     OKC_SUBCLASSES_B scsv,
                     OKC_K_HEADERS_B chrv
               WHERE srev.SCS_CODE = scsv.CODE
                 AND scsv.CODE     = chrv.SCS_CODE
                 AND chrv.ID       = p_rmpv_rec.dnz_chr_id)
         AND cplv.ID = p_rmpv_rec.CPL_ID;
Line: 225

    select 'x'
    from 	okc_k_party_roles_b CPL
    where CPL.id = p_rmpv_rec.cpl_id
    and CPL.rle_code in (
      select SRE.rle_code
      from okc_rg_role_defs RRD
	, okc_subclass_roles SRE
	, okc_k_headers_b KHD
      where RRD.id = p_rmpv_rec.rrd_id
        and SRE.id = RRD.sre_id
	and KHD.id = p_rmpv_rec.dnz_chr_id
	and SRE.SCS_CODE = KHD.SCS_CODE)
;
Line: 305

      SELECT 'x'
        FROM OKC_K_HEADERS_B chrv
       WHERE chrv.ID = p_rmpv_rec.DNZ_CHR_ID;
Line: 495

    SELECT
            ID,
            RGP_ID,
            RRD_ID,
            CPL_ID,
            DNZ_CHR_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Rg_Party_Roles
     WHERE okc_rg_party_roles.id = p_id;
Line: 524

              l_rpr_rec.LAST_UPDATED_BY,
              l_rpr_rec.LAST_UPDATE_DATE,
              l_rpr_rec.LAST_UPDATE_LOGIN;
Line: 547

    SELECT
            ID,
            RGP_ID,
            RRD_ID,
            CPL_ID,
            DNZ_CHR_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Rg_Party_Roles
     WHERE okc_rg_party_roles.id = p_id;
Line: 576

              l_rmpv_rec.LAST_UPDATED_BY,
              l_rmpv_rec.LAST_UPDATE_DATE,
              l_rmpv_rec.LAST_UPDATE_LOGIN;
Line: 621

    IF (l_rmpv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_rmpv_rec.last_updated_by := NULL;
Line: 624

    IF (l_rmpv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_rmpv_rec.last_update_date := NULL;
Line: 627

    IF (l_rmpv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_rmpv_rec.last_update_login := NULL;
Line: 703

    p_to.last_updated_by := p_from.last_updated_by;
Line: 704

    p_to.last_update_date := p_from.last_update_date;
Line: 705

    p_to.last_update_login := p_from.last_update_login;
Line: 720

    p_to.last_updated_by := p_from.last_updated_by;
Line: 721

    p_to.last_update_date := p_from.last_update_date;
Line: 722

    p_to.last_update_login := p_from.last_update_login;
Line: 875

  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_rpr_rec                      IN rpr_rec_type,
    x_rpr_rec                      OUT NOCOPY rpr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 884

    l_api_name                     CONSTANT VARCHAR2(30) := 'ROLES_insert_row';
Line: 920

    INSERT INTO OKC_RG_PARTY_ROLES(
        id,
        rgp_id,
        rrd_id,
        cpl_id,
        dnz_chr_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_rpr_rec.id,
        l_rpr_rec.rgp_id,
        l_rpr_rec.rrd_id,
        l_rpr_rec.cpl_id,
        l_rpr_rec.dnz_chr_id,
        l_rpr_rec.object_version_number,
        l_rpr_rec.created_by,
        l_rpr_rec.creation_date,
        l_rpr_rec.last_updated_by,
        l_rpr_rec.last_update_date,
        l_rpr_rec.last_update_login);
Line: 978

  END insert_row;
Line: 982

  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_rmpv_rec                     IN rmpv_rec_type,
    x_rmpv_rec                     OUT NOCOPY rmpv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 992

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

      l_rmpv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1009

      l_rmpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1010

      l_rmpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1074

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_rpr_rec,
      lx_rpr_rec
    );
Line: 1122

  END insert_row;
Line: 1126

  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_rmpv_tbl                     IN rmpv_tbl_type,
    x_rmpv_tbl                     OUT NOCOPY rmpv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1136

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

        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_rmpv_rec                     => p_rmpv_tbl(i),
          x_rmpv_rec                     => x_rmpv_tbl(i));
Line: 1188

  END insert_row;
Line: 1206

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_RG_PARTY_ROLES
     WHERE ID = p_rpr_rec.id
       AND OBJECT_VERSION_NUMBER = p_rpr_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1213

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_RG_PARTY_ROLES
    WHERE ID = p_rpr_rec.id;
Line: 1254

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1263

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 1450

  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_rpr_rec                      IN rpr_rec_type,
    x_rpr_rec                      OUT NOCOPY rpr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1459

    l_api_name                     CONSTANT VARCHAR2(30) := 'ROLES_update_row';
Line: 1513

      IF (x_rpr_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_rpr_rec.last_updated_by := l_rpr_rec.last_updated_by;
Line: 1517

      IF (x_rpr_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_rpr_rec.last_update_date := l_rpr_rec.last_update_date;
Line: 1521

      IF (x_rpr_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_rpr_rec.last_update_login := l_rpr_rec.last_update_login;
Line: 1565

    UPDATE  OKC_RG_PARTY_ROLES
    SET RGP_ID = l_def_rpr_rec.rgp_id,
        RRD_ID = l_def_rpr_rec.rrd_id,
        CPL_ID = l_def_rpr_rec.cpl_id,
        DNZ_CHR_ID = l_def_rpr_rec.dnz_chr_id,
        OBJECT_VERSION_NUMBER = l_def_rpr_rec.object_version_number,
        CREATED_BY = l_def_rpr_rec.created_by,
        CREATION_DATE = l_def_rpr_rec.creation_date,
        LAST_UPDATED_BY = l_def_rpr_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_rpr_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_rpr_rec.last_update_login
    WHERE ID = l_def_rpr_rec.id;
Line: 1611

  END update_row;
Line: 1615

  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_rmpv_rec                     IN rmpv_rec_type,
    x_rmpv_rec                     OUT NOCOPY rmpv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1625

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

      l_rmpv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1640

      l_rmpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1641

      l_rmpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1693

      IF (x_rmpv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_rmpv_rec.last_updated_by := l_rmpv_rec.last_updated_by;
Line: 1697

      IF (x_rmpv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_rmpv_rec.last_update_date := l_rmpv_rec.last_update_date;
Line: 1701

      IF (x_rmpv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_rmpv_rec.last_update_login := l_rmpv_rec.last_update_login;
Line: 1772

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_rpr_rec,
      lx_rpr_rec
    );
Line: 1819

  END update_row;
Line: 1823

  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_rmpv_tbl                     IN rmpv_tbl_type,
    x_rmpv_tbl                     OUT NOCOPY rmpv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1833

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

        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_rmpv_rec                     => p_rmpv_tbl(i),
          x_rmpv_rec                     => x_rmpv_tbl(i));
Line: 1885

  END update_row;
Line: 1893

  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_rpr_rec                      IN rpr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1901

    l_api_name                     CONSTANT VARCHAR2(30) := 'ROLES_delete_row';
Line: 1915

    DELETE FROM OKC_RG_PARTY_ROLES
     WHERE ID = l_rpr_rec.id;
Line: 1950

  END delete_row;
Line: 1954

  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_rmpv_rec                     IN rmpv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1963

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_rpr_rec
    );
Line: 2031

  END delete_row;
Line: 2035

  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_rmpv_tbl                     IN rmpv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2044

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

        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_rmpv_rec                     => p_rmpv_tbl(i));
Line: 2095

  END delete_row;
Line: 2109

INSERT INTO okc_rg_party_roles_h
  (
      major_version,
      id,
      rgp_id,
      rrd_id,
      cpl_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
)
  SELECT
      p_major_version,
      id,
      rgp_id,
      rrd_id,
      cpl_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
  FROM okc_rg_party_roles
 WHERE dnz_chr_id = p_chr_id;
Line: 2169

INSERT INTO okc_rg_party_roles
  (
      id,
      rgp_id,
      rrd_id,
      cpl_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
)
  SELECT
      id,
      rgp_id,
      rrd_id,
      cpl_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
  FROM okc_rg_party_roles_h
WHERE dnz_chr_id = p_chr_id
  AND major_version = p_major_version;