DBA Data[Home] [Help]

APPS.OE_PREPAYMENT_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 3322: FROM oe_order_headers_all

3318: -- MOAC changes
3319: -- select fnd_profile.value('ORG_ID') into l_organization_id from DUAL;
3320: SELECT org_id
3321: INTO l_organization_id
3322: FROM oe_order_headers_all
3323: WHERE header_id = p_header_id;
3324:
3325: FND_REQUEST.set_org_id(l_organization_id);
3326:

Line 3491: Update oe_order_headers_all set

3487: AND line_id is null;
3488: --Need to update oe_order headers table with
3489: --null payment type code as it has been deleted from
3490: --oe_payments table.
3491: Update oe_order_headers_all set
3492: payment_type_code = null where
3493: header_id = p_header_id;
3494: IF l_debug_level > 0 THEN
3495: oe_debug_pub.add('Header id...after updating oe order headers all'||p_header_id);

Line 3495: oe_debug_pub.add('Header id...after updating oe order headers all'||p_header_id);

3491: Update oe_order_headers_all set
3492: payment_type_code = null where
3493: header_id = p_header_id;
3494: IF l_debug_level > 0 THEN
3495: oe_debug_pub.add('Header id...after updating oe order headers all'||p_header_id);
3496: END IF;
3497: x_return_status := FND_API.G_RET_STS_SUCCESS;
3498: END IF;
3499: END IF;

Line 3600: from ra_terms rat, oe_order_headers_all oeh

3596: and line_id is null;
3597:
3598: /*
3599: and exists ( select null
3600: from ra_terms rat, oe_order_headers_all oeh
3601: where oeh.header_id = p_header_id
3602: and oeh.payment_term_id = rat.term_id
3603: and rat.prepayment_flag = 'Y' );
3604: */

Line 3618: from oe_order_headers_all

3614: credit_card_approval_code,
3615: credit_card_approval_date, --bug3906851 */ --R12 CC Encryption
3616: payment_term_id,
3617: transactional_curr_code
3618: from oe_order_headers_all
3619: where header_id = p_header_id;
3620:
3621: l_payment_type_code varchar2(30) := NULL;
3622: l_payment_amount NUMBER := NULL;

Line 3885: oe_debug_pub.add('before updating oe_order_headers_all ');

3881: l_header_rec.credit_card_expiration_date := l_credit_card_expiration_date;
3882: l_header_rec.credit_card_approval_code := l_credit_card_approval_code;
3883: --bug3781675 end
3884:
3885: oe_debug_pub.add('before updating oe_order_headers_all ');
3886: --oe_debug_pub.add('Credit card number'||l_credit_card_number);
3887: oe_debug_pub.add('Check number'||l_check_number);
3888: oe_debug_pub.add('PVIPRANA: l_del_payment is '|| l_del_payment);
3889:

Line 3890: update oe_order_headers_all

3886: --oe_debug_pub.add('Credit card number'||l_credit_card_number);
3887: oe_debug_pub.add('Check number'||l_check_number);
3888: oe_debug_pub.add('PVIPRANA: l_del_payment is '|| l_del_payment);
3889:
3890: update oe_order_headers_all
3891: set payment_type_code = l_payment_type_code,
3892: -- payment_amount = l_payment_amount, --bug 5185139
3893: check_number = l_check_number, --R12 CC Encryption
3894: /*credit_card_code = l_credit_card_code,

Line 3902: oe_debug_pub.add('after updating oe_order_headers_all');

3898: credit_card_approval_code = l_credit_card_approval_code,*/ --R12 CC Encryption
3899: lock_control = lock_control + 1 --bug3781675
3900: where header_id = p_header_id;
3901:
3902: oe_debug_pub.add('after updating oe_order_headers_all');
3903: --bug3781675 start
3904:
3905: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3906: