APPS.OKC_PAV_PVT SQL Statements

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

Line: 45

    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
        FROM Okc_Price_Att_Values
     WHERE okc_price_att_values.id = p_id;

Line: 384

              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,
              l_pav_rec.PROGRAM_APPLICATION_ID,
              l_pav_rec.PROGRAM_ID,
              l_pav_rec.PROGRAM_UPDATE_DATE,
              l_pav_rec.REQUEST_ID,
              l_pav_rec.OBJECT_VERSION_NUMBER;

Line: 507

    SELECT
            ID,
            CHR_ID,
            CLE_ID,
            FLEX_TITLE,
            PRICING_CONTEXT,
            PRICING_ATTRIBUTE1,
            PRICING_ATTRIBUTE2,
            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,
            QUALIFIER_ATTRIBUTE3,
            QUALIFIER_ATTRIBUTE4,
            QUALIFIER_ATTRIBUTE5,
            QUALIFIER_ATTRIBUTE6,
            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,
            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_Att_Values_V
     WHERE okc_price_att_values_v.id = p_id;

Line: 941

              l_pavv_rec.LAST_UPDATED_BY,
              l_pavv_rec.LAST_UPDATE_DATE,
              l_pavv_rec.LAST_UPDATE_LOGIN,
              l_pavv_rec.PROGRAM_APPLICATION_ID,
              l_pavv_rec.PROGRAM_ID,
              l_pavv_rec.PROGRAM_UPDATE_DATE,
              l_pavv_rec.REQUEST_ID,
              l_pavv_rec.OBJECT_VERSION_NUMBER;

Line: 1591

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

Line: 1594

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

Line: 1597

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

Line: 1606

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

Line: 1714

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

Line: 1720

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

Line: 1882

    p_to.last_updated_by := p_from.last_updated_by;

Line: 1884

    p_to.last_update_date := p_from.last_update_date;

Line: 1979

    p_to.last_update_login := p_from.last_update_login;

Line: 1982

    p_to.program_update_date:= p_from.program_update_date;

Line: 2104

    p_to.last_updated_by := p_from.last_updated_by;

Line: 2106

    p_to.last_update_date := p_from.last_update_date;

Line: 2201

    p_to.last_update_login := p_from.last_update_login;

Line: 2204

    p_to.program_update_date:= p_from.program_update_date;

Line: 2359

  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: 2368

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

Line: 2404

    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: 2872

  END insert_row;

Line: 2876

  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: 2886

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

Line: 2902

      l_pavv_rec.LAST_UPDATE_DATE := l_pavv_rec.CREATION_DATE;

Line: 2903

      l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2904

      l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2968

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

Line: 3016

  END insert_row;

Line: 3020

  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: 3030

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

Line: 3039

        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: 3082

  END insert_row;

Line: 3100

    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: 3107

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_PRICE_ATT_VALUES
    WHERE ID = p_pav_rec.id;

Line: 3149

      OKC_API.set_message(G_APP_NAME,'OKC_FORM_RECORD_DELETED');

Line: 3158

      OKC_API.set_message(G_FND_APP,G_RECORD_LOGICALLY_DELETED);

Line: 3346

  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: 3355

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

Line: 3829

      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: 3837

      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: 4217

      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: 4229

   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: 4281

    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: 4532

  END update_row;

Line: 4536

  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: 4546

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

Line: 4560

      l_pavv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 4561

      l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 4562

      l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 5414

      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: 5418

      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: 5422

      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: 5434

     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: 5513

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

Line: 5560

  END update_row;

Line: 5564

  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: 5574

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

Line: 5583

        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: 5626

  END update_row;

Line: 5634

  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: 5642

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

Line: 5656

    DELETE FROM OKC_PRICE_ATT_VALUES
     WHERE ID = l_pav_rec.id;

Line: 5691

  END delete_row;

Line: 5695

  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: 5704

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

Line: 5728

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

Line: 5772

  END delete_row;

Line: 5776

  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: 5785

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

Line: 5794

        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: 5836

  END delete_row;

Line: 5841

PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_pavv_tbl pavv_tbl_type) IS
  l_tabsize NUMBER := p_pavv_tbl.COUNT;

Line: 6053

  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;

Line: 6054

  in_last_update_date              OKC_DATATYPES.DateTabTyp;

Line: 6055

  in_last_update_login             OKC_DATATYPES.NumberTabTyp;

Line: 6058

  in_program_update_date          OKC_DATATYPES.DateTabTyp;

Line: 6278

    in_last_updated_by          (j) := p_pavv_tbl(i).last_updated_by;

Line: 6279

    in_last_update_date         (j) := p_pavv_tbl(i).last_update_date;

Line: 6280

    in_last_update_login        (j) := p_pavv_tbl(i).last_update_login;

Line: 6283

    in_program_update_date        (j) := p_pavv_tbl(i).program_update_date;

Line: 6290

    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 (
        in_id(i),
        in_flex_title(i),
        in_pricing_context(i),
        in_pricing_attribute1(i),
        in_chr_id(i),
        in_pricing_attribute2(i),
        in_cle_id(i),
        in_pricing_attribute3(i),
        in_pricing_attribute4(i),
        in_pricing_attribute5(i),
        in_pricing_attribute6(i),
        in_pricing_attribute7(i),
        in_pricing_attribute8(i),
        in_pricing_attribute9(i),
        in_pricing_attribute10(i),
        in_pricing_attribute11(i),
        in_pricing_attribute12(i),
        in_pricing_attribute13(i),
        in_pricing_attribute14(i),
        in_pricing_attribute15(i),
        in_pricing_attribute16(i),
        in_pricing_attribute17(i),
        in_pricing_attribute18(i),
        in_pricing_attribute19(i),
        in_pricing_attribute20(i),
        in_pricing_attribute21(i),
        in_pricing_attribute22(i),
        in_pricing_attribute23(i),
        in_pricing_attribute24(i),
        in_pricing_attribute25(i),
        in_pricing_attribute26(i),
        in_pricing_attribute27(i),
        in_pricing_attribute28(i),
        in_pricing_attribute29(i),
        in_pricing_attribute30(i),
        in_pricing_attribute31(i),
        in_pricing_attribute32(i),
        in_pricing_attribute33(i),
        in_pricing_attribute34(i),
        in_pricing_attribute35(i),
        in_pricing_attribute36(i),
        in_pricing_attribute37(i),
        in_pricing_attribute38(i),
        in_pricing_attribute39(i),
        in_pricing_attribute40(i),
        in_pricing_attribute41(i),
        in_pricing_attribute42(i),
        in_pricing_attribute43(i),
        in_pricing_attribute44(i),
        in_pricing_attribute45(i),
        in_pricing_attribute46(i),
        in_pricing_attribute47(i),
        in_pricing_attribute48(i),
        in_pricing_attribute49(i),
        in_pricing_attribute50(i),
        in_pricing_attribute51(i),
        in_pricing_attribute52(i),
        in_pricing_attribute53(i),
        in_pricing_attribute54(i),
        in_pricing_attribute55(i),
        in_pricing_attribute56(i),
        in_pricing_attribute57(i),
        in_pricing_attribute58(i),
        in_pricing_attribute59(i),
        in_pricing_attribute60(i),
        in_pricing_attribute61(i),
        in_pricing_attribute62(i),
        in_pricing_attribute63(i),
        in_pricing_attribute64(i),
        in_pricing_attribute65(i),
        in_pricing_attribute66(i),
        in_pricing_attribute67(i),
        in_pricing_attribute68(i),
        in_pricing_attribute69(i),
        in_pricing_attribute70(i),
        in_pricing_attribute71(i),
        in_pricing_attribute72(i),
        in_pricing_attribute73(i),
        in_pricing_attribute74(i),
        in_pricing_attribute75(i),
        in_pricing_attribute76(i),
        in_pricing_attribute77(i),
        in_pricing_attribute78(i),
        in_pricing_attribute79(i),
        in_pricing_attribute80(i),
        in_pricing_attribute81(i),
        in_pricing_attribute82(i),
        in_pricing_attribute83(i),
        in_pricing_attribute84(i),
        in_pricing_attribute85(i),
        in_pricing_attribute86(i),
        in_pricing_attribute87(i),
        in_pricing_attribute88(i),
        in_pricing_attribute89(i),
        in_pricing_attribute90(i),
        in_pricing_attribute91(i),
        in_pricing_attribute92(i),
        in_pricing_attribute93(i),
        in_pricing_attribute94(i),
        in_pricing_attribute95(i),
        in_pricing_attribute96(i),
        in_pricing_attribute97(i),
        in_pricing_attribute98(i),
        in_pricing_attribute99(i),
        in_pricing_attribute100(i),
        in_qualifier_context(i),
        in_qualifier_attribute1(i),
        in_qualifier_attribute2(i),
        in_created_by(i),
        in_qualifier_attribute3(i),
        in_creation_date(i),
        in_qualifier_attribute4(i),
        in_qualifier_attribute5(i),
        in_last_updated_by(i),
        in_qualifier_attribute6(i),
        in_last_update_date(i),
        in_qualifier_attribute7(i),
        in_qualifier_attribute8(i),
        in_qualifier_attribute9(i),
        in_qualifier_attribute10(i),
        in_qualifier_attribute11(i),
        in_qualifier_attribute12(i),
        in_qualifier_attribute13(i),
        in_qualifier_attribute14(i),
        in_qualifier_attribute15(i),
        in_qualifier_attribute16(i),
        in_qualifier_attribute17(i),
        in_qualifier_attribute18(i),
        in_qualifier_attribute19(i),
        in_qualifier_attribute20(i),
        in_qualifier_attribute21(i),
        in_qualifier_attribute22(i),
        in_qualifier_attribute23(i),
        in_qualifier_attribute24(i),
        in_qualifier_attribute25(i),
        in_qualifier_attribute26(i),
        in_qualifier_attribute27(i),
        in_qualifier_attribute28(i),
        in_qualifier_attribute29(i),
        in_qualifier_attribute30(i),
        in_qualifier_attribute31(i),
        in_qualifier_attribute32(i),
        in_qualifier_attribute33(i),
        in_qualifier_attribute34(i),
        in_qualifier_attribute35(i),
        in_qualifier_attribute36(i),
        in_qualifier_attribute37(i),
        in_qualifier_attribute38(i),
        in_qualifier_attribute39(i),
        in_qualifier_attribute40(i),
        in_qualifier_attribute41(i),
        in_qualifier_attribute42(i),
        in_qualifier_attribute43(i),
        in_qualifier_attribute44(i),
        in_qualifier_attribute45(i),
        in_qualifier_attribute46(i),
        in_qualifier_attribute47(i),
        in_qualifier_attribute48(i),
        in_qualifier_attribute49(i),
        in_qualifier_attribute50(i),
        in_qualifier_attribute51(i),
        in_qualifier_attribute52(i),
        in_qualifier_attribute53(i),
        in_qualifier_attribute54(i),
        in_qualifier_attribute55(i),
        in_qualifier_attribute56(i),
        in_qualifier_attribute57(i),
        in_qualifier_attribute58(i),
        in_qualifier_attribute59(i),
        in_qualifier_attribute60(i),
        in_qualifier_attribute61(i),
        in_qualifier_attribute62(i),
        in_qualifier_attribute63(i),
        in_qualifier_attribute64(i),
        in_qualifier_attribute65(i),
        in_qualifier_attribute66(i),
        in_qualifier_attribute67(i),
        in_qualifier_attribute68(i),
        in_qualifier_attribute69(i),
        in_qualifier_attribute70(i),
        in_qualifier_attribute71(i),
        in_qualifier_attribute72(i),
        in_qualifier_attribute73(i),
        in_qualifier_attribute74(i),
        in_qualifier_attribute75(i),
        in_qualifier_attribute76(i),
        in_qualifier_attribute77(i),
        in_qualifier_attribute78(i),
        in_qualifier_attribute79(i),
        in_qualifier_attribute80(i),
        in_qualifier_attribute81(i),
        in_qualifier_attribute82(i),
        in_qualifier_attribute83(i),
        in_qualifier_attribute84(i),
        in_qualifier_attribute85(i),
        in_qualifier_attribute86(i),
        in_qualifier_attribute87(i),
        in_qualifier_attribute88(i),
        in_qualifier_attribute89(i),
        in_qualifier_attribute90(i),
        in_qualifier_attribute91(i),
        in_qualifier_attribute92(i),
        in_qualifier_attribute93(i),
        in_qualifier_attribute94(i),
        in_qualifier_attribute95(i),
        in_qualifier_attribute96(i),
        in_qualifier_attribute97(i),
        in_qualifier_attribute98(i),
        in_qualifier_attribute99(i),
        in_qualifier_attribute100(i),
        in_last_update_login(i),
        in_program_application_id(i),
     in_program_id(i),
     in_program_update_date(i),
      in_request_id(i),
      in_object_version_number(i)
 );

Line: 6742

END INSERT_ROW_UPG;

Line: 6753

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
           );

Line: 7446

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
      )
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
FROM    okc_price_att_values_h
WHERE   chr_id = p_chr_id
AND     major_version = p_major_version
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
FROM    okc_price_att_values_h
WHERE   cle_id IN
           (SELECT id
            FROM OKC_K_LINES_B
            WHERE dnz_chr_id = p_chr_id
           )
AND     major_version = p_major_version;