DBA Data[Home] [Help]

APPS.XNP_CVU_PKG dependencies on WF_ACTIVITIES

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 2310: CURSOR c_wf_activities ( p_process_name varchar2,

2306: -- Used for CVU_EXECUTE_FA validation
2307: -- Limitation: Wouldn't work if there is same activity from different item_types in the same
2308: -- process. Unlikely but possible scenario.
2309:
2310: CURSOR c_wf_activities ( p_process_name varchar2,
2311: p_process_item_type varchar2,
2312: p_process_version number)
2313: IS
2314: SELECT pat.instance_id

Line 2391: FOR ac_rec IN c_wf_activities( rec.process_name,

2387: FOR rec IN c_wi_processes
2388: LOOP
2389:
2390:
2391: FOR ac_rec IN c_wf_activities( rec.process_name,
2392: rec.process_item_type,
2393: rec.process_version)
2394: LOOP
2395: