APPS.AZW_PROC dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 2142: v_begin_date wf_item_activity_statuses.begin_date%TYPE;

2138: --
2139: FUNCTION get_old_task_label(p_type VARCHAR2, p_key VARCHAR2, p_name VARCHAR2,
2140: p_role VARCHAR2) RETURN VARCHAR2
2141: IS
2142: v_begin_date wf_item_activity_statuses.begin_date%TYPE;
2143: v_display_status wf_resources.text%TYPE;
2144: v_label az_webform_messages.mesg%TYPE;
2145: v_task_tot_days NUMBER(5) := 0;
2146: v_count NUMBER(5) := 0;

Line 2148: v_task_status wf_item_activity_statuses.activity_status%TYPE;

2144: v_label az_webform_messages.mesg%TYPE;
2145: v_task_tot_days NUMBER(5) := 0;
2146: v_count NUMBER(5) := 0;
2147: v_skip_count NUMBER(4) := 0;
2148: v_task_status wf_item_activity_statuses.activity_status%TYPE;
2149:
2150: CURSOR az_tasks_days_cursor IS
2151: SELECT round( months_between(sysdate, wfi.begin_date)* 31),
2152: wias.activity_status

Line 2154: wf_item_activity_statuses wias

2150: CURSOR az_tasks_days_cursor IS
2151: SELECT round( months_between(sysdate, wfi.begin_date)* 31),
2152: wias.activity_status
2153: FROM wf_items wfi, wf_process_activities wpa,
2154: wf_item_activity_statuses wias
2155: WHERE wfi.item_type = p_type
2156: AND wfi.root_activity = p_name
2157: AND wfi.item_key = p_key
2158: AND wias.item_type = wfi.item_type

Line 2168: FROM wf_process_activities wpa, wf_item_activity_statuses wias,

2164:
2165: CURSOR az_task_display_cursor IS
2166: SELECT wav.display_name,
2167: wias.begin_date
2168: FROM wf_process_activities wpa, wf_item_activity_statuses wias,
2169: wf_activities_vl wav
2170: WHERE wias.item_type = p_type
2171: AND wias.item_key = p_key
2172: AND wias.process_activity = wpa.instance_id

Line 2184: FROM wf_item_activity_statuses wias, wf_notification_attributes wna,

2180: ORDER BY wias.begin_date desc;
2181:
2182: CURSOR az_steps_count_cursor IS
2183: SELECT COUNT(*)
2184: FROM wf_item_activity_statuses wias, wf_notification_attributes wna,
2185: wf_notifications wn
2186: WHERE wias.item_type = p_type
2187: AND wias.item_key = p_key
2188: AND wias.notification_id IS NOT NULL

Line 2197: FROM wf_item_activity_statuses wias, wf_notification_attributes wna,

2193: AND wna.text_value LIKE '%DONE%';
2194:
2195: CURSOR az_skip_count_cursor IS
2196: SELECT COUNT(*)
2197: FROM wf_item_activity_statuses wias, wf_notification_attributes wna,
2198: wf_notifications wn
2199: WHERE wias.item_type = p_type
2200: AND wias.item_key = p_key
2201: AND wias.notification_id is not NULL

Line 2269: v_begin_date wf_item_activity_statuses.begin_date%TYPE;

2265: p_role VARCHAR2, p_ctxt_id VARCHAR2)
2266: RETURN VARCHAR2
2267: IS
2268: label az_webform_messages.mesg%TYPE;
2269: v_begin_date wf_item_activity_statuses.begin_date%TYPE;
2270: v_display_status wf_resources.text%TYPE;
2271: v_mesg az_webform_messages.mesg%TYPE;
2272: v_node_id VARCHAR2(300);
2273: v_parent_node_id VARCHAR2(300);

Line 2278: FROM wf_process_activities wpa, wf_item_activity_statuses wias,

2274:
2275: CURSOR az_task_display_cursor IS
2276: SELECT wav.display_name,
2277: wias.begin_date
2278: FROM wf_process_activities wpa, wf_item_activity_statuses wias,
2279: wf_activities_vl wav
2280: WHERE wias.item_type = p_type
2281: AND wias.item_key = v_new_task_key
2282: AND wias.process_activity = wpa.instance_id

Line 2519: v_task_status wf_item_activity_statuses.activity_status%TYPE;

2515: v_type az_processes.item_type%TYPE;
2516: v_key wf_items.item_key%TYPE;
2517: p_name az_processes.process_name%TYPE;
2518: label az_webform_messages.mesg%TYPE;
2519: v_task_status wf_item_activity_statuses.activity_status%TYPE;
2520:
2521: CURSOR az_task_status_cursor IS
2522: SELECT wias.activity_status
2523: FROM wf_items wfi, wf_process_activities wpa,

Line 2524: wf_item_activity_statuses wias

2520:
2521: CURSOR az_task_status_cursor IS
2522: SELECT wias.activity_status
2523: FROM wf_items wfi, wf_process_activities wpa,
2524: wf_item_activity_statuses wias
2525: WHERE wfi.item_type = v_type
2526: AND wfi.root_activity = p_name
2527: AND wfi.item_key = v_key
2528: AND wias.item_type = wfi.item_type