APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 1770: FROM OE_ORDER_HEADERS_ALL OOH

1766:
1767: BEGIN
1768: SELECT 1 /* MOAC_SQL_CHANGE */
1769: INTO l_ship_rule_count
1770: FROM OE_ORDER_HEADERS_ALL OOH
1771: WHERE OOH.HEADER_ID = p_header_id
1772: AND EXISTS
1773: (SELECT 'Line Shipped'
1774: FROM OE_ORDER_LINES OOL

Line 1813: FROM OE_ORDER_HEADERS_ALL OOH

1809:
1810: BEGIN
1811: SELECT 1 + l_ship_rule_count /* MOAC_SQL_CHANGE */
1812: INTO l_ship_rule_count
1813: FROM OE_ORDER_HEADERS_ALL OOH
1814: WHERE OOH.PAYMENT_TYPE_CODE = 'CREDIT_CARD'
1815: AND OOH.HEADER_ID = p_header_id
1816: AND EXISTS
1817: (SELECT 'Purchase Released'

Line 5582: FROM oe_order_headers_all

5578: ELSE
5579: BEGIN
5580: SELECT invoice_to_org_id, ship_to_org_id
5581: INTO l_invoice_to_org_id,l_ship_to_org_id
5582: FROM oe_order_headers_all
5583: WHERE header_id = p_header_rec.header_id;
5584: EXCEPTION WHEN NO_DATA_FOUND THEN
5585: null;
5586: END;

Line 5761: FROM oe_order_headers_all

5757: ELSE
5758: BEGIN
5759: SELECT invoice_to_org_id, ship_to_org_id
5760: INTO l_invoice_to_org_id,l_ship_to_org_id
5761: FROM oe_order_headers_all
5762: WHERE header_id = p_header_rec.header_id;
5763: EXCEPTION WHEN NO_DATA_FOUND THEN
5764: null;
5765: END;

Line 6086: UPDATE oe_order_headers_all

6082: -- table directly here as we did in 11i code, as the payment amount field is also
6083: -- used for Cash and Check payment type.
6084: -- if line_id is null, then this is for header invoice payment.
6085: IF l_payments_tbl(I).line_id IS NULL THEN
6086: UPDATE oe_order_headers_all
6087: SET payment_amount = l_amount.value
6088: , last_updated_by = FND_GLOBAL.USER_ID
6089: , last_update_date = SYSDATE
6090: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 6132: UPDATE oe_order_headers_all

6128: );
6129: END IF;
6130:
6131: -- update order header with the authorized amount for header invoice payment.
6132: UPDATE oe_order_headers_all
6133: SET payment_amount = l_amount.value
6134: , last_updated_by = FND_GLOBAL.USER_ID
6135: , last_update_date = SYSDATE
6136: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 7548: update oe_order_headers_all

7544: and payment_collection_event = 'INVOICE'
7545: and nvl(payment_number, -1) = nvl(p_payment_number, -1)
7546: and header_id = p_header_id;
7547:
7548: update oe_order_headers_all
7549: set credit_card_approval_code = p_auth_code
7550: , credit_card_approval_date = p_auth_date
7551: where header_id = p_header_id;
7552: END IF;