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 long default hr_api.g_varchar2
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 long default hr_api.g_varchar2

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 long default hr_api.g_varchar2
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 long default hr_api.g_varchar2
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 long default hr_api.g_varchar2
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 long default hr_api.g_varchar2
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 long default hr_api.g_varchar2
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_end_life_reason_id <> hr_api.g_number

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_end_life_reason_id <> hr_api.g_number
1369: and p_end_life_reason_id <> nvl(l_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_end_life_reason_id <> hr_api.g_number
1369: and p_end_life_reason_id <> nvl(l_end_life_reason_id,hr_api.g_number))
1370: or (p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2

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_end_life_reason_id <> hr_api.g_number
1369: and p_end_life_reason_id <> nvl(l_end_life_reason_id,hr_api.g_number))
1370: or (p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2
1371: and p_rltd_per_rsds_w_dsgntr_flag <> nvl(l_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2))

Line 1368: or (p_end_life_reason_id <> hr_api.g_number

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_end_life_reason_id <> hr_api.g_number
1369: and p_end_life_reason_id <> nvl(l_end_life_reason_id,hr_api.g_number))
1370: or (p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2
1371: and p_rltd_per_rsds_w_dsgntr_flag <> nvl(l_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2))
1372: or (p_personal_flag <> hr_api.g_varchar2

Line 1369: and p_end_life_reason_id <> nvl(l_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_end_life_reason_id <> hr_api.g_number
1369: and p_end_life_reason_id <> nvl(l_end_life_reason_id,hr_api.g_number))
1370: or (p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2
1371: and p_rltd_per_rsds_w_dsgntr_flag <> nvl(l_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2))
1372: or (p_personal_flag <> hr_api.g_varchar2
1373: and p_personal_flag <> nvl(l_personal_flag,hr_api.g_varchar2)))

Line 1370: or (p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2

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_end_life_reason_id <> hr_api.g_number
1369: and p_end_life_reason_id <> nvl(l_end_life_reason_id,hr_api.g_number))
1370: or (p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2
1371: and p_rltd_per_rsds_w_dsgntr_flag <> nvl(l_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2))
1372: or (p_personal_flag <> hr_api.g_varchar2
1373: and p_personal_flag <> nvl(l_personal_flag,hr_api.g_varchar2)))
1374: and (p_contact_type = hr_api.g_varchar2

Line 1371: and p_rltd_per_rsds_w_dsgntr_flag <> nvl(l_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_end_life_reason_id <> hr_api.g_number
1369: and p_end_life_reason_id <> nvl(l_end_life_reason_id,hr_api.g_number))
1370: or (p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2
1371: and p_rltd_per_rsds_w_dsgntr_flag <> nvl(l_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2))
1372: or (p_personal_flag <> hr_api.g_varchar2
1373: and p_personal_flag <> nvl(l_personal_flag,hr_api.g_varchar2)))
1374: and (p_contact_type = hr_api.g_varchar2
1375: or p_contact_type = l_contact_type)

Line 1372: or (p_personal_flag <> hr_api.g_varchar2

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

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

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

Line 1374: and (p_contact_type = hr_api.g_varchar2

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

Line 1407: if p_personal_flag <> hr_api.g_varchar2 then

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

Line 1408: if p_contact_type=hr_api.g_varchar2 then

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

Line 1426: if (p_date_start <> hr_api.g_date

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

Line 1500: when hr_api.cannot_find_prog_unit then

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

Line 1501: hr_api.cannot_find_prog_unit_error

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

Line 1513: raise hr_api.validate_enabled;

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

Line 1518: when hr_api.validate_enabled then

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

Line 1622: when hr_api.cannot_find_prog_unit then

1618: (p_contact_relationship_id => p_contact_relationship_id
1619: ,p_object_version_number => p_object_version_number
1620: );
1621: exception
1622: when hr_api.cannot_find_prog_unit then
1623: hr_api.cannot_find_prog_unit_error
1624: (p_module_name => 'Delete_contact_relationship'
1625: ,p_hook_type => 'BP'
1626: );

Line 1623: hr_api.cannot_find_prog_unit_error

1619: ,p_object_version_number => p_object_version_number
1620: );
1621: exception
1622: when hr_api.cannot_find_prog_unit then
1623: hr_api.cannot_find_prog_unit_error
1624: (p_module_name => 'Delete_contact_relationship'
1625: ,p_hook_type => 'BP'
1626: );
1627: --

Line 1714: when hr_api.cannot_find_prog_unit then

1710: (p_contact_relationship_id => p_contact_relationship_id
1711: ,p_object_version_number => p_object_version_number
1712: );
1713: exception
1714: when hr_api.cannot_find_prog_unit then
1715: hr_api.cannot_find_prog_unit_error
1716: (p_module_name => 'Delete_contact_relationship'
1717: ,p_hook_type => 'AP'
1718: );

Line 1715: hr_api.cannot_find_prog_unit_error

1711: ,p_object_version_number => p_object_version_number
1712: );
1713: exception
1714: when hr_api.cannot_find_prog_unit then
1715: hr_api.cannot_find_prog_unit_error
1716: (p_module_name => 'Delete_contact_relationship'
1717: ,p_hook_type => 'AP'
1718: );
1719: --

Line 1727: raise hr_api.validate_enabled;

1723: --
1724: -- When in validation only mode raise the Validate_Enabled exception
1725: --
1726: if p_validate then
1727: raise hr_api.validate_enabled;
1728: end if;
1729: --
1730: hr_utility.set_location(' Leaving:'||l_proc, 100);
1731: exception

Line 1732: when hr_api.validate_enabled then

1728: end if;
1729: --
1730: hr_utility.set_location(' Leaving:'||l_proc, 100);
1731: exception
1732: when hr_api.validate_enabled then
1733: --
1734: -- As the Validate_Enabled exception has been raised
1735: -- we must rollback to the savepoint
1736: --