APPS.PQH_WORKFLOW dependencies on FND_USER

Line 98: procedure person_has_user(p_person_id in fnd_user.employee_id%type,

94: procedure position_occupied(p_position_id in pqh_position_transactions.position_id%type,
95: p_value_date in date,
96: p_applicable_flag out nocopy boolean);
97:
98: procedure person_has_user(p_person_id in fnd_user.employee_id%type,
99: p_value_date in date,
100: p_applicable_flag out nocopy boolean);
101:
102: procedure person_on_assignment(p_assignment_id in per_all_assignments_f.assignment_id%type,

Line 104: p_person_id out nocopy fnd_user.employee_id%type ) ;

100: p_applicable_flag out nocopy boolean);
101:
102: procedure person_on_assignment(p_assignment_id in per_all_assignments_f.assignment_id%type,
103: p_value_date in date,
104: p_person_id out nocopy fnd_user.employee_id%type ) ;
105:
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,

Line 108: p_cur_user_id in out nocopy fnd_user.user_id%type,

104: p_person_id out nocopy fnd_user.employee_id%type ) ;
105:
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,

Line 109: p_cur_user_name in out nocopy fnd_user.user_name%type,

105:
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,

Line 117: p_person_id out nocopy fnd_user.employee_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,
121: p_member_role_id out nocopy pqh_roles.role_id%type,

Line 122: p_member_user_id out nocopy fnd_user.user_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,
126: p_old_position_id out nocopy pqh_position_transactions.position_id%type,

Line 123: p_cur_person_id out nocopy fnd_user.employee_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,
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,

Line 151: p_cur_user_id in out nocopy fnd_user.user_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,
155: p_member_role_id out nocopy pqh_routing_list_members.role_id%type,

Line 152: p_cur_user_name in out nocopy fnd_user.user_name%type,

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,
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,

Line 169: p_cur_user_id in out nocopy fnd_user.user_id%type,

165: p_from_clause in pqh_table_route.from_clause%type,
166: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
167: p_old_position_id in pqh_position_transactions.position_id%type,
168: p_pos_str_id in per_pos_structure_versions.position_structure_id%type,
169: p_cur_user_id in out nocopy fnd_user.user_id%type,
170: p_cur_user_name in out nocopy fnd_user.user_name%type,
171: p_pos_str_ver_id out nocopy per_pos_structure_elements.pos_structure_version_id%type,
172: p_cur_position_id out nocopy per_all_assignments_f.position_id%type,
173: p_cur_person_id out nocopy fnd_user.employee_id%type,

Line 170: p_cur_user_name in out nocopy fnd_user.user_name%type,

166: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
167: p_old_position_id in pqh_position_transactions.position_id%type,
168: p_pos_str_id in per_pos_structure_versions.position_structure_id%type,
169: p_cur_user_id in out nocopy fnd_user.user_id%type,
170: p_cur_user_name in out nocopy fnd_user.user_name%type,
171: p_pos_str_ver_id out nocopy per_pos_structure_elements.pos_structure_version_id%type,
172: p_cur_position_id out nocopy per_all_assignments_f.position_id%type,
173: p_cur_person_id out nocopy fnd_user.employee_id%type,
174: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,

Line 173: p_cur_person_id out nocopy fnd_user.employee_id%type,

169: p_cur_user_id in out nocopy fnd_user.user_id%type,
170: p_cur_user_name in out nocopy fnd_user.user_name%type,
171: p_pos_str_ver_id out nocopy per_pos_structure_elements.pos_structure_version_id%type,
172: p_cur_position_id out nocopy per_all_assignments_f.position_id%type,
173: p_cur_person_id out nocopy fnd_user.employee_id%type,
174: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
175: p_old_pos_str_id out nocopy per_pos_structure_versions.position_structure_id%type,
176: p_position_id out nocopy pqh_position_transactions.position_id%type,
177: p_status_flag out nocopy number,

Line 188: p_cur_user_id in out nocopy fnd_user.user_id%type,

184: p_from_clause in pqh_table_route.from_clause%type,
185: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
186: p_old_assignment_id in per_all_assignments_f.assignment_id%type,
187: p_value_date in date,
188: p_cur_user_id in out nocopy fnd_user.user_id%type,
189: p_cur_user_name in out nocopy fnd_user.user_name%type,
190: p_cur_person_id out nocopy fnd_user.employee_id%type,
191: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
192: p_person_id out nocopy per_all_assignments_f.person_id%type,

