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

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

838: ) IS
839:
840: CURSOR order_paytype_hold IS
841: Select OH.Order_hold_id,NVL(OH.hold_release_id,0)
842: FROM OE_HOLD_SOURCES HS,OE_ORDER_HOLDS OH,OE_PAYMENTS OP
843: WHERE HS.hold_source_id=OH.hold_source_id
844: AND OH.header_id=OP.header_id
845: AND OP.payment_number=p_payment_number
846: AND ((HS.hold_entity_code= 'P' AND HS.hold_entity_id=OP.payment_type_code)

Line 958: oe_payments op,

954: ite.card_holder_name,
955: ite.card_number,
956: ite.card_expirydate
957: from oe_order_headers_all ooh,
958: oe_payments op,
959: iby_trxn_extensions_v ite
960: where ooh.header_id = p_x_header_payment_rec.header_id
961: and ooh.header_id = op.header_id
962: and op.trxn_extension_id = ite.trxn_extension_id;

Line 976: oe_payments op,

972: c.chname,
973: c.masked_cc_number,
974: c.expirydate
975: from oe_order_headers_all ooh,
976: oe_payments op,
977: iby_creditcard c,
978: iby_pmt_instr_uses_all u,
979: iby_fndcpt_tx_extensions x
980: where ooh.header_id = p_x_header_payment_rec.header_id

Line 2005: FROM OE_PAYMENTS

2001: BEGIN
2002:
2003: SELECT lock_control
2004: INTO l_lock_control
2005: FROM OE_PAYMENTS
2006: WHERE payment_number = p_Header_Payment_rec.payment_number
2007: AND header_id = p_Header_Payment_rec.header_id
2008: AND line_id IS NULL;
2009:

Line 2047: UPDATE OE_PAYMENTS

2043: END IF;
2044: END IF; /*code_release_level*/
2045: -- notification framework end
2046:
2047: UPDATE OE_PAYMENTS
2048: SET ATTRIBUTE1 = p_Header_Payment_rec.attribute1
2049: , ATTRIBUTE2 = p_Header_Payment_rec.attribute2
2050: , ATTRIBUTE3 = p_Header_Payment_rec.attribute3
2051: , ATTRIBUTE4 = p_Header_Payment_rec.attribute4

Line 2142: INSERT INTO OE_PAYMENTS

2138: IF l_debug_level > 0 THEN
2139: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2140: END IF;
2141:
2142: INSERT INTO OE_PAYMENTS
2143: ( ATTRIBUTE1
2144: , ATTRIBUTE2
2145: , ATTRIBUTE3
2146: , ATTRIBUTE4

Line 2326: FROM OE_PAYMENTS

2322:
2323:
2324: CURSOR payment IS
2325: SELECT payment_number, payment_collection_event,trxn_extension_id,payment_type_code --R12 CC Encryption
2326: FROM OE_PAYMENTS
2327: WHERE HEADER_ID = p_header_id
2328: AND line_id is NULL;
2329: -- added for notification framework
2330: l_new_header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;

Line 2446: DELETE FROM OE_PAYMENTS

2442: p_entity_id => p_header_id,
2443: x_return_status => l_return_status
2444: );
2445:
2446: DELETE FROM OE_PAYMENTS
2447: WHERE HEADER_ID = p_header_id
2448: AND LINE_ID IS NULL;
2449:
2450: --3382262

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

2448: AND LINE_ID IS NULL;
2449:
2450: --3382262
2451: IF l_debug_level > 0 THEN
2452: oe_debug_pub.add('1: after executing delete statement against oe_payments - before delete_payment_at_header');
2453: END IF;
2454: Delete_Payment_at_header(p_header_id => p_header_id,
2455: x_return_status => l_return_status,
2456: x_msg_count => l_msg_count,

Line 2557: FROM oe_payments

2553:
2554: BEGIN
2555: SELECT payment_collection_event,trxn_extension_id,payment_type_code --R12 CC Encryption
2556: INTO l_pmt_collection_event,l_trxn_extension_id,l_payment_type_code
2557: FROM oe_payments
2558: WHERE payment_number = p_payment_number
2559: AND header_id = p_header_id
2560: AND line_id is null;
2561: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2609: DELETE FROM OE_PAYMENTS

2605: RAISE FND_API.G_EXC_ERROR;
2606: END IF;
2607: END IF;
2608: --R12 CC Encryption
2609: DELETE FROM OE_PAYMENTS
2610: WHERE HEADER_ID = p_header_id
2611: AND PAYMENT_NUMBER = p_payment_number
2612: AND LINE_ID IS NULL
2613: ;

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

2613: ;
2614:
2615: --3382262
2616: IF l_debug_level > 0 THEN
2617: oe_debug_pub.add('2: after executing delete statement against oe_payments - before delete_payment_at_header');
2618: END IF;
2619: Delete_Payment_at_header(p_header_id => p_header_id,
2620: x_return_status => l_return_status,
2621: x_msg_count => l_msg_count,

Line 2649: FROM oe_payments

2645: -- the payment being deleted is a prepayment.
2646: BEGIN
2647: SELECT count(*)
2648: INTO l_prepay_count
2649: FROM oe_payments
2650: WHERE nvl(payment_collection_event, 'PREPAY') = 'PREPAY'
2651: AND header_id = p_header_id
2652: AND line_id is null;
2653: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2758: FROM OE_PAYMENTS

2754: , LOCK_CONTROL
2755: , PAYMENT_NUMBER
2756: , DEFER_PAYMENT_PROCESSING_FLAG
2757: , TRXN_EXTENSION_ID
2758: FROM OE_PAYMENTS
2759: WHERE ( PAYMENT_NUMBER = p_payment_number
2760: AND HEADER_ID = p_header_id
2761: AND LINE_ID IS NULL);
2762:

Line 2963: FROM OE_PAYMENTS

2959: , LOCK_CONTROL
2960: , PAYMENT_NUMBER
2961: , DEFER_PAYMENT_PROCESSING_FLAG
2962: , TRXN_EXTENSION_ID
2963: FROM OE_PAYMENTS
2964: WHERE HEADER_ID = p_header_id
2965: AND LINE_ID IS NULL
2966: ;
2967:

Line 3128: FROM oe_payments

3124: END IF;
3125:
3126: SELECT payment_number
3127: INTO l_payment_number
3128: FROM oe_payments
3129: WHERE payment_number = l_payment_number
3130: AND header_id = l_header_id
3131: AND line_id is null
3132: FOR UPDATE NOWAIT;

Line 3245: FROM oe_payments

3241: )
3242: IS
3243: CURSOR lock_hdr_Payments(p_header_id NUMBER) IS
3244: SELECT payment_number
3245: FROM oe_payments
3246: WHERE header_id = p_header_id
3247: AND line_id is NULL
3248: FOR UPDATE NOWAIT;
3249:

Line 3283: FROM OE_PAYMENTS

3279: p_header_id <> FND_API.G_MISS_NUM THEN
3280:
3281: SELECT payment_number
3282: INTO l_payment_number
3283: FROM OE_PAYMENTS
3284: WHERE payment_number = p_payment_number
3285: AND header_id = p_header_id
3286: AND line_id is NULL
3287: FOR UPDATE NOWAIT;

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

4121: oe_debug_pub.add('msg data'||l_msg_data);
4122: END IF;
4123: --Setting the trxn extension id as null as for transactions
4124: --coming from sales order others tab, the trxn extension id would
4125: --be updated in oe_payments table during updation.
4126: p_x_header_Payment_rec.trxn_extension_id := null;
4127:
4128: END IF;
4129:

Line 4184: from oe_payments

4180:
4181: Begin
4182:
4183: select count(payment_type_code) into p_count
4184: from oe_payments
4185: where header_id = p_header_id
4186: and nvl(payment_collection_event, 'PREPAY') = 'INVOICE'
4187: and line_id is null;
4188: