APPS.PQH_WORKFLOW dependencies on PQH_ROUTING_CATEGORIES

Line 35: p_routing_category_id in pqh_routing_categories.routing_category_id%type,

31: p_assignment_id out nocopy number,
32: p_position_id out nocopy number) ;
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,

Line 40: p_routing_list_id in pqh_routing_categories.routing_list_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,
44: p_next_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,

Line 54: procedure next_applicable_member(p_routing_category_id in pqh_routing_categories.routing_category_id%type,

50: procedure old_approver_valid(p_transaction_category_id in number,
51: p_transaction_id in number,
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,

Line 58: p_routing_list_id in pqh_routing_categories.routing_list_id%type,

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,
62: p_user_id out nocopy number,

Line 66: procedure next_applicable_assignment(p_routing_category_id in pqh_routing_categories.routing_category_id%type,

62: p_user_id out nocopy number,
63: p_status_flag out nocopy number,
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,

Line 75: procedure next_applicable_position(p_routing_category_id in pqh_routing_categories.routing_category_id%type,

71: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
72: p_status_flag out nocopy number,
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,

Line 87: p_routing_category_id in pqh_routing_categories.routing_category_id%type,

83: p_applicable_flag out nocopy boolean) ;
84:
85: procedure position_applicable(p_position_id in pqh_position_transactions.position_id%type,
86: p_pos_str_ver_id in per_pos_structure_versions.pos_structure_version_id%type,
87: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
88: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
89: p_trans_id in pqh_position_transactions.position_transaction_id%type,
90: p_status_flag out nocopy number,
91: p_can_approve out nocopy boolean,

Line 112: p_routing_category_id out nocopy pqh_routing_categories.routing_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,
116: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,

Line 128: p_pos_str_id out nocopy pqh_routing_categories.position_structure_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,
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,

Line 129: p_old_pos_str_id out nocopy pqh_routing_categories.position_structure_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,
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,

Line 131: p_old_pos_str_ver_id out nocopy pqh_routing_categories.position_structure_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,
135: p_status_flag out nocopy number,

Line 145: p_routing_category_id in pqh_routing_categories.routing_category_id%type,

141: p_old_routing_list_id in pqh_routing_lists.routing_list_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,

Line 166: p_routing_category_id in pqh_routing_categories.routing_category_id%type,

162: procedure ps_element_check(p_history_flag in boolean,
163: p_value_date in date,
164: p_tran_cat_id in pqh_transaction_categories.transaction_category_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,

Line 185: p_routing_category_id in pqh_routing_categories.routing_category_id%type,

181:
182: procedure assignment_check(p_history_flag in boolean,
183: p_tran_cat_id in pqh_transaction_categories.transaction_category_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,

Line 203: p_pos_str_id out nocopy pqh_routing_categories.position_structure_id%type,

199: procedure list_range_check(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
200: p_used_for in varchar2 default null,
201: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,
202: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
203: p_pos_str_id out nocopy pqh_routing_categories.position_structure_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,

Line 204: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,

200: p_used_for in varchar2 default null,
201: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,
202: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
203: p_pos_str_id out nocopy pqh_routing_categories.position_structure_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,

Line 213: p_pos_str_id out nocopy pqh_routing_categories.position_structure_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,
213: p_pos_str_id out nocopy pqh_routing_categories.position_structure_id%type,
214: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,
215: p_range_name out nocopy pqh_attribute_ranges.range_name%type,
216: p_status_flag out nocopy number );
217:

Line 214: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%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,
213: p_pos_str_id out nocopy pqh_routing_categories.position_structure_id%type,
214: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,
215: p_range_name out nocopy pqh_attribute_ranges.range_name%type,
216: p_status_flag out nocopy number );
217:
218: procedure assignment_applicable(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,

Line 221: p_routing_category_id in pqh_routing_categories.routing_category_id%type,

217:
218: procedure assignment_applicable(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
219: p_from_clause in pqh_table_route.from_clause%type,
220: p_assignment_id in per_all_assignments_f.assignment_id%type,
221: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
222: p_value_date in date,
223: p_used_for in varchar2 default null,
224: p_applicable_flag out nocopy boolean,
225: p_status_flag out nocopy number,

Line 231: p_routing_category_id in pqh_routing_categories.routing_category_id%type,

227:
228: procedure ps_element_applicable(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
229: p_from_clause in pqh_table_route.from_clause%type,
230: p_position_id in pqh_position_transactions.position_id%type,
231: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
232: p_value_date in date,
233: p_used_for in varchar2 default null,
234: p_applicable_flag out nocopy boolean,
235: p_status_flag out nocopy number,

Line 241: p_routing_category_id in pqh_routing_categories.routing_category_id%type,

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,
245: p_can_approve out nocopy boolean) ;