[Home] [Help]
140: procedure rl_member_check(p_routing_list_id in pqh_routing_lists.routing_list_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,
161:
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,
180: p_applicable_flag out nocopy boolean );
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,
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,
213: p_pos_str_id out nocopy pqh_routing_categories.position_structure_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,
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,
225: p_status_flag out nocopy number,
226: p_can_approve out nocopy boolean);
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,
235: p_status_flag out nocopy number,
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,
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,
270: p_value_char in pqh_attribute_ranges.to_char%type,