eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AZW_PROC dependencies on WF_ITEM

Line 33: v_new_task_key wf_items.item_key%TYPE;

29: v_language fnd_languages.nls_language%TYPE;
30: v_days VARCHAR2(8);
31: v_done VARCHAR2(8);
32: v_skip VARCHAR2(8);
33: v_new_task_key wf_items.item_key%TYPE;
34: g_current_mode az_groups.process_type%TYPE;
35:
36: PROCEDURE update_hierarchy_status(p_item_type IN VARCHAR2,
37: p_process_name IN VARCHAR2,

Line 349: itm_k wf_items.item_key%TYPE;

345: FUNCTION parse_item_key(node_id IN VARCHAR2) RETURN VARCHAR2 IS
346:
347: v_last_sep PLS_INTEGER;
348: v_len PLS_INTEGER;
349: itm_k wf_items.item_key%TYPE;
350:
351: BEGIN
352:
353: v_last_sep := INSTR(node_id, '.', -1, 1);

Line 1944: FROM wf_items wfi, wf_item_attribute_values wiav

1940: -- get count of tasks for this process
1941: BEGIN
1942: SELECT count(*)
1943: INTO v_count
1944: FROM wf_items wfi, wf_item_attribute_values wiav
1945: WHERE wfi.item_type = p_type
1946: AND wfi.root_activity = p_name
1947: AND wiav.item_type = p_type
1948: AND wiav.item_key = wfi.item_key

Line 1957: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_count from wf_items,wf_item_attribute_values');

1953: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1954: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1955: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1956: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1957: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_count from wf_items,wf_item_attribute_values');
1958: APP_EXCEPTION.RAISE_EXCEPTION;
1959: END;
1960:
1961: IF (value <> 'N') THEN

Line 2054: select AZ_WF_ITEMKEY_S.nextval into itemkey from dual;

2050: prev_step varchar2(2000);
2051:
2052: BEGIN
2053:
2054: select AZ_WF_ITEMKEY_S.nextval into itemkey from dual;
2055:
2056: if (wf_item.Item_Exist(p_itemtype, itemkey)) then
2057: --wf_engine.handleerror(p_itemtype, itemkey, 'START', 'RETRY', null);
2058: null;

Line 2056: if (wf_item.Item_Exist(p_itemtype, itemkey)) then

2052: BEGIN
2053:
2054: select AZ_WF_ITEMKEY_S.nextval into itemkey from dual;
2055:
2056: if (wf_item.Item_Exist(p_itemtype, itemkey)) then
2057: --wf_engine.handleerror(p_itemtype, itemkey, 'START', 'RETRY', null);
2058: null;
2059: else
2060:

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 2153: FROM wf_items wfi, wf_process_activities wpa,

2149:
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

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 2404: v_key wf_items.item_key%TYPE;

2400: FUNCTION az_reassign_task(node_id IN VARCHAR2, p_role IN VARCHAR2)
2401: RETURN VARCHAR2
2402: IS
2403: v_type az_processes.item_type%TYPE;
2404: v_key wf_items.item_key%TYPE;
2405: p_name az_processes.process_name%TYPE;
2406: label az_webform_messages.mesg%TYPE;
2407:
2408: BEGIN

Line 2439: v_key wf_items.item_key%TYPE;

2435: --
2436: FUNCTION az_abort_task(node_id IN VARCHAR2) RETURN VARCHAR2
2437: IS
2438: v_type az_processes.item_type%TYPE;
2439: v_key wf_items.item_key%TYPE;
2440: p_name az_processes.process_name%TYPE;
2441: label az_webform_messages.mesg%TYPE;
2442: p_role wf_roles.name%TYPE;
2443:

Line 2480: v_key wf_items.item_key%TYPE;

2476: --
2477: FUNCTION get_task_label(node_id IN VARCHAR2) RETURN VARCHAR2
2478: IS
2479: v_type az_processes.item_type%TYPE;
2480: v_key wf_items.item_key%TYPE;
2481: p_name az_processes.process_name%TYPE;
2482: label az_webform_messages.mesg%TYPE;
2483: p_role wf_roles.name%TYPE;
2484:

Line 2516: v_key wf_items.item_key%TYPE;

2512: --
2513: FUNCTION get_task_status(node_id IN VARCHAR2) RETURN VARCHAR2
2514: IS
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:

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 2523: FROM wf_items wfi, wf_process_activities wpa,

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,
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

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

Line 2576: FROM az_processes ap,wf_items wfi, wf_item_attribute_values wiav

2572: PROCEDURE populate_process_status IS
2573:
2574: CURSOR az_process_active_cursor IS
2575: SELECT ap.item_type, ap.process_name, ap.context_id
2576: FROM az_processes ap,wf_items wfi, wf_item_attribute_values wiav
2577: WHERE wfi.item_type = ap.item_type
2578: AND wfi.root_activity = ap.process_name
2579: AND wiav.item_type = wfi.item_type
2580: AND wiav.item_key = wfi.item_key

Line 2679: FROM wf_items wi

2675: PROCEDURE abort_running_tasks IS
2676:
2677: CURSOR running_tasks IS
2678: SELECT distinct wi.item_type, wi.item_key
2679: FROM wf_items wi
2680: WHERE wi.item_type like 'AZW%'
2681: AND wi.end_date is NULL;
2682:
2683: v_item_type wf_items.item_type%TYPE;

Line 2683: v_item_type wf_items.item_type%TYPE;

2679: FROM wf_items wi
2680: WHERE wi.item_type like 'AZW%'
2681: AND wi.end_date is NULL;
2682:
2683: v_item_type wf_items.item_type%TYPE;
2684: v_item_key wf_items.item_key%TYPE;
2685:
2686: BEGIN
2687:

Line 2684: v_item_key wf_items.item_key%TYPE;

2680: WHERE wi.item_type like 'AZW%'
2681: AND wi.end_date is NULL;
2682:
2683: v_item_type wf_items.item_type%TYPE;
2684: v_item_key wf_items.item_key%TYPE;
2685:
2686: BEGIN
2687:
2688: OPEN running_tasks;

Line 2725: v_type wf_items.item_type%TYPE;

2721: IS
2722:
2723: v_count NUMBER;
2724: v_return BOOLEAN;
2725: v_type wf_items.item_type%TYPE;
2726: v_name wf_items.root_activity%TYPE;
2727:
2728: BEGIN
2729:

Line 2726: v_name wf_items.root_activity%TYPE;

2722:
2723: v_count NUMBER;
2724: v_return BOOLEAN;
2725: v_type wf_items.item_type%TYPE;
2726: v_name wf_items.root_activity%TYPE;
2727:
2728: BEGIN
2729:
2730: --