[Home] [Help]
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,
88: p_user_active_role_name in out nocopy pqh_roles.role_name%type,
89: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,
90: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,
91: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
92: p_member_role_id out nocopy pqh_roles.role_id%type,
93: p_member_user_id out nocopy fnd_user.user_id%type,
104: p_next_user_display out nocopy varchar2,
105: p_status_flag out nocopy number,
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,
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,
115: p_pos_str_ver_id in per_pos_structure_elements.pos_structure_version_id%type,
116: p_next_position_id out nocopy pqh_position_transactions.position_id%type,
117: p_next_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,