DBA Data[Home] [Help]

APPS.OE_NEGOTIATE_WF dependencies on WF_ITEMS

Line 932: from wf_items

928: BEGIN
929: -- Bug3435165
930: select count(1)
931: into l_wf_item_count
932: from wf_items
933: where item_type = 'OENH'
934: and item_key = To_Char(p_header_id); -- Added to char function for bug 11793697
935:
936: IF l_wf_item_count = 0 THEN --we are in fulfillment phase and it has no nego phase

Line 1227: from wf_items

1223: BEGIN
1224: --Bug3435165
1225: select count(1)
1226: into l_wf_item_count
1227: from wf_items
1228: where item_type = 'OENH'
1229: and item_key = to_char(p_header_id); -- Bug 9209740, p_header_id conversion to char.
1230:
1231: IF l_wf_item_count = 0 THEN --we are in fulfillment phase and it has no nego phase