DBA Data[Home] [Help]

APPS.OKC_CPR_PVT SQL Statements

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

Line: 53

    SELECT
            CRT_ID,
            CPL_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            ACCEPTANCE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Change_Party_Role
     WHERE okc_change_party_role.crt_id = p_crt_id
       AND okc_change_party_role.cpl_id = p_cpl_id;
Line: 79

              l_cpr_rec.LAST_UPDATED_BY,
              l_cpr_rec.LAST_UPDATE_DATE,
              l_cpr_rec.ACCEPTANCE_DATE,
              l_cpr_rec.LAST_UPDATE_LOGIN;
Line: 104

    SELECT
            CRT_ID,
            CPL_ID,
            OBJECT_VERSION_NUMBER,
            ACCEPTANCE_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Change_Party_Role_V
     WHERE okc_change_party_role_v.crt_id = p_crt_id
       AND okc_change_party_role_v.cpl_id = p_cpl_id;
Line: 131

              l_cprv_rec.LAST_UPDATED_BY,
              l_cprv_rec.LAST_UPDATE_DATE,
              l_cprv_rec.LAST_UPDATE_LOGIN;
Line: 173

    IF (l_cprv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_cprv_rec.last_updated_by := NULL;
Line: 176

    IF (l_cprv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_cprv_rec.last_update_date := NULL;
Line: 179

    IF (l_cprv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_cprv_rec.last_update_login := NULL;
Line: 202

  select 'x'
  from OKC_K_PARTY_ROLES_B
  where id = p_cprv_rec.cpl_id;
Line: 253

  select 'x'
  from OKC_CHANGE_REQUESTS_B
  where id = p_cprv_rec.crt_id;
Line: 366

    ,p_mode IN varchar2 DEFAULT 'UPDATE'  -- or 'INSERT'
--+++++++++++++++End   handcode +++++++++++++++++++++++++++++++++++
  ) RETURN VARCHAR2 IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 379

      SELECT
              ID,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              CHR_ID,
              CRS_CODE,
              USER_ID,
              NAME,
              DATETIME_REQUEST,
              SHORT_DESCRIPTION,
              EXTENDED_YN,
              AUTHORITY,
              SIGNATURE_REQUIRED_YN,
              DATETIME_APPROVED,
              DATETIME_REJECTED,
              DATETIME_EFFECTIVE,
              DATETIME_INEFFECTIVE,
              VERSION_CONTRACT,
              APPLIED_CONTRACT_VERSION,
              ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15,
              CRT_TYPE,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATE_LOGIN
        FROM Okc_Change_Requests_V
       WHERE okc_change_requests_v.id = p_id;
Line: 451

    select '!' from okc_change_party_role
    where cpl_id = p_cprv_rec.cpl_id
      and crt_id = p_cprv_rec.crt_id;
Line: 456

    if (p_mode = 'INSERT') then
--
      if (p_cprv_rec.cpl_id = OKC_API.G_MISS_NUM
		and p_cprv_rec.crt_id = OKC_API.G_MISS_NUM )
	then
   		return x_return_status;
Line: 475

    else  -- other mode than INSERT
      return x_return_status;
Line: 505

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

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

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

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

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

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

  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_cpr_rec                      IN cpr_rec_type,
    x_cpr_rec                      OUT NOCOPY cpr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 685

    l_api_name                     CONSTANT VARCHAR2(30) := 'ROLE_insert_row';
Line: 721

    INSERT INTO OKC_CHANGE_PARTY_ROLE(
        crt_id,
        cpl_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        acceptance_date,
        last_update_login)
      VALUES (
        l_cpr_rec.crt_id,
        l_cpr_rec.cpl_id,
        l_cpr_rec.object_version_number,
        l_cpr_rec.created_by,
        l_cpr_rec.creation_date,
        l_cpr_rec.last_updated_by,
        l_cpr_rec.last_update_date,
        l_cpr_rec.acceptance_date,
        l_cpr_rec.last_update_login);
Line: 775

  END insert_row;
Line: 779

  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_cprv_rec                     IN cprv_rec_type,
    x_cprv_rec                     OUT NOCOPY cprv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 789

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

      l_cprv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 806

      l_cprv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 807

      l_cprv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 860

    l_return_status := Validate_Record(l_def_cprv_rec,'INSERT');
Line: 874

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cpr_rec,
      lx_cpr_rec
    );
Line: 922

  END insert_row;
Line: 926

  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_cprv_tbl                     IN cprv_tbl_type,
    x_cprv_tbl                     OUT NOCOPY cprv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 936

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

        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_cprv_rec                     => p_cprv_tbl(i),
          x_cprv_rec                     => x_cprv_tbl(i));
Line: 988

  END insert_row;
Line: 1006

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_CHANGE_PARTY_ROLE
     WHERE CRT_ID = p_cpr_rec.crt_id
       AND CPL_ID = p_cpr_rec.cpl_id
       AND OBJECT_VERSION_NUMBER = p_cpr_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1014

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_CHANGE_PARTY_ROLE
    WHERE CRT_ID = p_cpr_rec.crt_id
       AND CPL_ID = p_cpr_rec.cpl_id;
Line: 1056

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

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

  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_cpr_rec                      IN cpr_rec_type,
    x_cpr_rec                      OUT NOCOPY cpr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1261

    l_api_name                     CONSTANT VARCHAR2(30) := 'ROLE_update_row';
Line: 1303

      IF (x_cpr_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_cpr_rec.last_updated_by := l_cpr_rec.last_updated_by;
Line: 1307

      IF (x_cpr_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cpr_rec.last_update_date := l_cpr_rec.last_update_date;
Line: 1315

      IF (x_cpr_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_cpr_rec.last_update_login := l_cpr_rec.last_update_login;
Line: 1359

    UPDATE  OKC_CHANGE_PARTY_ROLE
    SET OBJECT_VERSION_NUMBER = l_def_cpr_rec.object_version_number,
        CREATED_BY = l_def_cpr_rec.created_by,
        CREATION_DATE = l_def_cpr_rec.creation_date,
        LAST_UPDATED_BY = l_def_cpr_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cpr_rec.last_update_date,
        ACCEPTANCE_DATE = l_def_cpr_rec.acceptance_date,
        LAST_UPDATE_LOGIN = l_def_cpr_rec.last_update_login
    WHERE CRT_ID = l_def_cpr_rec.crt_id
      AND CPL_ID = l_def_cpr_rec.cpl_id;
Line: 1403

  END update_row;
Line: 1407

  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_cprv_rec                     IN cprv_rec_type,
    x_cprv_rec                     OUT NOCOPY cprv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1417

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

      l_cprv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1432

      l_cprv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1433

      l_cprv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1477

      IF (x_cprv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_cprv_rec.last_updated_by := l_cprv_rec.last_updated_by;
Line: 1481

      IF (x_cprv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cprv_rec.last_update_date := l_cprv_rec.last_update_date;
Line: 1485

      IF (x_cprv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_cprv_rec.last_update_login := l_cprv_rec.last_update_login;
Line: 1556

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cpr_rec,
      lx_cpr_rec
    );
Line: 1603

  END update_row;
Line: 1607

  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_cprv_tbl                     IN cprv_tbl_type,
    x_cprv_tbl                     OUT NOCOPY cprv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1617

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

        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_cprv_rec                     => p_cprv_tbl(i),
          x_cprv_rec                     => x_cprv_tbl(i));
Line: 1669

  END update_row;
Line: 1677

  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_cpr_rec                      IN cpr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1685

    l_api_name                     CONSTANT VARCHAR2(30) := 'ROLE_delete_row';
Line: 1699

    DELETE FROM OKC_CHANGE_PARTY_ROLE
     WHERE CRT_ID = l_cpr_rec.crt_id AND
CPL_ID = l_cpr_rec.cpl_id;
Line: 1735

  END delete_row;
Line: 1739

  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_cprv_rec                     IN cprv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1748

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cpr_rec
    );
Line: 1816

  END delete_row;
Line: 1820

  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_cprv_tbl                     IN cprv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1829

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

        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_cprv_rec                     => p_cprv_tbl(i));
Line: 1880

  END delete_row;