13: function to_canonical(p_number in number) return varchar2
14: is
15: begin
16: if p_number is not null then
17: if p_number = hr_api.g_number then
18: return hr_api.g_varchar2;
19: else
20: return fnd_number.number_to_canonical(p_number);
21: end if;
14: is
15: begin
16: if p_number is not null then
17: if p_number = hr_api.g_number then
18: return hr_api.g_varchar2;
19: else
20: return fnd_number.number_to_canonical(p_number);
21: end if;
22: end if;
27: function to_canonical(p_date in date) return varchar2
28: is
29: begin
30: if p_date is not null then
31: if p_date = hr_api.g_date then
32: return hr_api.g_varchar2;
33: else
34: return fnd_date.date_to_canonical(p_date);
35: end if;
28: is
29: begin
30: if p_date is not null then
31: if p_date = hr_api.g_date then
32: return hr_api.g_varchar2;
33: else
34: return fnd_date.date_to_canonical(p_date);
35: end if;
36: end if;
76: -- |---------------------------------------------------------------------------|
77: -- |------------------------------< update_pact >------------------------------|
78: -- |---------------------------------------------------------------------------|
79: procedure update_pact(
80: P_VALIDATE in number default hr_api.g_false_num,
81: P_ACTION_INFORMATION_ID in number,
82: P_OBJECT_VERSION_NUMBER in out nocopy number,
83: P_SUBMISSION_PERIOD_STATUS in varchar2 default hr_api.g_varchar2,
84: P_SUBMISSION_START_DATE in date default hr_api.g_date,
79: procedure update_pact(
80: P_VALIDATE in number default hr_api.g_false_num,
81: P_ACTION_INFORMATION_ID in number,
82: P_OBJECT_VERSION_NUMBER in out nocopy number,
83: P_SUBMISSION_PERIOD_STATUS in varchar2 default hr_api.g_varchar2,
84: P_SUBMISSION_START_DATE in date default hr_api.g_date,
85: P_SUBMISSION_END_DATE in date default hr_api.g_date,
86: P_TAX_OFFICE_NAME in varchar2 default hr_api.g_varchar2,
87: P_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
80: P_VALIDATE in number default hr_api.g_false_num,
81: P_ACTION_INFORMATION_ID in number,
82: P_OBJECT_VERSION_NUMBER in out nocopy number,
83: P_SUBMISSION_PERIOD_STATUS in varchar2 default hr_api.g_varchar2,
84: P_SUBMISSION_START_DATE in date default hr_api.g_date,
85: P_SUBMISSION_END_DATE in date default hr_api.g_date,
86: P_TAX_OFFICE_NAME in varchar2 default hr_api.g_varchar2,
87: P_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
88: P_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
81: P_ACTION_INFORMATION_ID in number,
82: P_OBJECT_VERSION_NUMBER in out nocopy number,
83: P_SUBMISSION_PERIOD_STATUS in varchar2 default hr_api.g_varchar2,
84: P_SUBMISSION_START_DATE in date default hr_api.g_date,
85: P_SUBMISSION_END_DATE in date default hr_api.g_date,
86: P_TAX_OFFICE_NAME in varchar2 default hr_api.g_varchar2,
87: P_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
88: P_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
89: p_return_status out nocopy varchar2)
82: P_OBJECT_VERSION_NUMBER in out nocopy number,
83: P_SUBMISSION_PERIOD_STATUS in varchar2 default hr_api.g_varchar2,
84: P_SUBMISSION_START_DATE in date default hr_api.g_date,
85: P_SUBMISSION_END_DATE in date default hr_api.g_date,
86: P_TAX_OFFICE_NAME in varchar2 default hr_api.g_varchar2,
87: P_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
88: P_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
89: p_return_status out nocopy varchar2)
90: is
83: P_SUBMISSION_PERIOD_STATUS in varchar2 default hr_api.g_varchar2,
84: P_SUBMISSION_START_DATE in date default hr_api.g_date,
85: P_SUBMISSION_END_DATE in date default hr_api.g_date,
86: P_TAX_OFFICE_NAME in varchar2 default hr_api.g_varchar2,
87: P_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
88: P_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
89: p_return_status out nocopy varchar2)
90: is
91: l_rec pay_jp_def_pact_v%rowtype;
84: P_SUBMISSION_START_DATE in date default hr_api.g_date,
85: P_SUBMISSION_END_DATE in date default hr_api.g_date,
86: P_TAX_OFFICE_NAME in varchar2 default hr_api.g_varchar2,
87: P_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
88: P_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
89: p_return_status out nocopy varchar2)
90: is
91: l_rec pay_jp_def_pact_v%rowtype;
92: begin
146: procedure update_assact(
147: P_VALIDATE in boolean default false,
148: P_ACTION_INFORMATION_ID in number,
149: P_OBJECT_VERSION_NUMBER in out nocopy number,
150: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
151: P_FINALIZED_DATE in date default hr_api.g_date,
152: P_FINALIZED_BY in number default hr_api.g_number,
153: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
154: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
147: P_VALIDATE in boolean default false,
148: P_ACTION_INFORMATION_ID in number,
149: P_OBJECT_VERSION_NUMBER in out nocopy number,
150: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
151: P_FINALIZED_DATE in date default hr_api.g_date,
152: P_FINALIZED_BY in number default hr_api.g_number,
153: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
154: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
155: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
148: P_ACTION_INFORMATION_ID in number,
149: P_OBJECT_VERSION_NUMBER in out nocopy number,
150: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
151: P_FINALIZED_DATE in date default hr_api.g_date,
152: P_FINALIZED_BY in number default hr_api.g_number,
153: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
154: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
155: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
156: P_EXPIRY_DATE in date default hr_api.g_date)
149: P_OBJECT_VERSION_NUMBER in out nocopy number,
150: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
151: P_FINALIZED_DATE in date default hr_api.g_date,
152: P_FINALIZED_BY in number default hr_api.g_number,
153: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
154: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
155: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
156: P_EXPIRY_DATE in date default hr_api.g_date)
157: is
150: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
151: P_FINALIZED_DATE in date default hr_api.g_date,
152: P_FINALIZED_BY in number default hr_api.g_number,
153: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
154: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
155: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
156: P_EXPIRY_DATE in date default hr_api.g_date)
157: is
158: begin
151: P_FINALIZED_DATE in date default hr_api.g_date,
152: P_FINALIZED_BY in number default hr_api.g_number,
153: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
154: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
155: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
156: P_EXPIRY_DATE in date default hr_api.g_date)
157: is
158: begin
159: pay_action_information_api.update_action_information(
152: P_FINALIZED_BY in number default hr_api.g_number,
153: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
154: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
155: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
156: P_EXPIRY_DATE in date default hr_api.g_date)
157: is
158: begin
159: pay_action_information_api.update_action_information(
160: P_VALIDATE => P_VALIDATE,
175: -- is updated at first. So "check_submission_period" procedure
176: -- is implemented for this "Save" case at the moment.
177: --
178: procedure update_assact(
179: P_VALIDATE in number default hr_api.g_false_num,
180: P_ACTION_INFORMATION_ID in number,
181: P_OBJECT_VERSION_NUMBER in out nocopy number,
182: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
183: P_FINALIZED_DATE in date default hr_api.g_date,
178: procedure update_assact(
179: P_VALIDATE in number default hr_api.g_false_num,
180: P_ACTION_INFORMATION_ID in number,
181: P_OBJECT_VERSION_NUMBER in out nocopy number,
182: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
183: P_FINALIZED_DATE in date default hr_api.g_date,
184: P_FINALIZED_BY in number default hr_api.g_number,
185: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
186: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
179: P_VALIDATE in number default hr_api.g_false_num,
180: P_ACTION_INFORMATION_ID in number,
181: P_OBJECT_VERSION_NUMBER in out nocopy number,
182: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
183: P_FINALIZED_DATE in date default hr_api.g_date,
184: P_FINALIZED_BY in number default hr_api.g_number,
185: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
186: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
187: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
180: P_ACTION_INFORMATION_ID in number,
181: P_OBJECT_VERSION_NUMBER in out nocopy number,
182: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
183: P_FINALIZED_DATE in date default hr_api.g_date,
184: P_FINALIZED_BY in number default hr_api.g_number,
185: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
186: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
187: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
188: P_EXPIRY_DATE in date default hr_api.g_date,
181: P_OBJECT_VERSION_NUMBER in out nocopy number,
182: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
183: P_FINALIZED_DATE in date default hr_api.g_date,
184: P_FINALIZED_BY in number default hr_api.g_number,
185: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
186: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
187: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
188: P_EXPIRY_DATE in date default hr_api.g_date,
189: p_return_status out nocopy varchar2)
182: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
183: P_FINALIZED_DATE in date default hr_api.g_date,
184: P_FINALIZED_BY in number default hr_api.g_number,
185: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
186: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
187: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
188: P_EXPIRY_DATE in date default hr_api.g_date,
189: p_return_status out nocopy varchar2)
190: is
183: P_FINALIZED_DATE in date default hr_api.g_date,
184: P_FINALIZED_BY in number default hr_api.g_number,
185: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
186: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
187: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
188: P_EXPIRY_DATE in date default hr_api.g_date,
189: p_return_status out nocopy varchar2)
190: is
191: l_api_updating boolean;
184: P_FINALIZED_BY in number default hr_api.g_number,
185: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
186: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
187: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
188: P_EXPIRY_DATE in date default hr_api.g_date,
189: p_return_status out nocopy varchar2)
190: is
191: l_api_updating boolean;
192: l_transaction_status varchar2(30) := p_transaction_status;
190: is
191: l_api_updating boolean;
192: l_transaction_status varchar2(30) := p_transaction_status;
193: begin
194: if l_transaction_status = hr_api.g_varchar2 then
195: l_api_updating := pay_aif_shd.api_updating(
196: p_action_information_id => p_action_information_id,
197: p_object_version_number => p_object_version_number);
198: --
298: -- |---------------------------------------------------------------------------|
299: -- |------------------------------< update_emp >-------------------------------|
300: -- |---------------------------------------------------------------------------|
301: procedure update_emp(
302: P_VALIDATE in number default hr_api.g_false_num,
303: P_ACTION_INFORMATION_ID in number,
304: P_OBJECT_VERSION_NUMBER in out nocopy number,
305: P_CHANGE_DATE in date default hr_api.g_date,
306: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
301: procedure update_emp(
302: P_VALIDATE in number default hr_api.g_false_num,
303: P_ACTION_INFORMATION_ID in number,
304: P_OBJECT_VERSION_NUMBER in out nocopy number,
305: P_CHANGE_DATE in date default hr_api.g_date,
306: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
307: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
308: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
309: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
302: P_VALIDATE in number default hr_api.g_false_num,
303: P_ACTION_INFORMATION_ID in number,
304: P_OBJECT_VERSION_NUMBER in out nocopy number,
305: P_CHANGE_DATE in date default hr_api.g_date,
306: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
307: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
308: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
309: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
310: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
303: P_ACTION_INFORMATION_ID in number,
304: P_OBJECT_VERSION_NUMBER in out nocopy number,
305: P_CHANGE_DATE in date default hr_api.g_date,
306: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
307: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
308: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
309: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
310: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
311: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
304: P_OBJECT_VERSION_NUMBER in out nocopy number,
305: P_CHANGE_DATE in date default hr_api.g_date,
306: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
307: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
308: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
309: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
310: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
311: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
312: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
305: P_CHANGE_DATE in date default hr_api.g_date,
306: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
307: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
308: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
309: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
310: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
311: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
312: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
313: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
306: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
307: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
308: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
309: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
310: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
311: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
312: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
313: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
314: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
307: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
308: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
309: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
310: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
311: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
312: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
313: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
314: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
315: p_return_status out nocopy varchar2)
308: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
309: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
310: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
311: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
312: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
313: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
314: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
315: p_return_status out nocopy varchar2)
316: is
309: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
310: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
311: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
312: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
313: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
314: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
315: p_return_status out nocopy varchar2)
316: is
317: begin
310: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
311: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
312: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
313: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
314: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
315: p_return_status out nocopy varchar2)
316: is
317: begin
318: pay_action_information_swi.update_action_information(
419: procedure update_entry(
420: P_VALIDATE in boolean default false,
421: P_ACTION_INFORMATION_ID in number,
422: P_OBJECT_VERSION_NUMBER in out nocopy number,
423: P_STATUS in varchar2 default hr_api.g_varchar2,
424: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
425: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
426: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
427: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
420: P_VALIDATE in boolean default false,
421: P_ACTION_INFORMATION_ID in number,
422: P_OBJECT_VERSION_NUMBER in out nocopy number,
423: P_STATUS in varchar2 default hr_api.g_varchar2,
424: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
425: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
426: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
427: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
428: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
421: P_ACTION_INFORMATION_ID in number,
422: P_OBJECT_VERSION_NUMBER in out nocopy number,
423: P_STATUS in varchar2 default hr_api.g_varchar2,
424: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
425: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
426: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
427: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
428: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
429: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
422: P_OBJECT_VERSION_NUMBER in out nocopy number,
423: P_STATUS in varchar2 default hr_api.g_varchar2,
424: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
425: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
426: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
427: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
428: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
429: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
430: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
423: P_STATUS in varchar2 default hr_api.g_varchar2,
424: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
425: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
426: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
427: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
428: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
429: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
430: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
431: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
424: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
425: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
426: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
427: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
428: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
429: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
430: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
431: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
432: P_NUM_DEPS in number default hr_api.g_number,
425: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
426: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
427: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
428: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
429: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
430: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
431: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
432: P_NUM_DEPS in number default hr_api.g_number,
433: P_NUM_AGEDS in number default hr_api.g_number,
426: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
427: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
428: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
429: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
430: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
431: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
432: P_NUM_DEPS in number default hr_api.g_number,
433: P_NUM_AGEDS in number default hr_api.g_number,
434: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
427: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
428: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
429: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
430: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
431: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
432: P_NUM_DEPS in number default hr_api.g_number,
433: P_NUM_AGEDS in number default hr_api.g_number,
434: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
435: P_NUM_SPECIFIEDS in number default hr_api.g_number,
428: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
429: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
430: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
431: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
432: P_NUM_DEPS in number default hr_api.g_number,
433: P_NUM_AGEDS in number default hr_api.g_number,
434: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
435: P_NUM_SPECIFIEDS in number default hr_api.g_number,
436: P_NUM_DISABLEDS in number default hr_api.g_number,
429: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
430: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
431: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
432: P_NUM_DEPS in number default hr_api.g_number,
433: P_NUM_AGEDS in number default hr_api.g_number,
434: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
435: P_NUM_SPECIFIEDS in number default hr_api.g_number,
436: P_NUM_DISABLEDS in number default hr_api.g_number,
437: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
430: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
431: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
432: P_NUM_DEPS in number default hr_api.g_number,
433: P_NUM_AGEDS in number default hr_api.g_number,
434: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
435: P_NUM_SPECIFIEDS in number default hr_api.g_number,
436: P_NUM_DISABLEDS in number default hr_api.g_number,
437: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
438: P_NUM_SVR_DISABLEDS_LT in number default hr_api.g_number)
431: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
432: P_NUM_DEPS in number default hr_api.g_number,
433: P_NUM_AGEDS in number default hr_api.g_number,
434: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
435: P_NUM_SPECIFIEDS in number default hr_api.g_number,
436: P_NUM_DISABLEDS in number default hr_api.g_number,
437: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
438: P_NUM_SVR_DISABLEDS_LT in number default hr_api.g_number)
439: is
432: P_NUM_DEPS in number default hr_api.g_number,
433: P_NUM_AGEDS in number default hr_api.g_number,
434: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
435: P_NUM_SPECIFIEDS in number default hr_api.g_number,
436: P_NUM_DISABLEDS in number default hr_api.g_number,
437: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
438: P_NUM_SVR_DISABLEDS_LT in number default hr_api.g_number)
439: is
440: begin
433: P_NUM_AGEDS in number default hr_api.g_number,
434: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
435: P_NUM_SPECIFIEDS in number default hr_api.g_number,
436: P_NUM_DISABLEDS in number default hr_api.g_number,
437: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
438: P_NUM_SVR_DISABLEDS_LT in number default hr_api.g_number)
439: is
440: begin
441: pay_action_information_api.update_action_information(
434: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
435: P_NUM_SPECIFIEDS in number default hr_api.g_number,
436: P_NUM_DISABLEDS in number default hr_api.g_number,
437: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
438: P_NUM_SVR_DISABLEDS_LT in number default hr_api.g_number)
439: is
440: begin
441: pay_action_information_api.update_action_information(
442: P_VALIDATE => P_VALIDATE,
534: P_OBJECT_VERSION_NUMBER => p_object_version_number);
535: end create_dep;
536: --
537: procedure create_dep(
538: P_VALIDATE in number default hr_api.g_false_num,
539: P_ACTION_INFORMATION_ID in number,
540: P_ASSIGNMENT_ACTION_ID in number,
541: P_EFFECTIVE_DATE in date,
542: P_ASSIGNMENT_ID in number,
613: procedure update_dep(
614: P_VALIDATE in boolean default false,
615: P_ACTION_INFORMATION_ID in number,
616: P_OBJECT_VERSION_NUMBER in out nocopy number,
617: P_STATUS in varchar2 default hr_api.g_varchar2,
618: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
619: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
620: P_CHANGE_DATE in date default hr_api.g_date,
621: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
614: P_VALIDATE in boolean default false,
615: P_ACTION_INFORMATION_ID in number,
616: P_OBJECT_VERSION_NUMBER in out nocopy number,
617: P_STATUS in varchar2 default hr_api.g_varchar2,
618: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
619: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
620: P_CHANGE_DATE in date default hr_api.g_date,
621: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
622: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
615: P_ACTION_INFORMATION_ID in number,
616: P_OBJECT_VERSION_NUMBER in out nocopy number,
617: P_STATUS in varchar2 default hr_api.g_varchar2,
618: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
619: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
620: P_CHANGE_DATE in date default hr_api.g_date,
621: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
622: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
623: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
616: P_OBJECT_VERSION_NUMBER in out nocopy number,
617: P_STATUS in varchar2 default hr_api.g_varchar2,
618: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
619: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
620: P_CHANGE_DATE in date default hr_api.g_date,
621: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
622: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
623: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
624: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
617: P_STATUS in varchar2 default hr_api.g_varchar2,
618: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
619: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
620: P_CHANGE_DATE in date default hr_api.g_date,
621: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
622: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
623: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
624: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
625: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
618: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
619: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
620: P_CHANGE_DATE in date default hr_api.g_date,
621: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
622: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
623: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
624: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
625: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
626: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2)
619: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
620: P_CHANGE_DATE in date default hr_api.g_date,
621: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
622: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
623: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
624: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
625: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
626: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2)
627: is
620: P_CHANGE_DATE in date default hr_api.g_date,
621: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
622: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
623: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
624: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
625: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
626: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2)
627: is
628: begin
621: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
622: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
623: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
624: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
625: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
626: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2)
627: is
628: begin
629: pay_action_information_api.update_action_information(
622: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
623: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
624: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
625: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
626: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2)
627: is
628: begin
629: pay_action_information_api.update_action_information(
630: P_VALIDATE => P_VALIDATE,
642: P_ACTION_INFORMATION25 => P_DISABILITY_DETAILS);
643: end update_dep;
644: --
645: procedure update_dep(
646: P_VALIDATE in number default hr_api.g_false_num,
647: P_ACTION_INFORMATION_ID in number,
648: P_OBJECT_VERSION_NUMBER in out nocopy number,
649: P_STATUS in varchar2 default hr_api.g_varchar2,
650: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
645: procedure update_dep(
646: P_VALIDATE in number default hr_api.g_false_num,
647: P_ACTION_INFORMATION_ID in number,
648: P_OBJECT_VERSION_NUMBER in out nocopy number,
649: P_STATUS in varchar2 default hr_api.g_varchar2,
650: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
651: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
652: P_CHANGE_DATE in date default hr_api.g_date,
653: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
646: P_VALIDATE in number default hr_api.g_false_num,
647: P_ACTION_INFORMATION_ID in number,
648: P_OBJECT_VERSION_NUMBER in out nocopy number,
649: P_STATUS in varchar2 default hr_api.g_varchar2,
650: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
651: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
652: P_CHANGE_DATE in date default hr_api.g_date,
653: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
654: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
647: P_ACTION_INFORMATION_ID in number,
648: P_OBJECT_VERSION_NUMBER in out nocopy number,
649: P_STATUS in varchar2 default hr_api.g_varchar2,
650: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
651: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
652: P_CHANGE_DATE in date default hr_api.g_date,
653: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
654: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
655: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
648: P_OBJECT_VERSION_NUMBER in out nocopy number,
649: P_STATUS in varchar2 default hr_api.g_varchar2,
650: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
651: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
652: P_CHANGE_DATE in date default hr_api.g_date,
653: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
654: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
655: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
656: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
649: P_STATUS in varchar2 default hr_api.g_varchar2,
650: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
651: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
652: P_CHANGE_DATE in date default hr_api.g_date,
653: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
654: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
655: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
656: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
657: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
650: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
651: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
652: P_CHANGE_DATE in date default hr_api.g_date,
653: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
654: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
655: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
656: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
657: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
658: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
651: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
652: P_CHANGE_DATE in date default hr_api.g_date,
653: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
654: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
655: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
656: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
657: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
658: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
659: p_return_status out nocopy varchar2)
652: P_CHANGE_DATE in date default hr_api.g_date,
653: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
654: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
655: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
656: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
657: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
658: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
659: p_return_status out nocopy varchar2)
660: is
653: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
654: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
655: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
656: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
657: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
658: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
659: p_return_status out nocopy varchar2)
660: is
661: begin
654: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
655: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
656: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
657: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
658: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
659: p_return_status out nocopy varchar2)
660: is
661: begin
662: pay_action_information_swi.update_action_information(
744: P_OBJECT_VERSION_NUMBER => p_object_version_number);
745: end create_dep_oe;
746: --
747: procedure create_dep_oe(
748: P_VALIDATE in number default hr_api.g_false_num,
749: P_ACTION_INFORMATION_ID in number,
750: P_ASSIGNMENT_ACTION_ID in number,
751: P_EFFECTIVE_DATE in date,
752: P_ASSIGNMENT_ID in number,
817: procedure update_dep_oe(
818: P_VALIDATE in boolean default false,
819: P_ACTION_INFORMATION_ID in number,
820: P_OBJECT_VERSION_NUMBER in out nocopy number,
821: P_STATUS in varchar2 default hr_api.g_varchar2,
822: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
823: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
824: P_CHANGE_DATE in date default hr_api.g_date,
825: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
818: P_VALIDATE in boolean default false,
819: P_ACTION_INFORMATION_ID in number,
820: P_OBJECT_VERSION_NUMBER in out nocopy number,
821: P_STATUS in varchar2 default hr_api.g_varchar2,
822: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
823: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
824: P_CHANGE_DATE in date default hr_api.g_date,
825: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
826: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
819: P_ACTION_INFORMATION_ID in number,
820: P_OBJECT_VERSION_NUMBER in out nocopy number,
821: P_STATUS in varchar2 default hr_api.g_varchar2,
822: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
823: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
824: P_CHANGE_DATE in date default hr_api.g_date,
825: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
826: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
827: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
820: P_OBJECT_VERSION_NUMBER in out nocopy number,
821: P_STATUS in varchar2 default hr_api.g_varchar2,
822: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
823: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
824: P_CHANGE_DATE in date default hr_api.g_date,
825: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
826: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
827: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
828: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
821: P_STATUS in varchar2 default hr_api.g_varchar2,
822: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
823: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
824: P_CHANGE_DATE in date default hr_api.g_date,
825: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
826: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
827: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
828: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
829: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
822: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
823: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
824: P_CHANGE_DATE in date default hr_api.g_date,
825: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
826: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
827: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
828: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
829: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
830: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2)
823: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
824: P_CHANGE_DATE in date default hr_api.g_date,
825: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
826: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
827: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
828: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
829: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
830: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2)
831: is
824: P_CHANGE_DATE in date default hr_api.g_date,
825: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
826: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
827: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
828: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
829: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
830: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2)
831: is
832: begin
825: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
826: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
827: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
828: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
829: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
830: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2)
831: is
832: begin
833: pay_action_information_api.update_action_information(
826: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
827: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
828: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
829: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
830: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2)
831: is
832: begin
833: pay_action_information_api.update_action_information(
834: P_VALIDATE => P_VALIDATE,
846: P_ACTION_INFORMATION22 => P_OE_ADDRESS);
847: end update_dep_oe;
848: --
849: procedure update_dep_oe(
850: P_VALIDATE in number default hr_api.g_false_num,
851: P_ACTION_INFORMATION_ID in number,
852: P_OBJECT_VERSION_NUMBER in out nocopy number,
853: P_STATUS in varchar2 default hr_api.g_varchar2,
854: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
849: procedure update_dep_oe(
850: P_VALIDATE in number default hr_api.g_false_num,
851: P_ACTION_INFORMATION_ID in number,
852: P_OBJECT_VERSION_NUMBER in out nocopy number,
853: P_STATUS in varchar2 default hr_api.g_varchar2,
854: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
855: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
856: P_CHANGE_DATE in date default hr_api.g_date,
857: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
850: P_VALIDATE in number default hr_api.g_false_num,
851: P_ACTION_INFORMATION_ID in number,
852: P_OBJECT_VERSION_NUMBER in out nocopy number,
853: P_STATUS in varchar2 default hr_api.g_varchar2,
854: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
855: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
856: P_CHANGE_DATE in date default hr_api.g_date,
857: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
858: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
851: P_ACTION_INFORMATION_ID in number,
852: P_OBJECT_VERSION_NUMBER in out nocopy number,
853: P_STATUS in varchar2 default hr_api.g_varchar2,
854: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
855: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
856: P_CHANGE_DATE in date default hr_api.g_date,
857: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
858: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
859: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
852: P_OBJECT_VERSION_NUMBER in out nocopy number,
853: P_STATUS in varchar2 default hr_api.g_varchar2,
854: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
855: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
856: P_CHANGE_DATE in date default hr_api.g_date,
857: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
858: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
859: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
860: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
853: P_STATUS in varchar2 default hr_api.g_varchar2,
854: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
855: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
856: P_CHANGE_DATE in date default hr_api.g_date,
857: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
858: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
859: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
860: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
861: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
854: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
855: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
856: P_CHANGE_DATE in date default hr_api.g_date,
857: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
858: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
859: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
860: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
861: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
862: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
855: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
856: P_CHANGE_DATE in date default hr_api.g_date,
857: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
858: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
859: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
860: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
861: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
862: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
863: p_return_status out nocopy varchar2)
856: P_CHANGE_DATE in date default hr_api.g_date,
857: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
858: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
859: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
860: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
861: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
862: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
863: p_return_status out nocopy varchar2)
864: is
857: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
858: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
859: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
860: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
861: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
862: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
863: p_return_status out nocopy varchar2)
864: is
865: begin
858: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
859: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
860: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
861: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
862: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
863: p_return_status out nocopy varchar2)
864: is
865: begin
866: pay_action_information_swi.update_action_information(
940: P_OBJECT_VERSION_NUMBER => p_object_version_number);
941: end create_dep_os;
942: --
943: procedure create_dep_os(
944: P_VALIDATE in number default hr_api.g_false_num,
945: P_ACTION_INFORMATION_ID in number,
946: P_ASSIGNMENT_ACTION_ID in number,
947: P_EFFECTIVE_DATE in date,
948: P_ASSIGNMENT_ID in number,
1005: procedure update_dep_os(
1006: P_VALIDATE in boolean default false,
1007: P_ACTION_INFORMATION_ID in number,
1008: P_OBJECT_VERSION_NUMBER in out nocopy number,
1009: P_STATUS in varchar2 default hr_api.g_varchar2,
1010: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1011: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1012: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1013: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1006: P_VALIDATE in boolean default false,
1007: P_ACTION_INFORMATION_ID in number,
1008: P_OBJECT_VERSION_NUMBER in out nocopy number,
1009: P_STATUS in varchar2 default hr_api.g_varchar2,
1010: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1011: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1012: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1013: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1014: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2)
1007: P_ACTION_INFORMATION_ID in number,
1008: P_OBJECT_VERSION_NUMBER in out nocopy number,
1009: P_STATUS in varchar2 default hr_api.g_varchar2,
1010: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1011: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1012: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1013: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1014: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2)
1015: is
1008: P_OBJECT_VERSION_NUMBER in out nocopy number,
1009: P_STATUS in varchar2 default hr_api.g_varchar2,
1010: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1011: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1012: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1013: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1014: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2)
1015: is
1016: begin
1009: P_STATUS in varchar2 default hr_api.g_varchar2,
1010: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1011: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1012: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1013: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1014: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2)
1015: is
1016: begin
1017: pay_action_information_api.update_action_information(
1010: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1011: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1012: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1013: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1014: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2)
1015: is
1016: begin
1017: pay_action_information_api.update_action_information(
1018: P_VALIDATE => P_VALIDATE,
1026: P_ACTION_INFORMATION18 => P_OS_SALARY_PAYER_ADDRESS);
1027: end update_dep_os;
1028: --
1029: procedure update_dep_os(
1030: P_VALIDATE in number default hr_api.g_false_num,
1031: P_ACTION_INFORMATION_ID in number,
1032: P_OBJECT_VERSION_NUMBER in out nocopy number,
1033: P_STATUS in varchar2 default hr_api.g_varchar2,
1034: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1029: procedure update_dep_os(
1030: P_VALIDATE in number default hr_api.g_false_num,
1031: P_ACTION_INFORMATION_ID in number,
1032: P_OBJECT_VERSION_NUMBER in out nocopy number,
1033: P_STATUS in varchar2 default hr_api.g_varchar2,
1034: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1035: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1036: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1037: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1030: P_VALIDATE in number default hr_api.g_false_num,
1031: P_ACTION_INFORMATION_ID in number,
1032: P_OBJECT_VERSION_NUMBER in out nocopy number,
1033: P_STATUS in varchar2 default hr_api.g_varchar2,
1034: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1035: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1036: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1037: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1038: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
1031: P_ACTION_INFORMATION_ID in number,
1032: P_OBJECT_VERSION_NUMBER in out nocopy number,
1033: P_STATUS in varchar2 default hr_api.g_varchar2,
1034: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1035: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1036: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1037: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1038: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
1039: p_return_status out nocopy varchar2)
1032: P_OBJECT_VERSION_NUMBER in out nocopy number,
1033: P_STATUS in varchar2 default hr_api.g_varchar2,
1034: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1035: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1036: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1037: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1038: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
1039: p_return_status out nocopy varchar2)
1040: is
1033: P_STATUS in varchar2 default hr_api.g_varchar2,
1034: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1035: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1036: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1037: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1038: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
1039: p_return_status out nocopy varchar2)
1040: is
1041: begin
1034: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1035: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1036: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1037: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1038: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
1039: p_return_status out nocopy varchar2)
1040: is
1041: begin
1042: pay_action_information_swi.update_action_information(