APPS.XNP_CVU_PKG dependencies on WF_ACTIVITY_ATTR_VALUES

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 1965: v_work_attribute_name wf_activity_attr_values.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:
1968:
1969: v_message_code VARCHAR2(150) := NULL;

Line 1966: v_work_attribute_value wf_activity_attr_values.text_value%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:
1968:
1969: v_message_code VARCHAR2(150) := NULL;
1970: v_param_list VARCHAR2(150) := NULL;

Line 2211: FROM wf_activity_attr_values

2207: -- XNP_CVU_EXECUTE_FA_FA_NAME
2208: BEGIN
2209: SELECT text_value
2210: INTO v_text_value
2211: FROM wf_activity_attr_values
2212: WHERE process_activity_id = p_instance_id
2213: AND NAME = gc_FA_NAME;
2214:
2215: IF v_text_value IS NULL

Line 2241: FROM wf_activity_attr_values

2237: -- XNP_CVU_EXECUTE_FA_FE_NAME
2238: BEGIN
2239: SELECT text_value
2240: INTO v_text_value
2241: FROM wf_activity_attr_values
2242: WHERE process_activity_id = p_instance_id
2243: AND NAME = gc_FE_NAME;
2244:
2245: IF v_text_value IS NOT NULL

Line 2578: FROM wf_activity_attr_values ack_aav

2574: AND ats.result_code <> '*'
2575: AND NOT EXISTS
2576: (
2577: SELECT 1
2578: FROM wf_activity_attr_values ack_aav
2579: WHERE ack_aav.process_activity_id = pa.instance_id
2580: AND ack_aav.name = gc_EVENT_TYPE
2581: AND ack_aav.text_value = ats.result_code)
2582: ORDER BY pa.process_item_type, pa.process_name, pa.process_version;

Line 2665: FROM wf_activity_attr_values ack_aav, xnp_msg_acks ack_xma

2661: AND ats.result_code <> '*'
2662: AND NOT EXISTS
2663: (
2664: SELECT 1
2665: FROM wf_activity_attr_values ack_aav, xnp_msg_acks ack_xma
2666: WHERE
2667: -- Join with the outer SQL
2668: ack_aav.process_activity_id = pa.instance_id
2669: AND ack_xma.ack_msg_code = ats.result_code