APPS.HXC_APPROVAL_WF_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 976: ,p_item_key in wf_item_activity_statuses.item_key%type

972:
973: END get_empty_attribute;
974: Function find_mysterious_approver
975: (p_item_type in wf_items.item_type%type
976: ,p_item_key in wf_item_activity_statuses.item_key%type
977: ) return number is
978:
979: cursor c_find_approver_role
980: (itemType in wf_items.item_type%type

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

977: ) return number is
978:
979: cursor c_find_approver_role
980: (itemType in wf_items.item_type%type
981: ,itemKey in wf_item_activity_statuses.item_key%type) is
982: select wlr.orig_system, wlr.orig_system_id
983: from wf_notifications wn, wf_process_activities pa, wf_item_activity_statuses wias, wf_local_roles wlr
984: where pa.activity_name in('TC_APR_NOTIFICATION', 'TC_APR_NOTIFICATION_ABS')
985: and pa.activity_item_type = itemType

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

979: cursor c_find_approver_role
980: (itemType in wf_items.item_type%type
981: ,itemKey in wf_item_activity_statuses.item_key%type) is
982: select wlr.orig_system, wlr.orig_system_id
983: from wf_notifications wn, wf_process_activities pa, wf_item_activity_statuses wias, wf_local_roles wlr
984: where pa.activity_name in('TC_APR_NOTIFICATION', 'TC_APR_NOTIFICATION_ABS')
985: and pa.activity_item_type = itemType
986: and pa.instance_id = wias.process_activity
987: and wias.notification_id = wn.notification_id

Line 2011: p_item_key in wf_item_activity_statuses.item_key%type,

2007: End create_removed_links;
2008:
2009: FUNCTION item_attribute_exists
2010: (p_item_type in wf_items.item_type%type,
2011: p_item_key in wf_item_activity_statuses.item_key%type,
2012: p_name in wf_item_attribute_values.name%type)
2013: return boolean is
2014:
2015: l_dummy varchar2(1);