APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 1842: FROM OE_ORDER_HEADERS_ALL OOH

1838:
1839: BEGIN
1840: SELECT 1 /* MOAC_SQL_CHANGE */
1841: INTO l_ship_rule_count
1842: FROM OE_ORDER_HEADERS_ALL OOH
1843: WHERE OOH.HEADER_ID = p_header_id
1844: AND EXISTS
1845: (SELECT 'Line Shipped'
1846: FROM OE_ORDER_LINES OOL

Line 1886: FROM OE_ORDER_HEADERS_ALL OOH

1882:
1883: BEGIN
1884: SELECT 1 + l_ship_rule_count /* MOAC_SQL_CHANGE */
1885: INTO l_ship_rule_count
1886: FROM OE_ORDER_HEADERS_ALL OOH
1887: WHERE OOH.PAYMENT_TYPE_CODE = 'CREDIT_CARD'
1888: AND OOH.HEADER_ID = p_header_id
1889: AND EXISTS
1890: (SELECT 'Purchase Released'

Line 5736: FROM oe_order_headers_all

5732: ELSE
5733: BEGIN
5734: SELECT invoice_to_org_id, ship_to_org_id
5735: INTO l_invoice_to_org_id,l_ship_to_org_id
5736: FROM oe_order_headers_all
5737: WHERE header_id = p_header_rec.header_id;
5738: EXCEPTION WHEN NO_DATA_FOUND THEN
5739: null;
5740: END;

Line 5925: FROM oe_order_headers_all

5921: ELSE
5922: BEGIN
5923: SELECT invoice_to_org_id, ship_to_org_id
5924: INTO l_invoice_to_org_id,l_ship_to_org_id
5925: FROM oe_order_headers_all
5926: WHERE header_id = p_header_rec.header_id;
5927: EXCEPTION WHEN NO_DATA_FOUND THEN
5928: null;
5929: END;

Line 6338: UPDATE oe_order_headers_all

6334: -- table directly here as we did in 11i code, as the payment amount field is also
6335: -- used for Cash and Check payment type.
6336: -- if line_id is null, then this is for header invoice payment.
6337: IF l_payments_tbl(I).line_id IS NULL THEN
6338: UPDATE oe_order_headers_all
6339: SET payment_amount = l_amount.value
6340: , last_updated_by = FND_GLOBAL.USER_ID
6341: , last_update_date = SYSDATE
6342: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 6405: UPDATE oe_order_headers_all

6401: );
6402: END IF;
6403:
6404: -- update order header with the authorized amount for header invoice payment.
6405: UPDATE oe_order_headers_all
6406: SET payment_amount = l_amount.value
6407: , last_updated_by = FND_GLOBAL.USER_ID
6408: , last_update_date = SYSDATE
6409: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 8192: update oe_order_headers_all

8188: and payment_collection_event = 'INVOICE'
8189: and nvl(payment_number, -1) = nvl(p_payment_number, -1)
8190: and header_id = p_header_id;
8191:
8192: update oe_order_headers_all
8193: set credit_card_approval_code = p_auth_code
8194: , credit_card_approval_date = p_auth_date
8195: where header_id = p_header_id;
8196: END IF;

Line 9020: FROM OE_ORDER_HEADERS_ALL ordr ,

9016:
9017: BEGIN
9018: SELECT NVL(ordr_type.CREDIT_CARD_REV_REAUTH_CODE,oe_sys_parameters.value('OE_CC_REVERSAL_REAUTHORIZATION'))
9019: INTO l_cc_rev_reauth_code
9020: FROM OE_ORDER_HEADERS_ALL ordr ,
9021: OE_TRANSACTION_TYPES_ALL ordr_type
9022: WHERE ordr.ORDER_TYPE_ID = ordr_type.TRANSACTION_TYPE_ID
9023: AND ordr.header_id = p_header_id;
9024: EXCEPTION