DBA Data[Home] [Help]

APPS.OE_OE_FORM_PRICE_BREAK dependencies on OE_PRICE_LIST_PUB

Line 12: -- g_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

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

Line 19: RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;

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

Line 86: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

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;

Line 88: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_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;

Line 89: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_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;

Line 364: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_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;

Line 366: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_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;

Line 367: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_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;

Line 811: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_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;

Line 813: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_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;

Line 814: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_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;

Line 822: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_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:

Line 823: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_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:
827: I NUMBER := 1;

Line 824: l_Price_LLine_tbl OE_Price_List_PUB.Price_list_Line_Tbl_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;
828: l_attribute_grouping_no number := 0;

Line 825: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_list_Line_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;
829: l_pricing_attribute_id number := 0;

Line 1003: RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type

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:

Line 1005: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

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)

Line 1168: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

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;

Line 1170: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_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;

Line 1171: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_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;

Line 1314: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_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;

Line 1316: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_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;

Line 1317: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_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;

Line 1474: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_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;

Line 1476: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_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;

Line 1477: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_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;