APPS.OE_VALIDATE_WF dependencies on OE_WORKFLOW_ASSIGNMENTS

Line 880: FROM oe_workflow_assignments

876: -- Cursor Decleration
877: CURSOR c_all_line_flows(c_type_id NUMBER) IS
878: SELECT process_name,
879: item_type_code /* Bug # 4908592 */
880: FROM oe_workflow_assignments
881: WHERE order_type_id = c_type_id
882: AND line_type_id IS NOT NULL
883: AND NVL(wf_item_type,'OEOL') = 'OEOL'
884: AND SYSDATE >= start_date_active

Line 2045: FROM oe_workflow_assignments

2041:
2042: BEGIN
2043: SELECT DISTINCT process_name
2044: INTO l_line_process_name
2045: FROM oe_workflow_assignments
2046: WHERE order_type_id = l_order_type_id
2047: AND line_type_id IS NOT NULL
2048: AND NVL(wf_item_type,'OEOL') = 'OEOL'
2049: AND SYSDATE >= start_date_active

Line 2342: FROM oe_workflow_assignments

2338: AND TRUNC(SYSDATE) <= NVL(end_date_active, SYSDATE);
2339:
2340: CURSOR c_line_item_process(c_type_id NUMBER) IS
2341: SELECT DISTINCT process_name, item_type_code
2342: FROM oe_workflow_assignments
2343: WHERE order_type_id = c_type_id
2344: AND line_type_id IS NOT NULL
2345: AND NVL(wf_item_type, 'OEOL') = 'OEOL'
2346: AND SYSDATE >= start_date_active

Line 2351: FROM oe_workflow_assignments

2347: AND TRUNC(SYSDATE) <= nvl(end_date_active, SYSDATE);
2348:
2349: CURSOR c_line_process(c_type_id NUMBER) IS
2350: SELECT DISTINCT process_name
2351: FROM oe_workflow_assignments
2352: WHERE order_type_id = c_type_id
2353: AND line_type_id IS NOT NULL
2354: AND NVL(wf_item_type,'OEOL') = 'OEOL'
2355: AND SYSDATE >= start_date_active

Line 2360: FROM oe_workflow_assignments

2356: AND TRUNC(SYSDATE) <= nvl(end_date_active, SYSDATE);
2357:
2358: CURSOR c_other_process(c_type_id NUMBER, c_item_type VARCHAR2) IS
2359: SELECT DISTINCT process_name
2360: FROM oe_workflow_assignments
2361: WHERE order_type_id = c_type_id
2362: AND wf_item_type = c_item_type
2363: AND SYSDATE >= start_date_active
2364: AND TRUNC(SYSDATE) <= nvl(end_date_active, SYSDATE);

Line 2451: -- from oe_workflow_assignments;

2447:
2448: IF l_transaction_tbl(l_record_count).sales_document_type_code='O' THEN
2449: -- Uunconditionally for pre-11.5.10 releases)
2450: -- Getting associated order header() internal workflow process name
2451: -- from oe_workflow_assignments;
2452:
2453: BEGIN
2454: SELECT process_name
2455: INTO l_process_name

Line 2456: FROM oe_workflow_assignments

2452:
2453: BEGIN
2454: SELECT process_name
2455: INTO l_process_name
2456: FROM oe_workflow_assignments
2457: WHERE order_type_id = l_transaction_tbl(l_record_count).transaction_type_id
2458: AND line_type_id IS NULL
2459: AND wf_item_type = 'OEOH'
2460: AND SYSDATE >= start_date_active

Line 2484: /* Selecting from oe_workflow_assignments distinct order line

2480:
2481: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2483: END IF;
2484: /* Selecting from oe_workflow_assignments distinct order line
2485: (OEOL) internal workflow process names and OM item type
2486: combinations assigned to this order type */
2487:
2488: FOR line_item_processes IN c_line_item_process(l_transaction_tbl(l_record_count).transaction_type_id) LOOP

Line 2501: /* Selecting from oe_workflow_assignments distinct order line

2497: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2499: END IF;
2500: END LOOP; -- line_item_processes
2501: /* Selecting from oe_workflow_assignments distinct order line
2502: (OEOL) internal workflow process names assigned to this
2503: order type */
2504:
2505: FOR line_processes IN c_line_process(l_transaction_tbl(l_record_count).transaction_type_id) LOOP

Line 2526: -- process name from oe_workflow_assignments

2522:
2523: ELSIF l_transaction_tbl(l_record_count).sales_document_type_code='B' THEN
2524: -- not applicable to pre-11.5.10 releases
2525: -- Getting associated blanket header (OEBH) internal workflow
2526: -- process name from oe_workflow_assignments
2527: FOR blanket_processes IN c_other_process(l_transaction_tbl(l_record_count).transaction_type_id, OE_GLOBALS.G_WFI_BKT) LOOP
2528:
2529: OE_VALIDATE_WF.VALIDATE_ORDER_FLOW
2530: ( p_name => blanket_processes.process_name

Line 2548: oe_workflow_assignments; */

2544:
2545: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
2546: /* Applicable for Release 11.5.10 + only: Getting the associated
2547: negotiation header (OENH) internal workflow process name from
2548: oe_workflow_assignments; */
2549: FOR negotiation_processes IN c_other_process(l_transaction_tbl(l_record_count).transaction_type_id, OE_GLOBALS.G_WFI_NGO) LOOP
2550:
2551: OE_VALIDATE_WF.VALIDATE_ORDER_FLOW
2552: ( p_name => negotiation_processes.process_name