DBA Data[Home] [Help]

APPS.OE_LINE_FULLFILL dependencies on WF_ITEM_ACTIVITY_STATUS

Line 1594: FROM WF_ITEM_ACTIVITY_STATUSES wias, WF_PROCESS_ACTIVITIES wpa

1590: END IF;
1591:
1592: SELECT wias.ACTIVITY_STATUS, wias.ACTIVITY_RESULT_CODE, wias.PROCESS_ACTIVITY
1593: INTO x_activity_status_code, x_activity_result, x_activity_id
1594: FROM WF_ITEM_ACTIVITY_STATUSES wias, WF_PROCESS_ACTIVITIES wpa
1595: WHERE wias.ITEM_KEY = p_item_key
1596: AND wias.ITEM_TYPE = p_item_type
1597: AND wpa.ACTIVITY_NAME = p_activity_name
1598: AND wias.PROCESS_ACTIVITY = wpa.INSTANCE_ID;

Line 4055: wf_item_activity_status.create_status('OEOL',to_char(l_item_key),l_activity_id,'NOTIFIED',NULL,SYSDATE,null);

4051: oe_debug_pub.add('activity status - '||l_activity_status , 3 ) ;
4052: END IF;
4053: /*Added for bug 8790623*/
4054: IF l_activity_status = 'DEFERRED' THEN
4055: wf_item_activity_status.create_status('OEOL',to_char(l_item_key),l_activity_id,'NOTIFIED',NULL,SYSDATE,null);
4056: l_activity_status:= NULL ;
4057: END IF ;
4058: /*Added for bug 8790623*/
4059: