DBA Data[Home] [Help]

APPS.OKS_SLL_PVT SQL Statements

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

Line: 101

    SELECT
            ID,
            CHR_ID,
            CLE_ID,
            DNZ_CHR_ID,
            SEQUENCE_NO,
            UOM_CODE,
            START_DATE,
            END_DATE,
            LEVEL_PERIODS,
            UOM_PER_PERIOD,
            ADVANCE_PERIODS,
            LEVEL_AMOUNT,
            INVOICE_OFFSET_DAYS,
            INTERFACE_OFFSET_DAYS,
            COMMENTS,
            DUE_ARR_YN,
            AMOUNT,
            LINES_DETAILED_YN,
            OBJECT_VERSION_NUMBER,
            SECURITY_GROUP_ID,
            REQUEST_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            ORIG_SYSTEM_ID1,
            ORIG_SYSTEM_REFERENCE1,
            ORIG_SYSTEM_SOURCE_CODE
      FROM Oks_Stream_Levels_V
     WHERE oks_stream_levels_v.id = p_id;
Line: 163

              l_sllv_rec.last_updated_by,
              l_sllv_rec.last_update_date,
              l_sllv_rec.last_update_login,
              l_sllv_rec.orig_system_id1,
              l_sllv_rec.orig_system_reference1,
              l_sllv_rec.orig_system_source_code;
Line: 210

    SELECT
            ID,
            CHR_ID,
            CLE_ID,
            DNZ_CHR_ID,
            SEQUENCE_NO,
            UOM_CODE,
            START_DATE,
            END_DATE,
            LEVEL_PERIODS,
            UOM_PER_PERIOD,
            ADVANCE_PERIODS,
            LEVEL_AMOUNT,
            INVOICE_OFFSET_DAYS,
            INTERFACE_OFFSET_DAYS,
            COMMENTS,
            DUE_ARR_YN,
            AMOUNT,
            LINES_DETAILED_YN,
            OBJECT_VERSION_NUMBER,
            REQUEST_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            ORIG_SYSTEM_ID1,
            ORIG_SYSTEM_REFERENCE1,
            ORIG_SYSTEM_SOURCE_CODE
      FROM Oks_Stream_Levels_B
     WHERE oks_stream_levels_b.id = p_id;
Line: 270

              l_sll_rec.last_updated_by,
              l_sll_rec.last_update_date,
              l_sll_rec.last_update_login,
              l_sll_rec.orig_system_id1,
              l_sll_rec.orig_system_reference1,
              l_sll_rec.orig_system_source_code;
