APPS.OE_RETROBILL_PVT dependencies on OE_ORDER_PUB

Line 557: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.LINE_ADJ_TBL_TYPE) AS

553: (p_key_header_id IN NUMBER,
554: p_key_line_id IN NUMBER,
555: p_adjustment_level IN VARCHAR2,
556: x_retro_exists OUT NOCOPY BOOLEAN, --bug3738043
557: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.LINE_ADJ_TBL_TYPE) AS
558:
559: Cursor last_retrobill_line IS
560: Select max(line_id),
561: max(header_id)

Line 682: l_line_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;

678: AND list_line_id = p_list_line_id
679: AND line_id = p_line_id;
680: --bug3738043 end
681:
682: l_line_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
683: i PLS_INTEGER;
684: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
685: --bug3738043 start
686: l_new_price_adj_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

Line 911: Procedure Call_Process_Order(p_header_rec In Oe_Order_Pub.Header_Rec_Type,

907:
908: /**************************************************************
909: This procedure calls process order api to create headers and lines
910: ***************************************************************/
911: Procedure Call_Process_Order(p_header_rec In Oe_Order_Pub.Header_Rec_Type,
912: p_line_tbl In Oe_Order_Pub.Line_Tbl_Type,
913: x_created_header_id Out NOCOPY Number,
914: x_return_status Out NOCOPY Varchar2) As
915:

Line 912: p_line_tbl In Oe_Order_Pub.Line_Tbl_Type,

908: /**************************************************************
909: This procedure calls process order api to create headers and lines
910: ***************************************************************/
911: Procedure Call_Process_Order(p_header_rec In Oe_Order_Pub.Header_Rec_Type,
912: p_line_tbl In Oe_Order_Pub.Line_Tbl_Type,
913: x_created_header_id Out NOCOPY Number,
914: x_return_status Out NOCOPY Varchar2) As
915:
916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

912: p_line_tbl In Oe_Order_Pub.Line_Tbl_Type,
913: x_created_header_id Out NOCOPY Number,
914: x_return_status Out NOCOPY Varchar2) As
915:
916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

913: x_created_header_id Out NOCOPY Number,
914: x_return_status Out NOCOPY Varchar2) As
915:
916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
921: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

914: x_return_status Out NOCOPY Varchar2) As
915:
916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
921: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
922: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

Line 919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

915:
916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
921: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
922: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
923: l_line_rec OE_Order_PUB.Line_Rec_Type;

Line 920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

916: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
921: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
922: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
923: l_line_rec OE_Order_PUB.Line_Rec_Type;
924: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 921: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

917: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
921: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
922: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
923: l_line_rec OE_Order_PUB.Line_Rec_Type;
924: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
925: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 922: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

918: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
921: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
922: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
923: l_line_rec OE_Order_PUB.Line_Rec_Type;
924: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
925: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
926: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 923: l_line_rec OE_Order_PUB.Line_Rec_Type;

919: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
921: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
922: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
923: l_line_rec OE_Order_PUB.Line_Rec_Type;
924: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
925: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
926: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
927: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 924: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

920: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
921: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
922: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
923: l_line_rec OE_Order_PUB.Line_Rec_Type;
924: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
925: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
926: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
927: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
928: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 925: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

921: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
922: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
923: l_line_rec OE_Order_PUB.Line_Rec_Type;
924: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
925: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
926: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
927: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
928: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
929: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 926: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

922: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
923: l_line_rec OE_Order_PUB.Line_Rec_Type;
924: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
925: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
926: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
927: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
928: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
929: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
930: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 927: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

923: l_line_rec OE_Order_PUB.Line_Rec_Type;
924: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
925: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
926: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
927: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
928: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
929: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
930: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
931: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 928: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

924: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
925: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
926: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
927: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
928: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
929: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
930: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
931: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
932: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

Line 929: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

925: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
926: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
927: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
928: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
929: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
930: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
931: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
932: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
933: l_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

Line 930: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

926: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
927: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
928: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
929: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
930: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
931: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
932: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
933: l_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
934: l_return_status Varchar2(30);

Line 931: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

927: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
928: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
929: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
930: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
931: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
932: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
933: l_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
934: l_return_status Varchar2(30);
935: l_file_val Varchar2(30);

Line 932: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

928: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
929: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
930: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
931: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
932: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
933: l_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
934: l_return_status Varchar2(30);
935: l_file_val Varchar2(30);
936: x_msg_count number;

Line 933: l_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

