APPS.OE_HEADER_PAYMENT_UTIL dependencies on OE_ORDER_HEADERS

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 1226: FROM oe_order_headers_all

1222: --bug3507871 start
1223: IF OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE then
1224: BEGIN
1225: SELECT booked_flag INTO l_booked_flag
1226: FROM oe_order_headers_all
1227: WHERE header_id=p_x_header_Payment_rec.header_id;
1228: IF (l_booked_flag = 'Y') THEN
1229: IF( l_debug_level > 0) THEN
1230: oe_debug_pub.add('pviprana: logging a new payment delayed request for making the order go on payment hold', 1);

Line 1309: FROM oe_order_headers_all

1305: --bug3625027 start
1306: BEGIN
1307: IF nvl(p_x_Header_Payment_rec.payment_collection_event,'PREPAY') = 'INVOICE' THEN
1308: SELECT booked_flag INTO l_booked_flag
1309: FROM oe_order_headers_all
1310: WHERE header_id=p_x_header_Payment_rec.header_id;
1311:
1312: IF p_old_header_payment_rec.payment_type_code IS NOT NULL THEN
1313: SELECT credit_check_flag INTO l_cc_flag_old

Line 2398: from oe_order_headers_all where

2394: --as the old invoice to org id needs to be passed to this api in
2395: --case of deleting the payments due to bill-to site change.
2396:
2397: /*select invoice_to_org_id into l_invoice_to_org_id --Verify
2398: from oe_order_headers_all where
2399: header_id = p_header_id;*/
2400: IF l_debug_level > 0 THEN
2401: oe_debug_pub.add('Deleting trxn id...'||l_pmt.trxn_extension_id);
2402: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);

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

2569: --as the old invoice to org id needs to be passed to this api in
2570: --case of deleting the payments due to bill-to site change.
2571:
2572: /*select invoice_to_org_id into l_invoice_to_org_id
2573: from oe_order_headers_all where header_id = p_header_id;*/
2574: IF l_debug_level > 0 THEN
2575: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2576: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);
2577: END IF;

Line 3593: from oe_order_headers

3589: --Querying the invoice to org id before checking the payment type
3590: --as it is needed for both credit card and check payments.
3591: select ordered_date, transactional_curr_code, invoice_to_org_id
3592: into l_ordered_date, l_transactional_curr_code, l_invoice_to_org_id
3593: from oe_order_headers
3594: where header_id=p_x_header_Payment_rec.header_id;
3595:
3596: IF l_debug_level > 0 THEN
3597: oe_debug_pub.add( 'l_transactional_curr_code:'||l_transactional_curr_code||':l_invoice_to_org_id:'||l_invoice_to_org_id);

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

4209: END IF;
4210:
4211: l_header_rec := l_old_header_rec;
4212:
4213: oe_debug_pub.add('before updating oe_order_headers_all ');
4214:
4215: update oe_order_headers_all
4216: set payment_type_code = null,
4217: payment_amount = null,

Line 4215: update oe_order_headers_all

4211: l_header_rec := l_old_header_rec;
4212:
4213: oe_debug_pub.add('before updating oe_order_headers_all ');
4214:
4215: update oe_order_headers_all
4216: set payment_type_code = null,
4217: payment_amount = null,
4218: check_number = null,
4219: credit_card_code = null,