eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_PAV_PVT SQL Statements

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

Line: 192


      SELECT
              'x'
        FROM Okc_K_Headers_B
       WHERE okc_k_headers_b.id   = p_id;

Line: 198


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

Line: 373


    p_to.last_updated_by := p_from.last_updated_by;

Line: 375


    p_to.last_update_date := p_from.last_update_date;

Line: 470


    p_to.last_update_login := p_from.last_update_login;

Line: 473


    p_to.program_update_date:= p_from.program_update_date;

Line: 628


  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_pav_rec                      IN pav_rec_type,
    x_pav_rec                      OUT NOCOPY pav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 637


    l_api_name                     CONSTANT VARCHAR2(30) := 'VALUES_insert_row';

Line: 673


    INSERT INTO OKC_PRICE_ATT_VALUES(
        id,
        flex_title,
        pricing_context,
        pricing_attribute1,
        chr_id,
        pricing_attribute2,
        cle_id,
        pricing_attribute3,
        pricing_attribute4,
        pricing_attribute5,
        pricing_attribute6,
        pricing_attribute7,
        pricing_attribute8,
        pricing_attribute9,
        pricing_attribute10,
        pricing_attribute11,
        pricing_attribute12,
        pricing_attribute13,
        pricing_attribute14,
        pricing_attribute15,
        pricing_attribute16,
        pricing_attribute17,
        pricing_attribute18,
        pricing_attribute19,
        pricing_attribute20,
        pricing_attribute21,
        pricing_attribute22,
        pricing_attribute23,
        pricing_attribute24,
        pricing_attribute25,
        pricing_attribute26,
        pricing_attribute27,
        pricing_attribute28,
        pricing_attribute29,
        pricing_attribute30,
        pricing_attribute31,
        pricing_attribute32,
        pricing_attribute33,
        pricing_attribute34,
        pricing_attribute35,
        pricing_attribute36,
        pricing_attribute37,
        pricing_attribute38,
        pricing_attribute39,
        pricing_attribute40,
        pricing_attribute41,
        pricing_attribute42,
        pricing_attribute43,
        pricing_attribute44,
        pricing_attribute45,
        pricing_attribute46,
        pricing_attribute47,
        pricing_attribute48,
        pricing_attribute49,
        pricing_attribute50,
        pricing_attribute51,
        pricing_attribute52,
        pricing_attribute53,
        pricing_attribute54,
        pricing_attribute55,
        pricing_attribute56,
        pricing_attribute57,
        pricing_attribute58,
        pricing_attribute59,
        pricing_attribute60,
        pricing_attribute61,
        pricing_attribute62,
        pricing_attribute63,
        pricing_attribute64,
        pricing_attribute65,
        pricing_attribute66,
        pricing_attribute67,
        pricing_attribute68,
        pricing_attribute69,
        pricing_attribute70,
        pricing_attribute71,
        pricing_attribute72,
        pricing_attribute73,
        pricing_attribute74,
        pricing_attribute75,
        pricing_attribute76,
        pricing_attribute77,
        pricing_attribute78,
        pricing_attribute79,
        pricing_attribute80,
        pricing_attribute81,
        pricing_attribute82,
        pricing_attribute83,
        pricing_attribute84,
        pricing_attribute85,
        pricing_attribute86,
        pricing_attribute87,
        pricing_attribute88,
        pricing_attribute89,
        pricing_attribute90,
        pricing_attribute91,
        pricing_attribute92,
        pricing_attribute93,
        pricing_attribute94,
        pricing_attribute95,
        pricing_attribute96,
        pricing_attribute97,
        pricing_attribute98,
        pricing_attribute99,
        pricing_attribute100,
        qualifier_context,
        qualifier_attribute1,
        qualifier_attribute2,
        created_by,
        qualifier_attribute3,
        creation_date,
        qualifier_attribute4,
        qualifier_attribute5,
        last_updated_by,
        qualifier_attribute6,
        last_update_date,
        qualifier_attribute7,
        qualifier_attribute8,
        qualifier_attribute9,
        qualifier_attribute10,
        qualifier_attribute11,
        qualifier_attribute12,
        qualifier_attribute13,
        qualifier_attribute14,
        qualifier_attribute15,
        qualifier_attribute16,
        qualifier_attribute17,
        qualifier_attribute18,
        qualifier_attribute19,
        qualifier_attribute20,
        qualifier_attribute21,
        qualifier_attribute22,
        qualifier_attribute23,
        qualifier_attribute24,
        qualifier_attribute25,
        qualifier_attribute26,
        qualifier_attribute27,
        qualifier_attribute28,
        qualifier_attribute29,
        qualifier_attribute30,
        qualifier_attribute31,
        qualifier_attribute32,
        qualifier_attribute33,
        qualifier_attribute34,
        qualifier_attribute35,
        qualifier_attribute36,
        qualifier_attribute37,
        qualifier_attribute38,
        qualifier_attribute39,
        qualifier_attribute40,
        qualifier_attribute41,
        qualifier_attribute42,
        qualifier_attribute43,
        qualifier_attribute44,
        qualifier_attribute45,
        qualifier_attribute46,
        qualifier_attribute47,
        qualifier_attribute48,
        qualifier_attribute49,
        qualifier_attribute50,
        qualifier_attribute51,
        qualifier_attribute52,
        qualifier_attribute53,
        qualifier_attribute54,
        qualifier_attribute55,
        qualifier_attribute56,
        qualifier_attribute57,
        qualifier_attribute58,
        qualifier_attribute59,
        qualifier_attribute60,
        qualifier_attribute61,
        qualifier_attribute62,
        qualifier_attribute63,
        qualifier_attribute64,
        qualifier_attribute65,
        qualifier_attribute66,
        qualifier_attribute67,
        qualifier_attribute68,
        qualifier_attribute69,
        qualifier_attribute70,
        qualifier_attribute71,
        qualifier_attribute72,
        qualifier_attribute73,
        qualifier_attribute74,
        qualifier_attribute75,
        qualifier_attribute76,
        qualifier_attribute77,
        qualifier_attribute78,
        qualifier_attribute79,
        qualifier_attribute80,
        qualifier_attribute81,
        qualifier_attribute82,
        qualifier_attribute83,
        qualifier_attribute84,
        qualifier_attribute85,
        qualifier_attribute86,
        qualifier_attribute87,
        qualifier_attribute88,
        qualifier_attribute89,
        qualifier_attribute90,
        qualifier_attribute91,
        qualifier_attribute92,
        qualifier_attribute93,
        qualifier_attribute94,
        qualifier_attribute95,
        qualifier_attribute96,
        qualifier_attribute97,
        qualifier_attribute98,
        qualifier_attribute99,
        qualifier_attribute100,
        last_update_login,
        program_application_id,
        program_id,
        program_update_date,
        request_id,
       object_version_number)
       VALUES (
        l_pav_rec.id,
        l_pav_rec.flex_title,
        l_pav_rec.pricing_context,
        l_pav_rec.pricing_attribute1,
        l_pav_rec.chr_id,
        l_pav_rec.pricing_attribute2,
        l_pav_rec.cle_id,
        l_pav_rec.pricing_attribute3,
        l_pav_rec.pricing_attribute4,
        l_pav_rec.pricing_attribute5,
        l_pav_rec.pricing_attribute6,
        l_pav_rec.pricing_attribute7,
        l_pav_rec.pricing_attribute8,
        l_pav_rec.pricing_attribute9,
        l_pav_rec.pricing_attribute10,
        l_pav_rec.pricing_attribute11,
        l_pav_rec.pricing_attribute12,
        l_pav_rec.pricing_attribute13,
        l_pav_rec.pricing_attribute14,
        l_pav_rec.pricing_attribute15,
        l_pav_rec.pricing_attribute16,
        l_pav_rec.pricing_attribute17,
        l_pav_rec.pricing_attribute18,
        l_pav_rec.pricing_attribute19,
        l_pav_rec.pricing_attribute20,
        l_pav_rec.pricing_attribute21,
        l_pav_rec.pricing_attribute22,
        l_pav_rec.pricing_attribute23,
        l_pav_rec.pricing_attribute24,
        l_pav_rec.pricing_attribute25,
        l_pav_rec.pricing_attribute26,
        l_pav_rec.pricing_attribute27,
        l_pav_rec.pricing_attribute28,
        l_pav_rec.pricing_attribute29,
        l_pav_rec.pricing_attribute30,
        l_pav_rec.pricing_attribute31,
        l_pav_rec.pricing_attribute32,
        l_pav_rec.pricing_attribute33,
        l_pav_rec.pricing_attribute34,
        l_pav_rec.pricing_attribute35,
        l_pav_rec.pricing_attribute36,
        l_pav_rec.pricing_attribute37,
        l_pav_rec.pricing_attribute38,
        l_pav_rec.pricing_attribute39,
        l_pav_rec.pricing_attribute40,
        l_pav_rec.pricing_attribute41,
        l_pav_rec.pricing_attribute42,
        l_pav_rec.pricing_attribute43,
        l_pav_rec.pricing_attribute44,
        l_pav_rec.pricing_attribute45,
        l_pav_rec.pricing_attribute46,
        l_pav_rec.pricing_attribute47,
        l_pav_rec.pricing_attribute48,
        l_pav_rec.pricing_attribute49,
        l_pav_rec.pricing_attribute50,
        l_pav_rec.pricing_attribute51,
        l_pav_rec.pricing_attribute52,
        l_pav_rec.pricing_attribute53,
        l_pav_rec.pricing_attribute54,
        l_pav_rec.pricing_attribute55,
        l_pav_rec.pricing_attribute56,
        l_pav_rec.pricing_attribute57,
        l_pav_rec.pricing_attribute58,
        l_pav_rec.pricing_attribute59,
        l_pav_rec.pricing_attribute60,
        l_pav_rec.pricing_attribute61,
        l_pav_rec.pricing_attribute62,
        l_pav_rec.pricing_attribute63,
        l_pav_rec.pricing_attribute64,
        l_pav_rec.pricing_attribute65,
        l_pav_rec.pricing_attribute66,
        l_pav_rec.pricing_attribute67,
        l_pav_rec.pricing_attribute68,
        l_pav_rec.pricing_attribute69,
        l_pav_rec.pricing_attribute70,
        l_pav_rec.pricing_attribute71,
        l_pav_rec.pricing_attribute72,
        l_pav_rec.pricing_attribute73,
        l_pav_rec.pricing_attribute74,
        l_pav_rec.pricing_attribute75,
        l_pav_rec.pricing_attribute76,
        l_pav_rec.pricing_attribute77,
        l_pav_rec.pricing_attribute78,
        l_pav_rec.pricing_attribute79,
        l_pav_rec.pricing_attribute80,
        l_pav_rec.pricing_attribute81,
        l_pav_rec.pricing_attribute82,
        l_pav_rec.pricing_attribute83,
        l_pav_rec.pricing_attribute84,
        l_pav_rec.pricing_attribute85,
        l_pav_rec.pricing_attribute86,
        l_pav_rec.pricing_attribute87,
        l_pav_rec.pricing_attribute88,
        l_pav_rec.pricing_attribute89,
        l_pav_rec.pricing_attribute90,
        l_pav_rec.pricing_attribute91,
        l_pav_rec.pricing_attribute92,
        l_pav_rec.pricing_attribute93,
        l_pav_rec.pricing_attribute94,
        l_pav_rec.pricing_attribute95,
        l_pav_rec.pricing_attribute96,
        l_pav_rec.pricing_attribute97,
        l_pav_rec.pricing_attribute98,
        l_pav_rec.pricing_attribute99,
        l_pav_rec.pricing_attribute100,
        l_pav_rec.qualifier_context,
        l_pav_rec.qualifier_attribute1,
        l_pav_rec.qualifier_attribute2,
        l_pav_rec.created_by,
        l_pav_rec.qualifier_attribute3,
        l_pav_rec.creation_date,
        l_pav_rec.qualifier_attribute4,
        l_pav_rec.qualifier_attribute5,
        l_pav_rec.last_updated_by,
        l_pav_rec.qualifier_attribute6,
        l_pav_rec.last_update_date,
        l_pav_rec.qualifier_attribute7,
        l_pav_rec.qualifier_attribute8,
        l_pav_rec.qualifier_attribute9,
        l_pav_rec.qualifier_attribute10,
        l_pav_rec.qualifier_attribute11,
        l_pav_rec.qualifier_attribute12,
        l_pav_rec.qualifier_attribute13,
        l_pav_rec.qualifier_attribute14,
        l_pav_rec.qualifier_attribute15,
        l_pav_rec.qualifier_attribute16,
        l_pav_rec.qualifier_attribute17,
        l_pav_rec.qualifier_attribute18,
        l_pav_rec.qualifier_attribute19,
        l_pav_rec.qualifier_attribute20,
        l_pav_rec.qualifier_attribute21,
        l_pav_rec.qualifier_attribute22,
        l_pav_rec.qualifier_attribute23,
        l_pav_rec.qualifier_attribute24,
        l_pav_rec.qualifier_attribute25,
        l_pav_rec.qualifier_attribute26,
        l_pav_rec.qualifier_attribute27,
        l_pav_rec.qualifier_attribute28,
        l_pav_rec.qualifier_attribute29,
        l_pav_rec.qualifier_attribute30,
        l_pav_rec.qualifier_attribute31,
        l_pav_rec.qualifier_attribute32,
        l_pav_rec.qualifier_attribute33,
        l_pav_rec.qualifier_attribute34,
        l_pav_rec.qualifier_attribute35,
        l_pav_rec.qualifier_attribute36,
        l_pav_rec.qualifier_attribute37,
        l_pav_rec.qualifier_attribute38,
        l_pav_rec.qualifier_attribute39,
        l_pav_rec.qualifier_attribute40,
        l_pav_rec.qualifier_attribute41,
        l_pav_rec.qualifier_attribute42,
        l_pav_rec.qualifier_attribute43,
        l_pav_rec.qualifier_attribute44,
        l_pav_rec.qualifier_attribute45,
        l_pav_rec.qualifier_attribute46,
        l_pav_rec.qualifier_attribute47,
        l_pav_rec.qualifier_attribute48,
        l_pav_rec.qualifier_attribute49,
        l_pav_rec.qualifier_attribute50,
        l_pav_rec.qualifier_attribute51,
        l_pav_rec.qualifier_attribute52,
        l_pav_rec.qualifier_attribute53,
        l_pav_rec.qualifier_attribute54,
        l_pav_rec.qualifier_attribute55,
        l_pav_rec.qualifier_attribute56,
        l_pav_rec.qualifier_attribute57,
        l_pav_rec.qualifier_attribute58,
        l_pav_rec.qualifier_attribute59,
        l_pav_rec.qualifier_attribute60,
        l_pav_rec.qualifier_attribute61,
        l_pav_rec.qualifier_attribute62,
        l_pav_rec.qualifier_attribute63,
        l_pav_rec.qualifier_attribute64,
        l_pav_rec.qualifier_attribute65,
        l_pav_rec.qualifier_attribute66,
        l_pav_rec.qualifier_attribute67,
        l_pav_rec.qualifier_attribute68,
        l_pav_rec.qualifier_attribute69,
        l_pav_rec.qualifier_attribute70,
        l_pav_rec.qualifier_attribute71,
        l_pav_rec.qualifier_attribute72,
        l_pav_rec.qualifier_attribute73,
        l_pav_rec.qualifier_attribute74,
        l_pav_rec.qualifier_attribute75,
        l_pav_rec.qualifier_attribute76,
        l_pav_rec.qualifier_attribute77,
        l_pav_rec.qualifier_attribute78,
        l_pav_rec.qualifier_attribute79,
        l_pav_rec.qualifier_attribute80,
        l_pav_rec.qualifier_attribute81,
        l_pav_rec.qualifier_attribute82,
        l_pav_rec.qualifier_attribute83,
        l_pav_rec.qualifier_attribute84,
        l_pav_rec.qualifier_attribute85,
        l_pav_rec.qualifier_attribute86,
        l_pav_rec.qualifier_attribute87,
        l_pav_rec.qualifier_attribute88,
        l_pav_rec.qualifier_attribute89,
        l_pav_rec.qualifier_attribute90,
        l_pav_rec.qualifier_attribute91,
        l_pav_rec.qualifier_attribute92,
        l_pav_rec.qualifier_attribute93,
        l_pav_rec.qualifier_attribute94,
        l_pav_rec.qualifier_attribute95,
        l_pav_rec.qualifier_attribute96,
        l_pav_rec.qualifier_attribute97,
        l_pav_rec.qualifier_attribute98,
        l_pav_rec.qualifier_attribute99,
        l_pav_rec.qualifier_attribute100,
        l_pav_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_pav_rec.object_version_number);

