APPS.OE_PAYMENT_TRXN_UTIL dependencies on OE_PAYMENTS

Line 708: UPDATE oe_payments

704: IF p_payment_type_code = 'CREDIT_CARD'
705: AND p_x_trxn_extension_id IS NULL
706: AND p_line_id IS NOT NULL
707: THEN
708: UPDATE oe_payments
709: SET credit_card_approval_code = NULL
710: WHERE header_id = p_header_id
711: AND line_id = p_line_id;
712: END IF;

Line 1481: -- update oe_payments table

1477: end if;
1478: END IF;
1479: END;
1480: --CC Reversal ER#16014135 End
1481: -- update oe_payments table
1482: p_trxn_extension_id := l_trxn_extension_id;
1483: END IF; --Security code use ='REQUIRED'
1484: --bug 5299050
1485: ELSIF NOT OE_GLOBALS.Is_Same_Credit_Card(l_old_card_number,

Line 2246: FROM oe_payments

2242: --< if l_trxn_extension_id is null, this might be called from sales order header>
2243: IF l_trxn_extension_id IS NULL THEN
2244: SELECT trxn_extension_id
2245: INTO l_trxn_extension_id
2246: FROM oe_payments
2247: WHERE header_id = p_header_id;
2248: IF l_debug_level > 0 THEN
2249: oe_debug_pub.add('Trxn extension id from oe_payments'||l_trxn_extension_id);
2250: END IF;

Line 2249: oe_debug_pub.add('Trxn extension id from oe_payments'||l_trxn_extension_id);

2245: INTO l_trxn_extension_id
2246: FROM oe_payments
2247: WHERE header_id = p_header_id;
2248: IF l_debug_level > 0 THEN
2249: oe_debug_pub.add('Trxn extension id from oe_payments'||l_trxn_extension_id);
2250: END IF;
2251:
2252: END IF;
2253:

Line 2663: /* DELETE oe_payments

2659: oe_debug_pub.add('Call to Reverse_CreditCard_Auth --> Success',5);
2660: end if;
2661: --need to evaluate again
2662: IF p_line_id IS NOT NULL THEN
2663: /* DELETE oe_payments
2664: WHERE trxn_extension_id = p_trxn_extension_id
2665: AND header_id = p_header_id
2666: AND nvl(line_id,-1) = nvl(p_line_id,-1)
2667: ;*/ --Commented for CC Reversal ER bug# 16595030

Line 2678: FROM oe_payments

2674: -- Check if there is a header level invoice payment with cc
2675: BEGIN
2676: SELECT 'Y'
2677: INTO l_header_payment_exists
2678: FROM oe_payments
2679: WHERE header_id =p_header_id
2680: AND line_id is null --Added for CC Reversal ER bug# 16595030
2681: AND PAYMENT_COLLECTION_EVENT='INVOICE'
2682: AND PAYMENT_TYPE_CODE='CREDIT_CARD';

Line 3012: FROM OE_PAYMENTS

3008: END IF;
3009: BEGIN
3010: SELECT trxn_extension_id
3011: INTO l_trxn_extension_id
3012: FROM OE_PAYMENTS
3013: WHERE HEADER_ID = p_header_id and line_id is null
3014: AND nvl(payment_collection_event,'PREPAY') = 'INVOICE';
3015: EXCEPTION WHEN NO_DATA_FOUND THEN
3016: IF l_debug_level > 0 THEN

Line 3027: FROM OE_PAYMENTS

3023: oe_debug_pub.add('Before getting trxn id line_id '||p_line_id||' and header_id '||p_header_id,5);
3024: END IF;
3025: SELECT trxn_extension_id
3026: INTO l_trxn_extension_id
3027: FROM OE_PAYMENTS
3028: WHERE line_id = p_line_id
3029: AND header_id = p_header_id
3030: AND payment_type_code <> 'COMMITMENT';
3031: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 3174: /* UPDATE oe_payments

3170: IF l_debug_level > 0 THEN
3171: oe_debug_pub.ADD('kadiraju new trx '||oe_verify_payment_pub.G_CC_Change_Flag);
3172: END IF;
3173: oe_verify_payment_pub.G_CC_Change_Flag := 'Y';
3174: /* UPDATE oe_payments
3175: SET trxn_extension_id = p_new_trxn_extension_id
3176: WHERE header_id = p_header_id
3177: AND trxn_extension_id=l_trxn_extension_id;
3178: