APPS.PQH_WORKFLOW dependencies on PQH_TRANSACTION_CATEGORIES

Line 34: procedure next_applicable(p_member_cd in pqh_transaction_categories.member_cd%type,

30: p_effective_date in date,
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,

Line 36: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,

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,
40: p_routing_list_id in pqh_routing_categories.routing_list_id%type,

Line 55: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,

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,
59: p_used_for in varchar2,

Line 67: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,

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

Line 76: p_tran_cat_id in pqh_transaction_categories.transaction_category_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,
80: p_used_for in varchar2,

Line 88: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,

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,
92: p_applicable_flag out nocopy boolean);

Line 107: p_tran_cat_id in pqh_transaction_categories.transaction_category_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,
111: p_user_active_role_name in out nocopy pqh_roles.role_name%type,

Line 113: p_member_cd out nocopy pqh_transaction_categories.member_cd%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,
117: p_person_id out nocopy fnd_user.employee_id%type,

Line 114: p_old_member_cd out nocopy pqh_transaction_categories.member_cd%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,
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,

Line 143: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,

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

Line 164: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,

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

Line 183: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,

179: p_old_can_approve out nocopy boolean,
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,

Line 199: procedure list_range_check(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,

195: p_old_can_approve out nocopy boolean,
196: p_can_approve out nocopy boolean,
197: p_applicable_flag out nocopy boolean );
198:
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,

Line 201: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,

197: p_applicable_flag out nocopy boolean );
198:
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 ) ;

Line 207: procedure list_range_check(p_tran_cat_id in pqh_transaction_categories.transaction_category_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,
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,

Line 211: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,

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

Line 218: procedure assignment_applicable(p_tran_cat_id in pqh_transaction_categories.transaction_category_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,
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,

Line 228: procedure ps_element_applicable(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,

224: p_applicable_flag out nocopy boolean,
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,

Line 238: procedure rl_member_applicable(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,

234: p_applicable_flag out nocopy boolean,
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,

Line 264: procedure prepare_from_clause(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%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,
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,

Line 297: procedure routing_current(p_tran_cat_id in pqh_transaction_categories.transaction_category_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,
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,

Line 300: p_old_member_cd out nocopy pqh_transaction_categories.member_cd%type,

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,
303: p_role_id out nocopy number,
304: p_user_id out nocopy number,