The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_program_update_date in date default null,
p_date_start in date default null,
p_start_life_reason_id in number default null,
p_date_end in date default null,
p_end_life_reason_id in number default null,
p_rltd_per_rsds_w_dsgntr_flag in varchar2 default 'N',
p_personal_flag in varchar2 default 'N',
p_sequence_number in number default null,
p_cont_attribute_category in varchar2 default null,
p_cont_attribute1 in varchar2 default null,
p_cont_attribute2 in varchar2 default null,
p_cont_attribute3 in varchar2 default null,
p_cont_attribute4 in varchar2 default null,
p_cont_attribute5 in varchar2 default null,
p_cont_attribute6 in varchar2 default null,
p_cont_attribute7 in varchar2 default null,
p_cont_attribute8 in varchar2 default null,
p_cont_attribute9 in varchar2 default null,
p_cont_attribute10 in varchar2 default null,
p_cont_attribute11 in varchar2 default null,
p_cont_attribute12 in varchar2 default null,
p_cont_attribute13 in varchar2 default null,
p_cont_attribute14 in varchar2 default null,
p_cont_attribute15 in varchar2 default null,
p_cont_attribute16 in varchar2 default null,
p_cont_attribute17 in varchar2 default null,
p_cont_attribute18 in varchar2 default null,
p_cont_attribute19 in varchar2 default null,
p_cont_attribute20 in varchar2 default null,
p_cont_information_category in varchar2 default null,
p_cont_information1 in varchar2 default null,
p_cont_information2 in varchar2 default null,
p_cont_information3 in varchar2 default null,
p_cont_information4 in varchar2 default null,
p_cont_information5 in varchar2 default null,
p_cont_information6 in varchar2 default null,
p_cont_information7 in varchar2 default null,
p_cont_information8 in varchar2 default null,
p_cont_information9 in varchar2 default null,
p_cont_information10 in varchar2 default null,
p_cont_information11 in varchar2 default null,
p_cont_information12 in varchar2 default null,
p_cont_information13 in varchar2 default null,
p_cont_information14 in varchar2 default null,
p_cont_information15 in varchar2 default null,
p_cont_information16 in varchar2 default null,
p_cont_information17 in varchar2 default null,
p_cont_information18 in varchar2 default null,
p_cont_information19 in varchar2 default null,
p_cont_information20 in varchar2 default null,
p_third_party_pay_flag in varchar2 default 'N',
p_bondholder_flag in varchar2 default 'N',
p_dependent_flag in varchar2 default 'N',
p_beneficiary_flag in varchar2 default 'N',
p_object_version_number out nocopy number,
p_effective_date in date default null,
p_validate in number default hr_api.g_false_num,
p_return_status out nocopy varchar2
) as
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'insert';
p_program_update_date in date default hr_api.g_date,
p_date_start in date default hr_api.g_date,
p_start_life_reason_id in number default hr_api.g_number,
p_date_end in date default hr_api.g_date,
p_end_life_reason_id in number default hr_api.g_number,
p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
p_personal_flag in varchar2 default hr_api.g_varchar2,
p_sequence_number in number default hr_api.g_number,
p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
p_cont_information_category in varchar2 default hr_api.g_varchar2,
p_cont_information1 in varchar2 default hr_api.g_varchar2,
p_cont_information2 in varchar2 default hr_api.g_varchar2,
p_cont_information3 in varchar2 default hr_api.g_varchar2,
p_cont_information4 in varchar2 default hr_api.g_varchar2,
p_cont_information5 in varchar2 default hr_api.g_varchar2,
p_cont_information6 in varchar2 default hr_api.g_varchar2,
p_cont_information7 in varchar2 default hr_api.g_varchar2,
p_cont_information8 in varchar2 default hr_api.g_varchar2,
p_cont_information9 in varchar2 default hr_api.g_varchar2,
p_cont_information10 in varchar2 default hr_api.g_varchar2,
p_cont_information11 in varchar2 default hr_api.g_varchar2,
p_cont_information12 in varchar2 default hr_api.g_varchar2,
p_cont_information13 in varchar2 default hr_api.g_varchar2,
p_cont_information14 in varchar2 default hr_api.g_varchar2,
p_cont_information15 in varchar2 default hr_api.g_varchar2,
p_cont_information16 in varchar2 default hr_api.g_varchar2,
p_cont_information17 in varchar2 default hr_api.g_varchar2,
p_cont_information18 in varchar2 default hr_api.g_varchar2,
p_cont_information19 in varchar2 default hr_api.g_varchar2,
p_cont_information20 in varchar2 default hr_api.g_varchar2,
p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
p_bondholder_flag in varchar2 default hr_api.g_varchar2,
p_dependent_flag in varchar2 default hr_api.g_varchar2,
p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
p_object_version_number in out nocopy number,
p_effective_date in date,
p_validate in number default hr_api.g_false_num,
p_return_status out nocopy varchar2
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
hr_contact_rel_api.update_contact_relationship(
P_CONTACT_RELATIONSHIP_ID => P_CONTACT_RELATIONSHIP_ID,
P_CONTACT_TYPE => P_CONTACT_TYPE,
P_COMMENTS => P_COMMENTS,
P_PRIMARY_CONTACT_FLAG => P_PRIMARY_CONTACT_FLAG,
P_DATE_START => P_DATE_START,
P_START_LIFE_REASON_ID => P_START_LIFE_REASON_ID,
P_DATE_END => P_DATE_END,
P_END_LIFE_REASON_ID => P_END_LIFE_REASON_ID,
P_RLTD_PER_RSDS_W_DSGNTR_FLAG => P_RLTD_PER_RSDS_W_DSGNTR_FLAG,
P_PERSONAL_FLAG => P_PERSONAL_FLAG,
P_SEQUENCE_NUMBER => P_SEQUENCE_NUMBER,
P_CONT_ATTRIBUTE_CATEGORY => P_CONT_ATTRIBUTE_CATEGORY,
P_CONT_ATTRIBUTE1 => P_CONT_ATTRIBUTE1,
P_CONT_ATTRIBUTE2 => P_CONT_ATTRIBUTE2,
P_CONT_ATTRIBUTE3 => P_CONT_ATTRIBUTE3,
P_CONT_ATTRIBUTE4 => P_CONT_ATTRIBUTE4,
P_CONT_ATTRIBUTE5 => P_CONT_ATTRIBUTE5,
P_CONT_ATTRIBUTE6 => P_CONT_ATTRIBUTE6,
P_CONT_ATTRIBUTE7 => P_CONT_ATTRIBUTE7,
P_CONT_ATTRIBUTE8 => P_CONT_ATTRIBUTE8,
P_CONT_ATTRIBUTE9 => P_CONT_ATTRIBUTE9,
P_CONT_ATTRIBUTE10 => P_CONT_ATTRIBUTE10,
P_CONT_ATTRIBUTE11 => P_CONT_ATTRIBUTE11,
P_CONT_ATTRIBUTE12 => P_CONT_ATTRIBUTE12,
P_CONT_ATTRIBUTE13 => P_CONT_ATTRIBUTE13,
P_CONT_ATTRIBUTE14 => P_CONT_ATTRIBUTE14,
P_CONT_ATTRIBUTE15 => P_CONT_ATTRIBUTE15,
P_CONT_ATTRIBUTE16 => P_CONT_ATTRIBUTE16,
P_CONT_ATTRIBUTE17 => P_CONT_ATTRIBUTE17,
P_CONT_ATTRIBUTE18 => P_CONT_ATTRIBUTE18,
P_CONT_ATTRIBUTE19 => P_CONT_ATTRIBUTE19,
P_CONT_ATTRIBUTE20 => P_CONT_ATTRIBUTE20,
P_CONT_INFORMATION_CATEGORY => P_CONT_INFORMATION_CATEGORY,
P_CONT_INFORMATION1 => P_CONT_INFORMATION1,
P_CONT_INFORMATION2 => P_CONT_INFORMATION2,
P_CONT_INFORMATION3 => P_CONT_INFORMATION3,
P_CONT_INFORMATION4 => P_CONT_INFORMATION4,
P_CONT_INFORMATION5 => P_CONT_INFORMATION5,
P_CONT_INFORMATION6 => P_CONT_INFORMATION6,
P_CONT_INFORMATION7 => P_CONT_INFORMATION7,
P_CONT_INFORMATION8 => P_CONT_INFORMATION8,
P_CONT_INFORMATION9 => P_CONT_INFORMATION9,
P_CONT_INFORMATION10 => P_CONT_INFORMATION10,
P_CONT_INFORMATION11 => P_CONT_INFORMATION11,
P_CONT_INFORMATION12 => P_CONT_INFORMATION12,
P_CONT_INFORMATION13 => P_CONT_INFORMATION13,
P_CONT_INFORMATION14 => P_CONT_INFORMATION14,
P_CONT_INFORMATION15 => P_CONT_INFORMATION15,
P_CONT_INFORMATION16 => P_CONT_INFORMATION16,
P_CONT_INFORMATION17 => P_CONT_INFORMATION17,
P_CONT_INFORMATION18 => P_CONT_INFORMATION18,
P_CONT_INFORMATION19 => P_CONT_INFORMATION19,
P_CONT_INFORMATION20 => P_CONT_INFORMATION20,
P_THIRD_PARTY_PAY_FLAG => P_THIRD_PARTY_PAY_FLAG,
P_BONDHOLDER_FLAG => P_BONDHOLDER_FLAG,
P_DEPENDENT_FLAG => P_DEPENDENT_FLAG,
P_BENEFICIARY_FLAG => P_BENEFICIARY_FLAG,
P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
P_EFFECTIVE_DATE => P_EFFECTIVE_DATE,
P_VALIDATE => l_validate
);
hr_contact_rel_api.delete_contact_relationship(
P_CONTACT_RELATIONSHIP_ID => P_CONTACT_RELATIONSHIP_ID,
P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
P_VALIDATE => l_validate
);
rollback to delete_questionnaire_swi;