Line: 1141


  END insert_row;

Line: 1145


  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_pavv_rec                     IN pavv_rec_type,
    x_pavv_rec                     OUT NOCOPY pavv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1155


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

Line: 1171


      l_pavv_rec.LAST_UPDATE_DATE := l_pavv_rec.CREATION_DATE;

Line: 1172


      l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1173


      l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1237


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_pav_rec,
      lx_pav_rec
    );

Line: 1285


  END insert_row;

Line: 1289


  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_pavv_tbl                     IN pavv_tbl_type,
    x_pavv_tbl                     OUT NOCOPY pavv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1299


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

Line: 1308


        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_pavv_rec                     => p_pavv_tbl(i),
          x_pavv_rec                     => x_pavv_tbl(i));

Line: 1351


  END insert_row;

Line: 1369


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_PRICE_ATT_VALUES
     WHERE ID = p_pav_rec.id
       AND OBJECT_VERSION_NUMBER = p_pav_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1376


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_PRICE_ATT_VALUES
    WHERE ID = p_pav_rec.id;

Line: 1418


      OKC_API.set_message(G_APP_NAME,'OKC_FORM_RECORD_DELETED');

Line: 1427


      OKC_API.set_message(G_FND_APP,G_RECORD_LOGICALLY_DELETED);

Line: 1615


  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_pav_rec                      IN pav_rec_type,
    x_pav_rec                      OUT NOCOPY pav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1624


    l_api_name                     CONSTANT VARCHAR2(30) := 'VALUES_update_row';

Line: 2098


      IF (x_pav_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_pav_rec.last_updated_by := l_pav_rec.last_updated_by;

Line: 2106


      IF (x_pav_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_pav_rec.last_update_date := l_pav_rec.last_update_date;

Line: 2486


      IF (x_pav_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_pav_rec.last_update_login := l_pav_rec.last_update_login;

Line: 2498


   IF (x_pav_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_pav_rec.program_update_date := l_pav_rec.program_update_date;

Line: 2550


    UPDATE  OKC_PRICE_ATT_VALUES
    SET FLEX_TITLE = l_def_pav_rec.flex_title,
        PRICING_CONTEXT = l_def_pav_rec.pricing_context,
        PRICING_ATTRIBUTE1 = l_def_pav_rec.pricing_attribute1,
        CHR_ID = l_def_pav_rec.chr_id,
        PRICING_ATTRIBUTE2 = l_def_pav_rec.pricing_attribute2,
        CLE_ID = l_def_pav_rec.cle_id,
        PRICING_ATTRIBUTE3 = l_def_pav_rec.pricing_attribute3,
        PRICING_ATTRIBUTE4 = l_def_pav_rec.pricing_attribute4,
        PRICING_ATTRIBUTE5 = l_def_pav_rec.pricing_attribute5,
        PRICING_ATTRIBUTE6 = l_def_pav_rec.pricing_attribute6,
        PRICING_ATTRIBUTE7 = l_def_pav_rec.pricing_attribute7,
        PRICING_ATTRIBUTE8 = l_def_pav_rec.pricing_attribute8,
        PRICING_ATTRIBUTE9 = l_def_pav_rec.pricing_attribute9,
        PRICING_ATTRIBUTE10 = l_def_pav_rec.pricing_attribute10,
        PRICING_ATTRIBUTE11 = l_def_pav_rec.pricing_attribute11,
        PRICING_ATTRIBUTE12 = l_def_pav_rec.pricing_attribute12,
        PRICING_ATTRIBUTE13 = l_def_pav_rec.pricing_attribute13,
        PRICING_ATTRIBUTE14 = l_def_pav_rec.pricing_attribute14,
        PRICING_ATTRIBUTE15 = l_def_pav_rec.pricing_attribute15,
        PRICING_ATTRIBUTE16 = l_def_pav_rec.pricing_attribute16,
        PRICING_ATTRIBUTE17 = l_def_pav_rec.pricing_attribute17,
        PRICING_ATTRIBUTE18 = l_def_pav_rec.pricing_attribute18,
        PRICING_ATTRIBUTE19 = l_def_pav_rec.pricing_attribute19,
        PRICING_ATTRIBUTE20 = l_def_pav_rec.pricing_attribute20,
        PRICING_ATTRIBUTE21 = l_def_pav_rec.pricing_attribute21,
        PRICING_ATTRIBUTE22 = l_def_pav_rec.pricing_attribute22,
        PRICING_ATTRIBUTE23 = l_def_pav_rec.pricing_attribute23,
        PRICING_ATTRIBUTE24 = l_def_pav_rec.pricing_attribute24,
        PRICING_ATTRIBUTE25 = l_def_pav_rec.pricing_attribute25,
        PRICING_ATTRIBUTE26 = l_def_pav_rec.pricing_attribute26,
        PRICING_ATTRIBUTE27 = l_def_pav_rec.pricing_attribute27,
        PRICING_ATTRIBUTE28 = l_def_pav_rec.pricing_attribute28,
        PRICING_ATTRIBUTE29 = l_def_pav_rec.pricing_attribute29,
        PRICING_ATTRIBUTE30 = l_def_pav_rec.pricing_attribute30,
        PRICING_ATTRIBUTE31 = l_def_pav_rec.pricing_attribute31,
        PRICING_ATTRIBUTE32 = l_def_pav_rec.pricing_attribute32,
        PRICING_ATTRIBUTE33 = l_def_pav_rec.pricing_attribute33,
        PRICING_ATTRIBUTE34 = l_def_pav_rec.pricing_attribute34,
        PRICING_ATTRIBUTE35 = l_def_pav_rec.pricing_attribute35,
        PRICING_ATTRIBUTE36 = l_def_pav_rec.pricing_attribute36,
        PRICING_ATTRIBUTE37 = l_def_pav_rec.pricing_attribute37,
        PRICING_ATTRIBUTE38 = l_def_pav_rec.pricing_attribute38,
        PRICING_ATTRIBUTE39 = l_def_pav_rec.pricing_attribute39,
        PRICING_ATTRIBUTE40 = l_def_pav_rec.pricing_attribute40,
        PRICING_ATTRIBUTE41 = l_def_pav_rec.pricing_attribute41,
        PRICING_ATTRIBUTE42 = l_def_pav_rec.pricing_attribute42,
        PRICING_ATTRIBUTE43 = l_def_pav_rec.pricing_attribute43,
        PRICING_ATTRIBUTE44 = l_def_pav_rec.pricing_attribute44,
        PRICING_ATTRIBUTE45 = l_def_pav_rec.pricing_attribute45,
        PRICING_ATTRIBUTE46 = l_def_pav_rec.pricing_attribute46,
        PRICING_ATTRIBUTE47 = l_def_pav_rec.pricing_attribute47,
        PRICING_ATTRIBUTE48 = l_def_pav_rec.pricing_attribute48,
        PRICING_ATTRIBUTE49 = l_def_pav_rec.pricing_attribute49,
        PRICING_ATTRIBUTE50 = l_def_pav_rec.pricing_attribute50,
        PRICING_ATTRIBUTE51 = l_def_pav_rec.pricing_attribute51,
        PRICING_ATTRIBUTE52 = l_def_pav_rec.pricing_attribute52,
        PRICING_ATTRIBUTE53 = l_def_pav_rec.pricing_attribute53,
        PRICING_ATTRIBUTE54 = l_def_pav_rec.pricing_attribute54,
        PRICING_ATTRIBUTE55 = l_def_pav_rec.pricing_attribute55,
        PRICING_ATTRIBUTE56 = l_def_pav_rec.pricing_attribute56,
        PRICING_ATTRIBUTE57 = l_def_pav_rec.pricing_attribute57,
        PRICING_ATTRIBUTE58 = l_def_pav_rec.pricing_attribute58,
        PRICING_ATTRIBUTE59 = l_def_pav_rec.pricing_attribute59,
        PRICING_ATTRIBUTE60 = l_def_pav_rec.pricing_attribute60,
        PRICING_ATTRIBUTE61 = l_def_pav_rec.pricing_attribute61,
        PRICING_ATTRIBUTE62 = l_def_pav_rec.pricing_attribute62,
        PRICING_ATTRIBUTE63 = l_def_pav_rec.pricing_attribute63,
        PRICING_ATTRIBUTE64 = l_def_pav_rec.pricing_attribute64,
        PRICING_ATTRIBUTE65 = l_def_pav_rec.pricing_attribute65,
        PRICING_ATTRIBUTE66 = l_def_pav_rec.pricing_attribute66,
        PRICING_ATTRIBUTE67 = l_def_pav_rec.pricing_attribute67,
        PRICING_ATTRIBUTE68 = l_def_pav_rec.pricing_attribute68,
        PRICING_ATTRIBUTE69 = l_def_pav_rec.pricing_attribute69,
        PRICING_ATTRIBUTE70 = l_def_pav_rec.pricing_attribute70,
        PRICING_ATTRIBUTE71 = l_def_pav_rec.pricing_attribute71,
        PRICING_ATTRIBUTE72 = l_def_pav_rec.pricing_attribute72,
        PRICING_ATTRIBUTE73 = l_def_pav_rec.pricing_attribute73,
        PRICING_ATTRIBUTE74 = l_def_pav_rec.pricing_attribute74,
        PRICING_ATTRIBUTE75 = l_def_pav_rec.pricing_attribute75,
        PRICING_ATTRIBUTE76 = l_def_pav_rec.pricing_attribute76,
        PRICING_ATTRIBUTE77 = l_def_pav_rec.pricing_attribute77,
        PRICING_ATTRIBUTE78 = l_def_pav_rec.pricing_attribute78,
        PRICING_ATTRIBUTE79 = l_def_pav_rec.pricing_attribute79,
        PRICING_ATTRIBUTE80 = l_def_pav_rec.pricing_attribute80,
        PRICING_ATTRIBUTE81 = l_def_pav_rec.pricing_attribute81,
        PRICING_ATTRIBUTE82 = l_def_pav_rec.pricing_attribute82,
        PRICING_ATTRIBUTE83 = l_def_pav_rec.pricing_attribute83,
        PRICING_ATTRIBUTE84 = l_def_pav_rec.pricing_attribute84,
        PRICING_ATTRIBUTE85 = l_def_pav_rec.pricing_attribute85,
        PRICING_ATTRIBUTE86 = l_def_pav_rec.pricing_attribute86,
        PRICING_ATTRIBUTE87 = l_def_pav_rec.pricing_attribute87,
        PRICING_ATTRIBUTE88 = l_def_pav_rec.pricing_attribute88,
        PRICING_ATTRIBUTE89 = l_def_pav_rec.pricing_attribute89,
        PRICING_ATTRIBUTE90 = l_def_pav_rec.pricing_attribute90,
        PRICING_ATTRIBUTE91 = l_def_pav_rec.pricing_attribute91,
        PRICING_ATTRIBUTE92 = l_def_pav_rec.pricing_attribute92,
        PRICING_ATTRIBUTE93 = l_def_pav_rec.pricing_attribute93,
        PRICING_ATTRIBUTE94 = l_def_pav_rec.pricing_attribute94,
        PRICING_ATTRIBUTE95 = l_def_pav_rec.pricing_attribute95,
        PRICING_ATTRIBUTE96 = l_def_pav_rec.pricing_attribute96,
        PRICING_ATTRIBUTE97 = l_def_pav_rec.pricing_attribute97,
        PRICING_ATTRIBUTE98 = l_def_pav_rec.pricing_attribute98,
        PRICING_ATTRIBUTE99 = l_def_pav_rec.pricing_attribute99,
        PRICING_ATTRIBUTE100 = l_def_pav_rec.pricing_attribute100,
        QUALIFIER_CONTEXT = l_def_pav_rec.qualifier_context,
        QUALIFIER_ATTRIBUTE1 = l_def_pav_rec.qualifier_attribute1,
        QUALIFIER_ATTRIBUTE2 = l_def_pav_rec.qualifier_attribute2,
        CREATED_BY = l_def_pav_rec.created_by,
        QUALIFIER_ATTRIBUTE3 = l_def_pav_rec.qualifier_attribute3,
        CREATION_DATE = l_def_pav_rec.creation_date,
        QUALIFIER_ATTRIBUTE4 = l_def_pav_rec.qualifier_attribute4,
        QUALIFIER_ATTRIBUTE5 = l_def_pav_rec.qualifier_attribute5,
        LAST_UPDATED_BY = l_def_pav_rec.last_updated_by,
        QUALIFIER_ATTRIBUTE6 = l_def_pav_rec.qualifier_attribute6,
        LAST_UPDATE_DATE = l_def_pav_rec.last_update_date,
        QUALIFIER_ATTRIBUTE7 = l_def_pav_rec.qualifier_attribute7,
        QUALIFIER_ATTRIBUTE8 = l_def_pav_rec.qualifier_attribute8,
        QUALIFIER_ATTRIBUTE9 = l_def_pav_rec.qualifier_attribute9,
        QUALIFIER_ATTRIBUTE10 = l_def_pav_rec.qualifier_attribute10,
        QUALIFIER_ATTRIBUTE11 = l_def_pav_rec.qualifier_attribute11,
        QUALIFIER_ATTRIBUTE12 = l_def_pav_rec.qualifier_attribute12,
        QUALIFIER_ATTRIBUTE13 = l_def_pav_rec.qualifier_attribute13,
        QUALIFIER_ATTRIBUTE14 = l_def_pav_rec.qualifier_attribute14,
        QUALIFIER_ATTRIBUTE15 = l_def_pav_rec.qualifier_attribute15,
        QUALIFIER_ATTRIBUTE16 = l_def_pav_rec.qualifier_attribute16,
        QUALIFIER_ATTRIBUTE17 = l_def_pav_rec.qualifier_attribute17,
        QUALIFIER_ATTRIBUTE18 = l_def_pav_rec.qualifier_attribute18,
        QUALIFIER_ATTRIBUTE19 = l_def_pav_rec.qualifier_attribute19,
        QUALIFIER_ATTRIBUTE20 = l_def_pav_rec.qualifier_attribute20,
        QUALIFIER_ATTRIBUTE21 = l_def_pav_rec.qualifier_attribute21,
        QUALIFIER_ATTRIBUTE22 = l_def_pav_rec.qualifier_attribute22,
        QUALIFIER_ATTRIBUTE23 = l_def_pav_rec.qualifier_attribute23,
        QUALIFIER_ATTRIBUTE24 = l_def_pav_rec.qualifier_attribute24,
        QUALIFIER_ATTRIBUTE25 = l_def_pav_rec.qualifier_attribute25,
        QUALIFIER_ATTRIBUTE26 = l_def_pav_rec.qualifier_attribute26,
        QUALIFIER_ATTRIBUTE27 = l_def_pav_rec.qualifier_attribute27,
        QUALIFIER_ATTRIBUTE28 = l_def_pav_rec.qualifier_attribute28,
        QUALIFIER_ATTRIBUTE29 = l_def_pav_rec.qualifier_attribute29,
        QUALIFIER_ATTRIBUTE30 = l_def_pav_rec.qualifier_attribute30,
        QUALIFIER_ATTRIBUTE31 = l_def_pav_rec.qualifier_attribute31,
        QUALIFIER_ATTRIBUTE32 = l_def_pav_rec.qualifier_attribute32,
        QUALIFIER_ATTRIBUTE33 = l_def_pav_rec.qualifier_attribute33,
        QUALIFIER_ATTRIBUTE34 = l_def_pav_rec.qualifier_attribute34,
        QUALIFIER_ATTRIBUTE35 = l_def_pav_rec.qualifier_attribute35,
        QUALIFIER_ATTRIBUTE36 = l_def_pav_rec.qualifier_attribute36,
        QUALIFIER_ATTRIBUTE37 = l_def_pav_rec.qualifier_attribute37,
        QUALIFIER_ATTRIBUTE38 = l_def_pav_rec.qualifier_attribute38,
        QUALIFIER_ATTRIBUTE39 = l_def_pav_rec.qualifier_attribute39,
        QUALIFIER_ATTRIBUTE40 = l_def_pav_rec.qualifier_attribute40,
        QUALIFIER_ATTRIBUTE41 = l_def_pav_rec.qualifier_attribute41,
        QUALIFIER_ATTRIBUTE42 = l_def_pav_rec.qualifier_attribute42,
        QUALIFIER_ATTRIBUTE43 = l_def_pav_rec.qualifier_attribute43,
        QUALIFIER_ATTRIBUTE44 = l_def_pav_rec.qualifier_attribute44,
        QUALIFIER_ATTRIBUTE45 = l_def_pav_rec.qualifier_attribute45,
        QUALIFIER_ATTRIBUTE46 = l_def_pav_rec.qualifier_attribute46,
        QUALIFIER_ATTRIBUTE47 = l_def_pav_rec.qualifier_attribute47,
        QUALIFIER_ATTRIBUTE48 = l_def_pav_rec.qualifier_attribute48,
        QUALIFIER_ATTRIBUTE49 = l_def_pav_rec.qualifier_attribute49,
        QUALIFIER_ATTRIBUTE50 = l_def_pav_rec.qualifier_attribute50,
        QUALIFIER_ATTRIBUTE51 = l_def_pav_rec.qualifier_attribute51,
        QUALIFIER_ATTRIBUTE52 = l_def_pav_rec.qualifier_attribute52,
        QUALIFIER_ATTRIBUTE53 = l_def_pav_rec.qualifier_attribute53,
        QUALIFIER_ATTRIBUTE54 = l_def_pav_rec.qualifier_attribute54,
        QUALIFIER_ATTRIBUTE55 = l_def_pav_rec.qualifier_attribute55,
        QUALIFIER_ATTRIBUTE56 = l_def_pav_rec.qualifier_attribute56,
        QUALIFIER_ATTRIBUTE57 = l_def_pav_rec.qualifier_attribute57,
        QUALIFIER_ATTRIBUTE58 = l_def_pav_rec.qualifier_attribute58,
        QUALIFIER_ATTRIBUTE59 = l_def_pav_rec.qualifier_attribute59,
        QUALIFIER_ATTRIBUTE60 = l_def_pav_rec.qualifier_attribute60,
        QUALIFIER_ATTRIBUTE61 = l_def_pav_rec.qualifier_attribute61,
        QUALIFIER_ATTRIBUTE62 = l_def_pav_rec.qualifier_attribute62,
        QUALIFIER_ATTRIBUTE63 = l_def_pav_rec.qualifier_attribute63,
        QUALIFIER_ATTRIBUTE64 = l_def_pav_rec.qualifier_attribute64,
        QUALIFIER_ATTRIBUTE65 = l_def_pav_rec.qualifier_attribute65,
        QUALIFIER_ATTRIBUTE66 = l_def_pav_rec.qualifier_attribute66,
        QUALIFIER_ATTRIBUTE67 = l_def_pav_rec.qualifier_attribute67,
        QUALIFIER_ATTRIBUTE68 = l_def_pav_rec.qualifier_attribute68,
        QUALIFIER_ATTRIBUTE69 = l_def_pav_rec.qualifier_attribute69,
        QUALIFIER_ATTRIBUTE70 = l_def_pav_rec.qualifier_attribute70,
        QUALIFIER_ATTRIBUTE71 = l_def_pav_rec.qualifier_attribute71,
        QUALIFIER_ATTRIBUTE72 = l_def_pav_rec.qualifier_attribute72,
        QUALIFIER_ATTRIBUTE73 = l_def_pav_rec.qualifier_attribute73,
        QUALIFIER_ATTRIBUTE74 = l_def_pav_rec.qualifier_attribute74,
        QUALIFIER_ATTRIBUTE75 = l_def_pav_rec.qualifier_attribute75,
        QUALIFIER_ATTRIBUTE76 = l_def_pav_rec.qualifier_attribute76,
        QUALIFIER_ATTRIBUTE77 = l_def_pav_rec.qualifier_attribute77,
        QUALIFIER_ATTRIBUTE78 = l_def_pav_rec.qualifier_attribute78,
        QUALIFIER_ATTRIBUTE79 = l_def_pav_rec.qualifier_attribute79,
        QUALIFIER_ATTRIBUTE80 = l_def_pav_rec.qualifier_attribute80,
        QUALIFIER_ATTRIBUTE81 = l_def_pav_rec.qualifier_attribute81,
        QUALIFIER_ATTRIBUTE82 = l_def_pav_rec.qualifier_attribute82,
        QUALIFIER_ATTRIBUTE83 = l_def_pav_rec.qualifier_attribute83,
        QUALIFIER_ATTRIBUTE84 = l_def_pav_rec.qualifier_attribute84,
        QUALIFIER_ATTRIBUTE85 = l_def_pav_rec.qualifier_attribute85,
        QUALIFIER_ATTRIBUTE86 = l_def_pav_rec.qualifier_attribute86,
        QUALIFIER_ATTRIBUTE87 = l_def_pav_rec.qualifier_attribute87,
        QUALIFIER_ATTRIBUTE88 = l_def_pav_rec.qualifier_attribute88,
        QUALIFIER_ATTRIBUTE89 = l_def_pav_rec.qualifier_attribute89,
        QUALIFIER_ATTRIBUTE90 = l_def_pav_rec.qualifier_attribute90,
        QUALIFIER_ATTRIBUTE91 = l_def_pav_rec.qualifier_attribute91,
        QUALIFIER_ATTRIBUTE92 = l_def_pav_rec.qualifier_attribute92,
        QUALIFIER_ATTRIBUTE93 = l_def_pav_rec.qualifier_attribute93,
        QUALIFIER_ATTRIBUTE94 = l_def_pav_rec.qualifier_attribute94,
        QUALIFIER_ATTRIBUTE95 = l_def_pav_rec.qualifier_attribute95,
        QUALIFIER_ATTRIBUTE96 = l_def_pav_rec.qualifier_attribute96,
        QUALIFIER_ATTRIBUTE97 = l_def_pav_rec.qualifier_attribute97,
        QUALIFIER_ATTRIBUTE98 = l_def_pav_rec.qualifier_attribute98,
        QUALIFIER_ATTRIBUTE99 = l_def_pav_rec.qualifier_attribute99,
        QUALIFIER_ATTRIBUTE100 = l_def_pav_rec.qualifier_attribute100,
        LAST_UPDATE_LOGIN = l_def_pav_rec.last_update_login,
 REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pav_rec.request_id),
PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pav_rec.program_application_id),
PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pav_rec.program_id),
PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pav_rec.program_update_date,SYSDATE),
 OBJECT_VERSION_NUMBER = l_def_pav_rec.object_version_number
     WHERE ID = l_def_pav_rec.id;

Line: 2801


  END update_row;

Line: 2805


  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_pavv_rec                     IN pavv_rec_type,
    x_pavv_rec                     OUT NOCOPY pavv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2815


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

Line: 2829


      l_pavv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2830


      l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2831


      l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3683


      IF (x_pavv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_pavv_rec.last_updated_by := l_pavv_rec.last_updated_by;

Line: 3687


      IF (x_pavv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_pavv_rec.last_update_date := l_pavv_rec.last_update_date;

Line: 3691


      IF (x_pavv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_pavv_rec.last_update_login := l_pavv_rec.last_update_login;

Line: 3703


     IF (x_pavv_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_pavv_rec.program_update_date := l_pavv_rec.program_update_date;

Line: 3782


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_pav_rec,
      lx_pav_rec
    );

Line: 3829


  END update_row;

Line: 3833


  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_pavv_tbl                     IN pavv_tbl_type,
    x_pavv_tbl                     OUT NOCOPY pavv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3843


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

Line: 3852


        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_pavv_rec                     => p_pavv_tbl(i),
          x_pavv_rec                     => x_pavv_tbl(i));

Line: 3895


  END update_row;

Line: 3903


  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_pav_rec                      IN pav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3911


    l_api_name                     CONSTANT VARCHAR2(30) := 'VALUES_delete_row';

Line: 3925


    DELETE FROM OKC_PRICE_ATT_VALUES
     WHERE ID = l_pav_rec.id;

Line: 3960


  END delete_row;

Line: 3964


  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_pavv_rec                     IN pavv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3973


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

Line: 3997


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_pav_rec
    );

Line: 4041


  END delete_row;

Line: 4045


  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_pavv_tbl                     IN pavv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4054


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

Line: 4063


        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_pavv_rec                     => p_pavv_tbl(i));

Line: 4105


  END delete_row;

Line: 4110


PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_pavv_tbl pavv_tbl_type) IS
BEGIN
----need to substitue
 OKC_SPLIT2_PAV_PVT.INSERT_ROW_UPG(x_return_status ,p_pavv_tbl );

Line: 4116


END INSERT_ROW_UPG;

Line: 4127


INSERT INTO okc_price_att_values_h
  (
        id,
        flex_title,
        pricing_context,
        pricing_attribute1,
        chr_id,
        pricing_attribute2,
        cle_id,
        pricing_attribute3,
        pricing_attribute4,
        pricing_attribute5,
        pricing_attribute6,
        pricing_attribute7,
        pricing_attribute8,
        pricing_attribute9,
        pricing_attribute10,
        pricing_attribute11,
        pricing_attribute12,
        pricing_attribute13,
        pricing_attribute14,
        pricing_attribute15,
        pricing_attribute16,
        pricing_attribute17,
        pricing_attribute18,
        pricing_attribute19,
        pricing_attribute20,
        pricing_attribute21,
        pricing_attribute22,
        pricing_attribute23,
        pricing_attribute24,
        pricing_attribute25,
        pricing_attribute26,
        pricing_attribute27,
        pricing_attribute28,
        pricing_attribute29,
        pricing_attribute30,
        pricing_attribute31,
        pricing_attribute32,
        pricing_attribute33,
        pricing_attribute34,
        pricing_attribute35,
        pricing_attribute36,
        pricing_attribute37,
        pricing_attribute38,
        pricing_attribute39,
        pricing_attribute40,
        pricing_attribute41,
        pricing_attribute42,
        pricing_attribute43,
        pricing_attribute44,
        pricing_attribute45,
        pricing_attribute46,
        pricing_attribute47,
        pricing_attribute48,
        pricing_attribute49,
        pricing_attribute50,
        pricing_attribute51,
        pricing_attribute52,
        pricing_attribute53,
        pricing_attribute54,
        pricing_attribute55,
        pricing_attribute56,
        pricing_attribute57,
        pricing_attribute58,
        pricing_attribute59,
        pricing_attribute60,
        pricing_attribute61,
        pricing_attribute62,
        pricing_attribute63,
        pricing_attribute64,
        pricing_attribute65,
        pricing_attribute66,
        pricing_attribute67,
        pricing_attribute68,
        pricing_attribute69,
        pricing_attribute70,
        pricing_attribute71,
        pricing_attribute72,
        pricing_attribute73,
        pricing_attribute74,
        pricing_attribute75,
        pricing_attribute76,
        pricing_attribute77,
        pricing_attribute78,
        pricing_attribute79,
        pricing_attribute80,
        pricing_attribute81,
        pricing_attribute82,
        pricing_attribute83,
        pricing_attribute84,
        pricing_attribute85,
        pricing_attribute86,
        pricing_attribute87,
        pricing_attribute88,
        pricing_attribute89,
        pricing_attribute90,
        pricing_attribute91,
        pricing_attribute92,
        pricing_attribute93,
        pricing_attribute94,
        pricing_attribute95,
        pricing_attribute96,
        pricing_attribute97,
        pricing_attribute98,
        pricing_attribute99,
        pricing_attribute100,
        qualifier_context,
        qualifier_attribute1,
        qualifier_attribute2,
        created_by,
        qualifier_attribute3,
        creation_date,
        qualifier_attribute4,
        qualifier_attribute5,
        last_updated_by,
        qualifier_attribute6,
        last_update_date,
        qualifier_attribute7,
        qualifier_attribute8,
        qualifier_attribute9,
        qualifier_attribute10,
        qualifier_attribute11,
        qualifier_attribute12,
        qualifier_attribute13,
        qualifier_attribute14,
        qualifier_attribute15,
        qualifier_attribute16,
        qualifier_attribute17,
        qualifier_attribute18,
        qualifier_attribute19,
        qualifier_attribute20,
        qualifier_attribute21,
        qualifier_attribute22,
        qualifier_attribute23,
        qualifier_attribute24,
        qualifier_attribute25,
        qualifier_attribute26,
        qualifier_attribute27,
        qualifier_attribute28,
        qualifier_attribute29,
        qualifier_attribute30,
        qualifier_attribute31,
        qualifier_attribute32,
        qualifier_attribute33,
        qualifier_attribute34,
        qualifier_attribute35,
        qualifier_attribute36,
        qualifier_attribute37,
        qualifier_attribute38,
        qualifier_attribute39,
        qualifier_attribute40,
        qualifier_attribute41,
        qualifier_attribute42,
        qualifier_attribute43,
        qualifier_attribute44,
        qualifier_attribute45,
        qualifier_attribute46,
        qualifier_attribute47,
        qualifier_attribute48,
        qualifier_attribute49,
        qualifier_attribute50,
        qualifier_attribute51,
        qualifier_attribute52,
        qualifier_attribute53,
        qualifier_attribute54,
        qualifier_attribute55,
        qualifier_attribute56,
        qualifier_attribute57,
        qualifier_attribute58,
        qualifier_attribute59,
        qualifier_attribute60,
        qualifier_attribute61,
        qualifier_attribute62,
        qualifier_attribute63,
        qualifier_attribute64,
        qualifier_attribute65,
        qualifier_attribute66,
        qualifier_attribute67,
        qualifier_attribute68,
        qualifier_attribute69,
        qualifier_attribute70,
        qualifier_attribute71,
        qualifier_attribute72,
        qualifier_attribute73,
        qualifier_attribute74,
        qualifier_attribute75,
        qualifier_attribute76,
        qualifier_attribute77,
        qualifier_attribute78,
        qualifier_attribute79,
        qualifier_attribute80,
        qualifier_attribute81,
        qualifier_attribute82,
        qualifier_attribute83,
        qualifier_attribute84,
        qualifier_attribute85,
        qualifier_attribute86,
        qualifier_attribute87,
        qualifier_attribute88,
        qualifier_attribute89,
        qualifier_attribute90,
        qualifier_attribute91,
        qualifier_attribute92,
        qualifier_attribute93,
        qualifier_attribute94,
        qualifier_attribute95,
        qualifier_attribute96,
        qualifier_attribute97,
        qualifier_attribute98,
        qualifier_attribute99,
        qualifier_attribute100,
        last_update_login,
        program_application_id,
        program_id,
        program_update_date,
        request_id,
       object_version_number,
       major_version
      )

