APPS.OE_HEADER_PAYMENT_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 957: from oe_order_headers_all ooh,

953: ite.card_issuer_code,
954: ite.card_holder_name,
955: ite.card_number,
956: ite.card_expirydate
957: from oe_order_headers_all ooh,
958: oe_payments op,
959: iby_trxn_extensions_v ite
960: where ooh.header_id = p_x_header_payment_rec.header_id
961: and ooh.header_id = op.header_id

Line 975: from oe_order_headers_all ooh,

971: c.card_issuer_code,
972: c.chname,
973: c.masked_cc_number,
974: c.expirydate
975: from oe_order_headers_all ooh,
976: oe_payments op,
977: iby_creditcard c,
978: iby_pmt_instr_uses_all u,
979: iby_fndcpt_tx_extensions x

Line 1200: FROM oe_order_headers_all

1196: --bug3507871 start
1197: IF OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE then
1198: BEGIN
1199: SELECT booked_flag INTO l_booked_flag
1200: FROM oe_order_headers_all
1201: WHERE header_id=p_x_header_Payment_rec.header_id;
1202: IF (l_booked_flag = 'Y') THEN
1203: IF( l_debug_level > 0) THEN
1204: oe_debug_pub.add('pviprana: logging a new payment delayed request for making the order go on payment hold', 1);

Line 1284: FROM oe_order_headers_all

1280: --bug3625027 start
1281: BEGIN
1282: IF nvl(p_x_Header_Payment_rec.payment_collection_event,'PREPAY') = 'INVOICE' THEN
1283: SELECT booked_flag INTO l_booked_flag
1284: FROM oe_order_headers_all
1285: WHERE header_id=p_x_header_Payment_rec.header_id;
1286:
1287: IF p_old_header_payment_rec.payment_type_code IS NOT NULL THEN
1288: SELECT credit_check_flag INTO l_cc_flag_old

Line 2312: from oe_order_headers_all where

2308: --as the old invoice to org id needs to be passed to this api in
2309: --case of deleting the payments due to bill-to site change.
2310:
2311: /*select invoice_to_org_id into l_invoice_to_org_id --Verify
2312: from oe_order_headers_all where
2313: header_id = p_header_id;*/
2314: IF l_debug_level > 0 THEN
2315: oe_debug_pub.add('Deleting trxn id...'||l_pmt.trxn_extension_id);
2316: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);

Line 2487: from oe_order_headers_all where header_id = p_header_id;*/

2483: --as the old invoice to org id needs to be passed to this api in
2484: --case of deleting the payments due to bill-to site change.
2485:
2486: /*select invoice_to_org_id into l_invoice_to_org_id
2487: from oe_order_headers_all where header_id = p_header_id;*/
2488: IF l_debug_level > 0 THEN
2489: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2490: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2491: END IF;

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

4088: END IF;
4089:
4090: l_header_rec := l_old_header_rec;
4091:
4092: oe_debug_pub.add('before updating oe_order_headers_all ');
4093:
4094: update oe_order_headers_all
4095: set payment_type_code = null,
4096: payment_amount = null,

Line 4094: update oe_order_headers_all

4090: l_header_rec := l_old_header_rec;
4091:
4092: oe_debug_pub.add('before updating oe_order_headers_all ');
4093:
4094: update oe_order_headers_all
4095: set payment_type_code = null,
4096: payment_amount = null,
4097: check_number = null,
4098: credit_card_code = null,