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_GLOBALS

Line 698: l_new_price_adj_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

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;
699: k PLS_INTEGER := 1 ;
700: l_found BOOLEAN := FALSE;
701: l_dummy NUMBER;
702: l_retro_exists BOOLEAN;

Line 766: l_line_adj_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;

762: END IF;
763:
764: l_line_adj_tbl(i).line_id := p_line_id;
765: l_line_adj_tbl(i).header_id := p_header_id;
766: l_line_adj_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
767:
768: SELECT Oe_Price_Adjustments_S.Nextval
769: INTO l_line_adj_tbl(i).price_adjustment_id
770: FROM dual;

Line 965: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF

961: , p_init_msg_list => FND_API.G_FALSE
962: , x_return_status => x_return_status
963: , x_msg_count => x_msg_count
964: , x_msg_data => x_msg_data
965: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
966: -- , p_validation_level => FND_API.G_VALID_LEVEL_NONE
967: , p_x_header_rec => l_x_header_rec
968: , p_x_Header_Adj_tbl => l_x_Header_Adj_tbl
969: , p_x_Header_Scredit_tbl => l_x_Header_Scredit_tbl

Line 1196: x_line_rec.operation:= OE_Globals.G_OPR_CREATE;

1192: x_line_rec.pricing_quantity:=NULL;
1193: x_line_rec.orig_sys_document_ref:= to_char(p_oline_rec.header_id); -- p_oline_rec.header_id; --commented for bug#7665009
1194: x_line_rec.orig_sys_line_ref:= to_char(p_oline_rec.line_id); -- p_oline_rec.line_id; --commented for bug#7665009
1195: x_line_rec.calculate_price_flag:='Y';
1196: x_line_rec.operation:= OE_Globals.G_OPR_CREATE;
1197: x_line_rec.flow_status_code:='ENTERED';
1198: --SET line category code as 'RETURN' first because this is the most common case
1199: --line category code will be reset to 'ORDER' by OEXVOPRB.pls if it ends up to be
1200: --not a 'RETURN' line.

Line 1296: x_header_rec.operation :=OE_Globals.G_OPR_CREATE;

1292: G_INT_USE_ANY_VALID_PL := nvl(FND_PROFILE.VALUE('ONT_USE_ANY_VALID_PL'),'N');
1293: x_header_rec.sold_to_org_id := p_sold_to_org_id;
1294: x_header_rec.transactional_curr_code:=p_transaction_curr_code;
1295: x_header_rec.conversion_type_code:=p_conversion_type_code;
1296: x_header_rec.operation :=OE_Globals.G_OPR_CREATE;
1297: x_header_rec.ordered_date :=SYSDATE;
1298: --Should pric list get defaulted? Or just plain copy?
1299: x_header_rec.price_list_id :=FND_API.G_MISS_NUM;
1300: x_header_rec.header_id :=FND_API.G_MISS_NUM;

Line 1353: l_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

1349: oe_debug_pub.add('Retro:currency:'||x_header_rec.transactional_curr_code);
1350: End;
1351:
1352: PROCEDURE Insert_Id(p_retrobill_tbl IN RETROBILL_TBL_TYPE) As
1353: l_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
1354: l_value_tbl OE_GLOBALS.NUMBER_TBL_TYPE; --store the index of p_retrobill_tbl for line_id
1355: i NUMBER;
1356: j NUMBER:=1;
1357: Begin

Line 1354: l_value_tbl OE_GLOBALS.NUMBER_TBL_TYPE; --store the index of p_retrobill_tbl for line_id

1350: End;
1351:
1352: PROCEDURE Insert_Id(p_retrobill_tbl IN RETROBILL_TBL_TYPE) As
1353: l_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
1354: l_value_tbl OE_GLOBALS.NUMBER_TBL_TYPE; --store the index of p_retrobill_tbl for line_id
1355: i NUMBER;
1356: j NUMBER:=1;
1357: Begin
1358:

Line 1779: l_line_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

1775:
1776: l_deleted_line NUMBER :=NULL;
1777: l_deleted_line_hdr NUMBER :=NULL;
1778: k PLS_INTEGER:=1;
1779: l_line_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
1780: l_line_num_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
1781: l_usp_sum Number:=0;
1782: l_ulp_sum Number:=0;
1783: l_orig_usp Number:=0;

Line 1780: l_line_num_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

1776: l_deleted_line NUMBER :=NULL;
1777: l_deleted_line_hdr NUMBER :=NULL;
1778: k PLS_INTEGER:=1;
1779: l_line_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
1780: l_line_num_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
1781: l_usp_sum Number:=0;
1782: l_ulp_sum Number:=0;
1783: l_orig_usp Number:=0;
1784: l_orig_ulp Number:=0;

Line 1793: l_control_rec OE_GLOBALS.Control_Rec_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);
1795: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1796: --skubendr{
1797: l_inventory_item_id_previous NUMBER;

Line 1926: l_line_rec.operation :=OE_GLOBALS.G_OPR_UPDATE;

1922: l_line_rec.line_category_code :='ORDER';
1923: l_line_rec.calculate_price_flag :='N';
1924: --set following to miss char such that redefault can take place.
1925: -- l_line_rec.line_type_id :=FND_API.G_MISS_NUM; -- bug# 8751523 : Commented this assignment
1926: l_line_rec.operation :=OE_GLOBALS.G_OPR_UPDATE;
1927: l_debit := 'Y';
1928: j:=j+1;
1929:
1930: -- oe_default_line.attributes(p_x_line_rec => l_line_rec, p_old_line_rec => l_old_line_rec); --- -- bug# 8751523: Commented this call

Line 1997: oe_globals.g_pricing_recursion := 'Y';

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,
2001: p_x_line_tbl => l_line_tbl,

Line 2006: oe_globals.g_pricing_recursion := 'N';

2002: p_x_old_line_tbl => l_old_line_tbl,
2003: x_return_status => l_return_status);
2004:
2005: -- Reset the pricing recursion, so that pricing will get triggered after Oe_Order_Pvt.Lines call
2006: oe_globals.g_pricing_recursion := 'N';
2007: --deletion occured, need to resequence line number.
2008: END IF;
2009:
2010: IF l_deleted_line_hdr IS NOT NULL THEN

Line 3136: l_header_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

3132: upd_index PLS_INTEGER:=1;
3133: n_index PLS_INTEGER:=1;
3134:
3135:
3136: l_header_id_tbl OE_GLOBALS.NUMBER_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;

Line 3137: l_line_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

3133: n_index PLS_INTEGER:=1;
3134:
3135:
3136: l_header_id_tbl OE_GLOBALS.NUMBER_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;

Line 3138: l_arrange_line_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

3134:
3135:
3136: l_header_id_tbl OE_GLOBALS.NUMBER_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);

Line 3139: l_arrange_line_num_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

3135:
3136: l_header_id_tbl OE_GLOBALS.NUMBER_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;

Line 3140: l_retrobill_qty_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

3136: l_header_id_tbl OE_GLOBALS.NUMBER_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);

Line 3389: l_to_be_exe_hdr_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

3385: i PLS_INTEGER:=1;
3386: l_visited Boolean:=FALSE;
3387: stmt NUMBER;
3388: lx_header_id NUMBER;
3389: l_to_be_exe_hdr_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
3390: l_msg_count NUMBER;
3391: l_msg_data VARCHAR2(5000);
3392: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3393: lx_return_status VARCHAR2(15);

Line 3546: l_Line_price_Att_rec.operation := OE_GLOBALS.G_OPR_CREATE;

3542: Prepare_Line_Pricing_Attribs(p_line_id => l.line_id,
3543: x_Line_price_Att_rec => l_Line_price_Att_rec,
3544: x_row_count => l_row_count);
3545: IF l_row_count > 0 THEN
3546: l_Line_price_Att_rec.operation := OE_GLOBALS.G_OPR_CREATE;
3547: END IF;
3548: --8736629
3549:
3550:

Line 4358: l_control_rec OE_GLOBALS.Control_Rec_Type;

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;
4362: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 4395: l_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;

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
4398: ( p_api_version_number => 1.0
4399: , p_init_msg_list => FND_API.G_TRUE

Line 4544: AND b.language = oe_globals.g_lang

4540: , b.message_text
4541: FROM oe_processing_msgs a, oe_processing_msgs_tl b
4542: WHERE a.request_id = l_concurrent_id
4543: AND a.transaction_id = b.transaction_id
4544: AND b.language = oe_globals.g_lang
4545: ORDER BY a.order_source_id, a.original_sys_document_ref, a.change_sequence;
4546:
4547:
4548: BEGIN