eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_PRICE_LIST_LINE_UTIL dependencies on OE_PRICE_LIST_PUB

Line 12: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
13: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
14: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
15: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
16: )

Line 13: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
13: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
14: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
15: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
16: )
17: IS

Line 14: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
13: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
14: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
15: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;

Line 15: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
13: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
14: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
15: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

Line 552: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

548:
549: -- Procedure Apply_Attribute_Changes
550:
551: PROCEDURE Apply_Attribute_Changes
552: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
553: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
554: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
555: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
556: )

Line 553: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=

549: -- Procedure Apply_Attribute_Changes
550:
551: PROCEDURE Apply_Attribute_Changes
552: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
553: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
554: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
555: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
556: )
557: IS

Line 554: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC

550:
551: PROCEDURE Apply_Attribute_Changes
552: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
553: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
554: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
555: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
556: )
557: IS
558: l_primary_exists BOOLEAN;

Line 555: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type

551: PROCEDURE Apply_Attribute_Changes
552: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
553: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
554: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
555: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
556: )
557: IS
558: l_primary_exists BOOLEAN;
559: BEGIN

Line 1047: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

1043:
1044: -- Function Complete_Record
1045:
1046: FUNCTION Complete_Record
1047: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
1048: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
1049: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type
1050: IS
1051: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;

Line 1048: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

1044: -- Function Complete_Record
1045:
1046: FUNCTION Complete_Record
1047: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
1048: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
1049: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type
1050: IS
1051: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1052: BEGIN

Line 1049: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type

1045:
1046: FUNCTION Complete_Record
1047: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
1048: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
1049: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type
1050: IS
1051: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1052: BEGIN
1053:

Line 1051: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;

1047: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
1048: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
1049: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type
1050: IS
1051: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1052: BEGIN
1053:
1054: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1055: l_PRICE_LIST_LINE_rec.attribute1 := p_old_PRICE_LIST_LINE_rec.attribute1;

Line 1289: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

1285:
1286: -- Function Convert_Miss_To_Null
1287:
1288: FUNCTION Convert_Miss_To_Null
1289: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
1290: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type
1291: IS
1292: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1293: BEGIN

Line 1290: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type

1286: -- Function Convert_Miss_To_Null
1287:
1288: FUNCTION Convert_Miss_To_Null
1289: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
1290: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type
1291: IS
1292: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1293: BEGIN
1294:

Line 1292: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;

1288: FUNCTION Convert_Miss_To_Null
1289: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
1290: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type
1291: IS
1292: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1293: BEGIN
1294:
1295: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1296: l_PRICE_LIST_LINE_rec.attribute1 := NULL;

Line 1530: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

1526:
1527: -- Procedure Update_Row
1528:
1529: PROCEDURE Update_Row
1530: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
1531: )
1532: IS
1533: l_list_price number := NULL;
1534: l_percent_price number := NULL;

Line 1616: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

1612:
1613: -- Procedure Insert_Row
1614:
1615: PROCEDURE Insert_Row
1616: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
1617: )
1618: IS
1619: l_product_context varchar2(30);
1620: l_customer_item_context varchar2(30);

Line 1623: l_pricing_attr_rec OE_PRICE_LIST_PUB.Pricing_Attr_Rec_Type;

1619: l_product_context varchar2(30);
1620: l_customer_item_context varchar2(30);
1621: l_product_attr varchar2(30);
1622: l_customer_item_attr varchar2(30);
1623: l_pricing_attr_rec OE_PRICE_LIST_PUB.Pricing_Attr_Rec_Type;
1624: l_pricing_attr_tbl OE_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
1625: l_attribute_grouping_no number;
1626: l_pricing_attribute_id number;
1627: I number := 1;

Line 1624: l_pricing_attr_tbl OE_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

1620: l_customer_item_context varchar2(30);
1621: l_product_attr varchar2(30);
1622: l_customer_item_attr varchar2(30);
1623: l_pricing_attr_rec OE_PRICE_LIST_PUB.Pricing_Attr_Rec_Type;
1624: l_pricing_attr_tbl OE_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
1625: l_attribute_grouping_no number;
1626: l_pricing_attribute_id number;
1627: I number := 1;
1628: J number := 1;

Line 1914: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type

1910:
1911: FUNCTION Query_Row
1912: ( p_price_list_line_id IN NUMBER
1913: , p_price_list_id IN NUMBER
1914: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type
1915: IS
1916: BEGIN
1917:
1918: RETURN Query_Rows

Line 1934: ) RETURN OE_Price_List_PUB.Price_List_Line_Tbl_Type

1930: ( p_price_list_line_id IN NUMBER :=
1931: FND_API.G_MISS_NUM
1932: , p_price_list_id IN NUMBER :=
1933: FND_API.G_MISS_NUM
1934: ) RETURN OE_Price_List_PUB.Price_List_Line_Tbl_Type
1935: IS
1936: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1937: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1938: l_method_code VARCHAR2(30) := NULL;

Line 1936: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

1932: , p_price_list_id IN NUMBER :=
1933: FND_API.G_MISS_NUM
1934: ) RETURN OE_Price_List_PUB.Price_List_Line_Tbl_Type
1935: IS
1936: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1937: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1938: l_method_code VARCHAR2(30) := NULL;
1939:
1940: CURSOR l_PRICE_LIST_LINE_csr IS

Line 1937: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

1933: FND_API.G_MISS_NUM
1934: ) RETURN OE_Price_List_PUB.Price_List_Line_Tbl_Type
1935: IS
1936: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1937: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1938: l_method_code VARCHAR2(30) := NULL;
1939:
1940: CURSOR l_PRICE_LIST_LINE_csr IS
1941: SELECT ATTRIBUTE1

Line 2136: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

2132:
2133:
2134: PROCEDURE Lock_Row
2135: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2136: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
2137: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
2138: ) is
2139: l_PRICE_LIST_LINE_rec oe_price_list_pub.price_list_line_rec_type;
2140: l_percent_price number;

Line 2137: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type

2133:
2134: PROCEDURE Lock_Row
2135: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2136: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
2137: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
2138: ) is
2139: l_PRICE_LIST_LINE_rec oe_price_list_pub.price_list_line_rec_type;
2140: l_percent_price number;
2141: l_list_price number;

Line 2139: l_PRICE_LIST_LINE_rec oe_price_list_pub.price_list_line_rec_type;

2135: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2136: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
2137: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
2138: ) is
2139: l_PRICE_LIST_LINE_rec oe_price_list_pub.price_list_line_rec_type;
2140: l_percent_price number;
2141: l_list_price number;
2142: l_automatic_flag varchar2(30);
2143: l_list_line_type_code varchar2(30);

Line 2289: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

2285:
2286: -- Function Get_Values
2287:
2288: FUNCTION Get_Values
2289: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
2290: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
2291: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
2292: ) RETURN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type
2293: IS

Line 2290: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=

2286: -- Function Get_Values
2287:
2288: FUNCTION Get_Values
2289: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
2290: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
2291: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
2292: ) RETURN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type
2293: IS
2294: l_PRICE_LIST_LINE_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;

Line 2291: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC

2287:
2288: FUNCTION Get_Values
2289: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
2290: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
2291: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
2292: ) RETURN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type
2293: IS
2294: l_PRICE_LIST_LINE_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
2295: BEGIN

Line 2292: ) RETURN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type

2288: FUNCTION Get_Values
2289: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
2290: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
2291: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
2292: ) RETURN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type
2293: IS
2294: l_PRICE_LIST_LINE_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
2295: BEGIN
2296:

Line 2294: l_PRICE_LIST_LINE_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;

2290: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
2291: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
2292: ) RETURN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type
2293: IS
2294: l_PRICE_LIST_LINE_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
2295: BEGIN
2296:
2297: /*
2298: IF p_PRICE_LIST_LINE_rec.customer_item_id IS NOT NULL AND

Line 2398: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

2394:
2395: -- Function Get_Ids
2396:
2397: FUNCTION Get_Ids
2398: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
2399: , p_PRICE_LIST_LINE_val_rec IN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type
2400: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type
2401: IS
2402: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 2399: , p_PRICE_LIST_LINE_val_rec IN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type

2395: -- Function Get_Ids
2396:
2397: FUNCTION Get_Ids
2398: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
2399: , p_PRICE_LIST_LINE_val_rec IN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type
2400: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type
2401: IS
2402: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
2403: BEGIN

Line 2400: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type

2396:
2397: FUNCTION Get_Ids
2398: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
2399: , p_PRICE_LIST_LINE_val_rec IN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type
2400: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type
2401: IS
2402: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
2403: BEGIN
2404:

Line 2402: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

2398: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
2399: , p_PRICE_LIST_LINE_val_rec IN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type
2400: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type
2401: IS
2402: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
2403: BEGIN
2404:
2405: -- initialize return_status.
2406:

Line 2746: PROCEDURE maintain_pricing_attributes(p_PRICE_LIST_LINE_rec in OE_PRICE_LIST_PUB.Price_List_Line_Rec_Type,

2742:
2743:
2744: end lock_pricing_attributes;
2745:
2746: PROCEDURE maintain_pricing_attributes(p_PRICE_LIST_LINE_rec in OE_PRICE_LIST_PUB.Price_List_Line_Rec_Type,
2747: operation in varchar2,
2748: x_return_status out NOCOPY /* file.sql.39 change */ varchar2)
2749: is
2750: l_pricing_attr_tbl OE_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

Line 2750: l_pricing_attr_tbl OE_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

2746: PROCEDURE maintain_pricing_attributes(p_PRICE_LIST_LINE_rec in OE_PRICE_LIST_PUB.Price_List_Line_Rec_Type,
2747: operation in varchar2,
2748: x_return_status out NOCOPY /* file.sql.39 change */ varchar2)
2749: is
2750: l_pricing_attr_tbl OE_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
2751: l_pricing_attr_rec OE_PRICE_LIST_PUB.Pricing_Attr_Rec_Type;
2752: l_count number := 0;
2753: l_product_context varchar2(30);
2754: l_customer_item_context varchar2(30);

Line 2751: l_pricing_attr_rec OE_PRICE_LIST_PUB.Pricing_Attr_Rec_Type;

2747: operation in varchar2,
2748: x_return_status out NOCOPY /* file.sql.39 change */ varchar2)
2749: is
2750: l_pricing_attr_tbl OE_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
2751: l_pricing_attr_rec OE_PRICE_LIST_PUB.Pricing_Attr_Rec_Type;
2752: l_count number := 0;
2753: l_product_context varchar2(30);
2754: l_customer_item_context varchar2(30);
2755: l_pb_dollars_attribute_context varchar2(30);

Line 3335: ) RETURN OE_Price_List_PUB.Pricing_Attr_Tbl_Type

3331: ( p_pricing_attribute_id IN NUMBER :=
3332: FND_API.G_MISS_NUM
3333: , p_list_line_id IN NUMBER :=
3334: FND_API.G_MISS_NUM
3335: ) RETURN OE_Price_List_PUB.Pricing_Attr_Tbl_Type
3336: IS
3337: l_PRICING_ATTR_rec OE_PRICE_LIST_PUB.Pricing_Attr_Rec_Type;
3338: l_PRICING_ATTR_tbl OE_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
3339:

Line 3337: l_PRICING_ATTR_rec OE_PRICE_LIST_PUB.Pricing_Attr_Rec_Type;

3333: , p_list_line_id IN NUMBER :=
3334: FND_API.G_MISS_NUM
3335: ) RETURN OE_Price_List_PUB.Pricing_Attr_Tbl_Type
3336: IS
3337: l_PRICING_ATTR_rec OE_PRICE_LIST_PUB.Pricing_Attr_Rec_Type;
3338: l_PRICING_ATTR_tbl OE_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
3339:
3340: CURSOR l_PRICING_ATTR_csr IS
3341: SELECT ACCUMULATE_FLAG

Line 3338: l_PRICING_ATTR_tbl OE_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

3334: FND_API.G_MISS_NUM
3335: ) RETURN OE_Price_List_PUB.Pricing_Attr_Tbl_Type
3336: IS
3337: l_PRICING_ATTR_rec OE_PRICE_LIST_PUB.Pricing_Attr_Rec_Type;
3338: l_PRICING_ATTR_tbl OE_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
3339:
3340: CURSOR l_PRICING_ATTR_csr IS
3341: SELECT ACCUMULATE_FLAG
3342: , ATTRIBUTE1