APPS.OE_ORDER_WF_UTIL dependencies on WF_ITEMS

Line 613: FROM wf_items

609: -- For OENH
610: -- Check if a OENH flow exists, if so set the parent
611: SELECT COUNT (1)
612: INTO l_count
613: FROM wf_items
614: WHERE item_type = oe_globals.g_wfi_ngo
615: AND item_key = TO_CHAR (p_header_rec.header_id);
616:
617: IF l_count > 0

Line 1478: FROM wf_items

1474: THEN
1475: -- Start of 12609242
1476: SELECT COUNT (1)
1477: INTO l_count
1478: FROM wf_items
1479: WHERE item_type = oe_globals.g_wfi_hdr AND item_key = TO_CHAR (p_id);
1480:
1481: IF l_count > 0
1482: THEN

Line 1506: FROM wf_items

1502: END IF; --12609242
1503:
1504: SELECT COUNT (1)
1505: INTO l_count
1506: FROM wf_items
1507: WHERE item_type = oe_globals.g_wfi_ngo AND item_key = TO_CHAR (p_id);
1508:
1509: IF l_count > 0
1510: THEN

Line 1529: FROM wf_items

1525: THEN
1526: -- Start of 12609242
1527: SELECT COUNT (1)
1528: INTO l_count
1529: FROM wf_items
1530: WHERE item_type = oe_globals.g_wfi_lin
1531: AND item_key = TO_CHAR (p_id);
1532:
1533: IF l_count > 0

Line 1567: FROM wf_items

1563: THEN
1564: --Start of 13020709
1565: SELECT COUNT (1)
1566: INTO l_count
1567: FROM wf_items
1568: WHERE item_type = oe_globals.g_wfi_ngo AND item_key = TO_CHAR (p_id);
1569:
1570: IF l_count > 0
1571: THEN

Line 1602: FROM wf_items

1598: THEN
1599: -- Bug 8537639
1600: SELECT COUNT (1)
1601: INTO l_count
1602: FROM wf_items
1603: --where item_type=OE_GLOBALS.G_WFI_NGO
1604: WHERE item_type = oe_globals.g_wfi_bkt --13020709
1605: AND item_key = TO_CHAR (p_id);
1606:

Line 1638: FROM wf_items

1634: /* Bug 8537639 */
1635: --Uncommented below Select clause for bug 13020709
1636: SELECT COUNT (1)
1637: INTO l_count
1638: FROM wf_items
1639: WHERE item_type = oe_globals.g_wfi_ngo
1640: AND item_key = TO_CHAR (p_id);
1641:
1642: IF l_count > 0

Line 3542: FROM wf_items

3538: -- For OEBH
3539: -- Check if a OENH flow exists, if so set the parent
3540: SELECT COUNT (1)
3541: INTO l_count
3542: FROM wf_items
3543: WHERE item_type = oe_globals.g_wfi_ngo
3544: AND item_key = TO_CHAR (p_header_id);
3545:
3546: IF l_count > 0