[Home] [Help]
952: l_exists_prepay := 'N';
953: END;
954:
955: IF l_exists_prepay = 'Y' THEN
956: -- update prepaid_amount on oe_order_headers
957: UPDATE oe_payments
958: SET prepaid_amount = nvl(prepaid_amount,0) + l_pending_amount
959: WHERE header_id = l_header_rec.header_id
960: AND payment_type_code = 'CREDIT_CARD';
3166: select order_source_id, orig_sys_document_ref, change_sequence
3167: ,source_document_type_id, source_document_id
3168: into l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
3169: l_source_document_type_id, l_source_document_id
3170: from oe_order_headers where header_id = p_header_id;
3171: -- Set message context
3172: OE_MSG_PUB.set_msg_context(
3173: p_entity_code => 'HEADER'
3174: ,p_entity_id => p_header_id
3184: -- MOAC changes
3185: -- select fnd_profile.value('ORG_ID') into l_organization_id from DUAL;
3186: SELECT org_id
3187: INTO l_organization_id
3188: FROM oe_order_headers_all
3189: WHERE header_id = p_header_id;
3190:
3191: FND_REQUEST.set_org_id(l_organization_id);
3192:
3350: DELETE FROM OE_PAYMENTS
3351: WHERE HEADER_ID = p_header_id
3352: AND payment_number = header_payments_rec.payment_number
3353: AND line_id is null;
3354: --Need to update oe_order headers table with
3355: --null payment type code as it has been deleted from
3356: --oe_payments table.
3357: Update oe_order_headers_all set
3358: payment_type_code = null where
3353: AND line_id is null;
3354: --Need to update oe_order headers table with
3355: --null payment type code as it has been deleted from
3356: --oe_payments table.
3357: Update oe_order_headers_all set
3358: payment_type_code = null where
3359: header_id = p_header_id;
3360: IF l_debug_level > 0 THEN
3361: oe_debug_pub.add('Header id...after updating oe order headers all'||p_header_id);
3357: Update oe_order_headers_all set
3358: payment_type_code = null where
3359: header_id = p_header_id;
3360: IF l_debug_level > 0 THEN
3361: oe_debug_pub.add('Header id...after updating oe order headers all'||p_header_id);
3362: END IF;
3363: x_return_status := FND_API.G_RET_STS_SUCCESS;
3364: END IF;
3365: END IF;
3462: and line_id is null;
3463:
3464: /*
3465: and exists ( select null
3466: from ra_terms rat, oe_order_headers_all oeh
3467: where oeh.header_id = p_header_id
3468: and oeh.payment_term_id = rat.term_id
3469: and rat.prepayment_flag = 'Y' );
3470: */
3480: credit_card_approval_code,
3481: credit_card_approval_date, --bug3906851 */ --R12 CC Encryption
3482: payment_term_id,
3483: transactional_curr_code
3484: from oe_order_headers_all
3485: where header_id = p_header_id;
3486:
3487: l_payment_type_code varchar2(30) := NULL;
3488: l_payment_amount NUMBER := NULL;
3747: l_header_rec.credit_card_expiration_date := l_credit_card_expiration_date;
3748: l_header_rec.credit_card_approval_code := l_credit_card_approval_code;
3749: --bug3781675 end
3750:
3751: oe_debug_pub.add('before updating oe_order_headers_all ');
3752: oe_debug_pub.add('Credit card number'||l_credit_card_number);
3753: oe_debug_pub.add('Check number'||l_check_number);
3754: oe_debug_pub.add('PVIPRANA: l_del_payment is '|| l_del_payment);
3755:
3752: oe_debug_pub.add('Credit card number'||l_credit_card_number);
3753: oe_debug_pub.add('Check number'||l_check_number);
3754: oe_debug_pub.add('PVIPRANA: l_del_payment is '|| l_del_payment);
3755:
3756: update oe_order_headers_all
3757: set payment_type_code = l_payment_type_code,
3758: -- payment_amount = l_payment_amount, --bug 5185139
3759: check_number = l_check_number, --R12 CC Encryption
3760: /*credit_card_code = l_credit_card_code,
3764: credit_card_approval_code = l_credit_card_approval_code,*/ --R12 CC Encryption
3765: lock_control = lock_control + 1 --bug3781675
3766: where header_id = p_header_id;
3767:
3768: oe_debug_pub.add('after updating oe_order_headers_all');
3769: --bug3781675 start
3770:
3771: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3772: