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_RETROBILL_PVT dependencies on OE_ORDER_PUB

Line 568: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.LINE_ADJ_TBL_TYPE) AS

564: (p_key_header_id IN NUMBER,
565: p_key_line_id IN NUMBER,
566: p_adjustment_level IN VARCHAR2,
567: x_retro_exists OUT NOCOPY BOOLEAN, --bug3738043
568: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.LINE_ADJ_TBL_TYPE) AS
569:
570: Cursor last_retrobill_line IS
571: Select max(line_id),
572: max(header_id)

Line 694: l_line_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;

690: AND list_line_id = p_list_line_id
691: AND line_id = p_line_id;
692: --bug3738043 end
693:
694: l_line_adj_tbl OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
695: i PLS_INTEGER;
696: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
697: --bug3738043 start
698: l_new_price_adj_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

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

919:
920: /**************************************************************
921: This procedure calls process order api to create headers and lines
922: ***************************************************************/
923: Procedure Call_Process_Order(p_header_rec In Oe_Order_Pub.Header_Rec_Type,
924: p_line_tbl In Oe_Order_Pub.Line_Tbl_Type,
925: p_Line_price_Att_tbl IN Oe_Order_Pub.Line_Price_Att_Tbl_Type, -- 8736629
926: x_created_header_id Out NOCOPY Number,
927: x_return_status Out NOCOPY Varchar2) As

Line 924: p_line_tbl In Oe_Order_Pub.Line_Tbl_Type,

920: /**************************************************************
921: This procedure calls process order api to create headers and lines
922: ***************************************************************/
923: Procedure Call_Process_Order(p_header_rec In Oe_Order_Pub.Header_Rec_Type,
924: p_line_tbl In Oe_Order_Pub.Line_Tbl_Type,
925: p_Line_price_Att_tbl IN Oe_Order_Pub.Line_Price_Att_Tbl_Type, -- 8736629
926: x_created_header_id Out NOCOPY Number,
927: x_return_status Out NOCOPY Varchar2) As
928:

Line 925: p_Line_price_Att_tbl IN Oe_Order_Pub.Line_Price_Att_Tbl_Type, -- 8736629

921: This procedure calls process order api to create headers and lines
922: ***************************************************************/
923: Procedure Call_Process_Order(p_header_rec In Oe_Order_Pub.Header_Rec_Type,
924: p_line_tbl In Oe_Order_Pub.Line_Tbl_Type,
925: p_Line_price_Att_tbl IN Oe_Order_Pub.Line_Price_Att_Tbl_Type, -- 8736629
926: x_created_header_id Out NOCOPY Number,
927: x_return_status Out NOCOPY Varchar2) As
928:
929: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 929: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

925: p_Line_price_Att_tbl IN Oe_Order_Pub.Line_Price_Att_Tbl_Type, -- 8736629
926: x_created_header_id Out NOCOPY Number,
927: x_return_status Out NOCOPY Varchar2) As
928:
929: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
930: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
931: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
932: --l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type; -- 8736629
933: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 930: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

926: x_created_header_id Out NOCOPY Number,
927: x_return_status Out NOCOPY Varchar2) As
928:
929: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
930: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
931: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
932: --l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type; -- 8736629
933: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
934: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 931: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

927: x_return_status Out NOCOPY Varchar2) As
928:
929: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
930: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
931: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
932: --l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type; -- 8736629
933: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
934: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
935: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

Line 932: --l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type; -- 8736629

928:
929: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
930: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
931: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
932: --l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type; -- 8736629
933: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
934: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
935: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
936: l_line_rec OE_Order_PUB.Line_Rec_Type;

Line 933: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

929: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
930: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
931: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
932: --l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type; -- 8736629
933: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
934: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
935: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
936: l_line_rec OE_Order_PUB.Line_Rec_Type;
937: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 934: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

930: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
931: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
932: --l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type; -- 8736629
933: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
934: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
935: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
936: l_line_rec OE_Order_PUB.Line_Rec_Type;
937: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
938: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 935: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

931: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
932: --l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type; -- 8736629
933: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
934: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
935: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
936: l_line_rec OE_Order_PUB.Line_Rec_Type;
937: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
938: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
939: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 936: l_line_rec OE_Order_PUB.Line_Rec_Type;

