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;
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
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
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;
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
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;
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;
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:
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