APPS.PER_PER_SHD dependencies on PER_PEOPLE_F

Line 36: If (p_constraint_name = 'PER_PEOPLE_F_FK1') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PER_PEOPLE_F_FK1') Then
37: -- Error: The Business Group is not defined.
38: hr_utility.set_message(801, 'HR_6673_PO_EMP_NO_BG');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'PER_PEOPLE_F_FK2') Then

Line 40: ElsIf (p_constraint_name = 'PER_PEOPLE_F_FK2') Then

36: If (p_constraint_name = 'PER_PEOPLE_F_FK1') Then
37: -- Error: The Business Group is not defined.
38: hr_utility.set_message(801, 'HR_6673_PO_EMP_NO_BG');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'PER_PEOPLE_F_FK2') Then
41: -- Error: Invalid person type
42: hr_utility.set_message(801, 'HR_7513_PER_TYPE_INVALID');
43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'PER_PEOPLE_F_PK') Then

Line 44: ElsIf (p_constraint_name = 'PER_PEOPLE_F_PK') Then

40: ElsIf (p_constraint_name = 'PER_PEOPLE_F_FK2') Then
41: -- Error: Invalid person type
42: hr_utility.set_message(801, 'HR_7513_PER_TYPE_INVALID');
43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'PER_PEOPLE_F_PK') Then
45: -- Error: The primary key specified is invalid
46: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PER_PER_EXPENSE_CHECK_SEND_CHK') Then

Line 594: from per_people_f

590: npw_number,
591: current_npw_flag,
592: global_name,
593: local_name
594: from per_people_f
595: where person_id = p_person_id
596: and p_effective_date
597: between effective_start_date and effective_end_date
598: for update nowait;

Line 679: p_base_table_name => 'per_people_f',

675: --
676: dt_api.validate_dt_mode
677: (p_effective_date => p_effective_date,
678: p_datetrack_mode => p_datetrack_mode,
679: p_base_table_name => 'per_people_f',
680: p_base_key_column => 'person_id',
681: p_base_key_value => p_person_id,
682: p_child_table_name1 => 'per_contracts_f',
683: p_child_key_column1 => 'contract_id',

Line 715: hr_utility.set_message_token('TABLE_NAME', 'per_people_f');

711: -- The object is locked therefore we need to supply a meaningful
712: -- error message.
713: --
714: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
715: hr_utility.set_message_token('TABLE_NAME', 'per_people_f');
716: hr_utility.raise_error;
717: When l_object_invalid then
718: --
719: -- The object doesn't exist or is invalid

Line 722: hr_utility.set_message_token('TABLE_NAME', 'per_people_f');

718: --
719: -- The object doesn't exist or is invalid
720: --
721: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
722: hr_utility.set_message_token('TABLE_NAME', 'per_people_f');
723: hr_utility.raise_error;
724: End lck;
725: --
726: -- ----------------------------------------------------------------------------