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

APPS.OE_OE_FORM_PRICE_BREAK dependencies on OE_PRICING_CONT_PUB

Line 10: g_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Price_Break';
7:
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.

Line 11: g_db_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

7:
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

Line 22: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

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
24: );
25:
26: FUNCTION Get_Price_Break

Line 33: RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

29: , p_method_type_code IN VARCHAR2
30: , p_price_break_high IN NUMBER
31: , p_price_break_low IN NUMBER
32: )
33: RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
34:
35: PROCEDURE Clear_Price_Break;
36:
37: -- Global variable holding performed operations.

Line 39: g_opr__tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

35: PROCEDURE Clear_Price_Break;
36:
37: -- Global variable holding performed operations.
38:
39: g_opr__tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
40:
41: -- Procedure : Default_Attributes
42: --
43:

Line 79: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

75: , x_method_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76: , x_unit OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77: )
78: IS
79: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
80: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
81: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
82: l_control_rec OE_GLOBALS.Control_Rec_Type;
83: l_return_status VARCHAR2(1);

Line 80: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;

76: , x_unit OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77: )
78: IS
79: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
80: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
81: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_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;

Line 81: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

77: )
78: IS
79: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
80: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
81: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_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;

Line 84: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

80: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
81: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_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;

Line 85: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

81: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_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;

Line 87: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_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;
91: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 90: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_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;
94: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 91: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_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;
94: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
95: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 92: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_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;
94: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
95: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
96: BEGIN

Line 93: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_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;
94: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
95: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
96: BEGIN
97:

Line 94: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_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;
94: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
95: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
96: BEGIN
97:
98: -- Set control flags.

Line 95: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_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;
94: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
95: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
96: BEGIN
97:
98: -- Set control flags.
99:

Line 355: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

351: , x_method_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
352: , x_unit OUT NOCOPY /* file.sql.39 change */ VARCHAR2
353: )
354: IS
355: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
356: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
357: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
358: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
359: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 356: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

352: , x_unit OUT NOCOPY /* file.sql.39 change */ VARCHAR2
353: )
354: IS
355: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
356: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
357: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
358: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
359: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
360: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 357: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;

353: )
354: IS
355: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
356: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
357: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
358: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
359: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
360: l_control_rec OE_GLOBALS.Control_Rec_Type;
361: l_return_status VARCHAR2(1);

Line 358: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

354: IS
355: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
356: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
357: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
358: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
359: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_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;

Line 359: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

355: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
356: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
357: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
358: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
359: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_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;

Line 362: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

358: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
359: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_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;

Line 363: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

359: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_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;

Line 365: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_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;
369: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 368: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_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;
372: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 369: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_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;
372: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
373: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 370: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_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;
372: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
373: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
374: BEGIN

Line 371: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_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;
372: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
373: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
374: BEGIN
375:

Line 372: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_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;
372: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
373: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
374: BEGIN
375:
376: -- Set control flags.

Line 373: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_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;
372: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
373: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
374: BEGIN
375:
376: -- Set control flags.
377:

Line 803: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

799: , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
800: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
801: )
802: IS
803: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
804: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
805: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
806: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
807: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 804: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

800: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
801: )
802: IS
803: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
804: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
805: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
806: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
807: l_control_rec OE_GLOBALS.Control_Rec_Type;
808: l_return_status VARCHAR2(1);

Line 805: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

801: )
802: IS
803: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
804: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
805: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
806: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_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;

Line 806: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

802: IS
803: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
804: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
805: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
806: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_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;

Line 809: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

805: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
806: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_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;

Line 810: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

806: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_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;

Line 812: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_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;
816: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 815: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_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;
819: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 816: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_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;
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;

Line 817: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_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;
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:

Line 818: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_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;
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;

Line 819: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_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;
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;

Line 820: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_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;
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;

Line 1162: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

1158: , p_price_break_high IN NUMBER
1159: , p_price_break_low IN NUMBER
1160: )
1161: IS
1162: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1163: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_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;

Line 1163: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

1159: , p_price_break_low IN NUMBER
1160: )
1161: IS
1162: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1163: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_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;

Line 1166: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

1162: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1163: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_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;

Line 1167: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

1163: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_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;

Line 1169: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_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;
1173: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 1172: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_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;
1176: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 1173: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_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;
1176: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1177: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 1174: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_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;
1176: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1177: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1178: BEGIN

Line 1175: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_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;
1176: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1177: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1178: BEGIN
1179:

Line 1176: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_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;
1176: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1177: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1178: BEGIN
1179:
1180: -- Set control flags.

Line 1177: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_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;
1176: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1177: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1178: BEGIN
1179:
1180: -- Set control flags.
1181:

Line 1312: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

1308: )
1309: IS
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;

Line 1313: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

1309: IS
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;

Line 1315: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_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;
1319: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 1318: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_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;
1322: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 1319: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_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;
1322: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1323: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 1320: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_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;
1322: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1323: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1324: BEGIN

Line 1321: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_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;
1322: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1323: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1324: BEGIN
1325:

Line 1322: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_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;
1322: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1323: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1324: BEGIN
1325:
1326: -- Set control flags.

Line 1323: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_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;
1322: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1323: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1324: BEGIN
1325:
1326: -- Set control flags.
1327:

Line 1470: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

1466: , p_unit_code IN VARCHAR2
1467: )
1468: IS
1469: l_return_status VARCHAR2(1);
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;

Line 1471: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

1467: )
1468: IS
1469: l_return_status VARCHAR2(1);
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;

Line 1472: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

1468: IS
1469: l_return_status VARCHAR2(1);
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;

Line 1473: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

1469: l_return_status VARCHAR2(1);
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;

Line 1475: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_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;
1479: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 1478: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_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;
1482: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 1479: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_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;
1482: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1483: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 1480: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_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;
1482: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1483: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1484: BEGIN

Line 1481: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_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;
1482: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1483: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1484: BEGIN
1485:

Line 1482: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_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;
1482: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1483: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1484: BEGIN
1485:
1486: -- Load Price_Break record

Line 1483: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_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;
1482: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1483: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1484: BEGIN
1485:
1486: -- Load Price_Break record
1487:

Line 1600: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

1596:
1597: -- Procedures maintaining Price_Break record cache.
1598:
1599: PROCEDURE Write_Price_Break
1600: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1601: , p_db_record IN BOOLEAN := FALSE
1602: )
1603: IS
1604: BEGIN

Line 1623: RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type

1619: , p_method_type_code IN VARCHAR2
1620: , p_price_break_high IN NUMBER
1621: , p_price_break_low IN NUMBER
1622: )
1623: RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
1624: IS
1625: BEGIN
1626:
1627: IF p_discount_line_id <> g_Price_Break_rec.discount_line_id

Line 1662: g_Price_Break_rec := OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC;

1658: PROCEDURE Clear_Price_Break
1659: IS
1660: BEGIN
1661:
1662: g_Price_Break_rec := OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC;
1663: g_db_Price_Break_rec := OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC;
1664:
1665: END Clear_Price_Break;
1666:

Line 1663: g_db_Price_Break_rec := OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC;

1659: IS
1660: BEGIN
1661:
1662: g_Price_Break_rec := OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC;
1663: g_db_Price_Break_rec := OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC;
1664:
1665: END Clear_Price_Break;
1666:
1667: END OE_OE_Form_Price_Break;