932: --l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type; -- 8736629
933: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
934: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
935: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
936: l_line_rec OE_Order_PUB.Line_Rec_Type;
937: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
938: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
939: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
940: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 937: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

933: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
934: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
935: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
936: l_line_rec OE_Order_PUB.Line_Rec_Type;
937: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
938: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
939: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
940: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
941: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 938: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

934: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
935: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
936: l_line_rec OE_Order_PUB.Line_Rec_Type;
937: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
938: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
939: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
940: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
941: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
942: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 939: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

935: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
936: l_line_rec OE_Order_PUB.Line_Rec_Type;
937: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
938: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
939: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
940: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
941: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
942: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
943: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 940: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

936: l_line_rec OE_Order_PUB.Line_Rec_Type;
937: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
938: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
939: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
940: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
941: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
942: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
943: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
944: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 941: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

937: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
938: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
939: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
940: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
941: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
942: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
943: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
944: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
945: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

Line 942: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

938: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
939: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
940: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
941: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
942: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
943: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
944: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
945: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
946: l_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

Line 943: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

939: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
940: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
941: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
942: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
943: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
944: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
945: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
946: l_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
947: l_x_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type; -- 8736629

Line 944: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

940: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
941: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
942: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
943: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
944: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
945: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
946: l_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
947: l_x_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type; -- 8736629
948: l_return_status Varchar2(30);

Line 945: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

941: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
942: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
943: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
944: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
945: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
946: l_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
947: l_x_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type; -- 8736629
948: l_return_status Varchar2(30);
949: l_file_val Varchar2(30);

Line 946: l_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

942: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
943: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
944: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
945: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
946: l_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
947: l_x_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type; -- 8736629
948: l_return_status Varchar2(30);
949: l_file_val Varchar2(30);
950: x_msg_count number;

Line 947: l_x_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type; -- 8736629

943: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
944: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
945: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
946: l_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
947: l_x_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type; -- 8736629
948: l_return_status Varchar2(30);
949: l_file_val Varchar2(30);
950: x_msg_count number;
951: x_msg_data Varchar2(2000);

Line 1020: x_line_rec Out NOCOPY OE_ORDER_PUB.LINE_REC_TYPE) AS

1016: ***************************************************************/
1017: Procedure Prepare_Line(p_oline_rec In GROUP_LINES%ROWTYPE,
1018: p_retrobill_tbl In RETROBILL_TBL_TYPE,
1019: p_retrobill_request_rec In OE_RETROBILL_REQUESTS%ROWTYPE,
1020: x_line_rec Out NOCOPY OE_ORDER_PUB.LINE_REC_TYPE) AS
1021: l_retrobillable_qty NUMBER;
1022: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1023: stmt NUMBER:=7.1;
1024: Begin

Line 1284: x_header_rec OUT NOCOPY OE_ORDER_PUB.HEADER_REC_TYPE) AS

1280: p_sold_to_org_id IN NUMBER,
1281: p_transaction_curr_code IN VARCHAR2,
1282: p_conversion_type_code IN VARCHAR2,
1283: p_retrobill_request_rec IN OUT NOCOPY OE_RETROBILL_REQUESTS%ROWTYPE,
1284: x_header_rec OUT NOCOPY OE_ORDER_PUB.HEADER_REC_TYPE) AS
1285: l_order_type_id Number;
1286: l_pl_tbl QP_UTIL_PUB.price_list_tbl;
1287: l_valid_price_list_id Number;
1288: --internal private profile for debugging only.

Line 1388: x_Line_price_Att_rec Out NOCOPY Oe_Order_Pub.Line_Price_Att_Rec_Type,

1384: This procedure was added for bug 8736629. This procedure prepares
1385: the pricing attributes table for the line level
1386: ***************************************************************/
1387: Procedure Prepare_Line_Pricing_Attribs(p_line_id In NUMBER,
1388: x_Line_price_Att_rec Out NOCOPY Oe_Order_Pub.Line_Price_Att_Rec_Type,
1389: x_row_count OUT NOCOPY NUMBER) AS
1390:
1391: l_row_count NUMBER := 0;
1392: Begin

Line 1787: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

1783: l_orig_usp Number:=0;
1784: l_orig_ulp Number:=0;
1785: l_retrobill_selling_price Number;
1786: l_retrobill_list_price Number;
1787: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1788: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1789: l_old_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1790: l_old_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1791: l_debit Varchar2(1);

Line 1788: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;

1784: l_orig_ulp Number:=0;
1785: l_retrobill_selling_price Number;
1786: l_retrobill_list_price Number;
1787: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1788: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1789: l_old_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1790: l_old_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1791: l_debit Varchar2(1);
1792: j Number:=0;

Line 1789: l_old_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

1785: l_retrobill_selling_price Number;
1786: l_retrobill_list_price Number;
1787: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1788: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1789: l_old_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1790: l_old_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1791: l_debit Varchar2(1);
1792: j Number:=0;
1793: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 1790: l_old_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;

1786: l_retrobill_list_price Number;
1787: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1788: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1789: l_old_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1790: l_old_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1791: l_debit Varchar2(1);
1792: j Number:=0;
1793: l_control_rec OE_GLOBALS.Control_Rec_Type;
1794: l_return_status Varchar2(15);

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

1992: l_control_rec.clear_api_cache := FALSE;
1993: l_control_rec.clear_api_requests := FALSE;
1994:
1995: -- set the pricing recursion, so that pricing will not get triggered
1996: -- again due to the Oe_Order_Pub.Lines call.
1997: oe_globals.g_pricing_recursion := 'Y';
1998:
1999: Oe_Order_Pvt.Lines(p_validation_level=> FND_API.G_VALID_LEVEL_NONE,
2000: p_control_rec => l_control_rec,

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

2175: , NULL --p_Line_Adj_rec.program_application_id
2176: , NULL --p_Line_Adj_rec.program_id
2177: , NULL --p_Line_Adj_rec.program_update_date
2178: , NULL --p_Line_Adj_rec.request_id
2179: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id
2180: , NULL --p_Line_Adj_rec.discount_id
2181: , NULL --p_Line_Adj_rec.discount_line_id
2182: , ldets.automatic_flag
2183: , NULL --p_Line_Adj_rec.percent

Line 2417: WHERE header_id=oe_order_pub.g_hdr.header_id

2413: and lines.line_id=adj.line_id
2414: --and ldets.process_code = QP_PREQ_GRP.G_STATUS_UPDATED
2415: and adj.retrobill_request_id = G_CURRENT_RETROBILL_REQUEST_ID
2416: )
2417: WHERE header_id=oe_order_pub.g_hdr.header_id
2418: and list_line_id in
2419: (select list_line_id
2420: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2
2421: where --lines2.process_status <> 'NOT_VALID'

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

2553: , NULL --p_Line_Adj_rec.program_application_id
2554: , NULL --p_Line_Adj_rec.program_id
2555: , NULL --p_Line_Adj_rec.program_update_date
2556: , NULL --p_Line_Adj_rec.request_id
2557: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id
2558: , NULL --p_Line_Adj_rec.discount_id
2559: , NULL --p_Line_Adj_rec.discount_line_id
2560: , ldets.automatic_flag
2561: , NULL --p_Line_Adj_rec.percent

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

2847: , NULL --p_Line_Adj_rec.program_application_id
2848: , NULL --p_Line_Adj_rec.program_id
2849: , NULL --p_Line_Adj_rec.program_update_date
2850: , NULL --p_Line_Adj_rec.request_id
2851: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id
2852: , NULL --p_Line_Adj_rec.discount_id
2853: , NULL --p_Line_Adj_rec.discount_line_id
2854: , ldets.automatic_flag
2855: , NULL --p_Line_Adj_rec.percent

Line 2999: AND header_id=oe_order_pub.g_hdr.header_id

2995: WHERE
2996: lines.line_index = ldets.line_index
2997: and lines.line_id= adj.line_id
2998: and adj.list_line_id=ldets.list_line_id)
2999: AND header_id=oe_order_pub.g_hdr.header_id
3000: AND nvl(applied_flag,'N') = 'Y'
3001: AND nvl(automatic_flag,'N') = 'Y'
3002: AND nvl(list_line_type_code,'TAX') NOT IN ('TAX', 'FREIGHT_CHARGE')
3003: ORDER BY line_id;

Line 3141: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;

3137: l_line_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
3138: l_arrange_line_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
3139: l_arrange_line_num_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
3140: l_retrobill_qty_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
3141: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
3142: l_return_status VARCHAR2(15);
3143: l_msg_count NUMBER;
3144: l_msg_data VARCHAR2(2000);
3145: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3377: l_header_rec OE_ORDER_PUB.HEADER_REC_TYPE;

3373: ) AS
3374: l_sold_to_org NUMBER;
3375: l_currency_code VARCHAR2(15);
3376: l_conversion_type VARCHAR2(30);
3377: l_header_rec OE_ORDER_PUB.HEADER_REC_TYPE;
3378: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
3379: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
3380: l_retrobill_request_id NUMBER;
3381: l_header_price_list_id NUMBER;

Line 3378: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

3374: l_sold_to_org NUMBER;
3375: l_currency_code VARCHAR2(15);
3376: l_conversion_type VARCHAR2(30);
3377: l_header_rec OE_ORDER_PUB.HEADER_REC_TYPE;
3378: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
3379: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
3380: l_retrobill_request_id NUMBER;
3381: l_header_price_list_id NUMBER;
3382: l_update_price_list Boolean:=FALSE;

Line 3379: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;

3375: l_currency_code VARCHAR2(15);
3376: l_conversion_type VARCHAR2(30);
3377: l_header_rec OE_ORDER_PUB.HEADER_REC_TYPE;
3378: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
3379: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
3380: l_retrobill_request_id NUMBER;
3381: l_header_price_list_id NUMBER;
3382: l_update_price_list Boolean:=FALSE;
3383: l_retrobill_request_rec OE_RETROBILL_REQUESTS%ROWTYPE;

Line 3400: l_Line_price_Att_rec Oe_Order_Pub.Line_Price_Att_Rec_Type; -- 8736629

3396: l_book_line_count NUMBER;
3397: l_header_deleted BOOLEAN;
3398: --bug5003256 end
3399: l_cust_po_number VARCHAR2(50); -- Bug# 6603714
3400: l_Line_price_Att_rec Oe_Order_Pub.Line_Price_Att_Rec_Type; -- 8736629
3401: l_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type; -- 8736629
3402: l_row_count NUMBER; -- 8736629
3403: Begin
3404: stmt:=1;

Line 3401: l_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type; -- 8736629

3397: l_header_deleted BOOLEAN;
3398: --bug5003256 end
3399: l_cust_po_number VARCHAR2(50); -- Bug# 6603714
3400: l_Line_price_Att_rec Oe_Order_Pub.Line_Price_Att_Rec_Type; -- 8736629
3401: l_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type; -- 8736629
3402: l_row_count NUMBER; -- 8736629
3403: Begin
3404: stmt:=1;
3405: x_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 4033: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

4029: END IF;
4030: END Retrobill_Enabled;
4031:
4032: PROCEDURE Interface_Retrobilled_RMA
4033: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
4034: , p_header_rec IN OE_Order_PUB.Header_Rec_Type
4035: , x_return_status OUT NOCOPY VARCHAR2
4036: , x_result_out OUT NOCOPY VARCHAR2
4037: ) IS

Line 4034: , p_header_rec IN OE_Order_PUB.Header_Rec_Type

4030: END Retrobill_Enabled;
4031:
4032: PROCEDURE Interface_Retrobilled_RMA
4033: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
4034: , p_header_rec IN OE_Order_PUB.Header_Rec_Type
4035: , x_return_status OUT NOCOPY VARCHAR2
4036: , x_result_out OUT NOCOPY VARCHAR2
4037: ) IS
4038:

Line 4068: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

4064: and retro_line.orig_sys_document_ref = to_char(orig_line.header_id) --bug5553346
4065: and retro_line.orig_sys_line_ref = to_char(p_line_rec.reference_line_id) --bug5553346
4066: and retro_line.header_id = retro_header.header_id
4067: and retro_line.creation_date < p_line_rec.creation_date;
4068: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
4069: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
4070: i pls_integer;
4071: l_retrobilled_list_price number :=0;
4072: l_retrobilled_selling_price number:=0;

Line 4069: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;

4065: and retro_line.orig_sys_line_ref = to_char(p_line_rec.reference_line_id) --bug5553346
4066: and retro_line.header_id = retro_header.header_id
4067: and retro_line.creation_date < p_line_rec.creation_date;
4068: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
4069: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
4070: i pls_integer;
4071: l_retrobilled_list_price number :=0;
4072: l_retrobilled_selling_price number:=0;
4073: l_retro_adjusted_list_price number :=0;

Line 4356: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

