DBA Data[Home] [Help]

APPS.OKC_AAL_PVT SQL Statements

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

Line: 45

    SELECT
            ID,
            OBJECT_NAME,
            COLUMN_NAME,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Action_Att_Lookups
     WHERE okc_action_att_lookups.id = p_id;
Line: 70

              l_aal_rec.LAST_UPDATED_BY,
              l_aal_rec.LAST_UPDATE_DATE,
              l_aal_rec.LAST_UPDATE_LOGIN;
Line: 93

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            OBJECT_NAME,
            COLUMN_NAME,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Action_Att_Lookups_V
     WHERE okc_action_att_lookups_v.id = p_id;
Line: 118

              l_aalv_rec.LAST_UPDATED_BY,
              l_aalv_rec.LAST_UPDATE_DATE,
              l_aalv_rec.LAST_UPDATE_LOGIN;
Line: 157

    IF (l_aalv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_aalv_rec.last_updated_by := NULL;
Line: 160

    IF (l_aalv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_aalv_rec.last_update_date := NULL;
Line: 163

    IF (l_aalv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_aalv_rec.last_update_login := NULL;
Line: 241

	    SELECT id FROM OKC_ACTION_ATT_LOOKUPS_V
	    WHERE object_name = p_object_name;
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: 522

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

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

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

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

  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_aal_rec                      IN aal_rec_type,
    x_aal_rec                      OUT NOCOPY aal_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 700

    l_api_name                     CONSTANT VARCHAR2(30) := 'LOOKUPS_insert_row';
Line: 736

    INSERT INTO OKC_ACTION_ATT_LOOKUPS(
        id,
        object_name,
        column_name,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_aal_rec.id,
        l_aal_rec.object_name,
        l_aal_rec.column_name,
        l_aal_rec.object_version_number,
        l_aal_rec.created_by,
        l_aal_rec.creation_date,
        l_aal_rec.last_updated_by,
        l_aal_rec.last_update_date,
        l_aal_rec.last_update_login);
Line: 790

  END insert_row;
Line: 794

  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_aalv_rec                     IN aalv_rec_type,
    x_aalv_rec                     OUT NOCOPY aalv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 804

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

      l_aalv_rec.LAST_UPDATE_DATE := l_aalv_rec.CREATION_DATE;
Line: 821

      l_aalv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 822

      l_aalv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 886

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_aal_rec,
      lx_aal_rec
    );
Line: 934

  END insert_row;
Line: 938

  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_aalv_tbl                     IN aalv_tbl_type,
    x_aalv_tbl                     OUT NOCOPY aalv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 948

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

        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_aalv_rec                     => p_aalv_tbl(i),
          x_aalv_rec                     => x_aalv_tbl(i));
Line: 1000

  END insert_row;
Line: 1018

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_ACTION_ATT_LOOKUPS
     WHERE ID = p_aal_rec.id
       AND OBJECT_VERSION_NUMBER = p_aal_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1025

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_ACTION_ATT_LOOKUPS
    WHERE ID = p_aal_rec.id;
Line: 1066

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

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

  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_aal_rec                      IN aal_rec_type,
    x_aal_rec                      OUT NOCOPY aal_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1271

    l_api_name                     CONSTANT VARCHAR2(30) := 'LOOKUPS_update_row';
Line: 1317

      IF (x_aal_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_aal_rec.last_updated_by := l_aal_rec.last_updated_by;
Line: 1321

      IF (x_aal_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_aal_rec.last_update_date := l_aal_rec.last_update_date;
Line: 1325

      IF (x_aal_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_aal_rec.last_update_login := l_aal_rec.last_update_login;
Line: 1369

    UPDATE  OKC_ACTION_ATT_LOOKUPS
    SET OBJECT_NAME = l_def_aal_rec.object_name,
        COLUMN_NAME = l_def_aal_rec.column_name,
        OBJECT_VERSION_NUMBER = l_def_aal_rec.object_version_number,
        CREATED_BY = l_def_aal_rec.created_by,
        CREATION_DATE = l_def_aal_rec.creation_date,
        LAST_UPDATED_BY = l_def_aal_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_aal_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_aal_rec.last_update_login
    WHERE ID = l_def_aal_rec.id;
Line: 1413

  END update_row;
Line: 1417

  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_aalv_rec                     IN aalv_rec_type,
    x_aalv_rec                     OUT NOCOPY aalv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1427

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

      l_aalv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1442

      l_aalv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1443

      l_aalv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1487

      IF (x_aalv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_aalv_rec.last_updated_by := l_aalv_rec.last_updated_by;
Line: 1491

      IF (x_aalv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_aalv_rec.last_update_date := l_aalv_rec.last_update_date;
Line: 1495

      IF (x_aalv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_aalv_rec.last_update_login := l_aalv_rec.last_update_login;
Line: 1566

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_aal_rec,
      lx_aal_rec
    );
Line: 1613

  END update_row;
Line: 1617

  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_aalv_tbl                     IN aalv_tbl_type,
    x_aalv_tbl                     OUT NOCOPY aalv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1627

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

        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_aalv_rec                     => p_aalv_tbl(i),
          x_aalv_rec                     => x_aalv_tbl(i));
Line: 1679

  END update_row;
Line: 1687

  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_aal_rec                      IN aal_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1695

    l_api_name                     CONSTANT VARCHAR2(30) := 'LOOKUPS_delete_row';
Line: 1709

    DELETE FROM OKC_ACTION_ATT_LOOKUPS
     WHERE ID = l_aal_rec.id;
Line: 1744

  END delete_row;
Line: 1748

  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_aalv_rec                     IN aalv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1757

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_aal_rec
    );
Line: 1825

  END delete_row;
Line: 1829

  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_aalv_tbl                     IN aalv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1838

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

        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_aalv_rec                     => p_aalv_tbl(i));
Line: 1889

  END delete_row;