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_RCT_DEL dependencies on PQH_RCT_SHD

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

Line 64: pqh_rct_shd.constraint_error

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

Line 144: Procedure post_delete(p_effective_date in date,p_rec in pqh_rct_shd.g_rec_type) is

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

Line 159: ,p_transaction_category_id_o =>pqh_rct_shd.g_old_rec.transaction_category_id

155: --
156: pqh_rct_rkd.after_delete
157: (
158: p_routing_category_id =>p_rec.routing_category_id
159: ,p_transaction_category_id_o =>pqh_rct_shd.g_old_rec.transaction_category_id
160: ,p_enable_flag_o =>pqh_rct_shd.g_old_rec.enable_flag
161: ,p_default_flag_o =>pqh_rct_shd.g_old_rec.default_flag
162: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag
163: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id

Line 160: ,p_enable_flag_o =>pqh_rct_shd.g_old_rec.enable_flag

156: pqh_rct_rkd.after_delete
157: (
158: p_routing_category_id =>p_rec.routing_category_id
159: ,p_transaction_category_id_o =>pqh_rct_shd.g_old_rec.transaction_category_id
160: ,p_enable_flag_o =>pqh_rct_shd.g_old_rec.enable_flag
161: ,p_default_flag_o =>pqh_rct_shd.g_old_rec.default_flag
162: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag
163: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id
164: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id

Line 161: ,p_default_flag_o =>pqh_rct_shd.g_old_rec.default_flag

157: (
158: p_routing_category_id =>p_rec.routing_category_id
159: ,p_transaction_category_id_o =>pqh_rct_shd.g_old_rec.transaction_category_id
160: ,p_enable_flag_o =>pqh_rct_shd.g_old_rec.enable_flag
161: ,p_default_flag_o =>pqh_rct_shd.g_old_rec.default_flag
162: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag
163: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id
164: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id
165: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id

Line 162: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag

158: p_routing_category_id =>p_rec.routing_category_id
159: ,p_transaction_category_id_o =>pqh_rct_shd.g_old_rec.transaction_category_id
160: ,p_enable_flag_o =>pqh_rct_shd.g_old_rec.enable_flag
161: ,p_default_flag_o =>pqh_rct_shd.g_old_rec.default_flag
162: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag
163: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id
164: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id
165: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id
166: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id

Line 163: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id

159: ,p_transaction_category_id_o =>pqh_rct_shd.g_old_rec.transaction_category_id
160: ,p_enable_flag_o =>pqh_rct_shd.g_old_rec.enable_flag
161: ,p_default_flag_o =>pqh_rct_shd.g_old_rec.default_flag
162: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag
163: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id
164: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id
165: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id
166: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id
167: ,p_override_role_id_o =>pqh_rct_shd.g_old_rec.override_role_id

Line 164: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id

160: ,p_enable_flag_o =>pqh_rct_shd.g_old_rec.enable_flag
161: ,p_default_flag_o =>pqh_rct_shd.g_old_rec.default_flag
162: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag
163: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id
164: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id
165: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id
166: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id
167: ,p_override_role_id_o =>pqh_rct_shd.g_old_rec.override_role_id
168: ,p_override_user_id_o =>pqh_rct_shd.g_old_rec.override_user_id

Line 165: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id

161: ,p_default_flag_o =>pqh_rct_shd.g_old_rec.default_flag
162: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag
163: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id
164: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id
165: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id
166: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id
167: ,p_override_role_id_o =>pqh_rct_shd.g_old_rec.override_role_id
168: ,p_override_user_id_o =>pqh_rct_shd.g_old_rec.override_user_id
169: ,p_object_version_number_o =>pqh_rct_shd.g_old_rec.object_version_number

Line 166: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id

162: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag
163: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id
164: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id
165: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id
166: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id
167: ,p_override_role_id_o =>pqh_rct_shd.g_old_rec.override_role_id
168: ,p_override_user_id_o =>pqh_rct_shd.g_old_rec.override_user_id
169: ,p_object_version_number_o =>pqh_rct_shd.g_old_rec.object_version_number
170: );

Line 167: ,p_override_role_id_o =>pqh_rct_shd.g_old_rec.override_role_id

163: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id
164: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id
165: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id
166: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id
167: ,p_override_role_id_o =>pqh_rct_shd.g_old_rec.override_role_id
168: ,p_override_user_id_o =>pqh_rct_shd.g_old_rec.override_user_id
169: ,p_object_version_number_o =>pqh_rct_shd.g_old_rec.object_version_number
170: );
171: --

Line 168: ,p_override_user_id_o =>pqh_rct_shd.g_old_rec.override_user_id

164: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id
165: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id
166: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id
167: ,p_override_role_id_o =>pqh_rct_shd.g_old_rec.override_role_id
168: ,p_override_user_id_o =>pqh_rct_shd.g_old_rec.override_user_id
169: ,p_object_version_number_o =>pqh_rct_shd.g_old_rec.object_version_number
170: );
171: --
172: exception

Line 169: ,p_object_version_number_o =>pqh_rct_shd.g_old_rec.object_version_number

165: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id
166: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id
167: ,p_override_role_id_o =>pqh_rct_shd.g_old_rec.override_role_id
168: ,p_override_user_id_o =>pqh_rct_shd.g_old_rec.override_user_id
169: ,p_object_version_number_o =>pqh_rct_shd.g_old_rec.object_version_number
170: );
171: --
172: exception
173: --

Line 194: p_rec in pqh_rct_shd.g_rec_type

190: -- ----------------------------------------------------------------------------
191: Procedure del
192: (
193: p_effective_date in date,
194: p_rec in pqh_rct_shd.g_rec_type
195: ) is
196: --
197: l_proc varchar2(72) := g_package||'del';
198: --

Line 204: pqh_rct_shd.lck

200: hr_utility.set_location('Entering:'||l_proc, 5);
201: --
202: -- We must lock the row which we need to delete.
203: --
204: pqh_rct_shd.lck
205: (
206: p_rec.routing_category_id,
207: p_rec.object_version_number
208: );

Line 237: l_rec pqh_rct_shd.g_rec_type;

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