4352: l_headers_processed NUMBER:= 0;
4353: l_requests_processed NUMBER:= 0;
4354:
4355: --rt moac start
4356: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4357: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
4358: l_control_rec OE_GLOBALS.Control_Rec_Type;
4359: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
4360: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 4357: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

4353: l_requests_processed NUMBER:= 0;
4354:
4355: --rt moac start
4356: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4357: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
4358: l_control_rec OE_GLOBALS.Control_Rec_Type;
4359: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
4360: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
4361: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

Line 4359: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

4355: --rt moac start
4356: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4357: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
4358: l_control_rec OE_GLOBALS.Control_Rec_Type;
4359: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
4360: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
4361: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
4362: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4363: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 4360: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

4356: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4357: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
4358: l_control_rec OE_GLOBALS.Control_Rec_Type;
4359: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
4360: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
4361: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
4362: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4363: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4364: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 4361: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;

4357: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
4358: l_control_rec OE_GLOBALS.Control_Rec_Type;
4359: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
4360: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
4361: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
4362: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4363: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4364: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4365: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 4362: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4358: l_control_rec OE_GLOBALS.Control_Rec_Type;
4359: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
4360: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
4361: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
4362: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4363: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4364: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4365: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4366: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 4363: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

4359: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
4360: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
4361: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
4362: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4363: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4364: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4365: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4366: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4367: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

Line 4364: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

4360: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
4361: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
4362: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4363: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4364: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4365: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4366: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4367: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
4368: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 4365: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

4361: l_line_adj_out_tbl oe_order_pub.line_Adj_Tbl_Type;
4362: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4363: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4364: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4365: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4366: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4367: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
4368: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4369: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 4366: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

4362: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4363: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4364: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4365: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4366: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4367: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
4368: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4369: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4370: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 4367: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;

4363: l_Header_Scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4364: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4365: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4366: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4367: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
4368: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4369: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4370: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4371: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 4368: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

4364: l_Line_Scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4365: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4366: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4367: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
4368: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4369: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4370: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4371: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4372: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 4369: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

4365: l_Header_Payment_out_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4366: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4367: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
4368: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4369: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4370: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4371: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4372: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4373: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 4370: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

4366: l_Line_Payment_out_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4367: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
4368: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4369: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4370: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4371: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4372: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4373: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4374: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 4371: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

4367: l_action_request_out_tbl OE_Order_PUB.request_tbl_type;
4368: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4369: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4370: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4371: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4372: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4373: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4374: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4375: --rt moac end

Line 4372: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

4368: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4369: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4370: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4371: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4372: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4373: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4374: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4375: --rt moac end
4376:

Line 4373: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

4369: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4370: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4371: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4372: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4373: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4374: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4375: --rt moac end
4376:
4377: BEGIN

Line 4374: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

4370: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4371: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4372: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4373: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4374: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4375: --rt moac end
4376:
4377: BEGIN
4378: FOR l_retrobill_header_rec in retrobill_header(p_retrobill_request_id) LOOP

Line 4385: Oe_Order_Pub.Delete_Order

4381: IF(l_retrobill_header_rec.booked_flag = 'N') THEN
4382:
4383: --rt moac directly calling oe_order_pvt.process_order with delete operation since the context has already been set in procedure oe_retrobill_purge
4384: /*
4385: Oe_Order_Pub.Delete_Order
4386: (
4387: p_header_id =>l_retrobill_header_rec.header_id,
4388: x_return_status =>l_return_status,
4389: x_msg_count =>l_msg_count,

Line 4393: l_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

4389: x_msg_count =>l_msg_count,
4390: x_msg_data =>l_msg_data
4391: );
4392: */
4393: l_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
4394: l_header_rec.header_id := l_retrobill_header_rec.header_id;
4395: l_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;
4396:
4397: OE_ORDER_PVT.Process_order

Line 4770: p_line_rec IN OE_Order_Pub.Line_Rec_Type

4766: against Retrobill Bill only lines we query adjustments of Retrobill bill only Lines
4767: *********************************************************************************************************************************/
4768: PROCEDURE Get_Line_Adjustments
4769: (
4770: p_line_rec IN OE_Order_Pub.Line_Rec_Type
4771: ,x_line_adjustments OUT NOCOPY OE_Header_Adj_Util.Line_Adjustments_Tab_Type
4772: )
4773: IS
4774: --