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_LINE_PAYMENT_UTIL dependencies on OE_PAYMENTS

Line 857: FROM OE_HOLD_SOURCES HS,OE_ORDER_HOLDS OH,OE_PAYMENTS OP

853: ) IS
854:
855: CURSOR line_paytype_hold IS
856: Select OH.Order_hold_id,NVL(OH.hold_release_id,0)
857: FROM OE_HOLD_SOURCES HS,OE_ORDER_HOLDS OH,OE_PAYMENTS OP
858: WHERE HS.hold_source_id=OH.hold_source_id
859: AND OH.header_id=OP.header_id
860: AND OH.line_id=OP.line_id
861: AND OP.payment_number=p_payment_number

Line 1825: FROM OE_PAYMENTS

1821: BEGIN
1822:
1823: SELECT lock_control
1824: INTO l_lock_control
1825: FROM OE_PAYMENTS
1826: WHERE payment_number = p_Line_Payment_rec.payment_number
1827: AND header_id = p_Line_Payment_rec.header_id
1828: AND line_id = p_Line_Payment_rec.line_id;
1829:

Line 1867: UPDATE OE_PAYMENTS

1863: END IF;
1864: END IF; /*code_release_level*/
1865: -- notification framework end
1866:
1867: UPDATE OE_PAYMENTS
1868: SET ATTRIBUTE1 = p_Line_Payment_rec.attribute1
1869: , ATTRIBUTE2 = p_Line_Payment_rec.attribute2
1870: , ATTRIBUTE3 = p_Line_Payment_rec.attribute3
1871: , ATTRIBUTE4 = p_Line_Payment_rec.attribute4

Line 1981: INSERT INTO OE_PAYMENTS

1977: END IF;
1978: END IF;
1979:
1980:
1981: INSERT INTO OE_PAYMENTS
1982: ( ATTRIBUTE1
1983: , ATTRIBUTE2
1984: , ATTRIBUTE3
1985: , ATTRIBUTE4

Line 2168: FROM OE_PAYMENTS

2164: --R12 CC Encryption
2165:
2166: CURSOR payment IS
2167: SELECT payment_number, payment_type_code,trxn_extension_id
2168: FROM OE_PAYMENTS
2169: WHERE LINE_ID = p_line_id
2170: AND HEADER_ID = p_header_id;
2171: -- added for notification framework
2172: l_new_line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;

Line 2285: DELETE FROM OE_PAYMENTS

2281: p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
2282: p_entity_id => p_line_id,
2283: x_return_status => l_return_status
2284: );
2285: DELETE FROM OE_PAYMENTS
2286: WHERE LINE_ID = p_line_id
2287: AND HEADER_ID = p_header_id;
2288:
2289: --3382262

Line 2291: oe_debug_pub.add('1: after executing delete statement against oe_payments - before delete_payment_at_line');

2287: AND HEADER_ID = p_header_id;
2288:
2289: --3382262
2290: IF l_debug_level > 0 THEN
2291: oe_debug_pub.add('1: after executing delete statement against oe_payments - before delete_payment_at_line');
2292: END IF;
2293:
2294:
2295: Delete_Payment_at_line(p_line_id => p_line_id,

Line 2401: from oe_payments

2397: );
2398:
2399: Begin
2400: select payment_type_code,trxn_extension_id into p_payment_type_code,l_trxn_extension_id
2401: from oe_payments
2402: where payment_number = p_payment_number
2403: and line_id = p_line_id
2404: and header_id = p_header_id;
2405:

Line 2411: from oe_payments

2407: when no_data_found then
2408:
2409: Begin
2410: select payment_type_code,trxn_extension_id into p_payment_type_code,l_trxn_extension_id --R12 CC Encryption
2411: from oe_payments
2412: where line_id = p_line_id
2413: and payment_number is null
2414: and header_id = p_header_id;
2415:

Line 2474: DELETE FROM OE_PAYMENTS

2470: END IF;
2471: END IF;
2472: --R12 CC Encryption
2473:
2474: DELETE FROM OE_PAYMENTS
2475: WHERE PAYMENT_NUMBER = p_payment_number
2476: AND LINE_ID = p_line_id
2477: AND HEADER_ID = p_header_id
2478: ;

Line 2482: oe_debug_pub.add('2: after executing delete statement against oe_payments - before delete_payment_at_line');

2478: ;
2479:
2480: --3382262
2481: IF l_debug_level > 0 THEN
2482: oe_debug_pub.add('2: after executing delete statement against oe_payments - before delete_payment_at_line');
2483: END IF;
2484:
2485:
2486: Delete_Payment_at_line(p_line_id => p_line_id,

Line 2611: FROM OE_PAYMENTS

2607: , LOCK_CONTROL
2608: , PAYMENT_NUMBER
2609: , DEFER_PAYMENT_PROCESSING_FLAG
2610: , TRXN_EXTENSION_ID
2611: FROM OE_PAYMENTS
2612: WHERE ( PAYMENT_NUMBER = p_payment_number
2613: AND LINE_ID = p_line_id
2614: AND HEADER_ID = p_header_id
2615: );

Line 2820: FROM OE_PAYMENTS

2816: , LOCK_CONTROL
2817: , PAYMENT_NUMBER
2818: , DEFER_PAYMENT_PROCESSING_FLAG
2819: , TRXN_EXTENSION_ID
2820: FROM OE_PAYMENTS
2821: WHERE LINE_ID = p_line_id
2822: AND HEADER_ID = p_header_id
2823: ;
2824:

Line 2986: FROM oe_payments

2982: END IF;
2983:
2984: SELECT payment_number
2985: INTO l_payment_number
2986: FROM oe_payments
2987: WHERE payment_number = l_payment_number
2988: AND line_id = l_line_id
2989: AND header_id = l_header_id
2990: FOR UPDATE NOWAIT;

Line 3106: FROM oe_payments

3102: )
3103: IS
3104: CURSOR lock_lin_Payments(p_line_id NUMBER) IS
3105: SELECT payment_number
3106: FROM oe_payments
3107: WHERE line_id = p_line_id
3108: AND header_id = p_header_id
3109: FOR UPDATE NOWAIT;
3110:

Line 3144: FROM OE_PAYMENTS

3140: p_line_id <> FND_API.G_MISS_NUM THEN
3141:
3142: SELECT payment_number
3143: INTO l_payment_number
3144: FROM OE_PAYMENTS
3145: WHERE payment_number = p_payment_number
3146: AND line_id = p_line_id
3147: AND header_id = p_header_id
3148: FOR UPDATE NOWAIT;

Line 3532: FROM oe_payments

3528:
3529: BEGIN
3530: SELECT 'Y'
3531: INTO l_is_split_payment
3532: FROM oe_payments
3533: WHERE header_id = p_x_line_Payment_rec.header_id
3534: AND line_id = p_x_line_Payment_rec.line_id
3535: AND payment_type_code IS NULL
3536: AND credit_card_approval_code = 'CVV2_REQUIRED';

Line 3997: --be updated in oe_payments table during updation.

3993: END IF;
3994:
3995: --Setting the trxn extension id as null as for transactions
3996: --coming from sales order others tab, the trxn extension id would
3997: --be updated in oe_payments table during updation.
3998: p_x_line_payment_rec.trxn_extension_id := null;
3999: END IF; --Payment type condtion
4000: --R12 CC Encryption
4001: EXCEPTION