8: -- Global variables holding cached record.
9:
10: g_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
11: g_db_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
12: -- g_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
13:
14: -- Forward declaration of procedures maintaining entity record cache.
15: FUNCTION Get_Price_Id
16: ( p_db_record IN BOOLEAN := FALSE
15: FUNCTION Get_Price_Id
16: ( p_db_record IN BOOLEAN := FALSE
17: , p_price_list_line_id IN NUMBER
18: )
19: RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;
20:
21: PROCEDURE Write_Price_Break
22: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
23: , p_db_record IN BOOLEAN := FALSE
82: l_control_rec OE_GLOBALS.Control_Rec_Type;
83: l_return_status VARCHAR2(1);
84: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
85: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
86: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
87: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
88: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
89: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
90: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
84: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
85: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
86: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
87: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
88: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
89: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
90: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
91: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
92: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
85: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
86: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
87: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
88: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
89: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
90: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
91: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
92: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
93: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
360: l_control_rec OE_GLOBALS.Control_Rec_Type;
361: l_return_status VARCHAR2(1);
362: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
363: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
364: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
365: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
366: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
367: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
368: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
362: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
363: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
364: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
365: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
366: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
367: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
368: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
369: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
370: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
363: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
364: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
365: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
366: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
367: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
368: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
369: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
370: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
371: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
807: l_control_rec OE_GLOBALS.Control_Rec_Type;
808: l_return_status VARCHAR2(1);
809: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
810: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
811: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
812: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
813: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
814: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
815: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
809: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
810: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
811: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
812: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
813: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
814: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
815: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
816: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
817: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
810: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
811: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
812: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
813: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
814: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
815: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
816: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
817: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
818: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
818: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
819: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
820: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
821:
822: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
823: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
824: l_Price_LLine_tbl OE_Price_List_PUB.Price_list_Line_Tbl_Type;
825: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_list_Line_Tbl_Type;
826:
819: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
820: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
821:
822: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
823: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
824: l_Price_LLine_tbl OE_Price_List_PUB.Price_list_Line_Tbl_Type;
825: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_list_Line_Tbl_Type;
826:
827: I NUMBER := 1;
820: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
821:
822: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
823: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
824: l_Price_LLine_tbl OE_Price_List_PUB.Price_list_Line_Tbl_Type;
825: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_list_Line_Tbl_Type;
826:
827: I NUMBER := 1;
828: l_attribute_grouping_no number := 0;
821:
822: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
823: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
824: l_Price_LLine_tbl OE_Price_List_PUB.Price_list_Line_Tbl_Type;
825: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_list_Line_Tbl_Type;
826:
827: I NUMBER := 1;
828: l_attribute_grouping_no number := 0;
829: l_pricing_attribute_id number := 0;
999: FUNCTION Get_Price_Id
1000: ( p_db_record IN BOOLEAN := FALSE
1001: , p_price_list_line_id IN NUMBER
1002: )
1003: RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type
1004: IS
1005: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1006: BEGIN
1007:
1001: , p_price_list_line_id IN NUMBER
1002: )
1003: RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type
1004: IS
1005: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1006: BEGIN
1007:
1008:
1009: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1164: l_control_rec OE_GLOBALS.Control_Rec_Type;
1165: l_return_status VARCHAR2(1);
1166: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1167: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1168: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1169: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1170: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1171: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1172: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1166: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1167: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1168: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1169: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1170: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1171: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1172: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1173: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1174: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1167: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1168: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1169: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1170: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1171: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1172: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1173: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1174: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1175: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1310: l_control_rec OE_GLOBALS.Control_Rec_Type;
1311: l_return_status VARCHAR2(1);
1312: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1313: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1314: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1315: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1316: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1317: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1318: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1312: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1313: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1314: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1315: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1316: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1317: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1318: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1319: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1320: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1313: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1314: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1315: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1316: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1317: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1318: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1319: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1320: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1321: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1470: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1471: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1472: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1473: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1474: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1475: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1476: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1477: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1478: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1472: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1473: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1474: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1475: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1476: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1477: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1478: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1479: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1480: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1473: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1474: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1475: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1476: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1477: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1478: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1479: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1480: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1481: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;