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.PER_PSV_DEL dependencies on PER_PSV_SHD

Line 52: (p_rec in per_psv_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in per_psv_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 60: per_psv_shd.g_api_dml := true; -- Set the api dml status

56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: per_psv_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the per_pos_structure_versions row.
63: --
64: delete from per_pos_structure_versions

Line 67: per_psv_shd.g_api_dml := false; -- Unset the api dml status

63: --
64: delete from per_pos_structure_versions
65: where pos_structure_version_id = p_rec.pos_structure_version_id;
66: --
67: per_psv_shd.g_api_dml := false; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception

Line 74: per_psv_shd.g_api_dml := false; -- Unset the api dml status

70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: per_psv_shd.g_api_dml := false; -- Unset the api dml status
75: per_psv_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: per_psv_shd.g_api_dml := false; -- Unset the api dml status

Line 75: per_psv_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: per_psv_shd.g_api_dml := false; -- Unset the api dml status
75: per_psv_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: per_psv_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;

Line 78: per_psv_shd.g_api_dml := false; -- Unset the api dml status

74: per_psv_shd.g_api_dml := false; -- Unset the api dml status
75: per_psv_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: per_psv_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;
80: End delete_dml;
81: --
82: -- ----------------------------------------------------------------------------

Line 114: Procedure pre_delete(p_rec in per_psv_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in per_psv_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 156: Procedure post_delete(p_rec in per_psv_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in per_psv_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => per_psv_shd.g_old_rec.business_group_id

164: per_psv_rkd.after_delete
165: (p_pos_structure_version_id
166: => p_rec.pos_structure_version_id
167: ,p_business_group_id_o
168: => per_psv_shd.g_old_rec.business_group_id
169: ,p_position_structure_id_o
170: => per_psv_shd.g_old_rec.position_structure_id
171: ,p_date_from_o
172: => per_psv_shd.g_old_rec.date_from

Line 170: => per_psv_shd.g_old_rec.position_structure_id

166: => p_rec.pos_structure_version_id
167: ,p_business_group_id_o
168: => per_psv_shd.g_old_rec.business_group_id
169: ,p_position_structure_id_o
170: => per_psv_shd.g_old_rec.position_structure_id
171: ,p_date_from_o
172: => per_psv_shd.g_old_rec.date_from
173: ,p_version_number_o
174: => per_psv_shd.g_old_rec.version_number

Line 172: => per_psv_shd.g_old_rec.date_from

168: => per_psv_shd.g_old_rec.business_group_id
169: ,p_position_structure_id_o
170: => per_psv_shd.g_old_rec.position_structure_id
171: ,p_date_from_o
172: => per_psv_shd.g_old_rec.date_from
173: ,p_version_number_o
174: => per_psv_shd.g_old_rec.version_number
175: ,p_copy_structure_version_id_o
176: => per_psv_shd.g_old_rec.copy_structure_version_id

Line 174: => per_psv_shd.g_old_rec.version_number

170: => per_psv_shd.g_old_rec.position_structure_id
171: ,p_date_from_o
172: => per_psv_shd.g_old_rec.date_from
173: ,p_version_number_o
174: => per_psv_shd.g_old_rec.version_number
175: ,p_copy_structure_version_id_o
176: => per_psv_shd.g_old_rec.copy_structure_version_id
177: ,p_date_to_o
178: => per_psv_shd.g_old_rec.date_to

Line 176: => per_psv_shd.g_old_rec.copy_structure_version_id

172: => per_psv_shd.g_old_rec.date_from
173: ,p_version_number_o
174: => per_psv_shd.g_old_rec.version_number
175: ,p_copy_structure_version_id_o
176: => per_psv_shd.g_old_rec.copy_structure_version_id
177: ,p_date_to_o
178: => per_psv_shd.g_old_rec.date_to
179: ,p_request_id_o
180: => per_psv_shd.g_old_rec.request_id

Line 178: => per_psv_shd.g_old_rec.date_to

174: => per_psv_shd.g_old_rec.version_number
175: ,p_copy_structure_version_id_o
176: => per_psv_shd.g_old_rec.copy_structure_version_id
177: ,p_date_to_o
178: => per_psv_shd.g_old_rec.date_to
179: ,p_request_id_o
180: => per_psv_shd.g_old_rec.request_id
181: ,p_program_application_id_o
182: => per_psv_shd.g_old_rec.program_application_id

Line 180: => per_psv_shd.g_old_rec.request_id

176: => per_psv_shd.g_old_rec.copy_structure_version_id
177: ,p_date_to_o
178: => per_psv_shd.g_old_rec.date_to
179: ,p_request_id_o
180: => per_psv_shd.g_old_rec.request_id
181: ,p_program_application_id_o
182: => per_psv_shd.g_old_rec.program_application_id
183: ,p_program_id_o
184: => per_psv_shd.g_old_rec.program_id

Line 182: => per_psv_shd.g_old_rec.program_application_id

178: => per_psv_shd.g_old_rec.date_to
179: ,p_request_id_o
180: => per_psv_shd.g_old_rec.request_id
181: ,p_program_application_id_o
182: => per_psv_shd.g_old_rec.program_application_id
183: ,p_program_id_o
184: => per_psv_shd.g_old_rec.program_id
185: ,p_program_update_date_o
186: => per_psv_shd.g_old_rec.program_update_date

Line 184: => per_psv_shd.g_old_rec.program_id

180: => per_psv_shd.g_old_rec.request_id
181: ,p_program_application_id_o
182: => per_psv_shd.g_old_rec.program_application_id
183: ,p_program_id_o
184: => per_psv_shd.g_old_rec.program_id
185: ,p_program_update_date_o
186: => per_psv_shd.g_old_rec.program_update_date
187: ,p_object_version_number_o
188: => per_psv_shd.g_old_rec.object_version_number

Line 186: => per_psv_shd.g_old_rec.program_update_date

182: => per_psv_shd.g_old_rec.program_application_id
183: ,p_program_id_o
184: => per_psv_shd.g_old_rec.program_id
185: ,p_program_update_date_o
186: => per_psv_shd.g_old_rec.program_update_date
187: ,p_object_version_number_o
188: => per_psv_shd.g_old_rec.object_version_number
189: );
190: --

Line 188: => per_psv_shd.g_old_rec.object_version_number

184: => per_psv_shd.g_old_rec.program_id
185: ,p_program_update_date_o
186: => per_psv_shd.g_old_rec.program_update_date
187: ,p_object_version_number_o
188: => per_psv_shd.g_old_rec.object_version_number
189: );
190: --
191: exception
192: --

Line 208: (p_rec in per_psv_shd.g_rec_type

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

Line 218: per_psv_shd.lck

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

Line 249: l_rec per_psv_shd.g_rec_type;

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