APPS.OE_ORDER_WF_UTIL dependencies on WF_ITEMS

Line 517: FROM wf_items

513: -- For OENH
514: -- Check if a OENH flow exists, if so set the parent
515: SELECT count(1)
516: INTO l_count
517: FROM wf_items
518: WHERE item_type=OE_GLOBALS.G_WFI_NGO
519: AND item_key =to_char(p_header_rec.header_id);
520:
521: IF l_count > 0 THEN

Line 1342: from wf_items

1338: docommit => false);
1339:
1340: select count(1)
1341: into l_count
1342: from wf_items
1343: where item_type=OE_GLOBALS.G_WFI_NGO
1344: and item_key=to_char(p_id);
1345:
1346: IF l_count > 0 THEN

Line 1414: from wf_items

1410: docommit => false);
1411:
1412: select count(1)
1413: into l_count
1414: from wf_items
1415: where item_type=OE_GLOBALS.G_WFI_NGO
1416: and item_key=to_char(p_id);
1417:
1418: IF l_count > 0 THEN

Line 2778: FROM wf_items

2774: -- For OEBH
2775: -- Check if a OENH flow exists, if so set the parent
2776: SELECT count(1)
2777: INTO l_count
2778: FROM wf_items
2779: WHERE item_type=OE_GLOBALS.G_WFI_NGO
2780: AND item_key =to_char(p_header_id);
2781:
2782: IF l_count > 0 THEN