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_CEC_DEL dependencies on PQH_CEC_SHD

Line 48: Procedure delete_dml(p_rec in pqh_cec_shd.g_rec_type) is

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

Line 83: pqh_cec_shd.constraint_error

79: --
80: Exception
81: When hr_api.child_integrity_violated then
82: -- Child integrity has been violated
83: pqh_cec_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When Others Then
86: Raise;
87: End delete_dml;

Line 121: Procedure pre_delete(p_rec in pqh_cec_shd.g_rec_type) is

117: -- Internal Row Handler Use Only.
118: --
119: -- {End Of Comments}
120: -- ----------------------------------------------------------------------------
121: Procedure pre_delete(p_rec in pqh_cec_shd.g_rec_type) is
122: --
123: l_proc varchar2(72) := g_package||'pre_delete';
124: --
125: Begin

Line 163: Procedure post_delete(p_rec in pqh_cec_shd.g_rec_type) is

159: -- Internal table Handler Use Only.
160: --
161: -- {End Of Comments}
162: -- ----------------------------------------------------------------------------
163: Procedure post_delete(p_rec in pqh_cec_shd.g_rec_type) is
164: --
165: l_proc varchar2(72) := g_package||'post_delete';
166: --
167: Begin

Line 178: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name

174: --
175: pqh_cec_rkd.after_delete
176: (
177: p_context =>p_rec.context
178: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name
179: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code
180: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key
181: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name
182: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number

Line 179: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code

175: pqh_cec_rkd.after_delete
176: (
177: p_context =>p_rec.context
178: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name
179: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code
180: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key
181: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name
182: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number
183: );

Line 180: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key

176: (
177: p_context =>p_rec.context
178: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name
179: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code
180: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key
181: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name
182: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number
183: );
184: --

Line 181: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name

177: p_context =>p_rec.context
178: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name
179: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code
180: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key
181: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name
182: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number
183: );
184: --
185: exception

Line 182: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number

178: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name
179: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code
180: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key
181: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name
182: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number
183: );
184: --
185: exception
186: --

Line 206: p_rec in pqh_cec_shd.g_rec_type

202: -- |---------------------------------< del >----------------------------------|
203: -- ----------------------------------------------------------------------------
204: Procedure del
205: (
206: p_rec in pqh_cec_shd.g_rec_type
207: ) is
208: --
209: l_proc varchar2(72) := g_package||'del';
210: --

Line 216: pqh_cec_shd.lck

212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: -- We must lock the row which we need to delete.
215: --
216: pqh_cec_shd.lck
217: (
218: p_rec.context,
219: p_rec.object_version_number
220: );

Line 248: l_rec pqh_cec_shd.g_rec_type;

244: p_context in varchar2,
245: p_object_version_number in number
246: ) is
247: --
248: l_rec pqh_cec_shd.g_rec_type;
249: l_proc varchar2(72) := g_package||'del';
250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc, 5);