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_LLINE dependencies on OE_PRICE_LIST_PUB

Line 10: g_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Price_Lline';
7:
8: -- Global variables holding cached record.
9:
10: g_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
11: g_db_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:

Line 11: g_db_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
11: g_db_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_Price_LLine

Line 16: ( p_Price_LLine_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_Price_LLine
16: ( p_Price_LLine_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
17: , p_db_record IN BOOLEAN := FALSE
18: );
19:
20: FUNCTION Get_Price_LLine

Line 24: RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;

20: FUNCTION Get_Price_LLine
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_price_list_line_id IN NUMBER
23: )
24: RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;
25:
26: PROCEDURE Clear_Price_LLine;
27:
28: -- Global variable holding performed operations.

Line 30: g_opr__tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

26: PROCEDURE Clear_Price_LLine;
27:
28: -- Global variable holding performed operations.
29:
30: g_opr__tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
31:
32: -- Procedure : Default_Attributes
33: --
34:

Line 100: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

96: , x_creation_date OUT NOCOPY /* file.sql.39 change */ DATE /* Parameter added Geresh */
97: , x_list_line_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
98: )
99: IS
100: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
101: l_Price_LLine_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
102: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
103: l_control_rec OE_GLOBALS.Control_Rec_Type;
104: l_return_status VARCHAR2(1);

Line 101: l_Price_LLine_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;

97: , x_list_line_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
98: )
99: IS
100: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
101: l_Price_LLine_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
102: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_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_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

98: )
99: IS
100: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
101: l_Price_LLine_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
102: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_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 107: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_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;
111: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

Line 109: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

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;
113: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

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

Line 432: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

428: , x_creation_date OUT NOCOPY /* file.sql.39 change */ DATE
429: , x_list_line_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
430: )
431: IS
432: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
433: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
434: l_Price_LLine_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
435: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
436: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 433: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

429: , x_list_line_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
430: )
431: IS
432: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
433: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
434: l_Price_LLine_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
435: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
436: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
437: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 434: l_Price_LLine_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;

430: )
431: IS
432: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
433: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
434: l_Price_LLine_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
435: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
436: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
437: l_control_rec OE_GLOBALS.Control_Rec_Type;
438: l_return_status VARCHAR2(1);

Line 435: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

431: IS
432: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
433: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
434: l_Price_LLine_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
435: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
436: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
437: l_control_rec OE_GLOBALS.Control_Rec_Type;
438: l_return_status VARCHAR2(1);
439: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line 436: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

432: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
433: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
434: l_Price_LLine_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
435: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
436: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
437: l_control_rec OE_GLOBALS.Control_Rec_Type;
438: l_return_status VARCHAR2(1);
439: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
440: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line 441: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

437: l_control_rec OE_GLOBALS.Control_Rec_Type;
438: l_return_status VARCHAR2(1);
439: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
440: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
441: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
442: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
443: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
444: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
445: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

Line 443: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

439: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
440: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
441: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
442: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
443: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
444: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
445: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
446: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
447: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

Line 444: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

440: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
441: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
442: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
443: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
444: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
445: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
446: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
447: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
448: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

Line 1172: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

1168: , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
1169: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
1170: )
1171: IS
1172: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1173: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1174: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1175: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1176: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 1173: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

1169: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
1170: )
1171: IS
1172: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1173: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1174: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1175: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1176: l_control_rec OE_GLOBALS.Control_Rec_Type;
1177: l_return_status VARCHAR2(1);

Line 1174: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

1170: )
1171: IS
1172: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1173: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1174: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1175: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1176: l_control_rec OE_GLOBALS.Control_Rec_Type;
1177: l_return_status VARCHAR2(1);
1178: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line 1175: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

1171: IS
1172: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1173: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1174: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1175: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1176: l_control_rec OE_GLOBALS.Control_Rec_Type;
1177: l_return_status VARCHAR2(1);
1178: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1179: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line 1180: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

1176: l_control_rec OE_GLOBALS.Control_Rec_Type;
1177: l_return_status VARCHAR2(1);
1178: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1179: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1180: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1181: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1182: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1183: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1184: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

