24: -- |---------------------------------------------------------------------------|
25: -- Access Status:
26: -- Internal Development Use Only
27: procedure update_pact(
28: P_VALIDATE in number default hr_api.g_false_num,
29: P_ACTION_INFORMATION_ID in number,
30: P_OBJECT_VERSION_NUMBER in out nocopy number,
31: P_SUBMISSION_PERIOD_STATUS in varchar2 default hr_api.g_varchar2,
32: P_SUBMISSION_START_DATE in date default hr_api.g_date,
27: procedure update_pact(
28: P_VALIDATE in number default hr_api.g_false_num,
29: P_ACTION_INFORMATION_ID in number,
30: P_OBJECT_VERSION_NUMBER in out nocopy number,
31: P_SUBMISSION_PERIOD_STATUS in varchar2 default hr_api.g_varchar2,
32: P_SUBMISSION_START_DATE in date default hr_api.g_date,
33: P_SUBMISSION_END_DATE in date default hr_api.g_date,
34: P_TAX_OFFICE_NAME in varchar2 default hr_api.g_varchar2,
35: P_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
28: P_VALIDATE in number default hr_api.g_false_num,
29: P_ACTION_INFORMATION_ID in number,
30: P_OBJECT_VERSION_NUMBER in out nocopy number,
31: P_SUBMISSION_PERIOD_STATUS in varchar2 default hr_api.g_varchar2,
32: P_SUBMISSION_START_DATE in date default hr_api.g_date,
33: P_SUBMISSION_END_DATE in date default hr_api.g_date,
34: P_TAX_OFFICE_NAME in varchar2 default hr_api.g_varchar2,
35: P_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
36: P_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
29: P_ACTION_INFORMATION_ID in number,
30: P_OBJECT_VERSION_NUMBER in out nocopy number,
31: P_SUBMISSION_PERIOD_STATUS in varchar2 default hr_api.g_varchar2,
32: P_SUBMISSION_START_DATE in date default hr_api.g_date,
33: P_SUBMISSION_END_DATE in date default hr_api.g_date,
34: P_TAX_OFFICE_NAME in varchar2 default hr_api.g_varchar2,
35: P_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
36: P_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
37: p_return_status out nocopy varchar2);
30: P_OBJECT_VERSION_NUMBER in out nocopy number,
31: P_SUBMISSION_PERIOD_STATUS in varchar2 default hr_api.g_varchar2,
32: P_SUBMISSION_START_DATE in date default hr_api.g_date,
33: P_SUBMISSION_END_DATE in date default hr_api.g_date,
34: P_TAX_OFFICE_NAME in varchar2 default hr_api.g_varchar2,
35: P_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
36: P_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
37: p_return_status out nocopy varchar2);
38: -- |---------------------------------------------------------------------------|
31: P_SUBMISSION_PERIOD_STATUS in varchar2 default hr_api.g_varchar2,
32: P_SUBMISSION_START_DATE in date default hr_api.g_date,
33: P_SUBMISSION_END_DATE in date default hr_api.g_date,
34: P_TAX_OFFICE_NAME in varchar2 default hr_api.g_varchar2,
35: P_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
36: P_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
37: p_return_status out nocopy varchar2);
38: -- |---------------------------------------------------------------------------|
39: -- |-----------------------------< create_assact >-----------------------------|
32: P_SUBMISSION_START_DATE in date default hr_api.g_date,
33: P_SUBMISSION_END_DATE in date default hr_api.g_date,
34: P_TAX_OFFICE_NAME in varchar2 default hr_api.g_varchar2,
35: P_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
36: P_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
37: p_return_status out nocopy varchar2);
38: -- |---------------------------------------------------------------------------|
39: -- |-----------------------------< create_assact >-----------------------------|
40: -- |---------------------------------------------------------------------------|
63: procedure update_assact(
64: P_VALIDATE in boolean default false,
65: P_ACTION_INFORMATION_ID in number,
66: P_OBJECT_VERSION_NUMBER in out nocopy number,
67: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
68: P_FINALIZED_DATE in date default hr_api.g_date,
69: P_FINALIZED_BY in number default hr_api.g_number,
70: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
71: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
64: P_VALIDATE in boolean default false,
65: P_ACTION_INFORMATION_ID in number,
66: P_OBJECT_VERSION_NUMBER in out nocopy number,
67: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
68: P_FINALIZED_DATE in date default hr_api.g_date,
69: P_FINALIZED_BY in number default hr_api.g_number,
70: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
71: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
72: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
65: P_ACTION_INFORMATION_ID in number,
66: P_OBJECT_VERSION_NUMBER in out nocopy number,
67: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
68: P_FINALIZED_DATE in date default hr_api.g_date,
69: P_FINALIZED_BY in number default hr_api.g_number,
70: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
71: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
72: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
73: P_EXPIRY_DATE in date default hr_api.g_date);
66: P_OBJECT_VERSION_NUMBER in out nocopy number,
67: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
68: P_FINALIZED_DATE in date default hr_api.g_date,
69: P_FINALIZED_BY in number default hr_api.g_number,
70: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
71: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
72: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
73: P_EXPIRY_DATE in date default hr_api.g_date);
74: -- Access Status:
67: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
68: P_FINALIZED_DATE in date default hr_api.g_date,
69: P_FINALIZED_BY in number default hr_api.g_number,
70: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
71: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
72: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
73: P_EXPIRY_DATE in date default hr_api.g_date);
74: -- Access Status:
75: -- Internal Development Use Only
68: P_FINALIZED_DATE in date default hr_api.g_date,
69: P_FINALIZED_BY in number default hr_api.g_number,
70: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
71: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
72: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
73: P_EXPIRY_DATE in date default hr_api.g_date);
74: -- Access Status:
75: -- Internal Development Use Only
76: procedure update_assact(
69: P_FINALIZED_BY in number default hr_api.g_number,
70: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
71: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
72: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
73: P_EXPIRY_DATE in date default hr_api.g_date);
74: -- Access Status:
75: -- Internal Development Use Only
76: procedure update_assact(
77: P_VALIDATE in number default hr_api.g_false_num,
73: P_EXPIRY_DATE in date default hr_api.g_date);
74: -- Access Status:
75: -- Internal Development Use Only
76: procedure update_assact(
77: P_VALIDATE in number default hr_api.g_false_num,
78: P_ACTION_INFORMATION_ID in number,
79: P_OBJECT_VERSION_NUMBER in out nocopy number,
80: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
81: P_FINALIZED_DATE in date default hr_api.g_date,
76: procedure update_assact(
77: P_VALIDATE in number default hr_api.g_false_num,
78: P_ACTION_INFORMATION_ID in number,
79: P_OBJECT_VERSION_NUMBER in out nocopy number,
80: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
81: P_FINALIZED_DATE in date default hr_api.g_date,
82: P_FINALIZED_BY in number default hr_api.g_number,
83: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
84: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
77: P_VALIDATE in number default hr_api.g_false_num,
78: P_ACTION_INFORMATION_ID in number,
79: P_OBJECT_VERSION_NUMBER in out nocopy number,
80: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
81: P_FINALIZED_DATE in date default hr_api.g_date,
82: P_FINALIZED_BY in number default hr_api.g_number,
83: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
84: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
85: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
78: P_ACTION_INFORMATION_ID in number,
79: P_OBJECT_VERSION_NUMBER in out nocopy number,
80: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
81: P_FINALIZED_DATE in date default hr_api.g_date,
82: P_FINALIZED_BY in number default hr_api.g_number,
83: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
84: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
85: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
86: P_EXPIRY_DATE in date default hr_api.g_date,
79: P_OBJECT_VERSION_NUMBER in out nocopy number,
80: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
81: P_FINALIZED_DATE in date default hr_api.g_date,
82: P_FINALIZED_BY in number default hr_api.g_number,
83: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
84: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
85: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
86: P_EXPIRY_DATE in date default hr_api.g_date,
87: p_return_status out nocopy varchar2);
80: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,
81: P_FINALIZED_DATE in date default hr_api.g_date,
82: P_FINALIZED_BY in number default hr_api.g_number,
83: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
84: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
85: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
86: P_EXPIRY_DATE in date default hr_api.g_date,
87: p_return_status out nocopy varchar2);
88: -- |---------------------------------------------------------------------------|
81: P_FINALIZED_DATE in date default hr_api.g_date,
82: P_FINALIZED_BY in number default hr_api.g_number,
83: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
84: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
85: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
86: P_EXPIRY_DATE in date default hr_api.g_date,
87: p_return_status out nocopy varchar2);
88: -- |---------------------------------------------------------------------------|
89: -- |------------------------------< create_emp >-------------------------------|
82: P_FINALIZED_BY in number default hr_api.g_number,
83: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,
84: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,
85: P_TRANSFER_STATUS in varchar2 default hr_api.g_varchar2,
86: P_EXPIRY_DATE in date default hr_api.g_date,
87: p_return_status out nocopy varchar2);
88: -- |---------------------------------------------------------------------------|
89: -- |------------------------------< create_emp >-------------------------------|
90: -- |---------------------------------------------------------------------------|
125: -- |---------------------------------------------------------------------------|
126: -- Access Status:
127: -- Internal Development Use Only
128: procedure update_emp(
129: P_VALIDATE in number default hr_api.g_false_num,
130: P_ACTION_INFORMATION_ID in number,
131: P_OBJECT_VERSION_NUMBER in out nocopy number,
132: P_CHANGE_DATE in date default hr_api.g_date,
133: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
128: procedure update_emp(
129: P_VALIDATE in number default hr_api.g_false_num,
130: P_ACTION_INFORMATION_ID in number,
131: P_OBJECT_VERSION_NUMBER in out nocopy number,
132: P_CHANGE_DATE in date default hr_api.g_date,
133: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
134: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
135: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
136: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
129: P_VALIDATE in number default hr_api.g_false_num,
130: P_ACTION_INFORMATION_ID in number,
131: P_OBJECT_VERSION_NUMBER in out nocopy number,
132: P_CHANGE_DATE in date default hr_api.g_date,
133: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
134: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
135: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
136: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
137: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
130: P_ACTION_INFORMATION_ID in number,
131: P_OBJECT_VERSION_NUMBER in out nocopy number,
132: P_CHANGE_DATE in date default hr_api.g_date,
133: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
134: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
135: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
136: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
137: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
138: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
131: P_OBJECT_VERSION_NUMBER in out nocopy number,
132: P_CHANGE_DATE in date default hr_api.g_date,
133: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
134: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
135: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
136: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
137: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
138: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
139: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
132: P_CHANGE_DATE in date default hr_api.g_date,
133: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
134: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
135: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
136: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
137: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
138: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
139: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
140: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
133: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
134: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
135: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
136: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
137: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
138: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
139: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
140: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
141: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
134: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
135: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
136: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
137: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
138: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
139: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
140: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
141: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
142: p_return_status out nocopy varchar2);
135: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
136: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
137: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
138: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
139: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
140: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
141: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
142: p_return_status out nocopy varchar2);
143: -- |---------------------------------------------------------------------------|
136: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
137: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
138: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
139: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
140: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
141: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
142: p_return_status out nocopy varchar2);
143: -- |---------------------------------------------------------------------------|
144: -- |-----------------------------< create_entry >------------------------------|
137: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
138: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
139: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
140: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
141: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
142: p_return_status out nocopy varchar2);
143: -- |---------------------------------------------------------------------------|
144: -- |-----------------------------< create_entry >------------------------------|
145: -- |---------------------------------------------------------------------------|
190: procedure update_entry(
191: P_VALIDATE in boolean default false,
192: P_ACTION_INFORMATION_ID in number,
193: P_OBJECT_VERSION_NUMBER in out nocopy number,
194: P_STATUS in varchar2 default hr_api.g_varchar2,
195: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
196: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
197: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
198: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
191: P_VALIDATE in boolean default false,
192: P_ACTION_INFORMATION_ID in number,
193: P_OBJECT_VERSION_NUMBER in out nocopy number,
194: P_STATUS in varchar2 default hr_api.g_varchar2,
195: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
196: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
197: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
198: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
199: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
192: P_ACTION_INFORMATION_ID in number,
193: P_OBJECT_VERSION_NUMBER in out nocopy number,
194: P_STATUS in varchar2 default hr_api.g_varchar2,
195: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
196: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
197: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
198: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
199: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
200: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
193: P_OBJECT_VERSION_NUMBER in out nocopy number,
194: P_STATUS in varchar2 default hr_api.g_varchar2,
195: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
196: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
197: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
198: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
199: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
200: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
201: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
194: P_STATUS in varchar2 default hr_api.g_varchar2,
195: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
196: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
197: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
198: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
199: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
200: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
201: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
202: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
195: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
196: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
197: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
198: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
199: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
200: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
201: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
202: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
203: P_NUM_DEPS in number default hr_api.g_number,
196: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
197: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
198: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
199: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
200: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
201: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
202: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
203: P_NUM_DEPS in number default hr_api.g_number,
204: P_NUM_AGEDS in number default hr_api.g_number,
197: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
198: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
199: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
200: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
201: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
202: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
203: P_NUM_DEPS in number default hr_api.g_number,
204: P_NUM_AGEDS in number default hr_api.g_number,
205: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
198: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
199: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
200: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
201: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
202: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
203: P_NUM_DEPS in number default hr_api.g_number,
204: P_NUM_AGEDS in number default hr_api.g_number,
205: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
206: P_NUM_SPECIFIEDS in number default hr_api.g_number,
199: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
200: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
201: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
202: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
203: P_NUM_DEPS in number default hr_api.g_number,
204: P_NUM_AGEDS in number default hr_api.g_number,
205: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
206: P_NUM_SPECIFIEDS in number default hr_api.g_number,
207: P_NUM_DISABLEDS in number default hr_api.g_number,
200: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
201: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
202: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
203: P_NUM_DEPS in number default hr_api.g_number,
204: P_NUM_AGEDS in number default hr_api.g_number,
205: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
206: P_NUM_SPECIFIEDS in number default hr_api.g_number,
207: P_NUM_DISABLEDS in number default hr_api.g_number,
208: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
201: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
202: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
203: P_NUM_DEPS in number default hr_api.g_number,
204: P_NUM_AGEDS in number default hr_api.g_number,
205: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
206: P_NUM_SPECIFIEDS in number default hr_api.g_number,
207: P_NUM_DISABLEDS in number default hr_api.g_number,
208: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
209: P_NUM_SVR_DISABLEDS_LT in number default hr_api.g_number);
202: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
203: P_NUM_DEPS in number default hr_api.g_number,
204: P_NUM_AGEDS in number default hr_api.g_number,
205: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
206: P_NUM_SPECIFIEDS in number default hr_api.g_number,
207: P_NUM_DISABLEDS in number default hr_api.g_number,
208: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
209: P_NUM_SVR_DISABLEDS_LT in number default hr_api.g_number);
210: -- |---------------------------------------------------------------------------|
203: P_NUM_DEPS in number default hr_api.g_number,
204: P_NUM_AGEDS in number default hr_api.g_number,
205: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
206: P_NUM_SPECIFIEDS in number default hr_api.g_number,
207: P_NUM_DISABLEDS in number default hr_api.g_number,
208: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
209: P_NUM_SVR_DISABLEDS_LT in number default hr_api.g_number);
210: -- |---------------------------------------------------------------------------|
211: -- |------------------------------< create_dep >-------------------------------|
204: P_NUM_AGEDS in number default hr_api.g_number,
205: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
206: P_NUM_SPECIFIEDS in number default hr_api.g_number,
207: P_NUM_DISABLEDS in number default hr_api.g_number,
208: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
209: P_NUM_SVR_DISABLEDS_LT in number default hr_api.g_number);
210: -- |---------------------------------------------------------------------------|
211: -- |------------------------------< create_dep >-------------------------------|
212: -- |---------------------------------------------------------------------------|
205: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
206: P_NUM_SPECIFIEDS in number default hr_api.g_number,
207: P_NUM_DISABLEDS in number default hr_api.g_number,
208: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
209: P_NUM_SVR_DISABLEDS_LT in number default hr_api.g_number);
210: -- |---------------------------------------------------------------------------|
211: -- |------------------------------< create_dep >-------------------------------|
212: -- |---------------------------------------------------------------------------|
213: -- Access Status:
247: P_OBJECT_VERSION_NUMBER out nocopy number);
248: -- Access Status:
249: -- Internal Development Use Only
250: procedure create_dep(
251: P_VALIDATE in number default hr_api.g_false_num,
252: P_ACTION_INFORMATION_ID in number,
253: P_ASSIGNMENT_ACTION_ID in number,
254: P_EFFECTIVE_DATE in date,
255: P_ASSIGNMENT_ID in number,
289: procedure update_dep(
290: P_VALIDATE in boolean default false,
291: P_ACTION_INFORMATION_ID in number,
292: P_OBJECT_VERSION_NUMBER in out nocopy number,
293: P_STATUS in varchar2 default hr_api.g_varchar2,
294: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
295: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
296: P_CHANGE_DATE in date default hr_api.g_date,
297: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
290: P_VALIDATE in boolean default false,
291: P_ACTION_INFORMATION_ID in number,
292: P_OBJECT_VERSION_NUMBER in out nocopy number,
293: P_STATUS in varchar2 default hr_api.g_varchar2,
294: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
295: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
296: P_CHANGE_DATE in date default hr_api.g_date,
297: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
298: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
291: P_ACTION_INFORMATION_ID in number,
292: P_OBJECT_VERSION_NUMBER in out nocopy number,
293: P_STATUS in varchar2 default hr_api.g_varchar2,
294: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
295: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
296: P_CHANGE_DATE in date default hr_api.g_date,
297: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
298: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
299: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
292: P_OBJECT_VERSION_NUMBER in out nocopy number,
293: P_STATUS in varchar2 default hr_api.g_varchar2,
294: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
295: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
296: P_CHANGE_DATE in date default hr_api.g_date,
297: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
298: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
299: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
300: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
293: P_STATUS in varchar2 default hr_api.g_varchar2,
294: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
295: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
296: P_CHANGE_DATE in date default hr_api.g_date,
297: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
298: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
299: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
300: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
301: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
294: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
295: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
296: P_CHANGE_DATE in date default hr_api.g_date,
297: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
298: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
299: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
300: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
301: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
302: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2);
295: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
296: P_CHANGE_DATE in date default hr_api.g_date,
297: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
298: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
299: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
300: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
301: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
302: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2);
303: -- Access Status:
296: P_CHANGE_DATE in date default hr_api.g_date,
297: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
298: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
299: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
300: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
301: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
302: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2);
303: -- Access Status:
304: -- Internal Development Use Only
297: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
298: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
299: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
300: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
301: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
302: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2);
303: -- Access Status:
304: -- Internal Development Use Only
305: procedure update_dep(
298: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
299: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
300: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
301: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
302: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2);
303: -- Access Status:
304: -- Internal Development Use Only
305: procedure update_dep(
306: P_VALIDATE in number default hr_api.g_false_num,
302: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2);
303: -- Access Status:
304: -- Internal Development Use Only
305: procedure update_dep(
306: P_VALIDATE in number default hr_api.g_false_num,
307: P_ACTION_INFORMATION_ID in number,
308: P_OBJECT_VERSION_NUMBER in out nocopy number,
309: P_STATUS in varchar2 default hr_api.g_varchar2,
310: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
305: procedure update_dep(
306: P_VALIDATE in number default hr_api.g_false_num,
307: P_ACTION_INFORMATION_ID in number,
308: P_OBJECT_VERSION_NUMBER in out nocopy number,
309: P_STATUS in varchar2 default hr_api.g_varchar2,
310: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
311: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
312: P_CHANGE_DATE in date default hr_api.g_date,
313: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
306: P_VALIDATE in number default hr_api.g_false_num,
307: P_ACTION_INFORMATION_ID in number,
308: P_OBJECT_VERSION_NUMBER in out nocopy number,
309: P_STATUS in varchar2 default hr_api.g_varchar2,
310: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
311: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
312: P_CHANGE_DATE in date default hr_api.g_date,
313: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
314: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
307: P_ACTION_INFORMATION_ID in number,
308: P_OBJECT_VERSION_NUMBER in out nocopy number,
309: P_STATUS in varchar2 default hr_api.g_varchar2,
310: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
311: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
312: P_CHANGE_DATE in date default hr_api.g_date,
313: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
314: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
315: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
308: P_OBJECT_VERSION_NUMBER in out nocopy number,
309: P_STATUS in varchar2 default hr_api.g_varchar2,
310: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
311: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
312: P_CHANGE_DATE in date default hr_api.g_date,
313: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
314: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
315: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
316: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
309: P_STATUS in varchar2 default hr_api.g_varchar2,
310: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
311: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
312: P_CHANGE_DATE in date default hr_api.g_date,
313: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
314: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
315: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
316: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
317: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
310: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
311: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
312: P_CHANGE_DATE in date default hr_api.g_date,
313: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
314: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
315: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
316: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
317: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
318: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
311: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
312: P_CHANGE_DATE in date default hr_api.g_date,
313: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
314: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
315: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
316: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
317: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
318: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
319: p_return_status out nocopy varchar2);
312: P_CHANGE_DATE in date default hr_api.g_date,
313: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
314: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
315: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
316: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
317: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
318: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
319: p_return_status out nocopy varchar2);
320: -- |---------------------------------------------------------------------------|
313: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
314: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
315: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
316: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
317: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
318: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
319: p_return_status out nocopy varchar2);
320: -- |---------------------------------------------------------------------------|
321: -- |-----------------------------< create_dep_oe >-----------------------------|
314: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
315: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
316: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
317: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
318: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
319: p_return_status out nocopy varchar2);
320: -- |---------------------------------------------------------------------------|
321: -- |-----------------------------< create_dep_oe >-----------------------------|
322: -- |---------------------------------------------------------------------------|
354: P_OBJECT_VERSION_NUMBER out nocopy number);
355: -- Access Status:
356: -- Internal Development Use Only
357: procedure create_dep_oe(
358: P_VALIDATE in number default hr_api.g_false_num,
359: P_ACTION_INFORMATION_ID in number,
360: P_ASSIGNMENT_ACTION_ID in number,
361: P_EFFECTIVE_DATE in date,
362: P_ASSIGNMENT_ID in number,
393: procedure update_dep_oe(
394: P_VALIDATE in boolean default false,
395: P_ACTION_INFORMATION_ID in number,
396: P_OBJECT_VERSION_NUMBER in out nocopy number,
397: P_STATUS in varchar2 default hr_api.g_varchar2,
398: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
399: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
400: P_CHANGE_DATE in date default hr_api.g_date,
401: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
394: P_VALIDATE in boolean default false,
395: P_ACTION_INFORMATION_ID in number,
396: P_OBJECT_VERSION_NUMBER in out nocopy number,
397: P_STATUS in varchar2 default hr_api.g_varchar2,
398: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
399: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
400: P_CHANGE_DATE in date default hr_api.g_date,
401: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
402: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
395: P_ACTION_INFORMATION_ID in number,
396: P_OBJECT_VERSION_NUMBER in out nocopy number,
397: P_STATUS in varchar2 default hr_api.g_varchar2,
398: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
399: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
400: P_CHANGE_DATE in date default hr_api.g_date,
401: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
402: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
403: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
396: P_OBJECT_VERSION_NUMBER in out nocopy number,
397: P_STATUS in varchar2 default hr_api.g_varchar2,
398: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
399: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
400: P_CHANGE_DATE in date default hr_api.g_date,
401: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
402: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
403: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
404: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
397: P_STATUS in varchar2 default hr_api.g_varchar2,
398: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
399: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
400: P_CHANGE_DATE in date default hr_api.g_date,
401: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
402: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
403: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
404: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
405: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
398: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
399: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
400: P_CHANGE_DATE in date default hr_api.g_date,
401: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
402: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
403: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
404: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
405: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
406: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2);
399: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
400: P_CHANGE_DATE in date default hr_api.g_date,
401: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
402: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
403: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
404: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
405: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
406: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2);
407: -- Access Status:
400: P_CHANGE_DATE in date default hr_api.g_date,
401: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
402: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
403: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
404: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
405: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
406: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2);
407: -- Access Status:
408: -- Internal Development Use Only
401: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
402: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
403: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
404: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
405: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
406: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2);
407: -- Access Status:
408: -- Internal Development Use Only
409: procedure update_dep_oe(
402: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
403: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
404: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
405: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
406: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2);
407: -- Access Status:
408: -- Internal Development Use Only
409: procedure update_dep_oe(
410: P_VALIDATE in number default hr_api.g_false_num,
406: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2);
407: -- Access Status:
408: -- Internal Development Use Only
409: procedure update_dep_oe(
410: P_VALIDATE in number default hr_api.g_false_num,
411: P_ACTION_INFORMATION_ID in number,
412: P_OBJECT_VERSION_NUMBER in out nocopy number,
413: P_STATUS in varchar2 default hr_api.g_varchar2,
414: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
409: procedure update_dep_oe(
410: P_VALIDATE in number default hr_api.g_false_num,
411: P_ACTION_INFORMATION_ID in number,
412: P_OBJECT_VERSION_NUMBER in out nocopy number,
413: P_STATUS in varchar2 default hr_api.g_varchar2,
414: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
415: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
416: P_CHANGE_DATE in date default hr_api.g_date,
417: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
410: P_VALIDATE in number default hr_api.g_false_num,
411: P_ACTION_INFORMATION_ID in number,
412: P_OBJECT_VERSION_NUMBER in out nocopy number,
413: P_STATUS in varchar2 default hr_api.g_varchar2,
414: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
415: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
416: P_CHANGE_DATE in date default hr_api.g_date,
417: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
418: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
411: P_ACTION_INFORMATION_ID in number,
412: P_OBJECT_VERSION_NUMBER in out nocopy number,
413: P_STATUS in varchar2 default hr_api.g_varchar2,
414: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
415: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
416: P_CHANGE_DATE in date default hr_api.g_date,
417: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
418: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
419: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
412: P_OBJECT_VERSION_NUMBER in out nocopy number,
413: P_STATUS in varchar2 default hr_api.g_varchar2,
414: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
415: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
416: P_CHANGE_DATE in date default hr_api.g_date,
417: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
418: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
419: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
420: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
413: P_STATUS in varchar2 default hr_api.g_varchar2,
414: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
415: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
416: P_CHANGE_DATE in date default hr_api.g_date,
417: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
418: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
419: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
420: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
421: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
414: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
415: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
416: P_CHANGE_DATE in date default hr_api.g_date,
417: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
418: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
419: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
420: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
421: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
422: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
415: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
416: P_CHANGE_DATE in date default hr_api.g_date,
417: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
418: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
419: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
420: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
421: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
422: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
423: p_return_status out nocopy varchar2);
416: P_CHANGE_DATE in date default hr_api.g_date,
417: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
418: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
419: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
420: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
421: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
422: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
423: p_return_status out nocopy varchar2);
424: -- |---------------------------------------------------------------------------|
417: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
418: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
419: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
420: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
421: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
422: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
423: p_return_status out nocopy varchar2);
424: -- |---------------------------------------------------------------------------|
425: -- |-----------------------------< create_dep_os >-----------------------------|
418: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
419: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
420: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
421: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
422: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
423: p_return_status out nocopy varchar2);
424: -- |---------------------------------------------------------------------------|
425: -- |-----------------------------< create_dep_os >-----------------------------|
426: -- |---------------------------------------------------------------------------|
454: P_OBJECT_VERSION_NUMBER out nocopy number);
455: -- Access Status:
456: -- Internal Development Use Only
457: procedure create_dep_os(
458: P_VALIDATE in number default hr_api.g_false_num,
459: P_ACTION_INFORMATION_ID in number,
460: P_ASSIGNMENT_ACTION_ID in number,
461: P_EFFECTIVE_DATE in date,
462: P_ASSIGNMENT_ID in number,
489: procedure update_dep_os(
490: P_VALIDATE in boolean default false,
491: P_ACTION_INFORMATION_ID in number,
492: P_OBJECT_VERSION_NUMBER in out nocopy number,
493: P_STATUS in varchar2 default hr_api.g_varchar2,
494: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
495: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
496: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
497: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
490: P_VALIDATE in boolean default false,
491: P_ACTION_INFORMATION_ID in number,
492: P_OBJECT_VERSION_NUMBER in out nocopy number,
493: P_STATUS in varchar2 default hr_api.g_varchar2,
494: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
495: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
496: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
497: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
498: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2);
491: P_ACTION_INFORMATION_ID in number,
492: P_OBJECT_VERSION_NUMBER in out nocopy number,
493: P_STATUS in varchar2 default hr_api.g_varchar2,
494: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
495: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
496: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
497: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
498: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2);
499: -- Access Status:
492: P_OBJECT_VERSION_NUMBER in out nocopy number,
493: P_STATUS in varchar2 default hr_api.g_varchar2,
494: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
495: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
496: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
497: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
498: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2);
499: -- Access Status:
500: -- Internal Development Use Only
493: P_STATUS in varchar2 default hr_api.g_varchar2,
494: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
495: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
496: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
497: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
498: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2);
499: -- Access Status:
500: -- Internal Development Use Only
501: procedure update_dep_os(
494: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
495: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
496: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
497: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
498: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2);
499: -- Access Status:
500: -- Internal Development Use Only
501: procedure update_dep_os(
502: P_VALIDATE in number default hr_api.g_false_num,
498: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2);
499: -- Access Status:
500: -- Internal Development Use Only
501: procedure update_dep_os(
502: P_VALIDATE in number default hr_api.g_false_num,
503: P_ACTION_INFORMATION_ID in number,
504: P_OBJECT_VERSION_NUMBER in out nocopy number,
505: P_STATUS in varchar2 default hr_api.g_varchar2,
506: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
501: procedure update_dep_os(
502: P_VALIDATE in number default hr_api.g_false_num,
503: P_ACTION_INFORMATION_ID in number,
504: P_OBJECT_VERSION_NUMBER in out nocopy number,
505: P_STATUS in varchar2 default hr_api.g_varchar2,
506: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
507: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
508: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
509: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
502: P_VALIDATE in number default hr_api.g_false_num,
503: P_ACTION_INFORMATION_ID in number,
504: P_OBJECT_VERSION_NUMBER in out nocopy number,
505: P_STATUS in varchar2 default hr_api.g_varchar2,
506: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
507: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
508: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
509: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
510: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
503: P_ACTION_INFORMATION_ID in number,
504: P_OBJECT_VERSION_NUMBER in out nocopy number,
505: P_STATUS in varchar2 default hr_api.g_varchar2,
506: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
507: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
508: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
509: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
510: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
511: p_return_status out nocopy varchar2);
504: P_OBJECT_VERSION_NUMBER in out nocopy number,
505: P_STATUS in varchar2 default hr_api.g_varchar2,
506: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
507: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
508: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
509: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
510: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
511: p_return_status out nocopy varchar2);
512: --
505: P_STATUS in varchar2 default hr_api.g_varchar2,
506: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
507: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
508: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
509: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
510: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
511: p_return_status out nocopy varchar2);
512: --
513: end pay_jp_def_api;
506: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
507: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
508: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
509: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
510: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
511: p_return_status out nocopy varchar2);
512: --
513: end pay_jp_def_api;