[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
px_PRICE_ATTRIBUTE_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
p_CREATION_DATE DATE,
p_CREATED_BY NUMBER,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATED_BY NUMBER,
p_LAST_UPDATE_LOGIN NUMBER,
p_PROGRAM_APPLICATION_ID NUMBER,
p_PROGRAM_ID NUMBER,
p_PROGRAM_UPDATE_DATE DATE,
p_REQUEST_ID NUMBER,
p_QUOTE_HEADER_ID NUMBER,
p_QUOTE_LINE_ID NUMBER,
p_FLEX_TITLE VARCHAR2,
p_PRICING_CONTEXT VARCHAR2,
p_PRICING_ATTRIBUTE1 VARCHAR2,
p_PRICING_ATTRIBUTE2 VARCHAR2,
p_PRICING_ATTRIBUTE3 VARCHAR2,
p_PRICING_ATTRIBUTE4 VARCHAR2,
p_PRICING_ATTRIBUTE5 VARCHAR2,
p_PRICING_ATTRIBUTE6 VARCHAR2,
p_PRICING_ATTRIBUTE7 VARCHAR2,
p_PRICING_ATTRIBUTE8 VARCHAR2,
p_PRICING_ATTRIBUTE9 VARCHAR2,
p_PRICING_ATTRIBUTE10 VARCHAR2,
p_PRICING_ATTRIBUTE11 VARCHAR2,
p_PRICING_ATTRIBUTE12 VARCHAR2,
p_PRICING_ATTRIBUTE13 VARCHAR2,
p_PRICING_ATTRIBUTE14 VARCHAR2,
p_PRICING_ATTRIBUTE15 VARCHAR2,
p_PRICING_ATTRIBUTE16 VARCHAR2,
p_PRICING_ATTRIBUTE17 VARCHAR2,
p_PRICING_ATTRIBUTE18 VARCHAR2,
p_PRICING_ATTRIBUTE19 VARCHAR2,
p_PRICING_ATTRIBUTE20 VARCHAR2,
p_PRICING_ATTRIBUTE21 VARCHAR2,
p_PRICING_ATTRIBUTE22 VARCHAR2,
p_PRICING_ATTRIBUTE23 VARCHAR2,
p_PRICING_ATTRIBUTE24 VARCHAR2,
p_PRICING_ATTRIBUTE25 VARCHAR2,
p_PRICING_ATTRIBUTE26 VARCHAR2,
p_PRICING_ATTRIBUTE27 VARCHAR2,
p_PRICING_ATTRIBUTE28 VARCHAR2,
p_PRICING_ATTRIBUTE29 VARCHAR2,
p_PRICING_ATTRIBUTE30 VARCHAR2,
p_PRICING_ATTRIBUTE31 VARCHAR2,
p_PRICING_ATTRIBUTE32 VARCHAR2,
p_PRICING_ATTRIBUTE33 VARCHAR2,
p_PRICING_ATTRIBUTE34 VARCHAR2,
p_PRICING_ATTRIBUTE35 VARCHAR2,
p_PRICING_ATTRIBUTE36 VARCHAR2,
p_PRICING_ATTRIBUTE37 VARCHAR2,
p_PRICING_ATTRIBUTE38 VARCHAR2,
p_PRICING_ATTRIBUTE39 VARCHAR2,
p_PRICING_ATTRIBUTE40 VARCHAR2,
p_PRICING_ATTRIBUTE41 VARCHAR2,
p_PRICING_ATTRIBUTE42 VARCHAR2,
p_PRICING_ATTRIBUTE43 VARCHAR2,
p_PRICING_ATTRIBUTE44 VARCHAR2,
p_PRICING_ATTRIBUTE45 VARCHAR2,
p_PRICING_ATTRIBUTE46 VARCHAR2,
p_PRICING_ATTRIBUTE47 VARCHAR2,
p_PRICING_ATTRIBUTE48 VARCHAR2,
p_PRICING_ATTRIBUTE49 VARCHAR2,
p_PRICING_ATTRIBUTE50 VARCHAR2,
p_PRICING_ATTRIBUTE51 VARCHAR2,
p_PRICING_ATTRIBUTE52 VARCHAR2,
p_PRICING_ATTRIBUTE53 VARCHAR2,
p_PRICING_ATTRIBUTE54 VARCHAR2,
p_PRICING_ATTRIBUTE55 VARCHAR2,
p_PRICING_ATTRIBUTE56 VARCHAR2,
p_PRICING_ATTRIBUTE57 VARCHAR2,
p_PRICING_ATTRIBUTE58 VARCHAR2,
p_PRICING_ATTRIBUTE59 VARCHAR2,
p_PRICING_ATTRIBUTE60 VARCHAR2,
p_PRICING_ATTRIBUTE61 VARCHAR2,
p_PRICING_ATTRIBUTE62 VARCHAR2,
p_PRICING_ATTRIBUTE63 VARCHAR2,
p_PRICING_ATTRIBUTE64 VARCHAR2,
p_PRICING_ATTRIBUTE65 VARCHAR2,
p_PRICING_ATTRIBUTE66 VARCHAR2,
p_PRICING_ATTRIBUTE67 VARCHAR2,
p_PRICING_ATTRIBUTE68 VARCHAR2,
p_PRICING_ATTRIBUTE69 VARCHAR2,
p_PRICING_ATTRIBUTE70 VARCHAR2,
p_PRICING_ATTRIBUTE71 VARCHAR2,
p_PRICING_ATTRIBUTE72 VARCHAR2,
p_PRICING_ATTRIBUTE73 VARCHAR2,
p_PRICING_ATTRIBUTE74 VARCHAR2,
p_PRICING_ATTRIBUTE75 VARCHAR2,
p_PRICING_ATTRIBUTE76 VARCHAR2,
p_PRICING_ATTRIBUTE77 VARCHAR2,
p_PRICING_ATTRIBUTE78 VARCHAR2,
p_PRICING_ATTRIBUTE79 VARCHAR2,
p_PRICING_ATTRIBUTE80 VARCHAR2,
p_PRICING_ATTRIBUTE81 VARCHAR2,
p_PRICING_ATTRIBUTE82 VARCHAR2,
p_PRICING_ATTRIBUTE83 VARCHAR2,
p_PRICING_ATTRIBUTE84 VARCHAR2,
p_PRICING_ATTRIBUTE85 VARCHAR2,
p_PRICING_ATTRIBUTE86 VARCHAR2,
p_PRICING_ATTRIBUTE87 VARCHAR2,
p_PRICING_ATTRIBUTE88 VARCHAR2,
p_PRICING_ATTRIBUTE89 VARCHAR2,
p_PRICING_ATTRIBUTE90 VARCHAR2,
p_PRICING_ATTRIBUTE91 VARCHAR2,
p_PRICING_ATTRIBUTE92 VARCHAR2,
p_PRICING_ATTRIBUTE93 VARCHAR2,
p_PRICING_ATTRIBUTE94 VARCHAR2,
p_PRICING_ATTRIBUTE95 VARCHAR2,
p_PRICING_ATTRIBUTE96 VARCHAR2,
p_PRICING_ATTRIBUTE97 VARCHAR2,
p_PRICING_ATTRIBUTE98 VARCHAR2,
p_PRICING_ATTRIBUTE99 VARCHAR2,
p_PRICING_ATTRIBUTE100 VARCHAR2,
p_CONTEXT VARCHAR2,
p_ATTRIBUTE1 VARCHAR2,
p_ATTRIBUTE2 VARCHAR2,
p_ATTRIBUTE3 VARCHAR2,
p_ATTRIBUTE4 VARCHAR2,
p_ATTRIBUTE5 VARCHAR2,
p_ATTRIBUTE6 VARCHAR2,
p_ATTRIBUTE7 VARCHAR2,
p_ATTRIBUTE8 VARCHAR2,
p_ATTRIBUTE9 VARCHAR2,
p_ATTRIBUTE10 VARCHAR2,
p_ATTRIBUTE11 VARCHAR2,
p_ATTRIBUTE12 VARCHAR2,
p_ATTRIBUTE13 VARCHAR2,
p_ATTRIBUTE14 VARCHAR2,
p_ATTRIBUTE15 VARCHAR2,
p_ATTRIBUTE16 VARCHAR2,
p_ATTRIBUTE17 VARCHAR2,
p_ATTRIBUTE18 VARCHAR2,
p_ATTRIBUTE19 VARCHAR2,
p_ATTRIBUTE20 VARCHAR2,
p_OBJECT_VERSION_NUMBER NUMBER
)
IS
CURSOR C2 IS SELECT ASO_PRICE_ATTRIBUTES_S.nextval FROM sys.dual;
INSERT INTO ASO_PRICE_ATTRIBUTES(
PRICE_ATTRIBUTE_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
QUOTE_HEADER_ID,
QUOTE_LINE_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,
CONTEXT,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
OBJECT_VERSION_NUMBER
) VALUES (
px_PRICE_ATTRIBUTE_ID,
ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_HEADER_ID),
decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_LINE_ID),
decode( p_FLEX_TITLE, FND_API.G_MISS_CHAR, NULL, p_FLEX_TITLE),
decode( p_PRICING_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_PRICING_CONTEXT),
decode( p_PRICING_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE1),
decode( p_PRICING_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE2),
decode( p_PRICING_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE3),
decode( p_PRICING_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE4),
decode( p_PRICING_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE5),
decode( p_PRICING_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE6),
decode( p_PRICING_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE7),
decode( p_PRICING_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE8),
decode( p_PRICING_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE9),
decode( p_PRICING_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE10),
decode( p_PRICING_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE11),
decode( p_PRICING_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE12),
decode( p_PRICING_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE13),
decode( p_PRICING_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE14),
decode( p_PRICING_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE15),
decode( p_PRICING_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE16),
decode( p_PRICING_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE17),
decode( p_PRICING_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE18),
decode( p_PRICING_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE19),
decode( p_PRICING_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE20),
decode( p_PRICING_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE21),
decode( p_PRICING_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE22),
decode( p_PRICING_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE23),
decode( p_PRICING_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE24),
decode( p_PRICING_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE25),
decode( p_PRICING_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE26),
decode( p_PRICING_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE27),
decode( p_PRICING_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE28),
decode( p_PRICING_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE29),
decode( p_PRICING_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE30),
decode( p_PRICING_ATTRIBUTE31, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE31),
decode( p_PRICING_ATTRIBUTE32, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE32),
decode( p_PRICING_ATTRIBUTE33, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE33),
decode( p_PRICING_ATTRIBUTE34, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE34),
decode( p_PRICING_ATTRIBUTE35, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE35),
decode( p_PRICING_ATTRIBUTE36, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE36),
decode( p_PRICING_ATTRIBUTE37, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE37),
decode( p_PRICING_ATTRIBUTE38, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE38),
decode( p_PRICING_ATTRIBUTE39, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE39),
decode( p_PRICING_ATTRIBUTE40, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE40),
decode( p_PRICING_ATTRIBUTE41, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE41),
decode( p_PRICING_ATTRIBUTE42, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE42),
decode( p_PRICING_ATTRIBUTE43, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE43),
decode( p_PRICING_ATTRIBUTE44, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE44),
decode( p_PRICING_ATTRIBUTE45, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE45),
decode( p_PRICING_ATTRIBUTE46, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE46),
decode( p_PRICING_ATTRIBUTE47, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE47),
decode( p_PRICING_ATTRIBUTE48, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE48),
decode( p_PRICING_ATTRIBUTE49, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE49),
decode( p_PRICING_ATTRIBUTE50, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE50),
decode( p_PRICING_ATTRIBUTE51, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE51),
decode( p_PRICING_ATTRIBUTE52, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE52),
decode( p_PRICING_ATTRIBUTE53, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE53),
decode( p_PRICING_ATTRIBUTE54, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE54),
decode( p_PRICING_ATTRIBUTE55, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE55),
decode( p_PRICING_ATTRIBUTE56, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE56),
decode( p_PRICING_ATTRIBUTE57, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE57),
decode( p_PRICING_ATTRIBUTE58, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE58),
decode( p_PRICING_ATTRIBUTE59, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE59),
decode( p_PRICING_ATTRIBUTE60, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE60),
decode( p_PRICING_ATTRIBUTE61, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE61),
decode( p_PRICING_ATTRIBUTE62, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE62),
decode( p_PRICING_ATTRIBUTE63, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE63),
decode( p_PRICING_ATTRIBUTE64, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE64),
decode( p_PRICING_ATTRIBUTE65, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE65),
decode( p_PRICING_ATTRIBUTE66, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE66),
decode( p_PRICING_ATTRIBUTE67, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE67),
decode( p_PRICING_ATTRIBUTE68, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE68),
decode( p_PRICING_ATTRIBUTE69, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE69),
decode( p_PRICING_ATTRIBUTE70, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE70),
decode( p_PRICING_ATTRIBUTE71, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE71),
decode( p_PRICING_ATTRIBUTE72, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE72),
decode( p_PRICING_ATTRIBUTE73, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE73),
decode( p_PRICING_ATTRIBUTE74, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE74),
decode( p_PRICING_ATTRIBUTE75, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE75),
decode( p_PRICING_ATTRIBUTE76, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE76),
decode( p_PRICING_ATTRIBUTE77, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE77),
decode( p_PRICING_ATTRIBUTE78, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE78),
decode( p_PRICING_ATTRIBUTE79, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE79),
decode( p_PRICING_ATTRIBUTE80, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE80),
decode( p_PRICING_ATTRIBUTE81, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE81),
decode( p_PRICING_ATTRIBUTE82, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE82),
decode( p_PRICING_ATTRIBUTE83, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE83),
decode( p_PRICING_ATTRIBUTE84, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE84),
decode( p_PRICING_ATTRIBUTE85, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE85),
decode( p_PRICING_ATTRIBUTE86, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE86),
decode( p_PRICING_ATTRIBUTE87, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE87),
decode( p_PRICING_ATTRIBUTE88, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE88),
decode( p_PRICING_ATTRIBUTE89, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE89),
decode( p_PRICING_ATTRIBUTE90, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE90),
decode( p_PRICING_ATTRIBUTE91, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE91),
decode( p_PRICING_ATTRIBUTE92, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE92),
decode( p_PRICING_ATTRIBUTE93, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE93),
decode( p_PRICING_ATTRIBUTE94, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE94),
decode( p_PRICING_ATTRIBUTE95, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE95),
decode( p_PRICING_ATTRIBUTE96, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE96),
decode( p_PRICING_ATTRIBUTE97, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE97),
decode( p_PRICING_ATTRIBUTE98, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE98),
decode( p_PRICING_ATTRIBUTE99, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE99),
decode( p_PRICING_ATTRIBUTE100, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE100),
decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER)
);
End Insert_Row;
PROCEDURE Update_Row(
p_PRICE_ATTRIBUTE_ID NUMBER,
p_CREATION_DATE DATE,
p_CREATED_BY NUMBER,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATED_BY NUMBER,
p_LAST_UPDATE_LOGIN NUMBER,
p_PROGRAM_APPLICATION_ID NUMBER,
p_PROGRAM_ID NUMBER,
p_PROGRAM_UPDATE_DATE DATE,
p_REQUEST_ID NUMBER,
p_QUOTE_HEADER_ID NUMBER,
p_QUOTE_LINE_ID NUMBER,
p_FLEX_TITLE VARCHAR2,
p_PRICING_CONTEXT VARCHAR2,
p_PRICING_ATTRIBUTE1 VARCHAR2,
p_PRICING_ATTRIBUTE2 VARCHAR2,
p_PRICING_ATTRIBUTE3 VARCHAR2,
p_PRICING_ATTRIBUTE4 VARCHAR2,
p_PRICING_ATTRIBUTE5 VARCHAR2,
p_PRICING_ATTRIBUTE6 VARCHAR2,
p_PRICING_ATTRIBUTE7 VARCHAR2,
p_PRICING_ATTRIBUTE8 VARCHAR2,
p_PRICING_ATTRIBUTE9 VARCHAR2,
p_PRICING_ATTRIBUTE10 VARCHAR2,
p_PRICING_ATTRIBUTE11 VARCHAR2,
p_PRICING_ATTRIBUTE12 VARCHAR2,
p_PRICING_ATTRIBUTE13 VARCHAR2,
p_PRICING_ATTRIBUTE14 VARCHAR2,
p_PRICING_ATTRIBUTE15 VARCHAR2,
p_PRICING_ATTRIBUTE16 VARCHAR2,
p_PRICING_ATTRIBUTE17 VARCHAR2,
p_PRICING_ATTRIBUTE18 VARCHAR2,
p_PRICING_ATTRIBUTE19 VARCHAR2,
p_PRICING_ATTRIBUTE20 VARCHAR2,
p_PRICING_ATTRIBUTE21 VARCHAR2,
p_PRICING_ATTRIBUTE22 VARCHAR2,
p_PRICING_ATTRIBUTE23 VARCHAR2,
p_PRICING_ATTRIBUTE24 VARCHAR2,
p_PRICING_ATTRIBUTE25 VARCHAR2,
p_PRICING_ATTRIBUTE26 VARCHAR2,
p_PRICING_ATTRIBUTE27 VARCHAR2,
p_PRICING_ATTRIBUTE28 VARCHAR2,
p_PRICING_ATTRIBUTE29 VARCHAR2,
p_PRICING_ATTRIBUTE30 VARCHAR2,
p_PRICING_ATTRIBUTE31 VARCHAR2,
p_PRICING_ATTRIBUTE32 VARCHAR2,
p_PRICING_ATTRIBUTE33 VARCHAR2,
p_PRICING_ATTRIBUTE34 VARCHAR2,
p_PRICING_ATTRIBUTE35 VARCHAR2,
p_PRICING_ATTRIBUTE36 VARCHAR2,
p_PRICING_ATTRIBUTE37 VARCHAR2,
p_PRICING_ATTRIBUTE38 VARCHAR2,
p_PRICING_ATTRIBUTE39 VARCHAR2,
p_PRICING_ATTRIBUTE40 VARCHAR2,
p_PRICING_ATTRIBUTE41 VARCHAR2,
p_PRICING_ATTRIBUTE42 VARCHAR2,
p_PRICING_ATTRIBUTE43 VARCHAR2,
p_PRICING_ATTRIBUTE44 VARCHAR2,
p_PRICING_ATTRIBUTE45 VARCHAR2,
p_PRICING_ATTRIBUTE46 VARCHAR2,
p_PRICING_ATTRIBUTE47 VARCHAR2,
p_PRICING_ATTRIBUTE48 VARCHAR2,
p_PRICING_ATTRIBUTE49 VARCHAR2,
p_PRICING_ATTRIBUTE50 VARCHAR2,
p_PRICING_ATTRIBUTE51 VARCHAR2,
p_PRICING_ATTRIBUTE52 VARCHAR2,
p_PRICING_ATTRIBUTE53 VARCHAR2,
p_PRICING_ATTRIBUTE54 VARCHAR2,
p_PRICING_ATTRIBUTE55 VARCHAR2,
p_PRICING_ATTRIBUTE56 VARCHAR2,
p_PRICING_ATTRIBUTE57 VARCHAR2,
p_PRICING_ATTRIBUTE58 VARCHAR2,
p_PRICING_ATTRIBUTE59 VARCHAR2,
p_PRICING_ATTRIBUTE60 VARCHAR2,
p_PRICING_ATTRIBUTE61 VARCHAR2,
p_PRICING_ATTRIBUTE62 VARCHAR2,
p_PRICING_ATTRIBUTE63 VARCHAR2,
p_PRICING_ATTRIBUTE64 VARCHAR2,
p_PRICING_ATTRIBUTE65 VARCHAR2,
p_PRICING_ATTRIBUTE66 VARCHAR2,
p_PRICING_ATTRIBUTE67 VARCHAR2,
p_PRICING_ATTRIBUTE68 VARCHAR2,
p_PRICING_ATTRIBUTE69 VARCHAR2,
p_PRICING_ATTRIBUTE70 VARCHAR2,
p_PRICING_ATTRIBUTE71 VARCHAR2,
p_PRICING_ATTRIBUTE72 VARCHAR2,
p_PRICING_ATTRIBUTE73 VARCHAR2,
p_PRICING_ATTRIBUTE74 VARCHAR2,
p_PRICING_ATTRIBUTE75 VARCHAR2,
p_PRICING_ATTRIBUTE76 VARCHAR2,
p_PRICING_ATTRIBUTE77 VARCHAR2,
p_PRICING_ATTRIBUTE78 VARCHAR2,
p_PRICING_ATTRIBUTE79 VARCHAR2,
p_PRICING_ATTRIBUTE80 VARCHAR2,
p_PRICING_ATTRIBUTE81 VARCHAR2,
p_PRICING_ATTRIBUTE82 VARCHAR2,
p_PRICING_ATTRIBUTE83 VARCHAR2,
p_PRICING_ATTRIBUTE84 VARCHAR2,
p_PRICING_ATTRIBUTE85 VARCHAR2,
p_PRICING_ATTRIBUTE86 VARCHAR2,
p_PRICING_ATTRIBUTE87 VARCHAR2,
p_PRICING_ATTRIBUTE88 VARCHAR2,
p_PRICING_ATTRIBUTE89 VARCHAR2,
p_PRICING_ATTRIBUTE90 VARCHAR2,
p_PRICING_ATTRIBUTE91 VARCHAR2,
p_PRICING_ATTRIBUTE92 VARCHAR2,
p_PRICING_ATTRIBUTE93 VARCHAR2,
p_PRICING_ATTRIBUTE94 VARCHAR2,
p_PRICING_ATTRIBUTE95 VARCHAR2,
p_PRICING_ATTRIBUTE96 VARCHAR2,
p_PRICING_ATTRIBUTE97 VARCHAR2,
p_PRICING_ATTRIBUTE98 VARCHAR2,
p_PRICING_ATTRIBUTE99 VARCHAR2,
p_PRICING_ATTRIBUTE100 VARCHAR2,
p_CONTEXT VARCHAR2,
p_ATTRIBUTE1 VARCHAR2,
p_ATTRIBUTE2 VARCHAR2,
p_ATTRIBUTE3 VARCHAR2,
p_ATTRIBUTE4 VARCHAR2,
p_ATTRIBUTE5 VARCHAR2,
p_ATTRIBUTE6 VARCHAR2,
p_ATTRIBUTE7 VARCHAR2,
p_ATTRIBUTE8 VARCHAR2,
p_ATTRIBUTE9 VARCHAR2,
p_ATTRIBUTE10 VARCHAR2,
p_ATTRIBUTE11 VARCHAR2,
p_ATTRIBUTE12 VARCHAR2,
p_ATTRIBUTE13 VARCHAR2,
p_ATTRIBUTE14 VARCHAR2,
p_ATTRIBUTE15 VARCHAR2,
p_ATTRIBUTE16 VARCHAR2,
p_ATTRIBUTE17 VARCHAR2,
p_ATTRIBUTE18 VARCHAR2,
p_ATTRIBUTE19 VARCHAR2,
p_ATTRIBUTE20 VARCHAR2,
p_OBJECT_VERSION_NUMBER NUMBER
)
IS
BEGIN
Update ASO_PRICE_ATTRIBUTES
SET
/* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
QUOTE_HEADER_ID = decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
QUOTE_LINE_ID = decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, QUOTE_LINE_ID, p_QUOTE_LINE_ID),
FLEX_TITLE = decode( p_FLEX_TITLE, FND_API.G_MISS_CHAR, FLEX_TITLE, p_FLEX_TITLE),
PRICING_CONTEXT = decode( p_PRICING_CONTEXT, FND_API.G_MISS_CHAR, PRICING_CONTEXT, p_PRICING_CONTEXT),
PRICING_ATTRIBUTE1 = decode( p_PRICING_ATTRIBUTE1, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE1, p_PRICING_ATTRIBUTE1),
PRICING_ATTRIBUTE2 = decode( p_PRICING_ATTRIBUTE2, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE2, p_PRICING_ATTRIBUTE2),
PRICING_ATTRIBUTE3 = decode( p_PRICING_ATTRIBUTE3, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE3, p_PRICING_ATTRIBUTE3),
PRICING_ATTRIBUTE4 = decode( p_PRICING_ATTRIBUTE4, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE4, p_PRICING_ATTRIBUTE4),
PRICING_ATTRIBUTE5 = decode( p_PRICING_ATTRIBUTE5, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE5, p_PRICING_ATTRIBUTE5),
PRICING_ATTRIBUTE6 = decode( p_PRICING_ATTRIBUTE6, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE6, p_PRICING_ATTRIBUTE6),
PRICING_ATTRIBUTE7 = decode( p_PRICING_ATTRIBUTE7, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE7, p_PRICING_ATTRIBUTE7),
PRICING_ATTRIBUTE8 = decode( p_PRICING_ATTRIBUTE8, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE8, p_PRICING_ATTRIBUTE8),
PRICING_ATTRIBUTE9 = decode( p_PRICING_ATTRIBUTE9, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE9, p_PRICING_ATTRIBUTE9),
PRICING_ATTRIBUTE10 = decode( p_PRICING_ATTRIBUTE10, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE10, p_PRICING_ATTRIBUTE10),
PRICING_ATTRIBUTE11 = decode( p_PRICING_ATTRIBUTE11, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE11, p_PRICING_ATTRIBUTE11),
PRICING_ATTRIBUTE12 = decode( p_PRICING_ATTRIBUTE12, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE12, p_PRICING_ATTRIBUTE12),
PRICING_ATTRIBUTE13 = decode( p_PRICING_ATTRIBUTE13, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE13, p_PRICING_ATTRIBUTE13),
PRICING_ATTRIBUTE14 = decode( p_PRICING_ATTRIBUTE14, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE14, p_PRICING_ATTRIBUTE14),
PRICING_ATTRIBUTE15 = decode( p_PRICING_ATTRIBUTE15, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE15, p_PRICING_ATTRIBUTE15),
PRICING_ATTRIBUTE16 = decode( p_PRICING_ATTRIBUTE16, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE16, p_PRICING_ATTRIBUTE16),
PRICING_ATTRIBUTE17 = decode( p_PRICING_ATTRIBUTE17, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE17, p_PRICING_ATTRIBUTE17),
PRICING_ATTRIBUTE18 = decode( p_PRICING_ATTRIBUTE18, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE18, p_PRICING_ATTRIBUTE18),
PRICING_ATTRIBUTE19 = decode( p_PRICING_ATTRIBUTE19, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE19, p_PRICING_ATTRIBUTE19),
PRICING_ATTRIBUTE20 = decode( p_PRICING_ATTRIBUTE20, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE20, p_PRICING_ATTRIBUTE20),
PRICING_ATTRIBUTE21 = decode( p_PRICING_ATTRIBUTE21, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE21, p_PRICING_ATTRIBUTE21),
PRICING_ATTRIBUTE22 = decode( p_PRICING_ATTRIBUTE22, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE22, p_PRICING_ATTRIBUTE22),
PRICING_ATTRIBUTE23 = decode( p_PRICING_ATTRIBUTE23, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE23, p_PRICING_ATTRIBUTE23),
PRICING_ATTRIBUTE24 = decode( p_PRICING_ATTRIBUTE24, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE24, p_PRICING_ATTRIBUTE24),
PRICING_ATTRIBUTE25 = decode( p_PRICING_ATTRIBUTE25, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE25, p_PRICING_ATTRIBUTE25),
PRICING_ATTRIBUTE26 = decode( p_PRICING_ATTRIBUTE26, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE26, p_PRICING_ATTRIBUTE26),
PRICING_ATTRIBUTE27 = decode( p_PRICING_ATTRIBUTE27, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE27, p_PRICING_ATTRIBUTE27),
PRICING_ATTRIBUTE28 = decode( p_PRICING_ATTRIBUTE28, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE28, p_PRICING_ATTRIBUTE28),
PRICING_ATTRIBUTE29 = decode( p_PRICING_ATTRIBUTE29, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE29, p_PRICING_ATTRIBUTE29),
PRICING_ATTRIBUTE30 = decode( p_PRICING_ATTRIBUTE30, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE30, p_PRICING_ATTRIBUTE30),
PRICING_ATTRIBUTE31 = decode( p_PRICING_ATTRIBUTE31, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE31, p_PRICING_ATTRIBUTE31),
PRICING_ATTRIBUTE32 = decode( p_PRICING_ATTRIBUTE32, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE32, p_PRICING_ATTRIBUTE32),
PRICING_ATTRIBUTE33 = decode( p_PRICING_ATTRIBUTE33, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE33, p_PRICING_ATTRIBUTE33),
PRICING_ATTRIBUTE34 = decode( p_PRICING_ATTRIBUTE34, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE34, p_PRICING_ATTRIBUTE34),
PRICING_ATTRIBUTE35 = decode( p_PRICING_ATTRIBUTE35, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE35, p_PRICING_ATTRIBUTE35),
PRICING_ATTRIBUTE36 = decode( p_PRICING_ATTRIBUTE36, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE36, p_PRICING_ATTRIBUTE36),
PRICING_ATTRIBUTE37 = decode( p_PRICING_ATTRIBUTE37, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE37, p_PRICING_ATTRIBUTE37),
PRICING_ATTRIBUTE38 = decode( p_PRICING_ATTRIBUTE38, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE38, p_PRICING_ATTRIBUTE38),
PRICING_ATTRIBUTE39 = decode( p_PRICING_ATTRIBUTE39, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE39, p_PRICING_ATTRIBUTE39),
PRICING_ATTRIBUTE40 = decode( p_PRICING_ATTRIBUTE40, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE40, p_PRICING_ATTRIBUTE40),
PRICING_ATTRIBUTE41 = decode( p_PRICING_ATTRIBUTE41, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE41, p_PRICING_ATTRIBUTE41),
PRICING_ATTRIBUTE42 = decode( p_PRICING_ATTRIBUTE42, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE42, p_PRICING_ATTRIBUTE42),
PRICING_ATTRIBUTE43 = decode( p_PRICING_ATTRIBUTE43, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE43, p_PRICING_ATTRIBUTE43),
PRICING_ATTRIBUTE44 = decode( p_PRICING_ATTRIBUTE44, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE44, p_PRICING_ATTRIBUTE44),
PRICING_ATTRIBUTE45 = decode( p_PRICING_ATTRIBUTE45, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE45, p_PRICING_ATTRIBUTE45),
PRICING_ATTRIBUTE46 = decode( p_PRICING_ATTRIBUTE46, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE46, p_PRICING_ATTRIBUTE46),
PRICING_ATTRIBUTE47 = decode( p_PRICING_ATTRIBUTE47, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE47, p_PRICING_ATTRIBUTE47),
PRICING_ATTRIBUTE48 = decode( p_PRICING_ATTRIBUTE48, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE48, p_PRICING_ATTRIBUTE48),
PRICING_ATTRIBUTE49 = decode( p_PRICING_ATTRIBUTE49, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE49, p_PRICING_ATTRIBUTE49),
PRICING_ATTRIBUTE50 = decode( p_PRICING_ATTRIBUTE50, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE50, p_PRICING_ATTRIBUTE50),
PRICING_ATTRIBUTE51 = decode( p_PRICING_ATTRIBUTE51, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE51, p_PRICING_ATTRIBUTE51),
PRICING_ATTRIBUTE52 = decode( p_PRICING_ATTRIBUTE52, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE52, p_PRICING_ATTRIBUTE52),
PRICING_ATTRIBUTE53 = decode( p_PRICING_ATTRIBUTE53, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE53, p_PRICING_ATTRIBUTE53),
PRICING_ATTRIBUTE54 = decode( p_PRICING_ATTRIBUTE54, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE54, p_PRICING_ATTRIBUTE54),
PRICING_ATTRIBUTE55 = decode( p_PRICING_ATTRIBUTE55, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE55, p_PRICING_ATTRIBUTE55),
PRICING_ATTRIBUTE56 = decode( p_PRICING_ATTRIBUTE56, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE56, p_PRICING_ATTRIBUTE56),
PRICING_ATTRIBUTE57 = decode( p_PRICING_ATTRIBUTE57, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE57, p_PRICING_ATTRIBUTE57),
PRICING_ATTRIBUTE58 = decode( p_PRICING_ATTRIBUTE58, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE58, p_PRICING_ATTRIBUTE58),
PRICING_ATTRIBUTE59 = decode( p_PRICING_ATTRIBUTE59, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE59, p_PRICING_ATTRIBUTE59),
PRICING_ATTRIBUTE60 = decode( p_PRICING_ATTRIBUTE60, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE60, p_PRICING_ATTRIBUTE60),
PRICING_ATTRIBUTE61 = decode( p_PRICING_ATTRIBUTE61, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE61, p_PRICING_ATTRIBUTE61),
PRICING_ATTRIBUTE62 = decode( p_PRICING_ATTRIBUTE62, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE62, p_PRICING_ATTRIBUTE62),
PRICING_ATTRIBUTE63 = decode( p_PRICING_ATTRIBUTE63, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE63, p_PRICING_ATTRIBUTE63),
PRICING_ATTRIBUTE64 = decode( p_PRICING_ATTRIBUTE64, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE64, p_PRICING_ATTRIBUTE64),
PRICING_ATTRIBUTE65 = decode( p_PRICING_ATTRIBUTE65, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE65, p_PRICING_ATTRIBUTE65),
PRICING_ATTRIBUTE66 = decode( p_PRICING_ATTRIBUTE66, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE66, p_PRICING_ATTRIBUTE66),
PRICING_ATTRIBUTE67 = decode( p_PRICING_ATTRIBUTE67, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE67, p_PRICING_ATTRIBUTE67),
PRICING_ATTRIBUTE68 = decode( p_PRICING_ATTRIBUTE68, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE68, p_PRICING_ATTRIBUTE68),
PRICING_ATTRIBUTE69 = decode( p_PRICING_ATTRIBUTE69, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE69, p_PRICING_ATTRIBUTE69),
PRICING_ATTRIBUTE70 = decode( p_PRICING_ATTRIBUTE70, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE70, p_PRICING_ATTRIBUTE70),
PRICING_ATTRIBUTE71 = decode( p_PRICING_ATTRIBUTE71, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE71, p_PRICING_ATTRIBUTE71),
PRICING_ATTRIBUTE72 = decode( p_PRICING_ATTRIBUTE72, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE72, p_PRICING_ATTRIBUTE72),
PRICING_ATTRIBUTE73 = decode( p_PRICING_ATTRIBUTE73, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE73, p_PRICING_ATTRIBUTE73),
PRICING_ATTRIBUTE74 = decode( p_PRICING_ATTRIBUTE74, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE74, p_PRICING_ATTRIBUTE74),
PRICING_ATTRIBUTE75 = decode( p_PRICING_ATTRIBUTE75, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE75, p_PRICING_ATTRIBUTE75),
PRICING_ATTRIBUTE76 = decode( p_PRICING_ATTRIBUTE76, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE76, p_PRICING_ATTRIBUTE76),
PRICING_ATTRIBUTE77 = decode( p_PRICING_ATTRIBUTE77, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE77, p_PRICING_ATTRIBUTE77),
PRICING_ATTRIBUTE78 = decode( p_PRICING_ATTRIBUTE78, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE78, p_PRICING_ATTRIBUTE78),
PRICING_ATTRIBUTE79 = decode( p_PRICING_ATTRIBUTE79, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE79, p_PRICING_ATTRIBUTE79),
PRICING_ATTRIBUTE80 = decode( p_PRICING_ATTRIBUTE80, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE80, p_PRICING_ATTRIBUTE80),
PRICING_ATTRIBUTE81 = decode( p_PRICING_ATTRIBUTE81, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE81, p_PRICING_ATTRIBUTE81),
PRICING_ATTRIBUTE82 = decode( p_PRICING_ATTRIBUTE82, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE82, p_PRICING_ATTRIBUTE82),
PRICING_ATTRIBUTE83 = decode( p_PRICING_ATTRIBUTE83, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE83, p_PRICING_ATTRIBUTE83),
PRICING_ATTRIBUTE84 = decode( p_PRICING_ATTRIBUTE84, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE84, p_PRICING_ATTRIBUTE84),
PRICING_ATTRIBUTE85 = decode( p_PRICING_ATTRIBUTE85, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE85, p_PRICING_ATTRIBUTE85),
PRICING_ATTRIBUTE86 = decode( p_PRICING_ATTRIBUTE86, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE86, p_PRICING_ATTRIBUTE86),
PRICING_ATTRIBUTE87 = decode( p_PRICING_ATTRIBUTE87, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE87, p_PRICING_ATTRIBUTE87),
PRICING_ATTRIBUTE88 = decode( p_PRICING_ATTRIBUTE88, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE88, p_PRICING_ATTRIBUTE88),
PRICING_ATTRIBUTE89 = decode( p_PRICING_ATTRIBUTE89, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE89, p_PRICING_ATTRIBUTE89),
PRICING_ATTRIBUTE90 = decode( p_PRICING_ATTRIBUTE90, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE90, p_PRICING_ATTRIBUTE90),
PRICING_ATTRIBUTE91 = decode( p_PRICING_ATTRIBUTE91, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE91, p_PRICING_ATTRIBUTE91),
PRICING_ATTRIBUTE92 = decode( p_PRICING_ATTRIBUTE92, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE92, p_PRICING_ATTRIBUTE92),
PRICING_ATTRIBUTE93 = decode( p_PRICING_ATTRIBUTE93, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE93, p_PRICING_ATTRIBUTE93),
PRICING_ATTRIBUTE94 = decode( p_PRICING_ATTRIBUTE94, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE94, p_PRICING_ATTRIBUTE94),
PRICING_ATTRIBUTE95 = decode( p_PRICING_ATTRIBUTE95, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE95, p_PRICING_ATTRIBUTE95),
PRICING_ATTRIBUTE96 = decode( p_PRICING_ATTRIBUTE96, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE96, p_PRICING_ATTRIBUTE96),
PRICING_ATTRIBUTE97 = decode( p_PRICING_ATTRIBUTE97, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE97, p_PRICING_ATTRIBUTE97),
PRICING_ATTRIBUTE98 = decode( p_PRICING_ATTRIBUTE98, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE98, p_PRICING_ATTRIBUTE98),
PRICING_ATTRIBUTE99 = decode( p_PRICING_ATTRIBUTE99, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE99, p_PRICING_ATTRIBUTE99),
PRICING_ATTRIBUTE100 = decode( p_PRICING_ATTRIBUTE100, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE100, p_PRICING_ATTRIBUTE100),
CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, nvl(OBJECT_VERSION_NUMBER,0)+1, nvl(p_OBJECT_VERSION_NUMBER, nvl(OBJECT_VERSION_NUMBER,0))+1)
where PRICE_ATTRIBUTE_ID = p_PRICE_ATTRIBUTE_ID;
END Update_Row;
PROCEDURE Delete_Row(
p_PRICE_ATTRIBUTE_ID NUMBER)
IS
BEGIN
DELETE FROM ASO_PRICE_ATTRIBUTES
WHERE PRICE_ATTRIBUTE_ID = p_PRICE_ATTRIBUTE_ID;
END Delete_Row;
PROCEDURE Delete_Row(
p_QUOTE_LINE_ID NUMBER)
IS
BEGIN
DELETE FROM ASO_PRICE_ATTRIBUTES
WHERE QUOTE_LINE_ID = p_QUOTE_LINE_ID;
END Delete_Row;
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATED_BY NUMBER,
p_LAST_UPDATE_LOGIN NUMBER,
p_PROGRAM_APPLICATION_ID NUMBER,
p_PROGRAM_ID NUMBER,
p_PROGRAM_UPDATE_DATE DATE,
p_REQUEST_ID NUMBER,
p_QUOTE_HEADER_ID NUMBER,
p_QUOTE_LINE_ID NUMBER,
p_FLEX_TITLE VARCHAR2,
p_PRICING_CONTEXT VARCHAR2,
p_PRICING_ATTRIBUTE1 VARCHAR2,
p_PRICING_ATTRIBUTE2 VARCHAR2,
p_PRICING_ATTRIBUTE3 VARCHAR2,
p_PRICING_ATTRIBUTE4 VARCHAR2,
p_PRICING_ATTRIBUTE5 VARCHAR2,
p_PRICING_ATTRIBUTE6 VARCHAR2,
p_PRICING_ATTRIBUTE7 VARCHAR2,
p_PRICING_ATTRIBUTE8 VARCHAR2,
p_PRICING_ATTRIBUTE9 VARCHAR2,
p_PRICING_ATTRIBUTE10 VARCHAR2,
p_PRICING_ATTRIBUTE11 VARCHAR2,
p_PRICING_ATTRIBUTE12 VARCHAR2,
p_PRICING_ATTRIBUTE13 VARCHAR2,
p_PRICING_ATTRIBUTE14 VARCHAR2,
p_PRICING_ATTRIBUTE15 VARCHAR2,
p_PRICING_ATTRIBUTE16 VARCHAR2,
p_PRICING_ATTRIBUTE17 VARCHAR2,
p_PRICING_ATTRIBUTE18 VARCHAR2,
p_PRICING_ATTRIBUTE19 VARCHAR2,
p_PRICING_ATTRIBUTE20 VARCHAR2,
p_PRICING_ATTRIBUTE21 VARCHAR2,
p_PRICING_ATTRIBUTE22 VARCHAR2,
p_PRICING_ATTRIBUTE23 VARCHAR2,
p_PRICING_ATTRIBUTE24 VARCHAR2,
p_PRICING_ATTRIBUTE25 VARCHAR2,
p_PRICING_ATTRIBUTE26 VARCHAR2,
p_PRICING_ATTRIBUTE27 VARCHAR2,
p_PRICING_ATTRIBUTE28 VARCHAR2,
p_PRICING_ATTRIBUTE29 VARCHAR2,
p_PRICING_ATTRIBUTE30 VARCHAR2,
p_PRICING_ATTRIBUTE31 VARCHAR2,
p_PRICING_ATTRIBUTE32 VARCHAR2,
p_PRICING_ATTRIBUTE33 VARCHAR2,
p_PRICING_ATTRIBUTE34 VARCHAR2,
p_PRICING_ATTRIBUTE35 VARCHAR2,
p_PRICING_ATTRIBUTE36 VARCHAR2,
p_PRICING_ATTRIBUTE37 VARCHAR2,
p_PRICING_ATTRIBUTE38 VARCHAR2,
p_PRICING_ATTRIBUTE39 VARCHAR2,
p_PRICING_ATTRIBUTE40 VARCHAR2,
p_PRICING_ATTRIBUTE41 VARCHAR2,
p_PRICING_ATTRIBUTE42 VARCHAR2,
p_PRICING_ATTRIBUTE43 VARCHAR2,
p_PRICING_ATTRIBUTE44 VARCHAR2,
p_PRICING_ATTRIBUTE45 VARCHAR2,
p_PRICING_ATTRIBUTE46 VARCHAR2,
p_PRICING_ATTRIBUTE47 VARCHAR2,
p_PRICING_ATTRIBUTE48 VARCHAR2,
p_PRICING_ATTRIBUTE49 VARCHAR2,
p_PRICING_ATTRIBUTE50 VARCHAR2,
p_PRICING_ATTRIBUTE51 VARCHAR2,
p_PRICING_ATTRIBUTE52 VARCHAR2,
p_PRICING_ATTRIBUTE53 VARCHAR2,
p_PRICING_ATTRIBUTE54 VARCHAR2,
p_PRICING_ATTRIBUTE55 VARCHAR2,
p_PRICING_ATTRIBUTE56 VARCHAR2,
p_PRICING_ATTRIBUTE57 VARCHAR2,
p_PRICING_ATTRIBUTE58 VARCHAR2,
p_PRICING_ATTRIBUTE59 VARCHAR2,
p_PRICING_ATTRIBUTE60 VARCHAR2,
p_PRICING_ATTRIBUTE61 VARCHAR2,
p_PRICING_ATTRIBUTE62 VARCHAR2,
p_PRICING_ATTRIBUTE63 VARCHAR2,
p_PRICING_ATTRIBUTE64 VARCHAR2,
p_PRICING_ATTRIBUTE65 VARCHAR2,
p_PRICING_ATTRIBUTE66 VARCHAR2,
p_PRICING_ATTRIBUTE67 VARCHAR2,
p_PRICING_ATTRIBUTE68 VARCHAR2,
p_PRICING_ATTRIBUTE69 VARCHAR2,
p_PRICING_ATTRIBUTE70 VARCHAR2,
p_PRICING_ATTRIBUTE71 VARCHAR2,
p_PRICING_ATTRIBUTE72 VARCHAR2,
p_PRICING_ATTRIBUTE73 VARCHAR2,
p_PRICING_ATTRIBUTE74 VARCHAR2,
p_PRICING_ATTRIBUTE75 VARCHAR2,
p_PRICING_ATTRIBUTE76 VARCHAR2,
p_PRICING_ATTRIBUTE77 VARCHAR2,
p_PRICING_ATTRIBUTE78 VARCHAR2,
p_PRICING_ATTRIBUTE79 VARCHAR2,
p_PRICING_ATTRIBUTE80 VARCHAR2,
p_PRICING_ATTRIBUTE81 VARCHAR2,
p_PRICING_ATTRIBUTE82 VARCHAR2,
p_PRICING_ATTRIBUTE83 VARCHAR2,
p_PRICING_ATTRIBUTE84 VARCHAR2,
p_PRICING_ATTRIBUTE85 VARCHAR2,
p_PRICING_ATTRIBUTE86 VARCHAR2,
p_PRICING_ATTRIBUTE87 VARCHAR2,
p_PRICING_ATTRIBUTE88 VARCHAR2,
p_PRICING_ATTRIBUTE89 VARCHAR2,
p_PRICING_ATTRIBUTE90 VARCHAR2,
p_PRICING_ATTRIBUTE91 VARCHAR2,
p_PRICING_ATTRIBUTE92 VARCHAR2,
p_PRICING_ATTRIBUTE93 VARCHAR2,
p_PRICING_ATTRIBUTE94 VARCHAR2,
p_PRICING_ATTRIBUTE95 VARCHAR2,
p_PRICING_ATTRIBUTE96 VARCHAR2,
p_PRICING_ATTRIBUTE97 VARCHAR2,
p_PRICING_ATTRIBUTE98 VARCHAR2,
p_PRICING_ATTRIBUTE99 VARCHAR2,
p_PRICING_ATTRIBUTE100 VARCHAR2,
p_CONTEXT VARCHAR2,
p_ATTRIBUTE1 VARCHAR2,
p_ATTRIBUTE2 VARCHAR2,
p_ATTRIBUTE3 VARCHAR2,
p_ATTRIBUTE4 VARCHAR2,
p_ATTRIBUTE5 VARCHAR2,
p_ATTRIBUTE6 VARCHAR2,
p_ATTRIBUTE7 VARCHAR2,
p_ATTRIBUTE8 VARCHAR2,
p_ATTRIBUTE9 VARCHAR2,
p_ATTRIBUTE10 VARCHAR2,
p_ATTRIBUTE11 VARCHAR2,
p_ATTRIBUTE12 VARCHAR2,
p_ATTRIBUTE13 VARCHAR2,
p_ATTRIBUTE14 VARCHAR2,
p_ATTRIBUTE15 VARCHAR2)
IS
CURSOR C IS
SELECT PRICING_ATTRIBUTE26,
--OBJECT_VERSION_NUMBER,
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,
CONTEXT,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
PRICE_ATTRIBUTE_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
QUOTE_HEADER_ID,
QUOTE_LINE_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
FROM ASO_PRICE_ATTRIBUTES
WHERE PRICE_ATTRIBUTE_ID = p_PRICE_ATTRIBUTE_ID
FOR UPDATE of PRICE_ATTRIBUTE_ID NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
AND ( p_LAST_UPDATE_DATE IS NULL )))
/*
AND
( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
AND ( p_LAST_UPDATED_BY IS NULL )))
AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
AND ( p_LAST_UPDATE_LOGIN IS NULL )))
AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
OR ( ( Recinfo.PROGRAM_ID IS NULL )
AND ( p_PROGRAM_ID IS NULL )))
AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
OR ( ( Recinfo.REQUEST_ID IS NULL )
AND ( p_REQUEST_ID IS NULL )))
AND ( ( Recinfo.QUOTE_HEADER_ID = p_QUOTE_HEADER_ID)
OR ( ( Recinfo.QUOTE_HEADER_ID IS NULL )
AND ( p_QUOTE_HEADER_ID IS NULL )))
AND ( ( Recinfo.QUOTE_LINE_ID = p_QUOTE_LINE_ID)
OR ( ( Recinfo.QUOTE_LINE_ID IS NULL )
AND ( p_QUOTE_LINE_ID IS NULL )))
AND ( ( Recinfo.FLEX_TITLE = p_FLEX_TITLE)
OR ( ( Recinfo.FLEX_TITLE IS NULL )
AND ( p_FLEX_TITLE IS NULL )))
AND ( ( Recinfo.PRICING_CONTEXT = p_PRICING_CONTEXT)
OR ( ( Recinfo.PRICING_CONTEXT IS NULL )
AND ( p_PRICING_CONTEXT IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE1 = p_PRICING_ATTRIBUTE1)
OR ( ( Recinfo.PRICING_ATTRIBUTE1 IS NULL )
AND ( p_PRICING_ATTRIBUTE1 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE2 = p_PRICING_ATTRIBUTE2)
OR ( ( Recinfo.PRICING_ATTRIBUTE2 IS NULL )
AND ( p_PRICING_ATTRIBUTE2 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE3 = p_PRICING_ATTRIBUTE3)
OR ( ( Recinfo.PRICING_ATTRIBUTE3 IS NULL )
AND ( p_PRICING_ATTRIBUTE3 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE4 = p_PRICING_ATTRIBUTE4)
OR ( ( Recinfo.PRICING_ATTRIBUTE4 IS NULL )
AND ( p_PRICING_ATTRIBUTE4 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE5 = p_PRICING_ATTRIBUTE5)
OR ( ( Recinfo.PRICING_ATTRIBUTE5 IS NULL )
AND ( p_PRICING_ATTRIBUTE5 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE6 = p_PRICING_ATTRIBUTE6)
OR ( ( Recinfo.PRICING_ATTRIBUTE6 IS NULL )
AND ( p_PRICING_ATTRIBUTE6 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE7 = p_PRICING_ATTRIBUTE7)
OR ( ( Recinfo.PRICING_ATTRIBUTE7 IS NULL )
AND ( p_PRICING_ATTRIBUTE7 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE8 = p_PRICING_ATTRIBUTE8)
OR ( ( Recinfo.PRICING_ATTRIBUTE8 IS NULL )
AND ( p_PRICING_ATTRIBUTE8 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE9 = p_PRICING_ATTRIBUTE9)
OR ( ( Recinfo.PRICING_ATTRIBUTE9 IS NULL )
AND ( p_PRICING_ATTRIBUTE9 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE10 = p_PRICING_ATTRIBUTE10)
OR ( ( Recinfo.PRICING_ATTRIBUTE10 IS NULL )
AND ( p_PRICING_ATTRIBUTE10 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE11 = p_PRICING_ATTRIBUTE11)
OR ( ( Recinfo.PRICING_ATTRIBUTE11 IS NULL )
AND ( p_PRICING_ATTRIBUTE11 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE12 = p_PRICING_ATTRIBUTE12)
OR ( ( Recinfo.PRICING_ATTRIBUTE12 IS NULL )
AND ( p_PRICING_ATTRIBUTE12 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE13 = p_PRICING_ATTRIBUTE13)
OR ( ( Recinfo.PRICING_ATTRIBUTE13 IS NULL )
AND ( p_PRICING_ATTRIBUTE13 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE14 = p_PRICING_ATTRIBUTE14)
OR ( ( Recinfo.PRICING_ATTRIBUTE14 IS NULL )
AND ( p_PRICING_ATTRIBUTE14 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE15 = p_PRICING_ATTRIBUTE15)
OR ( ( Recinfo.PRICING_ATTRIBUTE15 IS NULL )
AND ( p_PRICING_ATTRIBUTE15 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE16 = p_PRICING_ATTRIBUTE16)
OR ( ( Recinfo.PRICING_ATTRIBUTE16 IS NULL )
AND ( p_PRICING_ATTRIBUTE16 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE17 = p_PRICING_ATTRIBUTE17)
OR ( ( Recinfo.PRICING_ATTRIBUTE17 IS NULL )
AND ( p_PRICING_ATTRIBUTE17 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE18 = p_PRICING_ATTRIBUTE18)
OR ( ( Recinfo.PRICING_ATTRIBUTE18 IS NULL )
AND ( p_PRICING_ATTRIBUTE18 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE19 = p_PRICING_ATTRIBUTE19)
OR ( ( Recinfo.PRICING_ATTRIBUTE19 IS NULL )
AND ( p_PRICING_ATTRIBUTE19 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE20 = p_PRICING_ATTRIBUTE20)
OR ( ( Recinfo.PRICING_ATTRIBUTE20 IS NULL )
AND ( p_PRICING_ATTRIBUTE20 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE21 = p_PRICING_ATTRIBUTE21)
OR ( ( Recinfo.PRICING_ATTRIBUTE21 IS NULL )
AND ( p_PRICING_ATTRIBUTE21 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE22 = p_PRICING_ATTRIBUTE22)
OR ( ( Recinfo.PRICING_ATTRIBUTE22 IS NULL )
AND ( p_PRICING_ATTRIBUTE22 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE23 = p_PRICING_ATTRIBUTE23)
OR ( ( Recinfo.PRICING_ATTRIBUTE23 IS NULL )
AND ( p_PRICING_ATTRIBUTE23 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE24 = p_PRICING_ATTRIBUTE24)
OR ( ( Recinfo.PRICING_ATTRIBUTE24 IS NULL )
AND ( p_PRICING_ATTRIBUTE24 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE25 = p_PRICING_ATTRIBUTE25)
OR ( ( Recinfo.PRICING_ATTRIBUTE25 IS NULL )
AND ( p_PRICING_ATTRIBUTE25 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE26 = p_PRICING_ATTRIBUTE26)
OR ( ( Recinfo.PRICING_ATTRIBUTE26 IS NULL )
AND ( p_PRICING_ATTRIBUTE26 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE27 = p_PRICING_ATTRIBUTE27)
OR ( ( Recinfo.PRICING_ATTRIBUTE27 IS NULL )
AND ( p_PRICING_ATTRIBUTE27 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE28 = p_PRICING_ATTRIBUTE28)
OR ( ( Recinfo.PRICING_ATTRIBUTE28 IS NULL )
AND ( p_PRICING_ATTRIBUTE28 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE29 = p_PRICING_ATTRIBUTE29)
OR ( ( Recinfo.PRICING_ATTRIBUTE29 IS NULL )
AND ( p_PRICING_ATTRIBUTE29 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE30 = p_PRICING_ATTRIBUTE30)
OR ( ( Recinfo.PRICING_ATTRIBUTE30 IS NULL )
AND ( p_PRICING_ATTRIBUTE30 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE31 = p_PRICING_ATTRIBUTE31)
OR ( ( Recinfo.PRICING_ATTRIBUTE31 IS NULL )
AND ( p_PRICING_ATTRIBUTE31 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE32 = p_PRICING_ATTRIBUTE32)
OR ( ( Recinfo.PRICING_ATTRIBUTE32 IS NULL )
AND ( p_PRICING_ATTRIBUTE32 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE33 = p_PRICING_ATTRIBUTE33)
OR ( ( Recinfo.PRICING_ATTRIBUTE33 IS NULL )
AND ( p_PRICING_ATTRIBUTE33 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE34 = p_PRICING_ATTRIBUTE34)
OR ( ( Recinfo.PRICING_ATTRIBUTE34 IS NULL )
AND ( p_PRICING_ATTRIBUTE34 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE35 = p_PRICING_ATTRIBUTE35)
OR ( ( Recinfo.PRICING_ATTRIBUTE35 IS NULL )
AND ( p_PRICING_ATTRIBUTE35 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE36 = p_PRICING_ATTRIBUTE36)
OR ( ( Recinfo.PRICING_ATTRIBUTE36 IS NULL )
AND ( p_PRICING_ATTRIBUTE36 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE37 = p_PRICING_ATTRIBUTE37)
OR ( ( Recinfo.PRICING_ATTRIBUTE37 IS NULL )
AND ( p_PRICING_ATTRIBUTE37 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE38 = p_PRICING_ATTRIBUTE38)
OR ( ( Recinfo.PRICING_ATTRIBUTE38 IS NULL )
AND ( p_PRICING_ATTRIBUTE38 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE39 = p_PRICING_ATTRIBUTE39)
OR ( ( Recinfo.PRICING_ATTRIBUTE39 IS NULL )
AND ( p_PRICING_ATTRIBUTE39 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE40 = p_PRICING_ATTRIBUTE40)
OR ( ( Recinfo.PRICING_ATTRIBUTE40 IS NULL )
AND ( p_PRICING_ATTRIBUTE40 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE41 = p_PRICING_ATTRIBUTE41)
OR ( ( Recinfo.PRICING_ATTRIBUTE41 IS NULL )
AND ( p_PRICING_ATTRIBUTE41 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE42 = p_PRICING_ATTRIBUTE42)
OR ( ( Recinfo.PRICING_ATTRIBUTE42 IS NULL )
AND ( p_PRICING_ATTRIBUTE42 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE43 = p_PRICING_ATTRIBUTE43)
OR ( ( Recinfo.PRICING_ATTRIBUTE43 IS NULL )
AND ( p_PRICING_ATTRIBUTE43 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE44 = p_PRICING_ATTRIBUTE44)
OR ( ( Recinfo.PRICING_ATTRIBUTE44 IS NULL )
AND ( p_PRICING_ATTRIBUTE44 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE45 = p_PRICING_ATTRIBUTE45)
OR ( ( Recinfo.PRICING_ATTRIBUTE45 IS NULL )
AND ( p_PRICING_ATTRIBUTE45 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE46 = p_PRICING_ATTRIBUTE46)
OR ( ( Recinfo.PRICING_ATTRIBUTE46 IS NULL )
AND ( p_PRICING_ATTRIBUTE46 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE47 = p_PRICING_ATTRIBUTE47)
OR ( ( Recinfo.PRICING_ATTRIBUTE47 IS NULL )
AND ( p_PRICING_ATTRIBUTE47 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE48 = p_PRICING_ATTRIBUTE48)
OR ( ( Recinfo.PRICING_ATTRIBUTE48 IS NULL )
AND ( p_PRICING_ATTRIBUTE48 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE49 = p_PRICING_ATTRIBUTE49)
OR ( ( Recinfo.PRICING_ATTRIBUTE49 IS NULL )
AND ( p_PRICING_ATTRIBUTE49 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE50 = p_PRICING_ATTRIBUTE50)
OR ( ( Recinfo.PRICING_ATTRIBUTE50 IS NULL )
AND ( p_PRICING_ATTRIBUTE50 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE51 = p_PRICING_ATTRIBUTE51)
OR ( ( Recinfo.PRICING_ATTRIBUTE51 IS NULL )
AND ( p_PRICING_ATTRIBUTE51 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE52 = p_PRICING_ATTRIBUTE52)
OR ( ( Recinfo.PRICING_ATTRIBUTE52 IS NULL )
AND ( p_PRICING_ATTRIBUTE52 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE53 = p_PRICING_ATTRIBUTE53)
OR ( ( Recinfo.PRICING_ATTRIBUTE53 IS NULL )
AND ( p_PRICING_ATTRIBUTE53 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE54 = p_PRICING_ATTRIBUTE54)
OR ( ( Recinfo.PRICING_ATTRIBUTE54 IS NULL )
AND ( p_PRICING_ATTRIBUTE54 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE55 = p_PRICING_ATTRIBUTE55)
OR ( ( Recinfo.PRICING_ATTRIBUTE55 IS NULL )
AND ( p_PRICING_ATTRIBUTE55 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE56 = p_PRICING_ATTRIBUTE56)
OR ( ( Recinfo.PRICING_ATTRIBUTE56 IS NULL )
AND ( p_PRICING_ATTRIBUTE56 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE57 = p_PRICING_ATTRIBUTE57)
OR ( ( Recinfo.PRICING_ATTRIBUTE57 IS NULL )
AND ( p_PRICING_ATTRIBUTE57 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE58 = p_PRICING_ATTRIBUTE58)
OR ( ( Recinfo.PRICING_ATTRIBUTE58 IS NULL )
AND ( p_PRICING_ATTRIBUTE58 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE59 = p_PRICING_ATTRIBUTE59)
OR ( ( Recinfo.PRICING_ATTRIBUTE59 IS NULL )
AND ( p_PRICING_ATTRIBUTE59 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE60 = p_PRICING_ATTRIBUTE60)
OR ( ( Recinfo.PRICING_ATTRIBUTE60 IS NULL )
AND ( p_PRICING_ATTRIBUTE60 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE61 = p_PRICING_ATTRIBUTE61)
OR ( ( Recinfo.PRICING_ATTRIBUTE61 IS NULL )
AND ( p_PRICING_ATTRIBUTE61 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE62 = p_PRICING_ATTRIBUTE62)
OR ( ( Recinfo.PRICING_ATTRIBUTE62 IS NULL )
AND ( p_PRICING_ATTRIBUTE62 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE63 = p_PRICING_ATTRIBUTE63)
OR ( ( Recinfo.PRICING_ATTRIBUTE63 IS NULL )
AND ( p_PRICING_ATTRIBUTE63 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE64 = p_PRICING_ATTRIBUTE64)
OR ( ( Recinfo.PRICING_ATTRIBUTE64 IS NULL )
AND ( p_PRICING_ATTRIBUTE64 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE65 = p_PRICING_ATTRIBUTE65)
OR ( ( Recinfo.PRICING_ATTRIBUTE65 IS NULL )
AND ( p_PRICING_ATTRIBUTE65 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE66 = p_PRICING_ATTRIBUTE66)
OR ( ( Recinfo.PRICING_ATTRIBUTE66 IS NULL )
AND ( p_PRICING_ATTRIBUTE66 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE67 = p_PRICING_ATTRIBUTE67)
OR ( ( Recinfo.PRICING_ATTRIBUTE67 IS NULL )
AND ( p_PRICING_ATTRIBUTE67 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE68 = p_PRICING_ATTRIBUTE68)
OR ( ( Recinfo.PRICING_ATTRIBUTE68 IS NULL )
AND ( p_PRICING_ATTRIBUTE68 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE69 = p_PRICING_ATTRIBUTE69)
OR ( ( Recinfo.PRICING_ATTRIBUTE69 IS NULL )
AND ( p_PRICING_ATTRIBUTE69 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE70 = p_PRICING_ATTRIBUTE70)
OR ( ( Recinfo.PRICING_ATTRIBUTE70 IS NULL )
AND ( p_PRICING_ATTRIBUTE70 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE71 = p_PRICING_ATTRIBUTE71)
OR ( ( Recinfo.PRICING_ATTRIBUTE71 IS NULL )
AND ( p_PRICING_ATTRIBUTE71 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE72 = p_PRICING_ATTRIBUTE72)
OR ( ( Recinfo.PRICING_ATTRIBUTE72 IS NULL )
AND ( p_PRICING_ATTRIBUTE72 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE73 = p_PRICING_ATTRIBUTE73)
OR ( ( Recinfo.PRICING_ATTRIBUTE73 IS NULL )
AND ( p_PRICING_ATTRIBUTE73 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE74 = p_PRICING_ATTRIBUTE74)
OR ( ( Recinfo.PRICING_ATTRIBUTE74 IS NULL )
AND ( p_PRICING_ATTRIBUTE74 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE75 = p_PRICING_ATTRIBUTE75)
OR ( ( Recinfo.PRICING_ATTRIBUTE75 IS NULL )
AND ( p_PRICING_ATTRIBUTE75 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE76 = p_PRICING_ATTRIBUTE76)
OR ( ( Recinfo.PRICING_ATTRIBUTE76 IS NULL )
AND ( p_PRICING_ATTRIBUTE76 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE77 = p_PRICING_ATTRIBUTE77)
OR ( ( Recinfo.PRICING_ATTRIBUTE77 IS NULL )
AND ( p_PRICING_ATTRIBUTE77 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE78 = p_PRICING_ATTRIBUTE78)
OR ( ( Recinfo.PRICING_ATTRIBUTE78 IS NULL )
AND ( p_PRICING_ATTRIBUTE78 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE79 = p_PRICING_ATTRIBUTE79)
OR ( ( Recinfo.PRICING_ATTRIBUTE79 IS NULL )
AND ( p_PRICING_ATTRIBUTE79 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE80 = p_PRICING_ATTRIBUTE80)
OR ( ( Recinfo.PRICING_ATTRIBUTE80 IS NULL )
AND ( p_PRICING_ATTRIBUTE80 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE81 = p_PRICING_ATTRIBUTE81)
OR ( ( Recinfo.PRICING_ATTRIBUTE81 IS NULL )
AND ( p_PRICING_ATTRIBUTE81 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE82 = p_PRICING_ATTRIBUTE82)
OR ( ( Recinfo.PRICING_ATTRIBUTE82 IS NULL )
AND ( p_PRICING_ATTRIBUTE82 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE83 = p_PRICING_ATTRIBUTE83)
OR ( ( Recinfo.PRICING_ATTRIBUTE83 IS NULL )
AND ( p_PRICING_ATTRIBUTE83 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE84 = p_PRICING_ATTRIBUTE84)
OR ( ( Recinfo.PRICING_ATTRIBUTE84 IS NULL )
AND ( p_PRICING_ATTRIBUTE84 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE85 = p_PRICING_ATTRIBUTE85)
OR ( ( Recinfo.PRICING_ATTRIBUTE85 IS NULL )
AND ( p_PRICING_ATTRIBUTE85 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE86 = p_PRICING_ATTRIBUTE86)
OR ( ( Recinfo.PRICING_ATTRIBUTE86 IS NULL )
AND ( p_PRICING_ATTRIBUTE86 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE87 = p_PRICING_ATTRIBUTE87)
OR ( ( Recinfo.PRICING_ATTRIBUTE87 IS NULL )
AND ( p_PRICING_ATTRIBUTE87 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE88 = p_PRICING_ATTRIBUTE88)
OR ( ( Recinfo.PRICING_ATTRIBUTE88 IS NULL )
AND ( p_PRICING_ATTRIBUTE88 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE89 = p_PRICING_ATTRIBUTE89)
OR ( ( Recinfo.PRICING_ATTRIBUTE89 IS NULL )
AND ( p_PRICING_ATTRIBUTE89 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE90 = p_PRICING_ATTRIBUTE90)
OR ( ( Recinfo.PRICING_ATTRIBUTE90 IS NULL )
AND ( p_PRICING_ATTRIBUTE90 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE91 = p_PRICING_ATTRIBUTE91)
OR ( ( Recinfo.PRICING_ATTRIBUTE91 IS NULL )
AND ( p_PRICING_ATTRIBUTE91 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE92 = p_PRICING_ATTRIBUTE92)
OR ( ( Recinfo.PRICING_ATTRIBUTE92 IS NULL )
AND ( p_PRICING_ATTRIBUTE92 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE93 = p_PRICING_ATTRIBUTE93)
OR ( ( Recinfo.PRICING_ATTRIBUTE93 IS NULL )
AND ( p_PRICING_ATTRIBUTE93 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE94 = p_PRICING_ATTRIBUTE94)
OR ( ( Recinfo.PRICING_ATTRIBUTE94 IS NULL )
AND ( p_PRICING_ATTRIBUTE94 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE95 = p_PRICING_ATTRIBUTE95)
OR ( ( Recinfo.PRICING_ATTRIBUTE95 IS NULL )
AND ( p_PRICING_ATTRIBUTE95 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE96 = p_PRICING_ATTRIBUTE96)
OR ( ( Recinfo.PRICING_ATTRIBUTE96 IS NULL )
AND ( p_PRICING_ATTRIBUTE96 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE97 = p_PRICING_ATTRIBUTE97)
OR ( ( Recinfo.PRICING_ATTRIBUTE97 IS NULL )
AND ( p_PRICING_ATTRIBUTE97 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE98 = p_PRICING_ATTRIBUTE98)
OR ( ( Recinfo.PRICING_ATTRIBUTE98 IS NULL )
AND ( p_PRICING_ATTRIBUTE98 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE99 = p_PRICING_ATTRIBUTE99)
OR ( ( Recinfo.PRICING_ATTRIBUTE99 IS NULL )
AND ( p_PRICING_ATTRIBUTE99 IS NULL )))
AND ( ( Recinfo.PRICING_ATTRIBUTE100 = p_PRICING_ATTRIBUTE100)
OR ( ( Recinfo.PRICING_ATTRIBUTE100 IS NULL )
AND ( p_PRICING_ATTRIBUTE100 IS NULL )))
AND ( ( Recinfo.CONTEXT = p_CONTEXT)
OR ( ( Recinfo.CONTEXT IS NULL )
AND ( p_CONTEXT IS NULL )))
AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
AND ( p_ATTRIBUTE1 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
AND ( p_ATTRIBUTE2 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
AND ( p_ATTRIBUTE3 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
AND ( p_ATTRIBUTE4 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
AND ( p_ATTRIBUTE5 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
AND ( p_ATTRIBUTE6 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
AND ( p_ATTRIBUTE7 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
AND ( p_ATTRIBUTE8 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
AND ( p_ATTRIBUTE9 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
AND ( p_ATTRIBUTE10 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
AND ( p_ATTRIBUTE11 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
AND ( p_ATTRIBUTE12 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
AND ( p_ATTRIBUTE13 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
AND ( p_ATTRIBUTE14 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
AND ( p_ATTRIBUTE15 IS NULL )))
*/
) then
return;