eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_WORKFLOW dependencies on PQH_ROUTING_LIST_MEMBERS

Line 39: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,

35: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
36: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
37: p_trans_id in pqh_routing_history.transaction_id%type,
38: p_cur_assignment_id in per_all_assignments_f.assignment_id%type,
39: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
40: p_routing_list_id in pqh_routing_categories.routing_list_id%type,
41: p_cur_position_id in pqh_position_transactions.position_id%type,
42: p_pos_str_ver_id in per_pos_structure_elements.pos_structure_version_id%type,
43: p_next_position_id out nocopy pqh_position_transactions.position_id%type,

Line 44: p_next_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,

40: p_routing_list_id in pqh_routing_categories.routing_list_id%type,
41: p_cur_position_id in pqh_position_transactions.position_id%type,
42: p_pos_str_ver_id in per_pos_structure_elements.pos_structure_version_id%type,
43: p_next_position_id out nocopy pqh_position_transactions.position_id%type,
44: p_next_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
45: p_next_role_id out nocopy number,
46: p_next_user_id out nocopy number,
47: p_next_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
48: p_status_flag out nocopy number);

Line 57: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,

53: p_old_approver_valid out nocopy varchar2 ) ;
54: procedure next_applicable_member(p_routing_category_id in pqh_routing_categories.routing_category_id%type,
55: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
56: p_trans_id in pqh_routing_history.transaction_id%type,
57: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
58: p_routing_list_id in pqh_routing_categories.routing_list_id%type,
59: p_used_for in varchar2,
60: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
61: p_role_id out nocopy number,

Line 60: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,

56: p_trans_id in pqh_routing_history.transaction_id%type,
57: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
58: p_routing_list_id in pqh_routing_categories.routing_list_id%type,
59: p_used_for in varchar2,
60: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
61: p_role_id out nocopy number,
62: p_user_id out nocopy number,
63: p_status_flag out nocopy number,
64: p_applicable_flag out nocopy boolean) ;

Line 116: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%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,
116: p_member_id out nocopy pqh_routing_list_members.routing_list_member_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,

Line 118: p_old_member_id out nocopy pqh_routing_list_members.routing_list_member_id%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,
116: p_member_id out nocopy pqh_routing_list_members.routing_list_member_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,

Line 124: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_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,
126: p_old_position_id out nocopy pqh_position_transactions.position_id%type,
127: p_cur_position_id out nocopy pqh_position_transactions.position_id%type,
128: p_pos_str_id out nocopy pqh_routing_categories.position_structure_id%type,

Line 146: p_old_member_id in pqh_routing_list_members.routing_list_member_id%type,

142: p_history_flag in boolean,
143: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
144: p_from_clause in pqh_table_route.from_clause%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,

Line 153: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,

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,
155: p_member_role_id out nocopy pqh_routing_list_members.role_id%type,
156: p_member_user_id out nocopy pqh_routing_list_members.user_id%type,
157: p_status_flag out nocopy number,

Line 154: p_member_id out nocopy pqh_routing_list_members.routing_list_member_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,
155: p_member_role_id out nocopy pqh_routing_list_members.role_id%type,
156: p_member_user_id out nocopy pqh_routing_list_members.user_id%type,
157: p_status_flag out nocopy number,
158: p_applicable_flag out nocopy boolean,

Line 155: p_member_role_id out nocopy pqh_routing_list_members.role_id%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,
155: p_member_role_id out nocopy pqh_routing_list_members.role_id%type,
156: p_member_user_id out nocopy pqh_routing_list_members.user_id%type,
157: p_status_flag out nocopy number,
158: p_applicable_flag out nocopy boolean,
159: p_old_can_approve out nocopy boolean,

Line 156: p_member_user_id out nocopy pqh_routing_list_members.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,
155: p_member_role_id out nocopy pqh_routing_list_members.role_id%type,
156: p_member_user_id out nocopy pqh_routing_list_members.user_id%type,
157: p_status_flag out nocopy number,
158: p_applicable_flag out nocopy boolean,
159: p_old_can_approve out nocopy boolean,
160: p_can_approve out nocopy boolean );

Line 240: p_member_id in pqh_routing_list_members.routing_list_member_id%type,

236: p_can_approve out nocopy boolean);
237:
238: procedure rl_member_applicable(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
239: p_from_clause in pqh_table_route.from_clause%type,
240: p_member_id in pqh_routing_list_members.routing_list_member_id%type,
241: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
242: p_used_for in varchar2 default null,
243: p_applicable_flag out nocopy boolean,
244: p_status_flag out nocopy number,

Line 294: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,

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) ;
296:
297: procedure routing_current(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
298: p_trans_id in pqh_routing_history.transaction_id%type,

Line 311: procedure rl_next_user (p_routing_list_id in pqh_routing_list_members.routing_list_id%type,

307: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
308: p_routing_history_id out nocopy pqh_routing_history.routing_history_id%type,
309: p_status_flag out nocopy number) ;
310:
311: procedure rl_next_user (p_routing_list_id in pqh_routing_list_members.routing_list_id%type,
312: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
313: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
314: p_role_id out nocopy pqh_routing_list_members.role_id%type,
315: p_user_id out nocopy pqh_routing_list_members.user_id%type,

Line 312: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,

308: p_routing_history_id out nocopy pqh_routing_history.routing_history_id%type,
309: p_status_flag out nocopy number) ;
310:
311: procedure rl_next_user (p_routing_list_id in pqh_routing_list_members.routing_list_id%type,
312: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
313: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
314: p_role_id out nocopy pqh_routing_list_members.role_id%type,
315: p_user_id out nocopy pqh_routing_list_members.user_id%type,
316: p_status_flag out nocopy number) ;

Line 313: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,

309: p_status_flag out nocopy number) ;
310:
311: procedure rl_next_user (p_routing_list_id in pqh_routing_list_members.routing_list_id%type,
312: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
313: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
314: p_role_id out nocopy pqh_routing_list_members.role_id%type,
315: p_user_id out nocopy pqh_routing_list_members.user_id%type,
316: p_status_flag out nocopy number) ;
317:

Line 314: p_role_id out nocopy pqh_routing_list_members.role_id%type,

310:
311: procedure rl_next_user (p_routing_list_id in pqh_routing_list_members.routing_list_id%type,
312: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
313: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
314: p_role_id out nocopy pqh_routing_list_members.role_id%type,
315: p_user_id out nocopy pqh_routing_list_members.user_id%type,
316: p_status_flag out nocopy number) ;
317:
318: procedure ph_next_user(p_cur_position_id in pqh_position_transactions.position_id%type,

Line 315: p_user_id out nocopy pqh_routing_list_members.user_id%type,

311: procedure rl_next_user (p_routing_list_id in pqh_routing_list_members.routing_list_id%type,
312: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
313: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
314: p_role_id out nocopy pqh_routing_list_members.role_id%type,
315: p_user_id out nocopy pqh_routing_list_members.user_id%type,
316: p_status_flag out nocopy number) ;
317:
318: procedure ph_next_user(p_cur_position_id in pqh_position_transactions.position_id%type,
319: p_pos_str_ver_id in pqh_routing_history.pos_structure_version_id%type,