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_ITEMS

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