APPS.PQH_CEP_DEL dependencies on PQH_CEP_SHD

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

Line 62: pqh_cep_shd.constraint_error

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

Line 100: Procedure pre_delete(p_rec in pqh_cep_shd.g_rec_type) is

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

Line 143: p_effective_date in date,p_rec in pqh_cep_shd.g_rec_type) is

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

Line 158: ,p_table_route_id_o =>pqh_cep_shd.g_old_rec.table_route_id

154: --
155: pqh_cep_rkd.after_delete
156: (
157: p_copy_entity_pref_id =>p_rec.copy_entity_pref_id
158: ,p_table_route_id_o =>pqh_cep_shd.g_old_rec.table_route_id
159: ,p_copy_entity_txn_id_o =>pqh_cep_shd.g_old_rec.copy_entity_txn_id
160: ,p_select_flag_o =>pqh_cep_shd.g_old_rec.select_flag
161: ,p_object_version_number_o =>pqh_cep_shd.g_old_rec.object_version_number
162: );

Line 159: ,p_copy_entity_txn_id_o =>pqh_cep_shd.g_old_rec.copy_entity_txn_id

155: pqh_cep_rkd.after_delete
156: (
157: p_copy_entity_pref_id =>p_rec.copy_entity_pref_id
158: ,p_table_route_id_o =>pqh_cep_shd.g_old_rec.table_route_id
159: ,p_copy_entity_txn_id_o =>pqh_cep_shd.g_old_rec.copy_entity_txn_id
160: ,p_select_flag_o =>pqh_cep_shd.g_old_rec.select_flag
161: ,p_object_version_number_o =>pqh_cep_shd.g_old_rec.object_version_number
162: );
163: --

Line 160: ,p_select_flag_o =>pqh_cep_shd.g_old_rec.select_flag

156: (
157: p_copy_entity_pref_id =>p_rec.copy_entity_pref_id
158: ,p_table_route_id_o =>pqh_cep_shd.g_old_rec.table_route_id
159: ,p_copy_entity_txn_id_o =>pqh_cep_shd.g_old_rec.copy_entity_txn_id
160: ,p_select_flag_o =>pqh_cep_shd.g_old_rec.select_flag
161: ,p_object_version_number_o =>pqh_cep_shd.g_old_rec.object_version_number
162: );
163: --
164: exception

Line 161: ,p_object_version_number_o =>pqh_cep_shd.g_old_rec.object_version_number

157: p_copy_entity_pref_id =>p_rec.copy_entity_pref_id
158: ,p_table_route_id_o =>pqh_cep_shd.g_old_rec.table_route_id
159: ,p_copy_entity_txn_id_o =>pqh_cep_shd.g_old_rec.copy_entity_txn_id
160: ,p_select_flag_o =>pqh_cep_shd.g_old_rec.select_flag
161: ,p_object_version_number_o =>pqh_cep_shd.g_old_rec.object_version_number
162: );
163: --
164: exception
165: --

Line 186: p_rec in pqh_cep_shd.g_rec_type

182: -- ----------------------------------------------------------------------------
183: Procedure del
184: (
185: p_effective_date in date,
186: p_rec in pqh_cep_shd.g_rec_type
187: ) is
188: --
189: l_proc varchar2(72) := g_package||'del';
190: --

Line 196: pqh_cep_shd.lck

192: hr_utility.set_location('Entering:'||l_proc, 5);
193: --
194: -- We must lock the row which we need to delete.
195: --
196: pqh_cep_shd.lck
197: (
198: p_rec.copy_entity_pref_id,
199: p_rec.object_version_number
200: );

Line 231: l_rec pqh_cep_shd.g_rec_type;

227: p_copy_entity_pref_id in number,
228: p_object_version_number in number
229: ) is
230: --
231: l_rec pqh_cep_shd.g_rec_type;
232: l_proc varchar2(72) := g_package||'del';
233: --
234: Begin
235: hr_utility.set_location('Entering:'||l_proc, 5);