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_RETROBILL_REQUESTS

Line 29: 2. Log this retrobill request into OE_RETROBILL_REQUESTS table.

25: f. If the line has retrobilled before, get the difference by sum ULP, USP, ULPPQTY, USPPQTY.
26: g. Updated applied_flag = N on any adjustment has
27: h. If price negative then change line category RETURN, pricing recursion Y oe_order_pvt.lines to redefault the lines.
28:
29: 2. Log this retrobill request into OE_RETROBILL_REQUESTS table.
30: Elsif EXECUTE previous preview Then
31: For each retrobill_header_id in p_rectobill_line_tbl call OE_ORDER_BOOK_UTIL.Book_Order.
32: Elsif PREVIEW AGAIN Then
33:

Line 876: This procdures update oe_retrobill_requests table

872: Return p_curr_ordered_qty;
873: End;
874:
875: /*************************************************************
876: This procdures update oe_retrobill_requests table
877: *************************************************************/
878: Procedure Update_Row(p_retrobill_request_rec IN OE_RETROBILL_REQUESTS%ROWTYPE) AS
879: Begin
880: oe_debug_pub.add('Retro:Entering Update retrobill request,request_id:'||p_retrobill_request_rec.retrobill_request_id);

Line 878: Procedure Update_Row(p_retrobill_request_rec IN OE_RETROBILL_REQUESTS%ROWTYPE) AS

874:
875: /*************************************************************
876: This procdures update oe_retrobill_requests table
877: *************************************************************/
878: Procedure Update_Row(p_retrobill_request_rec IN OE_RETROBILL_REQUESTS%ROWTYPE) AS
879: Begin
880: oe_debug_pub.add('Retro:Entering Update retrobill request,request_id:'||p_retrobill_request_rec.retrobill_request_id);
881: UPDATE OE_RETROBILL_REQUESTS
882: SET

Line 881: UPDATE OE_RETROBILL_REQUESTS

877: *************************************************************/
878: Procedure Update_Row(p_retrobill_request_rec IN OE_RETROBILL_REQUESTS%ROWTYPE) AS
879: Begin
880: oe_debug_pub.add('Retro:Entering Update retrobill request,request_id:'||p_retrobill_request_rec.retrobill_request_id);
881: UPDATE OE_RETROBILL_REQUESTS
882: SET
883: NAME = p_retrobill_request_rec.name
884: , DESCRIPTION = p_retrobill_request_rec.description
885: , EXECUTION_MODE= p_retrobill_request_rec.execution_mode

Line 1003: p_retrobill_request_rec In OE_RETROBILL_REQUESTS%ROWTYPE,

999: process order.
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;

Line 1264: p_retrobill_request_rec IN OUT NOCOPY OE_RETROBILL_REQUESTS%ROWTYPE,

1260: PROCEDURE Prepare_Header(p_cust_po_number IN VARCHAR2, -- Bug# 6603714
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;

Line 1364: PROCEDURE INSERT_RETROBILL_REQUEST(p_retrobill_request_rec IN OE_RETROBILL_REQUESTS%ROWTYPE) AS

1360: oe_debug_pub.add('Execption occured in Oe_Retrobill_Pvt.Insert_Id:'||SQLERRM);
1361: Raise;
1362: End;
1363:
1364: PROCEDURE INSERT_RETROBILL_REQUEST(p_retrobill_request_rec IN OE_RETROBILL_REQUESTS%ROWTYPE) AS
1365: Begin
1366: INSERT INTO OE_RETROBILL_REQUESTS
1367: ( RETROBILL_REQUEST_ID
1368: ,NAME

Line 1366: INSERT INTO OE_RETROBILL_REQUESTS

1362: End;
1363:
1364: PROCEDURE INSERT_RETROBILL_REQUEST(p_retrobill_request_rec IN OE_RETROBILL_REQUESTS%ROWTYPE) AS
1365: Begin
1366: INSERT INTO OE_RETROBILL_REQUESTS
1367: ( RETROBILL_REQUEST_ID
1368: ,NAME
1369: , DESCRIPTION
1370: , EXECUTION_MODE

Line 3025: (p_retrobill_request_rec IN OE_RETROBILL_REQUESTS%ROWTYPE

3021: oe_debug_pub.add('Exception occured in Delete_Order:'||SQLERRM);
3022: END;
3023:
3024: PROCEDURE Process_Retrobill_Request
3025: (p_retrobill_request_rec IN OE_RETROBILL_REQUESTS%ROWTYPE
3026: ,p_retrobill_tbl IN RETROBILL_TBL_TYPE
3027: ,x_created_retrobill_request_id OUT NOCOPY NUMBER
3028: ,x_msg_count OUT NOCOPY NUMBER
3029: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3044: l_retrobill_request_rec OE_RETROBILL_REQUESTS%ROWTYPE;

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;
3045: j PLS_INTEGER:=0;
3046: i PLS_INTEGER:=1;
3047: l_visited Boolean:=FALSE;
3048: stmt NUMBER;

Line 3364: from oe_retrobill_requests

3360: FOR UPDATE NOWAIT;
3361:
3362: cursor c_open_retrobill_requests(c_header_id NUMBER,c_line_id NUMBER) is
3363: select name
3364: from oe_retrobill_requests
3365: where
3366: retrobill_request_id
3367: in
3368: (select retrobill_request_id from oe_order_lines_all

Line 3381: l_retrobill_request_rec OE_RETROBILL_REQUESTS%ROWTYPE;

3377: c_lines_record c_lines%rowtype;
3378:
3379: i NUMBER :=1;
3380: j NUMBER;
3381: l_retrobill_request_rec OE_RETROBILL_REQUESTS%ROWTYPE;
3382: l_retrobill_tbl OE_RETROBILL_PVT.RETROBILL_TBL_TYPE;
3383:
3384: l_return_status varchar2(2000);
3385: l_msg_count NUMBER;

Line 4026: Delete from oe_retrobill_requests where

4022: and order_source_id=27;
4023:
4024: IF(l_header_count = 0) THEN
4025: IF(p_retrobill_request_id is NOT NULL) THEN
4026: Delete from oe_retrobill_requests where
4027: retrobill_request_id=to_number(p_retrobill_request_id);
4028: oe_debug_pub.add('Deleted Request'||p_retrobill_request_id);
4029: l_requests_processed := l_requests_processed + 1;
4030: END IF;

Line 4080: select retrobill_request_id,retro.name,ord_typ.org_id,retro.execution_mode from oe_retrobill_requests retro,oe_order_types_v ord_typ --rt moac selecting the org_id

4076: l_old_org_id NUMBER;
4077:
4078: cursor retrobill_request is
4079: --bug4752386 Selecting executed requests as well and adding execution_mode to the select clause
4080: select retrobill_request_id,retro.name,ord_typ.org_id,retro.execution_mode from oe_retrobill_requests retro,oe_order_types_v ord_typ --rt moac selecting the org_id
4081: where trunc(retro.creation_date) >= nvl(trunc(l_creation_date_from),trunc(retro.creation_date))
4082: and trunc(retro.creation_date) <= nvl(trunc(l_creation_date_to),trunc(retro.creation_date))
4083: and trunc(execution_date) >= nvl(trunc(l_execution_date_from),trunc(execution_date))
4084: and trunc(execution_date) <= nvl(trunc(l_execution_date_to),trunc(execution_date))

Line 4093: select retrobill_request_id,retro.name,ord_typ.org_id,retro.execution_mode from oe_retrobill_requests retro,oe_order_types_v ord_typ --rt moac selecting the org_id

4089:
4090:
4091: cursor retrobill_request_id is
4092: --bug4752386 Selecting executed requests as well and adding execution_mode to the select clause
4093: select retrobill_request_id,retro.name,ord_typ.org_id,retro.execution_mode from oe_retrobill_requests retro,oe_order_types_v ord_typ --rt moac selecting the org_id
4094: where retrobill_request_id = to_number(p_retrobill_request_id)
4095: and trunc(retro.creation_date) >= nvl(trunc(l_creation_date_from),trunc(retro.creation_date))
4096: and trunc(retro.creation_date) <= nvl(trunc(l_creation_date_to),trunc(retro.creation_date))
4097: and trunc(execution_date) >= nvl(trunc(l_execution_date_from),trunc(execution_date))