SELECT

        id,
        flex_title,
        pricing_context,
        pricing_attribute1,
        chr_id,
        pricing_attribute2,
        cle_id,
        pricing_attribute3,
        pricing_attribute4,
        pricing_attribute5,
        pricing_attribute6,
        pricing_attribute7,
        pricing_attribute8,
        pricing_attribute9,
        pricing_attribute10,
        pricing_attribute11,
        pricing_attribute12,
        pricing_attribute13,
        pricing_attribute14,
        pricing_attribute15,
        pricing_attribute16,
        pricing_attribute17,
        pricing_attribute18,
        pricing_attribute19,
        pricing_attribute20,
        pricing_attribute21,
        pricing_attribute22,
        pricing_attribute23,
        pricing_attribute24,
        pricing_attribute25,
        pricing_attribute26,
        pricing_attribute27,
        pricing_attribute28,
        pricing_attribute29,
        pricing_attribute30,
        pricing_attribute31,
        pricing_attribute32,
        pricing_attribute33,
        pricing_attribute34,
        pricing_attribute35,
        pricing_attribute36,
        pricing_attribute37,
        pricing_attribute38,
        pricing_attribute39,
        pricing_attribute40,
        pricing_attribute41,
        pricing_attribute42,
        pricing_attribute43,
        pricing_attribute44,
        pricing_attribute45,
        pricing_attribute46,
        pricing_attribute47,
        pricing_attribute48,
        pricing_attribute49,
        pricing_attribute50,
        pricing_attribute51,
        pricing_attribute52,
        pricing_attribute53,
        pricing_attribute54,
        pricing_attribute55,
        pricing_attribute56,
        pricing_attribute57,
        pricing_attribute58,
        pricing_attribute59,
        pricing_attribute60,
        pricing_attribute61,
        pricing_attribute62,
        pricing_attribute63,
        pricing_attribute64,
        pricing_attribute65,
        pricing_attribute66,
        pricing_attribute67,
        pricing_attribute68,
        pricing_attribute69,
        pricing_attribute70,
        pricing_attribute71,
        pricing_attribute72,
        pricing_attribute73,
        pricing_attribute74,
        pricing_attribute75,
        pricing_attribute76,
        pricing_attribute77,
        pricing_attribute78,
        pricing_attribute79,
        pricing_attribute80,
        pricing_attribute81,
        pricing_attribute82,
        pricing_attribute83,
        pricing_attribute84,
        pricing_attribute85,
        pricing_attribute86,
        pricing_attribute87,
        pricing_attribute88,
        pricing_attribute89,
        pricing_attribute90,
        pricing_attribute91,
        pricing_attribute92,
        pricing_attribute93,
        pricing_attribute94,
        pricing_attribute95,
        pricing_attribute96,
        pricing_attribute97,
        pricing_attribute98,
        pricing_attribute99,
        pricing_attribute100,
        qualifier_context,
        qualifier_attribute1,
        qualifier_attribute2,
        created_by,
        qualifier_attribute3,
        creation_date,
        qualifier_attribute4,
        qualifier_attribute5,
        last_updated_by,
        qualifier_attribute6,
        last_update_date,
        qualifier_attribute7,
        qualifier_attribute8,
        qualifier_attribute9,
        qualifier_attribute10,
        qualifier_attribute11,
        qualifier_attribute12,
        qualifier_attribute13,
        qualifier_attribute14,
        qualifier_attribute15,
        qualifier_attribute16,
        qualifier_attribute17,
        qualifier_attribute18,
        qualifier_attribute19,
        qualifier_attribute20,
        qualifier_attribute21,
        qualifier_attribute22,
        qualifier_attribute23,
        qualifier_attribute24,
        qualifier_attribute25,
        qualifier_attribute26,
        qualifier_attribute27,
        qualifier_attribute28,
        qualifier_attribute29,
        qualifier_attribute30,
        qualifier_attribute31,
        qualifier_attribute32,
        qualifier_attribute33,
        qualifier_attribute34,
        qualifier_attribute35,
        qualifier_attribute36,
        qualifier_attribute37,
        qualifier_attribute38,
        qualifier_attribute39,
        qualifier_attribute40,
        qualifier_attribute41,
        qualifier_attribute42,
        qualifier_attribute43,
        qualifier_attribute44,
        qualifier_attribute45,
        qualifier_attribute46,
        qualifier_attribute47,
        qualifier_attribute48,
        qualifier_attribute49,
        qualifier_attribute50,
        qualifier_attribute51,
        qualifier_attribute52,
        qualifier_attribute53,
        qualifier_attribute54,
        qualifier_attribute55,
        qualifier_attribute56,
        qualifier_attribute57,
        qualifier_attribute58,
        qualifier_attribute59,
        qualifier_attribute60,
        qualifier_attribute61,
        qualifier_attribute62,
        qualifier_attribute63,
        qualifier_attribute64,
        qualifier_attribute65,
        qualifier_attribute66,
        qualifier_attribute67,
        qualifier_attribute68,
        qualifier_attribute69,
        qualifier_attribute70,
        qualifier_attribute71,
        qualifier_attribute72,
        qualifier_attribute73,
        qualifier_attribute74,
        qualifier_attribute75,
        qualifier_attribute76,
        qualifier_attribute77,
        qualifier_attribute78,
        qualifier_attribute79,
        qualifier_attribute80,
        qualifier_attribute81,
        qualifier_attribute82,
        qualifier_attribute83,
        qualifier_attribute84,
        qualifier_attribute85,
        qualifier_attribute86,
        qualifier_attribute87,
        qualifier_attribute88,
        qualifier_attribute89,
        qualifier_attribute90,
        qualifier_attribute91,
        qualifier_attribute92,
        qualifier_attribute93,
        qualifier_attribute94,
        qualifier_attribute95,
        qualifier_attribute96,
        qualifier_attribute97,
        qualifier_attribute98,
        qualifier_attribute99,
        qualifier_attribute100,
        last_update_login,
        program_application_id,
        program_id,
        program_update_date,
        request_id,
        object_version_number,
        p_major_version
