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 686: l_new_price_adj_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

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;
687: k PLS_INTEGER := 1 ;
688: l_found BOOLEAN := FALSE;
689: l_dummy NUMBER;
690: l_retro_exists BOOLEAN;

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

750: END IF;
751:
752: l_line_adj_tbl(i).line_id := p_line_id;
753: l_line_adj_tbl(i).header_id := p_header_id;
754: l_line_adj_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
755:
756: SELECT Oe_Price_Adjustments_S.Nextval
757: INTO l_line_adj_tbl(i).price_adjustment_id
758: FROM dual;

Line 950: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF

946: , p_init_msg_list => FND_API.G_FALSE
947: , x_return_status => x_return_status
948: , x_msg_count => x_msg_count
949: , x_msg_data => x_msg_data
950: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
951: -- , p_validation_level => FND_API.G_VALID_LEVEL_NONE
952: , p_x_header_rec => l_x_header_rec
953: , p_x_Header_Adj_tbl => l_x_Header_Adj_tbl
954: , p_x_Header_Scredit_tbl => l_x_Header_Scredit_tbl

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

1173: x_line_rec.pricing_quantity:=NULL;
1174: x_line_rec.orig_sys_document_ref:=p_oline_rec.header_id;
1175: x_line_rec.orig_sys_line_ref:=p_oline_rec.line_id;
1176: x_line_rec.calculate_price_flag:='Y';
1177: x_line_rec.operation:= OE_Globals.G_OPR_CREATE;
1178: x_line_rec.flow_status_code:='ENTERED';
1179: --SET line category code as 'RETURN' first because this is the most common case
1180: --line category code will be reset to 'ORDER' by OEXVOPRB.pls if it ends up to be
1181: --not a 'RETURN' line.

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

1273: G_INT_USE_ANY_VALID_PL := nvl(FND_PROFILE.VALUE('ONT_USE_ANY_VALID_PL'),'N');
1274: x_header_rec.sold_to_org_id := p_sold_to_org_id;
1275: x_header_rec.transactional_curr_code:=p_transaction_curr_code;
1276: x_header_rec.conversion_type_code:=p_conversion_type_code;
1277: x_header_rec.operation :=OE_Globals.G_OPR_CREATE;
1278: x_header_rec.ordered_date :=SYSDATE;
1279: --Should pric list get defaulted? Or just plain copy?
1280: x_header_rec.price_list_id :=FND_API.G_MISS_NUM;
1281: x_header_rec.header_id :=FND_API.G_MISS_NUM;

Line 1334: l_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

1330: oe_debug_pub.add('Retro:currency:'||x_header_rec.transactional_curr_code);
1331: End;
1332:
1333: PROCEDURE Insert_Id(p_retrobill_tbl IN RETROBILL_TBL_TYPE) As
1334: l_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
1335: l_value_tbl OE_GLOBALS.NUMBER_TBL_TYPE; --store the index of p_retrobill_tbl for line_id
1336: i NUMBER;
1337: j NUMBER:=1;
1338: Begin

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

1331: End;
1332:
1333: PROCEDURE Insert_Id(p_retrobill_tbl IN RETROBILL_TBL_TYPE) As
1334: l_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
1335: l_value_tbl OE_GLOBALS.NUMBER_TBL_TYPE; --store the index of p_retrobill_tbl for line_id
1336: i NUMBER;
1337: j NUMBER:=1;
1338: Begin
1339:

Line 1475: l_line_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

1471:
1472: l_deleted_line NUMBER :=NULL;
1473: l_deleted_line_hdr NUMBER :=NULL;
1474: k PLS_INTEGER:=1;
1475: l_line_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
1476: l_line_num_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
1477: l_usp_sum Number:=0;
1478: l_ulp_sum Number:=0;
1479: l_orig_usp Number:=0;

Line 1476: l_line_num_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

1472: l_deleted_line NUMBER :=NULL;
1473: l_deleted_line_hdr NUMBER :=NULL;
1474: k PLS_INTEGER:=1;
1475: l_line_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
1476: l_line_num_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
1477: l_usp_sum Number:=0;
1478: l_ulp_sum Number:=0;
1479: l_orig_usp Number:=0;
1480: l_orig_ulp Number:=0;

Line 1489: l_control_rec OE_GLOBALS.Control_Rec_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);
1491: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1492: --skubendr{
1493: l_inventory_item_id_previous NUMBER;

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

1589: l_line_rec.line_category_code :='ORDER';
1590: l_line_rec.calculate_price_flag :='N';
1591: --set following to miss char such that redefault can take place.
1592: l_line_rec.line_type_id :=FND_API.G_MISS_NUM;
1593: l_line_rec.operation :=OE_GLOBALS.G_OPR_UPDATE;
1594: l_debit := 'Y';
1595: j:=j+1;
1596:
1597: oe_default_line.attributes(p_x_line_rec => l_line_rec,

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

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

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

1666: p_x_old_line_tbl => l_old_line_tbl,
1667: x_return_status => l_return_status);
1668:
1669: -- Reset the pricing recursion, so that pricing will get triggered after Oe_Order_Pvt.Lines call
1670: oe_globals.g_pricing_recursion := 'N';
1671: --deletion occured, need to resequence line number.
1672: END IF;
1673:
1674: IF l_deleted_line_hdr IS NOT NULL THEN

Line 2798: l_header_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

2794: upd_index PLS_INTEGER:=1;
2795: n_index PLS_INTEGER:=1;
2796:
2797:
2798: l_header_id_tbl OE_GLOBALS.NUMBER_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;

Line 2799: l_line_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

2795: n_index PLS_INTEGER:=1;
2796:
2797:
2798: l_header_id_tbl OE_GLOBALS.NUMBER_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;

Line 2800: l_arrange_line_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

2796:
2797:
2798: l_header_id_tbl OE_GLOBALS.NUMBER_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);

Line 2801: l_arrange_line_num_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

2797:
2798: l_header_id_tbl OE_GLOBALS.NUMBER_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;

Line 2802: l_retrobill_qty_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

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

Line 3050: l_to_be_exe_hdr_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;

3046: i PLS_INTEGER:=1;
3047: l_visited Boolean:=FALSE;
3048: stmt NUMBER;
3049: lx_header_id NUMBER;
3050: l_to_be_exe_hdr_id_tbl OE_GLOBALS.NUMBER_TBL_TYPE;
3051: l_msg_count NUMBER;
3052: l_msg_data VARCHAR2(5000);
3053: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3054: lx_return_status VARCHAR2(15);

Line 3933: l_control_rec OE_GLOBALS.Control_Rec_Type;

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

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

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

Line 4119: AND b.language = oe_globals.g_lang

4115: , b.message_text
4116: FROM oe_processing_msgs a, oe_processing_msgs_tl b
4117: WHERE a.request_id = l_concurrent_id
4118: AND a.transaction_id = b.transaction_id
4119: AND b.language = oe_globals.g_lang
4120: ORDER BY a.order_source_id, a.original_sys_document_ref, a.change_sequence;
4121:
4122:
4123: BEGIN