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.

[Home] [Help]

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: 309


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_postal_code             in varchar2 default hr_api.g_varchar2,
  p_address                 in varchar2 default hr_api.g_varchar2,
  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_employee_number         in varchar2 default hr_api.g_varchar2,
  p_district_name           in varchar2 default hr_api.g_varchar2,
  p_sec_sal_submit_flag     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_INFORMATION8   => p_postal_code,
    P_ACTION_INFORMATION9   => p_address,
    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_ACTION_INFORMATION24  => p_employee_number,
    P_ACTION_INFORMATION25  => p_district_name,
    P_ACTION_INFORMATION26  => p_sec_sal_submit_flag,
    p_return_status         => p_return_status);

Line: 353


end update_emp;

Line: 363


	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: 439


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: 481


end update_entry;

Line: 491


	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: 564


	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: 633


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,
  p_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_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_action_information14  => p_address);

Line: 667


end update_dep;

Line: 669


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_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_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_action_information14  => p_address,
    p_return_status         => p_return_status);

Line: 705


end update_dep;

Line: 715


	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: 782


	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: 845


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,
  p_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_address,
    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: 879


end update_dep_oe;

Line: 881


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_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_address,
    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: 917


end update_dep_oe;

Line: 927


	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: 986


	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: 1041


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: 1063


end update_dep_os;

Line: 1065


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: 1089


end update_dep_os;

Line: 1097


  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_sec_sal_submit_flag      in varchar2 default null,
  p_sec_sal_submit_flag_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_ENTRY_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         => to_canonical(p_element_entry_id),
    p_action_information4         => to_canonical(p_ee_object_version_number),
    p_action_information5         => p_sec_sal_submit_flag,
    p_action_information6         => p_sec_sal_submit_flag_o,
    p_action_information_id       => p_action_information_id,
    p_object_version_number       => p_object_version_number);

Line: 1125


procedure update_entry_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_element_entry_id         in number default hr_api.g_number,
  p_ee_object_version_number in number default hr_api.g_number,
  p_sec_sal_submit_flag      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_information3   => to_canonical(p_element_entry_id),
    p_action_information4   => to_canonical(p_ee_object_version_number),
    p_action_information5   => p_sec_sal_submit_flag);

Line: 1145


end update_entry_os;

Line: 1173


procedure update_entry_dep(
  p_validate                 in boolean  default false,
  p_action_information_id    in number,
  p_object_version_number    in out nocopy number,
  p_num_junior_deps          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   => to_canonical(p_num_junior_deps));

Line: 1187


end update_entry_dep;