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: )
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
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);
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;
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
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:
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('------------------------------------------------');
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: )
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
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);
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;
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:
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]
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:
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
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('------------------------------------------------');
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:
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 :=
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
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 :=
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
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 :=
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
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 :=
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
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
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: )
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;
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;
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;
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;
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;
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;
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]
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]
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:
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
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 :=
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
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 :=
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
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
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: )
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
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
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: )
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;
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;
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;
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;