APPS.OE_HEADER_UTIL dependencies on OE_PAYMENTS

Line 1744: from oe_payments

1740: -- added by Renga for multiple payments
1741:
1742: cursor payment_count_cur is
1743: select count(payment_type_code)
1744: from oe_payments
1745: where header_id = p_x_header_rec.header_id
1746: and line_id is null;
1747:
1748: cursor delete_payment_count_cur is

Line 1750: from oe_payments

1746: and line_id is null;
1747:
1748: cursor delete_payment_count_cur is
1749: select count(payment_type_code)
1750: from oe_payments
1751: where header_id = p_x_header_rec.header_id
1752: and line_id is null
1753: and payment_type_code in ('CREDIT_CARD','ACH','DIRECT_DEBIT');
1754:

Line 2965: --These details not stored in oe_payments table now and centrally stored in payments tables

2961: IF p_x_header_rec.check_number = FND_API.G_MISS_CHAR THEN
2962: p_x_header_rec.check_number := p_old_header_rec.check_number;
2963: END IF;
2964: --R12 CC Encryption
2965: --These details not stored in oe_payments table now and centrally stored in payments tables
2966: /*
2967: IF p_x_header_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
2968: p_x_header_rec.credit_card_code := p_old_header_rec.credit_card_code;
2969: END IF;

Line 3629: --These details not stored in oe_payments table now and centrally stored in payments tables

3625: IF p_x_header_rec.check_number = FND_API.G_MISS_CHAR THEN
3626: p_x_header_rec.check_number := NULL;
3627: END IF;
3628: --R12 CC Encryption
3629: --These details not stored in oe_payments table now and centrally stored in payments tables
3630: /*
3631: IF p_x_header_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
3632: p_x_header_rec.credit_card_code := NULL;
3633: END IF;

Line 4717: FROM OE_PAYMENTS

4713:
4714: BEGIN
4715: SELECT 'Y',trxn_extension_id
4716: into l_exists,l_trxn_extension_id
4717: FROM OE_PAYMENTS
4718: WHERE header_id = p_header_id
4719: and line_id is null and
4720: nvl(payment_collection_event,'PREPAY') = 'INVOICE';
4721: EXCEPTION

Line 4725: oe_debug_pub.add('No record in oe_payments ...in query card details');

4721: EXCEPTION
4722: WHEN NO_DATA_FOUND THEN
4723: l_exists := 'N';
4724: IF l_debug_level >0 THEN
4725: oe_debug_pub.add('No record in oe_payments ...in query card details');
4726: oe_debug_pub.add('Header id passed...'||p_header_id);
4727: END IF;
4728: END;
4729:

Line 4788: from oe_payments where

4784: p_credit_card_expiration_date,
4785: p_credit_card_code,
4786: p_credit_card_approval_code,
4787: p_credit_card_approval_date
4788: from oe_payments where
4789: header_id = p_header_id and line_id is null
4790: and nvl(payment_collection_event,'PREPAY') = 'INVOICE';
4791: --Set the new attributes value to null as this record was created before R12
4792: p_instrument_security_code := NULL;

Line 5250: FROM oe_payments

5246:
5247: BEGIN
5248: SELECT trxn_extension_id
5249: INTO l_trxn_extension_id
5250: FROM oe_payments
5251: WHERE header_id = p_header_id
5252: AND nvl(payment_collection_event,'PREPAY') = 'INVOICE'
5253: AND payment_type_code = 'CREDIT_CARD'
5254: AND line_id is null;

Line 9112: --need to delete the payment record from oe_payments.

9108: --only Credit card payment type code is checked here.
9109: --Moreover, when the old payment type code is credit card, then need
9110: --to delete the trxn extension id created for this creditcard
9111: --When the old payment type is not null and the new one is null then
9112: --need to delete the payment record from oe_payments.
9113: IF( ( OE_GLOBALS.Equal(p_x_header_rec.payment_type_code, 'CREDIT_CARD') AND
9114: p_x_header_rec.credit_card_number is not null
9115: )
9116: OR (

Line 9138: FROM oe_payments

9134: --the payment record type as otherwise the process order
9135: --call was failing in Query_row procedure during update operation
9136: SELECT 'Y',payment_number,payment_type_code
9137: INTO l_payment_exists,l_payment_number,l_old_payment_type_code
9138: FROM oe_payments
9139: WHERE header_id = p_x_header_rec.header_id
9140: and line_id is null
9141: AND nvl(PAYMENT_COLLECTION_EVENT,'PREPAY') = 'INVOICE';
9142:

Line 9189: --Others tab and hence it is required to delete this record from oe_payments.

9185: --Verify
9186: IF l_payment_exists = 'Y' THEN
9187: --If the old payment type code is not null and the new payment type code
9188: --is null, then the payment record has been cleared by the user from the
9189: --Others tab and hence it is required to delete this record from oe_payments.
9190: IF l_old_payment_type_code IS NOT NULL
9191: AND p_x_header_rec.payment_type_code IS NULL THEN
9192: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_DELETE;
9193: -- bug 5035651

Line 9243: FROM OE_PAYMENTS

9239: --the prepayment record if there is an existing prepayment
9240: --for this header.
9241: BEGIN
9242: SELECT count(*) INTO l_prepay_count
9243: FROM OE_PAYMENTS
9244: WHERE HEADER_ID = p_x_header_rec.header_id
9245: AND LINE_ID IS NULL AND
9246: NVL(PAYMENT_COLLECTION_EVENT,'PREPAY') = 'PREPAY';
9247: EXCEPTION

Line 9261: FROM OE_PAYMENTS

9257: --payments, checking the line payments count before calling the
9258: --process order for inserting the prepayments.
9259: BEGIN
9260: SELECT COUNT(PAYMENT_TYPE_CODE) INTO l_line_payment_count
9261: FROM OE_PAYMENTS
9262: WHERE HEADER_ID = p_x_header_rec.header_id
9263: AND LINE_ID IS NOT NULL
9264: AND PAYMENT_TYPE_CODE <> 'COMMITMENT';
9265: EXCEPTION

Line 9275: --additional prepayment record in Oe_Payments as the payment

9271: oe_debug_pub.add('OEXUHDRB post write: line payment count...'||l_line_payment_count);
9272: END IF;
9273:
9274: --If prepayment count is zero, then need to insert an
9275: --additional prepayment record in Oe_Payments as the payment
9276: --term used has the prepayment check box checked
9277: IF nvl(l_prepay_count,0) = 0 and nvl(l_line_payment_count,0) = 0 THEN
9278: IF l_debug_level > 0 THEN
9279: oe_debug_pub.add('OEXUHDRB: Inside prepayment record insertion....'||l_prepay_count);