[Home] [Help]
106: procedure applicable_next_user(p_trans_id in pqh_routing_history.transaction_id%type,
107: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
108: p_cur_user_id in out nocopy fnd_user.user_id%type,
109: p_cur_user_name in out nocopy fnd_user.user_name%type,
110: p_user_active_role_id in out nocopy pqh_roles.role_id%type,
111: p_user_active_role_name in out nocopy pqh_roles.role_name%type,
112: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,
113: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,
114: p_old_member_cd out nocopy pqh_transaction_categories.member_cd%type,
107: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
108: p_cur_user_id in out nocopy fnd_user.user_id%type,
109: p_cur_user_name in out nocopy fnd_user.user_name%type,
110: p_user_active_role_id in out nocopy pqh_roles.role_id%type,
111: p_user_active_role_name in out nocopy pqh_roles.role_name%type,
112: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,
113: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,
114: p_old_member_cd out nocopy pqh_transaction_categories.member_cd%type,
115: p_routing_history_id out nocopy pqh_routing_history.routing_history_id%type,
117: p_person_id out nocopy fnd_user.employee_id%type,
118: p_old_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
119: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
120: p_old_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
121: p_member_role_id out nocopy pqh_roles.role_id%type,
122: p_member_user_id out nocopy fnd_user.user_id%type,
123: p_cur_person_id out nocopy fnd_user.employee_id%type,
124: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
125: p_position_id out nocopy pqh_position_transactions.position_id%type,
145: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
146: p_old_member_id in pqh_routing_list_members.routing_list_member_id%type,
147: p_old_user_id in number,
148: p_old_role_id in number,
149: p_user_active_role_id in out nocopy pqh_roles.role_id%type,
150: p_user_active_role_name in out nocopy pqh_roles.role_name%type,
151: p_cur_user_id in out nocopy fnd_user.user_id%type,
152: p_cur_user_name in out nocopy fnd_user.user_name%type,
153: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
146: p_old_member_id in pqh_routing_list_members.routing_list_member_id%type,
147: p_old_user_id in number,
148: p_old_role_id in number,
149: p_user_active_role_id in out nocopy pqh_roles.role_id%type,
150: p_user_active_role_name in out nocopy pqh_roles.role_name%type,
151: p_cur_user_id in out nocopy fnd_user.user_id%type,
152: p_cur_user_name in out nocopy fnd_user.user_name%type,
153: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
154: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
286: procedure rlm_user_seq(p_routing_list_id in pqh_routing_lists.routing_list_id%type,
287: p_old_user_id in number default null,
288: p_old_role_id in number default null,
289: p_old_member_id in number default null,
290: p_role_id in out nocopy pqh_roles.role_id%type,
291: p_role_name in out nocopy pqh_roles.role_name%type,
292: p_user_id in out nocopy fnd_user.user_id%type,
293: p_user_name in out nocopy fnd_user.user_name%type,
294: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
287: p_old_user_id in number default null,
288: p_old_role_id in number default null,
289: p_old_member_id in number default null,
290: p_role_id in out nocopy pqh_roles.role_id%type,
291: p_role_name in out nocopy pqh_roles.role_name%type,
292: p_user_id in out nocopy fnd_user.user_id%type,
293: p_user_name in out nocopy fnd_user.user_name%type,
294: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
295: p_member_flag out nocopy boolean) ;