[Home] [Help]
79: p_business_group_id IN hr_organization_units_v.business_group_id%TYPE
80: ) RETURN VARCHAR;
81:
82: PROCEDURE APP_NEXT_USER
83: (p_trans_id in pqh_routing_history.transaction_id%type,
84: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
85: p_cur_user_id in out nocopy fnd_user.user_id%type,
86: p_cur_user_name in out nocopy fnd_user.user_name%type,
87: p_user_active_role_id in out nocopy pqh_roles.role_id%type,
96: p_position_id out nocopy pqh_position_transactions.position_id%type,
97: p_cur_person_id out nocopy fnd_user.employee_id%type,
98: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
99: p_cur_position_id out nocopy pqh_position_transactions.position_id%type,
100: p_pos_str_ver_id out nocopy pqh_routing_history.pos_structure_version_id%type,
101: p_assignment_id out nocopy per_assignments_f.assignment_id%type,
102: p_cur_assignment_id out nocopy per_assignments_f.assignment_id%type,
103: p_next_user out nocopy varchar2,
104: p_next_user_display out nocopy varchar2,
106: p_can_approve out nocopy number);
107: procedure get_next_user(p_member_cd in pqh_transaction_categories.member_cd%type,
108: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
109: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
110: p_trans_id in pqh_routing_history.transaction_id%type,
111: p_cur_assignment_id in per_assignments_f.assignment_id%type,
112: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
113: p_routing_list_id in pqh_routing_categories.routing_list_id%type,
114: p_cur_position_id in pqh_position_transactions.position_id%type,