DBA Data[Home] [Help]

APPS.OE_NEGOTIATE_WF dependencies on WF_ITEMS

Line 877: from wf_items

873: BEGIN
874: -- Bug3435165
875: select count(1)
876: into l_wf_item_count
877: from wf_items
878: where item_type = 'OENH'
879: and item_key = p_header_id;
880:
881: IF l_wf_item_count = 0 THEN --we are in fulfillment phase and it has no nego phase

Line 1172: from wf_items

1168: BEGIN
1169: --Bug3435165
1170: select count(1)
1171: into l_wf_item_count
1172: from wf_items
1173: where item_type = 'OENH'
1174: and item_key = p_header_id;
1175:
1176: IF l_wf_item_count = 0 THEN --we are in fulfillment phase and it has no nego phase