APPS.AZW_REPORT dependencies on WF_ACTIVITIES

Line 1088: wf_activities_vl wav,

1084: meaning context_type_name,
1085: wav.description
1086: FROM az_product_flows apf,
1087: az_groups ag,
1088: wf_activities_vl wav,
1089: fnd_lookups fnd
1090: WHERE apf.application_id = p_application_id
1091: AND apf.process_type = 'IMP'
1092: AND wav.end_date IS NULL

Line 6167: l_dname wf_activities_vl.display_name%TYPE;

6163: p_process_groups IN VARCHAR2,
6164: p_new_call IN VARCHAR2 DEFAULT NULL,
6165: p_external_call IN VARCHAR2 DEFAULT NULL) IS
6166:
6167: l_dname wf_activities_vl.display_name%TYPE;
6168: proc_version NUMBER;
6169:
6170: CURSOR start_act_cur IS
6171: select instance_id, activity_name, start_end

Line 6196: from wf_activities_vl wav

6192: v_locator := 2;
6193:
6194: select display_name, version
6195: into l_dname, proc_version
6196: from wf_activities_vl wav
6197: where wav.item_type = p_item_type
6198: and wav.name = p_process_name
6199: and wav.end_date IS NULL;
6200:

Line 6283: l_act_type wf_activities.type%TYPE;

6279: p_selected_products IN VARCHAR2,
6280: p_instance_id IN NUMBER,
6281: p_display_msg IN VARCHAR2) IS
6282:
6283: l_act_type wf_activities.type%TYPE;
6284: l_mesg wf_activities_vl.message%TYPE;
6285: l_dname wf_activities_vl.display_name%TYPE;
6286:
6287: l_body wf_messages_vl.body%TYPE;

Line 6284: l_mesg wf_activities_vl.message%TYPE;

6280: p_instance_id IN NUMBER,
6281: p_display_msg IN VARCHAR2) IS
6282:
6283: l_act_type wf_activities.type%TYPE;
6284: l_mesg wf_activities_vl.message%TYPE;
6285: l_dname wf_activities_vl.display_name%TYPE;
6286:
6287: l_body wf_messages_vl.body%TYPE;
6288:

Line 6285: l_dname wf_activities_vl.display_name%TYPE;

6281: p_display_msg IN VARCHAR2) IS
6282:
6283: l_act_type wf_activities.type%TYPE;
6284: l_mesg wf_activities_vl.message%TYPE;
6285: l_dname wf_activities_vl.display_name%TYPE;
6286:
6287: l_body wf_messages_vl.body%TYPE;
6288:
6289: act_type wf_process_activities.activity_item_type%TYPE;

Line 6308: from wf_activities_vl wav

6304: where wpa.instance_id = p_instance_id;
6305:
6306: select type, message, display_name
6307: into l_act_type, l_mesg, l_dname
6308: from wf_activities_vl wav
6309: where wav.item_type = act_type
6310: and wav.name = act_name
6311: and wav.end_date IS NULL;
6312: