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_RHT_DEL dependencies on PQH_RHT_SHD

Line 45: Procedure delete_dml(p_rec in pqh_rht_shd.g_rec_type) is

41: -- Internal Row Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in pqh_rht_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin

Line 64: pqh_rht_shd.constraint_error

60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: pqh_rht_shd.constraint_error
65: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
66: When Others Then
67: Raise;
68: End delete_dml;

Line 102: Procedure pre_delete(p_rec in pqh_rht_shd.g_rec_type) is

98: -- Internal Row Handler Use Only.
99: --
100: -- {End Of Comments}
101: -- ----------------------------------------------------------------------------
102: Procedure pre_delete(p_rec in pqh_rht_shd.g_rec_type) is
103: --
104: l_proc varchar2(72) := g_package||'pre_delete';
105: --
106: --

Line 148: p_effective_date in date,p_rec in pqh_rht_shd.g_rec_type) is

144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure post_delete(
148: p_effective_date in date,p_rec in pqh_rht_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'post_delete';
151: --
152: Begin

Line 163: ,p_approval_cd_o =>pqh_rht_shd.g_old_rec.approval_cd

159: --
160: pqh_rht_rkd.after_delete
161: (
162: p_routing_history_id =>p_rec.routing_history_id
163: ,p_approval_cd_o =>pqh_rht_shd.g_old_rec.approval_cd
164: ,p_comments_o =>pqh_rht_shd.g_old_rec.comments
165: ,p_forwarded_by_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id
166: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
167: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id

Line 164: ,p_comments_o =>pqh_rht_shd.g_old_rec.comments

160: pqh_rht_rkd.after_delete
161: (
162: p_routing_history_id =>p_rec.routing_history_id
163: ,p_approval_cd_o =>pqh_rht_shd.g_old_rec.approval_cd
164: ,p_comments_o =>pqh_rht_shd.g_old_rec.comments
165: ,p_forwarded_by_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id
166: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
167: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
168: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id

Line 165: ,p_forwarded_by_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id

161: (
162: p_routing_history_id =>p_rec.routing_history_id
163: ,p_approval_cd_o =>pqh_rht_shd.g_old_rec.approval_cd
164: ,p_comments_o =>pqh_rht_shd.g_old_rec.comments
165: ,p_forwarded_by_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id
166: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
167: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
168: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
169: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id

Line 166: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id

162: p_routing_history_id =>p_rec.routing_history_id
163: ,p_approval_cd_o =>pqh_rht_shd.g_old_rec.approval_cd
164: ,p_comments_o =>pqh_rht_shd.g_old_rec.comments
165: ,p_forwarded_by_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id
166: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
167: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
168: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
169: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
170: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id

Line 167: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id

163: ,p_approval_cd_o =>pqh_rht_shd.g_old_rec.approval_cd
164: ,p_comments_o =>pqh_rht_shd.g_old_rec.comments
165: ,p_forwarded_by_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id
166: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
167: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
168: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
169: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
170: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
171: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id

Line 168: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id

164: ,p_comments_o =>pqh_rht_shd.g_old_rec.comments
165: ,p_forwarded_by_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id
166: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
167: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
168: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
169: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
170: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
171: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
172: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id

Line 169: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id

165: ,p_forwarded_by_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id
166: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
167: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
168: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
169: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
170: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
171: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
172: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
173: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id

Line 170: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id

166: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
167: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
168: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
169: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
170: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
171: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
172: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
173: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
174: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id

Line 171: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id

167: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
168: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
169: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
170: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
171: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
172: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
173: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
174: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
175: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date

Line 172: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id

168: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
169: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
170: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
171: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
172: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
173: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
174: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
175: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date
176: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id

Line 173: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id

169: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
170: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
171: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
172: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
173: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
174: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
175: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date
176: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id
177: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id

Line 174: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id

170: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
171: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
172: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
173: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
174: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
175: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date
176: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id
177: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id
178: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id

Line 175: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date

171: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
172: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
173: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
174: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
175: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date
176: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id
177: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id
178: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id
179: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id

Line 176: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id

172: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
173: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
174: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
175: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date
176: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id
177: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id
178: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id
179: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id
180: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd

Line 177: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id

173: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
174: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
175: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date
176: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id
177: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id
178: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id
179: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id
180: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd
181: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name

Line 178: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id

174: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
175: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date
176: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id
177: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id
178: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id
179: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id
180: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd
181: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name
182: ,p_to_range_name_o =>pqh_rht_shd.g_old_rec.to_range_name

Line 179: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id

175: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date
176: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id
177: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id
178: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id
179: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id
180: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd
181: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name
182: ,p_to_range_name_o =>pqh_rht_shd.g_old_rec.to_range_name
183: ,p_list_range_name_o =>pqh_rht_shd.g_old_rec.list_range_name

Line 180: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd

176: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id
177: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id
178: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id
179: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id
180: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd
181: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name
182: ,p_to_range_name_o =>pqh_rht_shd.g_old_rec.to_range_name
183: ,p_list_range_name_o =>pqh_rht_shd.g_old_rec.list_range_name
184: ,p_object_version_number_o =>pqh_rht_shd.g_old_rec.object_version_number

Line 181: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name

177: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id
178: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id
179: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id
180: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd
181: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name
182: ,p_to_range_name_o =>pqh_rht_shd.g_old_rec.to_range_name
183: ,p_list_range_name_o =>pqh_rht_shd.g_old_rec.list_range_name
184: ,p_object_version_number_o =>pqh_rht_shd.g_old_rec.object_version_number
185: );

Line 182: ,p_to_range_name_o =>pqh_rht_shd.g_old_rec.to_range_name

178: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id
179: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id
180: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd
181: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name
182: ,p_to_range_name_o =>pqh_rht_shd.g_old_rec.to_range_name
183: ,p_list_range_name_o =>pqh_rht_shd.g_old_rec.list_range_name
184: ,p_object_version_number_o =>pqh_rht_shd.g_old_rec.object_version_number
185: );
186: --

Line 183: ,p_list_range_name_o =>pqh_rht_shd.g_old_rec.list_range_name

179: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id
180: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd
181: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name
182: ,p_to_range_name_o =>pqh_rht_shd.g_old_rec.to_range_name
183: ,p_list_range_name_o =>pqh_rht_shd.g_old_rec.list_range_name
184: ,p_object_version_number_o =>pqh_rht_shd.g_old_rec.object_version_number
185: );
186: --
187: exception

Line 184: ,p_object_version_number_o =>pqh_rht_shd.g_old_rec.object_version_number

180: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd
181: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name
182: ,p_to_range_name_o =>pqh_rht_shd.g_old_rec.to_range_name
183: ,p_list_range_name_o =>pqh_rht_shd.g_old_rec.list_range_name
184: ,p_object_version_number_o =>pqh_rht_shd.g_old_rec.object_version_number
185: );
186: --
187: exception
188: --

Line 209: p_rec in pqh_rht_shd.g_rec_type

205: -- ----------------------------------------------------------------------------
206: Procedure del
207: (
208: p_effective_date in date,
209: p_rec in pqh_rht_shd.g_rec_type
210: ) is
211: --
212: l_proc varchar2(72) := g_package||'del';
213: --

Line 219: pqh_rht_shd.lck

215: hr_utility.set_location('Entering:'||l_proc, 5);
216: --
217: -- We must lock the row which we need to delete.
218: --
219: pqh_rht_shd.lck
220: (
221: p_rec.routing_history_id,
222: p_rec.object_version_number
223: );

Line 254: l_rec pqh_rht_shd.g_rec_type;

250: p_routing_history_id in number,
251: p_object_version_number in number
252: ) is
253: --
254: l_rec pqh_rht_shd.g_rec_type;
255: l_proc varchar2(72) := g_package||'del';
256: --
257: Begin
258: hr_utility.set_location('Entering:'||l_proc, 5);