929: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
930: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
931: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
932: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
933: l_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
934: l_return_status Varchar2(30);
935: l_file_val Varchar2(30);
936: x_msg_count number;
937: x_msg_data Varchar2(2000);

Line 1004: x_line_rec Out NOCOPY OE_ORDER_PUB.LINE_REC_TYPE) AS

1000: ***************************************************************/
1001: Procedure Prepare_Line(p_oline_rec In GROUP_LINES%ROWTYPE,
1002: p_retrobill_tbl In RETROBILL_TBL_TYPE,
1003: p_retrobill_request_rec In OE_RETROBILL_REQUESTS%ROWTYPE,
1004: x_line_rec Out NOCOPY OE_ORDER_PUB.LINE_REC_TYPE) AS
1005: l_retrobillable_qty NUMBER;
1006: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1007: stmt NUMBER:=7.1;
1008: Begin

Line 1265: x_header_rec OUT NOCOPY OE_ORDER_PUB.HEADER_REC_TYPE) AS

1261: p_sold_to_org_id IN NUMBER,
1262: p_transaction_curr_code IN VARCHAR2,
1263: p_conversion_type_code IN VARCHAR2,
1264: p_retrobill_request_rec IN OUT NOCOPY OE_RETROBILL_REQUESTS%ROWTYPE,
1265: x_header_rec OUT NOCOPY OE_ORDER_PUB.HEADER_REC_TYPE) AS
1266: l_order_type_id Number;
1267: l_pl_tbl QP_UTIL_PUB.price_list_tbl;
1268: l_valid_price_list_id Number;
1269: --internal private profile for debugging only.

Line 1483: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

1479: l_orig_usp Number:=0;
1480: l_orig_ulp Number:=0;
1481: l_retrobill_selling_price Number;
1482: l_retrobill_list_price Number;
1483: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1484: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1485: l_old_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1486: l_old_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1487: l_debit Varchar2(1);

Line 1484: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;

1480: l_orig_ulp Number:=0;
1481: l_retrobill_selling_price Number;
1482: l_retrobill_list_price Number;
1483: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1484: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1485: l_old_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1486: l_old_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1487: l_debit Varchar2(1);
1488: j Number:=0;

Line 1485: l_old_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

1481: l_retrobill_selling_price Number;
1482: l_retrobill_list_price Number;
1483: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1484: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1485: l_old_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1486: l_old_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1487: l_debit Varchar2(1);
1488: j Number:=0;
1489: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 1486: l_old_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;

1482: l_retrobill_list_price Number;
1483: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1484: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1485: l_old_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1486: l_old_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1487: l_debit Varchar2(1);
1488: j Number:=0;
1489: l_control_rec OE_GLOBALS.Control_Rec_Type;
1490: l_return_status Varchar2(15);

Line 1660: -- again due to the Oe_Order_Pub.Lines call.

1656: l_control_rec.clear_api_cache := FALSE;
1657: l_control_rec.clear_api_requests := FALSE;
1658:
1659: -- set the pricing recursion, so that pricing will not get triggered
1660: -- again due to the Oe_Order_Pub.Lines call.
1661: oe_globals.g_pricing_recursion := 'Y';
1662:
1663: Oe_Order_Pvt.Lines(p_validation_level=> FND_API.G_VALID_LEVEL_NONE,
1664: p_control_rec => l_control_rec,

Line 1841: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id

1837: , NULL --p_Line_Adj_rec.program_application_id
1838: , NULL --p_Line_Adj_rec.program_id
1839: , NULL --p_Line_Adj_rec.program_update_date
1840: , NULL --p_Line_Adj_rec.request_id
1841: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id
1842: , NULL --p_Line_Adj_rec.discount_id
1843: , NULL --p_Line_Adj_rec.discount_line_id
1844: , ldets.automatic_flag
1845: , NULL --p_Line_Adj_rec.percent

Line 2079: WHERE header_id=oe_order_pub.g_hdr.header_id

2075: and lines.line_id=adj.line_id
2076: --and ldets.process_code = QP_PREQ_GRP.G_STATUS_UPDATED
2077: and adj.retrobill_request_id = G_CURRENT_RETROBILL_REQUEST_ID
2078: )
2079: WHERE header_id=oe_order_pub.g_hdr.header_id
2080: and list_line_id in
2081: (select list_line_id
2082: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2
2083: where --lines2.process_status <> 'NOT_VALID'

Line 2219: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id

2215: , NULL --p_Line_Adj_rec.program_application_id
2216: , NULL --p_Line_Adj_rec.program_id
2217: , NULL --p_Line_Adj_rec.program_update_date
2218: , NULL --p_Line_Adj_rec.request_id
2219: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id
2220: , NULL --p_Line_Adj_rec.discount_id
2221: , NULL --p_Line_Adj_rec.discount_line_id
2222: , ldets.automatic_flag
2223: , NULL --p_Line_Adj_rec.percent

Line 2513: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id

2509: , NULL --p_Line_Adj_rec.program_application_id
2510: , NULL --p_Line_Adj_rec.program_id
2511: , NULL --p_Line_Adj_rec.program_update_date
2512: , NULL --p_Line_Adj_rec.request_id
2513: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id
2514: , NULL --p_Line_Adj_rec.discount_id
2515: , NULL --p_Line_Adj_rec.discount_line_id
2516: , ldets.automatic_flag
2517: , NULL --p_Line_Adj_rec.percent

Line 2661: AND header_id=oe_order_pub.g_hdr.header_id

2657: WHERE
2658: lines.line_index = ldets.line_index
2659: and lines.line_id= adj.line_id
2660: and adj.list_line_id=ldets.list_line_id)
2661: AND header_id=oe_order_pub.g_hdr.header_id
2662: AND nvl(applied_flag,'N') = 'Y'
2663: AND nvl(automatic_flag,'N') = 'Y'
2664: AND nvl(list_line_type_code,'TAX') NOT IN ('TAX', 'FREIGHT_CHARGE')
2665: ORDER BY line_id;

