DBA Data[Home] [Help]

APPS.OKC_PAC_PVT SQL Statements

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

Line: 53

    SELECT
            ID,
            PAT_ID,
            PAT_ID_FROM,
            BSL_ID,
            CLE_ID,
            BCL_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            REQUEST_ID,
           OBJECT_VERSION_NUMBER
     FROM Okc_Price_Adj_Assocs
     WHERE okc_price_adj_assocs.id = p_id;
Line: 93

              l_pac_rec.LAST_UPDATED_BY,
              l_pac_rec.LAST_UPDATE_DATE,
              l_pac_rec.LAST_UPDATE_LOGIN,
              l_pac_rec.PROGRAM_APPLICATION_ID,
              l_pac_rec.PROGRAM_ID,
              l_pac_rec.PROGRAM_UPDATE_DATE,
              l_pac_rec.REQUEST_ID,
              l_pac_rec.OBJECT_VERSION_NUMBER;
Line: 130

    SELECT
            ID,
            PAT_ID,
            PAT_ID_FROM,
            BSL_ID,
            CLE_ID,
            BCL_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
           PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            REQUEST_ID,
           OBJECT_VERSION_NUMBER
      FROM Okc_Price_Adj_Assocs_V
     WHERE okc_price_adj_assocs_v.id = p_id;
Line: 170

              l_pacv_rec.LAST_UPDATED_BY,
              l_pacv_rec.LAST_UPDATE_DATE,
              l_pacv_rec.LAST_UPDATE_LOGIN,
              l_pacv_rec.PROGRAM_APPLICATION_ID,
              l_pacv_rec.PROGRAM_ID,
              l_pacv_rec.PROGRAM_UPDATE_DATE,
              l_pacv_rec.REQUEST_ID,
              l_pacv_rec.OBJECT_VERSION_NUMBER;
