DBA Data[Home] [Help]

APPS.AZW_UTIL dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 522: from wf_item_activity_statuses wias,

518: result out NOCOPY varchar2) IS
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

Line 533: pre_notification_id wf_item_activity_statuses_v.notification_id%TYPE;

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;
537: cur_notification_id wf_item_activity_statuses_v.notification_id%TYPE;

Line 537: cur_notification_id wf_item_activity_statuses_v.notification_id%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
541: