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 1928: FROM OE_PAYMENTS

1924: BEGIN
1925:
1926: SELECT lock_control
1927: INTO l_lock_control
1928: FROM OE_PAYMENTS
1929: WHERE payment_number = p_Header_Payment_rec.payment_number
1930: AND header_id = p_Header_Payment_rec.header_id
1931: AND line_id IS NULL;
1932:

Line 1970: UPDATE OE_PAYMENTS

1966: END IF;
1967: END IF; /*code_release_level*/
1968: -- notification framework end
1969:
1970: UPDATE OE_PAYMENTS
1971: SET ATTRIBUTE1 = p_Header_Payment_rec.attribute1
1972: , ATTRIBUTE2 = p_Header_Payment_rec.attribute2
1973: , ATTRIBUTE3 = p_Header_Payment_rec.attribute3
1974: , ATTRIBUTE4 = p_Header_Payment_rec.attribute4

Line 2060: INSERT INTO OE_PAYMENTS

2056: IF l_debug_level > 0 THEN
2057: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2058: END IF;
2059:
2060: INSERT INTO OE_PAYMENTS
2061: ( ATTRIBUTE1
2062: , ATTRIBUTE2
2063: , ATTRIBUTE3
2064: , ATTRIBUTE4

Line 2240: FROM OE_PAYMENTS

2236:
2237:
2238: CURSOR payment IS
2239: SELECT payment_number, payment_collection_event,trxn_extension_id,payment_type_code --R12 CC Encryption
2240: FROM OE_PAYMENTS
2241: WHERE HEADER_ID = p_header_id
2242: AND line_id is NULL;
2243: -- added for notification framework
2244: l_new_header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;

Line 2360: DELETE FROM OE_PAYMENTS

2356: p_entity_id => p_header_id,
2357: x_return_status => l_return_status
2358: );
2359:
2360: DELETE FROM OE_PAYMENTS
2361: WHERE HEADER_ID = p_header_id
2362: AND LINE_ID IS NULL;
2363:
2364: --3382262

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

2362: AND LINE_ID IS NULL;
2363:
2364: --3382262
2365: IF l_debug_level > 0 THEN
2366: oe_debug_pub.add('1: after executing delete statement against oe_payments - before delete_payment_at_header');
2367: END IF;
2368: Delete_Payment_at_header(p_header_id => p_header_id,
2369: x_return_status => l_return_status,
2370: x_msg_count => l_msg_count,

Line 2471: FROM oe_payments

2467:
2468: BEGIN
2469: SELECT payment_collection_event,trxn_extension_id,payment_type_code --R12 CC Encryption
2470: INTO l_pmt_collection_event,l_trxn_extension_id,l_payment_type_code
2471: FROM oe_payments
2472: WHERE payment_number = p_payment_number
2473: AND header_id = p_header_id
2474: AND line_id is null;
2475: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2523: DELETE FROM OE_PAYMENTS

2519: RAISE FND_API.G_EXC_ERROR;
2520: END IF;
2521: END IF;
2522: --R12 CC Encryption
2523: DELETE FROM OE_PAYMENTS
2524: WHERE HEADER_ID = p_header_id
2525: AND PAYMENT_NUMBER = p_payment_number
2526: AND LINE_ID IS NULL
2527: ;

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

2527: ;
2528:
2529: --3382262
2530: IF l_debug_level > 0 THEN
2531: oe_debug_pub.add('2: after executing delete statement against oe_payments - before delete_payment_at_header');
2532: END IF;
2533: Delete_Payment_at_header(p_header_id => p_header_id,
2534: x_return_status => l_return_status,
2535: x_msg_count => l_msg_count,

Line 2563: FROM oe_payments

2559: -- the payment being deleted is a prepayment.
2560: BEGIN
2561: SELECT count(*)
2562: INTO l_prepay_count
2563: FROM oe_payments
2564: WHERE nvl(payment_collection_event, 'PREPAY') = 'PREPAY'
2565: AND header_id = p_header_id
2566: AND line_id is null;
2567: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2671: FROM OE_PAYMENTS

2667: , LOCK_CONTROL
2668: , PAYMENT_NUMBER
2669: , DEFER_PAYMENT_PROCESSING_FLAG
2670: , TRXN_EXTENSION_ID
2671: FROM OE_PAYMENTS
2672: WHERE ( PAYMENT_NUMBER = p_payment_number
2673: AND HEADER_ID = p_header_id
2674: AND LINE_ID IS NULL);
2675:

Line 2874: FROM OE_PAYMENTS

2870: , LOCK_CONTROL
2871: , PAYMENT_NUMBER
2872: , DEFER_PAYMENT_PROCESSING_FLAG
2873: , TRXN_EXTENSION_ID
2874: FROM OE_PAYMENTS
2875: WHERE HEADER_ID = p_header_id
2876: AND LINE_ID IS NULL
2877: ;
2878:

Line 3038: FROM oe_payments

3034: END IF;
3035:
3036: SELECT payment_number
3037: INTO l_payment_number
3038: FROM oe_payments
3039: WHERE payment_number = l_payment_number
3040: AND header_id = l_header_id
3041: AND line_id is null
3042: FOR UPDATE NOWAIT;

Line 3155: FROM oe_payments

3151: )
3152: IS
3153: CURSOR lock_hdr_Payments(p_header_id NUMBER) IS
3154: SELECT payment_number
3155: FROM oe_payments
3156: WHERE header_id = p_header_id
3157: AND line_id is NULL
3158: FOR UPDATE NOWAIT;
3159:

Line 3193: FROM OE_PAYMENTS

3189: p_header_id <> FND_API.G_MISS_NUM THEN
3190:
3191: SELECT payment_number
3192: INTO l_payment_number
3193: FROM OE_PAYMENTS
3194: WHERE payment_number = p_payment_number
3195: AND header_id = p_header_id
3196: AND line_id is NULL
3197: FOR UPDATE NOWAIT;

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

4000: oe_debug_pub.add('msg data'||l_msg_data);
4001: END IF;
4002: --Setting the trxn extension id as null as for transactions
4003: --coming from sales order others tab, the trxn extension id would
4004: --be updated in oe_payments table during updation.
4005: p_x_header_Payment_rec.trxn_extension_id := null;
4006:
4007: END IF;
4008:

Line 4063: from oe_payments

4059:
4060: Begin
4061:
4062: select count(payment_type_code) into p_count
4063: from oe_payments
4064: where header_id = p_header_id
4065: and nvl(payment_collection_event, 'PREPAY') = 'INVOICE'
4066: and line_id is null;
4067: