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.JAI_OE_OLA_TRIGGER_PKG dependencies on JAI_OM_OE_RMA_LINES

Line 49: DELETE JAI_OM_OE_RMA_LINES

45: v_gl_set_of_bks_id := l_func_curr_det.ledger_id;
46: v_currency_code := l_func_curr_det.currency_code;
47:
48: IF v_line_category_code = 'RETURN' THEN
49: DELETE JAI_OM_OE_RMA_LINES
50: WHERE rma_header_id = v_header_id
51: AND rma_line_id = v_line_id;
52:
53: DELETE FROM JAI_OM_OE_RMA_TAXES

Line 264: FROM JAI_OM_OE_RMA_LINES

260: WHERE line_id = p_line_id;
261:
262: CURSOR get_rma_lines_count_cur(p_line_id NUMBER) IS
263: SELECT COUNT(1)
264: FROM JAI_OM_OE_RMA_LINES
265: WHERE rma_line_id = v_line_id;
266:
267: CURSOR get_so_tax_lines_count_cur( p_header_id NUMBER, p_line_id NUMBER) IS
268: SELECT COUNT(1)

Line 361: Get the details from the JAI_OM_OE_RMA_LINES table.

357:
358: v_trigg_stat VARCHAR2(100);
359:
360: /* This cursor has been added by Aiyer for the fix of the bug #2798930.
361: Get the details from the JAI_OM_OE_RMA_LINES table.
362: */
363: CURSOR cur_get_rma_entry_lines (
364: p_header_id JAI_OM_OE_RMA_LINES.RMA_HEADER_ID%TYPE,
365: p_Line_Id JAI_OM_OE_RMA_LINES.RMA_LINE_ID%TYPE

Line 364: p_header_id JAI_OM_OE_RMA_LINES.RMA_HEADER_ID%TYPE,

360: /* This cursor has been added by Aiyer for the fix of the bug #2798930.
361: Get the details from the JAI_OM_OE_RMA_LINES table.
362: */
363: CURSOR cur_get_rma_entry_lines (
364: p_header_id JAI_OM_OE_RMA_LINES.RMA_HEADER_ID%TYPE,
365: p_Line_Id JAI_OM_OE_RMA_LINES.RMA_LINE_ID%TYPE
366: )
367: IS
368: SELECT

Line 365: p_Line_Id JAI_OM_OE_RMA_LINES.RMA_LINE_ID%TYPE

361: Get the details from the JAI_OM_OE_RMA_LINES table.
362: */
363: CURSOR cur_get_rma_entry_lines (
364: p_header_id JAI_OM_OE_RMA_LINES.RMA_HEADER_ID%TYPE,
365: p_Line_Id JAI_OM_OE_RMA_LINES.RMA_LINE_ID%TYPE
366: )
367: IS
368: SELECT
369: *

Line 371: JAI_OM_OE_RMA_LINES

367: IS
368: SELECT
369: *
370: FROM
371: JAI_OM_OE_RMA_LINES
372: WHERE
373: rma_header_id = p_header_id AND
374: rma_line_id = p_Line_Id ;
375:

Line 626: Fix: Column 'quantity' is not nullable in both JAI_OM_OE_SO_LINES and JAI_OM_OE_RMA_LINES.

622:
623: 23. 10-Sep-2010 Jia for GST Bug#10043656.
624: 24. 13-Sep-2012 Bug 11774053
625: Issue: IMPROPER ERROR WHEN SALES ORDER IS SAVED WITH OUT QUANTITY
626: Fix: Column 'quantity' is not nullable in both JAI_OM_OE_SO_LINES and JAI_OM_OE_RMA_LINES.
627: So add a quantity check before inserting lines into JAI table.
628:
629: 17. 03-Oct-2012 mmurtuza for bug 14675557
630: Issue: ASSESSABLE AMOUNT IS SHOWING WRONG VALUE FOR A COPIED ORDER

Line 1146: JAI_OM_OE_RMA_LINES

1142: IS
1143: SELECT
1144: 'X'
1145: FROM
1146: JAI_OM_OE_RMA_LINES
1147: WHERE
1148: rma_line_id = p_line_id AND
1149: rma_header_id = p_header_id ;
1150:

Line 1259: select delivery_detail_id from JAI_OM_OE_RMA_LINES

1255: AND tax_type = cp_tax_type;
1256:
1257: /*Added by Bgowrava for Bug#6126581 */
1258: cursor cur_get_ddetail_id(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE , p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) is
1259: select delivery_detail_id from JAI_OM_OE_RMA_LINES
1260: where rma_header_id = p_source_document_id AND
1261: rma_line_id = p_source_document_line_id;
1262:
1263: v_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type;

Line 1263: v_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type;

1259: select delivery_detail_id from JAI_OM_OE_RMA_LINES
1260: where rma_header_id = p_source_document_id AND
1261: rma_line_id = p_source_document_line_id;
1262:
1263: v_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type;
1264: /* END, Bug#6126581*/
1265:
1266: /*Added a parameter p_ddetail_id in the below cursor for Bug#6126581 */
1267: CURSOR c_get_detail_id(p_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type)

Line 1267: CURSOR c_get_detail_id(p_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type)

1263: v_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type;
1264: /* END, Bug#6126581*/
1265:
1266: /*Added a parameter p_ddetail_id in the below cursor for Bug#6126581 */
1267: CURSOR c_get_detail_id(p_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type)
1268: IS
1269: SELECT
1270: wdd.delivery_detail_id,
1271: wnd.confirm_date

Line 1398: -- Insert a record into JAI_OM_OE_RMA_LINES

1394: IF a record does not exists with the newline_id and header_id
1395: only then go ahead with the insert
1396: */
1397: IF cur_rma_entry_line_exists%NOTFOUND THEN
1398: -- Insert a record into JAI_OM_OE_RMA_LINES
1399: INSERT INTO JAI_OM_OE_RMA_LINES
1400: (
1401: rma_line_number ,
1402: rma_line_id ,

Line 1399: INSERT INTO JAI_OM_OE_RMA_LINES

1395: only then go ahead with the insert
1396: */
1397: IF cur_rma_entry_line_exists%NOTFOUND THEN
1398: -- Insert a record into JAI_OM_OE_RMA_LINES
1399: INSERT INTO JAI_OM_OE_RMA_LINES
1400: (
1401: rma_line_number ,
1402: rma_line_id ,
1403: rma_header_id ,

Line 1702: UPDATE JAI_OM_OE_RMA_LINES

1698: END IF ; --IF cur_chk_rma_tax_lines_exists%NOTFOUND
1699: CLOSE cur_chk_rma_tax_lines_exists ;
1700: END LOOP;
1701:
1702: UPDATE JAI_OM_OE_RMA_LINES
1703: SET tax_amount = v_tax_total
1704: WHERE rma_line_id = v_line_id ;
1705:
1706: -- added by Allen Yang for bug 9666476 28-apr-2010, begin

Line 1863: -- need to insert into JAI_OM_OE_RMA_LINES from the source.

1859: THEN
1860: /*End of bug 5401180 */
1861: -- here need to code the cases where order category code is MIXED and line_category_code is RETURN
1862: -- this is typically the case where a legacy RMA is copied another legacy RMA
1863: -- need to insert into JAI_OM_OE_RMA_LINES from the source.
1864:
1865: --added the below if condition for bug#7675274
1866: IF pr_new.return_context IS NULL
1867: THEN

Line 1875: FROM JAI_OM_OE_RMA_LINES

1871: /* fetch the details of the original RMA order
1872: */
1873: CURSOR c_rma_details(cp_rma_header_id number , cp_rma_line_id number) is
1874: SELECT *
1875: FROM JAI_OM_OE_RMA_LINES
1876: WHERE rma_header_id = cp_rma_header_id
1877: AND rma_line_id = cp_rma_line_id;
1878:
1879: /* get the new order number from oe_order_headers_all*/

Line 1899: insert into JAI_OM_OE_RMA_LINES

1895: open c_rma_number(pr_new.header_id );
1896: fetch c_rma_number into lv_rma_number;
1897: close c_rma_number;
1898:
1899: insert into JAI_OM_OE_RMA_LINES
1900: (
1901: rma_line_id ,
1902: rma_line_number ,
1903: rma_header_id ,

Line 2066: JAI_OM_OE_RMA_LINES

2062: IS
2063: SELECT
2064: 'X'
2065: FROM
2066: JAI_OM_OE_RMA_LINES
2067: WHERE
2068: rma_line_id = p_line_id AND
2069: rma_header_id = p_header_id ;
2070:

Line 2176: select delivery_detail_id from JAI_OM_OE_RMA_LINES

2172: AND tax_type = cp_tax_type;
2173:
2174: /*Added by Bgowrava for Bug#6126581 */
2175: cursor cur_get_ddetail_id(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE , p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) is
2176: select delivery_detail_id from JAI_OM_OE_RMA_LINES
2177: where rma_header_id = p_source_document_id AND
2178: rma_line_id = p_source_document_line_id;
2179:
2180: v_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type;

Line 2180: v_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type;

2176: select delivery_detail_id from JAI_OM_OE_RMA_LINES
2177: where rma_header_id = p_source_document_id AND
2178: rma_line_id = p_source_document_line_id;
2179:
2180: v_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type;
2181: /* END, Bug#6126581*/
2182:
2183: /*Added a parameter p_ddetail_id in the below cursor for Bug#6126581 */
2184: CURSOR c_get_detail_id(p_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type)

Line 2184: CURSOR c_get_detail_id(p_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type)

2180: v_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type;
2181: /* END, Bug#6126581*/
2182:
2183: /*Added a parameter p_ddetail_id in the below cursor for Bug#6126581 */
2184: CURSOR c_get_detail_id(p_ddetail_id JAI_OM_OE_RMA_LINES.delivery_detail_id%type)
2185: IS
2186: SELECT
2187: wdd.delivery_detail_id,
2188: wnd.confirm_date

Line 2311: INSERT INTO JAI_OM_OE_RMA_LINES

2307: only then go ahead with the insert
2308: */
2309: IF cur_rma_entry_line_exists%NOTFOUND THEN
2310:
2311: INSERT INTO JAI_OM_OE_RMA_LINES
2312: (
2313: rma_line_number ,
2314: rma_line_id ,
2315: rma_header_id ,

Line 2609: UPDATE JAI_OM_OE_RMA_LINES

2605: END IF ; --IF cur_chk_rma_tax_lines_exists%NOTFOUND
2606: CLOSE cur_chk_rma_tax_lines_exists ;
2607: END LOOP;
2608:
2609: UPDATE JAI_OM_OE_RMA_LINES
2610: SET tax_amount = v_tax_total
2611: WHERE rma_line_id = v_line_id ;
2612:
2613: -- added by Allen Yang for bug 9691880 07-MAY-2010, begin

Line 3611: Due to this the record would be inserted into the JAI_OM_OE_RMA_LINES table instead of the

3607: Solution:-
3608: Added an NVL clause to the below IF statement .
3609: Now even if the Return_context is null it would be treated as = LEGACY
3610: and the v_transaction_name flag would be set to LEGACY.
3611: Due to this the record would be inserted into the JAI_OM_OE_RMA_LINES table instead of the
3612: JAI_OM_OE_SO_LINES table.
3613: */
3614: -- Start of bug #2979969
3615: IF pr_new.LINE_CATEGORY_CODE = 'RETURN' THEN

Line 3729: DELETE JAI_OM_OE_RMA_LINES

3725: END IF;
3726:
3727: IF ( v_transaction_name = 'RMA_LEGACY_INSERT') THEN
3728:
3729: DELETE JAI_OM_OE_RMA_LINES
3730: WHERE RMA_LINE_ID = V_LINE_ID;
3731: DELETE JAI_OM_OE_RMA_TAXES
3732: WHERE RMA_LINE_ID = V_LINE_ID;
3733: ELSE

Line 3907: utl_file.put_line(v_myfilehandle, ' BEFORE INSERTING RECORD INTO JAI_OM_OE_RMA_LINES ');

3903: -- added for bug 11774053 by zhiwei.xin on 13-Sep-2012 end.
3904:
3905: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
3906: IF v_debug = 'Y' THEN
3907: utl_file.put_line(v_myfilehandle, ' BEFORE INSERTING RECORD INTO JAI_OM_OE_RMA_LINES ');
3908: END IF;
3909: INSERT INTO JAI_OM_OE_RMA_LINES (
3910: rma_line_number,
3911: rma_line_id,

Line 3909: INSERT INTO JAI_OM_OE_RMA_LINES (

3905: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
3906: IF v_debug = 'Y' THEN
3907: utl_file.put_line(v_myfilehandle, ' BEFORE INSERTING RECORD INTO JAI_OM_OE_RMA_LINES ');
3908: END IF;
3909: INSERT INTO JAI_OM_OE_RMA_LINES (
3910: rma_line_number,
3911: rma_line_id,
3912: rma_header_id,
3913: rma_number,

Line 4962: FROM JAI_OM_OE_RMA_LINES

4958:
4959: CURSOR c_ja_in_rma_lines (p_line_id NUMBER) IS
4960: SELECT quantity,
4961: assessable_value
4962: FROM JAI_OM_OE_RMA_LINES
4963: WHERE rma_line_id = p_line_id;
4964:
4965:
4966:

Line 5188: -- as the JAI_OM_OE_SO_LINES has no records for a return order and instead records are present in the JAI_OM_OE_RMA_LINES

5184: -- for the fix of bug # 3181926
5185: -- When a Legacy return order is created and line saved and if quantity is changed , this trigger was throwing up
5186: -- an exception - DIVIDE BY ZERO .The reason for this is that the cursor which fetches the old quantity and old
5187: -- assessable value fetched the values from the JAI_OM_OE_SO_LINES table. For a return order , this is not relevant
5188: -- as the JAI_OM_OE_SO_LINES has no records for a return order and instead records are present in the JAI_OM_OE_RMA_LINES
5189: -- table.
5190: -- code added by sriram includes adding the if statement below , adding the elsif condition and opening the cursor
5191: -- c_ja_in_rma_lines . This cursor definition also has been added by sriram.
5192: /*bduvarag for the bug#5256498 start*/

Line 5494: jai_om_oe_rma_lines

5490: --bug#9067808,end
5491:
5492: ELSIF pr_new.line_category_code = 'RETURN' THEN /*added by aiyer for the bug 5401180. Replaced return_context = legacy with this */
5493: UPDATE
5494: jai_om_oe_rma_lines
5495: SET
5496: quantity = v_quantity ,
5497: uom = v_uom_code, --bug#8413915
5498: selling_price = v_selling_price ,

Line 5688: from JAI_OM_OE_RMA_LINES

5684: /* Added for DFF Elimination by Ramananda. Bug#4348749 */
5685: cursor c_rma_line_dtls(cp_rma_line_id in number) is
5686: select delivery_detail_id, nvl(allow_excise_credit_flag, 'N') allow_excise_credit_flag , nvl(allow_sales_credit_flag, 'N') allow_sales_credit_flag,
5687: rate_per_unit, excise_duty_rate
5688: from JAI_OM_OE_RMA_LINES
5689: where rma_line_id = cp_rma_line_id;
5690:
5691: ln_delivery_detail_id number;
5692: lv_allow_excise_flag varchar2(1);