APPS.AZW_REPORT dependencies on WF_PROCESS_ACTIVITIES

Line 148: g_prev_act_name wf_process_activities.activity_name%TYPE := NULL;

144: g_upper_process_names HierarchyLevels;
145: g_curr_process_level PLS_INTEGER;
146: g_inst_count PLS_INTEGER := 0;
147: g_instance_ids id_tbl_t;
148: g_prev_act_name wf_process_activities.activity_name%TYPE := NULL;
149:
150: /* Private Procedure Declarations ********************************************/
151:
152: PROCEDURE get_context_processes(p_context IN VARCHAR2);

Line 4522: v_item_type wf_process_activities.PROCESS_ITEM_TYPE%TYPE;

4518: AND PRIOR phase = phase;
4519:
4520: v_locator PLS_INTEGER := 0;
4521: v_upper_group_names HierarchyLevels;
4522: v_item_type wf_process_activities.PROCESS_ITEM_TYPE%TYPE;
4523: v_process_name wf_process_activities.PROCESS_NAME%TYPE;
4524: v_process_groups VARCHAR2(4000);
4525:
4526: BEGIN

Line 4523: v_process_name wf_process_activities.PROCESS_NAME%TYPE;

4519:
4520: v_locator PLS_INTEGER := 0;
4521: v_upper_group_names HierarchyLevels;
4522: v_item_type wf_process_activities.PROCESS_ITEM_TYPE%TYPE;
4523: v_process_name wf_process_activities.PROCESS_NAME%TYPE;
4524: v_process_groups VARCHAR2(4000);
4525:
4526: BEGIN
4527: print_time_stamp('Start report');

Line 5877: wf_process_activities wpa

5873: ,wiasv.activity_begin_date begin_date
5874: ,wiasv.activity_end_date end_date
5875: ,wiasv.notification_id
5876: FROM wf_item_activity_statuses_v wiasv,
5877: wf_process_activities wpa
5878: WHERE wiasv.item_type = p_item_type
5879: AND wiasv.item_key = p_item_key
5880: AND wiasv.item_type = wpa.process_item_type
5881: AND wpa.process_name = p_process_name

Line 6001: v_item_type wf_process_activities.PROCESS_ITEM_TYPE%TYPE;

5997: START WITH parent_node_id IS NULL
5998: CONNECT BY PRIOR node_id = parent_node_id
5999: AND PRIOR phase = phase;
6000:
6001: v_item_type wf_process_activities.PROCESS_ITEM_TYPE%TYPE;
6002: v_process_name wf_process_activities.PROCESS_NAME%TYPE;
6003:
6004: v_process_groups VARCHAR2(4000);
6005: v_last_printed VARCHAR2(4000);

Line 6002: v_process_name wf_process_activities.PROCESS_NAME%TYPE;

5998: CONNECT BY PRIOR node_id = parent_node_id
5999: AND PRIOR phase = phase;
6000:
6001: v_item_type wf_process_activities.PROCESS_ITEM_TYPE%TYPE;
6002: v_process_name wf_process_activities.PROCESS_NAME%TYPE;
6003:
6004: v_process_groups VARCHAR2(4000);
6005: v_last_printed VARCHAR2(4000);
6006: v_upper_group_names HierarchyLevels;

Line 6172: FROM wf_process_activities wpa

6168: proc_version NUMBER;
6169:
6170: CURSOR start_act_cur IS
6171: select instance_id, activity_name, start_end
6172: FROM wf_process_activities wpa
6173: where wpa.process_item_type = p_item_type
6174: and wpa.process_name = p_process_name
6175: and wpa.start_end = 'START'
6176: and wpa.process_version = proc_version;

Line 6289: act_type wf_process_activities.activity_item_type%TYPE;

6285: l_dname wf_activities_vl.display_name%TYPE;
6286:
6287: l_body wf_messages_vl.body%TYPE;
6288:
6289: act_type wf_process_activities.activity_item_type%TYPE;
6290: act_name wf_process_activities.activity_name%TYPE;
6291: v_result VARCHAR2(200);
6292:
6293: CURSOR act_cur IS

Line 6290: act_name wf_process_activities.activity_name%TYPE;

6286:
6287: l_body wf_messages_vl.body%TYPE;
6288:
6289: act_type wf_process_activities.activity_item_type%TYPE;
6290: act_name wf_process_activities.activity_name%TYPE;
6291: v_result VARCHAR2(200);
6292:
6293: CURSOR act_cur IS
6294: SELECT wat.to_process_activity instance_id, result_code

Line 6303: from wf_process_activities wpa

6299: BEGIN
6300:
6301: select activity_item_type, activity_name
6302: into act_type, act_name
6303: from wf_process_activities wpa
6304: where wpa.instance_id = p_instance_id;
6305:
6306: select type, message, display_name
6307: into l_act_type, l_mesg, l_dname