DBA Data[Home] [Help]

APPS.OE_ORDER_WF_UTIL dependencies on OE_BLANKET_HEADERS_ALL

Line 89: oe_blanket_headers_all header

85: CURSOR find_bktngohdrprocessname (itemkey VARCHAR2)
86: IS
87: SELECT wf_assign.process_name
88: FROM oe_workflow_assignments wf_assign,
89: oe_blanket_headers_all header
90: WHERE header.header_id = TO_NUMBER (itemkey)
91: AND header.order_type_id = wf_assign.order_type_id
92: AND SYSDATE >= wf_assign.start_date_active
93: AND TRUNC (SYSDATE) <= NVL (wf_assign.end_date_active, SYSDATE)

Line 101: oe_blanket_headers_all blanket

97: CURSOR find_blankethdrprocessname (itemkey VARCHAR2)
98: IS
99: SELECT wf_assign.process_name
100: FROM oe_workflow_assignments wf_assign,
101: oe_blanket_headers_all blanket
102: WHERE blanket.header_id = TO_NUMBER (itemkey)
103: AND blanket.order_type_id = wf_assign.order_type_id
104: AND SYSDATE >= wf_assign.start_date_active
105: AND TRUNC (SYSDATE) <= NVL (wf_assign.end_date_active, SYSDATE)

Line 1349: FROM oe_blanket_headers_all

1345: ELSIF oe_globals.g_sales_document_type_code = 'B'
1346: THEN
1347: SELECT header_id
1348: INTO l_header_id
1349: FROM oe_blanket_headers_all
1350: WHERE header_id = oe_globals.g_start_negotiate_header_flow;
1351: END IF;
1352:
1353: IF l_debug_level > 0

Line 1387: FROM oe_blanket_headers_all

1383: -- The create of the header could have been rolled back
1384: -- but the PL/SQL global is not in synch.
1385: SELECT header_id
1386: INTO l_header_id
1387: FROM oe_blanket_headers_all
1388: WHERE header_id = oe_globals.g_start_blanket_header_flow;
1389:
1390: IF l_debug_level > 0
1391: THEN

Line 1992: FROM oe_blanket_headers_all

1988: END IF;
1989:
1990: SELECT lock_control
1991: INTO l_blanket_lock_control
1992: FROM oe_blanket_headers_all
1993: WHERE header_id = p_header_id
1994: FOR UPDATE NOWAIT;
1995:
1996: /* avoid dependency on blanket code, do a direct lock row

Line 2017: UPDATE oe_blanket_headers_all

2013: ,p_header_id => p_header_id);
2014:
2015:
2016: */
2017: UPDATE oe_blanket_headers_all
2018: SET flow_status_code = p_flow_status_code
2019: --Bug 8435596
2020: ,
2021: last_update_date = SYSDATE,

Line 2040: FROM oe_blanket_headers_all

2036:
2037: -- lock row or select for update here
2038: SELECT lock_control
2039: INTO l_blanket_lock_control
2040: FROM oe_blanket_headers_all
2041: WHERE header_id = p_header_id
2042: FOR UPDATE NOWAIT;
2043:
2044: /* avoid dependency on blanket API

Line 2057: UPDATE oe_blanket_headers_all

2053: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2055: END IF;
2056: */-- set msg context follows
2057: UPDATE oe_blanket_headers_all
2058: SET flow_status_code = p_flow_status_code
2059: --Bug 8435596
2060: ,
2061: last_update_date = SYSDATE,

Line 3210: FROM oe_blanket_headers_all

3206: ELSIF l_sales_document_type_code = 'B'
3207: THEN -- Blanket Negotitation/Fulfillment
3208: SELECT lock_control
3209: INTO l_blanket_lock_control
3210: FROM oe_blanket_headers_all
3211: WHERE header_id = l_header_id
3212: FOR UPDATE NOWAIT;
3213:
3214: /* avoid dependency on blanket API

Line 3236: UPDATE oe_blanket_headers_all

3232:
3233: */
3234: IF p_flow_status_code IS NOT NULL
3235: THEN
3236: UPDATE oe_blanket_headers_all
3237: SET flow_status_code = p_flow_status_code
3238: --Bug 8435596
3239: ,
3240: last_update_date = SYSDATE,

Line 3250: UPDATE oe_blanket_headers_all

3246: END IF;
3247:
3248: IF p_open_flag IS NOT NULL
3249: THEN
3250: UPDATE oe_blanket_headers_all
3251: SET open_flag = p_open_flag,
3252: -- Bug 12849250
3253: last_update_date = SYSDATE,
3254: last_updated_by = fnd_global.user_id,

Line 3288: UPDATE oe_blanket_headers_all

3284: END IF;
3285:
3286: IF p_draft_submitted_flag IS NOT NULL
3287: THEN
3288: UPDATE oe_blanket_headers_all
3289: SET draft_submitted_flag = p_draft_submitted_flag,
3290: -- Bug 12849250
3291: last_update_date = SYSDATE,
3292: last_updated_by = fnd_global.user_id,

Line 3301: UPDATE oe_blanket_headers_all

3297: END IF;
3298:
3299: IF l_updated_flag = 'Y'
3300: THEN
3301: UPDATE oe_blanket_headers_all
3302: SET lock_control = lock_control + 1
3303: WHERE header_id = l_header_id;
3304: END IF;
3305: END IF; --check sales_document_type_code

Line 3987: FROM oe_blanket_headers_all headers,

3983: INTO l_order_number, l_creation_date,
3984: l_ship_to_address, l_invoice_to_address, l_payment_term,
3985: l_blanket_min_amount, l_blanket_max_amount,
3986: l_start_date_active, l_end_date_active, l_org_id
3987: FROM oe_blanket_headers_all headers,
3988: oe_blanket_headers_ext blnk_ext,
3989: hz_cust_site_uses_all shipto,
3990: hz_cust_site_uses_all invoiceto,
3991: ra_terms_tl terms