APPS.OE_ORDER_WF_UTIL dependencies on OE_BLANKET_HEADERS_ALL

Line 80: oe_blanket_headers_all header

76:
77: CURSOR find_BktNgoHdrProcessname(itemkey varchar2) is
78: SELECT wf_assign.process_name
79: FROM oe_workflow_assignments wf_assign,
80: oe_blanket_headers_all header
81: WHERE header.header_id = to_number(itemkey)
82: and header.order_type_id = wf_assign.order_type_id
83: and sysdate >= wf_assign.start_date_active
84: and trunc(sysdate) <= nvl(wf_assign.end_date_active, sysdate)

Line 91: oe_blanket_headers_all blanket

87:
88: CURSOR find_BlanketHdrProcessname(itemkey varchar2) is
89: SELECT wf_assign.process_name
90: FROM oe_workflow_assignments wf_assign,
91: oe_blanket_headers_all blanket
92: WHERE blanket.header_id = to_number(itemkey)
93: and blanket.order_type_id = wf_assign.order_type_id
94: and sysdate >= wf_assign.start_date_active
95: and trunc(sysdate) <= nvl(wf_assign.end_date_active, sysdate)

Line 1215: from oe_blanket_headers_all

1211: where header_id = OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW;
1212: ELSIF OE_GLOBALS.G_SALES_DOCUMENT_TYPE_CODE = 'B' THEN
1213: Select header_id
1214: into l_header_id
1215: from oe_blanket_headers_all
1216: where header_id = OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW;
1217: END IF;
1218: IF l_debug_level > 0 THEN
1219: oe_debug_pub.add( 'STARTING NEGOTIATE HEADER FLOW' ) ;

Line 1242: from oe_blanket_headers_all

1238: -- The create of the header could have been rolled back
1239: -- but the PL/SQL global is not in synch.
1240: Select header_id
1241: into l_header_id
1242: from oe_blanket_headers_all
1243: where header_id = OE_GLOBALS.G_START_BLANKET_HEADER_FLOW;
1244:
1245: IF l_debug_level > 0 THEN
1246: oe_debug_pub.add( 'STARTING BLANKET HEADER FLOW' ) ;

Line 1655: FROM oe_blanket_headers_all

1651: END IF;
1652:
1653: SELECT lock_control
1654: INTO l_blanket_lock_control
1655: FROM oe_blanket_headers_all
1656: WHERE header_id = p_header_id
1657: FOR UPDATE NOWAIT;
1658:
1659: /* avoid dependency on blanket code, do a direct lock row

Line 1680: UPDATE OE_BLANKET_HEADERS_ALL

1676: ,p_header_id => p_header_id);
1677:
1678:
1679: */
1680: UPDATE OE_BLANKET_HEADERS_ALL
1681: SET FLOW_STATUS_CODE = p_flow_status_code
1682: , LOCK_CONTROL = LOCK_CONTROL + 1
1683: WHERE HEADER_ID = p_header_id;
1684:

Line 1695: FROM oe_blanket_headers_all

1691:
1692: -- lock row or select for update here
1693: SELECT lock_control
1694: INTO l_blanket_lock_control
1695: FROM oe_blanket_headers_all
1696: WHERE header_id = p_header_id
1697: FOR UPDATE NOWAIT;
1698:
1699: /* avoid dependency on blanket API

Line 1714: UPDATE OE_BLANKET_HEADERS_ALL

1710: END IF;
1711: */
1712: -- set msg context follows
1713:
1714: UPDATE OE_BLANKET_HEADERS_ALL
1715: SET FLOW_STATUS_CODE = p_flow_status_code
1716: , LOCK_CONTROL = LOCK_CONTROL + 1
1717: WHERE HEADER_ID = p_header_id;
1718:

Line 2508: FROM oe_blanket_headers_all

2504: END IF; -- bug 4732614 ends
2505: ELSIF l_sales_document_type_code = 'B' THEN -- Blanket Negotitation/Fulfillment
2506: SELECT lock_control
2507: INTO l_blanket_lock_control
2508: FROM oe_blanket_headers_all
2509: WHERE header_id = l_header_id
2510: FOR UPDATE NOWAIT;
2511:
2512: /* avoid dependency on blanket API

Line 2534: UPDATE OE_BLANKET_HEADERS_ALL

2530:
2531: */
2532:
2533: IF p_flow_status_code is not null THEN
2534: UPDATE OE_BLANKET_HEADERS_ALL
2535: SET FLOW_STATUS_CODE = p_flow_status_code
2536: WHERE HEADER_ID = l_header_id;
2537:
2538: l_updated_flag := 'Y';

Line 2542: UPDATE OE_BLANKET_HEADERS_ALL

2538: l_updated_flag := 'Y';
2539: END IF;
2540:
2541: IF p_open_flag is not null THEN
2542: UPDATE OE_BLANKET_HEADERS_ALL
2543: SET OPEN_FLAG = p_open_flag
2544: WHERE HEADER_ID = l_header_id;
2545:
2546: -- ZB put the code here

Line 2565: UPDATE OE_BLANKET_HEADERS_ALL

2561: l_updated_flag := 'Y';
2562: END IF;
2563:
2564: IF p_draft_submitted_flag is not null THEN
2565: UPDATE OE_BLANKET_HEADERS_ALL
2566: SET DRAFT_SUBMITTED_FLAG = p_draft_submitted_flag
2567: WHERE HEADER_ID = l_header_id;
2568:
2569: l_updated_flag := 'Y';

Line 2573: UPDATE OE_BLANKET_HEADERS_ALL

2569: l_updated_flag := 'Y';
2570: END IF;
2571:
2572: IF l_updated_flag = 'Y' THEN
2573: UPDATE OE_BLANKET_HEADERS_ALL
2574: SET LOCK_CONTROL = LOCK_CONTROL + 1
2575: WHERE HEADER_ID = l_header_id;
2576: END IF;
2577: END IF; --check sales_document_type_code

Line 3188: FROM oe_blanket_headers_all headers,

3184: INTO l_order_number, l_creation_date, l_ship_to_address, l_invoice_to_address,
3185: l_payment_term,
3186: l_blanket_min_amount, l_blanket_max_amount,
3187: l_start_date_active, l_end_date_active
3188: FROM oe_blanket_headers_all headers,
3189: oe_blanket_headers_ext blnk_ext,
3190: hz_cust_site_uses_all shipto,
3191: hz_cust_site_uses_all invoiceto,
3192: ra_terms_tl terms