APPS.PQH_WORKFLOW dependencies on PQH_POSITION_TRANSACTIONS

Line 41: p_cur_position_id in pqh_position_transactions.position_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,
45: p_next_role_id out nocopy number,

Line 43: p_next_position_id out nocopy pqh_position_transactions.position_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,
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,

Line 78: p_cur_position_id in pqh_position_transactions.position_id%type,

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,
82: p_status_flag out nocopy number,

Line 81: p_position_id out nocopy pqh_position_transactions.position_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,
82: p_status_flag out nocopy number,
83: p_applicable_flag out nocopy boolean) ;
84:
85: procedure position_applicable(p_position_id in pqh_position_transactions.position_id%type,

Line 85: procedure position_applicable(p_position_id in pqh_position_transactions.position_id%type,

81: p_position_id out nocopy pqh_position_transactions.position_id%type,
82: p_status_flag out nocopy number,
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,

Line 89: p_trans_id in pqh_position_transactions.position_transaction_id%type,

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);
93:

Line 94: procedure position_occupied(p_position_id in pqh_position_transactions.position_id%type,

90: p_status_flag out nocopy number,
91: p_can_approve out nocopy boolean,
92: p_applicable_flag out nocopy boolean);
93:
94: procedure position_occupied(p_position_id in pqh_position_transactions.position_id%type,
95: p_value_date in date,
96: p_applicable_flag out nocopy boolean);
97:
98: procedure person_has_user(p_person_id in fnd_user.employee_id%type,

Line 125: p_position_id out nocopy pqh_position_transactions.position_id%type,

121: p_member_role_id out nocopy pqh_roles.role_id%type,
122: p_member_user_id out nocopy fnd_user.user_id%type,
123: p_cur_person_id out nocopy fnd_user.employee_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,

Line 126: p_old_position_id out nocopy pqh_position_transactions.position_id%type,

122: p_member_user_id out nocopy fnd_user.user_id%type,
123: p_cur_person_id out nocopy fnd_user.employee_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,

Line 127: p_cur_position_id out nocopy pqh_position_transactions.position_id%type,

123: p_cur_person_id out nocopy fnd_user.employee_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,

Line 167: p_old_position_id in pqh_position_transactions.position_id%type,

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,
171: p_pos_str_ver_id out nocopy per_pos_structure_elements.pos_structure_version_id%type,

Line 176: p_position_id out nocopy pqh_position_transactions.position_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,
179: p_old_can_approve out nocopy boolean,
180: p_applicable_flag out nocopy boolean );

Line 230: p_position_id in pqh_position_transactions.position_id%type,

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

Line 261: p_position_id out nocopy pqh_position_transactions.position_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,
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,

Line 318: procedure ph_next_user(p_cur_position_id in pqh_position_transactions.position_id%type,

314: p_role_id out nocopy pqh_routing_list_members.role_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:

Line 320: p_position_id out nocopy pqh_position_transactions.position_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;
324: