APPS.HR_WORKFLOW_SERVICE dependencies on PER_PEOPLE_F

Line 812: l_creator_person_id per_people_f.person_id%type;

808:
809: l_item_type wf_items.item_type%type := upper(p_item_type);
810: l_item_key wf_items.item_key%type;
811: --
812: l_creator_person_id per_people_f.person_id%type;
813: l_index binary_integer;
814: l_temp_item_attribute varchar2(2000);
815: l_temp_item_attribute_value varchar2(2000);
816: --

Line 1229: ,p_current_person_id in per_people_f.person_id%type

1225: -- ----------------------------------------------------------------------------
1226: function check_active_wf_items
1227: (p_item_type in wf_items.item_type%type
1228: ,p_process_name in wf_process_activities.process_name%type
1229: ,p_current_person_id in per_people_f.person_id%type
1230: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type
1231: ,p_activity_result_code in varchar2
1232: )
1233: return active_wf_items_list is

Line 1246: cursor csr_wfactitms (p_current_person_id in per_people_f.person_id%type

1242: -- Local cursor definations
1243: -- csr_wf_active_item Returns the item key of any process which
1244: -- is currently active with the name of p_process and belonging to
1245: -- the given person id
1246: cursor csr_wfactitms (p_current_person_id in per_people_f.person_id%type
1247: ,p_process_name in wf_process_activities.process_name%type
1248: ,p_item_type in wf_items.item_type%type
1249: ) is
1250:

Line 1422: ,p_current_person_id in per_people_f.person_id%type

1418: -- ----------------------------------------------------------------------------
1419: function check_active_wf_items
1420: (p_item_type in wf_items.item_type%type
1421: ,p_process_name in wf_process_activities.process_name%type
1422: ,p_current_person_id in per_people_f.person_id%type
1423: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type
1424: )
1425: return active_wf_items_list is
1426: --

Line 1438: cursor csr_wfactitms (p_current_person_id in per_people_f.person_id%type

1434: -- Local cursor definations
1435: -- csr_wf_active_item Returns the item key of any process which
1436: -- is currently active with the name of p_process and belonging to
1437: -- the given person id
1438: cursor csr_wfactitms (p_current_person_id in per_people_f.person_id%type
1439: ,p_process_name in wf_process_activities.process_name%type
1440: ,p_item_type in wf_items.item_type%type
1441: ) is
1442:

Line 1598: ,p_current_person_id in per_people_f.person_id%type

1594: -- ----------------------------------------------------------------------------
1595: FUNCTION get_active_wf_items
1596: (p_item_type in wf_items.item_type%type
1597: ,p_process_name in wf_process_activities.process_name%type
1598: ,p_current_person_id in per_people_f.person_id%type
1599: ,p_api_name in hr_api_transaction_steps.api_name%type
1600: ,p_activity_result_code in varchar2 default null
1601: ,p_address_context in varchar2 default null
1602: )

Line 1622: cursor csr_wfactitms (p_current_person_id in per_people_f.person_id%type

1618: -- contains a wf activity with a specific result code. This way, we can
1619: -- determine if the item_key has gone through a specific path, such as
1620: -- submit for approval.
1621: -----------------------------------------------------------------------------
1622: cursor csr_wfactitms (p_current_person_id in per_people_f.person_id%type
1623: ,p_process_name in wf_process_activities.process_name%type
1624: ,p_item_type in wf_items.item_type%type
1625: ,p_result_code in varchar2
1626: ) is

Line 1654: cursor csr_wfactitms2 (p_current_person_id in per_people_f.person_id%type

1650: -- the given person id
1651: --
1652: -- The following cursor is for no result code passed in.
1653: -----------------------------------------------------------------------------
1654: cursor csr_wfactitms2 (p_current_person_id in per_people_f.person_id%type
1655: ,p_process_name in wf_process_activities.process_name%type
1656: ,p_item_type in wf_items.item_type%type
1657: ) is
1658: