[Home] [Help]
21:
22:
23: PROCEDURE Query_Rows
24: ( p_order_price_attrib_id IN NUMBER :=
25: FND_API.G_MISS_NUM
26: , p_Line_id IN NUMBER :=
27: FND_API.G_MISS_NUM
28: , x_Line_Price_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
29: )
23: PROCEDURE Query_Rows
24: ( p_order_price_attrib_id IN NUMBER :=
25: FND_API.G_MISS_NUM
26: , p_Line_id IN NUMBER :=
27: FND_API.G_MISS_NUM
28: , x_Line_Price_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
29: )
30: IS
31: l_count NUMBER;
175:
176: IF
177: (p_order_price_attrib_id IS NOT NULL
178: AND
179: p_order_price_attrib_id <> FND_API.G_MISS_NUM)
180: AND
181: (p_line_id IS NOT NULL
182: AND
183: p_line_id <> FND_API.G_MISS_NUM)
179: p_order_price_attrib_id <> FND_API.G_MISS_NUM)
180: AND
181: (p_line_id IS NOT NULL
182: AND
183: p_line_id <> FND_API.G_MISS_NUM)
184: THEN
185:
186: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
187: THEN
190: , 'Query Rows'
191: , 'Keys are mutually exclusive'
192: );
193: END IF;
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195: END IF;
196:
197: l_count := 1;
198: FOR imp_rec IN l_Line_price_att_csr LOOP
340: x_line_price_att_tbl(l_count).override_flag := imp_rec.override_flag;
341: x_line_price_att_tbl(l_count).lock_control := imp_rec.lock_control;
342: x_line_price_att_tbl(l_count).orig_sys_atts_ref := imp_rec.orig_sys_atts_ref;
343: -- set values for non-DB fields
344: x_line_price_att_tbl(l_count).db_flag := FND_API.G_TRUE;
345: x_line_price_att_tbl(l_count).operation := FND_API.G_MISS_CHAR;
346: x_line_price_att_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
347:
348: l_count := l_count + 1;
341: x_line_price_att_tbl(l_count).lock_control := imp_rec.lock_control;
342: x_line_price_att_tbl(l_count).orig_sys_atts_ref := imp_rec.orig_sys_atts_ref;
343: -- set values for non-DB fields
344: x_line_price_att_tbl(l_count).db_flag := FND_API.G_TRUE;
345: x_line_price_att_tbl(l_count).operation := FND_API.G_MISS_CHAR;
346: x_line_price_att_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
347:
348: l_count := l_count + 1;
349: END LOOP;
342: x_line_price_att_tbl(l_count).orig_sys_atts_ref := imp_rec.orig_sys_atts_ref;
343: -- set values for non-DB fields
344: x_line_price_att_tbl(l_count).db_flag := FND_API.G_TRUE;
345: x_line_price_att_tbl(l_count).operation := FND_API.G_MISS_CHAR;
346: x_line_price_att_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
347:
348: l_count := l_count + 1;
349: END LOOP;
350:
348: l_count := l_count + 1;
349: END LOOP;
350:
351: IF ( p_order_price_attrib_id IS NOT NULL
352: and p_order_price_attrib_id <> FND_API.G_MISS_NUM )
353: AND
354: ( x_Line_price_att_tbl.COUNT = 0 )
355: THEN
356: RAISE NO_DATA_FOUND;
358:
359:
360: EXCEPTION
361:
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363:
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365:
366: WHEN OTHERS THEN
360: EXCEPTION
361:
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363:
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365:
366: WHEN OTHERS THEN
367:
368: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
372: , 'Query_Rows'
373: );
374: END IF;
375:
376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
377:
378: END Query_Rows;
379:
380:
674: ( G_PKG_NAME
675: , 'Insert_Row'
676: );
677: END IF;
678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
679:
680:
681: END Insert_Row;
682:
682:
683:
684: PROCEDURE Delete_Row
685: ( p_order_price_attrib_id NUMBER :=
686: FND_API.G_MISS_NUM
687: , p_line_id NUMBER :=
688: FND_API.G_MISS_NUM
689: )
690: IS
684: PROCEDURE Delete_Row
685: ( p_order_price_attrib_id NUMBER :=
686: FND_API.G_MISS_NUM
687: , p_line_id NUMBER :=
688: FND_API.G_MISS_NUM
689: )
690: IS
691: BEGIN
692: IF p_line_id <> FND_API.G_MISS_NUM then
688: FND_API.G_MISS_NUM
689: )
690: IS
691: BEGIN
692: IF p_line_id <> FND_API.G_MISS_NUM then
693:
694: DELETE FROM OE_ORDER_PRICE_ATTRIBS
695: WHERE Line_Id = p_Line_id;
696: Else
708: ( G_PKG_NAME
709: , 'Delete_Row'
710: );
711: END IF;
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
713:
714: END Delete_Row;
715:
716:
885: ( G_PKG_NAME
886: , 'Update_Row'
887: );
888: END IF;
889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
890:
891: END Update_Row;
892:
893:
892:
893:
894:
895: PROCEDURE Clear_Dependent_Attr
896: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
897: , p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
898: , p_old_Line_Price_Att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type :=
899: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC
900: -- , x_Line_Price_Att_rec OUT OE_Order_PUB.Line_Price_Att_Rec_Type
911:
912: -- If attr_id is missing compare old and new records and for
913: -- every changed attribute clear its dependent fields.
914:
915: IF p_attr_id = FND_API.G_MISS_NUM THEN
916:
917: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute1,p_old_Line_price_att_rec.attribute1)
918: THEN
919: l_index := l_index + 1;
2113:
2114: l_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type := p_x_Line_Price_Att_rec;
2115: BEGIN
2116:
2117: IF l_Line_price_att_rec.override_flag = FND_API.G_MISS_CHAR THEN
2118: l_Line_price_att_rec.override_flag := p_old_Line_price_att_rec.override_flag;
2119: END IF;
2120:
2121: IF l_Line_price_att_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2117: IF l_Line_price_att_rec.override_flag = FND_API.G_MISS_CHAR THEN
2118: l_Line_price_att_rec.override_flag := p_old_Line_price_att_rec.override_flag;
2119: END IF;
2120:
2121: IF l_Line_price_att_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2122: l_Line_price_att_rec.attribute1 := p_old_Line_price_att_rec.attribute1;
2123: END IF;
2124:
2125: IF l_Line_price_att_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2121: IF l_Line_price_att_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2122: l_Line_price_att_rec.attribute1 := p_old_Line_price_att_rec.attribute1;
2123: END IF;
2124:
2125: IF l_Line_price_att_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2126: l_Line_price_att_rec.attribute10 := p_old_Line_price_att_rec.attribute10;
2127: END IF;
2128:
2129: IF l_Line_price_att_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2125: IF l_Line_price_att_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2126: l_Line_price_att_rec.attribute10 := p_old_Line_price_att_rec.attribute10;
2127: END IF;
2128:
2129: IF l_Line_price_att_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2130: l_Line_price_att_rec.attribute11 := p_old_Line_price_att_rec.attribute11;
2131: END IF;
2132:
2133: IF l_Line_price_att_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2129: IF l_Line_price_att_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2130: l_Line_price_att_rec.attribute11 := p_old_Line_price_att_rec.attribute11;
2131: END IF;
2132:
2133: IF l_Line_price_att_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2134: l_Line_price_att_rec.attribute12 := p_old_Line_price_att_rec.attribute12;
2135: END IF;
2136:
2137: IF l_Line_price_att_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2133: IF l_Line_price_att_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2134: l_Line_price_att_rec.attribute12 := p_old_Line_price_att_rec.attribute12;
2135: END IF;
2136:
2137: IF l_Line_price_att_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2138: l_Line_price_att_rec.attribute13 := p_old_Line_price_att_rec.attribute13;
2139: END IF;
2140:
2141: IF l_Line_price_att_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2137: IF l_Line_price_att_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2138: l_Line_price_att_rec.attribute13 := p_old_Line_price_att_rec.attribute13;
2139: END IF;
2140:
2141: IF l_Line_price_att_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2142: l_Line_price_att_rec.attribute14 := p_old_Line_price_att_rec.attribute14;
2143: END IF;
2144:
2145: IF l_Line_price_att_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2141: IF l_Line_price_att_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2142: l_Line_price_att_rec.attribute14 := p_old_Line_price_att_rec.attribute14;
2143: END IF;
2144:
2145: IF l_Line_price_att_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2146: l_Line_price_att_rec.attribute15 := p_old_Line_price_att_rec.attribute15;
2147: END IF;
2148:
2149: IF l_Line_price_att_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2145: IF l_Line_price_att_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2146: l_Line_price_att_rec.attribute15 := p_old_Line_price_att_rec.attribute15;
2147: END IF;
2148:
2149: IF l_Line_price_att_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2150: l_Line_price_att_rec.attribute2 := p_old_Line_price_att_rec.attribute2;
2151: END IF;
2152:
2153: IF l_Line_price_att_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2149: IF l_Line_price_att_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2150: l_Line_price_att_rec.attribute2 := p_old_Line_price_att_rec.attribute2;
2151: END IF;
2152:
2153: IF l_Line_price_att_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2154: l_Line_price_att_rec.attribute3 := p_old_Line_price_att_rec.attribute3;
2155: END IF;
2156:
2157: IF l_Line_price_att_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2153: IF l_Line_price_att_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2154: l_Line_price_att_rec.attribute3 := p_old_Line_price_att_rec.attribute3;
2155: END IF;
2156:
2157: IF l_Line_price_att_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2158: l_Line_price_att_rec.attribute4 := p_old_Line_price_att_rec.attribute4;
2159: END IF;
2160:
2161: IF l_Line_price_att_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2157: IF l_Line_price_att_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2158: l_Line_price_att_rec.attribute4 := p_old_Line_price_att_rec.attribute4;
2159: END IF;
2160:
2161: IF l_Line_price_att_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2162: l_Line_price_att_rec.attribute5 := p_old_Line_price_att_rec.attribute5;
2163: END IF;
2164:
2165: IF l_Line_price_att_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2161: IF l_Line_price_att_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2162: l_Line_price_att_rec.attribute5 := p_old_Line_price_att_rec.attribute5;
2163: END IF;
2164:
2165: IF l_Line_price_att_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2166: l_Line_price_att_rec.attribute6 := p_old_Line_price_att_rec.attribute6;
2167: END IF;
2168:
2169: IF l_Line_price_att_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2165: IF l_Line_price_att_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2166: l_Line_price_att_rec.attribute6 := p_old_Line_price_att_rec.attribute6;
2167: END IF;
2168:
2169: IF l_Line_price_att_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2170: l_Line_price_att_rec.attribute7 := p_old_Line_price_att_rec.attribute7;
2171: END IF;
2172:
2173: IF l_Line_price_att_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2169: IF l_Line_price_att_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2170: l_Line_price_att_rec.attribute7 := p_old_Line_price_att_rec.attribute7;
2171: END IF;
2172:
2173: IF l_Line_price_att_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2174: l_Line_price_att_rec.attribute8 := p_old_Line_price_att_rec.attribute8;
2175: END IF;
2176:
2177: IF l_Line_price_att_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2173: IF l_Line_price_att_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2174: l_Line_price_att_rec.attribute8 := p_old_Line_price_att_rec.attribute8;
2175: END IF;
2176:
2177: IF l_Line_price_att_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2178: l_Line_price_att_rec.attribute9 := p_old_Line_price_att_rec.attribute9;
2179: END IF;
2180:
2181: IF l_Line_price_att_rec.context = FND_API.G_MISS_CHAR THEN
2177: IF l_Line_price_att_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2178: l_Line_price_att_rec.attribute9 := p_old_Line_price_att_rec.attribute9;
2179: END IF;
2180:
2181: IF l_Line_price_att_rec.context = FND_API.G_MISS_CHAR THEN
2182: l_Line_price_att_rec.context := p_old_Line_price_att_rec.context;
2183: END IF;
2184:
2185: IF l_Line_price_att_rec.created_by = FND_API.G_MISS_NUM THEN
2181: IF l_Line_price_att_rec.context = FND_API.G_MISS_CHAR THEN
2182: l_Line_price_att_rec.context := p_old_Line_price_att_rec.context;
2183: END IF;
2184:
2185: IF l_Line_price_att_rec.created_by = FND_API.G_MISS_NUM THEN
2186: l_Line_price_att_rec.created_by := p_old_Line_price_att_rec.created_by;
2187: END IF;
2188:
2189: IF l_Line_price_att_rec.creation_date = FND_API.G_MISS_DATE THEN
2185: IF l_Line_price_att_rec.created_by = FND_API.G_MISS_NUM THEN
2186: l_Line_price_att_rec.created_by := p_old_Line_price_att_rec.created_by;
2187: END IF;
2188:
2189: IF l_Line_price_att_rec.creation_date = FND_API.G_MISS_DATE THEN
2190: l_Line_price_att_rec.creation_date := p_old_Line_price_att_rec.creation_date;
2191: END IF;
2192:
2193: IF l_Line_price_att_rec.flex_title = FND_API.G_MISS_CHAR THEN
2189: IF l_Line_price_att_rec.creation_date = FND_API.G_MISS_DATE THEN
2190: l_Line_price_att_rec.creation_date := p_old_Line_price_att_rec.creation_date;
2191: END IF;
2192:
2193: IF l_Line_price_att_rec.flex_title = FND_API.G_MISS_CHAR THEN
2194: l_Line_price_att_rec.flex_title := p_old_Line_price_att_rec.flex_title;
2195: END IF;
2196:
2197: IF l_Line_price_att_rec.header_id = FND_API.G_MISS_NUM THEN
2193: IF l_Line_price_att_rec.flex_title = FND_API.G_MISS_CHAR THEN
2194: l_Line_price_att_rec.flex_title := p_old_Line_price_att_rec.flex_title;
2195: END IF;
2196:
2197: IF l_Line_price_att_rec.header_id = FND_API.G_MISS_NUM THEN
2198: l_Line_price_att_rec.header_id := p_old_Line_price_att_rec.header_id;
2199: END IF;
2200:
2201: IF l_Line_price_att_rec.last_updated_by = FND_API.G_MISS_NUM THEN
2197: IF l_Line_price_att_rec.header_id = FND_API.G_MISS_NUM THEN
2198: l_Line_price_att_rec.header_id := p_old_Line_price_att_rec.header_id;
2199: END IF;
2200:
2201: IF l_Line_price_att_rec.last_updated_by = FND_API.G_MISS_NUM THEN
2202: l_Line_price_att_rec.last_updated_by := p_old_Line_price_att_rec.last_updated_by;
2203: END IF;
2204:
2205: IF l_Line_price_att_rec.last_update_date = FND_API.G_MISS_DATE THEN
2201: IF l_Line_price_att_rec.last_updated_by = FND_API.G_MISS_NUM THEN
2202: l_Line_price_att_rec.last_updated_by := p_old_Line_price_att_rec.last_updated_by;
2203: END IF;
2204:
2205: IF l_Line_price_att_rec.last_update_date = FND_API.G_MISS_DATE THEN
2206: l_Line_price_att_rec.last_update_date := p_old_Line_price_att_rec.last_update_date;
2207: END IF;
2208:
2209: IF l_Line_price_att_rec.last_update_login = FND_API.G_MISS_NUM THEN
2205: IF l_Line_price_att_rec.last_update_date = FND_API.G_MISS_DATE THEN
2206: l_Line_price_att_rec.last_update_date := p_old_Line_price_att_rec.last_update_date;
2207: END IF;
2208:
2209: IF l_Line_price_att_rec.last_update_login = FND_API.G_MISS_NUM THEN
2210: l_Line_price_att_rec.last_update_login := p_old_Line_price_att_rec.last_update_login;
2211: END IF;
2212:
2213: IF l_Line_price_att_rec.line_id = FND_API.G_MISS_NUM THEN
2209: IF l_Line_price_att_rec.last_update_login = FND_API.G_MISS_NUM THEN
2210: l_Line_price_att_rec.last_update_login := p_old_Line_price_att_rec.last_update_login;
2211: END IF;
2212:
2213: IF l_Line_price_att_rec.line_id = FND_API.G_MISS_NUM THEN
2214: l_Line_price_att_rec.line_id := p_old_Line_price_att_rec.line_id;
2215: END IF;
2216:
2217: IF l_Line_price_att_rec.order_price_attrib_id = FND_API.G_MISS_NUM THEN
2213: IF l_Line_price_att_rec.line_id = FND_API.G_MISS_NUM THEN
2214: l_Line_price_att_rec.line_id := p_old_Line_price_att_rec.line_id;
2215: END IF;
2216:
2217: IF l_Line_price_att_rec.order_price_attrib_id = FND_API.G_MISS_NUM THEN
2218: l_Line_price_att_rec.order_price_attrib_id := p_old_Line_price_att_rec.order_price_attrib_id;
2219: END IF;
2220:
2221: IF l_Line_price_att_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
2217: IF l_Line_price_att_rec.order_price_attrib_id = FND_API.G_MISS_NUM THEN
2218: l_Line_price_att_rec.order_price_attrib_id := p_old_Line_price_att_rec.order_price_attrib_id;
2219: END IF;
2220:
2221: IF l_Line_price_att_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
2222: l_Line_price_att_rec.pricing_attribute1 := p_old_Line_price_att_rec.pricing_attribute1;
2223: END IF;
2224:
2225: IF l_Line_price_att_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
2221: IF l_Line_price_att_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
2222: l_Line_price_att_rec.pricing_attribute1 := p_old_Line_price_att_rec.pricing_attribute1;
2223: END IF;
2224:
2225: IF l_Line_price_att_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
2226: l_Line_price_att_rec.pricing_attribute10 := p_old_Line_price_att_rec.pricing_attribute10;
2227: END IF;
2228:
2229: IF l_Line_price_att_rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN
2225: IF l_Line_price_att_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
2226: l_Line_price_att_rec.pricing_attribute10 := p_old_Line_price_att_rec.pricing_attribute10;
2227: END IF;
2228:
2229: IF l_Line_price_att_rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN
2230: l_Line_price_att_rec.pricing_attribute100 := p_old_Line_price_att_rec.pricing_attribute100;
2231: END IF;
2232:
2233: IF l_Line_price_att_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
2229: IF l_Line_price_att_rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN
2230: l_Line_price_att_rec.pricing_attribute100 := p_old_Line_price_att_rec.pricing_attribute100;
2231: END IF;
2232:
2233: IF l_Line_price_att_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
2234: l_Line_price_att_rec.pricing_attribute11 := p_old_Line_price_att_rec.pricing_attribute11;
2235: END IF;
2236:
2237: IF l_Line_price_att_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
2233: IF l_Line_price_att_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
2234: l_Line_price_att_rec.pricing_attribute11 := p_old_Line_price_att_rec.pricing_attribute11;
2235: END IF;
2236:
2237: IF l_Line_price_att_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
2238: l_Line_price_att_rec.pricing_attribute12 := p_old_Line_price_att_rec.pricing_attribute12;
2239: END IF;
2240:
2241: IF l_Line_price_att_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
2237: IF l_Line_price_att_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
2238: l_Line_price_att_rec.pricing_attribute12 := p_old_Line_price_att_rec.pricing_attribute12;
2239: END IF;
2240:
2241: IF l_Line_price_att_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
2242: l_Line_price_att_rec.pricing_attribute13 := p_old_Line_price_att_rec.pricing_attribute13;
2243: END IF;
2244:
2245: IF l_Line_price_att_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
2241: IF l_Line_price_att_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
2242: l_Line_price_att_rec.pricing_attribute13 := p_old_Line_price_att_rec.pricing_attribute13;
2243: END IF;
2244:
2245: IF l_Line_price_att_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
2246: l_Line_price_att_rec.pricing_attribute14 := p_old_Line_price_att_rec.pricing_attribute14;
2247: END IF;
2248:
2249: IF l_Line_price_att_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
2245: IF l_Line_price_att_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
2246: l_Line_price_att_rec.pricing_attribute14 := p_old_Line_price_att_rec.pricing_attribute14;
2247: END IF;
2248:
2249: IF l_Line_price_att_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
2250: l_Line_price_att_rec.pricing_attribute15 := p_old_Line_price_att_rec.pricing_attribute15;
2251: END IF;
2252:
2253: IF l_Line_price_att_rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN
2249: IF l_Line_price_att_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
2250: l_Line_price_att_rec.pricing_attribute15 := p_old_Line_price_att_rec.pricing_attribute15;
2251: END IF;
2252:
2253: IF l_Line_price_att_rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN
2254: l_Line_price_att_rec.pricing_attribute16 := p_old_Line_price_att_rec.pricing_attribute16;
2255: END IF;
2256:
2257: IF l_Line_price_att_rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN
2253: IF l_Line_price_att_rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN
2254: l_Line_price_att_rec.pricing_attribute16 := p_old_Line_price_att_rec.pricing_attribute16;
2255: END IF;
2256:
2257: IF l_Line_price_att_rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN
2258: l_Line_price_att_rec.pricing_attribute17 := p_old_Line_price_att_rec.pricing_attribute17;
2259: END IF;
2260:
2261: IF l_Line_price_att_rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN
2257: IF l_Line_price_att_rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN
2258: l_Line_price_att_rec.pricing_attribute17 := p_old_Line_price_att_rec.pricing_attribute17;
2259: END IF;
2260:
2261: IF l_Line_price_att_rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN
2262: l_Line_price_att_rec.pricing_attribute18 := p_old_Line_price_att_rec.pricing_attribute18;
2263: END IF;
2264:
2265: IF l_Line_price_att_rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN
2261: IF l_Line_price_att_rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN
2262: l_Line_price_att_rec.pricing_attribute18 := p_old_Line_price_att_rec.pricing_attribute18;
2263: END IF;
2264:
2265: IF l_Line_price_att_rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN
2266: l_Line_price_att_rec.pricing_attribute19 := p_old_Line_price_att_rec.pricing_attribute19;
2267: END IF;
2268:
2269: IF l_Line_price_att_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
2265: IF l_Line_price_att_rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN
2266: l_Line_price_att_rec.pricing_attribute19 := p_old_Line_price_att_rec.pricing_attribute19;
2267: END IF;
2268:
2269: IF l_Line_price_att_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
2270: l_Line_price_att_rec.pricing_attribute2 := p_old_Line_price_att_rec.pricing_attribute2;
2271: END IF;
2272:
2273: IF l_Line_price_att_rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN
2269: IF l_Line_price_att_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
2270: l_Line_price_att_rec.pricing_attribute2 := p_old_Line_price_att_rec.pricing_attribute2;
2271: END IF;
2272:
2273: IF l_Line_price_att_rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN
2274: l_Line_price_att_rec.pricing_attribute20 := p_old_Line_price_att_rec.pricing_attribute20;
2275: END IF;
2276:
2277: IF l_Line_price_att_rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN
2273: IF l_Line_price_att_rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN
2274: l_Line_price_att_rec.pricing_attribute20 := p_old_Line_price_att_rec.pricing_attribute20;
2275: END IF;
2276:
2277: IF l_Line_price_att_rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN
2278: l_Line_price_att_rec.pricing_attribute21 := p_old_Line_price_att_rec.pricing_attribute21;
2279: END IF;
2280:
2281: IF l_Line_price_att_rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN
2277: IF l_Line_price_att_rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN
2278: l_Line_price_att_rec.pricing_attribute21 := p_old_Line_price_att_rec.pricing_attribute21;
2279: END IF;
2280:
2281: IF l_Line_price_att_rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN
2282: l_Line_price_att_rec.pricing_attribute22 := p_old_Line_price_att_rec.pricing_attribute22;
2283: END IF;
2284:
2285: IF l_Line_price_att_rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN
2281: IF l_Line_price_att_rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN
2282: l_Line_price_att_rec.pricing_attribute22 := p_old_Line_price_att_rec.pricing_attribute22;
2283: END IF;
2284:
2285: IF l_Line_price_att_rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN
2286: l_Line_price_att_rec.pricing_attribute23 := p_old_Line_price_att_rec.pricing_attribute23;
2287: END IF;
2288:
2289: IF l_Line_price_att_rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN
2285: IF l_Line_price_att_rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN
2286: l_Line_price_att_rec.pricing_attribute23 := p_old_Line_price_att_rec.pricing_attribute23;
2287: END IF;
2288:
2289: IF l_Line_price_att_rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN
2290: l_Line_price_att_rec.pricing_attribute24 := p_old_Line_price_att_rec.pricing_attribute24;
2291: END IF;
2292:
2293: IF l_Line_price_att_rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN
2289: IF l_Line_price_att_rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN
2290: l_Line_price_att_rec.pricing_attribute24 := p_old_Line_price_att_rec.pricing_attribute24;
2291: END IF;
2292:
2293: IF l_Line_price_att_rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN
2294: l_Line_price_att_rec.pricing_attribute25 := p_old_Line_price_att_rec.pricing_attribute25;
2295: END IF;
2296:
2297: IF l_Line_price_att_rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN
2293: IF l_Line_price_att_rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN
2294: l_Line_price_att_rec.pricing_attribute25 := p_old_Line_price_att_rec.pricing_attribute25;
2295: END IF;
2296:
2297: IF l_Line_price_att_rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN
2298: l_Line_price_att_rec.pricing_attribute26 := p_old_Line_price_att_rec.pricing_attribute26;
2299: END IF;
2300:
2301: IF l_Line_price_att_rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN
2297: IF l_Line_price_att_rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN
2298: l_Line_price_att_rec.pricing_attribute26 := p_old_Line_price_att_rec.pricing_attribute26;
2299: END IF;
2300:
2301: IF l_Line_price_att_rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN
2302: l_Line_price_att_rec.pricing_attribute27 := p_old_Line_price_att_rec.pricing_attribute27;
2303: END IF;
2304:
2305: IF l_Line_price_att_rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN
2301: IF l_Line_price_att_rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN
2302: l_Line_price_att_rec.pricing_attribute27 := p_old_Line_price_att_rec.pricing_attribute27;
2303: END IF;
2304:
2305: IF l_Line_price_att_rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN
2306: l_Line_price_att_rec.pricing_attribute28 := p_old_Line_price_att_rec.pricing_attribute28;
2307: END IF;
2308:
2309: IF l_Line_price_att_rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN
2305: IF l_Line_price_att_rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN
2306: l_Line_price_att_rec.pricing_attribute28 := p_old_Line_price_att_rec.pricing_attribute28;
2307: END IF;
2308:
2309: IF l_Line_price_att_rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN
2310: l_Line_price_att_rec.pricing_attribute29 := p_old_Line_price_att_rec.pricing_attribute29;
2311: END IF;
2312:
2313: IF l_Line_price_att_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
2309: IF l_Line_price_att_rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN
2310: l_Line_price_att_rec.pricing_attribute29 := p_old_Line_price_att_rec.pricing_attribute29;
2311: END IF;
2312:
2313: IF l_Line_price_att_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
2314: l_Line_price_att_rec.pricing_attribute3 := p_old_Line_price_att_rec.pricing_attribute3;
2315: END IF;
2316:
2317: IF l_Line_price_att_rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN
2313: IF l_Line_price_att_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
2314: l_Line_price_att_rec.pricing_attribute3 := p_old_Line_price_att_rec.pricing_attribute3;
2315: END IF;
2316:
2317: IF l_Line_price_att_rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN
2318: l_Line_price_att_rec.pricing_attribute30 := p_old_Line_price_att_rec.pricing_attribute30;
2319: END IF;
2320:
2321: IF l_Line_price_att_rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN
2317: IF l_Line_price_att_rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN
2318: l_Line_price_att_rec.pricing_attribute30 := p_old_Line_price_att_rec.pricing_attribute30;
2319: END IF;
2320:
2321: IF l_Line_price_att_rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN
2322: l_Line_price_att_rec.pricing_attribute31 := p_old_Line_price_att_rec.pricing_attribute31;
2323: END IF;
2324:
2325: IF l_Line_price_att_rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN
2321: IF l_Line_price_att_rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN
2322: l_Line_price_att_rec.pricing_attribute31 := p_old_Line_price_att_rec.pricing_attribute31;
2323: END IF;
2324:
2325: IF l_Line_price_att_rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN
2326: l_Line_price_att_rec.pricing_attribute32 := p_old_Line_price_att_rec.pricing_attribute32;
2327: END IF;
2328:
2329: IF l_Line_price_att_rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN
2325: IF l_Line_price_att_rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN
2326: l_Line_price_att_rec.pricing_attribute32 := p_old_Line_price_att_rec.pricing_attribute32;
2327: END IF;
2328:
2329: IF l_Line_price_att_rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN
2330: l_Line_price_att_rec.pricing_attribute33 := p_old_Line_price_att_rec.pricing_attribute33;
2331: END IF;
2332:
2333: IF l_Line_price_att_rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN
2329: IF l_Line_price_att_rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN
2330: l_Line_price_att_rec.pricing_attribute33 := p_old_Line_price_att_rec.pricing_attribute33;
2331: END IF;
2332:
2333: IF l_Line_price_att_rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN
2334: l_Line_price_att_rec.pricing_attribute34 := p_old_Line_price_att_rec.pricing_attribute34;
2335: END IF;
2336:
2337: IF l_Line_price_att_rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN
2333: IF l_Line_price_att_rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN
2334: l_Line_price_att_rec.pricing_attribute34 := p_old_Line_price_att_rec.pricing_attribute34;
2335: END IF;
2336:
2337: IF l_Line_price_att_rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN
2338: l_Line_price_att_rec.pricing_attribute35 := p_old_Line_price_att_rec.pricing_attribute35;
2339: END IF;
2340:
2341: IF l_Line_price_att_rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN
2337: IF l_Line_price_att_rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN
2338: l_Line_price_att_rec.pricing_attribute35 := p_old_Line_price_att_rec.pricing_attribute35;
2339: END IF;
2340:
2341: IF l_Line_price_att_rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN
2342: l_Line_price_att_rec.pricing_attribute36 := p_old_Line_price_att_rec.pricing_attribute36;
2343: END IF;
2344:
2345: IF l_Line_price_att_rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN
2341: IF l_Line_price_att_rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN
2342: l_Line_price_att_rec.pricing_attribute36 := p_old_Line_price_att_rec.pricing_attribute36;
2343: END IF;
2344:
2345: IF l_Line_price_att_rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN
2346: l_Line_price_att_rec.pricing_attribute37 := p_old_Line_price_att_rec.pricing_attribute37;
2347: END IF;
2348:
2349: IF l_Line_price_att_rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN
2345: IF l_Line_price_att_rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN
2346: l_Line_price_att_rec.pricing_attribute37 := p_old_Line_price_att_rec.pricing_attribute37;
2347: END IF;
2348:
2349: IF l_Line_price_att_rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN
2350: l_Line_price_att_rec.pricing_attribute38 := p_old_Line_price_att_rec.pricing_attribute38;
2351: END IF;
2352:
2353: IF l_Line_price_att_rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN
2349: IF l_Line_price_att_rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN
2350: l_Line_price_att_rec.pricing_attribute38 := p_old_Line_price_att_rec.pricing_attribute38;
2351: END IF;
2352:
2353: IF l_Line_price_att_rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN
2354: l_Line_price_att_rec.pricing_attribute39 := p_old_Line_price_att_rec.pricing_attribute39;
2355: END IF;
2356:
2357: IF l_Line_price_att_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
2353: IF l_Line_price_att_rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN
2354: l_Line_price_att_rec.pricing_attribute39 := p_old_Line_price_att_rec.pricing_attribute39;
2355: END IF;
2356:
2357: IF l_Line_price_att_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
2358: l_Line_price_att_rec.pricing_attribute4 := p_old_Line_price_att_rec.pricing_attribute4;
2359: END IF;
2360:
2361: IF l_Line_price_att_rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN
2357: IF l_Line_price_att_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
2358: l_Line_price_att_rec.pricing_attribute4 := p_old_Line_price_att_rec.pricing_attribute4;
2359: END IF;
2360:
2361: IF l_Line_price_att_rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN
2362: l_Line_price_att_rec.pricing_attribute40 := p_old_Line_price_att_rec.pricing_attribute40;
2363: END IF;
2364:
2365: IF l_Line_price_att_rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN
2361: IF l_Line_price_att_rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN
2362: l_Line_price_att_rec.pricing_attribute40 := p_old_Line_price_att_rec.pricing_attribute40;
2363: END IF;
2364:
2365: IF l_Line_price_att_rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN
2366: l_Line_price_att_rec.pricing_attribute41 := p_old_Line_price_att_rec.pricing_attribute41;
2367: END IF;
2368:
2369: IF l_Line_price_att_rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN
2365: IF l_Line_price_att_rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN
2366: l_Line_price_att_rec.pricing_attribute41 := p_old_Line_price_att_rec.pricing_attribute41;
2367: END IF;
2368:
2369: IF l_Line_price_att_rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN
2370: l_Line_price_att_rec.pricing_attribute42 := p_old_Line_price_att_rec.pricing_attribute42;
2371: END IF;
2372:
2373: IF l_Line_price_att_rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN
2369: IF l_Line_price_att_rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN
2370: l_Line_price_att_rec.pricing_attribute42 := p_old_Line_price_att_rec.pricing_attribute42;
2371: END IF;
2372:
2373: IF l_Line_price_att_rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN
2374: l_Line_price_att_rec.pricing_attribute43 := p_old_Line_price_att_rec.pricing_attribute43;
2375: END IF;
2376:
2377: IF l_Line_price_att_rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN
2373: IF l_Line_price_att_rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN
2374: l_Line_price_att_rec.pricing_attribute43 := p_old_Line_price_att_rec.pricing_attribute43;
2375: END IF;
2376:
2377: IF l_Line_price_att_rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN
2378: l_Line_price_att_rec.pricing_attribute44 := p_old_Line_price_att_rec.pricing_attribute44;
2379: END IF;
2380:
2381: IF l_Line_price_att_rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN
2377: IF l_Line_price_att_rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN
2378: l_Line_price_att_rec.pricing_attribute44 := p_old_Line_price_att_rec.pricing_attribute44;
2379: END IF;
2380:
2381: IF l_Line_price_att_rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN
2382: l_Line_price_att_rec.pricing_attribute45 := p_old_Line_price_att_rec.pricing_attribute45;
2383: END IF;
2384:
2385: IF l_Line_price_att_rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN
2381: IF l_Line_price_att_rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN
2382: l_Line_price_att_rec.pricing_attribute45 := p_old_Line_price_att_rec.pricing_attribute45;
2383: END IF;
2384:
2385: IF l_Line_price_att_rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN
2386: l_Line_price_att_rec.pricing_attribute46 := p_old_Line_price_att_rec.pricing_attribute46;
2387: END IF;
2388:
2389: IF l_Line_price_att_rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN
2385: IF l_Line_price_att_rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN
2386: l_Line_price_att_rec.pricing_attribute46 := p_old_Line_price_att_rec.pricing_attribute46;
2387: END IF;
2388:
2389: IF l_Line_price_att_rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN
2390: l_Line_price_att_rec.pricing_attribute47 := p_old_Line_price_att_rec.pricing_attribute47;
2391: END IF;
2392:
2393: IF l_Line_price_att_rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN
2389: IF l_Line_price_att_rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN
2390: l_Line_price_att_rec.pricing_attribute47 := p_old_Line_price_att_rec.pricing_attribute47;
2391: END IF;
2392:
2393: IF l_Line_price_att_rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN
2394: l_Line_price_att_rec.pricing_attribute48 := p_old_Line_price_att_rec.pricing_attribute48;
2395: END IF;
2396:
2397: IF l_Line_price_att_rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN
2393: IF l_Line_price_att_rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN
2394: l_Line_price_att_rec.pricing_attribute48 := p_old_Line_price_att_rec.pricing_attribute48;
2395: END IF;
2396:
2397: IF l_Line_price_att_rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN
2398: l_Line_price_att_rec.pricing_attribute49 := p_old_Line_price_att_rec.pricing_attribute49;
2399: END IF;
2400:
2401: IF l_Line_price_att_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
2397: IF l_Line_price_att_rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN
2398: l_Line_price_att_rec.pricing_attribute49 := p_old_Line_price_att_rec.pricing_attribute49;
2399: END IF;
2400:
2401: IF l_Line_price_att_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
2402: l_Line_price_att_rec.pricing_attribute5 := p_old_Line_price_att_rec.pricing_attribute5;
2403: END IF;
2404:
2405: IF l_Line_price_att_rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN
2401: IF l_Line_price_att_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
2402: l_Line_price_att_rec.pricing_attribute5 := p_old_Line_price_att_rec.pricing_attribute5;
2403: END IF;
2404:
2405: IF l_Line_price_att_rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN
2406: l_Line_price_att_rec.pricing_attribute50 := p_old_Line_price_att_rec.pricing_attribute50;
2407: END IF;
2408:
2409: IF l_Line_price_att_rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN
2405: IF l_Line_price_att_rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN
2406: l_Line_price_att_rec.pricing_attribute50 := p_old_Line_price_att_rec.pricing_attribute50;
2407: END IF;
2408:
2409: IF l_Line_price_att_rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN
2410: l_Line_price_att_rec.pricing_attribute51 := p_old_Line_price_att_rec.pricing_attribute51;
2411: END IF;
2412:
2413: IF l_Line_price_att_rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN
2409: IF l_Line_price_att_rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN
2410: l_Line_price_att_rec.pricing_attribute51 := p_old_Line_price_att_rec.pricing_attribute51;
2411: END IF;
2412:
2413: IF l_Line_price_att_rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN
2414: l_Line_price_att_rec.pricing_attribute52 := p_old_Line_price_att_rec.pricing_attribute52;
2415: END IF;
2416:
2417: IF l_Line_price_att_rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN
2413: IF l_Line_price_att_rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN
2414: l_Line_price_att_rec.pricing_attribute52 := p_old_Line_price_att_rec.pricing_attribute52;
2415: END IF;
2416:
2417: IF l_Line_price_att_rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN
2418: l_Line_price_att_rec.pricing_attribute53 := p_old_Line_price_att_rec.pricing_attribute53;
2419: END IF;
2420:
2421: IF l_Line_price_att_rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN
2417: IF l_Line_price_att_rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN
2418: l_Line_price_att_rec.pricing_attribute53 := p_old_Line_price_att_rec.pricing_attribute53;
2419: END IF;
2420:
2421: IF l_Line_price_att_rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN
2422: l_Line_price_att_rec.pricing_attribute54 := p_old_Line_price_att_rec.pricing_attribute54;
2423: END IF;
2424:
2425: IF l_Line_price_att_rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN
2421: IF l_Line_price_att_rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN
2422: l_Line_price_att_rec.pricing_attribute54 := p_old_Line_price_att_rec.pricing_attribute54;
2423: END IF;
2424:
2425: IF l_Line_price_att_rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN
2426: l_Line_price_att_rec.pricing_attribute55 := p_old_Line_price_att_rec.pricing_attribute55;
2427: END IF;
2428:
2429: IF l_Line_price_att_rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN
2425: IF l_Line_price_att_rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN
2426: l_Line_price_att_rec.pricing_attribute55 := p_old_Line_price_att_rec.pricing_attribute55;
2427: END IF;
2428:
2429: IF l_Line_price_att_rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN
2430: l_Line_price_att_rec.pricing_attribute56 := p_old_Line_price_att_rec.pricing_attribute56;
2431: END IF;
2432:
2433: IF l_Line_price_att_rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN
2429: IF l_Line_price_att_rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN
2430: l_Line_price_att_rec.pricing_attribute56 := p_old_Line_price_att_rec.pricing_attribute56;
2431: END IF;
2432:
2433: IF l_Line_price_att_rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN
2434: l_Line_price_att_rec.pricing_attribute57 := p_old_Line_price_att_rec.pricing_attribute57;
2435: END IF;
2436:
2437: IF l_Line_price_att_rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN
2433: IF l_Line_price_att_rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN
2434: l_Line_price_att_rec.pricing_attribute57 := p_old_Line_price_att_rec.pricing_attribute57;
2435: END IF;
2436:
2437: IF l_Line_price_att_rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN
2438: l_Line_price_att_rec.pricing_attribute58 := p_old_Line_price_att_rec.pricing_attribute58;
2439: END IF;
2440:
2441: IF l_Line_price_att_rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN
2437: IF l_Line_price_att_rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN
2438: l_Line_price_att_rec.pricing_attribute58 := p_old_Line_price_att_rec.pricing_attribute58;
2439: END IF;
2440:
2441: IF l_Line_price_att_rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN
2442: l_Line_price_att_rec.pricing_attribute59 := p_old_Line_price_att_rec.pricing_attribute59;
2443: END IF;
2444:
2445: IF l_Line_price_att_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
2441: IF l_Line_price_att_rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN
2442: l_Line_price_att_rec.pricing_attribute59 := p_old_Line_price_att_rec.pricing_attribute59;
2443: END IF;
2444:
2445: IF l_Line_price_att_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
2446: l_Line_price_att_rec.pricing_attribute6 := p_old_Line_price_att_rec.pricing_attribute6;
2447: END IF;
2448:
2449: IF l_Line_price_att_rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN
2445: IF l_Line_price_att_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
2446: l_Line_price_att_rec.pricing_attribute6 := p_old_Line_price_att_rec.pricing_attribute6;
2447: END IF;
2448:
2449: IF l_Line_price_att_rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN
2450: l_Line_price_att_rec.pricing_attribute60 := p_old_Line_price_att_rec.pricing_attribute60;
2451: END IF;
2452:
2453: IF l_Line_price_att_rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN
2449: IF l_Line_price_att_rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN
2450: l_Line_price_att_rec.pricing_attribute60 := p_old_Line_price_att_rec.pricing_attribute60;
2451: END IF;
2452:
2453: IF l_Line_price_att_rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN
2454: l_Line_price_att_rec.pricing_attribute61 := p_old_Line_price_att_rec.pricing_attribute61;
2455: END IF;
2456:
2457: IF l_Line_price_att_rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN
2453: IF l_Line_price_att_rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN
2454: l_Line_price_att_rec.pricing_attribute61 := p_old_Line_price_att_rec.pricing_attribute61;
2455: END IF;
2456:
2457: IF l_Line_price_att_rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN
2458: l_Line_price_att_rec.pricing_attribute62 := p_old_Line_price_att_rec.pricing_attribute62;
2459: END IF;
2460:
2461: IF l_Line_price_att_rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN
2457: IF l_Line_price_att_rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN
2458: l_Line_price_att_rec.pricing_attribute62 := p_old_Line_price_att_rec.pricing_attribute62;
2459: END IF;
2460:
2461: IF l_Line_price_att_rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN
2462: l_Line_price_att_rec.pricing_attribute63 := p_old_Line_price_att_rec.pricing_attribute63;
2463: END IF;
2464:
2465: IF l_Line_price_att_rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN
2461: IF l_Line_price_att_rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN
2462: l_Line_price_att_rec.pricing_attribute63 := p_old_Line_price_att_rec.pricing_attribute63;
2463: END IF;
2464:
2465: IF l_Line_price_att_rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN
2466: l_Line_price_att_rec.pricing_attribute64 := p_old_Line_price_att_rec.pricing_attribute64;
2467: END IF;
2468:
2469: IF l_Line_price_att_rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN
2465: IF l_Line_price_att_rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN
2466: l_Line_price_att_rec.pricing_attribute64 := p_old_Line_price_att_rec.pricing_attribute64;
2467: END IF;
2468:
2469: IF l_Line_price_att_rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN
2470: l_Line_price_att_rec.pricing_attribute65 := p_old_Line_price_att_rec.pricing_attribute65;
2471: END IF;
2472:
2473: IF l_Line_price_att_rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN
2469: IF l_Line_price_att_rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN
2470: l_Line_price_att_rec.pricing_attribute65 := p_old_Line_price_att_rec.pricing_attribute65;
2471: END IF;
2472:
2473: IF l_Line_price_att_rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN
2474: l_Line_price_att_rec.pricing_attribute66 := p_old_Line_price_att_rec.pricing_attribute66;
2475: END IF;
2476:
2477: IF l_Line_price_att_rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN
2473: IF l_Line_price_att_rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN
2474: l_Line_price_att_rec.pricing_attribute66 := p_old_Line_price_att_rec.pricing_attribute66;
2475: END IF;
2476:
2477: IF l_Line_price_att_rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN
2478: l_Line_price_att_rec.pricing_attribute67 := p_old_Line_price_att_rec.pricing_attribute67;
2479: END IF;
2480:
2481: IF l_Line_price_att_rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN
2477: IF l_Line_price_att_rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN
2478: l_Line_price_att_rec.pricing_attribute67 := p_old_Line_price_att_rec.pricing_attribute67;
2479: END IF;
2480:
2481: IF l_Line_price_att_rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN
2482: l_Line_price_att_rec.pricing_attribute68 := p_old_Line_price_att_rec.pricing_attribute68;
2483: END IF;
2484:
2485: IF l_Line_price_att_rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN
2481: IF l_Line_price_att_rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN
2482: l_Line_price_att_rec.pricing_attribute68 := p_old_Line_price_att_rec.pricing_attribute68;
2483: END IF;
2484:
2485: IF l_Line_price_att_rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN
2486: l_Line_price_att_rec.pricing_attribute69 := p_old_Line_price_att_rec.pricing_attribute69;
2487: END IF;
2488:
2489: IF l_Line_price_att_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
2485: IF l_Line_price_att_rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN
2486: l_Line_price_att_rec.pricing_attribute69 := p_old_Line_price_att_rec.pricing_attribute69;
2487: END IF;
2488:
2489: IF l_Line_price_att_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
2490: l_Line_price_att_rec.pricing_attribute7 := p_old_Line_price_att_rec.pricing_attribute7;
2491: END IF;
2492:
2493: IF l_Line_price_att_rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN
2489: IF l_Line_price_att_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
2490: l_Line_price_att_rec.pricing_attribute7 := p_old_Line_price_att_rec.pricing_attribute7;
2491: END IF;
2492:
2493: IF l_Line_price_att_rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN
2494: l_Line_price_att_rec.pricing_attribute70 := p_old_Line_price_att_rec.pricing_attribute70;
2495: END IF;
2496:
2497: IF l_Line_price_att_rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN
2493: IF l_Line_price_att_rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN
2494: l_Line_price_att_rec.pricing_attribute70 := p_old_Line_price_att_rec.pricing_attribute70;
2495: END IF;
2496:
2497: IF l_Line_price_att_rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN
2498: l_Line_price_att_rec.pricing_attribute71 := p_old_Line_price_att_rec.pricing_attribute71;
2499: END IF;
2500:
2501: IF l_Line_price_att_rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN
2497: IF l_Line_price_att_rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN
2498: l_Line_price_att_rec.pricing_attribute71 := p_old_Line_price_att_rec.pricing_attribute71;
2499: END IF;
2500:
2501: IF l_Line_price_att_rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN
2502: l_Line_price_att_rec.pricing_attribute72 := p_old_Line_price_att_rec.pricing_attribute72;
2503: END IF;
2504:
2505: IF l_Line_price_att_rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN
2501: IF l_Line_price_att_rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN
2502: l_Line_price_att_rec.pricing_attribute72 := p_old_Line_price_att_rec.pricing_attribute72;
2503: END IF;
2504:
2505: IF l_Line_price_att_rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN
2506: l_Line_price_att_rec.pricing_attribute73 := p_old_Line_price_att_rec.pricing_attribute73;
2507: END IF;
2508:
2509: IF l_Line_price_att_rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN
2505: IF l_Line_price_att_rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN
2506: l_Line_price_att_rec.pricing_attribute73 := p_old_Line_price_att_rec.pricing_attribute73;
2507: END IF;
2508:
2509: IF l_Line_price_att_rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN
2510: l_Line_price_att_rec.pricing_attribute74 := p_old_Line_price_att_rec.pricing_attribute74;
2511: END IF;
2512:
2513: IF l_Line_price_att_rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN
2509: IF l_Line_price_att_rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN
2510: l_Line_price_att_rec.pricing_attribute74 := p_old_Line_price_att_rec.pricing_attribute74;
2511: END IF;
2512:
2513: IF l_Line_price_att_rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN
2514: l_Line_price_att_rec.pricing_attribute75 := p_old_Line_price_att_rec.pricing_attribute75;
2515: END IF;
2516:
2517: IF l_Line_price_att_rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN
2513: IF l_Line_price_att_rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN
2514: l_Line_price_att_rec.pricing_attribute75 := p_old_Line_price_att_rec.pricing_attribute75;
2515: END IF;
2516:
2517: IF l_Line_price_att_rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN
2518: l_Line_price_att_rec.pricing_attribute76 := p_old_Line_price_att_rec.pricing_attribute76;
2519: END IF;
2520:
2521: IF l_Line_price_att_rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN
2517: IF l_Line_price_att_rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN
2518: l_Line_price_att_rec.pricing_attribute76 := p_old_Line_price_att_rec.pricing_attribute76;
2519: END IF;
2520:
2521: IF l_Line_price_att_rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN
2522: l_Line_price_att_rec.pricing_attribute77 := p_old_Line_price_att_rec.pricing_attribute77;
2523: END IF;
2524:
2525: IF l_Line_price_att_rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN
2521: IF l_Line_price_att_rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN
2522: l_Line_price_att_rec.pricing_attribute77 := p_old_Line_price_att_rec.pricing_attribute77;
2523: END IF;
2524:
2525: IF l_Line_price_att_rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN
2526: l_Line_price_att_rec.pricing_attribute78 := p_old_Line_price_att_rec.pricing_attribute78;
2527: END IF;
2528:
2529: IF l_Line_price_att_rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN
2525: IF l_Line_price_att_rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN
2526: l_Line_price_att_rec.pricing_attribute78 := p_old_Line_price_att_rec.pricing_attribute78;
2527: END IF;
2528:
2529: IF l_Line_price_att_rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN
2530: l_Line_price_att_rec.pricing_attribute79 := p_old_Line_price_att_rec.pricing_attribute79;
2531: END IF;
2532:
2533: IF l_Line_price_att_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
2529: IF l_Line_price_att_rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN
2530: l_Line_price_att_rec.pricing_attribute79 := p_old_Line_price_att_rec.pricing_attribute79;
2531: END IF;
2532:
2533: IF l_Line_price_att_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
2534: l_Line_price_att_rec.pricing_attribute8 := p_old_Line_price_att_rec.pricing_attribute8;
2535: END IF;
2536:
2537: IF l_Line_price_att_rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN
2533: IF l_Line_price_att_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
2534: l_Line_price_att_rec.pricing_attribute8 := p_old_Line_price_att_rec.pricing_attribute8;
2535: END IF;
2536:
2537: IF l_Line_price_att_rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN
2538: l_Line_price_att_rec.pricing_attribute80 := p_old_Line_price_att_rec.pricing_attribute80;
2539: END IF;
2540:
2541: IF l_Line_price_att_rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN
2537: IF l_Line_price_att_rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN
2538: l_Line_price_att_rec.pricing_attribute80 := p_old_Line_price_att_rec.pricing_attribute80;
2539: END IF;
2540:
2541: IF l_Line_price_att_rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN
2542: l_Line_price_att_rec.pricing_attribute81 := p_old_Line_price_att_rec.pricing_attribute81;
2543: END IF;
2544:
2545: IF l_Line_price_att_rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN
2541: IF l_Line_price_att_rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN
2542: l_Line_price_att_rec.pricing_attribute81 := p_old_Line_price_att_rec.pricing_attribute81;
2543: END IF;
2544:
2545: IF l_Line_price_att_rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN
2546: l_Line_price_att_rec.pricing_attribute82 := p_old_Line_price_att_rec.pricing_attribute82;
2547: END IF;
2548:
2549: IF l_Line_price_att_rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN
2545: IF l_Line_price_att_rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN
2546: l_Line_price_att_rec.pricing_attribute82 := p_old_Line_price_att_rec.pricing_attribute82;
2547: END IF;
2548:
2549: IF l_Line_price_att_rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN
2550: l_Line_price_att_rec.pricing_attribute83 := p_old_Line_price_att_rec.pricing_attribute83;
2551: END IF;
2552:
2553: IF l_Line_price_att_rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN
2549: IF l_Line_price_att_rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN
2550: l_Line_price_att_rec.pricing_attribute83 := p_old_Line_price_att_rec.pricing_attribute83;
2551: END IF;
2552:
2553: IF l_Line_price_att_rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN
2554: l_Line_price_att_rec.pricing_attribute84 := p_old_Line_price_att_rec.pricing_attribute84;
2555: END IF;
2556:
2557: IF l_Line_price_att_rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN
2553: IF l_Line_price_att_rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN
2554: l_Line_price_att_rec.pricing_attribute84 := p_old_Line_price_att_rec.pricing_attribute84;
2555: END IF;
2556:
2557: IF l_Line_price_att_rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN
2558: l_Line_price_att_rec.pricing_attribute85 := p_old_Line_price_att_rec.pricing_attribute85;
2559: END IF;
2560:
2561: IF l_Line_price_att_rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN
2557: IF l_Line_price_att_rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN
2558: l_Line_price_att_rec.pricing_attribute85 := p_old_Line_price_att_rec.pricing_attribute85;
2559: END IF;
2560:
2561: IF l_Line_price_att_rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN
2562: l_Line_price_att_rec.pricing_attribute86 := p_old_Line_price_att_rec.pricing_attribute86;
2563: END IF;
2564:
2565: IF l_Line_price_att_rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN
2561: IF l_Line_price_att_rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN
2562: l_Line_price_att_rec.pricing_attribute86 := p_old_Line_price_att_rec.pricing_attribute86;
2563: END IF;
2564:
2565: IF l_Line_price_att_rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN
2566: l_Line_price_att_rec.pricing_attribute87 := p_old_Line_price_att_rec.pricing_attribute87;
2567: END IF;
2568:
2569: IF l_Line_price_att_rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN
2565: IF l_Line_price_att_rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN
2566: l_Line_price_att_rec.pricing_attribute87 := p_old_Line_price_att_rec.pricing_attribute87;
2567: END IF;
2568:
2569: IF l_Line_price_att_rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN
2570: l_Line_price_att_rec.pricing_attribute88 := p_old_Line_price_att_rec.pricing_attribute88;
2571: END IF;
2572:
2573: IF l_Line_price_att_rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN
2569: IF l_Line_price_att_rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN
2570: l_Line_price_att_rec.pricing_attribute88 := p_old_Line_price_att_rec.pricing_attribute88;
2571: END IF;
2572:
2573: IF l_Line_price_att_rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN
2574: l_Line_price_att_rec.pricing_attribute89 := p_old_Line_price_att_rec.pricing_attribute89;
2575: END IF;
2576:
2577: IF l_Line_price_att_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
2573: IF l_Line_price_att_rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN
2574: l_Line_price_att_rec.pricing_attribute89 := p_old_Line_price_att_rec.pricing_attribute89;
2575: END IF;
2576:
2577: IF l_Line_price_att_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
2578: l_Line_price_att_rec.pricing_attribute9 := p_old_Line_price_att_rec.pricing_attribute9;
2579: END IF;
2580:
2581: IF l_Line_price_att_rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN
2577: IF l_Line_price_att_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
2578: l_Line_price_att_rec.pricing_attribute9 := p_old_Line_price_att_rec.pricing_attribute9;
2579: END IF;
2580:
2581: IF l_Line_price_att_rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN
2582: l_Line_price_att_rec.pricing_attribute90 := p_old_Line_price_att_rec.pricing_attribute90;
2583: END IF;
2584:
2585: IF l_Line_price_att_rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN
2581: IF l_Line_price_att_rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN
2582: l_Line_price_att_rec.pricing_attribute90 := p_old_Line_price_att_rec.pricing_attribute90;
2583: END IF;
2584:
2585: IF l_Line_price_att_rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN
2586: l_Line_price_att_rec.pricing_attribute91 := p_old_Line_price_att_rec.pricing_attribute91;
2587: END IF;
2588:
2589: IF l_Line_price_att_rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN
2585: IF l_Line_price_att_rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN
2586: l_Line_price_att_rec.pricing_attribute91 := p_old_Line_price_att_rec.pricing_attribute91;
2587: END IF;
2588:
2589: IF l_Line_price_att_rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN
2590: l_Line_price_att_rec.pricing_attribute92 := p_old_Line_price_att_rec.pricing_attribute92;
2591: END IF;
2592:
2593: IF l_Line_price_att_rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN
2589: IF l_Line_price_att_rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN
2590: l_Line_price_att_rec.pricing_attribute92 := p_old_Line_price_att_rec.pricing_attribute92;
2591: END IF;
2592:
2593: IF l_Line_price_att_rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN
2594: l_Line_price_att_rec.pricing_attribute93 := p_old_Line_price_att_rec.pricing_attribute93;
2595: END IF;
2596:
2597: IF l_Line_price_att_rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN
2593: IF l_Line_price_att_rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN
2594: l_Line_price_att_rec.pricing_attribute93 := p_old_Line_price_att_rec.pricing_attribute93;
2595: END IF;
2596:
2597: IF l_Line_price_att_rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN
2598: l_Line_price_att_rec.pricing_attribute94 := p_old_Line_price_att_rec.pricing_attribute94;
2599: END IF;
2600:
2601: IF l_Line_price_att_rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN
2597: IF l_Line_price_att_rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN
2598: l_Line_price_att_rec.pricing_attribute94 := p_old_Line_price_att_rec.pricing_attribute94;
2599: END IF;
2600:
2601: IF l_Line_price_att_rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN
2602: l_Line_price_att_rec.pricing_attribute95 := p_old_Line_price_att_rec.pricing_attribute95;
2603: END IF;
2604:
2605: IF l_Line_price_att_rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN
2601: IF l_Line_price_att_rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN
2602: l_Line_price_att_rec.pricing_attribute95 := p_old_Line_price_att_rec.pricing_attribute95;
2603: END IF;
2604:
2605: IF l_Line_price_att_rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN
2606: l_Line_price_att_rec.pricing_attribute96 := p_old_Line_price_att_rec.pricing_attribute96;
2607: END IF;
2608:
2609: IF l_Line_price_att_rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN
2605: IF l_Line_price_att_rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN
2606: l_Line_price_att_rec.pricing_attribute96 := p_old_Line_price_att_rec.pricing_attribute96;
2607: END IF;
2608:
2609: IF l_Line_price_att_rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN
2610: l_Line_price_att_rec.pricing_attribute97 := p_old_Line_price_att_rec.pricing_attribute97;
2611: END IF;
2612:
2613: IF l_Line_price_att_rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN
2609: IF l_Line_price_att_rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN
2610: l_Line_price_att_rec.pricing_attribute97 := p_old_Line_price_att_rec.pricing_attribute97;
2611: END IF;
2612:
2613: IF l_Line_price_att_rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN
2614: l_Line_price_att_rec.pricing_attribute98 := p_old_Line_price_att_rec.pricing_attribute98;
2615: END IF;
2616:
2617: IF l_Line_price_att_rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN
2613: IF l_Line_price_att_rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN
2614: l_Line_price_att_rec.pricing_attribute98 := p_old_Line_price_att_rec.pricing_attribute98;
2615: END IF;
2616:
2617: IF l_Line_price_att_rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN
2618: l_Line_price_att_rec.pricing_attribute99 := p_old_Line_price_att_rec.pricing_attribute99;
2619: END IF;
2620:
2621: IF l_Line_price_att_rec.pricing_context = FND_API.G_MISS_CHAR THEN
2617: IF l_Line_price_att_rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN
2618: l_Line_price_att_rec.pricing_attribute99 := p_old_Line_price_att_rec.pricing_attribute99;
2619: END IF;
2620:
2621: IF l_Line_price_att_rec.pricing_context = FND_API.G_MISS_CHAR THEN
2622: l_Line_price_att_rec.pricing_context := p_old_Line_price_att_rec.pricing_context;
2623: END IF;
2624:
2625: IF l_Line_price_att_rec.program_application_id = FND_API.G_MISS_NUM THEN
2621: IF l_Line_price_att_rec.pricing_context = FND_API.G_MISS_CHAR THEN
2622: l_Line_price_att_rec.pricing_context := p_old_Line_price_att_rec.pricing_context;
2623: END IF;
2624:
2625: IF l_Line_price_att_rec.program_application_id = FND_API.G_MISS_NUM THEN
2626: l_Line_price_att_rec.program_application_id := p_old_Line_price_att_rec.program_application_id;
2627: END IF;
2628:
2629: IF l_Line_price_att_rec.program_id = FND_API.G_MISS_NUM THEN
2625: IF l_Line_price_att_rec.program_application_id = FND_API.G_MISS_NUM THEN
2626: l_Line_price_att_rec.program_application_id := p_old_Line_price_att_rec.program_application_id;
2627: END IF;
2628:
2629: IF l_Line_price_att_rec.program_id = FND_API.G_MISS_NUM THEN
2630: l_Line_price_att_rec.program_id := p_old_Line_price_att_rec.program_id;
2631: END IF;
2632:
2633: IF l_Line_price_att_rec.program_update_date = FND_API.G_MISS_DATE THEN
2629: IF l_Line_price_att_rec.program_id = FND_API.G_MISS_NUM THEN
2630: l_Line_price_att_rec.program_id := p_old_Line_price_att_rec.program_id;
2631: END IF;
2632:
2633: IF l_Line_price_att_rec.program_update_date = FND_API.G_MISS_DATE THEN
2634: l_Line_price_att_rec.program_update_date := p_old_Line_price_att_rec.program_update_date;
2635: END IF;
2636:
2637: IF l_Line_price_att_rec.request_id = FND_API.G_MISS_NUM THEN
2633: IF l_Line_price_att_rec.program_update_date = FND_API.G_MISS_DATE THEN
2634: l_Line_price_att_rec.program_update_date := p_old_Line_price_att_rec.program_update_date;
2635: END IF;
2636:
2637: IF l_Line_price_att_rec.request_id = FND_API.G_MISS_NUM THEN
2638: l_Line_price_att_rec.request_id := p_old_Line_price_att_rec.request_id;
2639: END IF;
2640:
2641: IF l_Line_price_att_rec.orig_sys_atts_ref = FND_API.G_MISS_CHAR THEN
2637: IF l_Line_price_att_rec.request_id = FND_API.G_MISS_NUM THEN
2638: l_Line_price_att_rec.request_id := p_old_Line_price_att_rec.request_id;
2639: END IF;
2640:
2641: IF l_Line_price_att_rec.orig_sys_atts_ref = FND_API.G_MISS_CHAR THEN
2642: l_Line_price_att_rec.orig_sys_atts_ref := p_old_Line_price_att_rec.orig_sys_atts_ref;
2643: END IF;
2644: -- RETURN l_Line_price_att_rec;
2645: p_x_Line_price_att_rec := l_Line_price_att_rec;
2652: IS
2653: l_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type := p_x_Line_Price_Att_rec;
2654: BEGIN
2655:
2656: IF l_Line_price_att_rec.override_flag = FND_API.G_MISS_CHAR THEN
2657: l_Line_price_att_rec.override_flag := NULL;
2658: END IF;
2659:
2660: IF l_Line_price_att_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2656: IF l_Line_price_att_rec.override_flag = FND_API.G_MISS_CHAR THEN
2657: l_Line_price_att_rec.override_flag := NULL;
2658: END IF;
2659:
2660: IF l_Line_price_att_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2661: l_Line_price_att_rec.attribute1 := NULL;
2662: END IF;
2663:
2664: IF l_Line_price_att_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2660: IF l_Line_price_att_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2661: l_Line_price_att_rec.attribute1 := NULL;
2662: END IF;
2663:
2664: IF l_Line_price_att_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2665: l_Line_price_att_rec.attribute10 := NULL;
2666: END IF;
2667:
2668: IF l_Line_price_att_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2664: IF l_Line_price_att_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2665: l_Line_price_att_rec.attribute10 := NULL;
2666: END IF;
2667:
2668: IF l_Line_price_att_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2669: l_Line_price_att_rec.attribute11 := NULL;
2670: END IF;
2671:
2672: IF l_Line_price_att_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2668: IF l_Line_price_att_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2669: l_Line_price_att_rec.attribute11 := NULL;
2670: END IF;
2671:
2672: IF l_Line_price_att_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2673: l_Line_price_att_rec.attribute12 := NULL;
2674: END IF;
2675:
2676: IF l_Line_price_att_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2672: IF l_Line_price_att_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2673: l_Line_price_att_rec.attribute12 := NULL;
2674: END IF;
2675:
2676: IF l_Line_price_att_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2677: l_Line_price_att_rec.attribute13 := NULL;
2678: END IF;
2679:
2680: IF l_Line_price_att_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2676: IF l_Line_price_att_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2677: l_Line_price_att_rec.attribute13 := NULL;
2678: END IF;
2679:
2680: IF l_Line_price_att_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2681: l_Line_price_att_rec.attribute14 := NULL;
2682: END IF;
2683:
2684: IF l_Line_price_att_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2680: IF l_Line_price_att_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2681: l_Line_price_att_rec.attribute14 := NULL;
2682: END IF;
2683:
2684: IF l_Line_price_att_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2685: l_Line_price_att_rec.attribute15 := NULL;
2686: END IF;
2687:
2688: IF l_Line_price_att_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2684: IF l_Line_price_att_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2685: l_Line_price_att_rec.attribute15 := NULL;
2686: END IF;
2687:
2688: IF l_Line_price_att_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2689: l_Line_price_att_rec.attribute2 := NULL;
2690: END IF;
2691:
2692: IF l_Line_price_att_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2688: IF l_Line_price_att_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2689: l_Line_price_att_rec.attribute2 := NULL;
2690: END IF;
2691:
2692: IF l_Line_price_att_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2693: l_Line_price_att_rec.attribute3 := NULL;
2694: END IF;
2695:
2696: IF l_Line_price_att_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2692: IF l_Line_price_att_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2693: l_Line_price_att_rec.attribute3 := NULL;
2694: END IF;
2695:
2696: IF l_Line_price_att_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2697: l_Line_price_att_rec.attribute4 := NULL;
2698: END IF;
2699:
2700: IF l_Line_price_att_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2696: IF l_Line_price_att_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2697: l_Line_price_att_rec.attribute4 := NULL;
2698: END IF;
2699:
2700: IF l_Line_price_att_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2701: l_Line_price_att_rec.attribute5 := NULL;
2702: END IF;
2703:
2704: IF l_Line_price_att_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2700: IF l_Line_price_att_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2701: l_Line_price_att_rec.attribute5 := NULL;
2702: END IF;
2703:
2704: IF l_Line_price_att_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2705: l_Line_price_att_rec.attribute6 := NULL;
2706: END IF;
2707:
2708: IF l_Line_price_att_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2704: IF l_Line_price_att_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2705: l_Line_price_att_rec.attribute6 := NULL;
2706: END IF;
2707:
2708: IF l_Line_price_att_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2709: l_Line_price_att_rec.attribute7 := NULL;
2710: END IF;
2711:
2712: IF l_Line_price_att_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2708: IF l_Line_price_att_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2709: l_Line_price_att_rec.attribute7 := NULL;
2710: END IF;
2711:
2712: IF l_Line_price_att_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2713: l_Line_price_att_rec.attribute8 := NULL;
2714: END IF;
2715:
2716: IF l_Line_price_att_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2712: IF l_Line_price_att_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2713: l_Line_price_att_rec.attribute8 := NULL;
2714: END IF;
2715:
2716: IF l_Line_price_att_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2717: l_Line_price_att_rec.attribute9 := NULL;
2718: END IF;
2719:
2720: IF l_Line_price_att_rec.context = FND_API.G_MISS_CHAR THEN
2716: IF l_Line_price_att_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2717: l_Line_price_att_rec.attribute9 := NULL;
2718: END IF;
2719:
2720: IF l_Line_price_att_rec.context = FND_API.G_MISS_CHAR THEN
2721: l_Line_price_att_rec.context := NULL;
2722: END IF;
2723:
2724: IF l_Line_price_att_rec.created_by = FND_API.G_MISS_NUM THEN
2720: IF l_Line_price_att_rec.context = FND_API.G_MISS_CHAR THEN
2721: l_Line_price_att_rec.context := NULL;
2722: END IF;
2723:
2724: IF l_Line_price_att_rec.created_by = FND_API.G_MISS_NUM THEN
2725: l_Line_price_att_rec.created_by := NULL;
2726: END IF;
2727:
2728: IF l_Line_price_att_rec.creation_date = FND_API.G_MISS_DATE THEN
2724: IF l_Line_price_att_rec.created_by = FND_API.G_MISS_NUM THEN
2725: l_Line_price_att_rec.created_by := NULL;
2726: END IF;
2727:
2728: IF l_Line_price_att_rec.creation_date = FND_API.G_MISS_DATE THEN
2729: l_Line_price_att_rec.creation_date := NULL;
2730: END IF;
2731:
2732: IF l_Line_price_att_rec.flex_title = FND_API.G_MISS_CHAR THEN
2728: IF l_Line_price_att_rec.creation_date = FND_API.G_MISS_DATE THEN
2729: l_Line_price_att_rec.creation_date := NULL;
2730: END IF;
2731:
2732: IF l_Line_price_att_rec.flex_title = FND_API.G_MISS_CHAR THEN
2733: l_Line_price_att_rec.flex_title := NULL;
2734: END IF;
2735:
2736: IF l_Line_price_att_rec.header_id = FND_API.G_MISS_NUM THEN
2732: IF l_Line_price_att_rec.flex_title = FND_API.G_MISS_CHAR THEN
2733: l_Line_price_att_rec.flex_title := NULL;
2734: END IF;
2735:
2736: IF l_Line_price_att_rec.header_id = FND_API.G_MISS_NUM THEN
2737: l_Line_price_att_rec.header_id := NULL;
2738: END IF;
2739:
2740: IF l_Line_price_att_rec.last_updated_by = FND_API.G_MISS_NUM THEN
2736: IF l_Line_price_att_rec.header_id = FND_API.G_MISS_NUM THEN
2737: l_Line_price_att_rec.header_id := NULL;
2738: END IF;
2739:
2740: IF l_Line_price_att_rec.last_updated_by = FND_API.G_MISS_NUM THEN
2741: l_Line_price_att_rec.last_updated_by := NULL;
2742: END IF;
2743:
2744: IF l_Line_price_att_rec.last_update_date = FND_API.G_MISS_DATE THEN
2740: IF l_Line_price_att_rec.last_updated_by = FND_API.G_MISS_NUM THEN
2741: l_Line_price_att_rec.last_updated_by := NULL;
2742: END IF;
2743:
2744: IF l_Line_price_att_rec.last_update_date = FND_API.G_MISS_DATE THEN
2745: l_Line_price_att_rec.last_update_date := NULL;
2746: END IF;
2747:
2748: IF l_Line_price_att_rec.last_update_login = FND_API.G_MISS_NUM THEN
2744: IF l_Line_price_att_rec.last_update_date = FND_API.G_MISS_DATE THEN
2745: l_Line_price_att_rec.last_update_date := NULL;
2746: END IF;
2747:
2748: IF l_Line_price_att_rec.last_update_login = FND_API.G_MISS_NUM THEN
2749: l_Line_price_att_rec.last_update_login := NULL;
2750: END IF;
2751:
2752: IF l_Line_price_att_rec.line_id = FND_API.G_MISS_NUM THEN
2748: IF l_Line_price_att_rec.last_update_login = FND_API.G_MISS_NUM THEN
2749: l_Line_price_att_rec.last_update_login := NULL;
2750: END IF;
2751:
2752: IF l_Line_price_att_rec.line_id = FND_API.G_MISS_NUM THEN
2753: l_Line_price_att_rec.line_id := NULL;
2754: END IF;
2755:
2756: IF l_Line_price_att_rec.order_price_attrib_id = FND_API.G_MISS_NUM THEN
2752: IF l_Line_price_att_rec.line_id = FND_API.G_MISS_NUM THEN
2753: l_Line_price_att_rec.line_id := NULL;
2754: END IF;
2755:
2756: IF l_Line_price_att_rec.order_price_attrib_id = FND_API.G_MISS_NUM THEN
2757: l_Line_price_att_rec.order_price_attrib_id := NULL;
2758: END IF;
2759:
2760: IF l_Line_price_att_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
2756: IF l_Line_price_att_rec.order_price_attrib_id = FND_API.G_MISS_NUM THEN
2757: l_Line_price_att_rec.order_price_attrib_id := NULL;
2758: END IF;
2759:
2760: IF l_Line_price_att_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
2761: l_Line_price_att_rec.pricing_attribute1 := NULL;
2762: END IF;
2763:
2764: IF l_Line_price_att_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
2760: IF l_Line_price_att_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
2761: l_Line_price_att_rec.pricing_attribute1 := NULL;
2762: END IF;
2763:
2764: IF l_Line_price_att_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
2765: l_Line_price_att_rec.pricing_attribute10 := NULL;
2766: END IF;
2767:
2768: IF l_Line_price_att_rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN
2764: IF l_Line_price_att_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
2765: l_Line_price_att_rec.pricing_attribute10 := NULL;
2766: END IF;
2767:
2768: IF l_Line_price_att_rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN
2769: l_Line_price_att_rec.pricing_attribute100 := NULL;
2770: END IF;
2771:
2772: IF l_Line_price_att_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
2768: IF l_Line_price_att_rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN
2769: l_Line_price_att_rec.pricing_attribute100 := NULL;
2770: END IF;
2771:
2772: IF l_Line_price_att_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
2773: l_Line_price_att_rec.pricing_attribute11 := NULL;
2774: END IF;
2775:
2776: IF l_Line_price_att_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
2772: IF l_Line_price_att_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
2773: l_Line_price_att_rec.pricing_attribute11 := NULL;
2774: END IF;
2775:
2776: IF l_Line_price_att_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
2777: l_Line_price_att_rec.pricing_attribute12 := NULL;
2778: END IF;
2779:
2780: IF l_Line_price_att_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
2776: IF l_Line_price_att_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
2777: l_Line_price_att_rec.pricing_attribute12 := NULL;
2778: END IF;
2779:
2780: IF l_Line_price_att_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
2781: l_Line_price_att_rec.pricing_attribute13 := NULL;
2782: END IF;
2783:
2784: IF l_Line_price_att_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
2780: IF l_Line_price_att_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
2781: l_Line_price_att_rec.pricing_attribute13 := NULL;
2782: END IF;
2783:
2784: IF l_Line_price_att_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
2785: l_Line_price_att_rec.pricing_attribute14 := NULL;
2786: END IF;
2787:
2788: IF l_Line_price_att_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
2784: IF l_Line_price_att_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
2785: l_Line_price_att_rec.pricing_attribute14 := NULL;
2786: END IF;
2787:
2788: IF l_Line_price_att_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
2789: l_Line_price_att_rec.pricing_attribute15 := NULL;
2790: END IF;
2791:
2792: IF l_Line_price_att_rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN
2788: IF l_Line_price_att_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
2789: l_Line_price_att_rec.pricing_attribute15 := NULL;
2790: END IF;
2791:
2792: IF l_Line_price_att_rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN
2793: l_Line_price_att_rec.pricing_attribute16 := NULL;
2794: END IF;
2795:
2796: IF l_Line_price_att_rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN
2792: IF l_Line_price_att_rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN
2793: l_Line_price_att_rec.pricing_attribute16 := NULL;
2794: END IF;
2795:
2796: IF l_Line_price_att_rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN
2797: l_Line_price_att_rec.pricing_attribute17 := NULL;
2798: END IF;
2799:
2800: IF l_Line_price_att_rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN
2796: IF l_Line_price_att_rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN
2797: l_Line_price_att_rec.pricing_attribute17 := NULL;
2798: END IF;
2799:
2800: IF l_Line_price_att_rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN
2801: l_Line_price_att_rec.pricing_attribute18 := NULL;
2802: END IF;
2803:
2804: IF l_Line_price_att_rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN
2800: IF l_Line_price_att_rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN
2801: l_Line_price_att_rec.pricing_attribute18 := NULL;
2802: END IF;
2803:
2804: IF l_Line_price_att_rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN
2805: l_Line_price_att_rec.pricing_attribute19 := NULL;
2806: END IF;
2807:
2808: IF l_Line_price_att_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
2804: IF l_Line_price_att_rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN
2805: l_Line_price_att_rec.pricing_attribute19 := NULL;
2806: END IF;
2807:
2808: IF l_Line_price_att_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
2809: l_Line_price_att_rec.pricing_attribute2 := NULL;
2810: END IF;
2811:
2812: IF l_Line_price_att_rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN
2808: IF l_Line_price_att_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
2809: l_Line_price_att_rec.pricing_attribute2 := NULL;
2810: END IF;
2811:
2812: IF l_Line_price_att_rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN
2813: l_Line_price_att_rec.pricing_attribute20 := NULL;
2814: END IF;
2815:
2816: IF l_Line_price_att_rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN
2812: IF l_Line_price_att_rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN
2813: l_Line_price_att_rec.pricing_attribute20 := NULL;
2814: END IF;
2815:
2816: IF l_Line_price_att_rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN
2817: l_Line_price_att_rec.pricing_attribute21 := NULL;
2818: END IF;
2819:
2820: IF l_Line_price_att_rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN
2816: IF l_Line_price_att_rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN
2817: l_Line_price_att_rec.pricing_attribute21 := NULL;
2818: END IF;
2819:
2820: IF l_Line_price_att_rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN
2821: l_Line_price_att_rec.pricing_attribute22 := NULL;
2822: END IF;
2823:
2824: IF l_Line_price_att_rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN
2820: IF l_Line_price_att_rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN
2821: l_Line_price_att_rec.pricing_attribute22 := NULL;
2822: END IF;
2823:
2824: IF l_Line_price_att_rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN
2825: l_Line_price_att_rec.pricing_attribute23 := NULL;
2826: END IF;
2827:
2828: IF l_Line_price_att_rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN
2824: IF l_Line_price_att_rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN
2825: l_Line_price_att_rec.pricing_attribute23 := NULL;
2826: END IF;
2827:
2828: IF l_Line_price_att_rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN
2829: l_Line_price_att_rec.pricing_attribute24 := NULL;
2830: END IF;
2831:
2832: IF l_Line_price_att_rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN
2828: IF l_Line_price_att_rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN
2829: l_Line_price_att_rec.pricing_attribute24 := NULL;
2830: END IF;
2831:
2832: IF l_Line_price_att_rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN
2833: l_Line_price_att_rec.pricing_attribute25 := NULL;
2834: END IF;
2835:
2836: IF l_Line_price_att_rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN
2832: IF l_Line_price_att_rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN
2833: l_Line_price_att_rec.pricing_attribute25 := NULL;
2834: END IF;
2835:
2836: IF l_Line_price_att_rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN
2837: l_Line_price_att_rec.pricing_attribute26 := NULL;
2838: END IF;
2839:
2840: IF l_Line_price_att_rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN
2836: IF l_Line_price_att_rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN
2837: l_Line_price_att_rec.pricing_attribute26 := NULL;
2838: END IF;
2839:
2840: IF l_Line_price_att_rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN
2841: l_Line_price_att_rec.pricing_attribute27 := NULL;
2842: END IF;
2843:
2844: IF l_Line_price_att_rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN
2840: IF l_Line_price_att_rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN
2841: l_Line_price_att_rec.pricing_attribute27 := NULL;
2842: END IF;
2843:
2844: IF l_Line_price_att_rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN
2845: l_Line_price_att_rec.pricing_attribute28 := NULL;
2846: END IF;
2847:
2848: IF l_Line_price_att_rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN
2844: IF l_Line_price_att_rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN
2845: l_Line_price_att_rec.pricing_attribute28 := NULL;
2846: END IF;
2847:
2848: IF l_Line_price_att_rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN
2849: l_Line_price_att_rec.pricing_attribute29 := NULL;
2850: END IF;
2851:
2852: IF l_Line_price_att_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
2848: IF l_Line_price_att_rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN
2849: l_Line_price_att_rec.pricing_attribute29 := NULL;
2850: END IF;
2851:
2852: IF l_Line_price_att_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
2853: l_Line_price_att_rec.pricing_attribute3 := NULL;
2854: END IF;
2855:
2856: IF l_Line_price_att_rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN
2852: IF l_Line_price_att_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
2853: l_Line_price_att_rec.pricing_attribute3 := NULL;
2854: END IF;
2855:
2856: IF l_Line_price_att_rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN
2857: l_Line_price_att_rec.pricing_attribute30 := NULL;
2858: END IF;
2859:
2860: IF l_Line_price_att_rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN
2856: IF l_Line_price_att_rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN
2857: l_Line_price_att_rec.pricing_attribute30 := NULL;
2858: END IF;
2859:
2860: IF l_Line_price_att_rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN
2861: l_Line_price_att_rec.pricing_attribute31 := NULL;
2862: END IF;
2863:
2864: IF l_Line_price_att_rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN
2860: IF l_Line_price_att_rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN
2861: l_Line_price_att_rec.pricing_attribute31 := NULL;
2862: END IF;
2863:
2864: IF l_Line_price_att_rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN
2865: l_Line_price_att_rec.pricing_attribute32 := NULL;
2866: END IF;
2867:
2868: IF l_Line_price_att_rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN
2864: IF l_Line_price_att_rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN
2865: l_Line_price_att_rec.pricing_attribute32 := NULL;
2866: END IF;
2867:
2868: IF l_Line_price_att_rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN
2869: l_Line_price_att_rec.pricing_attribute33 := NULL;
2870: END IF;
2871:
2872: IF l_Line_price_att_rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN
2868: IF l_Line_price_att_rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN
2869: l_Line_price_att_rec.pricing_attribute33 := NULL;
2870: END IF;
2871:
2872: IF l_Line_price_att_rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN
2873: l_Line_price_att_rec.pricing_attribute34 := NULL;
2874: END IF;
2875:
2876: IF l_Line_price_att_rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN
2872: IF l_Line_price_att_rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN
2873: l_Line_price_att_rec.pricing_attribute34 := NULL;
2874: END IF;
2875:
2876: IF l_Line_price_att_rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN
2877: l_Line_price_att_rec.pricing_attribute35 := NULL;
2878: END IF;
2879:
2880: IF l_Line_price_att_rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN
2876: IF l_Line_price_att_rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN
2877: l_Line_price_att_rec.pricing_attribute35 := NULL;
2878: END IF;
2879:
2880: IF l_Line_price_att_rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN
2881: l_Line_price_att_rec.pricing_attribute36 := NULL;
2882: END IF;
2883:
2884: IF l_Line_price_att_rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN
2880: IF l_Line_price_att_rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN
2881: l_Line_price_att_rec.pricing_attribute36 := NULL;
2882: END IF;
2883:
2884: IF l_Line_price_att_rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN
2885: l_Line_price_att_rec.pricing_attribute37 := NULL;
2886: END IF;
2887:
2888: IF l_Line_price_att_rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN
2884: IF l_Line_price_att_rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN
2885: l_Line_price_att_rec.pricing_attribute37 := NULL;
2886: END IF;
2887:
2888: IF l_Line_price_att_rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN
2889: l_Line_price_att_rec.pricing_attribute38 := NULL;
2890: END IF;
2891:
2892: IF l_Line_price_att_rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN
2888: IF l_Line_price_att_rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN
2889: l_Line_price_att_rec.pricing_attribute38 := NULL;
2890: END IF;
2891:
2892: IF l_Line_price_att_rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN
2893: l_Line_price_att_rec.pricing_attribute39 := NULL;
2894: END IF;
2895:
2896: IF l_Line_price_att_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
2892: IF l_Line_price_att_rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN
2893: l_Line_price_att_rec.pricing_attribute39 := NULL;
2894: END IF;
2895:
2896: IF l_Line_price_att_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
2897: l_Line_price_att_rec.pricing_attribute4 := NULL;
2898: END IF;
2899:
2900: IF l_Line_price_att_rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN
2896: IF l_Line_price_att_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
2897: l_Line_price_att_rec.pricing_attribute4 := NULL;
2898: END IF;
2899:
2900: IF l_Line_price_att_rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN
2901: l_Line_price_att_rec.pricing_attribute40 := NULL;
2902: END IF;
2903:
2904: IF l_Line_price_att_rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN
2900: IF l_Line_price_att_rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN
2901: l_Line_price_att_rec.pricing_attribute40 := NULL;
2902: END IF;
2903:
2904: IF l_Line_price_att_rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN
2905: l_Line_price_att_rec.pricing_attribute41 := NULL;
2906: END IF;
2907:
2908: IF l_Line_price_att_rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN
2904: IF l_Line_price_att_rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN
2905: l_Line_price_att_rec.pricing_attribute41 := NULL;
2906: END IF;
2907:
2908: IF l_Line_price_att_rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN
2909: l_Line_price_att_rec.pricing_attribute42 := NULL;
2910: END IF;
2911:
2912: IF l_Line_price_att_rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN
2908: IF l_Line_price_att_rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN
2909: l_Line_price_att_rec.pricing_attribute42 := NULL;
2910: END IF;
2911:
2912: IF l_Line_price_att_rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN
2913: l_Line_price_att_rec.pricing_attribute43 := NULL;
2914: END IF;
2915:
2916: IF l_Line_price_att_rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN
2912: IF l_Line_price_att_rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN
2913: l_Line_price_att_rec.pricing_attribute43 := NULL;
2914: END IF;
2915:
2916: IF l_Line_price_att_rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN
2917: l_Line_price_att_rec.pricing_attribute44 := NULL;
2918: END IF;
2919:
2920: IF l_Line_price_att_rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN
2916: IF l_Line_price_att_rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN
2917: l_Line_price_att_rec.pricing_attribute44 := NULL;
2918: END IF;
2919:
2920: IF l_Line_price_att_rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN
2921: l_Line_price_att_rec.pricing_attribute45 := NULL;
2922: END IF;
2923:
2924: IF l_Line_price_att_rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN
2920: IF l_Line_price_att_rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN
2921: l_Line_price_att_rec.pricing_attribute45 := NULL;
2922: END IF;
2923:
2924: IF l_Line_price_att_rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN
2925: l_Line_price_att_rec.pricing_attribute46 := NULL;
2926: END IF;
2927:
2928: IF l_Line_price_att_rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN
2924: IF l_Line_price_att_rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN
2925: l_Line_price_att_rec.pricing_attribute46 := NULL;
2926: END IF;
2927:
2928: IF l_Line_price_att_rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN
2929: l_Line_price_att_rec.pricing_attribute47 := NULL;
2930: END IF;
2931:
2932: IF l_Line_price_att_rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN
2928: IF l_Line_price_att_rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN
2929: l_Line_price_att_rec.pricing_attribute47 := NULL;
2930: END IF;
2931:
2932: IF l_Line_price_att_rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN
2933: l_Line_price_att_rec.pricing_attribute48 := NULL;
2934: END IF;
2935:
2936: IF l_Line_price_att_rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN
2932: IF l_Line_price_att_rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN
2933: l_Line_price_att_rec.pricing_attribute48 := NULL;
2934: END IF;
2935:
2936: IF l_Line_price_att_rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN
2937: l_Line_price_att_rec.pricing_attribute49 := NULL;
2938: END IF;
2939:
2940: IF l_Line_price_att_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
2936: IF l_Line_price_att_rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN
2937: l_Line_price_att_rec.pricing_attribute49 := NULL;
2938: END IF;
2939:
2940: IF l_Line_price_att_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
2941: l_Line_price_att_rec.pricing_attribute5 := NULL;
2942: END IF;
2943:
2944: IF l_Line_price_att_rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN
2940: IF l_Line_price_att_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
2941: l_Line_price_att_rec.pricing_attribute5 := NULL;
2942: END IF;
2943:
2944: IF l_Line_price_att_rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN
2945: l_Line_price_att_rec.pricing_attribute50 := NULL;
2946: END IF;
2947:
2948: IF l_Line_price_att_rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN
2944: IF l_Line_price_att_rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN
2945: l_Line_price_att_rec.pricing_attribute50 := NULL;
2946: END IF;
2947:
2948: IF l_Line_price_att_rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN
2949: l_Line_price_att_rec.pricing_attribute51 := NULL;
2950: END IF;
2951:
2952: IF l_Line_price_att_rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN
2948: IF l_Line_price_att_rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN
2949: l_Line_price_att_rec.pricing_attribute51 := NULL;
2950: END IF;
2951:
2952: IF l_Line_price_att_rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN
2953: l_Line_price_att_rec.pricing_attribute52 := NULL;
2954: END IF;
2955:
2956: IF l_Line_price_att_rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN
2952: IF l_Line_price_att_rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN
2953: l_Line_price_att_rec.pricing_attribute52 := NULL;
2954: END IF;
2955:
2956: IF l_Line_price_att_rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN
2957: l_Line_price_att_rec.pricing_attribute53 := NULL;
2958: END IF;
2959:
2960: IF l_Line_price_att_rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN
2956: IF l_Line_price_att_rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN
2957: l_Line_price_att_rec.pricing_attribute53 := NULL;
2958: END IF;
2959:
2960: IF l_Line_price_att_rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN
2961: l_Line_price_att_rec.pricing_attribute54 := NULL;
2962: END IF;
2963:
2964: IF l_Line_price_att_rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN
2960: IF l_Line_price_att_rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN
2961: l_Line_price_att_rec.pricing_attribute54 := NULL;
2962: END IF;
2963:
2964: IF l_Line_price_att_rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN
2965: l_Line_price_att_rec.pricing_attribute55 := NULL;
2966: END IF;
2967:
2968: IF l_Line_price_att_rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN
2964: IF l_Line_price_att_rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN
2965: l_Line_price_att_rec.pricing_attribute55 := NULL;
2966: END IF;
2967:
2968: IF l_Line_price_att_rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN
2969: l_Line_price_att_rec.pricing_attribute56 := NULL;
2970: END IF;
2971:
2972: IF l_Line_price_att_rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN
2968: IF l_Line_price_att_rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN
2969: l_Line_price_att_rec.pricing_attribute56 := NULL;
2970: END IF;
2971:
2972: IF l_Line_price_att_rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN
2973: l_Line_price_att_rec.pricing_attribute57 := NULL;
2974: END IF;
2975:
2976: IF l_Line_price_att_rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN
2972: IF l_Line_price_att_rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN
2973: l_Line_price_att_rec.pricing_attribute57 := NULL;
2974: END IF;
2975:
2976: IF l_Line_price_att_rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN
2977: l_Line_price_att_rec.pricing_attribute58 := NULL;
2978: END IF;
2979:
2980: IF l_Line_price_att_rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN
2976: IF l_Line_price_att_rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN
2977: l_Line_price_att_rec.pricing_attribute58 := NULL;
2978: END IF;
2979:
2980: IF l_Line_price_att_rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN
2981: l_Line_price_att_rec.pricing_attribute59 := NULL;
2982: END IF;
2983:
2984: IF l_Line_price_att_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
2980: IF l_Line_price_att_rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN
2981: l_Line_price_att_rec.pricing_attribute59 := NULL;
2982: END IF;
2983:
2984: IF l_Line_price_att_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
2985: l_Line_price_att_rec.pricing_attribute6 := NULL;
2986: END IF;
2987:
2988: IF l_Line_price_att_rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN
2984: IF l_Line_price_att_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
2985: l_Line_price_att_rec.pricing_attribute6 := NULL;
2986: END IF;
2987:
2988: IF l_Line_price_att_rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN
2989: l_Line_price_att_rec.pricing_attribute60 := NULL;
2990: END IF;
2991:
2992: IF l_Line_price_att_rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN
2988: IF l_Line_price_att_rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN
2989: l_Line_price_att_rec.pricing_attribute60 := NULL;
2990: END IF;
2991:
2992: IF l_Line_price_att_rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN
2993: l_Line_price_att_rec.pricing_attribute61 := NULL;
2994: END IF;
2995:
2996: IF l_Line_price_att_rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN
2992: IF l_Line_price_att_rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN
2993: l_Line_price_att_rec.pricing_attribute61 := NULL;
2994: END IF;
2995:
2996: IF l_Line_price_att_rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN
2997: l_Line_price_att_rec.pricing_attribute62 := NULL;
2998: END IF;
2999:
3000: IF l_Line_price_att_rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN
2996: IF l_Line_price_att_rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN
2997: l_Line_price_att_rec.pricing_attribute62 := NULL;
2998: END IF;
2999:
3000: IF l_Line_price_att_rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN
3001: l_Line_price_att_rec.pricing_attribute63 := NULL;
3002: END IF;
3003:
3004: IF l_Line_price_att_rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN
3000: IF l_Line_price_att_rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN
3001: l_Line_price_att_rec.pricing_attribute63 := NULL;
3002: END IF;
3003:
3004: IF l_Line_price_att_rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN
3005: l_Line_price_att_rec.pricing_attribute64 := NULL;
3006: END IF;
3007:
3008: IF l_Line_price_att_rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN
3004: IF l_Line_price_att_rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN
3005: l_Line_price_att_rec.pricing_attribute64 := NULL;
3006: END IF;
3007:
3008: IF l_Line_price_att_rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN
3009: l_Line_price_att_rec.pricing_attribute65 := NULL;
3010: END IF;
3011:
3012: IF l_Line_price_att_rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN
3008: IF l_Line_price_att_rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN
3009: l_Line_price_att_rec.pricing_attribute65 := NULL;
3010: END IF;
3011:
3012: IF l_Line_price_att_rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN
3013: l_Line_price_att_rec.pricing_attribute66 := NULL;
3014: END IF;
3015:
3016: IF l_Line_price_att_rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN
3012: IF l_Line_price_att_rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN
3013: l_Line_price_att_rec.pricing_attribute66 := NULL;
3014: END IF;
3015:
3016: IF l_Line_price_att_rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN
3017: l_Line_price_att_rec.pricing_attribute67 := NULL;
3018: END IF;
3019:
3020: IF l_Line_price_att_rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN
3016: IF l_Line_price_att_rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN
3017: l_Line_price_att_rec.pricing_attribute67 := NULL;
3018: END IF;
3019:
3020: IF l_Line_price_att_rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN
3021: l_Line_price_att_rec.pricing_attribute68 := NULL;
3022: END IF;
3023:
3024: IF l_Line_price_att_rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN
3020: IF l_Line_price_att_rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN
3021: l_Line_price_att_rec.pricing_attribute68 := NULL;
3022: END IF;
3023:
3024: IF l_Line_price_att_rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN
3025: l_Line_price_att_rec.pricing_attribute69 := NULL;
3026: END IF;
3027:
3028: IF l_Line_price_att_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
3024: IF l_Line_price_att_rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN
3025: l_Line_price_att_rec.pricing_attribute69 := NULL;
3026: END IF;
3027:
3028: IF l_Line_price_att_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
3029: l_Line_price_att_rec.pricing_attribute7 := NULL;
3030: END IF;
3031:
3032: IF l_Line_price_att_rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN
3028: IF l_Line_price_att_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
3029: l_Line_price_att_rec.pricing_attribute7 := NULL;
3030: END IF;
3031:
3032: IF l_Line_price_att_rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN
3033: l_Line_price_att_rec.pricing_attribute70 := NULL;
3034: END IF;
3035:
3036: IF l_Line_price_att_rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN
3032: IF l_Line_price_att_rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN
3033: l_Line_price_att_rec.pricing_attribute70 := NULL;
3034: END IF;
3035:
3036: IF l_Line_price_att_rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN
3037: l_Line_price_att_rec.pricing_attribute71 := NULL;
3038: END IF;
3039:
3040: IF l_Line_price_att_rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN
3036: IF l_Line_price_att_rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN
3037: l_Line_price_att_rec.pricing_attribute71 := NULL;
3038: END IF;
3039:
3040: IF l_Line_price_att_rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN
3041: l_Line_price_att_rec.pricing_attribute72 := NULL;
3042: END IF;
3043:
3044: IF l_Line_price_att_rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN
3040: IF l_Line_price_att_rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN
3041: l_Line_price_att_rec.pricing_attribute72 := NULL;
3042: END IF;
3043:
3044: IF l_Line_price_att_rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN
3045: l_Line_price_att_rec.pricing_attribute73 := NULL;
3046: END IF;
3047:
3048: IF l_Line_price_att_rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN
3044: IF l_Line_price_att_rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN
3045: l_Line_price_att_rec.pricing_attribute73 := NULL;
3046: END IF;
3047:
3048: IF l_Line_price_att_rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN
3049: l_Line_price_att_rec.pricing_attribute74 := NULL;
3050: END IF;
3051:
3052: IF l_Line_price_att_rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN
3048: IF l_Line_price_att_rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN
3049: l_Line_price_att_rec.pricing_attribute74 := NULL;
3050: END IF;
3051:
3052: IF l_Line_price_att_rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN
3053: l_Line_price_att_rec.pricing_attribute75 := NULL;
3054: END IF;
3055:
3056: IF l_Line_price_att_rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN
3052: IF l_Line_price_att_rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN
3053: l_Line_price_att_rec.pricing_attribute75 := NULL;
3054: END IF;
3055:
3056: IF l_Line_price_att_rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN
3057: l_Line_price_att_rec.pricing_attribute76 := NULL;
3058: END IF;
3059:
3060: IF l_Line_price_att_rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN
3056: IF l_Line_price_att_rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN
3057: l_Line_price_att_rec.pricing_attribute76 := NULL;
3058: END IF;
3059:
3060: IF l_Line_price_att_rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN
3061: l_Line_price_att_rec.pricing_attribute77 := NULL;
3062: END IF;
3063:
3064: IF l_Line_price_att_rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN
3060: IF l_Line_price_att_rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN
3061: l_Line_price_att_rec.pricing_attribute77 := NULL;
3062: END IF;
3063:
3064: IF l_Line_price_att_rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN
3065: l_Line_price_att_rec.pricing_attribute78 := NULL;
3066: END IF;
3067:
3068: IF l_Line_price_att_rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN
3064: IF l_Line_price_att_rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN
3065: l_Line_price_att_rec.pricing_attribute78 := NULL;
3066: END IF;
3067:
3068: IF l_Line_price_att_rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN
3069: l_Line_price_att_rec.pricing_attribute79 := NULL;
3070: END IF;
3071:
3072: IF l_Line_price_att_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
3068: IF l_Line_price_att_rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN
3069: l_Line_price_att_rec.pricing_attribute79 := NULL;
3070: END IF;
3071:
3072: IF l_Line_price_att_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
3073: l_Line_price_att_rec.pricing_attribute8 := NULL;
3074: END IF;
3075:
3076: IF l_Line_price_att_rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN
3072: IF l_Line_price_att_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
3073: l_Line_price_att_rec.pricing_attribute8 := NULL;
3074: END IF;
3075:
3076: IF l_Line_price_att_rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN
3077: l_Line_price_att_rec.pricing_attribute80 := NULL;
3078: END IF;
3079:
3080: IF l_Line_price_att_rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN
3076: IF l_Line_price_att_rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN
3077: l_Line_price_att_rec.pricing_attribute80 := NULL;
3078: END IF;
3079:
3080: IF l_Line_price_att_rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN
3081: l_Line_price_att_rec.pricing_attribute81 := NULL;
3082: END IF;
3083:
3084: IF l_Line_price_att_rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN
3080: IF l_Line_price_att_rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN
3081: l_Line_price_att_rec.pricing_attribute81 := NULL;
3082: END IF;
3083:
3084: IF l_Line_price_att_rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN
3085: l_Line_price_att_rec.pricing_attribute82 := NULL;
3086: END IF;
3087:
3088: IF l_Line_price_att_rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN
3084: IF l_Line_price_att_rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN
3085: l_Line_price_att_rec.pricing_attribute82 := NULL;
3086: END IF;
3087:
3088: IF l_Line_price_att_rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN
3089: l_Line_price_att_rec.pricing_attribute83 := NULL;
3090: END IF;
3091:
3092: IF l_Line_price_att_rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN
3088: IF l_Line_price_att_rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN
3089: l_Line_price_att_rec.pricing_attribute83 := NULL;
3090: END IF;
3091:
3092: IF l_Line_price_att_rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN
3093: l_Line_price_att_rec.pricing_attribute84 := NULL;
3094: END IF;
3095:
3096: IF l_Line_price_att_rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN
3092: IF l_Line_price_att_rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN
3093: l_Line_price_att_rec.pricing_attribute84 := NULL;
3094: END IF;
3095:
3096: IF l_Line_price_att_rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN
3097: l_Line_price_att_rec.pricing_attribute85 := NULL;
3098: END IF;
3099:
3100: IF l_Line_price_att_rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN
3096: IF l_Line_price_att_rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN
3097: l_Line_price_att_rec.pricing_attribute85 := NULL;
3098: END IF;
3099:
3100: IF l_Line_price_att_rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN
3101: l_Line_price_att_rec.pricing_attribute86 := NULL;
3102: END IF;
3103:
3104: IF l_Line_price_att_rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN
3100: IF l_Line_price_att_rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN
3101: l_Line_price_att_rec.pricing_attribute86 := NULL;
3102: END IF;
3103:
3104: IF l_Line_price_att_rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN
3105: l_Line_price_att_rec.pricing_attribute87 := NULL;
3106: END IF;
3107:
3108: IF l_Line_price_att_rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN
3104: IF l_Line_price_att_rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN
3105: l_Line_price_att_rec.pricing_attribute87 := NULL;
3106: END IF;
3107:
3108: IF l_Line_price_att_rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN
3109: l_Line_price_att_rec.pricing_attribute88 := NULL;
3110: END IF;
3111:
3112: IF l_Line_price_att_rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN
3108: IF l_Line_price_att_rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN
3109: l_Line_price_att_rec.pricing_attribute88 := NULL;
3110: END IF;
3111:
3112: IF l_Line_price_att_rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN
3113: l_Line_price_att_rec.pricing_attribute89 := NULL;
3114: END IF;
3115:
3116: IF l_Line_price_att_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
3112: IF l_Line_price_att_rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN
3113: l_Line_price_att_rec.pricing_attribute89 := NULL;
3114: END IF;
3115:
3116: IF l_Line_price_att_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
3117: l_Line_price_att_rec.pricing_attribute9 := NULL;
3118: END IF;
3119:
3120: IF l_Line_price_att_rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN
3116: IF l_Line_price_att_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
3117: l_Line_price_att_rec.pricing_attribute9 := NULL;
3118: END IF;
3119:
3120: IF l_Line_price_att_rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN
3121: l_Line_price_att_rec.pricing_attribute90 := NULL;
3122: END IF;
3123:
3124: IF l_Line_price_att_rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN
3120: IF l_Line_price_att_rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN
3121: l_Line_price_att_rec.pricing_attribute90 := NULL;
3122: END IF;
3123:
3124: IF l_Line_price_att_rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN
3125: l_Line_price_att_rec.pricing_attribute91 := NULL;
3126: END IF;
3127:
3128: IF l_Line_price_att_rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN
3124: IF l_Line_price_att_rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN
3125: l_Line_price_att_rec.pricing_attribute91 := NULL;
3126: END IF;
3127:
3128: IF l_Line_price_att_rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN
3129: l_Line_price_att_rec.pricing_attribute92 := NULL;
3130: END IF;
3131:
3132: IF l_Line_price_att_rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN
3128: IF l_Line_price_att_rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN
3129: l_Line_price_att_rec.pricing_attribute92 := NULL;
3130: END IF;
3131:
3132: IF l_Line_price_att_rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN
3133: l_Line_price_att_rec.pricing_attribute93 := NULL;
3134: END IF;
3135:
3136: IF l_Line_price_att_rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN
3132: IF l_Line_price_att_rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN
3133: l_Line_price_att_rec.pricing_attribute93 := NULL;
3134: END IF;
3135:
3136: IF l_Line_price_att_rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN
3137: l_Line_price_att_rec.pricing_attribute94 := NULL;
3138: END IF;
3139:
3140: IF l_Line_price_att_rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN
3136: IF l_Line_price_att_rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN
3137: l_Line_price_att_rec.pricing_attribute94 := NULL;
3138: END IF;
3139:
3140: IF l_Line_price_att_rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN
3141: l_Line_price_att_rec.pricing_attribute95 := NULL;
3142: END IF;
3143:
3144: IF l_Line_price_att_rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN
3140: IF l_Line_price_att_rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN
3141: l_Line_price_att_rec.pricing_attribute95 := NULL;
3142: END IF;
3143:
3144: IF l_Line_price_att_rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN
3145: l_Line_price_att_rec.pricing_attribute96 := NULL;
3146: END IF;
3147:
3148: IF l_Line_price_att_rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN
3144: IF l_Line_price_att_rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN
3145: l_Line_price_att_rec.pricing_attribute96 := NULL;
3146: END IF;
3147:
3148: IF l_Line_price_att_rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN
3149: l_Line_price_att_rec.pricing_attribute97 := NULL;
3150: END IF;
3151:
3152: IF l_Line_price_att_rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN
3148: IF l_Line_price_att_rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN
3149: l_Line_price_att_rec.pricing_attribute97 := NULL;
3150: END IF;
3151:
3152: IF l_Line_price_att_rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN
3153: l_Line_price_att_rec.pricing_attribute98 := NULL;
3154: END IF;
3155:
3156: IF l_Line_price_att_rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN
3152: IF l_Line_price_att_rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN
3153: l_Line_price_att_rec.pricing_attribute98 := NULL;
3154: END IF;
3155:
3156: IF l_Line_price_att_rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN
3157: l_Line_price_att_rec.pricing_attribute99 := NULL;
3158: END IF;
3159:
3160: IF l_Line_price_att_rec.pricing_context = FND_API.G_MISS_CHAR THEN
3156: IF l_Line_price_att_rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN
3157: l_Line_price_att_rec.pricing_attribute99 := NULL;
3158: END IF;
3159:
3160: IF l_Line_price_att_rec.pricing_context = FND_API.G_MISS_CHAR THEN
3161: l_Line_price_att_rec.pricing_context := NULL;
3162: END IF;
3163:
3164: IF l_Line_price_att_rec.program_application_id = FND_API.G_MISS_NUM THEN
3160: IF l_Line_price_att_rec.pricing_context = FND_API.G_MISS_CHAR THEN
3161: l_Line_price_att_rec.pricing_context := NULL;
3162: END IF;
3163:
3164: IF l_Line_price_att_rec.program_application_id = FND_API.G_MISS_NUM THEN
3165: l_Line_price_att_rec.program_application_id := NULL;
3166: END IF;
3167:
3168: IF l_Line_price_att_rec.program_id = FND_API.G_MISS_NUM THEN
3164: IF l_Line_price_att_rec.program_application_id = FND_API.G_MISS_NUM THEN
3165: l_Line_price_att_rec.program_application_id := NULL;
3166: END IF;
3167:
3168: IF l_Line_price_att_rec.program_id = FND_API.G_MISS_NUM THEN
3169: l_Line_price_att_rec.program_id := NULL;
3170: END IF;
3171:
3172: IF l_Line_price_att_rec.program_update_date = FND_API.G_MISS_DATE THEN
3168: IF l_Line_price_att_rec.program_id = FND_API.G_MISS_NUM THEN
3169: l_Line_price_att_rec.program_id := NULL;
3170: END IF;
3171:
3172: IF l_Line_price_att_rec.program_update_date = FND_API.G_MISS_DATE THEN
3173: l_Line_price_att_rec.program_update_date := NULL;
3174: END IF;
3175:
3176: IF l_Line_price_att_rec.request_id = FND_API.G_MISS_NUM THEN
3172: IF l_Line_price_att_rec.program_update_date = FND_API.G_MISS_DATE THEN
3173: l_Line_price_att_rec.program_update_date := NULL;
3174: END IF;
3175:
3176: IF l_Line_price_att_rec.request_id = FND_API.G_MISS_NUM THEN
3177: l_Line_price_att_rec.request_id := NULL;
3178: END IF;
3179:
3180: IF l_Line_price_att_rec.orig_sys_atts_ref = FND_API.G_MISS_CHAR THEN
3176: IF l_Line_price_att_rec.request_id = FND_API.G_MISS_NUM THEN
3177: l_Line_price_att_rec.request_id := NULL;
3178: END IF;
3179:
3180: IF l_Line_price_att_rec.orig_sys_atts_ref = FND_API.G_MISS_CHAR THEN
3181: l_Line_price_att_rec.orig_sys_atts_ref := NULL;
3182: END IF;
3183: -- RETURN l_Line_price_att_rec;
3184: p_x_Line_price_att_rec := l_Line_price_att_rec;
3448: IF l_return_status = 'E' THEN
3449: oe_debug_pub.add('OTA API - Error.', 1);
3450: FND_MESSAGE.SET_NAME('OTA',l_msg_name);
3451: OE_MSG_PUB.ADD;
3452: RAISE FND_API.G_EXC_ERROR;
3453: END IF;
3454:
3455: ELSE
3456: oe_debug_pub.add('OTA module is not installed. ',1);
4202:
4203: PROCEDURE Lock_Row
4204: ( x_return_status OUT NOCOPY VARCHAR2
4205: , p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
4206: , p_order_price_attrib_id IN NUMBER := FND_API.G_MISS_NUM
4207: )
4208: IS
4209: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4210: l_order_price_attrib_id NUMBER;
4216: SAVEPOINT Lock_Row;
4217:
4218: l_lock_control := NULL;
4219:
4220: IF p_order_price_attrib_id <> FND_API.G_MISS_NUM THEN
4221: l_order_price_attrib_id := p_order_price_attrib_id;
4222: ELSE
4223: l_order_price_attrib_id := p_x_Line_Price_Att_rec.order_price_attrib_id;
4224: l_lock_control := p_x_Line_Price_Att_rec.lock_control;
4241: -- If lock_control is not passed(is null or missing), then return the locked record.
4242:
4243:
4244: IF l_lock_control is null OR
4245: l_lock_control = FND_API.G_MISS_NUM
4246: THEN
4247:
4248: -- Set return status
4249: x_return_status := FND_API.G_RET_STS_SUCCESS;
4245: l_lock_control = FND_API.G_MISS_NUM
4246: THEN
4247:
4248: -- Set return status
4249: x_return_status := FND_API.G_RET_STS_SUCCESS;
4250: p_x_line_Price_Att_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4251:
4252: -- return for lock by ID.
4253: RETURN;
4246: THEN
4247:
4248: -- Set return status
4249: x_return_status := FND_API.G_RET_STS_SUCCESS;
4250: p_x_line_Price_Att_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4251:
4252: -- return for lock by ID.
4253: RETURN;
4254:
4268: oe_debug_pub.add('locked row', 1);
4269:
4270: -- Set return status
4271:
4272: x_return_status := FND_API.G_RET_STS_SUCCESS;
4273: p_x_line_Price_Att_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4274:
4275: ELSE
4276:
4269:
4270: -- Set return status
4271:
4272: x_return_status := FND_API.G_RET_STS_SUCCESS;
4273: p_x_line_Price_Att_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4274:
4275: ELSE
4276:
4277: -- Row has changed by another user.
4276:
4277: -- Row has changed by another user.
4278: oe_debug_pub.add('row changed by other user', 1);
4279:
4280: x_return_status := FND_API.G_RET_STS_ERROR;
4281: p_x_line_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4282:
4283: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4284: THEN
4277: -- Row has changed by another user.
4278: oe_debug_pub.add('row changed by other user', 1);
4279:
4280: x_return_status := FND_API.G_RET_STS_ERROR;
4281: p_x_line_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4282:
4283: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4284: THEN
4285:
4296: EXCEPTION
4297:
4298: WHEN NO_DATA_FOUND THEN
4299:
4300: x_return_status := FND_API.G_RET_STS_ERROR;
4301: p_x_Line_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4302:
4303: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4304: THEN
4297:
4298: WHEN NO_DATA_FOUND THEN
4299:
4300: x_return_status := FND_API.G_RET_STS_ERROR;
4301: p_x_Line_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4302:
4303: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4304: THEN
4305:
4308:
4309: END IF;
4310: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4311:
4312: x_return_status := FND_API.G_RET_STS_ERROR;
4313: p_x_Line_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4314:
4315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4316: THEN
4309: END IF;
4310: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4311:
4312: x_return_status := FND_API.G_RET_STS_ERROR;
4313: p_x_Line_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4314:
4315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4316: THEN
4317:
4320:
4321: END IF;
4322: WHEN OTHERS THEN
4323:
4324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4325: p_x_Line_Price_Att_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4326:
4327: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4328: THEN
4321: END IF;
4322: WHEN OTHERS THEN
4323:
4324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4325: p_x_Line_Price_Att_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4326:
4327: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4328: THEN
4329: FND_MSG_PUB.Add_Exc_Msg
4336:
4337: -- procedure lock_rows
4338: PROCEDURE Lock_Rows
4339: ( p_order_price_attrib_id IN NUMBER
4340: := FND_API.G_MISS_NUM
4341: , p_line_id IN NUMBER
4342: := FND_API.G_MISS_NUM
4343: , x_Line_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
4344: , x_return_status OUT NOCOPY VARCHAR2
4338: PROCEDURE Lock_Rows
4339: ( p_order_price_attrib_id IN NUMBER
4340: := FND_API.G_MISS_NUM
4341: , p_line_id IN NUMBER
4342: := FND_API.G_MISS_NUM
4343: , x_Line_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
4344: , x_return_status OUT NOCOPY VARCHAR2
4345: )
4346: IS
4359:
4360: oe_debug_pub.add('Entering OE_Line_PAttr_Util.Lock_Rows.', 1);
4361:
4362: IF (p_order_price_attrib_id IS NOT NULL AND
4363: p_order_price_attrib_id <> FND_API.G_MISS_NUM) AND
4364: (p_line_id IS NOT NULL AND
4365: p_line_id <> FND_API.G_MISS_NUM)
4366: THEN
4367: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4361:
4362: IF (p_order_price_attrib_id IS NOT NULL AND
4363: p_order_price_attrib_id <> FND_API.G_MISS_NUM) AND
4364: (p_line_id IS NOT NULL AND
4365: p_line_id <> FND_API.G_MISS_NUM)
4366: THEN
4367: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4368: OE_MSG_PUB.Add_Exc_Msg
4369: ( G_PKG_NAME
4371: , 'Keys are mutually exclusive: order_price_attrib_id = ' ||
4372: p_order_price_attrib_id || ', line_id = ' || p_line_id );
4373: END IF;
4374:
4375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4376: END IF;
4377:
4378: IF p_order_price_attrib_id <> FND_API.G_MISS_NUM THEN
4379:
4374:
4375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4376: END IF;
4377:
4378: IF p_order_price_attrib_id <> FND_API.G_MISS_NUM THEN
4379:
4380: SELECT order_price_attrib_id
4381: INTO l_order_price_attrib_id
4382: FROM oe_order_price_attribs
4386:
4387: -- null line_id shouldn't be passed in unnecessarily if
4388: -- order_price_attrib_id is passed in already.
4389: BEGIN
4390: IF p_line_id <> FND_API.G_MISS_NUM THEN
4391: SAVEPOINT LOCK_ROWS;
4392: OPEN lock_pattr_lines(p_line_id);
4393:
4394: LOOP
4414: , p_line_id => p_line_id
4415: , x_Line_Price_Att_tbl => x_Line_Price_Att_tbl
4416: );
4417:
4418: x_return_status := FND_API.G_RET_STS_SUCCESS;
4419:
4420: EXCEPTION
4421: WHEN NO_DATA_FOUND THEN
4422: x_return_status := FND_API.G_RET_STS_ERROR;
4418: x_return_status := FND_API.G_RET_STS_SUCCESS;
4419:
4420: EXCEPTION
4421: WHEN NO_DATA_FOUND THEN
4422: x_return_status := FND_API.G_RET_STS_ERROR;
4423: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4424: THEN
4425: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4426: OE_MSG_PUB.Add;
4426: OE_MSG_PUB.Add;
4427: END IF;
4428:
4429: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4430: x_return_status := FND_API.G_RET_STS_ERROR;
4431: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4432: THEN
4433: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4434: OE_MSG_PUB.Add;
4434: OE_MSG_PUB.Add;
4435: END IF;
4436:
4437: WHEN OTHERS THEN
4438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4439: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4440: THEN
4441: OE_MSG_PUB.Add_Exc_Msg
4442: ( G_PKG_NAME
4511:
4512: l_line_price_att_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
4513: l_line_price_att_tbl(i).line_id := p_to_line_id;
4514: l_line_price_att_tbl(i).header_id := p_to_header_id;
4515: l_line_price_att_tbl(i).order_price_attrib_id := FND_API.G_MISS_NUM;
4516:
4517: l_x_line_price_att_tbl(l_x_line_price_att_tbl.count+1)
4518: := l_line_price_att_tbl(i);
4519:
4584: -- OE_Globals.G_RECURSION_MODE := 'N';
4585:
4586: End IF;
4587:
4588: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4590: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4591: RAISE FND_API.G_EXC_ERROR;
4592: END IF;
4585:
4586: End IF;
4587:
4588: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4590: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4591: RAISE FND_API.G_EXC_ERROR;
4592: END IF;
4593:
4586: End IF;
4587:
4588: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4590: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4591: RAISE FND_API.G_EXC_ERROR;
4592: END IF;
4593:
4594: oe_debug_pub.add('Exiting OE_Line_PAttr_Util.copy_pricing_attribtes.', 1);
4587:
4588: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4590: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4591: RAISE FND_API.G_EXC_ERROR;
4592: END IF;
4593:
4594: oe_debug_pub.add('Exiting OE_Line_PAttr_Util.copy_pricing_attribtes.', 1);
4595:
4593:
4594: oe_debug_pub.add('Exiting OE_Line_PAttr_Util.copy_pricing_attribtes.', 1);
4595:
4596: Exception
4597: WHEN FND_API.G_EXC_ERROR THEN
4598:
4599: x_return_status := FND_API.G_RET_STS_ERROR;
4600:
4601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4595:
4596: Exception
4597: WHEN FND_API.G_EXC_ERROR THEN
4598:
4599: x_return_status := FND_API.G_RET_STS_ERROR;
4600:
4601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4602:
4603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4597: WHEN FND_API.G_EXC_ERROR THEN
4598:
4599: x_return_status := FND_API.G_RET_STS_ERROR;
4600:
4601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4602:
4603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4604:
4605: END copy_pricing_attributes;
4599: x_return_status := FND_API.G_RET_STS_ERROR;
4600:
4601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4602:
4603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4604:
4605: END copy_pricing_attributes;
4606:
4607: -- Fixed bug 1857538
4664: CLOSE Get_Option_Lines;
4665: */
4666:
4667:
4668: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4670: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4671: RAISE FND_API.G_EXC_ERROR;
4672: END IF;
4665: */
4666:
4667:
4668: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4670: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4671: RAISE FND_API.G_EXC_ERROR;
4672: END IF;
4673:
4666:
4667:
4668: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4670: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4671: RAISE FND_API.G_EXC_ERROR;
4672: END IF;
4673:
4674: oe_debug_pub.add('Exiting OE_Line_PAttr_Util.copy_model_pattr.', 1);
4667:
4668: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4670: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4671: RAISE FND_API.G_EXC_ERROR;
4672: END IF;
4673:
4674: oe_debug_pub.add('Exiting OE_Line_PAttr_Util.copy_model_pattr.', 1);
4675:
4673:
4674: oe_debug_pub.add('Exiting OE_Line_PAttr_Util.copy_model_pattr.', 1);
4675:
4676: EXCEPTION
4677: WHEN FND_API.G_EXC_ERROR THEN
4678:
4679: x_return_status := FND_API.G_RET_STS_ERROR;
4680:
4681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4675:
4676: EXCEPTION
4677: WHEN FND_API.G_EXC_ERROR THEN
4678:
4679: x_return_status := FND_API.G_RET_STS_ERROR;
4680:
4681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4682:
4683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4677: WHEN FND_API.G_EXC_ERROR THEN
4678:
4679: x_return_status := FND_API.G_RET_STS_ERROR;
4680:
4681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4682:
4683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4684:
4685: END copy_model_pattr;
4679: x_return_status := FND_API.G_RET_STS_ERROR;
4680:
4681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4682:
4683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4684:
4685: END copy_model_pattr;
4686:
4687: END OE_Line_PAttr_Util;