DBA Data[Home] [Help]

APPS.OE_LINE_REPRICE dependencies on OE_ORDER_PUB

Line 9: p_line_rec IN OE_Order_Pub.Line_Rec_Type

5:
6:
7: PROCEDURE Reprice_Line
8: (
9: p_line_rec IN OE_Order_Pub.Line_Rec_Type
10: , p_Repricing_date IN VARCHAR2
11: , p_Repricing_event IN VARCHAR2
12: , p_Honor_Price_Flag IN VARCHAR2
13: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 25: l_x_line_tbl OE_Order_Pub.Line_Tbl_Type;

21:
22: l_control_rec OE_GLOBALS.Control_Rec_Type;
23: l_return_status VARCHAR2(1);
24: l_Price_Control_Rec QP_PREQ_GRP.control_record_type;
25: l_x_line_tbl OE_Order_Pub.Line_Tbl_Type;
26: l_line_rec OE_Order_Pub.Line_Rec_Type := p_line_rec;
27: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
28: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
29: l_price_flag VARCHAR2(1);

Line 26: l_line_rec OE_Order_Pub.Line_Rec_Type := p_line_rec;

22: l_control_rec OE_GLOBALS.Control_Rec_Type;
23: l_return_status VARCHAR2(1);
24: l_Price_Control_Rec QP_PREQ_GRP.control_record_type;
25: l_x_line_tbl OE_Order_Pub.Line_Tbl_Type;
26: l_line_rec OE_Order_Pub.Line_Rec_Type := p_line_rec;
27: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
28: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
29: l_price_flag VARCHAR2(1);
30:

Line 27: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

23: l_return_status VARCHAR2(1);
24: l_Price_Control_Rec QP_PREQ_GRP.control_record_type;
25: l_x_line_tbl OE_Order_Pub.Line_Tbl_Type;
26: l_line_rec OE_Order_Pub.Line_Rec_Type := p_line_rec;
27: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
28: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
29: l_price_flag VARCHAR2(1);
30:
31: --

Line 28: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;

24: l_Price_Control_Rec QP_PREQ_GRP.control_record_type;
25: l_x_line_tbl OE_Order_Pub.Line_Tbl_Type;
26: l_line_rec OE_Order_Pub.Line_Rec_Type := p_line_rec;
27: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
28: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
29: l_price_flag VARCHAR2(1);
30:
31: --
32: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 269: l_line_rec OE_Order_Pub.Line_Rec_Type;

265: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
266: )
267: IS
268:
269: l_line_rec OE_Order_Pub.Line_Rec_Type;
270: l_return_status VARCHAR2(1);
271: l_item_key VARCHAR2(240);
272: l_Repricing_date_attr VARCHAR2(30):='REPRICE_DATE';
273: l_Repricing_date VARCHAR2(30);