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 287: l_line_rec OE_Order_Pub.Line_Rec_Type;

283: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
284: )
285: IS
286:
287: l_line_rec OE_Order_Pub.Line_Rec_Type;
288: l_return_status VARCHAR2(1);
289: l_item_key VARCHAR2(240);
290: l_Repricing_date_attr VARCHAR2(30):='REPRICE_DATE';
291: l_Repricing_date VARCHAR2(30);

Line 305: l_header_rec OE_Order_PUB.Header_Rec_Type;

301: l_msg_count NUMBER := 0;
302: l_msg_data VARCHAR2(2000);
303: l_result_out VARCHAR2(30);
304: l_cc_rev_reauth_code VARCHAR2(30);
305: l_header_rec OE_Order_PUB.Header_Rec_Type;
306: --CC Reversal ER#16014135 End
307: BEGIN
308:
309: IF l_debug_level > 0 THEN