DBA Data[Home] [Help]

APPS.OE_PRICING_CONT_PVT dependencies on OE_PRICE_LIST_PUB

Line 765: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type

761:
762: PROCEDURE Price_Lheader
763: ( p_validation_level IN NUMBER
764: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
765: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type
766: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type
767: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
768: , x_old_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
769: )

Line 766: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type

762: PROCEDURE Price_Lheader
763: ( p_validation_level IN NUMBER
764: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
765: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type
766: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type
767: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
768: , x_old_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
769: )
770: IS

Line 767: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

763: ( p_validation_level IN NUMBER
764: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
765: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type
766: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type
767: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
768: , x_old_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
769: )
770: IS
771: l_return_status VARCHAR2(1);

Line 768: , x_old_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

764: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
765: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type
766: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type
767: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
768: , x_old_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
769: )
770: IS
771: l_return_status VARCHAR2(1);
772: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 773: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_Price_LHeader_rec;

769: )
770: IS
771: l_return_status VARCHAR2(1);
772: l_control_rec OE_GLOBALS.Control_Rec_Type;
773: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_Price_LHeader_rec;
774: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_Price_LHeader_rec;
775:
776: l_p_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
777: BEGIN

Line 774: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_Price_LHeader_rec;

770: IS
771: l_return_status VARCHAR2(1);
772: l_control_rec OE_GLOBALS.Control_Rec_Type;
773: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_Price_LHeader_rec;
774: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_Price_LHeader_rec;
775:
776: l_p_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
777: BEGIN
778:

Line 776: l_p_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]

772: l_control_rec OE_GLOBALS.Control_Rec_Type;
773: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_Price_LHeader_rec;
774: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_Price_LHeader_rec;
775:
776: l_p_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
777: BEGIN
778:
779:
780: oe_debug_pub.add('------------------------------------------------');

Line 1026: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type

1022:
1023: PROCEDURE Price_Llines
1024: ( p_validation_level IN NUMBER
1025: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
1026: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
1027: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
1028: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1029: , x_old_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1030: )

Line 1027: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type

1023: PROCEDURE Price_Llines
1024: ( p_validation_level IN NUMBER
1025: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
1026: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
1027: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
1028: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1029: , x_old_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1030: )
1031: IS

Line 1028: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

1024: ( p_validation_level IN NUMBER
1025: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
1026: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
1027: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
1028: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1029: , x_old_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1030: )
1031: IS
1032: l_return_status VARCHAR2(1);

Line 1029: , x_old_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

1025: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
1026: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
1027: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
1028: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1029: , x_old_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1030: )
1031: IS
1032: l_return_status VARCHAR2(1);
1033: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 1034: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

1030: )
1031: IS
1032: l_return_status VARCHAR2(1);
1033: l_control_rec OE_GLOBALS.Control_Rec_Type;
1034: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1035: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1036: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1037: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1038:

Line 1035: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

1031: IS
1032: l_return_status VARCHAR2(1);
1033: l_control_rec OE_GLOBALS.Control_Rec_Type;
1034: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1035: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1036: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1037: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1038:
1039: l_p_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type; --[prarasto]

Line 1036: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

1032: l_return_status VARCHAR2(1);
1033: l_control_rec OE_GLOBALS.Control_Rec_Type;
1034: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1035: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1036: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1037: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1038:
1039: l_p_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type; --[prarasto]
1040:

Line 1037: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

1033: l_control_rec OE_GLOBALS.Control_Rec_Type;
1034: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1035: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1036: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1037: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1038:
1039: l_p_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type; --[prarasto]
1040:
1041: BEGIN

Line 1039: l_p_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type; --[prarasto]

1035: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1036: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1037: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1038:
1039: l_p_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type; --[prarasto]
1040:
1041: BEGIN
1042:
1043: oe_debug_pub.add('------------------------------------------------');

Line 1063: l_old_Price_LLine_rec := OE_Price_List_PUB.G_MISS_PRICE_List_Line_REC;