FROM    okc_price_att_values
WHERE   chr_id = p_chr_id
UNION     /* bugfix 2138898 - OR is replaced by UNION */
SELECT
        id,
        flex_title,
        pricing_context,
        pricing_attribute1,
        chr_id,
        pricing_attribute2,
        cle_id,
        pricing_attribute3,
        pricing_attribute4,
        pricing_attribute5,
        pricing_attribute6,
        pricing_attribute7,
        pricing_attribute8,
        pricing_attribute9,
        pricing_attribute10,
        pricing_attribute11,
        pricing_attribute12,
        pricing_attribute13,
        pricing_attribute14,
        pricing_attribute15,
        pricing_attribute16,
        pricing_attribute17,
        pricing_attribute18,
        pricing_attribute19,
        pricing_attribute20,
        pricing_attribute21,
        pricing_attribute22,
        pricing_attribute23,
        pricing_attribute24,
        pricing_attribute25,
        pricing_attribute26,
        pricing_attribute27,
        pricing_attribute28,
        pricing_attribute29,
        pricing_attribute30,
        pricing_attribute31,
        pricing_attribute32,
        pricing_attribute33,
        pricing_attribute34,
        pricing_attribute35,
        pricing_attribute36,
        pricing_attribute37,
        pricing_attribute38,
        pricing_attribute39,
        pricing_attribute40,
        pricing_attribute41,
        pricing_attribute42,
        pricing_attribute43,
        pricing_attribute44,
        pricing_attribute45,
        pricing_attribute46,
        pricing_attribute47,
        pricing_attribute48,
        pricing_attribute49,
        pricing_attribute50,
        pricing_attribute51,
        pricing_attribute52,
        pricing_attribute53,
        pricing_attribute54,
        pricing_attribute55,
        pricing_attribute56,
        pricing_attribute57,
        pricing_attribute58,
        pricing_attribute59,
        pricing_attribute60,
        pricing_attribute61,
        pricing_attribute62,
        pricing_attribute63,
        pricing_attribute64,
        pricing_attribute65,
        pricing_attribute66,
        pricing_attribute67,
        pricing_attribute68,
        pricing_attribute69,
        pricing_attribute70,
        pricing_attribute71,
        pricing_attribute72,
        pricing_attribute73,
        pricing_attribute74,
        pricing_attribute75,
        pricing_attribute76,
        pricing_attribute77,
        pricing_attribute78,
        pricing_attribute79,
        pricing_attribute80,
        pricing_attribute81,
        pricing_attribute82,
        pricing_attribute83,
        pricing_attribute84,
        pricing_attribute85,
        pricing_attribute86,
        pricing_attribute87,
        pricing_attribute88,
        pricing_attribute89,
        pricing_attribute90,
        pricing_attribute91,
        pricing_attribute92,
        pricing_attribute93,
        pricing_attribute94,
        pricing_attribute95,
        pricing_attribute96,
        pricing_attribute97,
        pricing_attribute98,
        pricing_attribute99,
        pricing_attribute100,
        qualifier_context,
        qualifier_attribute1,
        qualifier_attribute2,
        created_by,
        qualifier_attribute3,
        creation_date,
        qualifier_attribute4,
        qualifier_attribute5,
        last_updated_by,
        qualifier_attribute6,
        last_update_date,
        qualifier_attribute7,
        qualifier_attribute8,
        qualifier_attribute9,
        qualifier_attribute10,
        qualifier_attribute11,
        qualifier_attribute12,
        qualifier_attribute13,
        qualifier_attribute14,
        qualifier_attribute15,
        qualifier_attribute16,
        qualifier_attribute17,
        qualifier_attribute18,
        qualifier_attribute19,
        qualifier_attribute20,
        qualifier_attribute21,
        qualifier_attribute22,
        qualifier_attribute23,
        qualifier_attribute24,
        qualifier_attribute25,
        qualifier_attribute26,
        qualifier_attribute27,
        qualifier_attribute28,
        qualifier_attribute29,
        qualifier_attribute30,
        qualifier_attribute31,
        qualifier_attribute32,
        qualifier_attribute33,
        qualifier_attribute34,
        qualifier_attribute35,
        qualifier_attribute36,
        qualifier_attribute37,
        qualifier_attribute38,
        qualifier_attribute39,
        qualifier_attribute40,
        qualifier_attribute41,
        qualifier_attribute42,
        qualifier_attribute43,
        qualifier_attribute44,
        qualifier_attribute45,
        qualifier_attribute46,
        qualifier_attribute47,
        qualifier_attribute48,
        qualifier_attribute49,
        qualifier_attribute50,
        qualifier_attribute51,
        qualifier_attribute52,
        qualifier_attribute53,
        qualifier_attribute54,
        qualifier_attribute55,
        qualifier_attribute56,
        qualifier_attribute57,
        qualifier_attribute58,
        qualifier_attribute59,
        qualifier_attribute60,
        qualifier_attribute61,
        qualifier_attribute62,
        qualifier_attribute63,
        qualifier_attribute64,
        qualifier_attribute65,
        qualifier_attribute66,
        qualifier_attribute67,
        qualifier_attribute68,
        qualifier_attribute69,
        qualifier_attribute70,
        qualifier_attribute71,
        qualifier_attribute72,
        qualifier_attribute73,
        qualifier_attribute74,
        qualifier_attribute75,
        qualifier_attribute76,
        qualifier_attribute77,
        qualifier_attribute78,
        qualifier_attribute79,
        qualifier_attribute80,
        qualifier_attribute81,
        qualifier_attribute82,
        qualifier_attribute83,
        qualifier_attribute84,
        qualifier_attribute85,
        qualifier_attribute86,
        qualifier_attribute87,
        qualifier_attribute88,
        qualifier_attribute89,
        qualifier_attribute90,
        qualifier_attribute91,
        qualifier_attribute92,
        qualifier_attribute93,
        qualifier_attribute94,
        qualifier_attribute95,
        qualifier_attribute96,
        qualifier_attribute97,
        qualifier_attribute98,
        qualifier_attribute99,
        qualifier_attribute100,
        last_update_login,
        program_application_id,
        program_id,
        program_update_date,
        request_id,
        object_version_number,
        p_major_version
FROM    okc_price_att_values
WHERE   cle_id IN
           (SELECT id
            FROM OKC_K_LINES_B
            WHERE dnz_chr_id = p_chr_id
           );