Line: 236

    IF (l_pacv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_pacv_rec.last_updated_by := NULL;
Line: 239

    IF (l_pacv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_pacv_rec.last_update_date := NULL;
Line: 242

    IF (l_pacv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_pacv_rec.last_update_login := NULL;
Line: 251

  IF (l_pacv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
      l_pacv_rec.program_update_date := NULL;
Line: 465

      SELECT
              'x'
        FROM Okc_Price_Adjustments_V
       WHERE okc_price_adjustments_v.id = p_id;
Line: 471

      SELECT
              'x'
       FROM Okc_K_Lines_B
       WHERE okc_k_lines_b.id     = p_id;
Line: 477

      SELECT
              'x'
        FROM Oks_Bill_Cont_Lines_V
       WHERE oks_bill_cont_lines_v.id = p_id;
Line: 483

      SELECT
              'x'
        FROM Oks_Bill_Sub_Lines_V
       WHERE oks_bill_sub_lines_v.id = p_id;
Line: 602

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

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

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

    p_to.program_update_date:= p_from.program_update_date;
Line: 626

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

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

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

    p_to.program_update_date:= p_from.program_update_date;
Line: 849

  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_pac_rec                      IN pac_rec_type,
    x_pac_rec                      OUT NOCOPY pac_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 858

    l_api_name                     CONSTANT VARCHAR2(30) := 'ASSOCS_insert_row';
Line: 880

       okc_debug.log('3700: Entered insert_row', 2);
Line: 902

    INSERT INTO OKC_PRICE_ADJ_ASSOCS(
        id,
        pat_id,
        pat_id_from,
        bsl_id,
        cle_id,
        bcl_id,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        program_application_id,
        program_id,
        program_update_date,
        request_id,
       object_version_number)
      VALUES (
        l_pac_rec.id,
        l_pac_rec.pat_id,
        l_pac_rec.pat_id_from,
        l_pac_rec.bsl_id,
        l_pac_rec.cle_id,
        l_pac_rec.bcl_id,
        l_pac_rec.created_by,
        l_pac_rec.creation_date,
        l_pac_rec.last_updated_by,
        l_pac_rec.last_update_date,
        l_pac_rec.last_update_login,
        decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
        decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
       decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
        decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
        l_pac_rec.object_version_number);
Line: 941

       okc_debug.log('3800: Leaving insert_row', 2);
Line: 949

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

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

       okc_debug.log('4100: Exiting insert_row:OTHERS Exception', 2);
Line: 995

  END insert_row;
Line: 999

  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_pacv_rec                     IN pacv_rec_type,
    x_pacv_rec                     OUT NOCOPY pacv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1009

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

      l_pacv_rec.LAST_UPDATE_DATE := l_pacv_rec.CREATION_DATE;
Line: 1027

      l_pacv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1028

      l_pacv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1051

       okc_debug.log('4400: Entered insert_row', 2);
Line: 1101

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_pac_rec,
      lx_pac_rec
    );
Line: 1120

       okc_debug.log('4500: Leaving insert_row', 2);
Line: 1128

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

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

       okc_debug.log('4800: Exiting insert_row:OTHERS Exception', 2);
Line: 1174

  END insert_row;
Line: 1178

  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_pacv_tbl                     IN pacv_tbl_type,
    x_pacv_tbl                     OUT NOCOPY pacv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1188

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

       okc_debug.log('4900: Entered insert_row', 2);
Line: 1203

        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_pacv_rec                     => p_pacv_tbl(i),
          x_pacv_rec                     => x_pacv_tbl(i));
Line: 1217

       okc_debug.log('5000: Leaving insert_row', 2);
Line: 1225

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

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

       okc_debug.log('5300: Exiting insert_row:OTHERS Exception', 2);
Line: 1271

  END insert_row;
Line: 1289

    SELECT *
      FROM OKC_PRICE_ADJ_ASSOCS
     WHERE ID = p_pac_rec.id
    FOR UPDATE NOWAIT;
Line: 1339

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

      IF (l_lock_var.LAST_UPDATED_BY <> p_pac_rec.last_updated_by) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
Line: 1378

      IF (l_lock_var.LAST_UPDATE_DATE <> p_pac_rec.last_update_date) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
Line: 1382

      IF (l_lock_var.LAST_UPDATE_LOGIN <> p_pac_rec.last_update_login) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
Line: 1394

   IF (l_lock_var.PROGRAM_UPDATE_DATE <> p_pac_rec.program_update_date) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
Line: 1678

  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_pac_rec                      IN pac_rec_type,
    x_pac_rec                      OUT NOCOPY pac_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1687

    l_api_name                     CONSTANT VARCHAR2(30) := 'ASSOCS_update_row';
Line: 1747

      IF (x_pac_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_pac_rec.last_updated_by := l_pac_rec.last_updated_by;
Line: 1751

      IF (x_pac_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_pac_rec.last_update_date := l_pac_rec.last_update_date;
Line: 1755

      IF (x_pac_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_pac_rec.last_update_login := l_pac_rec.last_update_login;
Line: 1767

   IF (x_pac_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_pac_rec.program_update_date := l_pac_rec.program_update_date;
Line: 1806

       okc_debug.log('7400: Entered update_row', 2);
Line: 1834

    UPDATE  OKC_PRICE_ADJ_ASSOCS
    SET PAT_ID = l_def_pac_rec.pat_id,
        PAT_ID_FROM = l_def_pac_rec.pat_id_from,
        BSL_ID = l_def_pac_rec.bsl_id,
        CLE_ID = l_def_pac_rec.cle_id,
        BCL_ID = l_def_pac_rec.bcl_id,
        CREATED_BY = l_def_pac_rec.created_by,
        CREATION_DATE = l_def_pac_rec.creation_date,
        LAST_UPDATED_BY = l_def_pac_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_pac_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_pac_rec.last_update_login,
REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pac_rec.request_id),
PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pac_rec.program_application_id),
PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pac_rec.program_id),
PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pac_rec.program_update_date,SYSDATE),

   OBJECT_VERSION_NUMBER = l_def_pac_rec.object_version_number
 WHERE ID = l_def_pac_rec.id;
Line: 1857

   okc_debug.log('7500: Leaving update_row', 2);
Line: 1865

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

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

       okc_debug.log('7800: Exiting update_row:OTHERS Exception', 2);
Line: 1911

  END update_row;
Line: 1915

  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_pacv_rec                     IN pacv_rec_type,
    x_pacv_rec                     OUT NOCOPY pacv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1925

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

      l_pacv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1941

      l_pacv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1942

      l_pacv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2002

      IF (x_pacv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_pacv_rec.last_updated_by := l_pacv_rec.last_updated_by;
Line: 2006

      IF (x_pacv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_pacv_rec.last_update_date := l_pacv_rec.last_update_date;
Line: 2010

      IF (x_pacv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_pacv_rec.last_update_login := l_pacv_rec.last_update_login;
Line: 2022

     IF (x_pacv_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_pacv_rec.program_update_date := l_pacv_rec.program_update_date;
Line: 2036

       okc_debug.log('8100: Leaving update_row', 2);
Line: 2062

       okc_debug.log('8200: Entered update_row', 2);
Line: 2116

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_pac_rec,
      lx_pac_rec
    );
Line: 2134

       okc_debug.log('8300: Leaving update_row', 2);
Line: 2142

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

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

       okc_debug.log('8600: Exiting update_row:OTHERS Exception', 2);
Line: 2188

  END update_row;
Line: 2192

  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_pacv_tbl                     IN pacv_tbl_type,
    x_pacv_tbl                     OUT NOCOPY pacv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2202

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

       okc_debug.log('8700: Entered update_row', 2);
Line: 2217

        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_pacv_rec                     => p_pacv_tbl(i),
          x_pacv_rec                     => x_pacv_tbl(i));
Line: 2231

       okc_debug.log('8800: Leaving update_row', 2);
Line: 2239

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

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

       okc_debug.log('9100: Exiting update_row:OTHERS Exception', 2);
Line: 2285

  END update_row;
Line: 2293

  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_pac_rec                      IN pac_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2301

    l_api_name                     CONSTANT VARCHAR2(30) := 'ASSOCS_delete_row';
Line: 2309

       okc_debug.log('9200: Entered delete_row', 2);
Line: 2321

    DELETE FROM OKC_PRICE_ADJ_ASSOCS
     WHERE ID = l_pac_rec.id;
Line: 2327

       okc_debug.log('9300: Leaving delete_row', 2);
Line: 2335

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

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

       okc_debug.log('9600: Exiting delete_row:OTHERS Exception', 2);
Line: 2381

  END delete_row;
Line: 2385

  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_pacv_rec                     IN pacv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2394

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

       okc_debug.log('9700: Entered delete_row', 2);
Line: 2424

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_pac_rec
    );
Line: 2439

       okc_debug.log('9800: Leaving delete_row', 2);
Line: 2447

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

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

       okc_debug.log('10100: Exiting delete_row:OTHERS Exception', 2);
Line: 2493

  END delete_row;
Line: 2497

  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_pacv_tbl                     IN pacv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2506

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

       okc_debug.log('10200: Entered delete_row', 2);
Line: 2521

        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_pacv_rec                     => p_pacv_tbl(i));
Line: 2534

       okc_debug.log('10300: Leaving delete_row', 2);
Line: 2542

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

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

       okc_debug.log('10600: Exiting delete_row:OTHERS Exception', 2);
Line: 2588

  END delete_row;
Line: 2604

  INSERT INTO okc_price_adj_assocs_h
  (
      id,
        pat_id,
        pat_id_from,
        bsl_id,
        cle_id,
        bcl_id,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        program_application_id,
        program_id,
        program_update_date,
        request_id,
       object_version_number,
       major_version)
   SELECT
        id,
        pat_id,
        pat_id_from,
        bsl_id,
        cle_id,
        bcl_id,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        program_application_id,
        program_id,
        program_update_date,
        request_id,
       object_version_number,
       p_major_version

     FROM okc_price_adj_assocs
WHERE pat_id_from IN
        ( SELECT pat_id
          FROM OKC_PRICE_ADJUSTMENTS
          WHERE chr_id = p_chr_id
             );
Line: 2694

INSERT INTO okc_price_adj_assocs
   (
    id,
        pat_id,
        pat_id_from,
        bsl_id,
        cle_id,
        bcl_id,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        program_application_id,
        program_id,
        program_update_date,
        request_id,
       object_version_number
         )
   SELECT
        id,
        pat_id,
        pat_id_from,
        bsl_id,
        cle_id,
        bcl_id,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        program_application_id,
        program_id,
        program_update_date,
        request_id,
        object_version_number
FROM okc_price_adj_assocs_h
 WHERE pat_id_from IN
        ( SELECT pat_id
          FROM OKC_PRICE_ADJUSTMENTS
          WHERE chr_id = p_chr_id
             )
 AND major_version = p_major_version;