APPS.OE_PREPAYMENT_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 3188: FROM oe_order_headers_all

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:

Line 3357: Update oe_order_headers_all set

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);

Line 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;

Line 3466: from ra_terms rat, oe_order_headers_all oeh

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: */

Line 3484: from oe_order_headers_all

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;

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

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:

Line 3756: update 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:
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,

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

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: