APPS.PAY_JP_DEF_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 79

procedure update_pact(
	P_VALIDATE			in number	default hr_api.g_false_num,
	P_ACTION_INFORMATION_ID		in number,
	P_OBJECT_VERSION_NUMBER		in out nocopy number,
	P_SUBMISSION_PERIOD_STATUS	in varchar2	default hr_api.g_varchar2,
	P_SUBMISSION_START_DATE		in date		default hr_api.g_date,
	P_SUBMISSION_END_DATE		in date		default hr_api.g_date,
	P_TAX_OFFICE_NAME		in varchar2	default hr_api.g_varchar2,
	P_SALARY_PAYER_NAME		in varchar2	default hr_api.g_varchar2,
	P_SALARY_PAYER_ADDRESS		in varchar2	default hr_api.g_varchar2,
	p_return_status			out nocopy varchar2)
is
	l_rec		pay_jp_def_pact_v%rowtype;

Line: 93

	pay_action_information_swi.update_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
		P_ACTION_INFORMATION3		=> P_SUBMISSION_PERIOD_STATUS,
		P_ACTION_INFORMATION4		=> to_canonical(P_SUBMISSION_START_DATE),
		P_ACTION_INFORMATION5		=> to_canonical(P_SUBMISSION_END_DATE),
		P_ACTION_INFORMATION6		=> P_TAX_OFFICE_NAME,
		P_ACTION_INFORMATION7		=> P_SALARY_PAYER_NAME,
		P_ACTION_INFORMATION8		=> P_SALARY_PAYER_ADDRESS,
		p_return_status			=> p_return_status);

Line: 104

end update_pact;

Line: 146

procedure update_assact(
	P_VALIDATE			in boolean	default false,
	P_ACTION_INFORMATION_ID		in number,
	P_OBJECT_VERSION_NUMBER		in out nocopy number,
	P_TRANSACTION_STATUS		in varchar2	default hr_api.g_varchar2,
	P_FINALIZED_DATE		in date		default hr_api.g_date,
	P_FINALIZED_BY			in number	default hr_api.g_number,
	P_USER_COMMENTS			in varchar2	default hr_api.g_varchar2,
	P_ADMIN_COMMENTS		in varchar2	default hr_api.g_varchar2,
	P_TRANSFER_STATUS		in varchar2	default hr_api.g_varchar2,
	P_EXPIRY_DATE			in date		default hr_api.g_date)
is
begin
	pay_action_information_api.update_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
		P_ACTION_INFORMATION2		=> P_TRANSACTION_STATUS,
		P_ACTION_INFORMATION3		=> to_canonical(P_FINALIZED_DATE),
		P_ACTION_INFORMATION4		=> to_canonical(P_FINALIZED_BY),
		P_ACTION_INFORMATION5		=> P_USER_COMMENTS,
		P_ACTION_INFORMATION6		=> P_ADMIN_COMMENTS,
		P_ACTION_INFORMATION7		=> P_TRANSFER_STATUS,
		P_ACTION_INFORMATION8		=> to_canonical(P_EXPIRY_DATE));

Line: 170

end update_assact;

Line: 178

procedure update_assact(
	P_VALIDATE			in number	default hr_api.g_false_num,
	P_ACTION_INFORMATION_ID		in number,
	P_OBJECT_VERSION_NUMBER		in out nocopy number,
	P_TRANSACTION_STATUS		in varchar2	default hr_api.g_varchar2,
	P_FINALIZED_DATE		in date		default hr_api.g_date,
	P_FINALIZED_BY			in number	default hr_api.g_number,
	P_USER_COMMENTS			in varchar2	default hr_api.g_varchar2,
	P_ADMIN_COMMENTS		in varchar2	default hr_api.g_varchar2,
	P_TRANSFER_STATUS		in varchar2	default hr_api.g_varchar2,
	P_EXPIRY_DATE			in date		default hr_api.g_date,
	p_return_status			out nocopy varchar2)
is
	l_api_updating		boolean;

Line: 207

	-- Currently, update operation against assact is not allowed
	-- except for "Save" case.
	--
	if l_transaction_status <> 'N' then
		fnd_message.set_encoded('This operation is not supported at the moment.');

Line: 217

	pay_action_information_swi.update_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
		P_ACTION_INFORMATION2		=> P_TRANSACTION_STATUS,
		P_ACTION_INFORMATION3		=> to_canonical(P_FINALIZED_DATE),
		P_ACTION_INFORMATION4		=> to_canonical(P_FINALIZED_BY),
		P_ACTION_INFORMATION5		=> P_USER_COMMENTS,
		P_ACTION_INFORMATION6		=> P_ADMIN_COMMENTS,
		P_ACTION_INFORMATION7		=> P_TRANSFER_STATUS,
		P_ACTION_INFORMATION8		=> to_canonical(P_EXPIRY_DATE),
		p_return_status			=> p_return_status);

Line: 229

end update_assact;

Line: 301

procedure update_emp(
	P_VALIDATE			in number	default hr_api.g_false_num,
	P_ACTION_INFORMATION_ID		in number,
	P_OBJECT_VERSION_NUMBER		in out nocopy number,
	P_CHANGE_DATE			in date		default hr_api.g_date,
	P_CHANGE_REASON			in varchar2	default hr_api.g_varchar2,
	P_DISABILITY_TYPE		in varchar2	default hr_api.g_varchar2,
	P_DISABILITY_DETAILS		in varchar2	default hr_api.g_varchar2,
	P_AGED_TYPE			in varchar2	default hr_api.g_varchar2,
	P_AGED_DETAILS			in varchar2	default hr_api.g_varchar2,
	P_WIDOW_TYPE			in varchar2	default hr_api.g_varchar2,
	P_WIDOW_DETAILS			in varchar2	default hr_api.g_varchar2,
	P_WORKING_STUDENT_TYPE		in varchar2	default hr_api.g_varchar2,
	P_WORKING_STUDENT_DETAILS	in varchar2	default hr_api.g_varchar2,
	p_return_status			out nocopy varchar2)
is
begin
	pay_action_information_swi.update_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
		P_ACTION_INFORMATION14		=> to_canonical(P_CHANGE_DATE),
		P_ACTION_INFORMATION15		=> P_CHANGE_REASON,
		P_ACTION_INFORMATION16		=> P_DISABILITY_TYPE,
		P_ACTION_INFORMATION17		=> P_DISABILITY_DETAILS,
		P_ACTION_INFORMATION18		=> P_AGED_TYPE,
		P_ACTION_INFORMATION19		=> P_AGED_DETAILS,
		P_ACTION_INFORMATION20		=> P_WIDOW_TYPE,
		P_ACTION_INFORMATION21		=> P_WIDOW_DETAILS,
		P_ACTION_INFORMATION22		=> P_WORKING_STUDENT_TYPE,
		P_ACTION_INFORMATION23		=> P_WORKING_STUDENT_DETAILS,
		p_return_status			=> p_return_status);

Line: 333

end update_emp;

Line: 343

	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
	P_ELEMENT_ENTRY_ID		in number	default null,
	P_EE_OBJECT_VERSION_NUMBER	in number	default null,
	P_DISABILITY_TYPE		in varchar2	default null,
	P_DISABILITY_TYPE_O		in varchar2	default null,
	P_AGED_TYPE			in varchar2	default null,
	P_AGED_TYPE_O			in varchar2	default null,
	P_WIDOW_TYPE			in varchar2	default null,
	P_WIDOW_TYPE_O			in varchar2	default null,
	P_WORKING_STUDENT_TYPE		in varchar2	default null,
	P_WORKING_STUDENT_TYPE_O	in varchar2	default null,
	P_SPOUSE_DEP_TYPE		in varchar2	default null,
	P_SPOUSE_DEP_TYPE_O		in varchar2	default null,
	P_SPOUSE_DISABILITY_TYPE	in varchar2	default null,
	P_SPOUSE_DISABILITY_TYPE_O	in varchar2	default null,
	P_NUM_DEPS			in number	default null,
	P_NUM_DEPS_O			in number	default null,
	P_NUM_AGEDS			in number	default null,
	P_NUM_AGEDS_O			in number	default null,
	P_NUM_AGED_PARENTS_LT		in number	default null,
	P_NUM_AGED_PARENTS_LT_O		in number	default null,
	P_NUM_SPECIFIEDS		in number	default null,
	P_NUM_SPECIFIEDS_O		in number	default null,
	P_NUM_DISABLEDS			in number	default null,
	P_NUM_DISABLEDS_O		in number	default null,
	P_NUM_SVR_DISABLEDS		in number	default null,
	P_NUM_SVR_DISABLEDS_O		in number	default null,
	P_NUM_SVR_DISABLEDS_LT		in number	default null,
	P_NUM_SVR_DISABLEDS_LT_O	in number	default null,
	P_ACTION_INFORMATION_ID		out nocopy number,
	P_OBJECT_VERSION_NUMBER		out nocopy number)
is
begin
	pay_action_information_api.create_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
		P_ACTION_CONTEXT_TYPE		=> 'AAP',
		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_ENTRY',
		P_EFFECTIVE_DATE		=> p_effective_date,
		P_ASSIGNMENT_ID			=> p_assignment_id,
		P_ACTION_INFORMATION1		=> P_STATUS,
		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
		P_ACTION_INFORMATION3		=> to_canonical(P_ELEMENT_ENTRY_ID),
		P_ACTION_INFORMATION4		=> to_canonical(P_EE_OBJECT_VERSION_NUMBER),
		P_ACTION_INFORMATION5		=> P_DISABILITY_TYPE,
		P_ACTION_INFORMATION6		=> P_DISABILITY_TYPE_O,
		P_ACTION_INFORMATION7		=> P_AGED_TYPE,
		P_ACTION_INFORMATION8		=> P_AGED_TYPE_O,
		P_ACTION_INFORMATION9		=> P_WIDOW_TYPE,
		P_ACTION_INFORMATION10		=> P_WIDOW_TYPE_O,
		P_ACTION_INFORMATION11		=> P_WORKING_STUDENT_TYPE,
		P_ACTION_INFORMATION12		=> P_WORKING_STUDENT_TYPE_O,
		P_ACTION_INFORMATION13		=> P_SPOUSE_DEP_TYPE,
		P_ACTION_INFORMATION14		=> P_SPOUSE_DEP_TYPE_O,
		P_ACTION_INFORMATION15		=> P_SPOUSE_DISABILITY_TYPE,
		P_ACTION_INFORMATION16		=> P_SPOUSE_DISABILITY_TYPE_O,
		P_ACTION_INFORMATION17		=> to_canonical(P_NUM_DEPS),
		P_ACTION_INFORMATION18		=> to_canonical(P_NUM_DEPS_O),
		P_ACTION_INFORMATION19		=> to_canonical(P_NUM_AGEDS),
		P_ACTION_INFORMATION20		=> to_canonical(P_NUM_AGEDS_O),
		P_ACTION_INFORMATION21		=> to_canonical(P_NUM_AGED_PARENTS_LT),
		P_ACTION_INFORMATION22		=> to_canonical(P_NUM_AGED_PARENTS_LT_O),
		P_ACTION_INFORMATION23		=> to_canonical(P_NUM_SPECIFIEDS),
		P_ACTION_INFORMATION24		=> to_canonical(P_NUM_SPECIFIEDS_O),
		P_ACTION_INFORMATION25		=> to_canonical(P_NUM_DISABLEDS),
		P_ACTION_INFORMATION26		=> to_canonical(P_NUM_DISABLEDS_O),
		P_ACTION_INFORMATION27		=> to_canonical(P_NUM_SVR_DISABLEDS),
		P_ACTION_INFORMATION28		=> to_canonical(P_NUM_SVR_DISABLEDS_O),
		P_ACTION_INFORMATION29		=> to_canonical(P_NUM_SVR_DISABLEDS_LT),
		P_ACTION_INFORMATION30		=> to_canonical(P_NUM_SVR_DISABLEDS_LT_O),
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number);

Line: 419

procedure update_entry(
	P_VALIDATE			in boolean	default false,
	P_ACTION_INFORMATION_ID		in number,
	P_OBJECT_VERSION_NUMBER		in out nocopy number,
	P_STATUS			in varchar2	default hr_api.g_varchar2,
	P_ELEMENT_ENTRY_ID		in number	default hr_api.g_number,
	P_EE_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
	P_DISABILITY_TYPE		in varchar2	default hr_api.g_varchar2,
	P_AGED_TYPE			in varchar2	default hr_api.g_varchar2,
	P_WIDOW_TYPE			in varchar2	default hr_api.g_varchar2,
	P_WORKING_STUDENT_TYPE		in varchar2	default hr_api.g_varchar2,
	P_SPOUSE_DEP_TYPE		in varchar2	default hr_api.g_varchar2,
	P_SPOUSE_DISABILITY_TYPE	in varchar2	default hr_api.g_varchar2,
	P_NUM_DEPS			in number	default hr_api.g_number,
	P_NUM_AGEDS			in number	default hr_api.g_number,
	P_NUM_AGED_PARENTS_LT		in number	default hr_api.g_number,
	P_NUM_SPECIFIEDS		in number	default hr_api.g_number,
	P_NUM_DISABLEDS			in number	default hr_api.g_number,
	P_NUM_SVR_DISABLEDS		in number	default hr_api.g_number,
	P_NUM_SVR_DISABLEDS_LT		in number	default hr_api.g_number)
is
begin
	pay_action_information_api.update_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
		P_ACTION_INFORMATION1		=> P_STATUS,
		P_ACTION_INFORMATION3		=> to_canonical(P_ELEMENT_ENTRY_ID),
		P_ACTION_INFORMATION4		=> to_canonical(P_EE_OBJECT_VERSION_NUMBER),
		P_ACTION_INFORMATION5		=> P_DISABILITY_TYPE,
		P_ACTION_INFORMATION7		=> P_AGED_TYPE,
		P_ACTION_INFORMATION9		=> P_WIDOW_TYPE,
		P_ACTION_INFORMATION11		=> P_WORKING_STUDENT_TYPE,
		P_ACTION_INFORMATION13		=> P_SPOUSE_DEP_TYPE,
		P_ACTION_INFORMATION15		=> P_SPOUSE_DISABILITY_TYPE,
		P_ACTION_INFORMATION17		=> to_canonical(P_NUM_DEPS),
		P_ACTION_INFORMATION19		=> to_canonical(P_NUM_AGEDS),
		P_ACTION_INFORMATION21		=> to_canonical(P_NUM_AGED_PARENTS_LT),
		P_ACTION_INFORMATION23		=> to_canonical(P_NUM_SPECIFIEDS),
		P_ACTION_INFORMATION25		=> to_canonical(P_NUM_DISABLEDS),
		P_ACTION_INFORMATION27		=> to_canonical(P_NUM_SVR_DISABLEDS),
		P_ACTION_INFORMATION29		=> to_canonical(P_NUM_SVR_DISABLEDS_LT));

Line: 461

end update_entry;

Line: 471

	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
	P_DATETRACK_DELETE_MODE		in varchar2	default null,
	P_CONTACT_EXTRA_INFO_ID		in number	default null,
	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
	P_CONTACT_RELATIONSHIP_ID	in number	default null,
	P_LAST_NAME_KANA		in varchar2	default null,
	P_FIRST_NAME_KANA		in varchar2	default null,
	P_LAST_NAME			in varchar2	default null,
	P_FIRST_NAME			in varchar2	default null,
	P_CONTACT_TYPE			in varchar2	default null,
	P_DATE_OF_BIRTH			in date		default null,
	P_DATE_OF_DEATH			in date		default null,
	P_ADDRESS			in varchar2	default null,
	P_CHANGE_DATE			in date		default null,
	P_CHANGE_REASON			in varchar2	default null,
	P_DEP_TYPE			in varchar2	default null,
	P_DEP_TYPE_O			in varchar2	default null,
	P_OCCUPATION			in varchar2	default null,
	P_OCCUPATION_O			in varchar2	default null,
	P_ESTIMATED_ANNUAL_INCOME	in number	default null,
	P_ESTIMATED_ANNUAL_INCOME_O	in number	default null,
	P_DISABILITY_TYPE		in varchar2	default null,
	P_DISABILITY_TYPE_O		in varchar2	default null,
	P_DISABILITY_DETAILS		in varchar2	default null,
	P_DISABILITY_DETAILS_O		in varchar2	default null,
	P_ACTION_INFORMATION_ID		out nocopy number,
	P_OBJECT_VERSION_NUMBER		out nocopy number)
is
begin
	pay_action_information_api.create_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
		P_ACTION_CONTEXT_TYPE		=> 'AAP',
		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP',
		P_EFFECTIVE_DATE		=> p_effective_date,
		P_ASSIGNMENT_ID			=> p_assignment_id,
		P_ACTION_INFORMATION1		=> P_STATUS,
		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
		P_ACTION_INFORMATION9		=> P_LAST_NAME,
		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
		P_ACTION_INFORMATION14		=> P_ADDRESS,
		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
		P_ACTION_INFORMATION17		=> P_DEP_TYPE,
		P_ACTION_INFORMATION18		=> P_DEP_TYPE_O,
		P_ACTION_INFORMATION19		=> P_OCCUPATION,
		P_ACTION_INFORMATION20		=> P_OCCUPATION_O,
		P_ACTION_INFORMATION21		=> to_canonical(P_ESTIMATED_ANNUAL_INCOME),
		P_ACTION_INFORMATION22		=> to_canonical(P_ESTIMATED_ANNUAL_INCOME_O),
		P_ACTION_INFORMATION23		=> P_DISABILITY_TYPE,
		P_ACTION_INFORMATION24		=> P_DISABILITY_TYPE_O,
		P_ACTION_INFORMATION25		=> P_DISABILITY_DETAILS,
		P_ACTION_INFORMATION26		=> P_DISABILITY_DETAILS_O,
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number);

Line: 544

	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
	P_DATETRACK_DELETE_MODE		in varchar2	default null,
	P_CONTACT_EXTRA_INFO_ID		in number	default null,
	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
	P_CONTACT_RELATIONSHIP_ID	in number	default null,
	P_LAST_NAME_KANA		in varchar2	default null,
	P_FIRST_NAME_KANA		in varchar2	default null,
	P_LAST_NAME			in varchar2	default null,
	P_FIRST_NAME			in varchar2	default null,
	P_CONTACT_TYPE			in varchar2	default null,
	P_DATE_OF_BIRTH			in date		default null,
	P_DATE_OF_DEATH			in date		default null,
	P_ADDRESS			in varchar2	default null,
	P_CHANGE_DATE			in date		default null,
	P_CHANGE_REASON			in varchar2	default null,
	P_DEP_TYPE			in varchar2	default null,
	P_DEP_TYPE_O			in varchar2	default null,
	P_OCCUPATION			in varchar2	default null,
	P_OCCUPATION_O			in varchar2	default null,
	P_ESTIMATED_ANNUAL_INCOME	in number	default null,
	P_ESTIMATED_ANNUAL_INCOME_O	in number	default null,
	P_DISABILITY_TYPE		in varchar2	default null,
	P_DISABILITY_TYPE_O		in varchar2	default null,
	P_DISABILITY_DETAILS		in varchar2	default null,
	P_DISABILITY_DETAILS_O		in varchar2	default null,
	P_OBJECT_VERSION_NUMBER		out nocopy number,
	p_return_status			out nocopy varchar2)
is
begin
	pay_action_information_swi.create_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
		P_ACTION_CONTEXT_TYPE		=> 'AAP',
		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP',
		P_EFFECTIVE_DATE		=> p_effective_date,
		P_ASSIGNMENT_ID			=> p_assignment_id,
		P_ACTION_INFORMATION1		=> P_STATUS,
		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
		P_ACTION_INFORMATION9		=> P_LAST_NAME,
		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
		P_ACTION_INFORMATION14		=> P_ADDRESS,
		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
		P_ACTION_INFORMATION17		=> P_DEP_TYPE,
		P_ACTION_INFORMATION18		=> P_DEP_TYPE_O,
		P_ACTION_INFORMATION19		=> P_OCCUPATION,
		P_ACTION_INFORMATION20		=> P_OCCUPATION_O,
		P_ACTION_INFORMATION21		=> to_canonical(P_ESTIMATED_ANNUAL_INCOME),
		P_ACTION_INFORMATION22		=> to_canonical(P_ESTIMATED_ANNUAL_INCOME_O),
		P_ACTION_INFORMATION23		=> P_DISABILITY_TYPE,
		P_ACTION_INFORMATION24		=> P_DISABILITY_TYPE_O,
		P_ACTION_INFORMATION25		=> P_DISABILITY_DETAILS,
		P_ACTION_INFORMATION26		=> P_DISABILITY_DETAILS_O,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
		p_return_status			=> p_return_status);

Line: 613

procedure update_dep(
	P_VALIDATE			in boolean	default false,
	P_ACTION_INFORMATION_ID		in number,
	P_OBJECT_VERSION_NUMBER		in out nocopy number,
	P_STATUS			in varchar2	default hr_api.g_varchar2,
	P_CONTACT_EXTRA_INFO_ID		in number	default hr_api.g_number,
	P_CEI_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
	P_CHANGE_DATE			in date		default hr_api.g_date,
	P_CHANGE_REASON			in varchar2	default hr_api.g_varchar2,
	P_DEP_TYPE			in varchar2	default hr_api.g_varchar2,
	P_OCCUPATION			in varchar2	default hr_api.g_varchar2,
	P_ESTIMATED_ANNUAL_INCOME	in number	default hr_api.g_number,
	P_DISABILITY_TYPE		in varchar2	default hr_api.g_varchar2,
	P_DISABILITY_DETAILS		in varchar2	default hr_api.g_varchar2)
is
begin
	pay_action_information_api.update_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
		P_ACTION_INFORMATION1		=> P_STATUS,
		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
		P_ACTION_INFORMATION17		=> P_DEP_TYPE,
		P_ACTION_INFORMATION19		=> P_OCCUPATION,
		P_ACTION_INFORMATION21		=> to_canonical(P_ESTIMATED_ANNUAL_INCOME),
		P_ACTION_INFORMATION23		=> P_DISABILITY_TYPE,
		P_ACTION_INFORMATION25		=> P_DISABILITY_DETAILS);

Line: 643

end update_dep;

Line: 645

procedure update_dep(
	P_VALIDATE			in number	default hr_api.g_false_num,
	P_ACTION_INFORMATION_ID		in number,
	P_OBJECT_VERSION_NUMBER		in out nocopy number,
	P_STATUS			in varchar2	default hr_api.g_varchar2,
	P_CONTACT_EXTRA_INFO_ID		in number	default hr_api.g_number,
	P_CEI_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
	P_CHANGE_DATE			in date		default hr_api.g_date,
	P_CHANGE_REASON			in varchar2	default hr_api.g_varchar2,
	P_DEP_TYPE			in varchar2	default hr_api.g_varchar2,
	P_OCCUPATION			in varchar2	default hr_api.g_varchar2,
	P_ESTIMATED_ANNUAL_INCOME	in number	default hr_api.g_number,
	P_DISABILITY_TYPE		in varchar2	default hr_api.g_varchar2,
	P_DISABILITY_DETAILS		in varchar2	default hr_api.g_varchar2,
	p_return_status			out nocopy varchar2)
is
begin
	pay_action_information_swi.update_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
		P_ACTION_INFORMATION1		=> P_STATUS,
		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
		P_ACTION_INFORMATION17		=> P_DEP_TYPE,
		P_ACTION_INFORMATION19		=> P_OCCUPATION,
		P_ACTION_INFORMATION21		=> to_canonical(P_ESTIMATED_ANNUAL_INCOME),
		P_ACTION_INFORMATION23		=> P_DISABILITY_TYPE,
		P_ACTION_INFORMATION25		=> P_DISABILITY_DETAILS,
		p_return_status			=> p_return_status);

Line: 677

end update_dep;

Line: 687

	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
	P_DATETRACK_DELETE_MODE		in varchar2	default null,
	P_CONTACT_EXTRA_INFO_ID		in number	default null,
	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
	P_CONTACT_RELATIONSHIP_ID	in number	default null,
	P_LAST_NAME_KANA		in varchar2	default null,
	P_FIRST_NAME_KANA		in varchar2	default null,
	P_LAST_NAME			in varchar2	default null,
	P_FIRST_NAME			in varchar2	default null,
	P_CONTACT_TYPE			in varchar2	default null,
	P_DATE_OF_BIRTH			in date		default null,
	P_DATE_OF_DEATH			in date		default null,
	P_ADDRESS			in varchar2	default null,
	P_CHANGE_DATE			in date		default null,
	P_CHANGE_REASON			in varchar2	default null,
	P_OCCUPATION			in varchar2	default null,
	P_OCCUPATION_O			in varchar2	default null,
	P_OE_CONTACT_RELATIONSHIP_ID	in number	default null,
	P_OE_FULL_NAME			in varchar2	default null,
	P_OE_CONTACT_TYPE		in varchar2	default null,
	P_OE_ADDRESS			in varchar2	default null,
	P_OE_CONTACT_RELATIONSHIP_ID_O	in number	default null,
	P_ACTION_INFORMATION_ID		out nocopy number,
	P_OBJECT_VERSION_NUMBER		out nocopy number)
is
begin
	pay_action_information_api.create_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
		P_ACTION_CONTEXT_TYPE		=> 'AAP',
		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP_OE',
		P_EFFECTIVE_DATE		=> p_effective_date,
		P_ASSIGNMENT_ID			=> p_assignment_id,
		P_ACTION_INFORMATION1		=> P_STATUS,
		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
		P_ACTION_INFORMATION9		=> P_LAST_NAME,
		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
		P_ACTION_INFORMATION14		=> P_ADDRESS,
		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
		P_ACTION_INFORMATION17		=> P_OCCUPATION,
		P_ACTION_INFORMATION18		=> P_OCCUPATION_O,
		P_ACTION_INFORMATION19		=> to_canonical(P_OE_CONTACT_RELATIONSHIP_ID),
		P_ACTION_INFORMATION20		=> P_OE_FULL_NAME,
		P_ACTION_INFORMATION21		=> P_OE_CONTACT_TYPE,
		P_ACTION_INFORMATION22		=> P_OE_ADDRESS,
		P_ACTION_INFORMATION23		=> to_canonical(P_OE_CONTACT_RELATIONSHIP_ID_O),
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number);

Line: 754

	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
	P_DATETRACK_DELETE_MODE		in varchar2	default null,
	P_CONTACT_EXTRA_INFO_ID		in number	default null,
	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
	P_CONTACT_RELATIONSHIP_ID	in number	default null,
	P_LAST_NAME_KANA		in varchar2	default null,
	P_FIRST_NAME_KANA		in varchar2	default null,
	P_LAST_NAME			in varchar2	default null,
	P_FIRST_NAME			in varchar2	default null,
	P_CONTACT_TYPE			in varchar2	default null,
	P_DATE_OF_BIRTH			in date		default null,
	P_DATE_OF_DEATH			in date		default null,
	P_ADDRESS			in varchar2	default null,
	P_CHANGE_DATE			in date		default null,
	P_CHANGE_REASON			in varchar2	default null,
	P_OCCUPATION			in varchar2	default null,
	P_OCCUPATION_O			in varchar2	default null,
	P_OE_CONTACT_RELATIONSHIP_ID	in number	default null,
	P_OE_FULL_NAME			in varchar2	default null,
	P_OE_CONTACT_TYPE		in varchar2	default null,
	P_OE_ADDRESS			in varchar2	default null,
	P_OE_CONTACT_RELATIONSHIP_ID_O	in number	default null,
	P_OBJECT_VERSION_NUMBER		out nocopy number,
	p_return_status			out nocopy varchar2)
is
begin
	pay_action_information_swi.create_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
		P_ACTION_CONTEXT_TYPE		=> 'AAP',
		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP_OE',
		P_EFFECTIVE_DATE		=> p_effective_date,
		P_ASSIGNMENT_ID			=> p_assignment_id,
		P_ACTION_INFORMATION1		=> P_STATUS,
		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
		P_ACTION_INFORMATION9		=> P_LAST_NAME,
		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
		P_ACTION_INFORMATION14		=> P_ADDRESS,
		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
		P_ACTION_INFORMATION17		=> P_OCCUPATION,
		P_ACTION_INFORMATION18		=> P_OCCUPATION_O,
		P_ACTION_INFORMATION19		=> to_canonical(P_OE_CONTACT_RELATIONSHIP_ID),
		P_ACTION_INFORMATION20		=> P_OE_FULL_NAME,
		P_ACTION_INFORMATION21		=> P_OE_CONTACT_TYPE,
		P_ACTION_INFORMATION22		=> P_OE_ADDRESS,
		P_ACTION_INFORMATION23		=> to_canonical(P_OE_CONTACT_RELATIONSHIP_ID_O),
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
		p_return_status			=> p_return_status);

Line: 817

procedure update_dep_oe(
	P_VALIDATE			in boolean	default false,
	P_ACTION_INFORMATION_ID		in number,
	P_OBJECT_VERSION_NUMBER		in out nocopy number,
	P_STATUS			in varchar2	default hr_api.g_varchar2,
	P_CONTACT_EXTRA_INFO_ID		in number	default hr_api.g_number,
	P_CEI_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
	P_CHANGE_DATE			in date		default hr_api.g_date,
	P_CHANGE_REASON			in varchar2	default hr_api.g_varchar2,
	P_OCCUPATION			in varchar2	default hr_api.g_varchar2,
	P_OE_CONTACT_RELATIONSHIP_ID	in number	default hr_api.g_number,
	P_OE_FULL_NAME			in varchar2	default hr_api.g_varchar2,
	P_OE_CONTACT_TYPE		in varchar2	default hr_api.g_varchar2,
	P_OE_ADDRESS			in varchar2	default hr_api.g_varchar2)
is
begin
	pay_action_information_api.update_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
		P_ACTION_INFORMATION1		=> P_STATUS,
		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
		P_ACTION_INFORMATION17		=> P_OCCUPATION,
		P_ACTION_INFORMATION19		=> to_canonical(P_OE_CONTACT_RELATIONSHIP_ID),
		P_ACTION_INFORMATION20		=> P_OE_FULL_NAME,
		P_ACTION_INFORMATION21		=> P_OE_CONTACT_TYPE,
		P_ACTION_INFORMATION22		=> P_OE_ADDRESS);

Line: 847

end update_dep_oe;

Line: 849

procedure update_dep_oe(
	P_VALIDATE			in number	default hr_api.g_false_num,
	P_ACTION_INFORMATION_ID		in number,
	P_OBJECT_VERSION_NUMBER		in out nocopy number,
	P_STATUS			in varchar2	default hr_api.g_varchar2,
	P_CONTACT_EXTRA_INFO_ID		in number	default hr_api.g_number,
	P_CEI_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
	P_CHANGE_DATE			in date		default hr_api.g_date,
	P_CHANGE_REASON			in varchar2	default hr_api.g_varchar2,
	P_OCCUPATION			in varchar2	default hr_api.g_varchar2,
	P_OE_CONTACT_RELATIONSHIP_ID	in number	default hr_api.g_number,
	P_OE_FULL_NAME			in varchar2	default hr_api.g_varchar2,
	P_OE_CONTACT_TYPE		in varchar2	default hr_api.g_varchar2,
	P_OE_ADDRESS			in varchar2	default hr_api.g_varchar2,
	p_return_status			out nocopy varchar2)
is
begin
	pay_action_information_swi.update_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
		P_ACTION_INFORMATION1		=> P_STATUS,
		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
		P_ACTION_INFORMATION15		=> to_canonical(P_CHANGE_DATE),
		P_ACTION_INFORMATION16		=> P_CHANGE_REASON,
		P_ACTION_INFORMATION17		=> P_OCCUPATION,
		P_ACTION_INFORMATION19		=> to_canonical(P_OE_CONTACT_RELATIONSHIP_ID),
		P_ACTION_INFORMATION20		=> P_OE_FULL_NAME,
		P_ACTION_INFORMATION21		=> P_OE_CONTACT_TYPE,
		P_ACTION_INFORMATION22		=> P_OE_ADDRESS,
		p_return_status			=> p_return_status);

Line: 881

end update_dep_oe;

Line: 891

	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
	P_DATETRACK_DELETE_MODE		in varchar2	default null,
	P_CONTACT_EXTRA_INFO_ID		in number	default null,
	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
	P_CONTACT_RELATIONSHIP_ID	in number	default null,
	P_LAST_NAME_KANA		in varchar2	default null,
	P_FIRST_NAME_KANA		in varchar2	default null,
	P_LAST_NAME			in varchar2	default null,
	P_FIRST_NAME			in varchar2	default null,
	P_CONTACT_TYPE			in varchar2	default null,
	P_DATE_OF_BIRTH			in date		default null,
	P_DATE_OF_DEATH			in date		default null,
	P_OCCUPATION			in varchar2	default null,
	P_OCCUPATION_O			in varchar2	default null,
	P_OS_SALARY_PAYER_NAME		in varchar2	default null,
	P_OS_SALARY_PAYER_NAME_O	in varchar2	default null,
	P_OS_SALARY_PAYER_ADDRESS	in varchar2	default null,
	P_OS_SALARY_PAYER_ADDRESS_O	in varchar2	default null,
	P_ACTION_INFORMATION_ID		out nocopy number,
	P_OBJECT_VERSION_NUMBER		out nocopy number)
is
begin
	pay_action_information_api.create_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
		P_ACTION_CONTEXT_TYPE		=> 'AAP',
		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP_OS',
		P_EFFECTIVE_DATE		=> p_effective_date,
		P_ASSIGNMENT_ID			=> p_assignment_id,
		P_ACTION_INFORMATION1		=> P_STATUS,
		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
		P_ACTION_INFORMATION9		=> P_LAST_NAME,
		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
		P_ACTION_INFORMATION14		=> P_OCCUPATION,
		P_ACTION_INFORMATION15		=> P_OCCUPATION_O,
		P_ACTION_INFORMATION16		=> P_OS_SALARY_PAYER_NAME,
		P_ACTION_INFORMATION17		=> P_OS_SALARY_PAYER_NAME_O,
		P_ACTION_INFORMATION18		=> P_OS_SALARY_PAYER_ADDRESS,
		P_ACTION_INFORMATION19		=> P_OS_SALARY_PAYER_ADDRESS_O,
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number);

Line: 950

	P_DATETRACK_UPDATE_MODE		in varchar2	default null,
	P_DATETRACK_DELETE_MODE		in varchar2	default null,
	P_CONTACT_EXTRA_INFO_ID		in number	default null,
	P_CEI_OBJECT_VERSION_NUMBER	in number	default null,
	P_CONTACT_RELATIONSHIP_ID	in number	default null,
	P_LAST_NAME_KANA		in varchar2	default null,
	P_FIRST_NAME_KANA		in varchar2	default null,
	P_LAST_NAME			in varchar2	default null,
	P_FIRST_NAME			in varchar2	default null,
	P_CONTACT_TYPE			in varchar2	default null,
	P_DATE_OF_BIRTH			in date		default null,
	P_DATE_OF_DEATH			in date		default null,
	P_OCCUPATION			in varchar2	default null,
	P_OCCUPATION_O			in varchar2	default null,
	P_OS_SALARY_PAYER_NAME		in varchar2	default null,
	P_OS_SALARY_PAYER_NAME_O	in varchar2	default null,
	P_OS_SALARY_PAYER_ADDRESS	in varchar2	default null,
	P_OS_SALARY_PAYER_ADDRESS_O	in varchar2	default null,
	P_OBJECT_VERSION_NUMBER		out nocopy number,
	p_return_status			out nocopy varchar2)
is
begin
	pay_action_information_swi.create_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_ACTION_CONTEXT_ID		=> p_assignment_action_id,
		P_ACTION_CONTEXT_TYPE		=> 'AAP',
		P_ACTION_INFORMATION_CATEGORY	=> 'JP_DEF_DEP_OS',
		P_EFFECTIVE_DATE		=> p_effective_date,
		P_ASSIGNMENT_ID			=> p_assignment_id,
		P_ACTION_INFORMATION1		=> P_STATUS,
		P_ACTION_INFORMATION2		=> P_DATETRACK_UPDATE_MODE,
		P_ACTION_INFORMATION3		=> P_DATETRACK_DELETE_MODE,
		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
		P_ACTION_INFORMATION6		=> to_canonical(P_CONTACT_RELATIONSHIP_ID),
		P_ACTION_INFORMATION7		=> P_LAST_NAME_KANA,
		P_ACTION_INFORMATION8		=> P_FIRST_NAME_KANA,
		P_ACTION_INFORMATION9		=> P_LAST_NAME,
		P_ACTION_INFORMATION10		=> P_FIRST_NAME,
		P_ACTION_INFORMATION11		=> P_CONTACT_TYPE,
		P_ACTION_INFORMATION12		=> to_canonical(P_DATE_OF_BIRTH),
		P_ACTION_INFORMATION13		=> to_canonical(P_DATE_OF_DEATH),
		P_ACTION_INFORMATION14		=> P_OCCUPATION,
		P_ACTION_INFORMATION15		=> P_OCCUPATION_O,
		P_ACTION_INFORMATION16		=> P_OS_SALARY_PAYER_NAME,
		P_ACTION_INFORMATION17		=> P_OS_SALARY_PAYER_NAME_O,
		P_ACTION_INFORMATION18		=> P_OS_SALARY_PAYER_ADDRESS,
		P_ACTION_INFORMATION19		=> P_OS_SALARY_PAYER_ADDRESS_O,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
		p_return_status			=> p_return_status);

Line: 1005

procedure update_dep_os(
	P_VALIDATE			in boolean	default false,
	P_ACTION_INFORMATION_ID		in number,
	P_OBJECT_VERSION_NUMBER		in out nocopy number,
	P_STATUS			in varchar2	default hr_api.g_varchar2,
	P_CONTACT_EXTRA_INFO_ID		in number	default hr_api.g_number,
	P_CEI_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
	P_OCCUPATION			in varchar2	default hr_api.g_varchar2,
	P_OS_SALARY_PAYER_NAME		in varchar2	default hr_api.g_varchar2,
	P_OS_SALARY_PAYER_ADDRESS	in varchar2	default hr_api.g_varchar2)
is
begin
	pay_action_information_api.update_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
		P_ACTION_INFORMATION1		=> P_STATUS,
		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
		P_ACTION_INFORMATION14		=> P_OCCUPATION,
		P_ACTION_INFORMATION16		=> P_OS_SALARY_PAYER_NAME,
		P_ACTION_INFORMATION18		=> P_OS_SALARY_PAYER_ADDRESS);

Line: 1027

end update_dep_os;

Line: 1029

procedure update_dep_os(
	P_VALIDATE			in number	default hr_api.g_false_num,
	P_ACTION_INFORMATION_ID		in number,
	P_OBJECT_VERSION_NUMBER		in out nocopy number,
	P_STATUS			in varchar2	default hr_api.g_varchar2,
	P_CONTACT_EXTRA_INFO_ID		in number	default hr_api.g_number,
	P_CEI_OBJECT_VERSION_NUMBER	in number	default hr_api.g_number,
	P_OCCUPATION			in varchar2	default hr_api.g_varchar2,
	P_OS_SALARY_PAYER_NAME		in varchar2	default hr_api.g_varchar2,
	P_OS_SALARY_PAYER_ADDRESS	in varchar2	default hr_api.g_varchar2,
	p_return_status			out nocopy varchar2)
is
begin
	pay_action_information_swi.update_action_information(
		P_VALIDATE			=> P_VALIDATE,
		P_ACTION_INFORMATION_ID		=> p_action_information_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
		P_ACTION_INFORMATION1		=> P_STATUS,
		P_ACTION_INFORMATION4		=> to_canonical(P_CONTACT_EXTRA_INFO_ID),
		P_ACTION_INFORMATION5		=> to_canonical(P_CEI_OBJECT_VERSION_NUMBER),
		P_ACTION_INFORMATION14		=> P_OCCUPATION,
		P_ACTION_INFORMATION16		=> P_OS_SALARY_PAYER_NAME,
		P_ACTION_INFORMATION18		=> P_OS_SALARY_PAYER_ADDRESS,
		p_return_status			=> p_return_status);

Line: 1053

end update_dep_os;