APPS.OKS_WF_K_PROCESS_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 745: FROM wf_item_activity_statuses wias, wf_process_activities wpa

741: l_rowfound BOOLEAN := FALSE;
742: l_api_name CONSTANT VARCHAR2(50) := 'activity_exist_in_process';
743: CURSOR check_activity_csr IS
744: SELECT '1'
745: FROM wf_item_activity_statuses wias, wf_process_activities wpa
746: WHERE wias.item_type = p_item_type
747: AND wias.item_key = p_item_key
748: AND wias.process_activity = wpa.instance_id
749: AND wpa.ACTIVITY_ITEM_TYPE = p_item_type

Line 789: FROM wf_item_activity_statuses wias, wf_process_activities wpa

785: l_api_name CONSTANT VARCHAR2(50) := 'get_notified_activity';
786:
787: CURSOR check_activity_csr IS
788: SELECT ACTIVITY_NAME
789: FROM wf_item_activity_statuses wias, wf_process_activities wpa
790: WHERE wias.item_type = p_item_type
791: AND wias.item_key = p_item_key
792: AND wias.process_activity = wpa.instance_id
793: AND wpa.ACTIVITY_ITEM_TYPE = p_item_type

Line 8297: l_result_out wf_item_activity_statuses.activity_result_code%TYPE;

8293: l_send_email_yn VARCHAR2(1) := 'N';
8294: l_reason VARCHAR2(250);
8295:
8296: l_item_key wf_items.item_key%TYPE;
8297: l_result_out wf_item_activity_statuses.activity_result_code%TYPE;
8298: l_process_status VARCHAR2(30);
8299: l_activity_name VARCHAR2(30);
8300: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
8301: