APPS.OE_HEADER_UTIL dependencies on OE_PAYMENTS

Line 1776: from oe_payments

1772: -- added by Renga for multiple payments
1773:
1774: cursor payment_count_cur is
1775: select count(payment_type_code)
1776: from oe_payments
1777: where header_id = p_x_header_rec.header_id
1778: and line_id is null;
1779:
1780: cursor delete_payment_count_cur is

Line 1782: from oe_payments

1778: and line_id is null;
1779:
1780: cursor delete_payment_count_cur is
1781: select count(payment_type_code)
1782: from oe_payments
1783: where header_id = p_x_header_rec.header_id
1784: and line_id is null
1785: and payment_type_code in ('CREDIT_CARD','ACH','DIRECT_DEBIT');
1786:

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

3080: IF p_x_header_rec.check_number = FND_API.G_MISS_CHAR THEN
3081: p_x_header_rec.check_number := p_old_header_rec.check_number;
3082: END IF;
3083: --R12 CC Encryption
3084: --These details not stored in oe_payments table now and centrally stored in payments tables
3085: --kadiraju Uncommented the below code for Bug#13499934 Begin
3086: --/*
3087: IF p_x_header_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
3088: p_x_header_rec.credit_card_code := p_old_header_rec.credit_card_code;

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

3760: IF p_x_header_rec.check_number = FND_API.G_MISS_CHAR THEN
3761: p_x_header_rec.check_number := NULL;
3762: END IF;
3763: --R12 CC Encryption
3764: --These details not stored in oe_payments table now and centrally stored in payments tables
3765: --kadiraju Uncommented the below code for Bug#13499934 Begin
3766: --/*
3767: IF p_x_header_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
3768: p_x_header_rec.credit_card_code := NULL;

Line 4867: FROM OE_PAYMENTS

4863:
4864: BEGIN
4865: SELECT 'Y',trxn_extension_id
4866: into l_exists,l_trxn_extension_id
4867: FROM OE_PAYMENTS
4868: WHERE header_id = p_header_id
4869: and line_id is null and
4870: nvl(payment_collection_event,'PREPAY') = 'INVOICE';
4871: EXCEPTION

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

4871: EXCEPTION
4872: WHEN NO_DATA_FOUND THEN
4873: l_exists := 'N';
4874: IF l_debug_level >0 THEN
4875: oe_debug_pub.add('No record in oe_payments ...in query card details');
4876: oe_debug_pub.add('Header id passed...'||p_header_id);
4877: END IF;
4878: END;
4879:

Line 4938: from oe_payments where

4934: p_credit_card_expiration_date,
4935: p_credit_card_code,
4936: p_credit_card_approval_code,
4937: p_credit_card_approval_date
4938: from oe_payments where
4939: header_id = p_header_id and line_id is null
4940: and nvl(payment_collection_event,'PREPAY') = 'INVOICE';
4941: --Set the new attributes value to null as this record was created before R12
4942: p_instrument_security_code := NULL;

Line 5400: FROM oe_payments

5396:
5397: BEGIN
5398: SELECT trxn_extension_id
5399: INTO l_trxn_extension_id
5400: FROM oe_payments
5401: WHERE header_id = p_header_id
5402: AND nvl(payment_collection_event,'PREPAY') = 'INVOICE'
5403: AND payment_type_code = 'CREDIT_CARD'
5404: AND line_id is null;

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

9324: --only Credit card payment type code is checked here.
9325: --Moreover, when the old payment type code is credit card, then need
9326: --to delete the trxn extension id created for this creditcard
9327: --When the old payment type is not null and the new one is null then
9328: --need to delete the payment record from oe_payments.
9329: IF( ( OE_GLOBALS.Equal(p_x_header_rec.payment_type_code, 'CREDIT_CARD') AND
9330: p_x_header_rec.credit_card_number is not null
9331: )
9332: OR (

Line 9355: FROM oe_payments

9351: --the payment record type as otherwise the process order
9352: --call was failing in Query_row procedure during update operation
9353: SELECT 'Y',payment_number,payment_type_code
9354: INTO l_payment_exists,l_payment_number,l_old_payment_type_code
9355: FROM oe_payments
9356: WHERE header_id = p_x_header_rec.header_id
9357: and line_id is null
9358: AND nvl(PAYMENT_COLLECTION_EVENT,'PREPAY') = 'INVOICE';
9359:

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

9403: --Verify
9404: IF l_payment_exists = 'Y' THEN
9405: --If the old payment type code is not null and the new payment type code
9406: --is null, then the payment record has been cleared by the user from the
9407: --Others tab and hence it is required to delete this record from oe_payments.
9408: IF l_old_payment_type_code IS NOT NULL
9409: AND p_x_header_rec.payment_type_code IS NULL THEN
9410: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_DELETE;
9411: -- bug 5035651

Line 9461: FROM OE_PAYMENTS

9457: --the prepayment record if there is an existing prepayment
9458: --for this header.
9459: BEGIN
9460: SELECT count(*) INTO l_prepay_count
9461: FROM OE_PAYMENTS
9462: WHERE HEADER_ID = p_x_header_rec.header_id
9463: AND LINE_ID IS NULL AND
9464: NVL(PAYMENT_COLLECTION_EVENT,'PREPAY') = 'PREPAY';
9465: EXCEPTION

Line 9479: FROM OE_PAYMENTS

9475: --payments, checking the line payments count before calling the
9476: --process order for inserting the prepayments.
9477: BEGIN
9478: SELECT COUNT(PAYMENT_TYPE_CODE) INTO l_line_payment_count
9479: FROM OE_PAYMENTS
9480: WHERE HEADER_ID = p_x_header_rec.header_id
9481: AND LINE_ID IS NOT NULL
9482: AND PAYMENT_TYPE_CODE <> 'COMMITMENT';
9483: EXCEPTION

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

9489: oe_debug_pub.add('OEXUHDRB post write: line payment count...'||l_line_payment_count);
9490: END IF;
9491:
9492: --If prepayment count is zero, then need to insert an
9493: --additional prepayment record in Oe_Payments as the payment
9494: --term used has the prepayment check box checked
9495: IF nvl(l_prepay_count,0) = 0 and nvl(l_line_payment_count,0) = 0 THEN
9496: IF l_debug_level > 0 THEN
9497: oe_debug_pub.add('OEXUHDRB: Inside prepayment record insertion....'||l_prepay_count);