DBA Data[Home] [Help]

APPS.OE_ORDER_WF_UTIL dependencies on WF_ITEM_ACTIVITY_STATUSES_H

Line 251: FROM wf_item_activity_statuses_h

247: -- Begin Changes for bug 8570400
248: BEGIN
249: SELECT item_key, item_type
250: INTO l_item_key, l_item_type --l_header_id ame er 16084377
251: FROM wf_item_activity_statuses_h
252: WHERE notification_id = TO_NUMBER (document_id);
253: EXCEPTION
254: WHEN TOO_MANY_ROWS
255: THEN

Line 385: FROM wf_item_activity_statuses_h

381: -- Begin Changes for bug 8570400
382: BEGIN
383: SELECT item_key
384: INTO l_line_id
385: FROM wf_item_activity_statuses_h
386: WHERE notification_id = TO_NUMBER (document_id);
387: EXCEPTION
388: WHEN TOO_MANY_ROWS
389: THEN

Line 3826: FROM wf_item_activity_statuses_h

3822: WHEN NO_DATA_FOUND
3823: THEN
3824: SELECT item_key, item_type
3825: INTO l_item_key, l_item_type
3826: FROM wf_item_activity_statuses_h
3827: WHERE notification_id = TO_NUMBER (document_id);
3828: END;
3829:
3830: /* 9047023: End */