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 1226: FROM oe_payments

1222: IF (p_x_Line_Payment_rec.operation ='CREATE'AND p_x_Line_Payment_rec.payment_type_code<>'CREDIT_CARD' ) THEN
1223: -- check if there is any header level invoice payment with credit card then only log verify payment
1224: BEGIN
1225: SELECT 'Y' INTO l_header_inv_cc_payment
1226: FROM oe_payments
1227: WHERE header_id=p_x_Line_Payment_rec.header_id
1228: AND PAYMENT_COLLECTION_EVENT ='INVOICE'
1229: AND PAYMENT_TYPE_CODE='CREDIT_CARD'
1230: AND rownum<2;

Line 1903: FROM OE_PAYMENTS

1899: BEGIN
1900:
1901: SELECT lock_control
1902: INTO l_lock_control
1903: FROM OE_PAYMENTS
1904: WHERE payment_number = p_Line_Payment_rec.payment_number
1905: AND header_id = p_Line_Payment_rec.header_id
1906: AND line_id = p_Line_Payment_rec.line_id;
1907:

Line 1945: UPDATE OE_PAYMENTS

1941: END IF;
1942: END IF; /*code_release_level*/
1943: -- notification framework end
1944:
1945: UPDATE OE_PAYMENTS
1946: SET ATTRIBUTE1 = p_Line_Payment_rec.attribute1
1947: , ATTRIBUTE2 = p_Line_Payment_rec.attribute2
1948: , ATTRIBUTE3 = p_Line_Payment_rec.attribute3
1949: , ATTRIBUTE4 = p_Line_Payment_rec.attribute4

Line 2059: INSERT INTO OE_PAYMENTS

2055: END IF;
2056: END IF;
2057:
2058:
2059: INSERT INTO OE_PAYMENTS
2060: ( ATTRIBUTE1
2061: , ATTRIBUTE2
2062: , ATTRIBUTE3
2063: , ATTRIBUTE4

Line 2246: FROM OE_PAYMENTS

2242: --R12 CC Encryption
2243:
2244: CURSOR payment IS
2245: SELECT payment_number, payment_type_code,trxn_extension_id
2246: FROM OE_PAYMENTS
2247: WHERE LINE_ID = p_line_id
2248: AND HEADER_ID = p_header_id;
2249: -- added for notification framework
2250: l_new_line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;

Line 2363: DELETE FROM OE_PAYMENTS

2359: p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
2360: p_entity_id => p_line_id,
2361: x_return_status => l_return_status
2362: );
2363: DELETE FROM OE_PAYMENTS
2364: WHERE LINE_ID = p_line_id
2365: AND HEADER_ID = p_header_id;
2366:
2367: --3382262

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

2365: AND HEADER_ID = p_header_id;
2366:
2367: --3382262
2368: IF l_debug_level > 0 THEN
2369: oe_debug_pub.add('1: after executing delete statement against oe_payments - before delete_payment_at_line');
2370: END IF;
2371:
2372:
2373: Delete_Payment_at_line(p_line_id => p_line_id,

Line 2479: from oe_payments

2475: );
2476:
2477: Begin
2478: select payment_type_code,trxn_extension_id into p_payment_type_code,l_trxn_extension_id
2479: from oe_payments
2480: where payment_number = p_payment_number
2481: and line_id = p_line_id
2482: and header_id = p_header_id;
2483:

Line 2489: from oe_payments

2485: when no_data_found then
2486:
2487: Begin
2488: select payment_type_code,trxn_extension_id into p_payment_type_code,l_trxn_extension_id --R12 CC Encryption
2489: from oe_payments
2490: where line_id = p_line_id
2491: and payment_number is null
2492: and header_id = p_header_id;
2493:

Line 2552: DELETE FROM OE_PAYMENTS

2548: END IF;
2549: END IF;
2550: --R12 CC Encryption
2551:
2552: DELETE FROM OE_PAYMENTS
2553: WHERE PAYMENT_NUMBER = p_payment_number
2554: AND LINE_ID = p_line_id
2555: AND HEADER_ID = p_header_id
2556: ;

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

2556: ;
2557:
2558: --3382262
2559: IF l_debug_level > 0 THEN
2560: oe_debug_pub.add('2: after executing delete statement against oe_payments - before delete_payment_at_line');
2561: END IF;
2562:
2563:
2564: Delete_Payment_at_line(p_line_id => p_line_id,

Line 2689: FROM OE_PAYMENTS

2685: , LOCK_CONTROL
2686: , PAYMENT_NUMBER
2687: , DEFER_PAYMENT_PROCESSING_FLAG
2688: , TRXN_EXTENSION_ID
2689: FROM OE_PAYMENTS
2690: WHERE ( PAYMENT_NUMBER = p_payment_number
2691: AND LINE_ID = p_line_id
2692: AND HEADER_ID = p_header_id
2693: );

Line 2898: FROM OE_PAYMENTS

2894: , LOCK_CONTROL
2895: , PAYMENT_NUMBER
2896: , DEFER_PAYMENT_PROCESSING_FLAG
2897: , TRXN_EXTENSION_ID
2898: FROM OE_PAYMENTS
2899: WHERE LINE_ID = p_line_id
2900: AND HEADER_ID = p_header_id
2901: ;
2902:

Line 3064: FROM oe_payments

3060: END IF;
3061:
3062: SELECT payment_number
3063: INTO l_payment_number
3064: FROM oe_payments
3065: WHERE payment_number = l_payment_number
3066: AND line_id = l_line_id
3067: AND header_id = l_header_id
3068: FOR UPDATE NOWAIT;

Line 3184: FROM oe_payments

3180: )
3181: IS
3182: CURSOR lock_lin_Payments(p_line_id NUMBER) IS
3183: SELECT payment_number
3184: FROM oe_payments
3185: WHERE line_id = p_line_id
3186: AND header_id = p_header_id
3187: FOR UPDATE NOWAIT;
3188:

Line 3222: FROM OE_PAYMENTS

3218: p_line_id <> FND_API.G_MISS_NUM THEN
3219:
3220: SELECT payment_number
3221: INTO l_payment_number
3222: FROM OE_PAYMENTS
3223: WHERE payment_number = p_payment_number
3224: AND line_id = p_line_id
3225: AND header_id = p_header_id
3226: FOR UPDATE NOWAIT;

Line 3610: FROM oe_payments

3606:
3607: BEGIN
3608: SELECT 'Y'
3609: INTO l_is_split_payment
3610: FROM oe_payments
3611: WHERE header_id = p_x_line_Payment_rec.header_id
3612: AND line_id = p_x_line_Payment_rec.line_id
3613: AND payment_type_code IS NULL
3614: AND credit_card_approval_code = 'CVV2_REQUIRED';

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

4071: END IF;
4072:
4073: --Setting the trxn extension id as null as for transactions
4074: --coming from sales order others tab, the trxn extension id would
4075: --be updated in oe_payments table during updation.
4076: p_x_line_payment_rec.trxn_extension_id := null;
4077: END IF; --Payment type condtion
4078: --R12 CC Encryption
4079: EXCEPTION