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

Line 10: g_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Agreement';
7:
8: -- Global variables holding cached record.
9:
10: g_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
11: g_db_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:

Line 11: g_db_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
11: g_db_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_Agreement

Line 16: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_Agreement
16: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
17: , p_db_record IN BOOLEAN := FALSE
18: );
19:
20: FUNCTION Get_Agreement

Line 24: RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type;

20: FUNCTION Get_Agreement
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_agreement_id IN NUMBER
23: )
24: RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type;
25:
26: PROCEDURE Clear_Agreement;
27:
28: -- Global variable holding performed operations.

Line 30: g_opr__tbl OE_Pricing_Cont_PUB.Agreement_Tbl_Type;

26: PROCEDURE Clear_Agreement;
27:
28: -- Global variable holding performed operations.
29:
30: g_opr__tbl OE_Pricing_Cont_PUB.Agreement_Tbl_Type;
31:
32: -- Procedure : Default_Attributes
33: --
34:

Line 101: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

97: , x_agreement_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2 --added by rchellam for OKC
98: , x_invoice_to_customer_id OUT NOCOPY NUMBER -- Added for bug#4029589
99: )
100: IS
101: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
102: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
103: l_control_rec oe_globals.Control_Rec_Type;
104: l_return_status VARCHAR2(1);
105: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line 102: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;

98: , x_invoice_to_customer_id OUT NOCOPY NUMBER -- Added for bug#4029589
99: )
100: IS
101: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
102: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
103: l_control_rec oe_globals.Control_Rec_Type;
104: l_return_status VARCHAR2(1);
105: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
106: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line 105: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

101: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
102: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
103: l_control_rec oe_globals.Control_Rec_Type;
104: l_return_status VARCHAR2(1);
105: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
106: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
107: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
108: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
109: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 106: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

102: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
103: l_control_rec oe_globals.Control_Rec_Type;
104: l_return_status VARCHAR2(1);
105: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
106: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
107: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
108: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
109: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
110: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 108: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

104: l_return_status VARCHAR2(1);
105: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
106: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
107: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
108: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
109: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
110: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
111: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
112: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 111: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

107: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
108: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
109: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
110: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
111: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
112: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
113: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
114: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
115: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 112: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

108: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
109: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
110: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
111: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
112: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
113: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
114: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
115: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
116: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 113: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

109: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
110: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
111: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
112: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
113: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
114: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
115: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
116: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
117: BEGIN

Line 114: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

110: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
111: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
112: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
113: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
114: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
115: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
116: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
117: BEGIN
118:

Line 115: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

111: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
112: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
113: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
114: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
115: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
116: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
117: BEGIN
118:
119: oe_debug_pub.add('Entering OE_OE_Form_Agreement.Default_Attributes');

Line 116: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

112: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
113: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
114: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
115: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
116: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
117: BEGIN
118:
119: oe_debug_pub.add('Entering OE_OE_Form_Agreement.Default_Attributes');
120:

Line 419: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

415: , x_agreement_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2 --added by rchellam for OKC
416: , x_invoice_to_customer_id OUT NOCOPY NUMBER -- Added for bug#4029589
417: )
418: IS
419: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
420: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
421: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
422: l_control_rec oe_globals.Control_Rec_Type;
423: l_return_status VARCHAR2(1);

Line 420: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

416: , x_invoice_to_customer_id OUT NOCOPY NUMBER -- Added for bug#4029589
417: )
418: IS
419: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
420: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
421: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
422: l_control_rec oe_globals.Control_Rec_Type;
423: l_return_status VARCHAR2(1);
424: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line 421: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;

417: )
418: IS
419: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
420: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
421: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
422: l_control_rec oe_globals.Control_Rec_Type;
423: l_return_status VARCHAR2(1);
424: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
425: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line 424: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

420: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
421: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
422: l_control_rec oe_globals.Control_Rec_Type;
423: l_return_status VARCHAR2(1);
424: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
425: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
426: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
427: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
428: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 425: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

421: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
422: l_control_rec oe_globals.Control_Rec_Type;
423: l_return_status VARCHAR2(1);
424: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
425: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
426: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
427: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
428: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
429: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 427: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

423: l_return_status VARCHAR2(1);
424: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
425: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
426: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
427: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
428: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
429: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
430: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
431: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 430: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

426: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
427: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
428: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
429: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
430: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
431: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
432: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
433: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
434: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 431: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

427: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
428: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
429: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
430: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
431: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
432: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
433: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
434: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
435: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 432: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

428: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
429: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
430: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
431: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
432: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
433: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
434: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
435: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
436: BEGIN

Line 433: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

429: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
430: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
431: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
432: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
433: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
434: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
435: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
436: BEGIN
437:

Line 434: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

430: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
431: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
432: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
433: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
434: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
435: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
436: BEGIN
437:
438: oe_debug_pub.add('Entering OE_OE_Form_Agreement.Change_Attribute');

Line 435: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

431: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
432: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
433: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
434: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
435: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
436: BEGIN
437:
438: oe_debug_pub.add('Entering OE_OE_Form_Agreement.Change_Attribute');
439:

Line 1073: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

1069: , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
1070: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
1071: )
1072: IS
1073: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1074: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1075: l_control_rec oe_globals.Control_Rec_Type;
1076: l_return_status VARCHAR2(1);
1077: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line 1074: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

1070: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
1071: )
1072: IS
1073: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1074: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1075: l_control_rec oe_globals.Control_Rec_Type;
1076: l_return_status VARCHAR2(1);
1077: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1078: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line 1077: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

1073: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1074: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1075: l_control_rec oe_globals.Control_Rec_Type;
1076: l_return_status VARCHAR2(1);
1077: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1078: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1079: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1080: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1081: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1078: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

1074: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1075: l_control_rec oe_globals.Control_Rec_Type;
1076: l_return_status VARCHAR2(1);
1077: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1078: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1079: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1080: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1081: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1082: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1080: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

1076: l_return_status VARCHAR2(1);
1077: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1078: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1079: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1080: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1081: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1082: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1083: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1084: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 1083: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

1079: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1080: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1081: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1082: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1083: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1084: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1085: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1086: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1087: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 1084: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

1080: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1081: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1082: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1083: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1084: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1085: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1086: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1087: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1088: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 1085: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

1081: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1082: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1083: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1084: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1085: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1086: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1087: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1088: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1089: BEGIN

Line 1086: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

1082: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1083: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1084: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1085: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1086: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1087: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1088: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1089: BEGIN
1090:

Line 1087: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

1083: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1084: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1085: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1086: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1087: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1088: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1089: BEGIN
1090:
1091: oe_debug_pub.add('Entering OE_OE_Form_Agreement.Validate_And_Write');

Line 1088: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

1084: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1085: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1086: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1087: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1088: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1089: BEGIN
1090:
1091: oe_debug_pub.add('Entering OE_OE_Form_Agreement.Validate_And_Write');
1092:

Line 1281: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

1277: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1278: , p_agreement_id IN NUMBER
1279: )
1280: IS
1281: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1282: l_control_rec oe_globals.Control_Rec_Type;
1283: l_return_status VARCHAR2(1);
1284: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1285: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line 1284: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

1280: IS
1281: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1282: l_control_rec oe_globals.Control_Rec_Type;
1283: l_return_status VARCHAR2(1);
1284: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1285: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1286: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1287: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1288: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1285: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

1281: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1282: l_control_rec oe_globals.Control_Rec_Type;
1283: l_return_status VARCHAR2(1);
1284: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1285: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1286: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1287: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1288: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1289: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1287: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

1283: l_return_status VARCHAR2(1);
1284: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1285: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1286: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1287: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1288: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1289: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1290: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1291: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 1290: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

1286: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1287: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1288: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1289: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1290: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1291: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1292: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1293: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1294: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 1291: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

1287: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1288: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1289: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1290: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1291: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1292: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1293: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1294: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1295: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 1292: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

1288: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1289: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1290: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1291: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1292: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1293: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1294: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1295: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1296: BEGIN

Line 1293: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

1289: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1290: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1291: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1292: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1293: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1294: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1295: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1296: BEGIN
1297:

Line 1294: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

1290: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1291: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1292: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1293: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1294: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1295: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1296: BEGIN
1297:
1298: -- Set control flags.

Line 1295: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

1291: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1292: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1293: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1294: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1295: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1296: BEGIN
1297:
1298: -- Set control flags.
1299:

Line 1423: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

1419: )
1420: IS
1421: l_control_rec oe_globals.Control_Rec_Type;
1422: l_return_status VARCHAR2(1);
1423: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1424: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1425: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1426: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1427: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1424: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

1420: IS
1421: l_control_rec oe_globals.Control_Rec_Type;
1422: l_return_status VARCHAR2(1);
1423: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1424: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1425: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1426: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1427: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1428: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1426: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

1422: l_return_status VARCHAR2(1);
1423: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1424: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1425: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1426: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1427: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1428: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1429: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1430: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 1429: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

1425: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1426: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1427: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1428: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1429: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1430: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1431: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1432: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1433: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 1430: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

1426: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1427: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1428: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1429: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1430: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1431: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1432: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1433: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1434: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 1431: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

1427: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1428: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1429: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1430: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1431: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1432: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1433: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1434: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1435: BEGIN

Line 1432: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

1428: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1429: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1430: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1431: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1432: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1433: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1434: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1435: BEGIN
1436:

Line 1433: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

1429: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1430: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1431: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1432: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1433: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1434: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1435: BEGIN
1436:
1437: -- Set control flags.

Line 1434: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

1430: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1431: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1432: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1433: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1434: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1435: BEGIN
1436:
1437: -- Set control flags.
1438:

Line 1597: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

1593: , p_invoice_to_customer_id IN NUMBER -- Added for bug#4029589
1594: )
1595: IS
1596: l_return_status VARCHAR2(1);
1597: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1598: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1599: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1600: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1601: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

Line 1598: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

1594: )
1595: IS
1596: l_return_status VARCHAR2(1);
1597: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1598: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1599: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1600: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1601: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1602: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1599: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

1595: IS
1596: l_return_status VARCHAR2(1);
1597: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1598: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1599: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1600: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1601: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1602: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1603: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1601: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

1597: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1598: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1599: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1600: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1601: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1602: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1603: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1604: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1605: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 1604: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

1600: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1601: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1602: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1603: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1604: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1605: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1606: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1607: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1608: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

Line 1605: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

1601: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1602: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1603: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1604: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1605: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1606: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1607: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1608: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1609: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 1606: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

1602: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1603: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1604: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1605: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1606: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1607: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1608: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1609: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1610: BEGIN

Line 1607: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

1603: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1604: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1605: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1606: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1607: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1608: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1609: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1610: BEGIN
1611:

Line 1608: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;

1604: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1605: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1606: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1607: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1608: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1609: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1610: BEGIN
1611:
1612: -- Load Agreement record

Line 1609: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

1605: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1606: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1607: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;
1608: l_x_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1609: l_x_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1610: BEGIN
1611:
1612: -- Load Agreement record
1613:

Line 1738: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

1734:
1735: -- Procedures maintaining Agreement record cache.
1736:
1737: PROCEDURE Write_Agreement
1738: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
1739: , p_db_record IN BOOLEAN := FALSE
1740: )
1741: IS
1742: BEGIN

Line 1758: RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type

1754: FUNCTION Get_Agreement
1755: ( p_db_record IN BOOLEAN := FALSE
1756: , p_agreement_id IN NUMBER
1757: )
1758: RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type
1759: IS
1760: BEGIN
1761:
1762: IF p_agreement_id <> g_Agreement_rec.agreement_id

Line 1795: g_Agreement_rec := OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC;

1791: PROCEDURE Clear_Agreement
1792: IS
1793: BEGIN
1794:
1795: g_Agreement_rec := OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC;
1796: g_db_Agreement_rec := OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC;
1797:
1798: END Clear_Agreement;
1799:

Line 1796: g_db_Agreement_rec := OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC;

1792: IS
1793: BEGIN
1794:
1795: g_Agreement_rec := OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC;
1796: g_db_Agreement_rec := OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC;
1797:
1798: END Clear_Agreement;
1799:
1800: END OE_OE_Form_Agreement;