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_CONTRACT dependencies on OE_PRICING_CONT_PUB

Line 10: g_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Contract';
7:
8: -- Global variables holding cached record.
9:
10: g_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
11: g_db_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
12:
13: -- Revision Control S
14: g_Revision_Change VARCHAR2(1) := FND_API.G_FALSE;

Line 11: g_db_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
11: g_db_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
12:
13: -- Revision Control S
14: g_Revision_Change VARCHAR2(1) := FND_API.G_FALSE;
15: g_Agreement_Id NUMBER := FND_API.G_MISS_NUM;

Line 21: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type

17:
18: -- Forward declaration of procedures maintaining entity record cache.
19:
20: PROCEDURE Write_Contract
21: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
22: , p_db_record IN BOOLEAN := FALSE
23: );
24:
25: FUNCTION Get_Contract

Line 29: RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type;

25: FUNCTION Get_Contract
26: ( p_db_record IN BOOLEAN := FALSE
27: , p_pricing_contract_id IN NUMBER
28: )
29: RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type;
30:
31: PROCEDURE Clear_Contract;
32:
33: -- Global variable holding performed operations.

Line 35: g_opr__tbl OE_Pricing_Cont_PUB.Contract_Tbl_Type;

31: PROCEDURE Clear_Contract;
32:
33: -- Global variable holding performed operations.
34:
35: g_opr__tbl OE_Pricing_Cont_PUB.Contract_Tbl_Type;
36:
37: PROCEDURE Get_Startup_Values
38: (Item_Id_Flex_Code IN VARCHAR2,
39: Item_Id_Flex_Num OUT NUMBER) IS

Line 97: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

93: , x_discount OUT VARCHAR2
94: , x_price_list OUT VARCHAR2
95: )
96: IS
97: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
98: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
99: l_control_rec OE_GLOBALS.Control_Rec_Type;
100: l_return_status VARCHAR2(1);
101: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line 98: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;

94: , x_price_list OUT VARCHAR2
95: )
96: IS
97: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
98: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
99: l_control_rec OE_GLOBALS.Control_Rec_Type;
100: l_return_status VARCHAR2(1);
101: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
102: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line 101: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

97: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
98: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
99: l_control_rec OE_GLOBALS.Control_Rec_Type;
100: l_return_status VARCHAR2(1);
101: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
102: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
103: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
104: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
105: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 102: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

98: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
99: l_control_rec OE_GLOBALS.Control_Rec_Type;
100: l_return_status VARCHAR2(1);
101: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
102: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
103: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
104: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
105: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
106: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 104: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

100: l_return_status VARCHAR2(1);
101: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
102: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
103: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
104: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
105: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
106: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
107: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
108: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 107: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

103: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
104: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
105: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
106: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
107: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
108: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
109: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
110: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
111: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 108: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

104: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
105: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
106: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
107: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
108: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
109: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
110: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
111: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
112: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 109: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

105: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
106: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
107: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
108: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
109: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
110: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
111: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
112: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
113: BEGIN

Line 110: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

106: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
107: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
108: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
109: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
110: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
111: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
112: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
113: BEGIN
114:

Line 111: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

107: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
108: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
109: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
110: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
111: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
112: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
113: BEGIN
114:
115: oe_debug_pub.add('Entering OE_OE_Form_Contract.Default_Attributes');

Line 112: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

108: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
109: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
110: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
111: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
112: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
113: BEGIN
114:
115: oe_debug_pub.add('Entering OE_OE_Form_Contract.Default_Attributes');
116:

Line 338: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

334: , x_discount OUT VARCHAR2
335: , x_price_list OUT VARCHAR2
336: )
337: IS
338: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
339: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
340: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
341: l_control_rec OE_GLOBALS.Control_Rec_Type;
342: l_return_status VARCHAR2(1);

Line 339: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

335: , x_price_list OUT VARCHAR2
336: )
337: IS
338: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
339: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
340: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
341: l_control_rec OE_GLOBALS.Control_Rec_Type;
342: l_return_status VARCHAR2(1);
343: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line 340: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;

336: )
337: IS
338: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
339: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
340: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
341: l_control_rec OE_GLOBALS.Control_Rec_Type;
342: l_return_status VARCHAR2(1);
343: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
344: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line 343: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

339: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
340: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
341: l_control_rec OE_GLOBALS.Control_Rec_Type;
342: l_return_status VARCHAR2(1);
343: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
344: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
345: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
346: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
347: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 344: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

340: l_Contract_val_rec OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
341: l_control_rec OE_GLOBALS.Control_Rec_Type;
342: l_return_status VARCHAR2(1);
343: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
344: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
345: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
346: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
347: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
348: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 346: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

342: l_return_status VARCHAR2(1);
343: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
344: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
345: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
346: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
347: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
348: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
349: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
350: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 349: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

345: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
346: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
347: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
348: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
349: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
350: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
351: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
352: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
353: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 350: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

346: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
347: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
348: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
349: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
350: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
351: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
352: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
353: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
354: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 351: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

347: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
348: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
349: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
350: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
351: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
352: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
353: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
354: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
355: BEGIN

Line 352: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

348: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
349: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
350: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
351: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
352: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
353: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
354: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
355: BEGIN
356:

Line 353: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

349: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
350: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
351: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
352: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
353: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
354: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
355: BEGIN
356:
357: oe_debug_pub.add('Entering OE_OE_Form_Contract.Change_Attribute');

Line 354: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

350: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
351: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
352: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
353: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
354: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
355: BEGIN
356:
357: oe_debug_pub.add('Entering OE_OE_Form_Contract.Change_Attribute');
358:

Line 727: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

723: , x_last_updated_by OUT NUMBER
724: , x_last_update_login OUT NUMBER
725: )
726: IS
727: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
728: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
729: l_control_rec OE_GLOBALS.Control_Rec_Type;
730: l_return_status VARCHAR2(1);
731: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line 728: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

724: , x_last_update_login OUT NUMBER
725: )
726: IS
727: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
728: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
729: l_control_rec OE_GLOBALS.Control_Rec_Type;
730: l_return_status VARCHAR2(1);
731: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
732: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line 731: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

727: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
728: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
729: l_control_rec OE_GLOBALS.Control_Rec_Type;
730: l_return_status VARCHAR2(1);
731: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
732: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
733: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
734: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
735: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 732: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

728: l_old_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
729: l_control_rec OE_GLOBALS.Control_Rec_Type;
730: l_return_status VARCHAR2(1);
731: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
732: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
733: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
734: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
735: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
736: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 734: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

730: l_return_status VARCHAR2(1);
731: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
732: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
733: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
734: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
735: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
736: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
737: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
738: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 737: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

733: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
734: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
735: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
736: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
737: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
738: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
739: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
740: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
741: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 738: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

734: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
735: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
736: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
737: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
738: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
739: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
740: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
741: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
742: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 739: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

735: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
736: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
737: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
738: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
739: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
740: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
741: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
742: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
743: BEGIN

Line 740: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

736: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
737: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
738: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
739: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
740: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
741: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
742: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
743: BEGIN
744:

Line 741: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

737: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
738: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
739: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
740: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
741: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
742: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
743: BEGIN
744:
745: oe_debug_pub.add('Entering OE_OE_Form_Contract.Validate_And_Write');

Line 742: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

738: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
739: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
740: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
741: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
742: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
743: BEGIN
744:
745: oe_debug_pub.add('Entering OE_OE_Form_Contract.Validate_And_Write');
746:

Line 906: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

902: , x_msg_data OUT VARCHAR2
903: , p_pricing_contract_id IN NUMBER
904: )
905: IS
906: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
907: l_control_rec OE_GLOBALS.Control_Rec_Type;
908: l_return_status VARCHAR2(1);
909: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
910: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line 909: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

905: IS
906: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
907: l_control_rec OE_GLOBALS.Control_Rec_Type;
908: l_return_status VARCHAR2(1);
909: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
910: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
911: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
912: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
913: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 910: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

906: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
907: l_control_rec OE_GLOBALS.Control_Rec_Type;
908: l_return_status VARCHAR2(1);
909: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
910: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
911: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
912: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
913: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
914: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 912: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

908: l_return_status VARCHAR2(1);
909: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
910: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
911: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
912: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
913: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
914: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
915: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
916: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 915: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

911: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
912: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
913: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
914: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
915: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
916: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
917: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
918: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
919: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 916: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

912: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
913: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
914: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
915: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
916: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
917: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
918: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
919: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
920: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 917: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

913: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
914: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
915: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
916: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
917: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
918: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
919: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
920: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
921: BEGIN

Line 918: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

914: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
915: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
916: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
917: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
918: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
919: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
920: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
921: BEGIN
922:

Line 919: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

915: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
916: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
917: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
918: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
919: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
920: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
921: BEGIN
922:
923: -- Set control flags.

Line 920: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

916: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
917: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
918: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
919: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
920: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
921: BEGIN
922:
923: -- Set control flags.
924:

Line 1048: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

1044: )
1045: IS
1046: l_control_rec OE_GLOBALS.Control_Rec_Type;
1047: l_return_status VARCHAR2(1);
1048: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1049: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1050: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1051: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1052: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1049: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

1045: IS
1046: l_control_rec OE_GLOBALS.Control_Rec_Type;
1047: l_return_status VARCHAR2(1);
1048: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1049: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1050: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1051: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1052: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1053: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1051: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

