DBA Data[Home] [Help]

APPS.OE_CONTRACTS_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 205: FROM oe_order_headers_all

201:
202: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
203: SELECT version_number
204: INTO l_latest_version_number
205: FROM oe_order_headers_all
206: WHERE header_id = p_copy_from_doc_id;
207:
208: END IF;
209: oe_debug_pub.add('l_latest_version_number for p_doc_type: '||p_doc_type || ' and p_copy_from_doc_id: '

Line 1183: FROM oe_order_headers_all

1179:
1180: --cursor to get the version number of the sales order
1181: CURSOR c_get_so_version (cp_header_id NUMBER) IS
1182: SELECT version_number
1183: FROM oe_order_headers_all
1184: WHERE header_id = cp_header_id;
1185: *********/
1186:
1187:

Line 1937: FROM oe_order_headers_all oh

1933: oh.shipping_method_code,
1934: oh.payment_term_id,
1935: oh.invoicing_rule_id,
1936: oh.org_id
1937: FROM oe_order_headers_all oh
1938:
1939: WHERE oh.header_id = p_doc_id;
1940:
1941:

Line 3346: FROM oe_order_headers_all a

3342:
3343: CURSOR find_ord_signed IS
3344: SELECT a.customer_signature,
3345: a.customer_signature_date
3346: FROM oe_order_headers_all a
3347: WHERE a.header_id = p_doc_id;
3348:
3349: BEGIN
3350: IF (l_debug_level > 0) THEN

Line 3360: oe_debug_pub.add('Fetching customer_signature and customer_signature_date from oe_order_headers_all ', 3);

3356: END IF;
3357: -- Initialize API return status to success
3358: x_return_status := FND_API.G_RET_STS_SUCCESS;
3359: IF l_debug_level > 0 THEN
3360: oe_debug_pub.add('Fetching customer_signature and customer_signature_date from oe_order_headers_all ', 3);
3361: oe_debug_pub.add('p_api_version: ' || p_api_version,3);
3362: oe_debug_pub.add('p_init_msg_list: ' || p_init_msg_list,3);
3363: oe_debug_pub.add('p_doc_id: ' || p_doc_id, 3);
3364: END IF;

Line 3488: FROM oe_order_headers_all

3484: IF p_target_doc_type = 'O' THEN
3485: BEGIN
3486: SELECT order_number
3487: INTO l_document_number
3488: FROM oe_order_headers_all
3489: WHERE header_id = p_target_doc_id;
3490: EXCEPTION
3491: WHEN NO_DATA_FOUND THEN
3492: l_document_number := NULL;

Line 4259: FROM oe_order_headers_all

4255: END IF;
4256: --Get the org_id
4257: BEGIN
4258: SELECT org_id into l_org_id
4259: FROM oe_order_headers_all
4260: WHERE header_id=p_doc_id;
4261: EXCEPTION
4262: when others then
4263: l_org_id:=NULL;