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.HR_CONTACT_REL_API dependencies on HR_API

Line 456: when hr_api.cannot_find_prog_unit then

452: ,p_mirror_cont_information19 => p_mirror_cont_information19
453: ,p_mirror_cont_information20 => p_mirror_cont_information20
454: );
455: exception
456: when hr_api.cannot_find_prog_unit then
457: hr_api.cannot_find_prog_unit_error
458: (p_module_name => 'Create_contact'
459: ,p_hook_type => 'BP'
460: );

Line 457: hr_api.cannot_find_prog_unit_error

453: ,p_mirror_cont_information20 => p_mirror_cont_information20
454: );
455: exception
456: when hr_api.cannot_find_prog_unit then
457: hr_api.cannot_find_prog_unit_error
458: (p_module_name => 'Create_contact'
459: ,p_hook_type => 'BP'
460: );
461: --

Line 1005: when hr_api.cannot_find_prog_unit then

1001: ,p_name_combination_warning => l_name_combination_warning
1002: ,p_orig_hire_warning => l_orig_hire_warning
1003: );
1004: exception
1005: when hr_api.cannot_find_prog_unit then
1006: hr_api.cannot_find_prog_unit_error
1007: (p_module_name => 'Create_contact'
1008: ,p_hook_type => 'AP'
1009: );

Line 1006: hr_api.cannot_find_prog_unit_error

1002: ,p_orig_hire_warning => l_orig_hire_warning
1003: );
1004: exception
1005: when hr_api.cannot_find_prog_unit then
1006: hr_api.cannot_find_prog_unit_error
1007: (p_module_name => 'Create_contact'
1008: ,p_hook_type => 'AP'
1009: );
1010: --

Line 1018: raise hr_api.validate_enabled;

1014: --
1015: -- When in validation only mode raise the Validate_Enabled exception
1016: --
1017: if p_validate then
1018: raise hr_api.validate_enabled;
1019: end if;
1020: --
1021: hr_utility.set_location(' Leaving:'||l_proc, 11);
1022: exception

Line 1023: when hr_api.validate_enabled then

1019: end if;
1020: --
1021: hr_utility.set_location(' Leaving:'||l_proc, 11);
1022: exception
1023: when hr_api.validate_enabled then
1024: --
1025: -- As the Validate_Enabled exception has been raised
1026: -- we must rollback to the savepoint
1027: --

Line 1081: ,p_contact_type in varchar2 default hr_api.g_varchar2

1077: procedure update_contact_relationship
1078: (p_validate in boolean default false
1079: ,p_effective_date in date
1080: ,p_contact_relationship_id in number
1081: ,p_contact_type in varchar2 default hr_api.g_varchar2
1082: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
1083: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1084: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1085: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2

Line 1082: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792

1078: (p_validate in boolean default false
1079: ,p_effective_date in date
1080: ,p_contact_relationship_id in number
1081: ,p_contact_type in varchar2 default hr_api.g_varchar2
1082: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
1083: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1084: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1085: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1086: ,p_date_start in date default hr_api.g_date

Line 1083: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2

1079: ,p_effective_date in date
1080: ,p_contact_relationship_id in number
1081: ,p_contact_type in varchar2 default hr_api.g_varchar2
1082: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
1083: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1084: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1085: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1086: ,p_date_start in date default hr_api.g_date
1087: ,p_start_life_reason_id in number default hr_api.g_number

Line 1084: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2

1080: ,p_contact_relationship_id in number
1081: ,p_contact_type in varchar2 default hr_api.g_varchar2
1082: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
1083: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1084: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1085: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1086: ,p_date_start in date default hr_api.g_date
1087: ,p_start_life_reason_id in number default hr_api.g_number
1088: ,p_date_end in date default hr_api.g_date

Line 1085: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2

1081: ,p_contact_type in varchar2 default hr_api.g_varchar2
1082: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
1083: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1084: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1085: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1086: ,p_date_start in date default hr_api.g_date
1087: ,p_start_life_reason_id in number default hr_api.g_number
1088: ,p_date_end in date default hr_api.g_date
1089: ,p_end_life_reason_id in number default hr_api.g_number

Line 1086: ,p_date_start in date default hr_api.g_date

1082: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
1083: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1084: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1085: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1086: ,p_date_start in date default hr_api.g_date
1087: ,p_start_life_reason_id in number default hr_api.g_number
1088: ,p_date_end in date default hr_api.g_date
1089: ,p_end_life_reason_id in number default hr_api.g_number
1090: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2

Line 1087: ,p_start_life_reason_id in number default hr_api.g_number

1083: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1084: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1085: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1086: ,p_date_start in date default hr_api.g_date
1087: ,p_start_life_reason_id in number default hr_api.g_number
1088: ,p_date_end in date default hr_api.g_date
1089: ,p_end_life_reason_id in number default hr_api.g_number
1090: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1091: ,p_personal_flag in varchar2 default hr_api.g_varchar2

Line 1088: ,p_date_end in date default hr_api.g_date

1084: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1085: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1086: ,p_date_start in date default hr_api.g_date
1087: ,p_start_life_reason_id in number default hr_api.g_number
1088: ,p_date_end in date default hr_api.g_date
1089: ,p_end_life_reason_id in number default hr_api.g_number
1090: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1091: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1092: ,p_sequence_number in number default hr_api.g_number

Line 1089: ,p_end_life_reason_id in number default hr_api.g_number

1085: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1086: ,p_date_start in date default hr_api.g_date
1087: ,p_start_life_reason_id in number default hr_api.g_number
1088: ,p_date_end in date default hr_api.g_date
1089: ,p_end_life_reason_id in number default hr_api.g_number
1090: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1091: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1092: ,p_sequence_number in number default hr_api.g_number
1093: ,p_dependent_flag in varchar2 default hr_api.g_varchar2

Line 1090: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2

1086: ,p_date_start in date default hr_api.g_date
1087: ,p_start_life_reason_id in number default hr_api.g_number
1088: ,p_date_end in date default hr_api.g_date
1089: ,p_end_life_reason_id in number default hr_api.g_number
1090: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1091: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1092: ,p_sequence_number in number default hr_api.g_number
1093: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1094: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2

Line 1091: ,p_personal_flag in varchar2 default hr_api.g_varchar2

1087: ,p_start_life_reason_id in number default hr_api.g_number
1088: ,p_date_end in date default hr_api.g_date
1089: ,p_end_life_reason_id in number default hr_api.g_number
1090: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1091: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1092: ,p_sequence_number in number default hr_api.g_number
1093: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1094: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1095: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2

Line 1092: ,p_sequence_number in number default hr_api.g_number

1088: ,p_date_end in date default hr_api.g_date
1089: ,p_end_life_reason_id in number default hr_api.g_number
1090: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1091: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1092: ,p_sequence_number in number default hr_api.g_number
1093: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1094: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1095: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1096: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2

Line 1093: ,p_dependent_flag in varchar2 default hr_api.g_varchar2

1089: ,p_end_life_reason_id in number default hr_api.g_number
1090: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1091: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1092: ,p_sequence_number in number default hr_api.g_number
1093: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1094: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1095: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1096: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1097: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2

Line 1094: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2

1090: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1091: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1092: ,p_sequence_number in number default hr_api.g_number
1093: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1094: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1095: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1096: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1097: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1098: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2

Line 1095: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2

1091: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1092: ,p_sequence_number in number default hr_api.g_number
1093: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1094: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1095: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1096: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1097: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1098: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1099: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2

Line 1096: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2

1092: ,p_sequence_number in number default hr_api.g_number
1093: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1094: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1095: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1096: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1097: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1098: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1099: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1100: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2

Line 1097: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2

1093: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1094: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1095: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1096: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1097: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1098: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1099: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1100: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1101: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2

Line 1098: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2

1094: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1095: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1096: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1097: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1098: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1099: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1100: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1101: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1102: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2

Line 1099: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2

1095: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1096: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1097: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1098: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1099: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1100: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1101: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1102: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1103: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2

Line 1100: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2

1096: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1097: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1098: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1099: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1100: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1101: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1102: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1103: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1104: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2

Line 1101: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2

1097: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1098: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1099: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1100: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1101: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1102: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1103: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1104: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1105: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2

Line 1102: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2

1098: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1099: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1100: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1101: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1102: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1103: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1104: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1105: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1106: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2

Line 1103: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2

1099: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1100: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1101: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1102: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1103: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1104: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1105: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1106: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1107: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2

Line 1104: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2

1100: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1101: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1102: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1103: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1104: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1105: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1106: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1107: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1108: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2

Line 1105: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2

1101: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1102: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1103: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1104: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1105: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1106: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1107: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1108: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1109: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2

Line 1106: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2

1102: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1103: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1104: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1105: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1106: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1107: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1108: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1109: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1110: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2

Line 1107: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2

1103: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1104: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1105: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1106: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1107: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1108: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1109: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1110: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1111: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2

Line 1108: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2

1104: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1105: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1106: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1107: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1108: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1109: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1110: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1111: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1112: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2

Line 1109: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2

1105: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1106: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1107: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1108: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1109: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1110: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1111: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1112: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1113: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2

Line 1110: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2

1106: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1107: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1108: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1109: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1110: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1111: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1112: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1113: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1114: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2

Line 1111: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2

1107: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1108: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1109: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1110: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1111: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1112: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1113: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1114: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1115: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2

Line 1112: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2

1108: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1109: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1110: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1111: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1112: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1113: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1114: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1115: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1116: ,p_cont_information_category in varchar2 default hr_api.g_varchar2

Line 1113: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2

1109: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1110: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1111: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1112: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1113: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1114: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1115: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1116: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1117: ,p_cont_information1 in varchar2 default hr_api.g_varchar2

Line 1114: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2

1110: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1111: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1112: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1113: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1114: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1115: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1116: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1117: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1118: ,p_cont_information2 in varchar2 default hr_api.g_varchar2

Line 1115: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2

1111: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1112: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1113: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1114: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1115: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1116: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1117: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1118: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1119: ,p_cont_information3 in varchar2 default hr_api.g_varchar2

Line 1116: ,p_cont_information_category in varchar2 default hr_api.g_varchar2

1112: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1113: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1114: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1115: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1116: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1117: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1118: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1119: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1120: ,p_cont_information4 in varchar2 default hr_api.g_varchar2

Line 1117: ,p_cont_information1 in varchar2 default hr_api.g_varchar2

1113: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1114: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1115: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1116: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1117: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1118: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1119: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1120: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1121: ,p_cont_information5 in varchar2 default hr_api.g_varchar2

Line 1118: ,p_cont_information2 in varchar2 default hr_api.g_varchar2

1114: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1115: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1116: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1117: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1118: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1119: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1120: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1121: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1122: ,p_cont_information6 in varchar2 default hr_api.g_varchar2

Line 1119: ,p_cont_information3 in varchar2 default hr_api.g_varchar2

1115: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1116: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1117: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1118: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1119: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1120: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1121: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1122: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1123: ,p_cont_information7 in varchar2 default hr_api.g_varchar2

Line 1120: ,p_cont_information4 in varchar2 default hr_api.g_varchar2

1116: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1117: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1118: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1119: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1120: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1121: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1122: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1123: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1124: ,p_cont_information8 in varchar2 default hr_api.g_varchar2

Line 1121: ,p_cont_information5 in varchar2 default hr_api.g_varchar2

1117: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1118: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1119: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1120: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1121: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1122: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1123: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1124: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1125: ,p_cont_information9 in varchar2 default hr_api.g_varchar2

Line 1122: ,p_cont_information6 in varchar2 default hr_api.g_varchar2

1118: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1119: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1120: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1121: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1122: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1123: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1124: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1125: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1126: ,p_cont_information10 in varchar2 default hr_api.g_varchar2

Line 1123: ,p_cont_information7 in varchar2 default hr_api.g_varchar2

1119: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1120: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1121: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1122: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1123: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1124: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1125: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1126: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1127: ,p_cont_information11 in varchar2 default hr_api.g_varchar2

Line 1124: ,p_cont_information8 in varchar2 default hr_api.g_varchar2

1120: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1121: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1122: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1123: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1124: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1125: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1126: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1127: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1128: ,p_cont_information12 in varchar2 default hr_api.g_varchar2

Line 1125: ,p_cont_information9 in varchar2 default hr_api.g_varchar2

1121: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1122: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1123: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1124: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1125: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1126: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1127: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1128: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1129: ,p_cont_information13 in varchar2 default hr_api.g_varchar2

Line 1126: ,p_cont_information10 in varchar2 default hr_api.g_varchar2

1122: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1123: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1124: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1125: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1126: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1127: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1128: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1129: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1130: ,p_cont_information14 in varchar2 default hr_api.g_varchar2

Line 1127: ,p_cont_information11 in varchar2 default hr_api.g_varchar2

1123: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1124: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1125: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1126: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1127: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1128: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1129: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1130: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1131: ,p_cont_information15 in varchar2 default hr_api.g_varchar2

Line 1128: ,p_cont_information12 in varchar2 default hr_api.g_varchar2

1124: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1125: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1126: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1127: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1128: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1129: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1130: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1131: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1132: ,p_cont_information16 in varchar2 default hr_api.g_varchar2

Line 1129: ,p_cont_information13 in varchar2 default hr_api.g_varchar2

1125: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1126: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1127: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1128: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1129: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1130: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1131: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1132: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1133: ,p_cont_information17 in varchar2 default hr_api.g_varchar2

Line 1130: ,p_cont_information14 in varchar2 default hr_api.g_varchar2

1126: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1127: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1128: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1129: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1130: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1131: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1132: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1133: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1134: ,p_cont_information18 in varchar2 default hr_api.g_varchar2

Line 1131: ,p_cont_information15 in varchar2 default hr_api.g_varchar2

1127: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1128: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1129: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1130: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1131: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1132: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1133: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1134: ,p_cont_information18 in varchar2 default hr_api.g_varchar2
1135: ,p_cont_information19 in varchar2 default hr_api.g_varchar2

Line 1132: ,p_cont_information16 in varchar2 default hr_api.g_varchar2

1128: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1129: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1130: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1131: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1132: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1133: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1134: ,p_cont_information18 in varchar2 default hr_api.g_varchar2
1135: ,p_cont_information19 in varchar2 default hr_api.g_varchar2
1136: ,p_cont_information20 in varchar2 default hr_api.g_varchar2

Line 1133: ,p_cont_information17 in varchar2 default hr_api.g_varchar2

1129: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1130: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1131: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1132: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1133: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1134: ,p_cont_information18 in varchar2 default hr_api.g_varchar2
1135: ,p_cont_information19 in varchar2 default hr_api.g_varchar2
1136: ,p_cont_information20 in varchar2 default hr_api.g_varchar2
1137: ,p_object_version_number in out nocopy number

Line 1134: ,p_cont_information18 in varchar2 default hr_api.g_varchar2

1130: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1131: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1132: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1133: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1134: ,p_cont_information18 in varchar2 default hr_api.g_varchar2
1135: ,p_cont_information19 in varchar2 default hr_api.g_varchar2
1136: ,p_cont_information20 in varchar2 default hr_api.g_varchar2
1137: ,p_object_version_number in out nocopy number
1138: )

Line 1135: ,p_cont_information19 in varchar2 default hr_api.g_varchar2

1131: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1132: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1133: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1134: ,p_cont_information18 in varchar2 default hr_api.g_varchar2
1135: ,p_cont_information19 in varchar2 default hr_api.g_varchar2
1136: ,p_cont_information20 in varchar2 default hr_api.g_varchar2
1137: ,p_object_version_number in out nocopy number
1138: )
1139: is

Line 1136: ,p_cont_information20 in varchar2 default hr_api.g_varchar2

1132: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1133: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1134: ,p_cont_information18 in varchar2 default hr_api.g_varchar2
1135: ,p_cont_information19 in varchar2 default hr_api.g_varchar2
1136: ,p_cont_information20 in varchar2 default hr_api.g_varchar2
1137: ,p_object_version_number in out nocopy number
1138: )
1139: is
1140: --

Line 1274: when hr_api.cannot_find_prog_unit then

1270: ,p_cont_information20 => p_cont_information20
1271: ,p_object_version_number => p_object_version_number
1272: );
1273: exception
1274: when hr_api.cannot_find_prog_unit then
1275: hr_api.cannot_find_prog_unit_error
1276: (p_module_name => 'Update_contact_relationship'
1277: ,p_hook_type => 'BP'
1278: );

Line 1275: hr_api.cannot_find_prog_unit_error

1271: ,p_object_version_number => p_object_version_number
1272: );
1273: exception
1274: when hr_api.cannot_find_prog_unit then
1275: hr_api.cannot_find_prog_unit_error
1276: (p_module_name => 'Update_contact_relationship'
1277: ,p_hook_type => 'BP'
1278: );
1279: --

Line 1362: if ((p_date_start <> hr_api.g_date

1358: );
1359:
1360: hr_utility.set_location(l_proc, 30);
1361: --
1362: if ((p_date_start <> hr_api.g_date
1363: and p_date_start <> nvl(l_date_start,hr_api.g_date))
1364: or (p_start_life_reason_id <> hr_api.g_number
1365: and p_start_life_reason_id <> nvl(l_start_life_reason_id,hr_api.g_number))
1366: or ((p_date_end <> hr_api.g_date

Line 1363: and p_date_start <> nvl(l_date_start,hr_api.g_date))

1359:
1360: hr_utility.set_location(l_proc, 30);
1361: --
1362: if ((p_date_start <> hr_api.g_date
1363: and p_date_start <> nvl(l_date_start,hr_api.g_date))
1364: or (p_start_life_reason_id <> hr_api.g_number
1365: and p_start_life_reason_id <> nvl(l_start_life_reason_id,hr_api.g_number))
1366: or ((p_date_end <> hr_api.g_date
1367: and p_date_end <> nvl(l_date_end,hr_api.g_date))

Line 1364: or (p_start_life_reason_id <> hr_api.g_number

1360: hr_utility.set_location(l_proc, 30);
1361: --
1362: if ((p_date_start <> hr_api.g_date
1363: and p_date_start <> nvl(l_date_start,hr_api.g_date))
1364: or (p_start_life_reason_id <> hr_api.g_number
1365: and p_start_life_reason_id <> nvl(l_start_life_reason_id,hr_api.g_number))
1366: or ((p_date_end <> hr_api.g_date
1367: and p_date_end <> nvl(l_date_end,hr_api.g_date))
1368: or p_date_end is null ) --Fix for Bug#8220360

Line 1365: and p_start_life_reason_id <> nvl(l_start_life_reason_id,hr_api.g_number))

1361: --
1362: if ((p_date_start <> hr_api.g_date
1363: and p_date_start <> nvl(l_date_start,hr_api.g_date))
1364: or (p_start_life_reason_id <> hr_api.g_number
1365: and p_start_life_reason_id <> nvl(l_start_life_reason_id,hr_api.g_number))
1366: or ((p_date_end <> hr_api.g_date
1367: and p_date_end <> nvl(l_date_end,hr_api.g_date))
1368: or p_date_end is null ) --Fix for Bug#8220360
1369: or (p_end_life_reason_id <> hr_api.g_number

Line 1366: or ((p_date_end <> hr_api.g_date

1362: if ((p_date_start <> hr_api.g_date
1363: and p_date_start <> nvl(l_date_start,hr_api.g_date))
1364: or (p_start_life_reason_id <> hr_api.g_number
1365: and p_start_life_reason_id <> nvl(l_start_life_reason_id,hr_api.g_number))
1366: or ((p_date_end <> hr_api.g_date
1367: and p_date_end <> nvl(l_date_end,hr_api.g_date))
1368: or p_date_end is null ) --Fix for Bug#8220360
1369: or (p_end_life_reason_id <> hr_api.g_number
1370: and p_end_life_reason_id <> nvl(l_end_life_reason_id,hr_api.g_number))

Line 1367: and p_date_end <> nvl(l_date_end,hr_api.g_date))

1363: and p_date_start <> nvl(l_date_start,hr_api.g_date))
1364: or (p_start_life_reason_id <> hr_api.g_number
1365: and p_start_life_reason_id <> nvl(l_start_life_reason_id,hr_api.g_number))
1366: or ((p_date_end <> hr_api.g_date
1367: and p_date_end <> nvl(l_date_end,hr_api.g_date))
1368: or p_date_end is null ) --Fix for Bug#8220360
1369: or (p_end_life_reason_id <> hr_api.g_number
1370: and p_end_life_reason_id <> nvl(l_end_life_reason_id,hr_api.g_number))
1371: or (p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2

Line 1369: or (p_end_life_reason_id <> hr_api.g_number

1365: and p_start_life_reason_id <> nvl(l_start_life_reason_id,hr_api.g_number))
1366: or ((p_date_end <> hr_api.g_date
1367: and p_date_end <> nvl(l_date_end,hr_api.g_date))
1368: or p_date_end is null ) --Fix for Bug#8220360
1369: or (p_end_life_reason_id <> hr_api.g_number
1370: and p_end_life_reason_id <> nvl(l_end_life_reason_id,hr_api.g_number))
1371: or (p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2
1372: and p_rltd_per_rsds_w_dsgntr_flag <> nvl(l_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2))
1373: or (p_personal_flag <> hr_api.g_varchar2

Line 1370: and p_end_life_reason_id <> nvl(l_end_life_reason_id,hr_api.g_number))

1366: or ((p_date_end <> hr_api.g_date
1367: and p_date_end <> nvl(l_date_end,hr_api.g_date))
1368: or p_date_end is null ) --Fix for Bug#8220360
1369: or (p_end_life_reason_id <> hr_api.g_number
1370: and p_end_life_reason_id <> nvl(l_end_life_reason_id,hr_api.g_number))
1371: or (p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2
1372: and p_rltd_per_rsds_w_dsgntr_flag <> nvl(l_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2))
1373: or (p_personal_flag <> hr_api.g_varchar2
1374: and p_personal_flag <> nvl(l_personal_flag,hr_api.g_varchar2)))

Line 1371: or (p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2

1367: and p_date_end <> nvl(l_date_end,hr_api.g_date))
1368: or p_date_end is null ) --Fix for Bug#8220360
1369: or (p_end_life_reason_id <> hr_api.g_number
1370: and p_end_life_reason_id <> nvl(l_end_life_reason_id,hr_api.g_number))
1371: or (p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2
1372: and p_rltd_per_rsds_w_dsgntr_flag <> nvl(l_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2))
1373: or (p_personal_flag <> hr_api.g_varchar2
1374: and p_personal_flag <> nvl(l_personal_flag,hr_api.g_varchar2)))
1375: and (p_contact_type = hr_api.g_varchar2

Line 1372: and p_rltd_per_rsds_w_dsgntr_flag <> nvl(l_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2))

1368: or p_date_end is null ) --Fix for Bug#8220360
1369: or (p_end_life_reason_id <> hr_api.g_number
1370: and p_end_life_reason_id <> nvl(l_end_life_reason_id,hr_api.g_number))
1371: or (p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2
1372: and p_rltd_per_rsds_w_dsgntr_flag <> nvl(l_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2))
1373: or (p_personal_flag <> hr_api.g_varchar2
1374: and p_personal_flag <> nvl(l_personal_flag,hr_api.g_varchar2)))
1375: and (p_contact_type = hr_api.g_varchar2
1376: or p_contact_type = l_contact_type)

Line 1373: or (p_personal_flag <> hr_api.g_varchar2

1369: or (p_end_life_reason_id <> hr_api.g_number
1370: and p_end_life_reason_id <> nvl(l_end_life_reason_id,hr_api.g_number))
1371: or (p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2
1372: and p_rltd_per_rsds_w_dsgntr_flag <> nvl(l_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2))
1373: or (p_personal_flag <> hr_api.g_varchar2
1374: and p_personal_flag <> nvl(l_personal_flag,hr_api.g_varchar2)))
1375: and (p_contact_type = hr_api.g_varchar2
1376: or p_contact_type = l_contact_type)
1377: then

Line 1374: and p_personal_flag <> nvl(l_personal_flag,hr_api.g_varchar2)))

1370: and p_end_life_reason_id <> nvl(l_end_life_reason_id,hr_api.g_number))
1371: or (p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2
1372: and p_rltd_per_rsds_w_dsgntr_flag <> nvl(l_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2))
1373: or (p_personal_flag <> hr_api.g_varchar2
1374: and p_personal_flag <> nvl(l_personal_flag,hr_api.g_varchar2)))
1375: and (p_contact_type = hr_api.g_varchar2
1376: or p_contact_type = l_contact_type)
1377: then
1378: --

Line 1375: and (p_contact_type = hr_api.g_varchar2

1371: or (p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2
1372: and p_rltd_per_rsds_w_dsgntr_flag <> nvl(l_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2))
1373: or (p_personal_flag <> hr_api.g_varchar2
1374: and p_personal_flag <> nvl(l_personal_flag,hr_api.g_varchar2)))
1375: and (p_contact_type = hr_api.g_varchar2
1376: or p_contact_type = l_contact_type)
1377: then
1378: --
1379: l_mirror_contact_type := per_contact_relationships_pkg.get_mirror_contact_type

Line 1408: if p_personal_flag <> hr_api.g_varchar2 then

1404: close check_mirror;
1405: end if;
1406: --
1407: -- start of code for bug 2678841
1408: if p_personal_flag <> hr_api.g_varchar2 then
1409: if p_contact_type=hr_api.g_varchar2 then
1410: if l_contact_type in ('P','C','S') and
1411: p_personal_flag <> 'Y' then
1412: hr_utility.set_message(800,'PER_6994_PERSONAL_FLAG');

Line 1409: if p_contact_type=hr_api.g_varchar2 then

1405: end if;
1406: --
1407: -- start of code for bug 2678841
1408: if p_personal_flag <> hr_api.g_varchar2 then
1409: if p_contact_type=hr_api.g_varchar2 then
1410: if l_contact_type in ('P','C','S') and
1411: p_personal_flag <> 'Y' then
1412: hr_utility.set_message(800,'PER_6994_PERSONAL_FLAG');
1413: hr_utility.raise_error;

Line 1427: if (p_date_start <> hr_api.g_date

1423: -- end of code for bug2678841
1424:
1425: -- 1766066: added call for contact start date enh.
1426: --
1427: if (p_date_start <> hr_api.g_date
1428: and p_date_start < l_date_start) then
1429: per_people12_pkg.maintain_coverage(p_person_id => l_contact_person_id
1430: ,p_type => 'CONT'
1431: );

Line 1501: when hr_api.cannot_find_prog_unit then

1497: ,p_cont_information20 => p_cont_information20
1498: ,p_object_version_number => p_object_version_number
1499: );
1500: exception
1501: when hr_api.cannot_find_prog_unit then
1502: hr_api.cannot_find_prog_unit_error
1503: (p_module_name => 'Update_contact_relationship'
1504: ,p_hook_type => 'AP'
1505: );

Line 1502: hr_api.cannot_find_prog_unit_error

1498: ,p_object_version_number => p_object_version_number
1499: );
1500: exception
1501: when hr_api.cannot_find_prog_unit then
1502: hr_api.cannot_find_prog_unit_error
1503: (p_module_name => 'Update_contact_relationship'
1504: ,p_hook_type => 'AP'
1505: );
1506: --

Line 1514: raise hr_api.validate_enabled;

1510: --
1511: -- When in validation only mode raise the Validate_Enabled exception
1512: --
1513: if p_validate then
1514: raise hr_api.validate_enabled;
1515: end if;
1516: --
1517: hr_utility.set_location(' Leaving:'||l_proc, 100);
1518: exception

Line 1519: when hr_api.validate_enabled then

1515: end if;
1516: --
1517: hr_utility.set_location(' Leaving:'||l_proc, 100);
1518: exception
1519: when hr_api.validate_enabled then
1520: --
1521: -- As the Validate_Enabled exception has been raised
1522: -- we must rollback to the savepoint
1523: --

Line 1629: when hr_api.cannot_find_prog_unit then

1625: (p_contact_relationship_id => p_contact_relationship_id
1626: ,p_object_version_number => p_object_version_number
1627: );
1628: exception
1629: when hr_api.cannot_find_prog_unit then
1630: hr_api.cannot_find_prog_unit_error
1631: (p_module_name => 'Delete_contact_relationship'
1632: ,p_hook_type => 'BP'
1633: );

Line 1630: hr_api.cannot_find_prog_unit_error

1626: ,p_object_version_number => p_object_version_number
1627: );
1628: exception
1629: when hr_api.cannot_find_prog_unit then
1630: hr_api.cannot_find_prog_unit_error
1631: (p_module_name => 'Delete_contact_relationship'
1632: ,p_hook_type => 'BP'
1633: );
1634: --

Line 1721: when hr_api.cannot_find_prog_unit then

1717: (p_contact_relationship_id => p_contact_relationship_id
1718: ,p_object_version_number => p_object_version_number
1719: );
1720: exception
1721: when hr_api.cannot_find_prog_unit then
1722: hr_api.cannot_find_prog_unit_error
1723: (p_module_name => 'Delete_contact_relationship'
1724: ,p_hook_type => 'AP'
1725: );

Line 1722: hr_api.cannot_find_prog_unit_error

1718: ,p_object_version_number => p_object_version_number
1719: );
1720: exception
1721: when hr_api.cannot_find_prog_unit then
1722: hr_api.cannot_find_prog_unit_error
1723: (p_module_name => 'Delete_contact_relationship'
1724: ,p_hook_type => 'AP'
1725: );
1726: --

Line 1734: raise hr_api.validate_enabled;

1730: --
1731: -- When in validation only mode raise the Validate_Enabled exception
1732: --
1733: if p_validate then
1734: raise hr_api.validate_enabled;
1735: end if;
1736: --
1737: hr_utility.set_location(' Leaving:'||l_proc, 100);
1738: exception

Line 1739: when hr_api.validate_enabled then

1735: end if;
1736: --
1737: hr_utility.set_location(' Leaving:'||l_proc, 100);
1738: exception
1739: when hr_api.validate_enabled then
1740: --
1741: -- As the Validate_Enabled exception has been raised
1742: -- we must rollback to the savepoint
1743: --