Line 2803: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;

2799: l_line_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
2800: l_arrange_line_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
2801: l_arrange_line_num_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
2802: l_retrobill_qty_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
2803: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
2804: l_return_status VARCHAR2(15);
2805: l_msg_count NUMBER;
2806: l_msg_data VARCHAR2(2000);
2807: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3038: l_header_rec OE_ORDER_PUB.HEADER_REC_TYPE;

3034: ) AS
3035: l_sold_to_org NUMBER;
3036: l_currency_code VARCHAR2(15);
3037: l_conversion_type VARCHAR2(30);
3038: l_header_rec OE_ORDER_PUB.HEADER_REC_TYPE;
3039: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
3040: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
3041: l_retrobill_request_id NUMBER;
3042: l_header_price_list_id NUMBER;

Line 3039: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

3035: l_sold_to_org NUMBER;
3036: l_currency_code VARCHAR2(15);
3037: l_conversion_type VARCHAR2(30);
3038: l_header_rec OE_ORDER_PUB.HEADER_REC_TYPE;
3039: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
3040: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
3041: l_retrobill_request_id NUMBER;
3042: l_header_price_list_id NUMBER;
3043: l_update_price_list Boolean:=FALSE;

Line 3040: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;

3036: l_currency_code VARCHAR2(15);
3037: l_conversion_type VARCHAR2(30);
3038: l_header_rec OE_ORDER_PUB.HEADER_REC_TYPE;
3039: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
3040: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
3041: l_retrobill_request_id NUMBER;
3042: l_header_price_list_id NUMBER;
3043: l_update_price_list Boolean:=FALSE;
3044: l_retrobill_request_rec OE_RETROBILL_REQUESTS%ROWTYPE;

Line 3632: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

3628: END IF;
3629: END Retrobill_Enabled;
3630:
3631: PROCEDURE Interface_Retrobilled_RMA
3632: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
3633: , p_header_rec IN OE_Order_PUB.Header_Rec_Type
3634: , x_return_status OUT NOCOPY VARCHAR2
3635: , x_result_out OUT NOCOPY VARCHAR2
3636: ) IS

Line 3633: , p_header_rec IN OE_Order_PUB.Header_Rec_Type

3629: END Retrobill_Enabled;
3630:
3631: PROCEDURE Interface_Retrobilled_RMA
3632: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
3633: , p_header_rec IN OE_Order_PUB.Header_Rec_Type
3634: , x_return_status OUT NOCOPY VARCHAR2
3635: , x_result_out OUT NOCOPY VARCHAR2
3636: ) IS
3637:

Line 3667: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

3663: and retro_line.orig_sys_document_ref = to_char(orig_line.header_id) --bug5553346
3664: and retro_line.orig_sys_line_ref = to_char(p_line_rec.reference_line_id) --bug5553346
3665: and retro_line.header_id = retro_header.header_id
3666: and retro_line.creation_date < p_line_rec.creation_date;
3667: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
3668: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
3669: i pls_integer;
3670: l_retrobilled_list_price number :=0;
3671: l_retrobilled_selling_price number:=0;

Line 3668: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;

3664: and retro_line.orig_sys_line_ref = to_char(p_line_rec.reference_line_id) --bug5553346
3665: and retro_line.header_id = retro_header.header_id
3666: and retro_line.creation_date < p_line_rec.creation_date;
3667: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
3668: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
3669: i pls_integer;
3670: l_retrobilled_list_price number :=0;
3671: l_retrobilled_selling_price number:=0;
3672: l_retro_adjusted_list_price number :=0;

Line 3931: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

3927: l_headers_processed NUMBER:= 0;
3928: l_requests_processed NUMBER:= 0;
3929:
3930: --rt moac start
3931: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3932: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
3933: l_control_rec OE_GLOBALS.Control_Rec_Type;
3934: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3935: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 3932: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

3928: l_requests_processed NUMBER:= 0;
3929:
3930: --rt moac start
3931: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3932: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
3933: l_control_rec OE_GLOBALS.Control_Rec_Type;
3934: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3935: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3936: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

Line 3934: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

3930: --rt moac start
3931: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3932: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
3933: l_control_rec OE_GLOBALS.Control_Rec_Type;
3934: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3935: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3936: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3937: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3938: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 3935: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

3931: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3932: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
3933: l_control_rec OE_GLOBALS.Control_Rec_Type;
3934: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3935: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3936: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3937: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3938: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3939: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 3936: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

3932: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
3933: l_control_rec OE_GLOBALS.Control_Rec_Type;
3934: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3935: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3936: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3937: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3938: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3939: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3940: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 3937: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

3933: l_control_rec OE_GLOBALS.Control_Rec_Type;
3934: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3935: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3936: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3937: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3938: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3939: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3940: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3941: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 3938: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

3934: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
3935: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3936: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3937: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3938: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3939: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3940: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3941: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3942: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

Line 3939: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

3935: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
3936: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3937: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3938: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3939: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3940: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3941: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3942: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3943: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 3940: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

3936: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
3937: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3938: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3939: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3940: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3941: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3942: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3943: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3944: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 3941: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

3937: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3938: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3939: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3940: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3941: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3942: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3943: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3944: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3945: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 3942: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

3938: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3939: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3940: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3941: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3942: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3943: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3944: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3945: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3946: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 3943: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

3939: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3940: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3941: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3942: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3943: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3944: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3945: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3946: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3947: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 3944: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

3940: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
3941: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3942: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3943: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3944: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3945: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3946: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3947: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3948: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 3945: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

3941: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
3942: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3943: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3944: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3945: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3946: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3947: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3948: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3949: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 3946: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

3942: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
3943: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3944: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3945: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3946: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3947: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3948: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3949: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3950: --rt moac end

Line 3947: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

3943: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3944: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3945: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3946: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3947: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3948: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3949: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3950: --rt moac end
3951:

Line 3948: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

3944: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3945: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3946: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3947: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3948: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3949: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3950: --rt moac end
3951:
3952: BEGIN

Line 3949: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

3945: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3946: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3947: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3948: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3949: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3950: --rt moac end
3951:
3952: BEGIN
3953: FOR l_retrobill_header_rec in retrobill_header(p_retrobill_request_id) LOOP

Line 3960: Oe_Order_Pub.Delete_Order

3956: IF(l_retrobill_header_rec.booked_flag = 'N') THEN
3957:
3958: --rt moac directly calling oe_order_pvt.process_order with delete operation since the context has already been set in procedure oe_retrobill_purge
3959: /*
3960: Oe_Order_Pub.Delete_Order
3961: (
3962: p_header_id =>l_retrobill_header_rec.header_id,
3963: x_return_status =>l_return_status,
3964: x_msg_count =>l_msg_count,

Line 3968: l_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

3964: x_msg_count =>l_msg_count,
3965: x_msg_data =>l_msg_data
3966: );
3967: */
3968: l_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
3969: l_header_rec.header_id := l_retrobill_header_rec.header_id;
3970: l_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3971:
3972: OE_ORDER_PVT.Process_order

Line 4345: p_line_rec IN OE_Order_Pub.Line_Rec_Type

4341: against Retrobill Bill only lines we query adjustments of Retrobill bill only Lines
4342: *********************************************************************************************************************************/
4343: PROCEDURE Get_Line_Adjustments
4344: (
4345: p_line_rec IN OE_Order_Pub.Line_Rec_Type
4346: ,x_line_adjustments OUT NOCOPY OE_Header_Adj_Util.Line_Adjustments_Tab_Type
4347: )
4348: IS
4349: --