eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_WORKFLOW dependencies on PER_ALL_ASSIGNMENTS_F

Line 38: p_cur_assignment_id in per_all_assignments_f.assignment_id%type,

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,
42: p_pos_str_ver_id in per_pos_structure_elements.pos_structure_version_id%type,

Line 47: p_next_assignment_id out nocopy per_all_assignments_f.assignment_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,
45: p_next_role_id out nocopy number,
46: p_next_user_id out nocopy number,
47: p_next_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
48: p_status_flag out nocopy number);
49:
50: procedure old_approver_valid(p_transaction_category_id in number,
51: p_transaction_id in number,

Line 69: p_cur_assignment_id in per_all_assignments_f.assignment_id%type,

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

Line 71: p_assignment_id out nocopy per_all_assignments_f.assignment_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,
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,

Line 102: procedure person_on_assignment(p_assignment_id in per_all_assignments_f.assignment_id%type,

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

Line 132: p_assignment_id out nocopy per_all_assignments_f.assignment_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,
136: p_history_flag out nocopy boolean,

Line 133: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_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,
136: p_history_flag out nocopy boolean,
137: p_range_name out nocopy pqh_attribute_ranges.range_name%type,

Line 134: p_old_assignment_id out nocopy per_all_assignments_f.assignment_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,
136: p_history_flag out nocopy boolean,
137: p_range_name out nocopy pqh_attribute_ranges.range_name%type,
138: p_can_approve out nocopy boolean);

Line 172: p_cur_position_id out nocopy per_all_assignments_f.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,
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,

Line 174: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_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,
178: p_can_approve out nocopy boolean,

Line 186: p_old_assignment_id in per_all_assignments_f.assignment_id%type,

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,
190: p_cur_person_id out nocopy fnd_user.employee_id%type,

Line 191: p_assignment_id out nocopy 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,
195: p_old_can_approve out nocopy boolean,

Line 192: p_person_id out nocopy per_all_assignments_f.person_id%type,

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,
195: p_old_can_approve out nocopy boolean,
196: p_can_approve out nocopy boolean,

Line 194: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%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,
195: p_old_can_approve out nocopy boolean,
196: p_can_approve out nocopy boolean,
197: p_applicable_flag out nocopy boolean );
198:

Line 220: p_assignment_id in per_all_assignments_f.assignment_id%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,
224: p_applicable_flag out nocopy boolean,

Line 249: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,

245: p_can_approve out nocopy boolean) ;
246:
247: procedure su_next_user(p_cur_assignment_id in number,
248: p_value_date in date,
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,

Line 256: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type);

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,
260: p_person_id out nocopy fnd_user.employee_id%type,

Line 262: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type);

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,
265: p_trans_id in pqh_routing_history.transaction_id%type,
266: p_from_clause out nocopy pqh_table_route.from_clause%type );