[Home] [Help]
90: ) Is
91:
92: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
93: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
94: l_control_rec OE_GLOBALS.Control_Rec_Type;
95: l_return_status VARCHAR2(1);
96: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
97: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
98: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
125: IF l_debug_level > 0 THEN
126: oe_debug_pub.add( 'ENERING OE_OE_FORM_LINE_PATTR.DEFAULT_ATTRIBUTE.' , 1 ) ;
127: END IF;
128: -- Set the UI flag
129: OE_GLOBALS.G_UI_FLAG := TRUE;
130:
131: -- Set Control Flags
132: l_control_rec.controlled_operation := TRUE;
133: l_control_rec.check_security := TRUE;
176: l_x_Line_Price_Att_Rec.override_flag := NULL;
177:
178:
179: -- Set Operation to Create
180: l_x_Line_Price_Att_Rec.operation := OE_GLOBALS.G_OPR_CREATE;
181:
182: l_x_Line_Price_Att_Tbl(1) := l_x_Line_Price_Att_Rec;
183: IF l_debug_level > 0 THEN
184: oe_debug_pub.add( 'BEFORE CALLING OE_ORDER_ADJ_PVT.LINE_PRICE_ATTS' ) ;
241: p_Line_Price_Att_rec => l_x_Line_Price_Att_Rec
242: );
243:
244: -- Re-set the UI flag to FALSE
245: OE_GLOBALS.G_UI_FLAG := FALSE;
246:
247: -- Set return status.
248: x_return_status := FND_API.G_RET_STS_SUCCESS;
249:
259: END IF;
260: EXCEPTION
261: WHEN FND_API.G_EXC_ERROR THEN
262:
263: OE_GLOBALS.G_UI_FLAG := FALSE;
264: x_return_status := FND_API.G_RET_STS_ERROR;
265:
266: -- Get message count and data
267:
271: );
272:
273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
274:
275: OE_GLOBALS.G_UI_FLAG := FALSE;
276:
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278:
279: -- Get message count and data
284: );
285:
286: WHEN OTHERS THEN
287:
288: OE_GLOBALS.G_UI_FLAG := FALSE;
289:
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
291:
292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
567: IS
568: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
569: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
570:
571: l_control_rec OE_GLOBALS.Control_Rec_Type;
572: l_return_status VARCHAR2(1);
573: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
574: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
575: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
602: IF l_debug_level > 0 THEN
603: oe_debug_pub.add( 'ENERING OE_OE_FORM_LINE_PATTR.DEFAULT_ATTRIBUTE.' , 1 ) ;
604: END IF;
605: -- Set the UI flag
606: OE_GLOBALS.G_UI_FLAG := TRUE;
607:
608: -- Set Control Flags
609: l_control_rec.controlled_operation := TRUE;
610: l_control_rec.check_security := TRUE;
750: l_x_Line_Price_Att_Rec.override_flag := NULL;
751:
752:
753: -- Set Operation to Create
754: l_x_Line_Price_Att_Rec.operation := OE_GLOBALS.G_OPR_CREATE;
755:
756: l_x_Line_Price_Att_Tbl(1) := l_x_Line_Price_Att_Rec;
757: IF l_debug_level > 0 THEN
758: oe_debug_pub.add( 'BEFORE CALLING OE_ORDER_ADJ_PVT.LINE_PRICE_ATTS' ) ;
912: p_Line_Price_Att_rec => l_x_Line_Price_Att_Rec
913: );
914:
915: -- Re-set the UI flag to FALSE
916: OE_GLOBALS.G_UI_FLAG := FALSE;
917:
918: -- Set return status.
919: x_return_status := FND_API.G_RET_STS_SUCCESS;
920:
930: END IF;
931: EXCEPTION
932: WHEN FND_API.G_EXC_ERROR THEN
933:
934: OE_GLOBALS.G_UI_FLAG := FALSE;
935: x_return_status := FND_API.G_RET_STS_ERROR;
936:
937: -- Get message count and data
938:
942: );
943:
944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
945:
946: OE_GLOBALS.G_UI_FLAG := FALSE;
947:
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
949:
950: -- Get message count and data
955: );
956:
957: WHEN OTHERS THEN
958:
959: OE_GLOBALS.G_UI_FLAG := FALSE;
960:
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
962:
963: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1361: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
1362: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1363: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1364:
1365: l_control_rec OE_GLOBALS.Control_Rec_Type;
1366: l_return_status VARCHAR2(1);
1367: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1368: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1369: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1395: IF l_debug_level > 0 THEN
1396: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_PATTR.CHANGE_ATTRIBUTES' , 1 ) ;
1397: END IF;
1398: -- Set the UI flag
1399: OE_GLOBALS.G_UI_FLAG := TRUE;
1400:
1401: -- Set control flags.
1402: l_control_rec.controlled_operation := TRUE;
1403: l_control_rec.check_security := TRUE;
1414: l_control_rec.write_to_DB := TRUE;
1415: END IF;
1416:
1417: l_control_rec.process := FALSE;
1418: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE_PRICE_ATT;
1419:
1420:
1421: -- Instruct API to retain its caches
1422: l_control_rec.clear_api_cache := FALSE;
1713: END IF;
1714: --bug 3266627
1715: -- Set Operation.
1716: IF FND_API.To_Boolean(l_x_Line_Price_Att_rec.db_flag) THEN
1717: l_x_Line_Price_Att_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1718: ELSE
1719: l_x_Line_Price_Att_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1720: END IF;
1721:
1715: -- Set Operation.
1716: IF FND_API.To_Boolean(l_x_Line_Price_Att_rec.db_flag) THEN
1717: l_x_Line_Price_Att_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1718: ELSE
1719: l_x_Line_Price_Att_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1720: END IF;
1721:
1722: IF l_debug_level > 0 THEN
1723: oe_debug_pub.add( ' PATTR OPERATION:'||L_X_LINE_PRICE_ATT_REC.OPERATION ) ;
1725: --If new pricing context is null and old is not null then we
1726: --know user is clearing the field hence operation delete
1727: If l_x_line_price_att_rec.pricing_context is Null and
1728: l_x_old_Line_Price_Att_rec.pricing_context is Not Null and
1729: l_x_Line_Price_Att_rec.operation <> OE_GLOBALS.G_OPR_CREATE
1730: Then
1731:
1732: l_x_Line_Price_Att_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1733: clear_order_line_attr;
1728: l_x_old_Line_Price_Att_rec.pricing_context is Not Null and
1729: l_x_Line_Price_Att_rec.operation <> OE_GLOBALS.G_OPR_CREATE
1730: Then
1731:
1732: l_x_Line_Price_Att_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1733: clear_order_line_attr;
1734:
1735: End If;
1736:
1921: -- Record structure
1922:
1923: -- No Get Values
1924:
1925: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.override_flag,
1926: l_Line_Price_Att_Rec.override_flag)
1927: THEN
1928: x_override_flag := l_x_Line_Price_Att_Rec.override_flag;
1929: END IF;
1928: x_override_flag := l_x_Line_Price_Att_Rec.override_flag;
1929: END IF;
1930:
1931:
1932: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute1,
1933: l_Line_Price_Att_Rec.attribute1)
1934: THEN
1935: x_attribute1 := l_x_Line_Price_Att_Rec.attribute1;
1936: END IF;
1935: x_attribute1 := l_x_Line_Price_Att_Rec.attribute1;
1936: END IF;
1937:
1938:
1939: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute2,
1940: l_Line_Price_Att_Rec.attribute2)
1941: THEN
1942: x_attribute3 := l_x_Line_Price_Att_Rec.attribute2;
1943: END IF;
1941: THEN
1942: x_attribute3 := l_x_Line_Price_Att_Rec.attribute2;
1943: END IF;
1944:
1945: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute3,
1946: l_Line_Price_Att_Rec.attribute3)
1947: THEN
1948: x_attribute3 := l_x_Line_Price_Att_Rec.attribute3;
1949: END IF;
1948: x_attribute3 := l_x_Line_Price_Att_Rec.attribute3;
1949: END IF;
1950:
1951:
1952: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute4,
1953: l_Line_Price_Att_Rec.attribute4)
1954: THEN
1955: x_attribute4 := l_x_Line_Price_Att_Rec.attribute4;
1956: END IF;
1954: THEN
1955: x_attribute4 := l_x_Line_Price_Att_Rec.attribute4;
1956: END IF;
1957:
1958: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute5,
1959: l_Line_Price_Att_Rec.attribute5)
1960: THEN
1961: x_attribute5 := l_x_Line_Price_Att_Rec.attribute5;
1962: END IF;
1959: l_Line_Price_Att_Rec.attribute5)
1960: THEN
1961: x_attribute5 := l_x_Line_Price_Att_Rec.attribute5;
1962: END IF;
1963: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute6,
1964: l_Line_Price_Att_Rec.attribute6)
1965: THEN
1966: x_attribute6 := l_x_Line_Price_Att_Rec.attribute6;
1967: END IF;
1964: l_Line_Price_Att_Rec.attribute6)
1965: THEN
1966: x_attribute6 := l_x_Line_Price_Att_Rec.attribute6;
1967: END IF;
1968: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute7,
1969: l_Line_Price_Att_Rec.attribute7)
1970: THEN
1971: x_attribute7 := l_x_Line_Price_Att_Rec.attribute7;
1972: END IF;
1970: THEN
1971: x_attribute7 := l_x_Line_Price_Att_Rec.attribute7;
1972: END IF;
1973:
1974: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute8,
1975: l_Line_Price_Att_Rec.attribute8)
1976: THEN
1977: x_attribute8 := l_x_Line_Price_Att_Rec.attribute8;
1978: END IF;
1978: END IF;
1979:
1980:
1981:
1982: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute9,
1983: l_Line_Price_Att_Rec.attribute9)
1984: THEN
1985: x_attribute9 := l_x_Line_Price_Att_Rec.attribute9;
1986: END IF;
1984: THEN
1985: x_attribute9 := l_x_Line_Price_Att_Rec.attribute9;
1986: END IF;
1987:
1988: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute10,
1989: l_Line_Price_Att_Rec.attribute10)
1990: THEN
1991: x_attribute10 := l_x_Line_Price_Att_Rec.attribute10;
1992: END IF;
1990: THEN
1991: x_attribute10 := l_x_Line_Price_Att_Rec.attribute10;
1992: END IF;
1993:
1994: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute11,
1995: l_Line_Price_Att_Rec.attribute11)
1996: THEN
1997: x_attribute11 := l_x_Line_Price_Att_Rec.attribute11;
1998: END IF;
1996: THEN
1997: x_attribute11 := l_x_Line_Price_Att_Rec.attribute11;
1998: END IF;
1999:
2000: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute12,
2001: l_Line_Price_Att_Rec.attribute12)
2002: THEN
2003: x_attribute12 := l_x_Line_Price_Att_Rec.attribute12;
2004: END IF;
2002: THEN
2003: x_attribute12 := l_x_Line_Price_Att_Rec.attribute12;
2004: END IF;
2005:
2006: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute13,
2007: l_Line_Price_Att_Rec.attribute13)
2008: THEN
2009: x_attribute13 := l_x_Line_Price_Att_Rec.attribute13;
2010: END IF;
2008: THEN
2009: x_attribute13 := l_x_Line_Price_Att_Rec.attribute13;
2010: END IF;
2011:
2012: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute14,
2013: l_Line_Price_Att_Rec.attribute14)
2014: THEN
2015: x_attribute14 := l_x_Line_Price_Att_Rec.attribute14;
2016: END IF;
2014: THEN
2015: x_attribute14 := l_x_Line_Price_Att_Rec.attribute14;
2016: END IF;
2017:
2018: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute15,
2019: l_Line_Price_Att_Rec.attribute15)
2020: THEN
2021: x_attribute15 := l_x_Line_Price_Att_Rec.attribute15;
2022: END IF;
2020: THEN
2021: x_attribute15 := l_x_Line_Price_Att_Rec.attribute15;
2022: END IF;
2023:
2024: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.header_id,
2025: l_Line_Price_Att_Rec.header_id)
2026: THEN
2027: x_header_id := l_x_Line_Price_Att_Rec.header_id;
2028: END IF;
2026: THEN
2027: x_header_id := l_x_Line_Price_Att_Rec.header_id;
2028: END IF;
2029:
2030: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.line_id,
2031: l_Line_Price_Att_Rec.line_id)
2032: THEN
2033: x_line_id := l_x_Line_Price_Att_Rec.line_id;
2034: END IF;
2032: THEN
2033: x_line_id := l_x_Line_Price_Att_Rec.line_id;
2034: END IF;
2035:
2036: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.flex_title,
2037: l_Line_Price_Att_Rec.flex_title)
2038: THEN
2039: x_flex_title := l_x_Line_Price_Att_Rec.flex_title;
2040: END IF;
2038: THEN
2039: x_flex_title := l_x_Line_Price_Att_Rec.flex_title;
2040: END IF;
2041:
2042: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.order_price_attrib_id,
2043: l_Line_Price_Att_Rec.order_price_attrib_id)
2044: THEN
2045: x_order_price_attrib_id := l_x_Line_Price_Att_Rec.order_price_attrib_id;
2046: END IF;
2044: THEN
2045: x_order_price_attrib_id := l_x_Line_Price_Att_Rec.order_price_attrib_id;
2046: END IF;
2047:
2048: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute1,
2049: l_Line_Price_Att_Rec.pricing_attribute1)
2050: THEN
2051: x_pricing_attribute1 := l_x_Line_Price_Att_Rec.pricing_attribute1;
2052: END IF;
2050: THEN
2051: x_pricing_attribute1 := l_x_Line_Price_Att_Rec.pricing_attribute1;
2052: END IF;
2053:
2054: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute10,
2055: l_Line_Price_Att_Rec.pricing_attribute10)
2056: THEN
2057: x_pricing_attribute10 := l_x_Line_Price_Att_Rec.pricing_attribute10;
2058: END IF;
2056: THEN
2057: x_pricing_attribute10 := l_x_Line_Price_Att_Rec.pricing_attribute10;
2058: END IF;
2059:
2060: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute100,
2061: l_Line_Price_Att_Rec.pricing_attribute100)
2062: THEN
2063: x_pricing_attribute100 := l_x_Line_Price_Att_Rec.pricing_attribute100;
2064: END IF;
2062: THEN
2063: x_pricing_attribute100 := l_x_Line_Price_Att_Rec.pricing_attribute100;
2064: END IF;
2065:
2066: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute11,
2067: l_Line_Price_Att_Rec.pricing_attribute11)
2068: THEN
2069: x_pricing_attribute11 := l_x_Line_Price_Att_Rec.pricing_attribute11;
2070: END IF;
2068: THEN
2069: x_pricing_attribute11 := l_x_Line_Price_Att_Rec.pricing_attribute11;
2070: END IF;
2071:
2072: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute12,
2073: l_Line_Price_Att_Rec.pricing_attribute12)
2074: THEN
2075: x_pricing_attribute12 := l_x_Line_Price_Att_Rec.pricing_attribute12;
2076: END IF;
2074: THEN
2075: x_pricing_attribute12 := l_x_Line_Price_Att_Rec.pricing_attribute12;
2076: END IF;
2077:
2078: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute13,
2079: l_Line_Price_Att_Rec.pricing_attribute13)
2080: THEN
2081: x_pricing_attribute13 := l_x_Line_Price_Att_Rec.pricing_attribute13;
2082: END IF;
2080: THEN
2081: x_pricing_attribute13 := l_x_Line_Price_Att_Rec.pricing_attribute13;
2082: END IF;
2083:
2084: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute14,
2085: l_Line_Price_Att_Rec.pricing_attribute14)
2086: THEN
2087: x_pricing_attribute14 := l_x_Line_Price_Att_Rec.pricing_attribute14;
2088: END IF;
2086: THEN
2087: x_pricing_attribute14 := l_x_Line_Price_Att_Rec.pricing_attribute14;
2088: END IF;
2089:
2090: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute15,
2091: l_Line_Price_Att_Rec.pricing_attribute15)
2092: THEN
2093: x_pricing_attribute15 := l_x_Line_Price_Att_Rec.pricing_attribute15;
2094: END IF;
2092: THEN
2093: x_pricing_attribute15 := l_x_Line_Price_Att_Rec.pricing_attribute15;
2094: END IF;
2095:
2096: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute16,
2097: l_Line_Price_Att_Rec.pricing_attribute16)
2098: THEN
2099: x_pricing_attribute16 := l_x_Line_Price_Att_Rec.pricing_attribute16;
2100: END IF;
2098: THEN
2099: x_pricing_attribute16 := l_x_Line_Price_Att_Rec.pricing_attribute16;
2100: END IF;
2101:
2102: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute17,
2103: l_Line_Price_Att_Rec.pricing_attribute17)
2104: THEN
2105: x_pricing_attribute17 := l_x_Line_Price_Att_Rec.pricing_attribute17;
2106: END IF;
2104: THEN
2105: x_pricing_attribute17 := l_x_Line_Price_Att_Rec.pricing_attribute17;
2106: END IF;
2107:
2108: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute18,
2109: l_Line_Price_Att_Rec.pricing_attribute18)
2110: THEN
2111: x_pricing_attribute18 := l_x_Line_Price_Att_Rec.pricing_attribute18;
2112: END IF;
2110: THEN
2111: x_pricing_attribute18 := l_x_Line_Price_Att_Rec.pricing_attribute18;
2112: END IF;
2113:
2114: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute19,
2115: l_Line_Price_Att_Rec.pricing_attribute19)
2116: THEN
2117: x_pricing_attribute19 := l_x_Line_Price_Att_Rec.pricing_attribute19;
2118: END IF;
2116: THEN
2117: x_pricing_attribute19 := l_x_Line_Price_Att_Rec.pricing_attribute19;
2118: END IF;
2119:
2120: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute2,
2121: l_Line_Price_Att_Rec.pricing_attribute2)
2122: THEN
2123: x_pricing_attribute2 := l_x_Line_Price_Att_Rec.pricing_attribute2;
2124: END IF;
2122: THEN
2123: x_pricing_attribute2 := l_x_Line_Price_Att_Rec.pricing_attribute2;
2124: END IF;
2125:
2126: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute20,
2127: l_Line_Price_Att_Rec.pricing_attribute20)
2128: THEN
2129: x_pricing_attribute20 := l_x_Line_Price_Att_Rec.pricing_attribute20;
2130: END IF;
2128: THEN
2129: x_pricing_attribute20 := l_x_Line_Price_Att_Rec.pricing_attribute20;
2130: END IF;
2131:
2132: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute21,
2133: l_Line_Price_Att_Rec.pricing_attribute21)
2134: THEN
2135: x_pricing_attribute21 := l_x_Line_Price_Att_Rec.pricing_attribute21;
2136: END IF;
2134: THEN
2135: x_pricing_attribute21 := l_x_Line_Price_Att_Rec.pricing_attribute21;
2136: END IF;
2137:
2138: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute22,
2139: l_Line_Price_Att_Rec.pricing_attribute22)
2140: THEN
2141: x_pricing_attribute22 := l_x_Line_Price_Att_Rec.pricing_attribute22;
2142: END IF;
2140: THEN
2141: x_pricing_attribute22 := l_x_Line_Price_Att_Rec.pricing_attribute22;
2142: END IF;
2143:
2144: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute23,
2145: l_Line_Price_Att_Rec.pricing_attribute23)
2146: THEN
2147: x_pricing_attribute23 := l_x_Line_Price_Att_Rec.pricing_attribute23;
2148: END IF;
2146: THEN
2147: x_pricing_attribute23 := l_x_Line_Price_Att_Rec.pricing_attribute23;
2148: END IF;
2149:
2150: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute24,
2151: l_Line_Price_Att_Rec.pricing_attribute24)
2152: THEN
2153: x_pricing_attribute24 := l_x_Line_Price_Att_Rec.pricing_attribute24;
2154: END IF;
2152: THEN
2153: x_pricing_attribute24 := l_x_Line_Price_Att_Rec.pricing_attribute24;
2154: END IF;
2155:
2156: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute25,
2157: l_Line_Price_Att_Rec.pricing_attribute25)
2158: THEN
2159: x_pricing_attribute25 := l_x_Line_Price_Att_Rec.pricing_attribute25;
2160: END IF;
2158: THEN
2159: x_pricing_attribute25 := l_x_Line_Price_Att_Rec.pricing_attribute25;
2160: END IF;
2161:
2162: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute26,
2163: l_Line_Price_Att_Rec.pricing_attribute26)
2164: THEN
2165: x_pricing_attribute26 := l_x_Line_Price_Att_Rec.pricing_attribute26;
2166: END IF;
2164: THEN
2165: x_pricing_attribute26 := l_x_Line_Price_Att_Rec.pricing_attribute26;
2166: END IF;
2167:
2168: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute27,
2169: l_Line_Price_Att_Rec.pricing_attribute27)
2170: THEN
2171: x_pricing_attribute27 := l_x_Line_Price_Att_Rec.pricing_attribute27;
2172: END IF;
2170: THEN
2171: x_pricing_attribute27 := l_x_Line_Price_Att_Rec.pricing_attribute27;
2172: END IF;
2173:
2174: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute28,
2175: l_Line_Price_Att_Rec.pricing_attribute28)
2176: THEN
2177: x_pricing_attribute28 := l_x_Line_Price_Att_Rec.pricing_attribute28;
2178: END IF;
2176: THEN
2177: x_pricing_attribute28 := l_x_Line_Price_Att_Rec.pricing_attribute28;
2178: END IF;
2179:
2180: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute29,
2181: l_Line_Price_Att_Rec.pricing_attribute29)
2182: THEN
2183: x_pricing_attribute29 := l_x_Line_Price_Att_Rec.pricing_attribute29;
2184: END IF;
2182: THEN
2183: x_pricing_attribute29 := l_x_Line_Price_Att_Rec.pricing_attribute29;
2184: END IF;
2185:
2186: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute3,
2187: l_Line_Price_Att_Rec.pricing_attribute3)
2188: THEN
2189: x_pricing_attribute3 := l_x_Line_Price_Att_Rec.pricing_attribute3;
2190: END IF;
2188: THEN
2189: x_pricing_attribute3 := l_x_Line_Price_Att_Rec.pricing_attribute3;
2190: END IF;
2191:
2192: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute30,
2193: l_Line_Price_Att_Rec.pricing_attribute30)
2194: THEN
2195: x_pricing_attribute30 := l_x_Line_Price_Att_Rec.pricing_attribute30;
2196: END IF;
2194: THEN
2195: x_pricing_attribute30 := l_x_Line_Price_Att_Rec.pricing_attribute30;
2196: END IF;
2197:
2198: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute31,
2199: l_Line_Price_Att_Rec.pricing_attribute31)
2200: THEN
2201: x_pricing_attribute31 := l_x_Line_Price_Att_Rec.pricing_attribute31;
2202: END IF;
2200: THEN
2201: x_pricing_attribute31 := l_x_Line_Price_Att_Rec.pricing_attribute31;
2202: END IF;
2203:
2204: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute32,
2205: l_Line_Price_Att_Rec.pricing_attribute32)
2206: THEN
2207: x_pricing_attribute32 := l_x_Line_Price_Att_Rec.pricing_attribute32;
2208: END IF;
2206: THEN
2207: x_pricing_attribute32 := l_x_Line_Price_Att_Rec.pricing_attribute32;
2208: END IF;
2209:
2210: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute33,
2211: l_Line_Price_Att_Rec.pricing_attribute33)
2212: THEN
2213: x_pricing_attribute33 := l_x_Line_Price_Att_Rec.pricing_attribute33;
2214: END IF;
2212: THEN
2213: x_pricing_attribute33 := l_x_Line_Price_Att_Rec.pricing_attribute33;
2214: END IF;
2215:
2216: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute34,
2217: l_Line_Price_Att_Rec.pricing_attribute34)
2218: THEN
2219: x_pricing_attribute34 := l_x_Line_Price_Att_Rec.pricing_attribute34;
2220: END IF;
2218: THEN
2219: x_pricing_attribute34 := l_x_Line_Price_Att_Rec.pricing_attribute34;
2220: END IF;
2221:
2222: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute35,
2223: l_Line_Price_Att_Rec.pricing_attribute35)
2224: THEN
2225: x_pricing_attribute35 := l_x_Line_Price_Att_Rec.pricing_attribute35;
2226: END IF;
2224: THEN
2225: x_pricing_attribute35 := l_x_Line_Price_Att_Rec.pricing_attribute35;
2226: END IF;
2227:
2228: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute36,
2229: l_Line_Price_Att_Rec.pricing_attribute36)
2230: THEN
2231: x_pricing_attribute36 := l_x_Line_Price_Att_Rec.pricing_attribute36;
2232: END IF;
2230: THEN
2231: x_pricing_attribute36 := l_x_Line_Price_Att_Rec.pricing_attribute36;
2232: END IF;
2233:
2234: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute37,
2235: l_Line_Price_Att_Rec.pricing_attribute37)
2236: THEN
2237: x_pricing_attribute37 := l_x_Line_Price_Att_Rec.pricing_attribute37;
2238: END IF;
2236: THEN
2237: x_pricing_attribute37 := l_x_Line_Price_Att_Rec.pricing_attribute37;
2238: END IF;
2239:
2240: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute38,
2241: l_Line_Price_Att_Rec.pricing_attribute38)
2242: THEN
2243: x_pricing_attribute38 := l_x_Line_Price_Att_Rec.pricing_attribute38;
2244: END IF;
2242: THEN
2243: x_pricing_attribute38 := l_x_Line_Price_Att_Rec.pricing_attribute38;
2244: END IF;
2245:
2246: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute39,
2247: l_Line_Price_Att_Rec.pricing_attribute39)
2248: THEN
2249: x_pricing_attribute39 := l_x_Line_Price_Att_Rec.pricing_attribute39;
2250: END IF;
2248: THEN
2249: x_pricing_attribute39 := l_x_Line_Price_Att_Rec.pricing_attribute39;
2250: END IF;
2251:
2252: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute4,
2253: l_Line_Price_Att_Rec.pricing_attribute4)
2254: THEN
2255: x_pricing_attribute4 := l_x_Line_Price_Att_Rec.pricing_attribute4;
2256: END IF;
2254: THEN
2255: x_pricing_attribute4 := l_x_Line_Price_Att_Rec.pricing_attribute4;
2256: END IF;
2257:
2258: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute40,
2259: l_Line_Price_Att_Rec.pricing_attribute40)
2260: THEN
2261: x_pricing_attribute40 := l_x_Line_Price_Att_Rec.pricing_attribute40;
2262: END IF;
2260: THEN
2261: x_pricing_attribute40 := l_x_Line_Price_Att_Rec.pricing_attribute40;
2262: END IF;
2263:
2264: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute41,
2265: l_Line_Price_Att_Rec.pricing_attribute41)
2266: THEN
2267: x_pricing_attribute41 := l_x_Line_Price_Att_Rec.pricing_attribute41;
2268: END IF;
2266: THEN
2267: x_pricing_attribute41 := l_x_Line_Price_Att_Rec.pricing_attribute41;
2268: END IF;
2269:
2270: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute42,
2271: l_Line_Price_Att_Rec.pricing_attribute42)
2272: THEN
2273: x_pricing_attribute42 := l_x_Line_Price_Att_Rec.pricing_attribute42;
2274: END IF;
2272: THEN
2273: x_pricing_attribute42 := l_x_Line_Price_Att_Rec.pricing_attribute42;
2274: END IF;
2275:
2276: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute43,
2277: l_Line_Price_Att_Rec.pricing_attribute43)
2278: THEN
2279: x_pricing_attribute43 := l_x_Line_Price_Att_Rec.pricing_attribute43;
2280: END IF;
2278: THEN
2279: x_pricing_attribute43 := l_x_Line_Price_Att_Rec.pricing_attribute43;
2280: END IF;
2281:
2282: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute44,
2283: l_Line_Price_Att_Rec.pricing_attribute44)
2284: THEN
2285: x_pricing_attribute44 := l_x_Line_Price_Att_Rec.pricing_attribute44;
2286: END IF;
2284: THEN
2285: x_pricing_attribute44 := l_x_Line_Price_Att_Rec.pricing_attribute44;
2286: END IF;
2287:
2288: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute45,
2289: l_Line_Price_Att_Rec.pricing_attribute45)
2290: THEN
2291: x_pricing_attribute45 := l_x_Line_Price_Att_Rec.pricing_attribute45;
2292: END IF;
2290: THEN
2291: x_pricing_attribute45 := l_x_Line_Price_Att_Rec.pricing_attribute45;
2292: END IF;
2293:
2294: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute46,
2295: l_Line_Price_Att_Rec.pricing_attribute46)
2296: THEN
2297: x_pricing_attribute46 := l_x_Line_Price_Att_Rec.pricing_attribute46;
2298: END IF;
2296: THEN
2297: x_pricing_attribute46 := l_x_Line_Price_Att_Rec.pricing_attribute46;
2298: END IF;
2299:
2300: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute47,
2301: l_Line_Price_Att_Rec.pricing_attribute47)
2302: THEN
2303: x_pricing_attribute47 := l_x_Line_Price_Att_Rec.pricing_attribute47;
2304: END IF;
2302: THEN
2303: x_pricing_attribute47 := l_x_Line_Price_Att_Rec.pricing_attribute47;
2304: END IF;
2305:
2306: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute48,
2307: l_Line_Price_Att_Rec.pricing_attribute48)
2308: THEN
2309: x_pricing_attribute48 := l_x_Line_Price_Att_Rec.pricing_attribute48;
2310: END IF;
2308: THEN
2309: x_pricing_attribute48 := l_x_Line_Price_Att_Rec.pricing_attribute48;
2310: END IF;
2311:
2312: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute49,
2313: l_Line_Price_Att_Rec.pricing_attribute49)
2314: THEN
2315: x_pricing_attribute49 := l_x_Line_Price_Att_Rec.pricing_attribute49;
2316: END IF;
2314: THEN
2315: x_pricing_attribute49 := l_x_Line_Price_Att_Rec.pricing_attribute49;
2316: END IF;
2317:
2318: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute5,
2319: l_Line_Price_Att_Rec.pricing_attribute5)
2320: THEN
2321: x_pricing_attribute5 := l_x_Line_Price_Att_Rec.pricing_attribute5;
2322: END IF;
2320: THEN
2321: x_pricing_attribute5 := l_x_Line_Price_Att_Rec.pricing_attribute5;
2322: END IF;
2323:
2324: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute50,
2325: l_Line_Price_Att_Rec.pricing_attribute50)
2326: THEN
2327: x_pricing_attribute50 := l_x_Line_Price_Att_Rec.pricing_attribute50;
2328: END IF;
2326: THEN
2327: x_pricing_attribute50 := l_x_Line_Price_Att_Rec.pricing_attribute50;
2328: END IF;
2329:
2330: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute51,
2331: l_Line_Price_Att_Rec.pricing_attribute51)
2332: THEN
2333: x_pricing_attribute51 := l_x_Line_Price_Att_Rec.pricing_attribute51;
2334: END IF;
2332: THEN
2333: x_pricing_attribute51 := l_x_Line_Price_Att_Rec.pricing_attribute51;
2334: END IF;
2335:
2336: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute52,
2337: l_Line_Price_Att_Rec.pricing_attribute52)
2338: THEN
2339: x_pricing_attribute52 := l_x_Line_Price_Att_Rec.pricing_attribute52;
2340: END IF;
2338: THEN
2339: x_pricing_attribute52 := l_x_Line_Price_Att_Rec.pricing_attribute52;
2340: END IF;
2341:
2342: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute53,
2343: l_Line_Price_Att_Rec.pricing_attribute53)
2344: THEN
2345: x_pricing_attribute53 := l_x_Line_Price_Att_Rec.pricing_attribute53;
2346: END IF;
2344: THEN
2345: x_pricing_attribute53 := l_x_Line_Price_Att_Rec.pricing_attribute53;
2346: END IF;
2347:
2348: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute54,
2349: l_Line_Price_Att_Rec.pricing_attribute54)
2350: THEN
2351: x_pricing_attribute54 := l_x_Line_Price_Att_Rec.pricing_attribute54;
2352: END IF;
2350: THEN
2351: x_pricing_attribute54 := l_x_Line_Price_Att_Rec.pricing_attribute54;
2352: END IF;
2353:
2354: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute55,
2355: l_Line_Price_Att_Rec.pricing_attribute55)
2356: THEN
2357: x_pricing_attribute55 := l_x_Line_Price_Att_Rec.pricing_attribute55;
2358: END IF;
2356: THEN
2357: x_pricing_attribute55 := l_x_Line_Price_Att_Rec.pricing_attribute55;
2358: END IF;
2359:
2360: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute56,
2361: l_Line_Price_Att_Rec.pricing_attribute56)
2362: THEN
2363: x_pricing_attribute56 := l_x_Line_Price_Att_Rec.pricing_attribute56;
2364: END IF;
2362: THEN
2363: x_pricing_attribute56 := l_x_Line_Price_Att_Rec.pricing_attribute56;
2364: END IF;
2365:
2366: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute57,
2367: l_Line_Price_Att_Rec.pricing_attribute57)
2368: THEN
2369: x_pricing_attribute57 := l_x_Line_Price_Att_Rec.pricing_attribute57;
2370: END IF;
2368: THEN
2369: x_pricing_attribute57 := l_x_Line_Price_Att_Rec.pricing_attribute57;
2370: END IF;
2371:
2372: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute58,
2373: l_Line_Price_Att_Rec.pricing_attribute58)
2374: THEN
2375: x_pricing_attribute58 := l_x_Line_Price_Att_Rec.pricing_attribute58;
2376: END IF;
2374: THEN
2375: x_pricing_attribute58 := l_x_Line_Price_Att_Rec.pricing_attribute58;
2376: END IF;
2377:
2378: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute59,
2379: l_Line_Price_Att_Rec.pricing_attribute59)
2380: THEN
2381: x_pricing_attribute59 := l_x_Line_Price_Att_Rec.pricing_attribute59;
2382: END IF;
2380: THEN
2381: x_pricing_attribute59 := l_x_Line_Price_Att_Rec.pricing_attribute59;
2382: END IF;
2383:
2384: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute6,
2385: l_Line_Price_Att_Rec.pricing_attribute6)
2386: THEN
2387: x_pricing_attribute6 := l_x_Line_Price_Att_Rec.pricing_attribute6;
2388: END IF;
2386: THEN
2387: x_pricing_attribute6 := l_x_Line_Price_Att_Rec.pricing_attribute6;
2388: END IF;
2389:
2390: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute60,
2391: l_Line_Price_Att_Rec.pricing_attribute60)
2392: THEN
2393: x_pricing_attribute60 := l_x_Line_Price_Att_Rec.pricing_attribute60;
2394: END IF;
2392: THEN
2393: x_pricing_attribute60 := l_x_Line_Price_Att_Rec.pricing_attribute60;
2394: END IF;
2395:
2396: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute61,
2397: l_Line_Price_Att_Rec.pricing_attribute61)
2398: THEN
2399: x_pricing_attribute61 := l_x_Line_Price_Att_Rec.pricing_attribute61;
2400: END IF;
2398: THEN
2399: x_pricing_attribute61 := l_x_Line_Price_Att_Rec.pricing_attribute61;
2400: END IF;
2401:
2402: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute62,
2403: l_Line_Price_Att_Rec.pricing_attribute62)
2404: THEN
2405: x_pricing_attribute62 := l_x_Line_Price_Att_Rec.pricing_attribute62;
2406: END IF;
2404: THEN
2405: x_pricing_attribute62 := l_x_Line_Price_Att_Rec.pricing_attribute62;
2406: END IF;
2407:
2408: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute63,
2409: l_Line_Price_Att_Rec.pricing_attribute63)
2410: THEN
2411: x_pricing_attribute63 := l_x_Line_Price_Att_Rec.pricing_attribute63;
2412: END IF;
2410: THEN
2411: x_pricing_attribute63 := l_x_Line_Price_Att_Rec.pricing_attribute63;
2412: END IF;
2413:
2414: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute64,
2415: l_Line_Price_Att_Rec.pricing_attribute64)
2416: THEN
2417: x_pricing_attribute64 := l_x_Line_Price_Att_Rec.pricing_attribute64;
2418: END IF;
2416: THEN
2417: x_pricing_attribute64 := l_x_Line_Price_Att_Rec.pricing_attribute64;
2418: END IF;
2419:
2420: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute65,
2421: l_Line_Price_Att_Rec.pricing_attribute65)
2422: THEN
2423: x_pricing_attribute65 := l_x_Line_Price_Att_Rec.pricing_attribute65;
2424: END IF;
2422: THEN
2423: x_pricing_attribute65 := l_x_Line_Price_Att_Rec.pricing_attribute65;
2424: END IF;
2425:
2426: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute66,
2427: l_Line_Price_Att_Rec.pricing_attribute66)
2428: THEN
2429: x_pricing_attribute66 := l_x_Line_Price_Att_Rec.pricing_attribute66;
2430: END IF;
2428: THEN
2429: x_pricing_attribute66 := l_x_Line_Price_Att_Rec.pricing_attribute66;
2430: END IF;
2431:
2432: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute67,
2433: l_Line_Price_Att_Rec.pricing_attribute67)
2434: THEN
2435: x_pricing_attribute67 := l_x_Line_Price_Att_Rec.pricing_attribute67;
2436: END IF;
2434: THEN
2435: x_pricing_attribute67 := l_x_Line_Price_Att_Rec.pricing_attribute67;
2436: END IF;
2437:
2438: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute68,
2439: l_Line_Price_Att_Rec.pricing_attribute68)
2440: THEN
2441: x_pricing_attribute68 := l_x_Line_Price_Att_Rec.pricing_attribute68;
2442: END IF;
2440: THEN
2441: x_pricing_attribute68 := l_x_Line_Price_Att_Rec.pricing_attribute68;
2442: END IF;
2443:
2444: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute69,
2445: l_Line_Price_Att_Rec.pricing_attribute69)
2446: THEN
2447: x_pricing_attribute69 := l_x_Line_Price_Att_Rec.pricing_attribute69;
2448: END IF;
2446: THEN
2447: x_pricing_attribute69 := l_x_Line_Price_Att_Rec.pricing_attribute69;
2448: END IF;
2449:
2450: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute7,
2451: l_Line_Price_Att_Rec.pricing_attribute7)
2452: THEN
2453: x_pricing_attribute7 := l_x_Line_Price_Att_Rec.pricing_attribute7;
2454: END IF;
2452: THEN
2453: x_pricing_attribute7 := l_x_Line_Price_Att_Rec.pricing_attribute7;
2454: END IF;
2455:
2456: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute70,
2457: l_Line_Price_Att_Rec.pricing_attribute70)
2458: THEN
2459: x_pricing_attribute70 := l_x_Line_Price_Att_Rec.pricing_attribute70;
2460: END IF;
2458: THEN
2459: x_pricing_attribute70 := l_x_Line_Price_Att_Rec.pricing_attribute70;
2460: END IF;
2461:
2462: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute71,
2463: l_Line_Price_Att_Rec.pricing_attribute71)
2464: THEN
2465: x_pricing_attribute71 := l_x_Line_Price_Att_Rec.pricing_attribute71;
2466: END IF;
2464: THEN
2465: x_pricing_attribute71 := l_x_Line_Price_Att_Rec.pricing_attribute71;
2466: END IF;
2467:
2468: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute72,
2469: l_Line_Price_Att_Rec.pricing_attribute72)
2470: THEN
2471: x_pricing_attribute72 := l_x_Line_Price_Att_Rec.pricing_attribute72;
2472: END IF;
2470: THEN
2471: x_pricing_attribute72 := l_x_Line_Price_Att_Rec.pricing_attribute72;
2472: END IF;
2473:
2474: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute73,
2475: l_Line_Price_Att_Rec.pricing_attribute73)
2476: THEN
2477: x_pricing_attribute73 := l_x_Line_Price_Att_Rec.pricing_attribute73;
2478: END IF;
2476: THEN
2477: x_pricing_attribute73 := l_x_Line_Price_Att_Rec.pricing_attribute73;
2478: END IF;
2479:
2480: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute74,
2481: l_Line_Price_Att_Rec.pricing_attribute74)
2482: THEN
2483: x_pricing_attribute74 := l_x_Line_Price_Att_Rec.pricing_attribute74;
2484: END IF;
2482: THEN
2483: x_pricing_attribute74 := l_x_Line_Price_Att_Rec.pricing_attribute74;
2484: END IF;
2485:
2486: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute75,
2487: l_Line_Price_Att_Rec.pricing_attribute75)
2488: THEN
2489: x_pricing_attribute75 := l_x_Line_Price_Att_Rec.pricing_attribute75;
2490: END IF;
2488: THEN
2489: x_pricing_attribute75 := l_x_Line_Price_Att_Rec.pricing_attribute75;
2490: END IF;
2491:
2492: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute76,
2493: l_Line_Price_Att_Rec.pricing_attribute76)
2494: THEN
2495: x_pricing_attribute76 := l_x_Line_Price_Att_Rec.pricing_attribute76;
2496: END IF;
2494: THEN
2495: x_pricing_attribute76 := l_x_Line_Price_Att_Rec.pricing_attribute76;
2496: END IF;
2497:
2498: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute77,
2499: l_Line_Price_Att_Rec.pricing_attribute77)
2500: THEN
2501: x_pricing_attribute77 := l_x_Line_Price_Att_Rec.pricing_attribute77;
2502: END IF;
2500: THEN
2501: x_pricing_attribute77 := l_x_Line_Price_Att_Rec.pricing_attribute77;
2502: END IF;
2503:
2504: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute78,
2505: l_Line_Price_Att_Rec.pricing_attribute78)
2506: THEN
2507: x_pricing_attribute78 := l_x_Line_Price_Att_Rec.pricing_attribute78;
2508: END IF;
2506: THEN
2507: x_pricing_attribute78 := l_x_Line_Price_Att_Rec.pricing_attribute78;
2508: END IF;
2509:
2510: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute79,
2511: l_Line_Price_Att_Rec.pricing_attribute79)
2512: THEN
2513: x_pricing_attribute79 := l_x_Line_Price_Att_Rec.pricing_attribute79;
2514: END IF;
2512: THEN
2513: x_pricing_attribute79 := l_x_Line_Price_Att_Rec.pricing_attribute79;
2514: END IF;
2515:
2516: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute8,
2517: l_Line_Price_Att_Rec.pricing_attribute8)
2518: THEN
2519: x_pricing_attribute8 := l_x_Line_Price_Att_Rec.pricing_attribute8;
2520: END IF;
2518: THEN
2519: x_pricing_attribute8 := l_x_Line_Price_Att_Rec.pricing_attribute8;
2520: END IF;
2521:
2522: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute80,
2523: l_Line_Price_Att_Rec.pricing_attribute80)
2524: THEN
2525: x_pricing_attribute80 := l_x_Line_Price_Att_Rec.pricing_attribute80;
2526: END IF;
2524: THEN
2525: x_pricing_attribute80 := l_x_Line_Price_Att_Rec.pricing_attribute80;
2526: END IF;
2527:
2528: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute81,
2529: l_Line_Price_Att_Rec.pricing_attribute81)
2530: THEN
2531: x_pricing_attribute81 := l_x_Line_Price_Att_Rec.pricing_attribute81;
2532: END IF;
2530: THEN
2531: x_pricing_attribute81 := l_x_Line_Price_Att_Rec.pricing_attribute81;
2532: END IF;
2533:
2534: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute82,
2535: l_Line_Price_Att_Rec.pricing_attribute82)
2536: THEN
2537: x_pricing_attribute82 := l_x_Line_Price_Att_Rec.pricing_attribute82;
2538: END IF;
2536: THEN
2537: x_pricing_attribute82 := l_x_Line_Price_Att_Rec.pricing_attribute82;
2538: END IF;
2539:
2540: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute83,
2541: l_Line_Price_Att_Rec.pricing_attribute83)
2542: THEN
2543: x_pricing_attribute83 := l_x_Line_Price_Att_Rec.pricing_attribute83;
2544: END IF;
2542: THEN
2543: x_pricing_attribute83 := l_x_Line_Price_Att_Rec.pricing_attribute83;
2544: END IF;
2545:
2546: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute84,
2547: l_Line_Price_Att_Rec.pricing_attribute84)
2548: THEN
2549: x_pricing_attribute84 := l_x_Line_Price_Att_Rec.pricing_attribute84;
2550: END IF;
2548: THEN
2549: x_pricing_attribute84 := l_x_Line_Price_Att_Rec.pricing_attribute84;
2550: END IF;
2551:
2552: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute85,
2553: l_Line_Price_Att_Rec.pricing_attribute85)
2554: THEN
2555: x_pricing_attribute85 := l_x_Line_Price_Att_Rec.pricing_attribute85;
2556: END IF;
2554: THEN
2555: x_pricing_attribute85 := l_x_Line_Price_Att_Rec.pricing_attribute85;
2556: END IF;
2557:
2558: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute86,
2559: l_Line_Price_Att_Rec.pricing_attribute86)
2560: THEN
2561: x_pricing_attribute86 := l_x_Line_Price_Att_Rec.pricing_attribute86;
2562: END IF;
2560: THEN
2561: x_pricing_attribute86 := l_x_Line_Price_Att_Rec.pricing_attribute86;
2562: END IF;
2563:
2564: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute87,
2565: l_Line_Price_Att_Rec.pricing_attribute87)
2566: THEN
2567: x_pricing_attribute87 := l_x_Line_Price_Att_Rec.pricing_attribute87;
2568: END IF;
2566: THEN
2567: x_pricing_attribute87 := l_x_Line_Price_Att_Rec.pricing_attribute87;
2568: END IF;
2569:
2570: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute88,
2571: l_Line_Price_Att_Rec.pricing_attribute88)
2572: THEN
2573: x_pricing_attribute88 := l_x_Line_Price_Att_Rec.pricing_attribute88;
2574: END IF;
2572: THEN
2573: x_pricing_attribute88 := l_x_Line_Price_Att_Rec.pricing_attribute88;
2574: END IF;
2575:
2576: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute89,
2577: l_Line_Price_Att_Rec.pricing_attribute89)
2578: THEN
2579: x_pricing_attribute89 := l_x_Line_Price_Att_Rec.pricing_attribute89;
2580: END IF;
2578: THEN
2579: x_pricing_attribute89 := l_x_Line_Price_Att_Rec.pricing_attribute89;
2580: END IF;
2581:
2582: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute9,
2583: l_Line_Price_Att_Rec.pricing_attribute9)
2584: THEN
2585: x_pricing_attribute9 := l_x_Line_Price_Att_Rec.pricing_attribute9;
2586: END IF;
2584: THEN
2585: x_pricing_attribute9 := l_x_Line_Price_Att_Rec.pricing_attribute9;
2586: END IF;
2587:
2588: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute90,
2589: l_Line_Price_Att_Rec.pricing_attribute90)
2590: THEN
2591: x_pricing_attribute90 := l_x_Line_Price_Att_Rec.pricing_attribute90;
2592: END IF;
2590: THEN
2591: x_pricing_attribute90 := l_x_Line_Price_Att_Rec.pricing_attribute90;
2592: END IF;
2593:
2594: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute91,
2595: l_Line_Price_Att_Rec.pricing_attribute91)
2596: THEN
2597: x_pricing_attribute91 := l_x_Line_Price_Att_Rec.pricing_attribute91;
2598: END IF;
2596: THEN
2597: x_pricing_attribute91 := l_x_Line_Price_Att_Rec.pricing_attribute91;
2598: END IF;
2599:
2600: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute92,
2601: l_Line_Price_Att_Rec.pricing_attribute92)
2602: THEN
2603: x_pricing_attribute92 := l_x_Line_Price_Att_Rec.pricing_attribute92;
2604: END IF;
2602: THEN
2603: x_pricing_attribute92 := l_x_Line_Price_Att_Rec.pricing_attribute92;
2604: END IF;
2605:
2606: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute93,
2607: l_Line_Price_Att_Rec.pricing_attribute93)
2608: THEN
2609: x_pricing_attribute93 := l_x_Line_Price_Att_Rec.pricing_attribute93;
2610: END IF;
2608: THEN
2609: x_pricing_attribute93 := l_x_Line_Price_Att_Rec.pricing_attribute93;
2610: END IF;
2611:
2612: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute94,
2613: l_Line_Price_Att_Rec.pricing_attribute94)
2614: THEN
2615: x_pricing_attribute94 := l_x_Line_Price_Att_Rec.pricing_attribute94;
2616: END IF;
2614: THEN
2615: x_pricing_attribute94 := l_x_Line_Price_Att_Rec.pricing_attribute94;
2616: END IF;
2617:
2618: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute95,
2619: l_Line_Price_Att_Rec.pricing_attribute95)
2620: THEN
2621: x_pricing_attribute95 := l_x_Line_Price_Att_Rec.pricing_attribute95;
2622: END IF;
2620: THEN
2621: x_pricing_attribute95 := l_x_Line_Price_Att_Rec.pricing_attribute95;
2622: END IF;
2623:
2624: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute96,
2625: l_Line_Price_Att_Rec.pricing_attribute96)
2626: THEN
2627: x_pricing_attribute96 := l_x_Line_Price_Att_Rec.pricing_attribute96;
2628: END IF;
2626: THEN
2627: x_pricing_attribute96 := l_x_Line_Price_Att_Rec.pricing_attribute96;
2628: END IF;
2629:
2630: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute97,
2631: l_Line_Price_Att_Rec.pricing_attribute97)
2632: THEN
2633: x_pricing_attribute97 := l_x_Line_Price_Att_Rec.pricing_attribute97;
2634: END IF;
2632: THEN
2633: x_pricing_attribute97 := l_x_Line_Price_Att_Rec.pricing_attribute97;
2634: END IF;
2635:
2636: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute98,
2637: l_Line_Price_Att_Rec.pricing_attribute98)
2638: THEN
2639: x_pricing_attribute98 := l_x_Line_Price_Att_Rec.pricing_attribute98;
2640: END IF;
2638: THEN
2639: x_pricing_attribute98 := l_x_Line_Price_Att_Rec.pricing_attribute98;
2640: END IF;
2641:
2642: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute99,
2643: l_Line_Price_Att_Rec.pricing_attribute99)
2644: THEN
2645: x_pricing_attribute99 := l_x_Line_Price_Att_Rec.pricing_attribute99;
2646: END IF;
2644: THEN
2645: x_pricing_attribute99 := l_x_Line_Price_Att_Rec.pricing_attribute99;
2646: END IF;
2647:
2648: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_context,
2649: l_Line_Price_Att_Rec.pricing_context)
2650: THEN
2651: x_pricing_context := l_x_Line_Price_Att_Rec.pricing_context;
2652: END IF;
2663:
2664:
2665:
2666: -- Re-set the UI flag to FALSE
2667: OE_GLOBALS.G_UI_FLAG := FALSE;
2668:
2669: -- Set return status.
2670:
2671: x_return_status := FND_API.G_RET_STS_SUCCESS;
2685: EXCEPTION
2686:
2687: WHEN FND_API.G_EXC_ERROR THEN
2688:
2689: OE_GLOBALS.G_UI_FLAG := FALSE;
2690:
2691: x_return_status := FND_API.G_RET_STS_ERROR;
2692:
2693: -- Get message count and data
2697: );
2698:
2699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2700:
2701: OE_GLOBALS.G_UI_FLAG := FALSE;
2702:
2703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2704:
2705: -- Get message count and data
2710: );
2711:
2712: WHEN OTHERS THEN
2713:
2714: OE_GLOBALS.G_UI_FLAG := FALSE;
2715:
2716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2717:
2718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2759: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2760: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2761: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2762: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2763: l_control_rec OE_GLOBALS.Control_Rec_Type;
2764: l_return_status VARCHAR2(1);
2765: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2766:
2767: /* OUT NOCOPY parameters for Process Order */
2794: --
2795: BEGIN
2796:
2797: -- Set the UI flag
2798: OE_GLOBALS.G_UI_FLAG := TRUE;
2799:
2800: -- Set control flags.
2801: l_control_rec.controlled_operation := TRUE;
2802: l_control_rec.validate_entity := TRUE;
2806: l_control_rec.clear_dependents := FALSE;
2807: l_control_rec.default_attributes := FALSE;
2808: l_control_rec.change_attributes := FALSE;
2809: l_control_rec.process := FALSE;
2810: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE_PRICE_ATT;
2811:
2812: -- Instruct API to retain its caches
2813: l_control_rec.clear_api_cache := FALSE;
2814: l_control_rec.clear_api_requests := FALSE;
2831: -- Set Operation.
2832: IF p_called_from_pattr = 'Y' THEN
2833: -- this is from Promotions window.
2834: IF FND_API.To_Boolean(l_x_Line_Price_Att_Rec.db_flag) THEN
2835: l_x_Line_Price_Att_Rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2836: ELSE
2837: l_x_Line_Price_Att_Rec.operation := OE_GLOBALS.G_OPR_CREATE;
2838: END IF;
2839: ELSE
2833: -- this is from Promotions window.
2834: IF FND_API.To_Boolean(l_x_Line_Price_Att_Rec.db_flag) THEN
2835: l_x_Line_Price_Att_Rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2836: ELSE
2837: l_x_Line_Price_Att_Rec.operation := OE_GLOBALS.G_OPR_CREATE;
2838: END IF;
2839: ELSE
2840: -- this is from Sales Order Line window.
2841: l_x_Line_Price_Att_Rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2837: l_x_Line_Price_Att_Rec.operation := OE_GLOBALS.G_OPR_CREATE;
2838: END IF;
2839: ELSE
2840: -- this is from Sales Order Line window.
2841: l_x_Line_Price_Att_Rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2842: END IF;
2843:
2844:
2845: l_x_Line_Price_Att_Tbl(1) := l_x_Line_Price_Att_Rec ;
2920: /* Clears the Line record cache */
2921: Clear_Order_Line_Attr;
2922:
2923: -- Re-set the UI flag to FALSE
2924: OE_GLOBALS.G_UI_FLAG := FALSE;
2925:
2926: -- Get message count and data
2927: OE_MSG_PUB.Count_And_Get
2928: ( p_count => x_msg_count
2932:
2933: EXCEPTION
2934: WHEN FND_API.G_EXC_ERROR THEN
2935:
2936: OE_GLOBALS.G_UI_FLAG := FALSE;
2937:
2938: x_return_status := FND_API.G_RET_STS_ERROR;
2939:
2940: -- Get message count and data
2948:
2949:
2950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2951:
2952: OE_GLOBALS.G_UI_FLAG := FALSE;
2953:
2954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2955:
2956: -- Get message count and data
2963: ROLLBACK TO SAVEPOINT validate_and_write;
2964:
2965: WHEN OTHERS THEN
2966:
2967: OE_GLOBALS.G_UI_FLAG := FALSE;
2968: NULL;
2969:
2970: END Validate_And_Write;
2971:
2984: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2985: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2986: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2987: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2988: l_control_rec OE_GLOBALS.Control_Rec_Type;
2989: l_return_status VARCHAR2(1);
2990: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2991:
2992: /* out nocopy parameters for Process Order */
3021: IF l_debug_level > 0 THEN
3022: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_PATTR.DELETE_ROW' , 1 ) ;
3023: END IF;
3024: -- Set the UI flag
3025: OE_GLOBALS.G_UI_FLAG := TRUE;
3026:
3027:
3028: -- Set control flags.
3029: l_control_rec.controlled_operation := TRUE;
3036: --bug 2702382
3037: l_control_rec.change_attributes := TRUE;
3038: l_control_rec.process := FALSE;
3039:
3040: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE_PRICE_ATT;
3041:
3042: -- Instruct API to retain its caches
3043: l_control_rec.clear_api_cache := FALSE;
3044: l_control_rec.clear_api_requests := FALSE;
3049: , p_order_price_attrib_id => p_order_price_attrib_id
3050: , x_Line_Price_Att_Rec => l_x_Line_Price_Att_Rec
3051: );
3052:
3053: l_x_Line_Price_Att_Rec.operation := OE_GLOBALS.G_OPR_DELETE;
3054:
3055: l_x_Line_Price_Att_Tbl(1) := l_x_Line_Price_Att_Rec;
3056:
3057:
3100: END IF;
3101:
3102:
3103: -- Re-set the UI flag to FALSE
3104: OE_GLOBALS.G_UI_FLAG := FALSE;
3105:
3106: x_return_status := FND_API.G_RET_STS_SUCCESS;
3107:
3108:
3115: EXCEPTION
3116:
3117: WHEN FND_API.G_EXC_ERROR THEN
3118:
3119: OE_GLOBALS.G_UI_FLAG := FALSE;
3120:
3121: x_return_status := FND_API.G_RET_STS_ERROR;
3122:
3123: -- Get message count and data
3127: );
3128:
3129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3130:
3131: OE_GLOBALS.G_UI_FLAG := FALSE;
3132:
3133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3134:
3135: -- Get message count and data
3139: );
3140:
3141: WHEN OTHERS THEN
3142:
3143: OE_GLOBALS.G_UI_FLAG := FALSE;
3144: NULL;
3145:
3146: END Delete_Row;
3147:
3166: BEGIN
3167:
3168: -- Load Line_Pricing_PAttr record
3169:
3170: l_x_Line_Price_Att_Rec.operation := OE_GLOBALS.G_OPR_LOCK;
3171: l_x_Line_Price_Att_Rec.lock_control := p_lock_control;
3172: l_x_Line_Price_Att_Rec.order_price_attrib_id := p_order_price_attrib_id;
3173:
3174:
3337: --
3338: begin
3339:
3340: SAVEPOINT Process_Price;
3341: OE_GLOBALS.G_UI_FLAG:= TRUE;
3342:
3343: Oe_Order_Pvt.Process_Requests_And_Notify
3344: ( p_process_requests => TRUE
3345: , p_notify => TRUE
3350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3352: RAISE FND_API.G_EXC_ERROR;
3353: END IF;
3354: OE_GLOBALS.G_UI_FLAG:= FALSE;
3355: exception when FND_API.G_EXC_ERROR or FND_API.G_EXC_UNEXPECTED_ERROR then
3356: ROLLBACK TO SAVEPOINT Process_Price;
3357: OE_GLOBALS.G_UI_FLAG:= FALSE;
3358: IF l_debug_level > 0 THEN
3353: END IF;
3354: OE_GLOBALS.G_UI_FLAG:= FALSE;
3355: exception when FND_API.G_EXC_ERROR or FND_API.G_EXC_UNEXPECTED_ERROR then
3356: ROLLBACK TO SAVEPOINT Process_Price;
3357: OE_GLOBALS.G_UI_FLAG:= FALSE;
3358: IF l_debug_level > 0 THEN
3359: oe_debug_pub.add( 'ERROR WHILE PRICING ' ) ;
3360: END IF;
3361: x_return_status := l_return_status;
3534: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
3535: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3536: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3537:
3538: l_control_rec OE_GLOBALS.Control_Rec_Type;
3539: l_return_status VARCHAR2(1);
3540: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3541: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3542: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3568: IF l_debug_level > 0 THEN
3569: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_PATTR.CHANGE_ATTRIBUTES' , 1 ) ;
3570: END IF;
3571: -- Set the UI flag
3572: OE_GLOBALS.G_UI_FLAG := TRUE;
3573:
3574: -- Set control flags.
3575: l_control_rec.controlled_operation := TRUE;
3576: l_control_rec.check_security := TRUE;
3587: l_control_rec.write_to_DB := TRUE;
3588: END IF;
3589:
3590: l_control_rec.process := FALSE;
3591: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE_PRICE_ATT;
3592:
3593:
3594: -- Instruct API to retain its caches
3595: l_control_rec.clear_api_cache := FALSE;
3735:
3736:
3737: -- Set Operation.
3738: IF FND_API.To_Boolean(l_x_Line_Price_Att_rec.db_flag) THEN
3739: l_x_Line_Price_Att_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
3740: ELSE
3741: l_x_Line_Price_Att_rec.operation := OE_GLOBALS.G_OPR_CREATE;
3742: END IF;
3743:
3737: -- Set Operation.
3738: IF FND_API.To_Boolean(l_x_Line_Price_Att_rec.db_flag) THEN
3739: l_x_Line_Price_Att_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
3740: ELSE
3741: l_x_Line_Price_Att_rec.operation := OE_GLOBALS.G_OPR_CREATE;
3742: END IF;
3743:
3744: IF l_debug_level > 0 THEN
3745: oe_debug_pub.add( ' PATTR OPERATION:'||L_X_LINE_PRICE_ATT_REC.OPERATION ) ;
3747: --If new pricing context is null and old is not null then we
3748: --know user is clearing the field hence operation delete
3749: If l_x_line_price_att_rec.pricing_context is Null and
3750: l_x_old_Line_Price_Att_rec.pricing_context is Not Null and
3751: l_x_Line_Price_Att_rec.operation <> OE_GLOBALS.G_OPR_CREATE
3752: Then
3753:
3754: l_x_Line_Price_Att_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3755: clear_order_line_attr;
3750: l_x_old_Line_Price_Att_rec.pricing_context is Not Null and
3751: l_x_Line_Price_Att_rec.operation <> OE_GLOBALS.G_OPR_CREATE
3752: Then
3753:
3754: l_x_Line_Price_Att_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3755: clear_order_line_attr;
3756:
3757: End If;
3758:
3872: -- Record structure
3873:
3874: -- No Get Values
3875:
3876: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.override_flag,
3877: l_Line_Price_Att_Rec.override_flag)
3878: THEN
3879: x_override_flag := l_x_Line_Price_Att_Rec.override_flag;
3880: END IF;
3879: x_override_flag := l_x_Line_Price_Att_Rec.override_flag;
3880: END IF;
3881:
3882:
3883: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute1,
3884: l_Line_Price_Att_Rec.attribute1)
3885: THEN
3886: x_attribute1 := l_x_Line_Price_Att_Rec.attribute1;
3887: END IF;
3886: x_attribute1 := l_x_Line_Price_Att_Rec.attribute1;
3887: END IF;
3888:
3889:
3890: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute2,
3891: l_Line_Price_Att_Rec.attribute2)
3892: THEN
3893: x_attribute3 := l_x_Line_Price_Att_Rec.attribute2;
3894: END IF;
3892: THEN
3893: x_attribute3 := l_x_Line_Price_Att_Rec.attribute2;
3894: END IF;
3895:
3896: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute3,
3897: l_Line_Price_Att_Rec.attribute3)
3898: THEN
3899: x_attribute3 := l_x_Line_Price_Att_Rec.attribute3;
3900: END IF;
3899: x_attribute3 := l_x_Line_Price_Att_Rec.attribute3;
3900: END IF;
3901:
3902:
3903: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute4,
3904: l_Line_Price_Att_Rec.attribute4)
3905: THEN
3906: x_attribute4 := l_x_Line_Price_Att_Rec.attribute4;
3907: END IF;
3905: THEN
3906: x_attribute4 := l_x_Line_Price_Att_Rec.attribute4;
3907: END IF;
3908:
3909: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute5,
3910: l_Line_Price_Att_Rec.attribute5)
3911: THEN
3912: x_attribute5 := l_x_Line_Price_Att_Rec.attribute5;
3913: END IF;
3910: l_Line_Price_Att_Rec.attribute5)
3911: THEN
3912: x_attribute5 := l_x_Line_Price_Att_Rec.attribute5;
3913: END IF;
3914: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute6,
3915: l_Line_Price_Att_Rec.attribute6)
3916: THEN
3917: x_attribute6 := l_x_Line_Price_Att_Rec.attribute6;
3918: END IF;
3915: l_Line_Price_Att_Rec.attribute6)
3916: THEN
3917: x_attribute6 := l_x_Line_Price_Att_Rec.attribute6;
3918: END IF;
3919: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute7,
3920: l_Line_Price_Att_Rec.attribute7)
3921: THEN
3922: x_attribute7 := l_x_Line_Price_Att_Rec.attribute7;
3923: END IF;
3921: THEN
3922: x_attribute7 := l_x_Line_Price_Att_Rec.attribute7;
3923: END IF;
3924:
3925: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute8,
3926: l_Line_Price_Att_Rec.attribute8)
3927: THEN
3928: x_attribute8 := l_x_Line_Price_Att_Rec.attribute8;
3929: END IF;
3929: END IF;
3930:
3931:
3932:
3933: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute9,
3934: l_Line_Price_Att_Rec.attribute9)
3935: THEN
3936: x_attribute9 := l_x_Line_Price_Att_Rec.attribute9;
3937: END IF;
3935: THEN
3936: x_attribute9 := l_x_Line_Price_Att_Rec.attribute9;
3937: END IF;
3938:
3939: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute10,
3940: l_Line_Price_Att_Rec.attribute10)
3941: THEN
3942: x_attribute10 := l_x_Line_Price_Att_Rec.attribute10;
3943: END IF;
3941: THEN
3942: x_attribute10 := l_x_Line_Price_Att_Rec.attribute10;
3943: END IF;
3944:
3945: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute11,
3946: l_Line_Price_Att_Rec.attribute11)
3947: THEN
3948: x_attribute11 := l_x_Line_Price_Att_Rec.attribute11;
3949: END IF;
3947: THEN
3948: x_attribute11 := l_x_Line_Price_Att_Rec.attribute11;
3949: END IF;
3950:
3951: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute12,
3952: l_Line_Price_Att_Rec.attribute12)
3953: THEN
3954: x_attribute12 := l_x_Line_Price_Att_Rec.attribute12;
3955: END IF;
3953: THEN
3954: x_attribute12 := l_x_Line_Price_Att_Rec.attribute12;
3955: END IF;
3956:
3957: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute13,
3958: l_Line_Price_Att_Rec.attribute13)
3959: THEN
3960: x_attribute13 := l_x_Line_Price_Att_Rec.attribute13;
3961: END IF;
3959: THEN
3960: x_attribute13 := l_x_Line_Price_Att_Rec.attribute13;
3961: END IF;
3962:
3963: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute14,
3964: l_Line_Price_Att_Rec.attribute14)
3965: THEN
3966: x_attribute14 := l_x_Line_Price_Att_Rec.attribute14;
3967: END IF;
3965: THEN
3966: x_attribute14 := l_x_Line_Price_Att_Rec.attribute14;
3967: END IF;
3968:
3969: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.attribute15,
3970: l_Line_Price_Att_Rec.attribute15)
3971: THEN
3972: x_attribute15 := l_x_Line_Price_Att_Rec.attribute15;
3973: END IF;
3971: THEN
3972: x_attribute15 := l_x_Line_Price_Att_Rec.attribute15;
3973: END IF;
3974:
3975: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.header_id,
3976: l_Line_Price_Att_Rec.header_id)
3977: THEN
3978: x_header_id := l_x_Line_Price_Att_Rec.header_id;
3979: END IF;
3977: THEN
3978: x_header_id := l_x_Line_Price_Att_Rec.header_id;
3979: END IF;
3980:
3981: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.line_id,
3982: l_Line_Price_Att_Rec.line_id)
3983: THEN
3984: x_line_id := l_x_Line_Price_Att_Rec.line_id;
3985: END IF;
3983: THEN
3984: x_line_id := l_x_Line_Price_Att_Rec.line_id;
3985: END IF;
3986:
3987: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.flex_title,
3988: l_Line_Price_Att_Rec.flex_title)
3989: THEN
3990: x_flex_title := l_x_Line_Price_Att_Rec.flex_title;
3991: END IF;
3989: THEN
3990: x_flex_title := l_x_Line_Price_Att_Rec.flex_title;
3991: END IF;
3992:
3993: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.order_price_attrib_id,
3994: l_Line_Price_Att_Rec.order_price_attrib_id)
3995: THEN
3996: x_order_price_attrib_id := l_x_Line_Price_Att_Rec.order_price_attrib_id;
3997: END IF;
3995: THEN
3996: x_order_price_attrib_id := l_x_Line_Price_Att_Rec.order_price_attrib_id;
3997: END IF;
3998:
3999: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute1,
4000: l_Line_Price_Att_Rec.pricing_attribute1)
4001: THEN
4002: x_pricing_attribute1 := l_x_Line_Price_Att_Rec.pricing_attribute1;
4003: END IF;
4001: THEN
4002: x_pricing_attribute1 := l_x_Line_Price_Att_Rec.pricing_attribute1;
4003: END IF;
4004:
4005: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute10,
4006: l_Line_Price_Att_Rec.pricing_attribute10)
4007: THEN
4008: x_pricing_attribute10 := l_x_Line_Price_Att_Rec.pricing_attribute10;
4009: END IF;
4007: THEN
4008: x_pricing_attribute10 := l_x_Line_Price_Att_Rec.pricing_attribute10;
4009: END IF;
4010:
4011: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute11,
4012: l_Line_Price_Att_Rec.pricing_attribute11)
4013: THEN
4014: x_pricing_attribute11 := l_x_Line_Price_Att_Rec.pricing_attribute11;
4015: END IF;
4013: THEN
4014: x_pricing_attribute11 := l_x_Line_Price_Att_Rec.pricing_attribute11;
4015: END IF;
4016:
4017: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute12,
4018: l_Line_Price_Att_Rec.pricing_attribute12)
4019: THEN
4020: x_pricing_attribute12 := l_x_Line_Price_Att_Rec.pricing_attribute12;
4021: END IF;
4019: THEN
4020: x_pricing_attribute12 := l_x_Line_Price_Att_Rec.pricing_attribute12;
4021: END IF;
4022:
4023: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute13,
4024: l_Line_Price_Att_Rec.pricing_attribute13)
4025: THEN
4026: x_pricing_attribute13 := l_x_Line_Price_Att_Rec.pricing_attribute13;
4027: END IF;
4025: THEN
4026: x_pricing_attribute13 := l_x_Line_Price_Att_Rec.pricing_attribute13;
4027: END IF;
4028:
4029: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute14,
4030: l_Line_Price_Att_Rec.pricing_attribute14)
4031: THEN
4032: x_pricing_attribute14 := l_x_Line_Price_Att_Rec.pricing_attribute14;
4033: END IF;
4031: THEN
4032: x_pricing_attribute14 := l_x_Line_Price_Att_Rec.pricing_attribute14;
4033: END IF;
4034:
4035: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute15,
4036: l_Line_Price_Att_Rec.pricing_attribute15)
4037: THEN
4038: x_pricing_attribute15 := l_x_Line_Price_Att_Rec.pricing_attribute15;
4039: END IF;
4037: THEN
4038: x_pricing_attribute15 := l_x_Line_Price_Att_Rec.pricing_attribute15;
4039: END IF;
4040:
4041: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute16,
4042: l_Line_Price_Att_Rec.pricing_attribute16)
4043: THEN
4044: x_pricing_attribute16 := l_x_Line_Price_Att_Rec.pricing_attribute16;
4045: END IF;
4043: THEN
4044: x_pricing_attribute16 := l_x_Line_Price_Att_Rec.pricing_attribute16;
4045: END IF;
4046:
4047: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute17,
4048: l_Line_Price_Att_Rec.pricing_attribute17)
4049: THEN
4050: x_pricing_attribute17 := l_x_Line_Price_Att_Rec.pricing_attribute17;
4051: END IF;
4049: THEN
4050: x_pricing_attribute17 := l_x_Line_Price_Att_Rec.pricing_attribute17;
4051: END IF;
4052:
4053: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute18,
4054: l_Line_Price_Att_Rec.pricing_attribute18)
4055: THEN
4056: x_pricing_attribute18 := l_x_Line_Price_Att_Rec.pricing_attribute18;
4057: END IF;
4055: THEN
4056: x_pricing_attribute18 := l_x_Line_Price_Att_Rec.pricing_attribute18;
4057: END IF;
4058:
4059: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute19,
4060: l_Line_Price_Att_Rec.pricing_attribute19)
4061: THEN
4062: x_pricing_attribute19 := l_x_Line_Price_Att_Rec.pricing_attribute19;
4063: END IF;
4061: THEN
4062: x_pricing_attribute19 := l_x_Line_Price_Att_Rec.pricing_attribute19;
4063: END IF;
4064:
4065: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute2,
4066: l_Line_Price_Att_Rec.pricing_attribute2)
4067: THEN
4068: x_pricing_attribute2 := l_x_Line_Price_Att_Rec.pricing_attribute2;
4069: END IF;
4067: THEN
4068: x_pricing_attribute2 := l_x_Line_Price_Att_Rec.pricing_attribute2;
4069: END IF;
4070:
4071: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute20,
4072: l_Line_Price_Att_Rec.pricing_attribute20)
4073: THEN
4074: x_pricing_attribute20 := l_x_Line_Price_Att_Rec.pricing_attribute20;
4075: END IF;
4073: THEN
4074: x_pricing_attribute20 := l_x_Line_Price_Att_Rec.pricing_attribute20;
4075: END IF;
4076:
4077: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute21,
4078: l_Line_Price_Att_Rec.pricing_attribute21)
4079: THEN
4080: x_pricing_attribute21 := l_x_Line_Price_Att_Rec.pricing_attribute21;
4081: END IF;
4079: THEN
4080: x_pricing_attribute21 := l_x_Line_Price_Att_Rec.pricing_attribute21;
4081: END IF;
4082:
4083: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute22,
4084: l_Line_Price_Att_Rec.pricing_attribute22)
4085: THEN
4086: x_pricing_attribute22 := l_x_Line_Price_Att_Rec.pricing_attribute22;
4087: END IF;
4085: THEN
4086: x_pricing_attribute22 := l_x_Line_Price_Att_Rec.pricing_attribute22;
4087: END IF;
4088:
4089: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute23,
4090: l_Line_Price_Att_Rec.pricing_attribute23)
4091: THEN
4092: x_pricing_attribute23 := l_x_Line_Price_Att_Rec.pricing_attribute23;
4093: END IF;
4091: THEN
4092: x_pricing_attribute23 := l_x_Line_Price_Att_Rec.pricing_attribute23;
4093: END IF;
4094:
4095: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute24,
4096: l_Line_Price_Att_Rec.pricing_attribute24)
4097: THEN
4098: x_pricing_attribute24 := l_x_Line_Price_Att_Rec.pricing_attribute24;
4099: END IF;
4097: THEN
4098: x_pricing_attribute24 := l_x_Line_Price_Att_Rec.pricing_attribute24;
4099: END IF;
4100:
4101: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute25,
4102: l_Line_Price_Att_Rec.pricing_attribute25)
4103: THEN
4104: x_pricing_attribute25 := l_x_Line_Price_Att_Rec.pricing_attribute25;
4105: END IF;
4103: THEN
4104: x_pricing_attribute25 := l_x_Line_Price_Att_Rec.pricing_attribute25;
4105: END IF;
4106:
4107: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute26,
4108: l_Line_Price_Att_Rec.pricing_attribute26)
4109: THEN
4110: x_pricing_attribute26 := l_x_Line_Price_Att_Rec.pricing_attribute26;
4111: END IF;
4109: THEN
4110: x_pricing_attribute26 := l_x_Line_Price_Att_Rec.pricing_attribute26;
4111: END IF;
4112:
4113: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute27,
4114: l_Line_Price_Att_Rec.pricing_attribute27)
4115: THEN
4116: x_pricing_attribute27 := l_x_Line_Price_Att_Rec.pricing_attribute27;
4117: END IF;
4115: THEN
4116: x_pricing_attribute27 := l_x_Line_Price_Att_Rec.pricing_attribute27;
4117: END IF;
4118:
4119: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute28,
4120: l_Line_Price_Att_Rec.pricing_attribute28)
4121: THEN
4122: x_pricing_attribute28 := l_x_Line_Price_Att_Rec.pricing_attribute28;
4123: END IF;
4121: THEN
4122: x_pricing_attribute28 := l_x_Line_Price_Att_Rec.pricing_attribute28;
4123: END IF;
4124:
4125: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute29,
4126: l_Line_Price_Att_Rec.pricing_attribute29)
4127: THEN
4128: x_pricing_attribute29 := l_x_Line_Price_Att_Rec.pricing_attribute29;
4129: END IF;
4127: THEN
4128: x_pricing_attribute29 := l_x_Line_Price_Att_Rec.pricing_attribute29;
4129: END IF;
4130:
4131: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute3,
4132: l_Line_Price_Att_Rec.pricing_attribute3)
4133: THEN
4134: x_pricing_attribute3 := l_x_Line_Price_Att_Rec.pricing_attribute3;
4135: END IF;
4133: THEN
4134: x_pricing_attribute3 := l_x_Line_Price_Att_Rec.pricing_attribute3;
4135: END IF;
4136:
4137: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute30,
4138: l_Line_Price_Att_Rec.pricing_attribute30)
4139: THEN
4140: x_pricing_attribute30 := l_x_Line_Price_Att_Rec.pricing_attribute30;
4141: END IF;
4140: x_pricing_attribute30 := l_x_Line_Price_Att_Rec.pricing_attribute30;
4141: END IF;
4142:
4143:
4144: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute4,
4145: l_Line_Price_Att_Rec.pricing_attribute4)
4146: THEN
4147: x_pricing_attribute4 := l_x_Line_Price_Att_Rec.pricing_attribute4;
4148: END IF;
4147: x_pricing_attribute4 := l_x_Line_Price_Att_Rec.pricing_attribute4;
4148: END IF;
4149:
4150:
4151: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute5,
4152: l_Line_Price_Att_Rec.pricing_attribute5)
4153: THEN
4154: x_pricing_attribute5 := l_x_Line_Price_Att_Rec.pricing_attribute5;
4155: END IF;
4155: END IF;
4156:
4157:
4158:
4159: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute6,
4160: l_Line_Price_Att_Rec.pricing_attribute6)
4161: THEN
4162: x_pricing_attribute6 := l_x_Line_Price_Att_Rec.pricing_attribute6;
4163: END IF;
4162: x_pricing_attribute6 := l_x_Line_Price_Att_Rec.pricing_attribute6;
4163: END IF;
4164:
4165:
4166: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute7,
4167: l_Line_Price_Att_Rec.pricing_attribute7)
4168: THEN
4169: x_pricing_attribute7 := l_x_Line_Price_Att_Rec.pricing_attribute7;
4170: END IF;
4169: x_pricing_attribute7 := l_x_Line_Price_Att_Rec.pricing_attribute7;
4170: END IF;
4171:
4172:
4173: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute8,
4174: l_Line_Price_Att_Rec.pricing_attribute8)
4175: THEN
4176: x_pricing_attribute8 := l_x_Line_Price_Att_Rec.pricing_attribute8;
4177: END IF;
4176: x_pricing_attribute8 := l_x_Line_Price_Att_Rec.pricing_attribute8;
4177: END IF;
4178:
4179:
4180: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_attribute9,
4181: l_Line_Price_Att_Rec.pricing_attribute9)
4182: THEN
4183: x_pricing_attribute9 := l_x_Line_Price_Att_Rec.pricing_attribute9;
4184: END IF;
4182: THEN
4183: x_pricing_attribute9 := l_x_Line_Price_Att_Rec.pricing_attribute9;
4184: END IF;
4185:
4186: IF NOT OE_GLOBALS.Equal(l_x_Line_Price_Att_Rec.pricing_context,
4187: l_Line_Price_Att_Rec.pricing_context)
4188: THEN
4189: x_pricing_context := l_x_Line_Price_Att_Rec.pricing_context;
4190: END IF;
4199: ) ;
4200:
4201:
4202: -- Re-set the UI flag to FALSE
4203: OE_GLOBALS.G_UI_FLAG := FALSE;
4204:
4205: -- Set return status.
4206:
4207: x_return_status := FND_API.G_RET_STS_SUCCESS;
4221: EXCEPTION
4222:
4223: WHEN FND_API.G_EXC_ERROR THEN
4224:
4225: OE_GLOBALS.G_UI_FLAG := FALSE;
4226:
4227: x_return_status := FND_API.G_RET_STS_ERROR;
4228:
4229: -- Get message count and data
4233: );
4234:
4235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4236:
4237: OE_GLOBALS.G_UI_FLAG := FALSE;
4238:
4239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4240:
4241: -- Get message count and data
4246: );
4247:
4248: WHEN OTHERS THEN
4249:
4250: OE_GLOBALS.G_UI_FLAG := FALSE;
4251:
4252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4253:
4254: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4378: ) IS
4379: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4380: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4381:
4382: l_control_rec OE_GLOBALS.Control_Rec_Type;
4383: l_return_status VARCHAR2(1);
4384: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
4385: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
4386: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4413: IF l_debug_level > 0 THEN
4414: oe_debug_pub.add( 'ENERING OE_OE_FORM_LINE_PATTR.DEFAULT_ATTRIBUTE.' , 1 ) ;
4415: END IF;
4416: -- Set the UI flag
4417: OE_GLOBALS.G_UI_FLAG := TRUE;
4418:
4419: -- Set Control Flags
4420: l_control_rec.controlled_operation := TRUE;
4421: l_control_rec.check_security := TRUE;
4491: l_x_Line_Price_Att_Rec.override_flag := NULL;
4492:
4493:
4494: -- Set Operation to Create
4495: l_x_Line_Price_Att_Rec.operation := OE_GLOBALS.G_OPR_CREATE;
4496:
4497: l_x_Line_Price_Att_Tbl(1) := l_x_Line_Price_Att_Rec;
4498: IF l_debug_level > 0 THEN
4499: oe_debug_pub.add( 'BEFORE CALLING OE_ORDER_ADJ_PVT.LINE_PRICE_ATTS' ) ;
4583: p_Line_Price_Att_rec => l_x_Line_Price_Att_Rec
4584: );
4585:
4586: -- Re-set the UI flag to FALSE
4587: OE_GLOBALS.G_UI_FLAG := FALSE;
4588:
4589: -- Set return status.
4590: x_return_status := FND_API.G_RET_STS_SUCCESS;
4591:
4601: END IF;
4602: EXCEPTION
4603: WHEN FND_API.G_EXC_ERROR THEN
4604:
4605: OE_GLOBALS.G_UI_FLAG := FALSE;
4606: x_return_status := FND_API.G_RET_STS_ERROR;
4607:
4608: -- Get message count and data
4609:
4613: );
4614:
4615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4616:
4617: OE_GLOBALS.G_UI_FLAG := FALSE;
4618:
4619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4620:
4621: -- Get message count and data
4626: );
4627:
4628: WHEN OTHERS THEN
4629:
4630: OE_GLOBALS.G_UI_FLAG := FALSE;
4631:
4632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4633:
4634: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)