APPS.PQH_WORKFLOW dependencies on PQH_ROUTING_HISTORY

Line 37: p_trans_id in pqh_routing_history.transaction_id%type,

33:
34: procedure next_applicable(p_member_cd in pqh_transaction_categories.member_cd%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,

Line 56: p_trans_id in pqh_routing_history.transaction_id%type,

52: p_transaction_status in varchar2,
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,

Line 68: p_trans_id in pqh_routing_history.transaction_id%type,

64: p_applicable_flag out nocopy boolean) ;
65:
66: procedure next_applicable_assignment(p_routing_category_id in pqh_routing_categories.routing_category_id%type,
67: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
68: p_trans_id in pqh_routing_history.transaction_id%type,
69: p_cur_assignment_id in per_all_assignments_f.assignment_id%type,
70: p_used_for in varchar2,
71: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
72: p_status_flag out nocopy number,

Line 77: p_trans_id in pqh_routing_history.transaction_id%type,

73: p_applicable_flag out nocopy boolean);
74:
75: procedure next_applicable_position(p_routing_category_id in pqh_routing_categories.routing_category_id%type,
76: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
77: p_trans_id in pqh_routing_history.transaction_id%type,
78: p_cur_position_id in pqh_position_transactions.position_id%type,
79: p_pos_str_ver_id in per_pos_structure_elements.pos_structure_version_id%type,
80: p_used_for in varchar2,
81: p_position_id out nocopy pqh_position_transactions.position_id%type,

Line 106: procedure applicable_next_user(p_trans_id in pqh_routing_history.transaction_id%type,

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

Line 115: p_routing_history_id out nocopy pqh_routing_history.routing_history_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,
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,

Line 130: p_pos_str_ver_id out nocopy pqh_routing_history.pos_structure_version_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,
129: p_old_pos_str_id out nocopy pqh_routing_categories.position_structure_id%type,
130: p_pos_str_ver_id out nocopy pqh_routing_history.pos_structure_version_id%type,
131: p_old_pos_str_ver_id out nocopy pqh_routing_categories.position_structure_id%type,
132: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
133: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
134: p_old_assignment_id out nocopy per_all_assignments_f.assignment_id%type,

Line 208: p_trans_id in pqh_routing_history.transaction_id%type,

204: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,
205: p_status_flag out nocopy number ) ;
206:
207: procedure list_range_check(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
208: p_trans_id in pqh_routing_history.transaction_id%type,
209: p_from_clause in pqh_table_route.from_clause%type,
210: p_used_for in varchar2 default null,
211: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,
212: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,

Line 265: p_trans_id in pqh_routing_history.transaction_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,
265: p_trans_id in pqh_routing_history.transaction_id%type,
266: p_from_clause out nocopy pqh_table_route.from_clause%type );
267:
268: procedure check_value_range(p_from_char in pqh_attribute_ranges.from_char%type,
269: p_to_char in pqh_attribute_ranges.to_char%type,

Line 298: p_trans_id in pqh_routing_history.transaction_id%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,
299: p_history_flag out nocopy boolean,
300: p_old_member_cd out nocopy pqh_transaction_categories.member_cd%type,
301: p_position_id out nocopy pqh_routing_history.forwarded_to_position_id%type,
302: p_member_id out nocopy pqh_routing_history.forwarded_to_member_id%type,

Line 301: p_position_id out nocopy pqh_routing_history.forwarded_to_position_id%type,

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,
299: p_history_flag out nocopy boolean,
300: p_old_member_cd out nocopy pqh_transaction_categories.member_cd%type,
301: p_position_id out nocopy pqh_routing_history.forwarded_to_position_id%type,
302: p_member_id out nocopy pqh_routing_history.forwarded_to_member_id%type,
303: p_role_id out nocopy number,
304: p_user_id out nocopy number,
305: p_assignment_id out nocopy pqh_routing_history.forwarded_to_assignment_id%type,

Line 302: p_member_id out nocopy pqh_routing_history.forwarded_to_member_id%type,

298: p_trans_id in pqh_routing_history.transaction_id%type,
299: p_history_flag out nocopy boolean,
300: p_old_member_cd out nocopy pqh_transaction_categories.member_cd%type,
301: p_position_id out nocopy pqh_routing_history.forwarded_to_position_id%type,
302: p_member_id out nocopy pqh_routing_history.forwarded_to_member_id%type,
303: p_role_id out nocopy number,
304: p_user_id out nocopy number,
305: p_assignment_id out nocopy pqh_routing_history.forwarded_to_assignment_id%type,
306: p_pos_str_ver_id out nocopy pqh_routing_history.pos_structure_version_id%type,

Line 305: p_assignment_id out nocopy pqh_routing_history.forwarded_to_assignment_id%type,

301: p_position_id out nocopy pqh_routing_history.forwarded_to_position_id%type,
302: p_member_id out nocopy pqh_routing_history.forwarded_to_member_id%type,
303: p_role_id out nocopy number,
304: p_user_id out nocopy number,
305: p_assignment_id out nocopy pqh_routing_history.forwarded_to_assignment_id%type,
306: p_pos_str_ver_id out nocopy pqh_routing_history.pos_structure_version_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) ;

Line 306: p_pos_str_ver_id out nocopy pqh_routing_history.pos_structure_version_id%type,

302: p_member_id out nocopy pqh_routing_history.forwarded_to_member_id%type,
303: p_role_id out nocopy number,
304: p_user_id out nocopy number,
305: p_assignment_id out nocopy pqh_routing_history.forwarded_to_assignment_id%type,
306: p_pos_str_ver_id out nocopy pqh_routing_history.pos_structure_version_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:

Line 308: p_routing_history_id out nocopy pqh_routing_history.routing_history_id%type,

304: p_user_id out nocopy number,
305: p_assignment_id out nocopy pqh_routing_history.forwarded_to_assignment_id%type,
306: p_pos_str_ver_id out nocopy pqh_routing_history.pos_structure_version_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,

Line 319: p_pos_str_ver_id in pqh_routing_history.pos_structure_version_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,
320: p_position_id out nocopy pqh_position_transactions.position_id%type,
321: p_status_flag out nocopy number ) ;
322:
323: function pos_str_version(p_pos_str_id in per_pos_structure_versions.position_structure_id%type) return number;