1059:
1060: IF l_old_Price_LLine_tbl.EXISTS(I) THEN
1061: l_old_Price_LLine_rec := l_old_Price_LLine_tbl(I);
1062: ELSE
1063: l_old_Price_LLine_rec := OE_Price_List_PUB.G_MISS_PRICE_List_Line_REC;
1064: END IF;
1065:
1066: -- Load API control record
1067:

Line 1703: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

1699: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
1700: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
1701: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
1702: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
1703: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1704: OE_Price_List_PUB.G_MISS_PRICE_List_REC
1705: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1706: OE_Price_List_PUB.G_MISS_PRICE_List_REC
1707: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=

Line 1704: OE_Price_List_PUB.G_MISS_PRICE_List_REC

1700: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
1701: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
1702: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
1703: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1704: OE_Price_List_PUB.G_MISS_PRICE_List_REC
1705: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1706: OE_Price_List_PUB.G_MISS_PRICE_List_REC
1707: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
1708: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC

Line 1705: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

1701: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
1702: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
1703: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1704: OE_Price_List_PUB.G_MISS_PRICE_List_REC
1705: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1706: OE_Price_List_PUB.G_MISS_PRICE_List_REC
1707: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
1708: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
1709: , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=

Line 1706: OE_Price_List_PUB.G_MISS_PRICE_List_REC

1702: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
1703: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1704: OE_Price_List_PUB.G_MISS_PRICE_List_REC
1705: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
1706: OE_Price_List_PUB.G_MISS_PRICE_List_REC
1707: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
1708: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
1709: , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
1710: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC

Line 1711: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

1707: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
1708: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
1709: , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
1710: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
1711: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
1712: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
1713: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
1714: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
1715: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=

Line 1712: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL

1708: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
1709: , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
1710: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
1711: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
1712: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
1713: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
1714: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
1715: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
1716: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL

Line 1713: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

1709: , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
1710: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
1711: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
1712: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
1713: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
1714: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
1715: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
1716: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
1717: , p_old_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=

Line 1714: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL

1710: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
1711: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
1712: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
1713: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
1714: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
1715: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
1716: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
1717: , p_old_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
1718: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL

Line 1729: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

1725: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
1726: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
1727: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
1728: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
1729: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
1730: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
1731: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1732: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
1733: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type

Line 1731: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

1727: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
1728: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
1729: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
1730: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
1731: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1732: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
1733: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
1734: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1735: )

Line 1745: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_Price_LHeader_rec;

1741: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_Contract_rec;
1742: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_old_Contract_rec;
1743: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
1744: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_old_Agreement_rec;
1745: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_Price_LHeader_rec;
1746: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_Price_LHeader_rec;
1747: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_Discount_Header_rec;
1748: l_old_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_old_Discount_Header_rec;
1749: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1746: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_Price_LHeader_rec;

1742: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type := p_old_Contract_rec;
1743: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
1744: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_old_Agreement_rec;
1745: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_Price_LHeader_rec;
1746: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_Price_LHeader_rec;
1747: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_Discount_Header_rec;
1748: l_old_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_old_Discount_Header_rec;
1749: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1750: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1749: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

1745: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_Price_LHeader_rec;
1746: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_Price_LHeader_rec;
1747: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_Discount_Header_rec;
1748: l_old_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_old_Discount_Header_rec;
1749: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1750: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1751: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1752: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1753: l_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

Line 1750: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

1746: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_Price_LHeader_rec;
1747: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_Discount_Header_rec;
1748: l_old_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_old_Discount_Header_rec;
1749: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1750: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1751: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1752: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1753: l_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1754: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 1751: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

1747: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_Discount_Header_rec;
1748: l_old_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_old_Discount_Header_rec;
1749: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1750: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1751: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1752: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1753: l_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1754: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1755: l_old_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

Line 1752: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

1748: l_old_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type := p_old_Discount_Header_rec;
1749: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1750: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1751: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1752: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1753: l_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1754: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1755: l_old_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1756: l_old_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 1788: l_p_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]

1784: NO_UPDATE_PRIVILEGE EXCEPTION;
1785:
1786: l_p_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]
1787: l_p_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]
1788: l_p_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
1789: l_p_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
1790: l_p_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
1791: l_p_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
1792: l_p_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type; --[prarasto]

Line 1789: l_p_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]

1785:
1786: l_p_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]
1787: l_p_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]
1788: l_p_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
1789: l_p_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
1790: l_p_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
1791: l_p_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
1792: l_p_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type; --[prarasto]
1793: l_p_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type; --[prarasto]

Line 1790: l_p_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]

1786: l_p_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]
1787: l_p_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]
1788: l_p_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
1789: l_p_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
1790: l_p_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
1791: l_p_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
1792: l_p_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type; --[prarasto]
1793: l_p_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type; --[prarasto]
1794:

Line 1791: l_p_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]

1787: l_p_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type; --[prarasto]
1788: l_p_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
1789: l_p_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
1790: l_p_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
1791: l_p_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
1792: l_p_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type; --[prarasto]
1793: l_p_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type; --[prarasto]
1794:
1795: BEGIN

Line 2389: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

2385: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
2386: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
2387: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
2388: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
2389: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
2390: OE_Price_List_PUB.G_MISS_PRICE_List_REC
2391: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
2392: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
2393: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 2390: OE_Price_List_PUB.G_MISS_PRICE_List_REC

2386: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
2387: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
2388: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
2389: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
2390: OE_Price_List_PUB.G_MISS_PRICE_List_REC
2391: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
2392: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
2393: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
2394: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL

Line 2393: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

2389: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
2390: OE_Price_List_PUB.G_MISS_PRICE_List_REC
2391: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
2392: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
2393: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
2394: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
2395: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
2396: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
2397: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=

Line 2394: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL

2390: OE_Price_List_PUB.G_MISS_PRICE_List_REC
2391: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
2392: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
2393: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
2394: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
2395: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
2396: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
2397: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
2398: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL

Line 2403: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

2399: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
2400: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
2401: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
2402: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
2403: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
2404: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
2405: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
2406: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
2407: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type

Line 2405: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

2401: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
2402: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
2403: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
2404: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
2405: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
2406: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
2407: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
2408: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
2409: )

Line 2414: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

2410: IS
2411: l_api_version_number CONSTANT NUMBER := 1.0;
2412: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Pricing_Cont';
2413: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2414: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
2415: l_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
2416: l_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
2417: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
2418: BEGIN

Line 2711: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

2707: , p_pricing_contract_id IN NUMBER
2708: , p_name IN VARCHAR2
2709: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
2710: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
2711: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
2712: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
2713: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
2714: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
2715: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type

Line 2713: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

2709: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
2710: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
2711: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
2712: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
2713: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
2714: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
2715: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
2716: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
2717: )

Line 2724: l_Price_LHeader_tbl OE_Price_List_PUB.Price_List_Tbl_Type;

2720: l_api_name CONSTANT VARCHAR2(30):= 'Get_Pricing_Cont';
2721: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
2722: l_Agreement_tbl OE_Pricing_Cont_PUB.Agreement_Tbl_Type;
2723: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
2724: l_Price_LHeader_tbl OE_Price_List_PUB.Price_List_Tbl_Type;
2725: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
2726: l_Discount_Header_tbl OE_Pricing_Cont_PUB.Discount_Header_Tbl_Type;
2727: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
2728: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 2725: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

2721: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
2722: l_Agreement_tbl OE_Pricing_Cont_PUB.Agreement_Tbl_Type;
2723: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
2724: l_Price_LHeader_tbl OE_Price_List_PUB.Price_List_Tbl_Type;
2725: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
2726: l_Discount_Header_tbl OE_Pricing_Cont_PUB.Discount_Header_Tbl_Type;
2727: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
2728: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
2729: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 2728: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

2724: l_Price_LHeader_tbl OE_Price_List_PUB.Price_List_Tbl_Type;
2725: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
2726: l_Discount_Header_tbl OE_Pricing_Cont_PUB.Discount_Header_Tbl_Type;
2727: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
2728: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
2729: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
2730: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
2731: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
2732: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 2729: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

2725: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
2726: l_Discount_Header_tbl OE_Pricing_Cont_PUB.Discount_Header_Tbl_Type;
2727: l_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
2728: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
2729: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
2730: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
2731: l_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
2732: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
2733: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;