APPS.OE_PAYMENT_TRXN_UTIL dependencies on OE_PAYMENTS

Line 571: UPDATE oe_payments

567: IF p_payment_type_code = 'CREDIT_CARD'
568: AND p_x_trxn_extension_id IS NULL
569: AND p_line_id IS NOT NULL
570: THEN
571: UPDATE oe_payments
572: SET credit_card_approval_code = NULL
573: WHERE header_id = p_header_id
574: AND line_id = p_line_id;
575: END IF;

Line 1245: -- update oe_payments table

1241: oe_debug_pub.add( 'OEXUPTXB.pls: After successful call to Create_New_Payment_Trxn');
1242: oe_debug_pub.add( 'New trxn extension --->'||l_trxn_extension_id);
1243: END IF;
1244:
1245: -- update oe_payments table
1246: p_trxn_extension_id := l_trxn_extension_id;
1247: END IF; --Security code use ='REQUIRED'
1248: --bug 5299050
1249: ELSIF NOT OE_GLOBALS.Is_Same_Credit_Card(l_old_card_number,

Line 1913: FROM oe_payments

1909: --< if l_trxn_extension_id is null, this might be called from sales order header>
1910: IF l_trxn_extension_id IS NULL THEN
1911: SELECT trxn_extension_id
1912: INTO l_trxn_extension_id
1913: FROM oe_payments
1914: WHERE header_id = p_header_id;
1915: IF l_debug_level > 0 THEN
1916: oe_debug_pub.add('Trxn extension id from oe_payments'||l_trxn_extension_id);
1917: END IF;

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

1912: INTO l_trxn_extension_id
1913: FROM oe_payments
1914: WHERE header_id = p_header_id;
1915: IF l_debug_level > 0 THEN
1916: oe_debug_pub.add('Trxn extension id from oe_payments'||l_trxn_extension_id);
1917: END IF;
1918:
1919: END IF;
1920: