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_ASP_UPD dependencies on PER_ASP_SHD

Line 54: Procedure update_dml(p_rec in out nocopy per_asp_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_asp_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 85: per_asp_shd.constraint_error

81: --
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: per_asp_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: per_asp_shd.constraint_error

Line 89: per_asp_shd.constraint_error

85: per_asp_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: per_asp_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: per_asp_shd.constraint_error

Line 93: per_asp_shd.constraint_error

89: per_asp_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: per_asp_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When Others Then
96: Raise;
97: End update_dml;

Line 131: Procedure pre_update(p_rec in per_asp_shd.g_rec_type) is

127: -- Internal Row Handler Use Only.
128: --
129: -- {End Of Comments}
130: -- ----------------------------------------------------------------------------
131: Procedure pre_update(p_rec in per_asp_shd.g_rec_type) is
132: --
133: l_proc varchar2(72) := g_package||'pre_update';
134: --
135: Begin

Line 173: Procedure post_update(p_rec in per_asp_shd.g_rec_type) is

169: -- Internal Row Handler Use Only.
170: --
171: -- {End Of Comments}
172: -- ----------------------------------------------------------------------------
173: Procedure post_update(p_rec in per_asp_shd.g_rec_type) is
174: --
175: l_proc varchar2(72) := g_package||'post_update';
176: --
177: Begin

Line 210: ,p_user_id_o =>per_asp_shd.g_old_rec.user_id

206: ,p_responsibility_application_i =>p_rec.responsibility_application_id
207: ,p_start_date =>p_rec.start_date
208: ,p_end_date =>p_rec.end_date
209: ,p_object_version_number =>p_rec.object_version_number
210: ,p_user_id_o =>per_asp_shd.g_old_rec.user_id
211: ,p_security_group_id_o =>per_asp_shd.g_old_rec.security_group_id
212: ,p_security_profile_id_o =>per_asp_shd.g_old_rec.security_profile_id
213: ,p_responsibility_id_o =>per_asp_shd.g_old_rec.responsibility_id
214: ,p_responsibility_application_o=>per_asp_shd.g_old_rec.responsibility_application_id

Line 211: ,p_security_group_id_o =>per_asp_shd.g_old_rec.security_group_id

207: ,p_start_date =>p_rec.start_date
208: ,p_end_date =>p_rec.end_date
209: ,p_object_version_number =>p_rec.object_version_number
210: ,p_user_id_o =>per_asp_shd.g_old_rec.user_id
211: ,p_security_group_id_o =>per_asp_shd.g_old_rec.security_group_id
212: ,p_security_profile_id_o =>per_asp_shd.g_old_rec.security_profile_id
213: ,p_responsibility_id_o =>per_asp_shd.g_old_rec.responsibility_id
214: ,p_responsibility_application_o=>per_asp_shd.g_old_rec.responsibility_application_id
215: ,p_start_date_o =>per_asp_shd.g_old_rec.start_date

Line 212: ,p_security_profile_id_o =>per_asp_shd.g_old_rec.security_profile_id

208: ,p_end_date =>p_rec.end_date
209: ,p_object_version_number =>p_rec.object_version_number
210: ,p_user_id_o =>per_asp_shd.g_old_rec.user_id
211: ,p_security_group_id_o =>per_asp_shd.g_old_rec.security_group_id
212: ,p_security_profile_id_o =>per_asp_shd.g_old_rec.security_profile_id
213: ,p_responsibility_id_o =>per_asp_shd.g_old_rec.responsibility_id
214: ,p_responsibility_application_o=>per_asp_shd.g_old_rec.responsibility_application_id
215: ,p_start_date_o =>per_asp_shd.g_old_rec.start_date
216: ,p_end_date_o =>per_asp_shd.g_old_rec.end_date

Line 213: ,p_responsibility_id_o =>per_asp_shd.g_old_rec.responsibility_id

209: ,p_object_version_number =>p_rec.object_version_number
210: ,p_user_id_o =>per_asp_shd.g_old_rec.user_id
211: ,p_security_group_id_o =>per_asp_shd.g_old_rec.security_group_id
212: ,p_security_profile_id_o =>per_asp_shd.g_old_rec.security_profile_id
213: ,p_responsibility_id_o =>per_asp_shd.g_old_rec.responsibility_id
214: ,p_responsibility_application_o=>per_asp_shd.g_old_rec.responsibility_application_id
215: ,p_start_date_o =>per_asp_shd.g_old_rec.start_date
216: ,p_end_date_o =>per_asp_shd.g_old_rec.end_date
217: ,p_object_version_number_o =>per_asp_shd.g_old_rec.object_version_number

Line 214: ,p_responsibility_application_o=>per_asp_shd.g_old_rec.responsibility_application_id

210: ,p_user_id_o =>per_asp_shd.g_old_rec.user_id
211: ,p_security_group_id_o =>per_asp_shd.g_old_rec.security_group_id
212: ,p_security_profile_id_o =>per_asp_shd.g_old_rec.security_profile_id
213: ,p_responsibility_id_o =>per_asp_shd.g_old_rec.responsibility_id
214: ,p_responsibility_application_o=>per_asp_shd.g_old_rec.responsibility_application_id
215: ,p_start_date_o =>per_asp_shd.g_old_rec.start_date
216: ,p_end_date_o =>per_asp_shd.g_old_rec.end_date
217: ,p_object_version_number_o =>per_asp_shd.g_old_rec.object_version_number
218: );

Line 215: ,p_start_date_o =>per_asp_shd.g_old_rec.start_date

211: ,p_security_group_id_o =>per_asp_shd.g_old_rec.security_group_id
212: ,p_security_profile_id_o =>per_asp_shd.g_old_rec.security_profile_id
213: ,p_responsibility_id_o =>per_asp_shd.g_old_rec.responsibility_id
214: ,p_responsibility_application_o=>per_asp_shd.g_old_rec.responsibility_application_id
215: ,p_start_date_o =>per_asp_shd.g_old_rec.start_date
216: ,p_end_date_o =>per_asp_shd.g_old_rec.end_date
217: ,p_object_version_number_o =>per_asp_shd.g_old_rec.object_version_number
218: );
219: --

Line 216: ,p_end_date_o =>per_asp_shd.g_old_rec.end_date

212: ,p_security_profile_id_o =>per_asp_shd.g_old_rec.security_profile_id
213: ,p_responsibility_id_o =>per_asp_shd.g_old_rec.responsibility_id
214: ,p_responsibility_application_o=>per_asp_shd.g_old_rec.responsibility_application_id
215: ,p_start_date_o =>per_asp_shd.g_old_rec.start_date
216: ,p_end_date_o =>per_asp_shd.g_old_rec.end_date
217: ,p_object_version_number_o =>per_asp_shd.g_old_rec.object_version_number
218: );
219: --
220: exception

Line 217: ,p_object_version_number_o =>per_asp_shd.g_old_rec.object_version_number

213: ,p_responsibility_id_o =>per_asp_shd.g_old_rec.responsibility_id
214: ,p_responsibility_application_o=>per_asp_shd.g_old_rec.responsibility_application_id
215: ,p_start_date_o =>per_asp_shd.g_old_rec.start_date
216: ,p_end_date_o =>per_asp_shd.g_old_rec.end_date
217: ,p_object_version_number_o =>per_asp_shd.g_old_rec.object_version_number
218: );
219: --
220: exception
221: --

Line 280: Procedure convert_defs(p_rec in out nocopy per_asp_shd.g_rec_type) is

276: -- Internal Row Handler Use Only.
277: --
278: -- {End Of Comments}
279: -- ----------------------------------------------------------------------------
280: Procedure convert_defs(p_rec in out nocopy per_asp_shd.g_rec_type) is
281: --
282: l_proc varchar2(72) := g_package||'convert_defs';
283: --
284: Begin

Line 295: per_asp_shd.g_old_rec.user_id;

291: -- is being used then we must set to the 'current' argument value.
292: --
293: If (p_rec.user_id = hr_api.g_number) then
294: p_rec.user_id :=
295: per_asp_shd.g_old_rec.user_id;
296: End If;
297: If (p_rec.security_group_id = hr_api.g_number) then
298: p_rec.security_group_id :=
299: per_asp_shd.g_old_rec.security_group_id;

Line 299: per_asp_shd.g_old_rec.security_group_id;

295: per_asp_shd.g_old_rec.user_id;
296: End If;
297: If (p_rec.security_group_id = hr_api.g_number) then
298: p_rec.security_group_id :=
299: per_asp_shd.g_old_rec.security_group_id;
300: End If;
301: If (p_rec.business_group_id = hr_api.g_number) then
302: p_rec.business_group_id :=
303: per_asp_shd.g_old_rec.business_group_id;

Line 303: per_asp_shd.g_old_rec.business_group_id;

299: per_asp_shd.g_old_rec.security_group_id;
300: End If;
301: If (p_rec.business_group_id = hr_api.g_number) then
302: p_rec.business_group_id :=
303: per_asp_shd.g_old_rec.business_group_id;
304: End If;
305: If (p_rec.security_profile_id = hr_api.g_number) then
306: p_rec.security_profile_id :=
307: per_asp_shd.g_old_rec.security_profile_id;

Line 307: per_asp_shd.g_old_rec.security_profile_id;

303: per_asp_shd.g_old_rec.business_group_id;
304: End If;
305: If (p_rec.security_profile_id = hr_api.g_number) then
306: p_rec.security_profile_id :=
307: per_asp_shd.g_old_rec.security_profile_id;
308: End If;
309: If (p_rec.responsibility_id = hr_api.g_number) then
310: p_rec.responsibility_id :=
311: per_asp_shd.g_old_rec.responsibility_id;

Line 311: per_asp_shd.g_old_rec.responsibility_id;

307: per_asp_shd.g_old_rec.security_profile_id;
308: End If;
309: If (p_rec.responsibility_id = hr_api.g_number) then
310: p_rec.responsibility_id :=
311: per_asp_shd.g_old_rec.responsibility_id;
312: End If;
313: If (p_rec.responsibility_application_id = hr_api.g_number) then
314: p_rec.responsibility_application_id :=
315: per_asp_shd.g_old_rec.responsibility_application_id;

Line 315: per_asp_shd.g_old_rec.responsibility_application_id;

311: per_asp_shd.g_old_rec.responsibility_id;
312: End If;
313: If (p_rec.responsibility_application_id = hr_api.g_number) then
314: p_rec.responsibility_application_id :=
315: per_asp_shd.g_old_rec.responsibility_application_id;
316: End If;
317: If (p_rec.start_date = hr_api.g_date) then
318: p_rec.start_date :=
319: per_asp_shd.g_old_rec.start_date;

Line 319: per_asp_shd.g_old_rec.start_date;

315: per_asp_shd.g_old_rec.responsibility_application_id;
316: End If;
317: If (p_rec.start_date = hr_api.g_date) then
318: p_rec.start_date :=
319: per_asp_shd.g_old_rec.start_date;
320: End If;
321: If (p_rec.end_date = hr_api.g_date) then
322: p_rec.end_date :=
323: per_asp_shd.g_old_rec.end_date;

Line 323: per_asp_shd.g_old_rec.end_date;

319: per_asp_shd.g_old_rec.start_date;
320: End If;
321: If (p_rec.end_date = hr_api.g_date) then
322: p_rec.end_date :=
323: per_asp_shd.g_old_rec.end_date;
324: End If;
325:
326: --
327: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 336: p_rec in out nocopy per_asp_shd.g_rec_type

332: -- |---------------------------------< upd >----------------------------------|
333: -- ----------------------------------------------------------------------------
334: Procedure upd
335: (
336: p_rec in out nocopy per_asp_shd.g_rec_type
337: ) is
338: --
339: l_proc varchar2(72) := g_package||'upd';
340: --

Line 346: per_asp_shd.lck

342: hr_utility.set_location('Entering:'||l_proc, 5);
343: --
344: -- We must lock the row which we need to update.
345: --
346: per_asp_shd.lck
347: (
348: p_rec.sec_profile_assignment_id,
349: p_rec.object_version_number
350: );

Line 390: l_rec per_asp_shd.g_rec_type;

386: p_end_date in date default hr_api.g_date,
387: p_object_version_number in out nocopy number
388: ) is
389: --
390: l_rec per_asp_shd.g_rec_type;
391: l_proc varchar2(72) := g_package||'upd';
392: --
393: Begin
394: hr_utility.set_location('Entering:'||l_proc, 5);

Line 401: per_asp_shd.convert_args

397: -- l_rec structure.
398: --
399: /*
400: l_rec :=
401: per_asp_shd.convert_args
402: (
403: p_sec_profile_assignment_id,
404: p_user_id,
405: p_security_group_id,

Line 415: per_asp_shd.convert_args

411: p_object_version_number
412: );
413: */
414: l_rec :=
415: per_asp_shd.convert_args
416: (
417: p_sec_profile_assignment_id,
418: hr_api.g_number,
419: hr_api.g_number,