[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
p_to.program_update_date:= p_from.program_update_date;
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;
PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_pavv_tbl OKC_PAV_PVT.pavv_tbl_type) IS
l_tabsize NUMBER := p_pavv_tbl.COUNT;
in_last_updated_by OKC_DATATYPES.NumberTabTyp;
in_last_update_date OKC_DATATYPES.DateTabTyp;
in_last_update_login OKC_DATATYPES.NumberTabTyp;
in_program_update_date OKC_DATATYPES.DateTabTyp;
in_last_updated_by (j) := p_pavv_tbl(i).last_updated_by;
in_last_update_date (j) := p_pavv_tbl(i).last_update_date;
in_last_update_login (j) := p_pavv_tbl(i).last_update_login;
in_program_update_date (j) := p_pavv_tbl(i).program_update_date;
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)
);
END INSERT_ROW_UPG;