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 888: This procdures update oe_retrobill_requests table

884: Return p_curr_ordered_qty;
885: End;
886:
887: /*************************************************************
888: This procdures update oe_retrobill_requests table
889: *************************************************************/
890: Procedure Update_Row(p_retrobill_request_rec IN OE_RETROBILL_REQUESTS%ROWTYPE) AS
891: Begin
892: oe_debug_pub.add('Retro:Entering Update retrobill request,request_id:'||p_retrobill_request_rec.retrobill_request_id);

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

886:
887: /*************************************************************
888: This procdures update oe_retrobill_requests table
889: *************************************************************/
890: Procedure Update_Row(p_retrobill_request_rec IN OE_RETROBILL_REQUESTS%ROWTYPE) AS
891: Begin
892: oe_debug_pub.add('Retro:Entering Update retrobill request,request_id:'||p_retrobill_request_rec.retrobill_request_id);
893: UPDATE OE_RETROBILL_REQUESTS
894: SET

Line 893: UPDATE OE_RETROBILL_REQUESTS

889: *************************************************************/
890: Procedure Update_Row(p_retrobill_request_rec IN OE_RETROBILL_REQUESTS%ROWTYPE) AS
891: Begin
892: oe_debug_pub.add('Retro:Entering Update retrobill request,request_id:'||p_retrobill_request_rec.retrobill_request_id);
893: UPDATE OE_RETROBILL_REQUESTS
894: SET
895: NAME = p_retrobill_request_rec.name
896: , DESCRIPTION = p_retrobill_request_rec.description
897: , EXECUTION_MODE= p_retrobill_request_rec.execution_mode

Line 1019: p_retrobill_request_rec In OE_RETROBILL_REQUESTS%ROWTYPE,

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

Line 1283: p_retrobill_request_rec IN OUT NOCOPY OE_RETROBILL_REQUESTS%ROWTYPE,

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

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

1659: End;
1660:
1661:
1662:
1663: PROCEDURE INSERT_RETROBILL_REQUEST(p_retrobill_request_rec IN OE_RETROBILL_REQUESTS%ROWTYPE) AS
1664: Begin
1665: INSERT INTO OE_RETROBILL_REQUESTS
1666: ( RETROBILL_REQUEST_ID
1667: ,NAME

Line 1665: INSERT INTO OE_RETROBILL_REQUESTS

1661:
1662:
1663: PROCEDURE INSERT_RETROBILL_REQUEST(p_retrobill_request_rec IN OE_RETROBILL_REQUESTS%ROWTYPE) AS
1664: Begin
1665: INSERT INTO OE_RETROBILL_REQUESTS
1666: ( RETROBILL_REQUEST_ID
1667: ,NAME
1668: , DESCRIPTION
1669: , EXECUTION_MODE

Line 3363: (p_retrobill_request_rec IN OE_RETROBILL_REQUESTS%ROWTYPE

3359: oe_debug_pub.add('Exception occured in Delete_Order:'||SQLERRM);
3360: END;
3361:
3362: PROCEDURE Process_Retrobill_Request
3363: (p_retrobill_request_rec IN OE_RETROBILL_REQUESTS%ROWTYPE
3364: ,p_retrobill_tbl IN RETROBILL_TBL_TYPE
3365: ,x_created_retrobill_request_id OUT NOCOPY NUMBER
3366: ,x_msg_count OUT NOCOPY NUMBER
3367: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3383: l_retrobill_request_rec OE_RETROBILL_REQUESTS%ROWTYPE;

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;
3384: j PLS_INTEGER:=0;
3385: i PLS_INTEGER:=1;
3386: l_visited Boolean:=FALSE;
3387: stmt NUMBER;

Line 3750: from oe_retrobill_requests

3746: FOR UPDATE NOWAIT;
3747:
3748: cursor c_open_retrobill_requests(c_header_id NUMBER,c_line_id NUMBER) is
3749: select name
3750: from oe_retrobill_requests
3751: where
3752: retrobill_request_id
3753: in
3754: (select retrobill_request_id from oe_order_lines_all

Line 3767: l_retrobill_request_rec OE_RETROBILL_REQUESTS%ROWTYPE;

3763: c_lines_record c_lines%rowtype;
3764:
3765: i NUMBER :=1;
3766: j NUMBER;
3767: l_retrobill_request_rec OE_RETROBILL_REQUESTS%ROWTYPE;
3768: l_retrobill_tbl OE_RETROBILL_PVT.RETROBILL_TBL_TYPE;
3769:
3770: l_return_status varchar2(2000);
3771: l_msg_count NUMBER;

Line 4451: Delete from oe_retrobill_requests where

4447: and order_source_id=27;
4448:
4449: IF(l_header_count = 0) THEN
4450: IF(p_retrobill_request_id is NOT NULL) THEN
4451: Delete from oe_retrobill_requests where
4452: retrobill_request_id=to_number(p_retrobill_request_id);
4453: oe_debug_pub.add('Deleted Request'||p_retrobill_request_id);
4454: l_requests_processed := l_requests_processed + 1;
4455: END IF;

Line 4505: 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

4501: l_old_org_id NUMBER;
4502:
4503: cursor retrobill_request is
4504: --bug4752386 Selecting executed requests as well and adding execution_mode to the select clause
4505: 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
4506: where trunc(retro.creation_date) >= nvl(trunc(l_creation_date_from),trunc(retro.creation_date))
4507: and trunc(retro.creation_date) <= nvl(trunc(l_creation_date_to),trunc(retro.creation_date))
4508: and trunc(execution_date) >= nvl(trunc(l_execution_date_from),trunc(execution_date))
4509: and trunc(execution_date) <= nvl(trunc(l_execution_date_to),trunc(execution_date))

Line 4518: 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

4514:
4515:
4516: cursor retrobill_request_id is
4517: --bug4752386 Selecting executed requests as well and adding execution_mode to the select clause
4518: 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
4519: where retrobill_request_id = to_number(p_retrobill_request_id)
4520: and trunc(retro.creation_date) >= nvl(trunc(l_creation_date_from),trunc(retro.creation_date))
4521: and trunc(retro.creation_date) <= nvl(trunc(l_creation_date_to),trunc(retro.creation_date))
4522: and trunc(execution_date) >= nvl(trunc(l_execution_date_from),trunc(execution_date))