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.XNP_CVU_PKG dependencies on WF_PROCESS_ACTIVITIES

Line 1914: FROM wf_process_activities pat, xdp_workitems wi

1910: IS
1911: SELECT pat.process_name process_name,
1912: pat.process_item_type process_item_type,
1913: max(pat.process_version) process_version
1914: FROM wf_process_activities pat, xdp_workitems wi
1915: WHERE
1916: -- xdp_workitem - process
1917: pat.process_name = wi.user_wf_process_name
1918: AND pat.process_item_type = wi.user_wf_item_type

Line 1930: FROM wf_process_activities pat, wf_activities ac, wf_activity_attr_values atv

1926: SELECT pat.instance_id, pat.process_name,
1927: pat.process_item_type, pat.process_version,
1928: atv.name attribute_name,
1929: atv.text_value attribute_value, pat.activity_name
1930: FROM wf_process_activities pat, wf_activities ac, wf_activity_attr_values atv
1931: WHERE
1932: -- highest version for the process
1933: pat.process_name = p_process_name
1934: AND pat.process_item_type = p_process_item_type

Line 1959: v_work_instance_id wf_process_activities.instance_id%TYPE := NULL;

1955: , pat.process_version
1956: , DECODE(atv.name, gc_EVENT_TYPE, 1, 2)
1957: , atv.text_value;
1958:
1959: v_work_instance_id wf_process_activities.instance_id%TYPE := NULL;
1960: v_work_process_name wf_process_activities.process_name%TYPE := NULL;
1961: v_work_activity_name wf_process_activities.activity_name%TYPE := NULL;
1962: v_work_process_item_type wf_process_activities.process_item_type%TYPE := NULL;
1963: v_work_process_version wf_process_activities.process_version%TYPE := NULL;

Line 1960: v_work_process_name wf_process_activities.process_name%TYPE := NULL;

1956: , DECODE(atv.name, gc_EVENT_TYPE, 1, 2)
1957: , atv.text_value;
1958:
1959: v_work_instance_id wf_process_activities.instance_id%TYPE := NULL;
1960: v_work_process_name wf_process_activities.process_name%TYPE := NULL;
1961: v_work_activity_name wf_process_activities.activity_name%TYPE := NULL;
1962: v_work_process_item_type wf_process_activities.process_item_type%TYPE := NULL;
1963: v_work_process_version wf_process_activities.process_version%TYPE := NULL;
1964:

Line 1961: v_work_activity_name wf_process_activities.activity_name%TYPE := NULL;

1957: , atv.text_value;
1958:
1959: v_work_instance_id wf_process_activities.instance_id%TYPE := NULL;
1960: v_work_process_name wf_process_activities.process_name%TYPE := NULL;
1961: v_work_activity_name wf_process_activities.activity_name%TYPE := NULL;
1962: v_work_process_item_type wf_process_activities.process_item_type%TYPE := NULL;
1963: v_work_process_version wf_process_activities.process_version%TYPE := NULL;
1964:
1965: v_work_attribute_name wf_activity_attr_values.name%TYPE := NULL;

Line 1962: v_work_process_item_type wf_process_activities.process_item_type%TYPE := NULL;

1958:
1959: v_work_instance_id wf_process_activities.instance_id%TYPE := NULL;
1960: v_work_process_name wf_process_activities.process_name%TYPE := NULL;
1961: v_work_activity_name wf_process_activities.activity_name%TYPE := NULL;
1962: v_work_process_item_type wf_process_activities.process_item_type%TYPE := NULL;
1963: v_work_process_version wf_process_activities.process_version%TYPE := NULL;
1964:
1965: v_work_attribute_name wf_activity_attr_values.name%TYPE := NULL;
1966: v_work_attribute_value wf_activity_attr_values.text_value%TYPE := NULL;

Line 1963: v_work_process_version wf_process_activities.process_version%TYPE := NULL;

1959: v_work_instance_id wf_process_activities.instance_id%TYPE := NULL;
1960: v_work_process_name wf_process_activities.process_name%TYPE := NULL;
1961: v_work_activity_name wf_process_activities.activity_name%TYPE := NULL;
1962: v_work_process_item_type wf_process_activities.process_item_type%TYPE := NULL;
1963: v_work_process_version wf_process_activities.process_version%TYPE := NULL;
1964:
1965: v_work_attribute_name wf_activity_attr_values.name%TYPE := NULL;
1966: v_work_attribute_value wf_activity_attr_values.text_value%TYPE := NULL;
1967:

Line 2181: FROM wf_process_activities pat

2177: v_count NUMBER := 0;
2178: BEGIN
2179: SELECT COUNT(*)
2180: INTO v_count
2181: FROM wf_process_activities pat
2182: WHERE pat.process_name = p_process_name
2183: AND pat.process_item_type = p_process_item_type
2184: AND pat.process_version = p_process_version
2185: AND pat.activity_name = p_act_name;

Line 2296: FROM wf_process_activities pat, xdp_workitems wi

2292: IS
2293: CURSOR c_wi_processes
2294: IS
2295: SELECT pat.process_item_type, pat.process_name, max(pat.process_version) process_version
2296: FROM wf_process_activities pat, xdp_workitems wi
2297: WHERE
2298: -- xdp_workitem - process
2299: pat.process_name = wi.user_wf_process_name
2300: AND pat.process_item_type = wi.user_wf_item_type

Line 2315: FROM wf_process_activities pat

2311: p_process_item_type varchar2,
2312: p_process_version number)
2313: IS
2314: SELECT pat.instance_id
2315: FROM wf_process_activities pat
2316: WHERE pat.process_name = p_process_name
2317: AND pat.process_item_type = p_process_item_type
2318: AND pat.process_version = p_process_version
2319: AND pat.activity_name = gc_EXECUTE_FA;

Line 2546: FROM wf_process_activities pat, xdp_workitems wi

2542: IS
2543: SELECT pat.process_name process_name,
2544: pat.process_item_type process_item_type,
2545: max(pat.process_version) process_version
2546: FROM wf_process_activities pat, xdp_workitems wi
2547: WHERE
2548: -- xdp_workitem - process
2549: pat.process_name = wi.user_wf_process_name
2550: AND pat.process_item_type = wi.user_wf_item_type

Line 2563: FROM wf_process_activities pa,

2559: IS
2560:
2561: SELECT pa.instance_id, pa.process_item_type,
2562: pa.process_name, pa.process_version, ats.result_code
2563: FROM wf_process_activities pa,
2564: wf_activity_transitions ats
2565: WHERE
2566: -- process_activities
2567: pa.process_name = p_process_name

Line 2634: FROM wf_process_activities pat, xdp_workitems wi

2630: IS
2631: SELECT pat.process_name process_name,
2632: pat.process_item_type process_item_type,
2633: max(pat.process_version) process_version
2634: FROM wf_process_activities pat, xdp_workitems wi
2635: WHERE
2636: -- xdp_workitem - process
2637: pat.process_name = wi.user_wf_process_name
2638: AND pat.process_item_type = wi.user_wf_item_type

Line 2650: FROM wf_process_activities pa,

2646: p_process_version number)
2647: IS
2648: SELECT pa.instance_id, pa.process_item_type,
2649: pa.process_name, pa.process_version, ats.result_code
2650: FROM wf_process_activities pa,
2651: wf_activity_transitions ats
2652: WHERE
2653: -- process_activities
2654: pa.process_name = p_process_name