DBA Data[Home] [Help]

APPS.OKC_LSR_PVT SQL Statements

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

Line: 46

    SELECT
            LSE_ID,
            SRE_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            ACCESS_LEVEL
      FROM Okc_Line_Style_Roles
     WHERE okc_line_style_roles.lse_id = p_lse_id
       AND okc_line_style_roles.sre_id = p_sre_id;
Line: 72

              l_lsr_rec.LAST_UPDATED_BY,
              l_lsr_rec.LAST_UPDATE_DATE,
              l_lsr_rec.LAST_UPDATE_LOGIN,
              l_lsr_rec.ACCESS_LEVEL;
Line: 97

    SELECT
            LSE_ID,
            SRE_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            ACCESS_LEVEL
      FROM Okc_Line_Style_Roles_V
     WHERE okc_line_style_roles_v.lse_id = p_lse_id
       AND okc_line_style_roles_v.sre_id = p_sre_id;
Line: 123

              l_lsrv_rec.LAST_UPDATED_BY,
              l_lsrv_rec.LAST_UPDATE_DATE,
              l_lsrv_rec.LAST_UPDATE_LOGIN,
              l_lsrv_rec.ACCESS_LEVEL;
Line: 163

    IF (l_lsrv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_lsrv_rec.last_updated_by := NULL;
Line: 166

    IF (l_lsrv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_lsrv_rec.last_update_date := NULL;
Line: 169

    IF (l_lsrv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_lsrv_rec.last_update_login := NULL;
Line: 375

      SELECT 'x'
        FROM Okc_Line_Styles_V
       WHERE okc_line_styles_v.id = p_id;
Line: 379

      SELECT 'x'
        FROM Okc_Subclass_Roles_V
       WHERE okc_subclass_roles_v.id = p_id;
Line: 432

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

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

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

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

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

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

  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_lsr_rec                      IN lsr_rec_type,
    x_lsr_rec                      OUT NOCOPY lsr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 612

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

    INSERT INTO OKC_LINE_STYLE_ROLES(
        lse_id,
        sre_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        access_level)
      VALUES (
        l_lsr_rec.lse_id,
        l_lsr_rec.sre_id,
        l_lsr_rec.object_version_number,
        l_lsr_rec.created_by,
        l_lsr_rec.creation_date,
        l_lsr_rec.last_updated_by,
        l_lsr_rec.last_update_date,
        l_lsr_rec.last_update_login,
        l_lsr_rec.access_level);
Line: 702

  END insert_row;
Line: 706

  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_lsrv_rec                     IN lsrv_rec_type,
    x_lsrv_rec                     OUT NOCOPY lsrv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 716

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

      l_lsrv_rec.LAST_UPDATE_DATE := l_lsrv_rec.CREATION_DATE;
Line: 733

      l_lsrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 734

      l_lsrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 759

      SELECT 'x'
        FROM Okc_Line_Style_Roles_V
       WHERE sre_id = p_sre_id
         AND lse_id = p_lse_id;
Line: 838

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_lsr_rec,
      lx_lsr_rec
    );
Line: 886

  END insert_row;
Line: 890

  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_lsrv_tbl                     IN lsrv_tbl_type,
    x_lsrv_tbl                     OUT NOCOPY lsrv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 900

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

        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_lsrv_rec                     => p_lsrv_tbl(i),
          x_lsrv_rec                     => x_lsrv_tbl(i));
Line: 952

  END insert_row;
Line: 970

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_LINE_STYLE_ROLES
     WHERE LSE_ID = p_lsr_rec.lse_id
       AND SRE_ID = p_lsr_rec.sre_id
       AND OBJECT_VERSION_NUMBER = p_lsr_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 978

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_LINE_STYLE_ROLES
    WHERE LSE_ID = p_lsr_rec.lse_id
       AND SRE_ID = p_lsr_rec.sre_id;
Line: 1020

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

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

  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_lsr_rec                      IN lsr_rec_type,
    x_lsr_rec                      OUT NOCOPY lsr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1225

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

      IF (x_lsr_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_lsr_rec.last_updated_by := l_lsr_rec.last_updated_by;
Line: 1271

      IF (x_lsr_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_lsr_rec.last_update_date := l_lsr_rec.last_update_date;
Line: 1275

      IF (x_lsr_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_lsr_rec.last_update_login := l_lsr_rec.last_update_login;
Line: 1323

    UPDATE  OKC_LINE_STYLE_ROLES
    SET OBJECT_VERSION_NUMBER = l_def_lsr_rec.object_version_number,
        CREATED_BY = l_def_lsr_rec.created_by,
        CREATION_DATE = l_def_lsr_rec.creation_date,
        LAST_UPDATED_BY = l_def_lsr_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_lsr_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_lsr_rec.last_update_login,
        ACCESS_LEVEL = l_def_lsr_rec.access_level
    WHERE LSE_ID = l_def_lsr_rec.lse_id
      AND SRE_ID = l_def_lsr_rec.sre_id;
Line: 1367

  END update_row;
Line: 1371

  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_lsrv_rec                     IN lsrv_rec_type,
    x_lsrv_rec                     OUT NOCOPY lsrv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1381

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

      l_lsrv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1396

      l_lsrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1397

      l_lsrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1437

      IF (x_lsrv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_lsrv_rec.last_updated_by := l_lsrv_rec.last_updated_by;
Line: 1441

      IF (x_lsrv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_lsrv_rec.last_update_date := l_lsrv_rec.last_update_date;
Line: 1445

      IF (x_lsrv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_lsrv_rec.last_update_login := l_lsrv_rec.last_update_login;
Line: 1520

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_lsr_rec,
      lx_lsr_rec
    );
Line: 1567

  END update_row;
Line: 1571

  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_lsrv_tbl                     IN lsrv_tbl_type,
    x_lsrv_tbl                     OUT NOCOPY lsrv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1581

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

        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_lsrv_rec                     => p_lsrv_tbl(i),
          x_lsrv_rec                     => x_lsrv_tbl(i));
Line: 1633

  END update_row;
Line: 1641

  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_lsr_rec                      IN lsr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1649

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

    DELETE FROM OKC_LINE_STYLE_ROLES
     WHERE LSE_ID = l_lsr_rec.lse_id AND
SRE_ID = l_lsr_rec.sre_id;
Line: 1699

  END delete_row;
Line: 1703

  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_lsrv_rec                     IN lsrv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1712

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_lsr_rec
    );
Line: 1780

  END delete_row;
Line: 1784

  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_lsrv_tbl                     IN lsrv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1793

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

        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_lsrv_rec                     => p_lsrv_tbl(i));
Line: 1844

  END delete_row;