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_RLM_DEL dependencies on PQH_RLM_SHD

Line 45: Procedure delete_dml(p_rec in pqh_rlm_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_rlm_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin

Line 64: pqh_rlm_shd.constraint_error

60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: pqh_rlm_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_rlm_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_rlm_shd.g_rec_type) is
103: --
104: l_proc varchar2(72) := g_package||'pre_delete';
105: --
106: Begin

Line 145: p_effective_date in date,p_rec in pqh_rlm_shd.g_rec_type) is

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

Line 160: ,p_role_id_o =>pqh_rlm_shd.g_old_rec.role_id

156: --
157: pqh_rlm_rkd.after_delete
158: (
159: p_routing_list_member_id =>p_rec.routing_list_member_id
160: ,p_role_id_o =>pqh_rlm_shd.g_old_rec.role_id
161: ,p_routing_list_id_o =>pqh_rlm_shd.g_old_rec.routing_list_id
162: ,p_seq_no_o =>pqh_rlm_shd.g_old_rec.seq_no
163: ,p_approver_flag_o =>pqh_rlm_shd.g_old_rec.approver_flag
164: ,p_enable_flag_o =>pqh_rlm_shd.g_old_rec.enable_flag

Line 161: ,p_routing_list_id_o =>pqh_rlm_shd.g_old_rec.routing_list_id

157: pqh_rlm_rkd.after_delete
158: (
159: p_routing_list_member_id =>p_rec.routing_list_member_id
160: ,p_role_id_o =>pqh_rlm_shd.g_old_rec.role_id
161: ,p_routing_list_id_o =>pqh_rlm_shd.g_old_rec.routing_list_id
162: ,p_seq_no_o =>pqh_rlm_shd.g_old_rec.seq_no
163: ,p_approver_flag_o =>pqh_rlm_shd.g_old_rec.approver_flag
164: ,p_enable_flag_o =>pqh_rlm_shd.g_old_rec.enable_flag
165: ,p_object_version_number_o =>pqh_rlm_shd.g_old_rec.object_version_number

Line 162: ,p_seq_no_o =>pqh_rlm_shd.g_old_rec.seq_no

158: (
159: p_routing_list_member_id =>p_rec.routing_list_member_id
160: ,p_role_id_o =>pqh_rlm_shd.g_old_rec.role_id
161: ,p_routing_list_id_o =>pqh_rlm_shd.g_old_rec.routing_list_id
162: ,p_seq_no_o =>pqh_rlm_shd.g_old_rec.seq_no
163: ,p_approver_flag_o =>pqh_rlm_shd.g_old_rec.approver_flag
164: ,p_enable_flag_o =>pqh_rlm_shd.g_old_rec.enable_flag
165: ,p_object_version_number_o =>pqh_rlm_shd.g_old_rec.object_version_number
166: ,p_user_id_o =>pqh_rlm_shd.g_old_rec.user_id

Line 163: ,p_approver_flag_o =>pqh_rlm_shd.g_old_rec.approver_flag

159: p_routing_list_member_id =>p_rec.routing_list_member_id
160: ,p_role_id_o =>pqh_rlm_shd.g_old_rec.role_id
161: ,p_routing_list_id_o =>pqh_rlm_shd.g_old_rec.routing_list_id
162: ,p_seq_no_o =>pqh_rlm_shd.g_old_rec.seq_no
163: ,p_approver_flag_o =>pqh_rlm_shd.g_old_rec.approver_flag
164: ,p_enable_flag_o =>pqh_rlm_shd.g_old_rec.enable_flag
165: ,p_object_version_number_o =>pqh_rlm_shd.g_old_rec.object_version_number
166: ,p_user_id_o =>pqh_rlm_shd.g_old_rec.user_id
167: );

Line 164: ,p_enable_flag_o =>pqh_rlm_shd.g_old_rec.enable_flag

160: ,p_role_id_o =>pqh_rlm_shd.g_old_rec.role_id
161: ,p_routing_list_id_o =>pqh_rlm_shd.g_old_rec.routing_list_id
162: ,p_seq_no_o =>pqh_rlm_shd.g_old_rec.seq_no
163: ,p_approver_flag_o =>pqh_rlm_shd.g_old_rec.approver_flag
164: ,p_enable_flag_o =>pqh_rlm_shd.g_old_rec.enable_flag
165: ,p_object_version_number_o =>pqh_rlm_shd.g_old_rec.object_version_number
166: ,p_user_id_o =>pqh_rlm_shd.g_old_rec.user_id
167: );
168: --

Line 165: ,p_object_version_number_o =>pqh_rlm_shd.g_old_rec.object_version_number

161: ,p_routing_list_id_o =>pqh_rlm_shd.g_old_rec.routing_list_id
162: ,p_seq_no_o =>pqh_rlm_shd.g_old_rec.seq_no
163: ,p_approver_flag_o =>pqh_rlm_shd.g_old_rec.approver_flag
164: ,p_enable_flag_o =>pqh_rlm_shd.g_old_rec.enable_flag
165: ,p_object_version_number_o =>pqh_rlm_shd.g_old_rec.object_version_number
166: ,p_user_id_o =>pqh_rlm_shd.g_old_rec.user_id
167: );
168: --
169: exception

Line 166: ,p_user_id_o =>pqh_rlm_shd.g_old_rec.user_id

162: ,p_seq_no_o =>pqh_rlm_shd.g_old_rec.seq_no
163: ,p_approver_flag_o =>pqh_rlm_shd.g_old_rec.approver_flag
164: ,p_enable_flag_o =>pqh_rlm_shd.g_old_rec.enable_flag
165: ,p_object_version_number_o =>pqh_rlm_shd.g_old_rec.object_version_number
166: ,p_user_id_o =>pqh_rlm_shd.g_old_rec.user_id
167: );
168: --
169: exception
170: --

Line 191: p_rec in pqh_rlm_shd.g_rec_type

187: -- ----------------------------------------------------------------------------
188: Procedure del
189: (
190: p_effective_date in date,
191: p_rec in pqh_rlm_shd.g_rec_type
192: ) is
193: --
194: l_proc varchar2(72) := g_package||'del';
195: --

Line 201: pqh_rlm_shd.lck

197: hr_utility.set_location('Entering:'||l_proc, 5);
198: --
199: -- We must lock the row which we need to delete.
200: --
201: pqh_rlm_shd.lck
202: (
203: p_rec.routing_list_member_id,
204: p_rec.object_version_number
205: );

Line 236: l_rec pqh_rlm_shd.g_rec_type;

232: p_routing_list_member_id in number,
233: p_object_version_number in number
234: ) is
235: --
236: l_rec pqh_rlm_shd.g_rec_type;
237: l_proc varchar2(72) := g_package||'del';
238: --
239: Begin
240: hr_utility.set_location('Entering:'||l_proc, 5);