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_PTI_DEL dependencies on PQH_PTI_SHD

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

Line 64: pqh_pti_shd.constraint_error

60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: pqh_pti_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_pti_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_pti_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_pti_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_pti_shd.g_rec_type) is
146: --
147: l_proc varchar2(72) := g_package||'post_delete';
148: --
149: Begin

Line 160: ,p_active_inactive_flag_o =>pqh_pti_shd.g_old_rec.active_inactive_flag

156: --
157: pqh_pti_rkd.after_delete
158: (
159: p_information_type =>p_rec.information_type
160: ,p_active_inactive_flag_o =>pqh_pti_shd.g_old_rec.active_inactive_flag
161: ,p_description_o =>pqh_pti_shd.g_old_rec.description
162: ,p_multiple_occurences_flag_o =>pqh_pti_shd.g_old_rec.multiple_occurences_flag
163: ,p_legislation_code_o =>pqh_pti_shd.g_old_rec.legislation_code
164: ,p_object_version_number_o =>pqh_pti_shd.g_old_rec.object_version_number

Line 161: ,p_description_o =>pqh_pti_shd.g_old_rec.description

157: pqh_pti_rkd.after_delete
158: (
159: p_information_type =>p_rec.information_type
160: ,p_active_inactive_flag_o =>pqh_pti_shd.g_old_rec.active_inactive_flag
161: ,p_description_o =>pqh_pti_shd.g_old_rec.description
162: ,p_multiple_occurences_flag_o =>pqh_pti_shd.g_old_rec.multiple_occurences_flag
163: ,p_legislation_code_o =>pqh_pti_shd.g_old_rec.legislation_code
164: ,p_object_version_number_o =>pqh_pti_shd.g_old_rec.object_version_number
165: );

Line 162: ,p_multiple_occurences_flag_o =>pqh_pti_shd.g_old_rec.multiple_occurences_flag

158: (
159: p_information_type =>p_rec.information_type
160: ,p_active_inactive_flag_o =>pqh_pti_shd.g_old_rec.active_inactive_flag
161: ,p_description_o =>pqh_pti_shd.g_old_rec.description
162: ,p_multiple_occurences_flag_o =>pqh_pti_shd.g_old_rec.multiple_occurences_flag
163: ,p_legislation_code_o =>pqh_pti_shd.g_old_rec.legislation_code
164: ,p_object_version_number_o =>pqh_pti_shd.g_old_rec.object_version_number
165: );
166: --

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

159: p_information_type =>p_rec.information_type
160: ,p_active_inactive_flag_o =>pqh_pti_shd.g_old_rec.active_inactive_flag
161: ,p_description_o =>pqh_pti_shd.g_old_rec.description
162: ,p_multiple_occurences_flag_o =>pqh_pti_shd.g_old_rec.multiple_occurences_flag
163: ,p_legislation_code_o =>pqh_pti_shd.g_old_rec.legislation_code
164: ,p_object_version_number_o =>pqh_pti_shd.g_old_rec.object_version_number
165: );
166: --
167: exception

Line 164: ,p_object_version_number_o =>pqh_pti_shd.g_old_rec.object_version_number

160: ,p_active_inactive_flag_o =>pqh_pti_shd.g_old_rec.active_inactive_flag
161: ,p_description_o =>pqh_pti_shd.g_old_rec.description
162: ,p_multiple_occurences_flag_o =>pqh_pti_shd.g_old_rec.multiple_occurences_flag
163: ,p_legislation_code_o =>pqh_pti_shd.g_old_rec.legislation_code
164: ,p_object_version_number_o =>pqh_pti_shd.g_old_rec.object_version_number
165: );
166: --
167: exception
168: --

Line 189: p_rec in pqh_pti_shd.g_rec_type

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

Line 199: pqh_pti_shd.lck

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

Line 234: l_rec pqh_pti_shd.g_rec_type;

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