APPS.AZW_UTIL dependencies on WF_PROCESS_ACTIVITIES

Line 13: proc_version wf_process_activities.process_version%TYPE;

9: --
10: procedure UpdateDocUrl(
11: p_itemtype in varchar2,
12: p_workflow in varchar2) IS
13: proc_version wf_process_activities.process_version%TYPE;
14: act_itemtype wf_activities.item_type%TYPE;
15: act_name wf_activities.name%TYPE;
16: act_type wf_activities.type%TYPE;
17: mesg_name wf_activities.message%TYPE;

Line 24: from wf_process_activities

20: url varchar2(255);
21:
22: CURSOR c_act_c IS
23: select activity_item_type, activity_name
24: from wf_process_activities
25: start with (process_item_type = p_itemtype
26: and process_version = proc_version
27: and process_name = p_workflow)
28: connect by (prior activity_name = process_name

Line 47: from wf_process_activities

43: and name = 'AZW_IA_TARGET';
44: BEGIN
45: BEGIN
46: select max(process_version) into proc_version
47: from wf_process_activities
48: where process_item_type = p_itemtype
49: and process_name = p_workflow;
50: EXCEPTION
51: WHEN app_exception.application_exception THEN

Line 58: fnd_message.set_token('AZW_ERROR_STMT','select process_version from wf_process_activities');

54: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
55: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
56: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
57: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
58: fnd_message.set_token('AZW_ERROR_STMT','select process_version from wf_process_activities');
59: APP_EXCEPTION.RAISE_EXCEPTION;
60: END;
61:
62: OPEN c_act_c;

Line 523: wf_process_activities wpa

519:
520: CURSOR wf_act_c IS
521: select wpa.instance_label, wpa.process_name, wias.notification_id
522: from wf_item_activity_statuses wias,
523: wf_process_activities wpa
524: where wias.item_type = itemtype
525: and wias.item_key = itemkey
526: and wias.notification_id is not null
527: and wias.process_activity = wpa.instance_id

Line 531: pre_act_label wf_process_activities.instance_label%TYPE;

527: and wias.process_activity = wpa.instance_id
528: order by wias.begin_date desc;
529:
530:
531: pre_act_label wf_process_activities.instance_label%TYPE;
532: pre_process_name wf_process_activities.process_name%TYPE;
533: pre_notification_id wf_item_activity_statuses_v.notification_id%TYPE;
534:
535: cur_act_label wf_process_activities.instance_label%TYPE;

Line 532: pre_process_name wf_process_activities.process_name%TYPE;

528: order by wias.begin_date desc;
529:
530:
531: pre_act_label wf_process_activities.instance_label%TYPE;
532: pre_process_name wf_process_activities.process_name%TYPE;
533: pre_notification_id wf_item_activity_statuses_v.notification_id%TYPE;
534:
535: cur_act_label wf_process_activities.instance_label%TYPE;
536: cur_process_name wf_process_activities.process_name%TYPE;

Line 535: cur_act_label wf_process_activities.instance_label%TYPE;

531: pre_act_label wf_process_activities.instance_label%TYPE;
532: pre_process_name wf_process_activities.process_name%TYPE;
533: pre_notification_id wf_item_activity_statuses_v.notification_id%TYPE;
534:
535: cur_act_label wf_process_activities.instance_label%TYPE;
536: cur_process_name wf_process_activities.process_name%TYPE;
537: cur_notification_id wf_item_activity_statuses_v.notification_id%TYPE;
538: comment wf_notifications.user_comment%TYPE;
539:

Line 536: cur_process_name wf_process_activities.process_name%TYPE;

532: pre_process_name wf_process_activities.process_name%TYPE;
533: pre_notification_id wf_item_activity_statuses_v.notification_id%TYPE;
534:
535: cur_act_label wf_process_activities.instance_label%TYPE;
536: cur_process_name wf_process_activities.process_name%TYPE;
537: cur_notification_id wf_item_activity_statuses_v.notification_id%TYPE;
538: comment wf_notifications.user_comment%TYPE;
539:
540: BEGIN