Line 1182: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

1178: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1179: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1180: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1181: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1182: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1183: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1184: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1185: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1186: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

Line 1183: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

1179: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1180: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1181: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1182: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1183: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1184: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1185: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1186: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1187: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

Line 1376: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

1372: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1373: , p_price_list_line_id IN NUMBER
1374: )
1375: IS
1376: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1377: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1378: l_control_rec OE_GLOBALS.Control_Rec_Type;
1379: l_return_status VARCHAR2(1);
1380: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line 1377: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

1373: , p_price_list_line_id IN NUMBER
1374: )
1375: IS
1376: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1377: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1378: l_control_rec OE_GLOBALS.Control_Rec_Type;
1379: l_return_status VARCHAR2(1);
1380: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1381: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line 1382: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

1378: l_control_rec OE_GLOBALS.Control_Rec_Type;
1379: l_return_status VARCHAR2(1);
1380: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1381: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1382: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1383: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1384: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1385: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1386: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

Line 1384: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

1380: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1381: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1382: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1383: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1384: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1385: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1386: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1387: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1388: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

Line 1385: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

1381: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1382: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1383: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1384: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1385: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1386: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1387: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1388: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1389: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

Line 1525: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

1521: l_control_rec OE_GLOBALS.Control_Rec_Type;
1522: l_return_status VARCHAR2(1);
1523: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1524: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1525: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1526: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1527: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1528: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1529: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

Line 1527: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

1523: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1524: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1525: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1526: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1527: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1528: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1529: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1530: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1531: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

Line 1528: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

1524: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1525: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1526: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1527: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1528: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1529: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1530: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1531: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1532: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

Line 1707: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

1703: , p_list_line_type_code IN VARCHAR2
1704: )
1705: IS
1706: l_return_status VARCHAR2(1);
1707: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1708: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1709: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1710: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1711: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 1708: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

1704: )
1705: IS
1706: l_return_status VARCHAR2(1);
1707: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1708: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1709: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1710: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1711: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1712: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

Line 1711: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

1707: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1708: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1709: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1710: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1711: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1712: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1713: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1714: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1715: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

Line 1713: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

1709: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1710: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1711: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1712: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1713: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1714: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1715: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1716: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1717: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

Line 1714: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

1710: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1711: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1712: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1713: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1714: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1715: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1716: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1717: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1718: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

Line 1868: ( p_Price_LLine_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

1864:
1865: -- Procedures maintaining Price_LLine record cache.
1866:
1867: PROCEDURE Write_Price_LLine
1868: ( p_Price_LLine_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
1869: , p_db_record IN BOOLEAN := FALSE
1870: )
1871: IS
1872: BEGIN

Line 1888: RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type

1884: FUNCTION Get_Price_LLine
1885: ( p_db_record IN BOOLEAN := FALSE
1886: , p_price_list_line_id IN NUMBER
1887: )
1888: RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type
1889: IS
1890: BEGIN
1891:
1892: oe_debug_pub.add('global pline id is : ' || to_char(g_Price_LLine_rec.price_list_id));

Line 1930: g_Price_LLine_rec := OE_Price_List_PUB.G_MISS_PRICE_List_Line_REC;

1926: PROCEDURE Clear_Price_Lline
1927: IS
1928: BEGIN
1929:
1930: g_Price_LLine_rec := OE_Price_List_PUB.G_MISS_PRICE_List_Line_REC;
1931: g_db_Price_LLine_rec := OE_Price_List_PUB.G_MISS_PRICE_List_Line_REC;
1932:
1933: END Clear_Price_Lline;
1934:

Line 1931: g_db_Price_LLine_rec := OE_Price_List_PUB.G_MISS_PRICE_List_Line_REC;

1927: IS
1928: BEGIN
1929:
1930: g_Price_LLine_rec := OE_Price_List_PUB.G_MISS_PRICE_List_Line_REC;
1931: g_db_Price_LLine_rec := OE_Price_List_PUB.G_MISS_PRICE_List_Line_REC;
1932:
1933: END Clear_Price_Lline;
1934:
1935: END OE_OE_Form_Price_Lline;