Line 189: p_cur_user_name in out nocopy fnd_user.user_name%type,

185: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
186: p_old_assignment_id in per_all_assignments_f.assignment_id%type,
187: p_value_date in date,
188: p_cur_user_id in out nocopy fnd_user.user_id%type,
189: p_cur_user_name in out nocopy fnd_user.user_name%type,
190: p_cur_person_id out nocopy fnd_user.employee_id%type,
191: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
192: p_person_id out nocopy per_all_assignments_f.person_id%type,
193: p_status_flag out nocopy number,

Line 190: p_cur_person_id out nocopy fnd_user.employee_id%type,

186: p_old_assignment_id in per_all_assignments_f.assignment_id%type,
187: p_value_date in date,
188: p_cur_user_id in out nocopy fnd_user.user_id%type,
189: p_cur_user_name in out nocopy fnd_user.user_name%type,
190: p_cur_person_id out nocopy fnd_user.employee_id%type,
191: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
192: p_person_id out nocopy per_all_assignments_f.person_id%type,
193: p_status_flag out nocopy number,
194: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,

Line 253: p_user_id in out nocopy fnd_user.user_id%type,

249: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
250: p_status_flag out nocopy number);
251:
252: procedure user_assignment(p_value_date in date,
253: p_user_id in out nocopy fnd_user.user_id%type,
254: p_user_name in out nocopy fnd_user.user_name%type,
255: p_person_id out nocopy fnd_user.employee_id%type,
256: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type);
257: procedure user_position_and_assignment(p_value_date in date,

Line 254: p_user_name in out nocopy fnd_user.user_name%type,

250: p_status_flag out nocopy number);
251:
252: procedure user_assignment(p_value_date in date,
253: p_user_id in out nocopy fnd_user.user_id%type,
254: p_user_name in out nocopy fnd_user.user_name%type,
255: p_person_id out nocopy fnd_user.employee_id%type,
256: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type);
257: procedure user_position_and_assignment(p_value_date in date,
258: p_user_id in out nocopy fnd_user.user_id%type,

Line 255: p_person_id out nocopy fnd_user.employee_id%type,

251:
252: procedure user_assignment(p_value_date in date,
253: p_user_id in out nocopy fnd_user.user_id%type,
254: p_user_name in out nocopy fnd_user.user_name%type,
255: p_person_id out nocopy fnd_user.employee_id%type,
256: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type);
257: procedure user_position_and_assignment(p_value_date in date,
258: p_user_id in out nocopy fnd_user.user_id%type,
259: p_user_name in out nocopy fnd_user.user_name%type,

Line 258: p_user_id in out nocopy fnd_user.user_id%type,

254: p_user_name in out nocopy fnd_user.user_name%type,
255: p_person_id out nocopy fnd_user.employee_id%type,
256: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type);
257: procedure user_position_and_assignment(p_value_date in date,
258: p_user_id in out nocopy fnd_user.user_id%type,
259: p_user_name in out nocopy fnd_user.user_name%type,
260: p_person_id out nocopy fnd_user.employee_id%type,
261: p_position_id out nocopy pqh_position_transactions.position_id%type,
262: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type);

Line 259: p_user_name in out nocopy fnd_user.user_name%type,

255: p_person_id out nocopy fnd_user.employee_id%type,
256: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type);
257: procedure user_position_and_assignment(p_value_date in date,
258: p_user_id in out nocopy fnd_user.user_id%type,
259: p_user_name in out nocopy fnd_user.user_name%type,
260: p_person_id out nocopy fnd_user.employee_id%type,
261: p_position_id out nocopy pqh_position_transactions.position_id%type,
262: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type);
263:

Line 260: p_person_id out nocopy fnd_user.employee_id%type,

256: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type);
257: procedure user_position_and_assignment(p_value_date in date,
258: p_user_id in out nocopy fnd_user.user_id%type,
259: p_user_name in out nocopy fnd_user.user_name%type,
260: p_person_id out nocopy fnd_user.employee_id%type,
261: p_position_id out nocopy pqh_position_transactions.position_id%type,
262: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type);
263:
264: procedure prepare_from_clause(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,

Line 292: p_user_id in out nocopy fnd_user.user_id%type,

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) ;
296:

Line 293: p_user_name in out nocopy fnd_user.user_name%type,

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