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_PTU_SHD dependencies on PER_PERSON_TYPE_USAGES_F

Line 21: If (p_constraint_name = 'PER_PERSON_TYPE_USAGES_F_FK1') Then

17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PER_PERSON_TYPE_USAGES_F_FK1') Then
22: hr_utility.set_message(801, 'HR_52361_PTU_INVALID_PERSON_ID');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','10');
25: hr_utility.raise_error;

Line 26: elsif (p_constraint_name = 'PER_PERSON_TYPE_USAGES_F_UK1') Then

22: hr_utility.set_message(801, 'HR_52361_PTU_INVALID_PERSON_ID');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','10');
25: hr_utility.raise_error;
26: elsif (p_constraint_name = 'PER_PERSON_TYPE_USAGES_F_UK1') Then
27: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','15');
30: hr_utility.raise_error;

Line 31: elsif (p_constraint_name = 'PER_PERSON_TYPE_USAGES_F_FK2') Then

27: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','15');
30: hr_utility.raise_error;
31: elsif (p_constraint_name = 'PER_PERSON_TYPE_USAGES_F_FK2') Then
32: hr_utility.set_message(801, 'HR_52362_PTU_INV_PER_TYPE_ID');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP','20');
35: hr_utility.raise_error;

Line 101: from per_person_type_usages_f

97: attribute27,
98: attribute28,
99: attribute29,
100: attribute30
101: from per_person_type_usages_f
102: where person_type_usage_id = p_person_type_usage_id
103: and p_effective_date
104: between effective_start_date and effective_end_date;
105: --

Line 174: from per_person_type_usages_f ptu

170: l_parent_key_value1 number;
171: --
172: Cursor C_Sel1 Is
173: select ptu.person_id
174: from per_person_type_usages_f ptu
175: where ptu.person_type_usage_id = p_base_key_value
176: and p_effective_date between ptu.effective_start_date
177: and ptu.effective_end_date;
178: --

Line 197: p_base_table_name => 'per_person_type_usages_f',

193: -- Call the corresponding datetrack api
194: --
195: dt_api.find_dt_del_modes
196: (p_effective_date => p_effective_date,
197: p_base_table_name => 'per_person_type_usages_f',
198: p_base_key_column => 'person_type_usage_id',
199: p_base_key_value => p_base_key_value,
200: p_parent_table_name1 => 'per_people_f',
201: p_parent_key_column1 => 'person_id',

Line 263: p_base_table_name => 'per_person_type_usages_f',

259: -- Call the corresponding datetrack api
260: --
261: dt_api.find_dt_upd_modes
262: (p_effective_date => p_effective_date,
263: p_base_table_name => 'per_person_type_usages_f',
264: p_base_key_column => 'person_type_usage_id',
265: p_base_key_value => p_base_key_value,
266: p_correction => p_correction,
267: p_update => p_update,

Line 320: from per_person_type_usages_f

316: l_new ben_ptu_ler.g_ptu_ler_rec;
317: --
318: cursor c1 is
319: select *
320: from per_person_type_usages_f
321: where person_type_usage_id = p_base_key_value
322: and p_effective_date
323: between effective_start_date
324: and effective_end_date;

Line 340: (p_base_table_name => 'per_person_type_usages_f',

336: -- version number.
337: --
338: l_object_version_number :=
339: dt_api.get_object_version_number
340: (p_base_table_name => 'per_person_type_usages_f',
341: p_base_key_column => 'person_type_usage_id',
342: p_base_key_value => p_base_key_value);
343: --
344: hr_utility.set_location(l_proc, 10);

Line 363: update per_person_type_usages_f t

359: --
360: -- Update the specified datetrack row setting the effective
361: -- end date to the specified new effective end date.
362: --
363: update per_person_type_usages_f t
364: set t.effective_end_date = p_new_effective_end_date,
365: t.object_version_number = l_object_version_number
366: where t.person_type_usage_id = p_base_key_value
367: and p_effective_date

Line 464: from per_person_type_usages_f

460: attribute27,
461: attribute28,
462: attribute29,
463: attribute30
464: from per_person_type_usages_f
465: where person_type_usage_id = p_person_type_usage_id
466: and p_effective_date
467: between effective_start_date and effective_end_date
468: for update nowait;

Line 523: p_base_table_name => 'per_person_type_usages_f',

519: --
520: dt_api.validate_dt_mode
521: (p_effective_date => p_effective_date,
522: p_datetrack_mode => p_datetrack_mode,
523: p_base_table_name => 'per_person_type_usages_f',
524: p_base_key_column => 'person_type_usage_id',
525: p_base_key_value => p_person_type_usage_id,
526: p_parent_table_name1 => 'per_all_people_f',
527: p_parent_key_column1 => 'person_id',

Line 560: hr_utility.set_message_token('TABLE_NAME', 'per_person_type_usages_f');

556: -- The object is locked therefore we need to supply a meaningful
557: -- error message.
558: --
559: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
560: hr_utility.set_message_token('TABLE_NAME', 'per_person_type_usages_f');
561: hr_utility.raise_error;
562: When l_object_invalid then
563: --
564: -- The object doesn't exist or is invalid

Line 567: hr_utility.set_message_token('TABLE_NAME', 'per_person_type_usages_f');

563: --
564: -- The object doesn't exist or is invalid
565: --
566: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
567: hr_utility.set_message_token('TABLE_NAME', 'per_person_type_usages_f');
568: hr_utility.raise_error;
569: End lck;
570: --
571: -- ----------------------------------------------------------------------------