1047: l_return_status VARCHAR2(1);
1048: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1049: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1050: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1051: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1052: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1053: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1054: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1055: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 1054: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

1050: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1051: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1052: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1053: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1054: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1055: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1056: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1057: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1058: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 1055: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

1051: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1052: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1053: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1054: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1055: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1056: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1057: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1058: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1059: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 1056: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

1052: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1053: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1054: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1055: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1056: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1057: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1058: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1059: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1060: BEGIN

Line 1057: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

1053: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1054: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1055: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1056: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1057: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1058: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1059: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1060: BEGIN
1061:

Line 1058: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

1054: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1055: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1056: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1057: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1058: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1059: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1060: BEGIN
1061:
1062: -- Set control flags.

Line 1059: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

1055: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1056: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1057: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1058: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1059: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1060: BEGIN
1061:
1062: -- Set control flags.
1063:

Line 1172: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

1168: )
1169: IS
1170: l_control_rec OE_GLOBALS.Control_Rec_Type;
1171: l_return_status VARCHAR2(1);
1172: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1173: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1174: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1175: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1176: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1173: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

1169: IS
1170: l_control_rec OE_GLOBALS.Control_Rec_Type;
1171: l_return_status VARCHAR2(1);
1172: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1173: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1174: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1175: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1176: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1177: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1175: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

1171: l_return_status VARCHAR2(1);
1172: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1173: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1174: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1175: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1176: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1177: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1178: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1179: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 1178: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

1174: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1175: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1176: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1177: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1178: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1179: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1180: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1181: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1182: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 1179: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

1175: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1176: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1177: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1178: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1179: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1180: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1181: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1182: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1183: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 1180: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

1176: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1177: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1178: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1179: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1180: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1181: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1182: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1183: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1184: BEGIN

Line 1181: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

1177: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1178: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1179: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1180: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1181: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1182: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1183: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1184: BEGIN
1185:

Line 1182: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

1178: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1179: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1180: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1181: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1182: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1183: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1184: BEGIN
1185:
1186: -- Set control flags.

Line 1183: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

1179: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1180: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1181: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1182: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1183: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1184: BEGIN
1185:
1186: -- Set control flags.
1187:

Line 1320: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

1316: , p_pricing_contract_id IN NUMBER
1317: )
1318: IS
1319: l_return_status VARCHAR2(1);
1320: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1321: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1322: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1323: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1324: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

Line 1321: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

1317: )
1318: IS
1319: l_return_status VARCHAR2(1);
1320: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1321: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1322: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1323: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1324: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1325: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1322: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

1318: IS
1319: l_return_status VARCHAR2(1);
1320: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1321: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1322: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1323: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1324: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1325: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1326: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1324: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

1320: l_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1321: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1322: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1323: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1324: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1325: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1326: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1327: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1328: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 1327: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

1323: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1324: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1325: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1326: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1327: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1328: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1329: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1330: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1331: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 1328: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

1324: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1325: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1326: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1327: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1328: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1329: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1330: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1331: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1332: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 1329: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

1325: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1326: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1327: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1328: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1329: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1330: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1331: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1332: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1333: BEGIN

Line 1330: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

1326: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1327: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1328: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1329: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1330: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1331: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1332: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1333: BEGIN
1334:

Line 1331: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

1327: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1328: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1329: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1330: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1331: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1332: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1333: BEGIN
1334:
1335: -- Load Contract record

Line 1332: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

1328: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1329: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1330: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1331: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1332: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1333: BEGIN
1334:
1335: -- Load Contract record
1336:

Line 1435: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type

1431:
1432: -- Procedures maintaining Contract record cache.
1433:
1434: PROCEDURE Write_Contract
1435: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
1436: , p_db_record IN BOOLEAN := FALSE
1437: )
1438: IS
1439: BEGIN

Line 1455: RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type

1451: FUNCTION Get_Contract
1452: ( p_db_record IN BOOLEAN := FALSE
1453: , p_pricing_contract_id IN NUMBER
1454: )
1455: RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type
1456: IS
1457: BEGIN
1458:
1459: IF p_pricing_contract_id <> g_Contract_rec.pricing_contract_id

Line 1492: g_Contract_rec := OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC;

1488: PROCEDURE Clear_Contract
1489: IS
1490: BEGIN
1491:
1492: g_Contract_rec := OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC;
1493: g_db_Contract_rec := OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC;
1494:
1495: END Clear_Contract;
1496:

Line 1493: g_db_Contract_rec := OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC;

1489: IS
1490: BEGIN
1491:
1492: g_Contract_rec := OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC;
1493: g_db_Contract_rec := OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC;
1494:
1495: END Clear_Contract;
1496:
1497: -- Revision Control S