DBA Data[Home] [Help]

APPS.OE_OE_FORM_PRICE_LHEADER dependencies on OE_PRICE_LIST_PUB

Line 10: g_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

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

Line 11: g_db_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
11: g_db_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_Price_LHeader

Line 16: ( p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type

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

Line 24: RETURN OE_Price_List_PUB.Price_List_Rec_Type;

20: FUNCTION Get_Price_LHeader
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_price_list_id IN NUMBER
23: )
24: RETURN OE_Price_List_PUB.Price_List_Rec_Type;
25:
26: PROCEDURE Clear_Price_LHeader;
27:
28: -- Global variable holding performed operations.

Line 30: g_opr__tbl OE_Price_List_PUB.Price_List_Tbl_Type;

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

Line 75: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

71: , x_ship_method OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72: , x_terms OUT NOCOPY /* file.sql.39 change */ VARCHAR2
73: )
74: IS
75: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
76: l_Price_LHeader_val_rec OE_Price_List_PUB.Price_List_Val_Rec_Type;
77: l_control_rec OE_GLOBALS.Control_Rec_Type;
78: l_return_status VARCHAR2(1);
79: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line 76: l_Price_LHeader_val_rec OE_Price_List_PUB.Price_List_Val_Rec_Type;

72: , x_terms OUT NOCOPY /* file.sql.39 change */ VARCHAR2
73: )
74: IS
75: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
76: l_Price_LHeader_val_rec OE_Price_List_PUB.Price_List_Val_Rec_Type;
77: l_control_rec OE_GLOBALS.Control_Rec_Type;
78: l_return_status VARCHAR2(1);
79: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
80: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line 81: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

77: l_control_rec OE_GLOBALS.Control_Rec_Type;
78: l_return_status VARCHAR2(1);
79: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
80: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
81: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
82: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
83: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
84: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
85: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

Line 83: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

79: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
80: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
81: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
82: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
83: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
84: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
85: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
86: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
87: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

Line 84: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

80: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
81: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
82: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
83: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
84: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
85: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
86: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
87: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
88: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

Line 343: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

339: , x_ship_method OUT NOCOPY /* file.sql.39 change */ VARCHAR2
340: , x_terms OUT NOCOPY /* file.sql.39 change */ VARCHAR2
341: )
342: IS
343: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
344: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
345: l_Price_LHeader_val_rec OE_Price_List_PUB.Price_List_Val_Rec_Type;
346: l_control_rec OE_GLOBALS.Control_Rec_Type;
347: l_return_status VARCHAR2(1);

Line 344: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

340: , x_terms OUT NOCOPY /* file.sql.39 change */ VARCHAR2
341: )
342: IS
343: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
344: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
345: l_Price_LHeader_val_rec OE_Price_List_PUB.Price_List_Val_Rec_Type;
346: l_control_rec OE_GLOBALS.Control_Rec_Type;
347: l_return_status VARCHAR2(1);
348: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line 345: l_Price_LHeader_val_rec OE_Price_List_PUB.Price_List_Val_Rec_Type;

341: )
342: IS
343: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
344: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
345: l_Price_LHeader_val_rec OE_Price_List_PUB.Price_List_Val_Rec_Type;
346: l_control_rec OE_GLOBALS.Control_Rec_Type;
347: l_return_status VARCHAR2(1);
348: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
349: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line 350: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

346: l_control_rec OE_GLOBALS.Control_Rec_Type;
347: l_return_status VARCHAR2(1);
348: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
349: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
350: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
351: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
352: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
353: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
354: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

Line 352: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

348: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
349: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
350: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
351: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
352: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
353: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
354: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
355: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
356: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

Line 353: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

349: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
350: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
351: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
352: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
353: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
354: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
355: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
356: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
357: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

Line 798: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

794: , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
795: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
796: )
797: IS
798: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
799: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
800: l_control_rec OE_GLOBALS.Control_Rec_Type;
801: l_return_status VARCHAR2(1);
802: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line 799: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

795: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
796: )
797: IS
798: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
799: l_old_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
800: l_control_rec OE_GLOBALS.Control_Rec_Type;
801: l_return_status VARCHAR2(1);
802: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
803: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line 804: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

800: l_control_rec OE_GLOBALS.Control_Rec_Type;
801: l_return_status VARCHAR2(1);
802: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
803: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
804: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
805: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
806: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
807: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
808: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

Line 806: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

802: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
803: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
804: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
805: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
806: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
807: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
808: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
809: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
810: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

Line 807: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

803: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
804: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
805: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
806: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
807: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
808: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
809: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
810: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
811: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

Line 964: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

960: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
961: , p_price_list_id IN NUMBER
962: )
963: IS
964: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
965: l_control_rec OE_GLOBALS.Control_Rec_Type;
966: l_return_status VARCHAR2(1);
967: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
968: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line 969: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

965: l_control_rec OE_GLOBALS.Control_Rec_Type;
966: l_return_status VARCHAR2(1);
967: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
968: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
969: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
970: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
971: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
972: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
973: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

Line 971: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

967: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
968: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
969: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
970: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
971: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
972: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
973: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
974: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
975: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

Line 972: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

968: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
969: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
970: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
971: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
972: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
973: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
974: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
975: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
976: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

Line 1108: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

1104: l_control_rec OE_GLOBALS.Control_Rec_Type;
1105: l_return_status VARCHAR2(1);
1106: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1107: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1108: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1109: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1110: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1111: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1112: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

Line 1110: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

1106: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1107: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1108: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1109: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1110: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1111: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1112: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1113: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1114: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

Line 1111: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

1107: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1108: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1109: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1110: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1111: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1112: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1113: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1114: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1115: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

Line 1267: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

1263: , p_currency_header_id IN NUMBER -- Multi-Currency SunilPandey
1264: )
1265: IS
1266: l_return_status VARCHAR2(1);
1267: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1268: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1269: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1270: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1271: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;

Line 1270: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

1266: l_return_status VARCHAR2(1);
1267: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1268: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1269: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1270: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1271: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1272: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1273: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1274: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;

Line 1272: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

1268: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1269: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1270: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1271: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1272: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1273: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1274: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1275: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1276: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;

Line 1273: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

1269: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1270: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
1271: l_x_Discount_Header_rec OE_Pricing_Cont_PUB.Discount_Header_Rec_Type;
1272: l_x_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1273: l_x_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1274: l_x_Discount_Cust_rec OE_Pricing_Cont_PUB.Discount_Cust_Rec_Type;
1275: l_x_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;
1276: l_x_Discount_Line_rec OE_Pricing_Cont_PUB.Discount_Line_Rec_Type;
1277: l_x_Discount_Line_tbl OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type;

Line 1395: ( p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type

1391:
1392: -- Procedures maintaining Price_LHeader record cache.
1393:
1394: PROCEDURE Write_Price_LHeader
1395: ( p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type
1396: , p_db_record IN BOOLEAN := FALSE
1397: )
1398: IS
1399: BEGIN

Line 1415: RETURN OE_Price_List_PUB.Price_List_Rec_Type

1411: FUNCTION Get_Price_LHeader
1412: ( p_db_record IN BOOLEAN := FALSE
1413: , p_price_list_id IN NUMBER
1414: )
1415: RETURN OE_Price_List_PUB.Price_List_Rec_Type
1416: IS
1417: BEGIN
1418:
1419: IF p_price_list_id <> g_Price_LHeader_rec.price_list_id

Line 1453: g_Price_LHeader_rec := OE_Price_List_PUB.G_MISS_PRICE_List_REC;

1449: PROCEDURE Clear_Price_Lheader
1450: IS
1451: BEGIN
1452:
1453: g_Price_LHeader_rec := OE_Price_List_PUB.G_MISS_PRICE_List_REC;
1454: g_db_Price_LHeader_rec := OE_Price_List_PUB.G_MISS_PRICE_List_REC;
1455:
1456: END Clear_Price_Lheader;
1457:

Line 1454: g_db_Price_LHeader_rec := OE_Price_List_PUB.G_MISS_PRICE_List_REC;

1450: IS
1451: BEGIN
1452:
1453: g_Price_LHeader_rec := OE_Price_List_PUB.G_MISS_PRICE_List_REC;
1454: g_db_Price_LHeader_rec := OE_Price_List_PUB.G_MISS_PRICE_List_REC;
1455:
1456: END Clear_Price_Lheader;
1457:
1458: END OE_OE_Form_Price_Lheader;