APPS.HXC_APPROVAL_WF_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 824: ,p_item_key in wf_item_activity_statuses.item_key%type

820:
821: END get_empty_attribute;
822: Function find_mysterious_approver
823: (p_item_type in wf_items.item_type%type
824: ,p_item_key in wf_item_activity_statuses.item_key%type
825: ) return number is
826:
827: cursor c_find_approver_role
828: (itemType in wf_items.item_type%type

Line 829: ,itemKey in wf_item_activity_statuses.item_key%type) is

825: ) return number is
826:
827: cursor c_find_approver_role
828: (itemType in wf_items.item_type%type
829: ,itemKey in wf_item_activity_statuses.item_key%type) is
830: select wlr.orig_system, wlr.orig_system_id
831: from wf_notifications wn, wf_process_activities pa, wf_item_activity_statuses wias, wf_local_roles wlr
832: where pa.activity_name = 'TC_APR_NOTIFICATION'
833: and pa.activity_item_type = itemType

Line 831: from wf_notifications wn, wf_process_activities pa, wf_item_activity_statuses wias, wf_local_roles wlr

827: cursor c_find_approver_role
828: (itemType in wf_items.item_type%type
829: ,itemKey in wf_item_activity_statuses.item_key%type) is
830: select wlr.orig_system, wlr.orig_system_id
831: from wf_notifications wn, wf_process_activities pa, wf_item_activity_statuses wias, wf_local_roles wlr
832: where pa.activity_name = 'TC_APR_NOTIFICATION'
833: and pa.activity_item_type = itemType
834: and pa.instance_id = wias.process_activity
835: and wias.notification_id = wn.notification_id

Line 1832: p_item_key in wf_item_activity_statuses.item_key%type,

1828: End create_removed_links;
1829:
1830: FUNCTION item_attribute_exists
1831: (p_item_type in wf_items.item_type%type,
1832: p_item_key in wf_item_activity_statuses.item_key%type,
1833: p_name in wf_item_attribute_values.name%type)
1834: return boolean is
1835:
1836: l_dummy varchar2(1);