DBA Data[Home] [Help]

APPS.OKC_CAC_PVT SQL Statements

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

Line: 29

  		select 'x'
  		from JTF_RS_GROUPS_B
  		where GROUP_ID = p_cacv_rec.group_id;
Line: 105

  		select 'x'
  		from OKC_K_HEADERS_B
  		where ID = p_cacv_rec.chr_id;
Line: 198

  		select 'x'
  		from JTF_RS_RESOURCE_EXTNS
  		where RESOURCE_ID = p_cacv_rec.resource_id;
Line: 392

    SELECT
            ID,
            CHR_ID,
            GROUP_ID,
            RESOURCE_ID,
            ACCESS_LEVEL,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_K_Accesses
     WHERE okc_k_accesses.id    = p_id;
Line: 427

              l_cac_rec.LAST_UPDATED_BY,
              l_cac_rec.LAST_UPDATE_DATE,
              l_cac_rec.LAST_UPDATE_LOGIN;
Line: 459

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            GROUP_ID,
            CHR_ID,
            RESOURCE_ID,
            ACCESS_LEVEL,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_K_Accesses_V
     WHERE okc_k_accesses_v.id  = p_id;
Line: 494

              l_cacv_rec.LAST_UPDATED_BY,
              l_cacv_rec.LAST_UPDATE_DATE,
              l_cacv_rec.LAST_UPDATE_LOGIN;
Line: 554

    IF (l_cacv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_cacv_rec.last_updated_by := NULL;
Line: 557

    IF (l_cacv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_cacv_rec.last_update_date := NULL;
Line: 560

    IF (l_cacv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_cacv_rec.last_update_login := NULL;
Line: 688

	  SELECT 'x'
	  FROM   okc_k_accesses
	  WHERE  chr_id       = p_cacv_rec.CHR_ID
       AND    resource_id  = p_cacv_rec.RESOURCE_ID
       AND    group_id    IS NULL
	  AND    id          <> NVL(p_cacv_rec.ID,-9999);
Line: 696

	  SELECT 'x'
	  FROM   okc_k_accesses
	  WHERE  chr_id       = p_cacv_rec.CHR_ID
       AND    resource_id IS NULL
       AND    group_id     = p_cacv_rec.GROUP_ID
	  AND    id          <> NVL(p_cacv_rec.ID,-9999);
Line: 709

 SELECT name
 FROM OKC_RESOURCE_GROUPS_V
 WHERE group_id = p_cacv_rec.GROUP_ID;
Line: 714

SELECT name
FROM OKC_RESOURCE_USERS_V
WHERE ID  = p_cacv_rec.RESOURCE_ID;
Line: 835

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

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

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

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

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

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

  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_cac_rec                      IN cac_rec_type,
    x_cac_rec                      OUT NOCOPY cac_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1092

    l_api_name                     CONSTANT VARCHAR2(30) := 'ACCESSES_insert_row';
Line: 1114

       okc_debug.log('3800: Entered insert_row', 2);
Line: 1136

    INSERT INTO OKC_K_ACCESSES(
        id,
        chr_id,
        group_id,
        resource_id,
        access_level,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_cac_rec.id,
        l_cac_rec.chr_id,
        l_cac_rec.group_id,
        l_cac_rec.resource_id,
        l_cac_rec.access_level,
        l_cac_rec.object_version_number,
        l_cac_rec.created_by,
        l_cac_rec.creation_date,
        l_cac_rec.last_updated_by,
        l_cac_rec.last_update_date,
        l_cac_rec.last_update_login);
Line: 1165

       okc_debug.log('3900: Exiting insert_row', 2);
Line: 1173

       okc_debug.log('4000: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 1189

       okc_debug.log('4100: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 1205

       okc_debug.log('4200: Exiting insert_row:OTHERS Exception', 2);
Line: 1219

  END insert_row;
Line: 1223

  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_cacv_rec                     IN cacv_rec_type,
    x_cacv_rec                     OUT NOCOPY cacv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1233

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

      l_cacv_rec.LAST_UPDATE_DATE := l_cacv_rec.CREATION_DATE;
Line: 1256

      l_cacv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1257

      l_cacv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1300

       okc_debug.log('4800: Entered insert_row', 2);
Line: 1350

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cac_rec,
      lx_cac_rec
    );
Line: 1369

   okc_debug.log('4850: Leaving insert_row', 2);
Line: 1377

       okc_debug.log('4900: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 1393

       okc_debug.log('5000: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 1409

       okc_debug.log('5100: Exiting insert_row:OTHERS Exception', 2);
Line: 1423

  END insert_row;
Line: 1427

  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_cacv_tbl                     IN cacv_tbl_type,
    x_cacv_tbl                     OUT NOCOPY cacv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1437

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

       okc_debug.log('5300: Entered insert_row', 2);
Line: 1453

        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_cacv_rec                     => p_cacv_tbl(i),
          x_cacv_rec                     => x_cacv_tbl(i));
Line: 1477

     okc_debug.log('5350: Leaving insert_row', 2);
Line: 1485

       okc_debug.log('5400: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 1501

       okc_debug.log('5500: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 1517

       okc_debug.log('5600: Exiting insert_row:OTHERS Exception', 2);
Line: 1531

  END insert_row;
Line: 1549

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_K_ACCESSES
     WHERE ID = p_cac_rec.id
       AND OBJECT_VERSION_NUMBER = p_cac_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1556

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_K_ACCESSES
    WHERE ID = p_cac_rec.id;
Line: 1621

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

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

  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_cac_rec                      IN cac_rec_type,
    x_cac_rec                      OUT NOCOPY cac_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1924

    l_api_name                     CONSTANT VARCHAR2(30) := 'ACCESSES_update_row';
Line: 1984

      IF (x_cac_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_cac_rec.last_updated_by := l_cac_rec.last_updated_by;
Line: 1988

      IF (x_cac_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cac_rec.last_update_date := l_cac_rec.last_update_date;
Line: 1992

      IF (x_cac_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_cac_rec.last_update_login := l_cac_rec.last_update_login;
Line: 2022

       okc_debug.log('7700: Entered update_row', 2);
Line: 2050

    UPDATE  OKC_K_ACCESSES
    SET CHR_ID = l_def_cac_rec.chr_id,
        GROUP_ID = l_def_cac_rec.group_id,
        RESOURCE_ID = l_def_cac_rec.resource_id,
        ACCESS_LEVEL = l_def_cac_rec.access_level,
        OBJECT_VERSION_NUMBER = l_def_cac_rec.object_version_number,
        CREATED_BY = l_def_cac_rec.created_by,
        CREATION_DATE = l_def_cac_rec.creation_date,
        LAST_UPDATED_BY = l_def_cac_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cac_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_cac_rec.last_update_login
    WHERE ID = l_def_cac_rec.id;
Line: 2067

   okc_debug.log('7750: Leaving update_row', 2);
Line: 2075

       okc_debug.log('7800: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 2091

       okc_debug.log('7900: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 2107

       okc_debug.log('8000: Exiting update_row:OTHERS Exception', 2);
Line: 2121

  END update_row;
Line: 2125

  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_cacv_rec                     IN cacv_rec_type,
    x_cacv_rec                     OUT NOCOPY cacv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2135

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

      l_cacv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2151

      l_cacv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2152

      l_cacv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2211

      IF (x_cacv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_cacv_rec.last_updated_by := l_cacv_rec.last_updated_by;
Line: 2215

      IF (x_cacv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cacv_rec.last_update_date := l_cacv_rec.last_update_date;
Line: 2219

      IF (x_cacv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_cacv_rec.last_update_login := l_cacv_rec.last_update_login;
Line: 2254

       okc_debug.log('8400: Entered update_row', 2);
Line: 2308

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cac_rec,
      lx_cac_rec
    );
Line: 2326

       okc_debug.log('8450: Leaving update_row', 2);
Line: 2334

       okc_debug.log('8500: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 2350

       okc_debug.log('8600: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 2366

       okc_debug.log('8700: Exiting update_row:OTHERS Exception', 2);
Line: 2380

  END update_row;
Line: 2384

  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_cacv_tbl                     IN cacv_tbl_type,
    x_cacv_tbl                     OUT NOCOPY cacv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2394

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

       okc_debug.log('8900: Entered update_row', 2);
Line: 2410

        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_cacv_rec                     => p_cacv_tbl(i),
          x_cacv_rec                     => x_cacv_tbl(i));
Line: 2434

       okc_debug.log('8950: Leaving update_row', 2);
Line: 2442

       okc_debug.log('9000: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 2458

       okc_debug.log('9100: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 2474

       okc_debug.log('9200: Exiting update_row:OTHERS Exception', 2);
Line: 2488

  END update_row;
Line: 2496

  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_cac_rec                      IN cac_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2504

    l_api_name                     CONSTANT VARCHAR2(30) := 'ACCESSES_delete_row';
Line: 2512

       okc_debug.log('9400: Entered delete_row', 2);
Line: 2524

    DELETE FROM OKC_K_ACCESSES
     WHERE ID = l_cac_rec.id;
Line: 2530

    okc_debug.log('9450: Leaving delete_row', 2);
Line: 2538

       okc_debug.log('9500: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 2554

       okc_debug.log('9600: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 2570

       okc_debug.log('9700: Exiting delete_row:OTHERS Exception', 2);
Line: 2584

  END delete_row;
Line: 2588

  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_cacv_rec                     IN cacv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2597

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

       okc_debug.log('9900: Entered delete_row', 2);
Line: 2627

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cac_rec
    );
Line: 2642

       okc_debug.log('9950: Leaving delete_row', 2);
Line: 2650

       okc_debug.log('10000: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 2666

       okc_debug.log('10100: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 2682

       okc_debug.log('10200: Exiting delete_row:OTHERS Exception', 2);
Line: 2696

  END delete_row;
Line: 2700

  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_cacv_tbl                     IN cacv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2709

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

       okc_debug.log('10400: Entered delete_row', 2);
Line: 2725

        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_cacv_rec                     => p_cacv_tbl(i));
Line: 2748

   okc_debug.log('10450: Leaving delete_row', 2);
Line: 2756

       okc_debug.log('10500: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 2772

       okc_debug.log('10600: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 2788

       okc_debug.log('10700: Exiting delete_row:OTHERS Exception', 2);
Line: 2802

  END delete_row;
Line: 2822

INSERT INTO okc_k_accesses_h
  (
      major_version,
      id,
      chr_id,
      group_id,
      resource_id,
      access_level,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
)
  SELECT
      p_major_version,
      id,
      chr_id,
      group_id,
      resource_id,
      access_level,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
  FROM okc_k_accesses
WHERE chr_id = p_chr_id;
Line: 2901

INSERT INTO okc_k_accesses
(
      id,
      chr_id,
      group_id,
      resource_id,
      access_level,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
)
  SELECT
      id,
      chr_id,
      group_id,
      resource_id,
      access_level,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
  FROM okc_k_accesses_h
WHERE chr_id = p_chr_id
  AND major_version = p_major_version;