DBA Data[Home] [Help]

APPS.OKL_AGB_PVT SQL Statements

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

Line: 43

    SELECT
            ID,
            KHR_ID,
            OBJECT_VERSION_NUMBER,
            DATE_BALANCE,
            ACC_GROUP_ID,
            AMOUNT,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM OKL_ACC_GROUP_BAL
     WHERE OKL_ACC_GROUP_BAL.id  = p_id;
Line: 72

              l_agb_rec.LAST_UPDATED_BY,
              l_agb_rec.LAST_UPDATE_DATE,
              l_agb_rec.LAST_UPDATE_LOGIN;
Line: 95

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            ACC_GROUP_ID,
            KHR_ID,
            DATE_BALANCE,
            AMOUNT,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM OKL_ACC_GROUP_BAL_V
     WHERE OKL_ACC_GROUP_BAL_v.id = p_id;
Line: 124

              l_agbv_rec.LAST_UPDATED_BY,
              l_agbv_rec.LAST_UPDATE_DATE,
              l_agbv_rec.LAST_UPDATE_LOGIN;
Line: 169

    IF (l_agbv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
      l_agbv_rec.last_updated_by := NULL;
Line: 172

    IF (l_agbv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
      l_agbv_rec.last_update_date := NULL;
Line: 175

    IF (l_agbv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
      l_agbv_rec.last_update_login := NULL;
Line: 267

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

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

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

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

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

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

  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_agb_rec                      IN agb_rec_type,
    x_agb_rec                      OUT NOCOPY agb_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 456

    l_api_name                     CONSTANT VARCHAR2(30) := 'SETS_insert_row';
Line: 492

    INSERT INTO OKL_ACC_GROUP_BAL(
        id,
        khr_id,
        object_version_number,
        date_balance,
        acc_group_id,
        amount,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_agb_rec.id,
        l_agb_rec.khr_id,
        l_agb_rec.object_version_number,
        l_agb_rec.date_balance,
        l_agb_rec.acc_group_id,
        l_agb_rec.amount,
        l_agb_rec.created_by,
        l_agb_rec.creation_date,
        l_agb_rec.last_updated_by,
        l_agb_rec.last_update_date,
        l_agb_rec.last_update_login);
Line: 550

  END insert_row;
Line: 554

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_agbv_rec                     IN agbv_rec_type,
    x_agbv_rec                     OUT NOCOPY agbv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 564

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

      l_agbv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 581

      l_agbv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 582

      l_agbv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 646

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_agb_rec,
      lx_agb_rec
    );
Line: 694

  END insert_row;
Line: 698

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_agbv_tbl                     IN agbv_tbl_type,
    x_agbv_tbl                     OUT NOCOPY agbv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 708

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

        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_agbv_rec                     => p_agbv_tbl(i),
          x_agbv_rec                     => x_agbv_tbl(i));
Line: 769

  END insert_row;
Line: 787

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ACC_GROUP_BAL
     WHERE ID = p_agb_rec.id
       AND OBJECT_VERSION_NUMBER = p_agb_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 794

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ACC_GROUP_BAL
    WHERE ID = p_agb_rec.id;
Line: 835

      Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 844

      Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 1040

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_agb_rec                      IN agb_rec_type,
    x_agb_rec                      OUT NOCOPY agb_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1049

    l_api_name                     CONSTANT VARCHAR2(30) := 'SETS_update_row';
Line: 1103

      IF (x_agb_rec.last_updated_by = Okc_Api.G_MISS_NUM)
      THEN
        x_agb_rec.last_updated_by := l_agb_rec.last_updated_by;
Line: 1107

      IF (x_agb_rec.last_update_date = Okc_Api.G_MISS_DATE)
      THEN
        x_agb_rec.last_update_date := l_agb_rec.last_update_date;
Line: 1111

      IF (x_agb_rec.last_update_login = Okc_Api.G_MISS_NUM)
      THEN
        x_agb_rec.last_update_login := l_agb_rec.last_update_login;
Line: 1155

    UPDATE  OKL_ACC_GROUP_BAL
    SET khr_id = l_def_agb_rec.khr_id,
        OBJECT_VERSION_NUMBER = l_def_agb_rec.object_version_number,
        DATE_BALANCE = l_def_agb_rec.date_balance,
        ACC_GROUP_ID = l_def_agb_rec.acc_group_id,
        AMOUNT = l_def_agb_rec.amount,
        CREATED_BY = l_def_agb_rec.created_by,
        CREATION_DATE = l_def_agb_rec.creation_date,
        LAST_UPDATED_BY = l_def_agb_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_agb_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_agb_rec.last_update_login
    WHERE ID = l_def_agb_rec.id;
Line: 1201

  END update_row;
Line: 1205

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_agbv_rec                     IN agbv_rec_type,
    x_agbv_rec                     OUT NOCOPY agbv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1215

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

      l_agbv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1230

      l_agbv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
Line: 1231

      l_agbv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 1283

      IF (x_agbv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
      THEN
        x_agbv_rec.last_updated_by := l_agbv_rec.last_updated_by;
Line: 1287

      IF (x_agbv_rec.last_update_date = Okc_Api.G_MISS_DATE)
      THEN
        x_agbv_rec.last_update_date := l_agbv_rec.last_update_date;
Line: 1291

      IF (x_agbv_rec.last_update_login = Okc_Api.G_MISS_NUM)
      THEN
        x_agbv_rec.last_update_login := l_agbv_rec.last_update_login;
Line: 1362

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_agb_rec,
      lx_agb_rec
    );
Line: 1409

  END update_row;
Line: 1413

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_agbv_tbl                     IN agbv_tbl_type,
    x_agbv_tbl                     OUT NOCOPY agbv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1423

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

        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_agbv_rec                     => p_agbv_tbl(i),
          x_agbv_rec                     => x_agbv_tbl(i));
Line: 1486

  END update_row;
Line: 1494

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_agb_rec                      IN agb_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1502

    l_api_name                     CONSTANT VARCHAR2(30) := 'SETS_delete_row';
Line: 1517

    DELETE FROM OKL_ACC_GROUP_BAL
     WHERE ID = l_agb_rec.id;
Line: 1553

  END delete_row;
Line: 1557

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_agbv_rec                     IN agbv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1566

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_agb_rec
    );
Line: 1634

  END delete_row;
Line: 1638

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_agbv_tbl                     IN agbv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1647

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

        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_agbv_rec                     => p_agbv_tbl(i));
Line: 1707

  END delete_row;