Line: 386

    IF (l_sllv_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
      l_sllv_rec.last_updated_by := NULL;
Line: 389

    IF (l_sllv_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
      l_sllv_rec.last_update_date := NULL;
Line: 392

    IF (l_sllv_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
      l_sllv_rec.last_update_login := NULL;
Line: 598

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

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

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

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

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

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

  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_sll_rec                      IN sll_rec_type,
    x_sll_rec                      OUT NOCOPY sll_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 892

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_insert_row';
Line: 928

    INSERT INTO OKS_STREAM_LEVELS_B(
      id,
      chr_id,
      cle_id,
      dnz_chr_id,
      sequence_no,
      uom_code,
      start_date,
      end_date,
      level_periods,
      uom_per_period,
      advance_periods,
      level_amount,
      invoice_offset_days,
      interface_offset_days,
      comments,
      due_arr_yn,
      amount,
      lines_detailed_yn,
      object_version_number,
      request_id,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      orig_system_id1,
      orig_system_reference1,
      orig_system_source_code)
    VALUES (
      l_sll_rec.id,
      l_sll_rec.chr_id,
      l_sll_rec.cle_id,
      l_sll_rec.dnz_chr_id,
      l_sll_rec.sequence_no,
      l_sll_rec.uom_code,
      l_sll_rec.start_date,
      l_sll_rec.end_date,
      l_sll_rec.level_periods,
      l_sll_rec.uom_per_period,
      l_sll_rec.advance_periods,
      l_sll_rec.level_amount,
      l_sll_rec.invoice_offset_days,
      l_sll_rec.interface_offset_days,
      l_sll_rec.comments,
      l_sll_rec.due_arr_yn,
      l_sll_rec.amount,
      l_sll_rec.lines_detailed_yn,
      l_sll_rec.object_version_number,
      l_sll_rec.request_id,
      l_sll_rec.created_by,
      l_sll_rec.creation_date,
      l_sll_rec.last_updated_by,
      l_sll_rec.last_update_date,
      l_sll_rec.last_update_login,
      l_sll_rec.orig_system_id1,
      l_sll_rec.orig_system_reference1,
      l_sll_rec.orig_system_source_code);
Line: 1021

  END insert_row;
Line: 1025

  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_sllv_rec                     IN sllv_rec_type,
    x_sllv_rec                     OUT NOCOPY sllv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1035

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

      l_sllv_rec.LAST_UPDATE_DATE := l_sllv_rec.CREATION_DATE;
Line: 1052

      l_sllv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1053

      l_sllv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1117

    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_sll_rec,
      lx_sll_rec
    );
Line: 1166

  END insert_row;
Line: 1170

  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_sllv_tbl                     IN sllv_tbl_type,
    x_sllv_tbl                     OUT NOCOPY sllv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1181

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
Line: 1195

          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_sllv_rec                     => p_sllv_tbl(i),
            x_sllv_rec                     => x_sllv_tbl(i));
Line: 1263

  END insert_row;
Line: 1270

  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_sllv_tbl                     IN sllv_tbl_type,
    x_sllv_tbl                     OUT NOCOPY sllv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1280

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

      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_sllv_tbl                     => p_sllv_tbl,
        x_sllv_tbl                     => x_sllv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 1329

  END insert_row;
Line: 1347

    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_STREAM_LEVELS_B
     WHERE ID = p_sll_rec.id
       AND OBJECT_VERSION_NUMBER = p_sll_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1354

    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_STREAM_LEVELS_B
     WHERE ID = p_sll_rec.id;
Line: 1395

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

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

  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_sll_rec                      IN sll_rec_type,
    x_sll_rec                      OUT NOCOPY sll_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1693

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_update_row';
Line: 1801

        IF (x_sll_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_sll_rec.last_updated_by := l_sll_rec.last_updated_by;
Line: 1805

        IF (x_sll_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_sll_rec.last_update_date := l_sll_rec.last_update_date;
Line: 1809

        IF (x_sll_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_sll_rec.last_update_login := l_sll_rec.last_update_login;
Line: 1867

    UPDATE OKS_STREAM_LEVELS_B
    SET CHR_ID = l_def_sll_rec.chr_id,
        CLE_ID = l_def_sll_rec.cle_id,
        DNZ_CHR_ID = l_def_sll_rec.dnz_chr_id,
        SEQUENCE_NO = l_def_sll_rec.sequence_no,
        UOM_CODE = l_def_sll_rec.uom_code,
        START_DATE = l_def_sll_rec.start_date,
        END_DATE = l_def_sll_rec.end_date,
        LEVEL_PERIODS = l_def_sll_rec.level_periods,
        UOM_PER_PERIOD = l_def_sll_rec.uom_per_period,
        ADVANCE_PERIODS = l_def_sll_rec.advance_periods,
        LEVEL_AMOUNT = l_def_sll_rec.level_amount,
        INVOICE_OFFSET_DAYS = l_def_sll_rec.invoice_offset_days,
        INTERFACE_OFFSET_DAYS = l_def_sll_rec.interface_offset_days,
        COMMENTS = l_def_sll_rec.comments,
        DUE_ARR_YN = l_def_sll_rec.due_arr_yn,
        AMOUNT = l_def_sll_rec.amount,
        LINES_DETAILED_YN = l_def_sll_rec.lines_detailed_yn,
        OBJECT_VERSION_NUMBER = l_def_sll_rec.object_version_number,
        REQUEST_ID = l_def_sll_rec.request_id,
        CREATED_BY = l_def_sll_rec.created_by,
        CREATION_DATE = l_def_sll_rec.creation_date,
        LAST_UPDATED_BY = l_def_sll_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_sll_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_sll_rec.last_update_login,
        ORIG_SYSTEM_ID1 = l_def_sll_rec.orig_system_id1,
        ORIG_SYSTEM_REFERENCE1 = l_def_sll_rec.orig_system_reference1,
        ORIG_SYSTEM_SOURCE_CODE = l_def_sll_rec.orig_system_source_code
    WHERE ID = l_def_sll_rec.id;
Line: 1931

  END update_row;
Line: 1935

  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_sllv_rec                     IN sllv_rec_type,
    x_sllv_rec                     OUT NOCOPY sllv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1945

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

      l_sllv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1961

      l_sllv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1962

      l_sllv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2069

        IF (x_sllv_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_sllv_rec.last_updated_by := l_db_sllv_rec.last_updated_by;
Line: 2073

        IF (x_sllv_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_sllv_rec.last_update_date := l_db_sllv_rec.last_update_date;
Line: 2077

        IF (x_sllv_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_sllv_rec.last_update_login := l_db_sllv_rec.last_update_login;
Line: 2174

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_sll_rec,
      lx_sll_rec
    );
Line: 2222

  END update_row;
Line: 2226

  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_sllv_tbl                     IN sllv_tbl_type,
    x_sllv_tbl                     OUT NOCOPY sllv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2237

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
Line: 2251

          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_sllv_rec                     => p_sllv_tbl(i),
            x_sllv_rec                     => x_sllv_tbl(i));
Line: 2319

  END update_row;
Line: 2326

  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_sllv_tbl                     IN sllv_tbl_type,
    x_sllv_tbl                     OUT NOCOPY sllv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2336

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

      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_sllv_tbl                     => p_sllv_tbl,
        x_sllv_tbl                     => x_sllv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 2385

  END update_row;
Line: 2393

  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_sll_rec                      IN sll_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2401

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_delete_row';
Line: 2416

    DELETE FROM OKS_STREAM_LEVELS_B
     WHERE ID = p_sll_rec.id;
Line: 2452

  END delete_row;
Line: 2456

  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_sllv_rec                     IN sllv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2465

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

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_sll_rec
    );
Line: 2534

  END delete_row;
Line: 2538

  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_sllv_tbl                     IN sllv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2548

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
Line: 2562

          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_sllv_rec                     => p_sllv_tbl(i));
Line: 2629

  END delete_row;
Line: 2634

  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_sllv_tbl                     IN sllv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2643

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

      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_sllv_tbl                     => p_sllv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 2691

  END delete_row;