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 67: pqh_cec_shd.constraint_error

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

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

101: -- Internal Row Handler Use Only.
102: --
103: -- {End Of Comments}
104: -- ----------------------------------------------------------------------------
105: Procedure pre_delete(p_rec in pqh_cec_shd.g_rec_type) is
106: --
107: l_proc varchar2(72) := g_package||'pre_delete';
108: --
109: Begin

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

143: -- Internal table Handler Use Only.
144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure post_delete(p_rec in pqh_cec_shd.g_rec_type) is
148: --
149: l_proc varchar2(72) := g_package||'post_delete';
150: --
151: Begin

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

158: --
159: pqh_cec_rkd.after_delete
160: (
161: p_context =>p_rec.context
162: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name
163: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code
164: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key
165: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name
166: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number

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

159: pqh_cec_rkd.after_delete
160: (
161: p_context =>p_rec.context
162: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name
163: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code
164: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key
165: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name
166: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number
167: );

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

160: (
161: p_context =>p_rec.context
162: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name
163: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code
164: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key
165: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name
166: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number
167: );
168: --

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

161: p_context =>p_rec.context
162: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name
163: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code
164: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key
165: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name
166: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number
167: );
168: --
169: exception

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

162: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name
163: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code
164: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key
165: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name
166: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number
167: );
168: --
169: exception
170: --

Line 190: p_rec in pqh_cec_shd.g_rec_type

186: -- |---------------------------------< del >----------------------------------|
187: -- ----------------------------------------------------------------------------
188: Procedure del
189: (
190: p_rec in pqh_cec_shd.g_rec_type
191: ) is
192: --
193: l_proc varchar2(72) := g_package||'del';
194: --

Line 200: pqh_cec_shd.lck

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

Line 232: l_rec pqh_cec_shd.g_rec_type;

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