eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_DEF_API dependencies on HR_API

Line 17: if p_number = hr_api.g_number then

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;

Line 18: return hr_api.g_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;
22: end if;

Line 31: if p_date = hr_api.g_date then

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;

Line 32: return hr_api.g_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;
36: end if;

Line 80: P_VALIDATE in number default hr_api.g_false_num,

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,

Line 83: P_SUBMISSION_PERIOD_STATUS in varchar2 default hr_api.g_varchar2,

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,

Line 84: P_SUBMISSION_START_DATE in date default hr_api.g_date,

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,

Line 85: P_SUBMISSION_END_DATE in date default hr_api.g_date,

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)

Line 86: P_TAX_OFFICE_NAME in varchar2 default hr_api.g_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

Line 87: P_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,

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;

Line 88: P_SALARY_PAYER_ADDRESS 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;
92: begin

Line 150: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,

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,

Line 151: P_FINALIZED_DATE in date default hr_api.g_date,

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,

Line 152: P_FINALIZED_BY in number default hr_api.g_number,

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)

Line 153: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,

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

Line 154: P_ADMIN_COMMENTS in varchar2 default hr_api.g_varchar2,

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

Line 155: P_TRANSFER_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
159: pay_action_information_api.update_action_information(

Line 156: P_EXPIRY_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(
160: P_VALIDATE => P_VALIDATE,

Line 179: P_VALIDATE in number default hr_api.g_false_num,

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,

Line 182: P_TRANSACTION_STATUS in varchar2 default hr_api.g_varchar2,

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,

Line 183: P_FINALIZED_DATE in date default hr_api.g_date,

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,

Line 184: P_FINALIZED_BY in number default hr_api.g_number,

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,

Line 185: P_USER_COMMENTS in varchar2 default hr_api.g_varchar2,

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)

Line 186: P_ADMIN_COMMENTS in varchar2 default hr_api.g_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

Line 187: P_TRANSFER_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
191: l_api_updating boolean;

Line 188: P_EXPIRY_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;
192: l_transaction_status varchar2(30) := p_transaction_status;

Line 194: if l_transaction_status = hr_api.g_varchar2 then

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

Line 310: P_VALIDATE in number default hr_api.g_false_num,

306: -- |---------------------------------------------------------------------------|
307: -- |------------------------------< update_emp >-------------------------------|
308: -- |---------------------------------------------------------------------------|
309: procedure update_emp(
310: P_VALIDATE in number default hr_api.g_false_num,
311: P_ACTION_INFORMATION_ID in number,
312: P_OBJECT_VERSION_NUMBER in out nocopy number,
313: p_postal_code in varchar2 default hr_api.g_varchar2,
314: p_address in varchar2 default hr_api.g_varchar2,

Line 313: p_postal_code in varchar2 default hr_api.g_varchar2,

309: procedure update_emp(
310: P_VALIDATE in number default hr_api.g_false_num,
311: P_ACTION_INFORMATION_ID in number,
312: P_OBJECT_VERSION_NUMBER in out nocopy number,
313: p_postal_code in varchar2 default hr_api.g_varchar2,
314: p_address in varchar2 default hr_api.g_varchar2,
315: P_CHANGE_DATE in date default hr_api.g_date,
316: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
317: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,

Line 314: p_address in varchar2 default hr_api.g_varchar2,

310: P_VALIDATE in number default hr_api.g_false_num,
311: P_ACTION_INFORMATION_ID in number,
312: P_OBJECT_VERSION_NUMBER in out nocopy number,
313: p_postal_code in varchar2 default hr_api.g_varchar2,
314: p_address in varchar2 default hr_api.g_varchar2,
315: P_CHANGE_DATE in date default hr_api.g_date,
316: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
317: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
318: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,

Line 315: P_CHANGE_DATE in date default hr_api.g_date,

311: P_ACTION_INFORMATION_ID in number,
312: P_OBJECT_VERSION_NUMBER in out nocopy number,
313: p_postal_code in varchar2 default hr_api.g_varchar2,
314: p_address in varchar2 default hr_api.g_varchar2,
315: P_CHANGE_DATE in date default hr_api.g_date,
316: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
317: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
318: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
319: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,

Line 316: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,

312: P_OBJECT_VERSION_NUMBER in out nocopy number,
313: p_postal_code in varchar2 default hr_api.g_varchar2,
314: p_address in varchar2 default hr_api.g_varchar2,
315: P_CHANGE_DATE in date default hr_api.g_date,
316: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
317: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
318: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
319: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
320: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,

Line 317: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,

313: p_postal_code in varchar2 default hr_api.g_varchar2,
314: p_address in varchar2 default hr_api.g_varchar2,
315: P_CHANGE_DATE in date default hr_api.g_date,
316: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
317: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
318: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
319: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
320: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
321: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,

Line 318: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,

314: p_address in varchar2 default hr_api.g_varchar2,
315: P_CHANGE_DATE in date default hr_api.g_date,
316: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
317: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
318: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
319: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
320: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
321: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
322: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,

Line 319: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,

315: P_CHANGE_DATE in date default hr_api.g_date,
316: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
317: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
318: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
319: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
320: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
321: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
322: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
323: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,

Line 320: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,

316: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
317: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
318: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
319: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
320: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
321: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
322: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
323: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
324: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,

Line 321: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,

317: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
318: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
319: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
320: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
321: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
322: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
323: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
324: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
325: p_employee_number in varchar2 default hr_api.g_varchar2,

Line 322: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,

318: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
319: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
320: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
321: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
322: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
323: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
324: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
325: p_employee_number in varchar2 default hr_api.g_varchar2,
326: p_district_name in varchar2 default hr_api.g_varchar2,

Line 323: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,

319: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
320: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
321: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
322: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
323: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
324: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
325: p_employee_number in varchar2 default hr_api.g_varchar2,
326: p_district_name in varchar2 default hr_api.g_varchar2,
327: p_sec_sal_submit_flag in varchar2 default hr_api.g_varchar2,

Line 324: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,

320: P_AGED_DETAILS in varchar2 default hr_api.g_varchar2,
321: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
322: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
323: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
324: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
325: p_employee_number in varchar2 default hr_api.g_varchar2,
326: p_district_name in varchar2 default hr_api.g_varchar2,
327: p_sec_sal_submit_flag in varchar2 default hr_api.g_varchar2,
328: p_return_status out nocopy varchar2)

Line 325: p_employee_number in varchar2 default hr_api.g_varchar2,

321: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
322: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
323: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
324: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
325: p_employee_number in varchar2 default hr_api.g_varchar2,
326: p_district_name in varchar2 default hr_api.g_varchar2,
327: p_sec_sal_submit_flag in varchar2 default hr_api.g_varchar2,
328: p_return_status out nocopy varchar2)
329: is

Line 326: p_district_name in varchar2 default hr_api.g_varchar2,

322: P_WIDOW_DETAILS in varchar2 default hr_api.g_varchar2,
323: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
324: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
325: p_employee_number in varchar2 default hr_api.g_varchar2,
326: p_district_name in varchar2 default hr_api.g_varchar2,
327: p_sec_sal_submit_flag in varchar2 default hr_api.g_varchar2,
328: p_return_status out nocopy varchar2)
329: is
330: begin

Line 327: p_sec_sal_submit_flag in varchar2 default hr_api.g_varchar2,

323: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
324: P_WORKING_STUDENT_DETAILS in varchar2 default hr_api.g_varchar2,
325: p_employee_number in varchar2 default hr_api.g_varchar2,
326: p_district_name in varchar2 default hr_api.g_varchar2,
327: p_sec_sal_submit_flag in varchar2 default hr_api.g_varchar2,
328: p_return_status out nocopy varchar2)
329: is
330: begin
331: --

Line 443: P_STATUS in varchar2 default hr_api.g_varchar2,

439: procedure update_entry(
440: P_VALIDATE in boolean default false,
441: P_ACTION_INFORMATION_ID in number,
442: P_OBJECT_VERSION_NUMBER in out nocopy number,
443: P_STATUS in varchar2 default hr_api.g_varchar2,
444: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
445: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
446: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
447: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,

Line 444: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,

440: P_VALIDATE in boolean default false,
441: P_ACTION_INFORMATION_ID in number,
442: P_OBJECT_VERSION_NUMBER in out nocopy number,
443: P_STATUS in varchar2 default hr_api.g_varchar2,
444: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
445: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
446: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
447: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
448: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,

Line 445: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,

441: P_ACTION_INFORMATION_ID in number,
442: P_OBJECT_VERSION_NUMBER in out nocopy number,
443: P_STATUS in varchar2 default hr_api.g_varchar2,
444: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
445: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
446: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
447: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
448: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
449: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,

Line 446: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,

442: P_OBJECT_VERSION_NUMBER in out nocopy number,
443: P_STATUS in varchar2 default hr_api.g_varchar2,
444: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
445: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
446: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
447: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
448: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
449: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
450: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,

Line 447: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,

443: P_STATUS in varchar2 default hr_api.g_varchar2,
444: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
445: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
446: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
447: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
448: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
449: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
450: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
451: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,

Line 448: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,

444: P_ELEMENT_ENTRY_ID in number default hr_api.g_number,
445: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
446: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
447: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
448: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
449: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
450: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
451: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
452: P_NUM_DEPS in number default hr_api.g_number,

Line 449: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,

445: P_EE_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
446: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
447: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
448: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
449: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
450: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
451: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
452: P_NUM_DEPS in number default hr_api.g_number,
453: P_NUM_AGEDS in number default hr_api.g_number,

Line 450: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,

446: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
447: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
448: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
449: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
450: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
451: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
452: P_NUM_DEPS in number default hr_api.g_number,
453: P_NUM_AGEDS in number default hr_api.g_number,
454: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,

Line 451: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,

447: P_AGED_TYPE in varchar2 default hr_api.g_varchar2,
448: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
449: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
450: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
451: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
452: P_NUM_DEPS in number default hr_api.g_number,
453: P_NUM_AGEDS in number default hr_api.g_number,
454: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
455: P_NUM_SPECIFIEDS in number default hr_api.g_number,

Line 452: P_NUM_DEPS in number default hr_api.g_number,

448: P_WIDOW_TYPE in varchar2 default hr_api.g_varchar2,
449: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
450: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
451: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
452: P_NUM_DEPS in number default hr_api.g_number,
453: P_NUM_AGEDS in number default hr_api.g_number,
454: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
455: P_NUM_SPECIFIEDS in number default hr_api.g_number,
456: P_NUM_DISABLEDS in number default hr_api.g_number,

Line 453: P_NUM_AGEDS in number default hr_api.g_number,

449: P_WORKING_STUDENT_TYPE in varchar2 default hr_api.g_varchar2,
450: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
451: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
452: P_NUM_DEPS in number default hr_api.g_number,
453: P_NUM_AGEDS in number default hr_api.g_number,
454: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
455: P_NUM_SPECIFIEDS in number default hr_api.g_number,
456: P_NUM_DISABLEDS in number default hr_api.g_number,
457: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,

Line 454: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,

450: P_SPOUSE_DEP_TYPE in varchar2 default hr_api.g_varchar2,
451: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
452: P_NUM_DEPS in number default hr_api.g_number,
453: P_NUM_AGEDS in number default hr_api.g_number,
454: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
455: P_NUM_SPECIFIEDS in number default hr_api.g_number,
456: P_NUM_DISABLEDS in number default hr_api.g_number,
457: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
458: P_NUM_SVR_DISABLEDS_LT in number default hr_api.g_number)

Line 455: P_NUM_SPECIFIEDS in number default hr_api.g_number,

451: P_SPOUSE_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
452: P_NUM_DEPS in number default hr_api.g_number,
453: P_NUM_AGEDS in number default hr_api.g_number,
454: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
455: P_NUM_SPECIFIEDS in number default hr_api.g_number,
456: P_NUM_DISABLEDS in number default hr_api.g_number,
457: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
458: P_NUM_SVR_DISABLEDS_LT in number default hr_api.g_number)
459: is

Line 456: P_NUM_DISABLEDS in number default hr_api.g_number,

452: P_NUM_DEPS in number default hr_api.g_number,
453: P_NUM_AGEDS in number default hr_api.g_number,
454: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
455: P_NUM_SPECIFIEDS in number default hr_api.g_number,
456: P_NUM_DISABLEDS in number default hr_api.g_number,
457: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
458: P_NUM_SVR_DISABLEDS_LT in number default hr_api.g_number)
459: is
460: begin

Line 457: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,

453: P_NUM_AGEDS in number default hr_api.g_number,
454: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
455: P_NUM_SPECIFIEDS in number default hr_api.g_number,
456: P_NUM_DISABLEDS in number default hr_api.g_number,
457: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
458: P_NUM_SVR_DISABLEDS_LT in number default hr_api.g_number)
459: is
460: begin
461: pay_action_information_api.update_action_information(

Line 458: P_NUM_SVR_DISABLEDS_LT in number default hr_api.g_number)

454: P_NUM_AGED_PARENTS_LT in number default hr_api.g_number,
455: P_NUM_SPECIFIEDS in number default hr_api.g_number,
456: P_NUM_DISABLEDS in number default hr_api.g_number,
457: P_NUM_SVR_DISABLEDS in number default hr_api.g_number,
458: P_NUM_SVR_DISABLEDS_LT in number default hr_api.g_number)
459: is
460: begin
461: pay_action_information_api.update_action_information(
462: P_VALIDATE => P_VALIDATE,

Line 558: P_VALIDATE in number default hr_api.g_false_num,

554: P_OBJECT_VERSION_NUMBER => p_object_version_number);
555: end create_dep;
556: --
557: procedure create_dep(
558: P_VALIDATE in number default hr_api.g_false_num,
559: P_ACTION_INFORMATION_ID in number,
560: P_ASSIGNMENT_ACTION_ID in number,
561: P_EFFECTIVE_DATE in date,
562: P_ASSIGNMENT_ID in number,

Line 637: P_STATUS in varchar2 default hr_api.g_varchar2,

633: procedure update_dep(
634: P_VALIDATE in boolean default false,
635: P_ACTION_INFORMATION_ID in number,
636: P_OBJECT_VERSION_NUMBER in out nocopy number,
637: P_STATUS in varchar2 default hr_api.g_varchar2,
638: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
639: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
640: P_CHANGE_DATE in date default hr_api.g_date,
641: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,

Line 638: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,

634: P_VALIDATE in boolean default false,
635: P_ACTION_INFORMATION_ID in number,
636: P_OBJECT_VERSION_NUMBER in out nocopy number,
637: P_STATUS in varchar2 default hr_api.g_varchar2,
638: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
639: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
640: P_CHANGE_DATE in date default hr_api.g_date,
641: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
642: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,

Line 639: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,

635: P_ACTION_INFORMATION_ID in number,
636: P_OBJECT_VERSION_NUMBER in out nocopy number,
637: P_STATUS in varchar2 default hr_api.g_varchar2,
638: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
639: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
640: P_CHANGE_DATE in date default hr_api.g_date,
641: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
642: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
643: P_OCCUPATION in varchar2 default hr_api.g_varchar2,

Line 640: P_CHANGE_DATE in date default hr_api.g_date,

636: P_OBJECT_VERSION_NUMBER in out nocopy number,
637: P_STATUS in varchar2 default hr_api.g_varchar2,
638: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
639: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
640: P_CHANGE_DATE in date default hr_api.g_date,
641: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
642: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
643: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
644: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,

Line 641: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,

637: P_STATUS in varchar2 default hr_api.g_varchar2,
638: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
639: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
640: P_CHANGE_DATE in date default hr_api.g_date,
641: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
642: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
643: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
644: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
645: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,

Line 642: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,

638: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
639: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
640: P_CHANGE_DATE in date default hr_api.g_date,
641: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
642: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
643: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
644: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
645: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
646: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,

Line 643: P_OCCUPATION in varchar2 default hr_api.g_varchar2,

639: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
640: P_CHANGE_DATE in date default hr_api.g_date,
641: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
642: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
643: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
644: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
645: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
646: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
647: p_address in varchar2 default hr_api.g_varchar2)

Line 644: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,

640: P_CHANGE_DATE in date default hr_api.g_date,
641: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
642: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
643: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
644: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
645: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
646: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
647: p_address in varchar2 default hr_api.g_varchar2)
648: is

Line 645: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,

641: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
642: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
643: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
644: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
645: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
646: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
647: p_address in varchar2 default hr_api.g_varchar2)
648: is
649: begin

Line 646: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,

642: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
643: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
644: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
645: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
646: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
647: p_address in varchar2 default hr_api.g_varchar2)
648: is
649: begin
650: --

Line 647: p_address in varchar2 default hr_api.g_varchar2)

643: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
644: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
645: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
646: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
647: p_address in varchar2 default hr_api.g_varchar2)
648: is
649: begin
650: --
651: pay_action_information_api.update_action_information(

Line 670: P_VALIDATE in number default hr_api.g_false_num,

666: --
667: end update_dep;
668: --
669: procedure update_dep(
670: P_VALIDATE in number default hr_api.g_false_num,
671: P_ACTION_INFORMATION_ID in number,
672: P_OBJECT_VERSION_NUMBER in out nocopy number,
673: P_STATUS in varchar2 default hr_api.g_varchar2,
674: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,

Line 673: P_STATUS in varchar2 default hr_api.g_varchar2,

669: procedure update_dep(
670: P_VALIDATE in number default hr_api.g_false_num,
671: P_ACTION_INFORMATION_ID in number,
672: P_OBJECT_VERSION_NUMBER in out nocopy number,
673: P_STATUS in varchar2 default hr_api.g_varchar2,
674: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
675: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
676: P_CHANGE_DATE in date default hr_api.g_date,
677: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,

Line 674: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,

670: P_VALIDATE in number default hr_api.g_false_num,
671: P_ACTION_INFORMATION_ID in number,
672: P_OBJECT_VERSION_NUMBER in out nocopy number,
673: P_STATUS in varchar2 default hr_api.g_varchar2,
674: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
675: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
676: P_CHANGE_DATE in date default hr_api.g_date,
677: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
678: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,

Line 675: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,

671: P_ACTION_INFORMATION_ID in number,
672: P_OBJECT_VERSION_NUMBER in out nocopy number,
673: P_STATUS in varchar2 default hr_api.g_varchar2,
674: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
675: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
676: P_CHANGE_DATE in date default hr_api.g_date,
677: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
678: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
679: P_OCCUPATION in varchar2 default hr_api.g_varchar2,

Line 676: P_CHANGE_DATE in date default hr_api.g_date,

672: P_OBJECT_VERSION_NUMBER in out nocopy number,
673: P_STATUS in varchar2 default hr_api.g_varchar2,
674: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
675: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
676: P_CHANGE_DATE in date default hr_api.g_date,
677: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
678: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
679: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
680: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,

Line 677: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,

673: P_STATUS in varchar2 default hr_api.g_varchar2,
674: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
675: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
676: P_CHANGE_DATE in date default hr_api.g_date,
677: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
678: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
679: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
680: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
681: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,

Line 678: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,

674: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
675: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
676: P_CHANGE_DATE in date default hr_api.g_date,
677: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
678: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
679: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
680: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
681: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
682: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,

Line 679: P_OCCUPATION in varchar2 default hr_api.g_varchar2,

675: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
676: P_CHANGE_DATE in date default hr_api.g_date,
677: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
678: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
679: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
680: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
681: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
682: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
683: p_address in varchar2 default hr_api.g_varchar2,

Line 680: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,

676: P_CHANGE_DATE in date default hr_api.g_date,
677: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
678: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
679: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
680: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
681: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
682: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
683: p_address in varchar2 default hr_api.g_varchar2,
684: p_return_status out nocopy varchar2)

Line 681: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,

677: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
678: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
679: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
680: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
681: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
682: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
683: p_address in varchar2 default hr_api.g_varchar2,
684: p_return_status out nocopy varchar2)
685: is

Line 682: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,

678: P_DEP_TYPE in varchar2 default hr_api.g_varchar2,
679: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
680: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
681: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
682: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
683: p_address in varchar2 default hr_api.g_varchar2,
684: p_return_status out nocopy varchar2)
685: is
686: begin

Line 683: p_address in varchar2 default hr_api.g_varchar2,

679: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
680: P_ESTIMATED_ANNUAL_INCOME in number default hr_api.g_number,
681: P_DISABILITY_TYPE in varchar2 default hr_api.g_varchar2,
682: P_DISABILITY_DETAILS in varchar2 default hr_api.g_varchar2,
683: p_address in varchar2 default hr_api.g_varchar2,
684: p_return_status out nocopy varchar2)
685: is
686: begin
687: --

Line 776: P_VALIDATE in number default hr_api.g_false_num,

772: P_OBJECT_VERSION_NUMBER => p_object_version_number);
773: end create_dep_oe;
774: --
775: procedure create_dep_oe(
776: P_VALIDATE in number default hr_api.g_false_num,
777: P_ACTION_INFORMATION_ID in number,
778: P_ASSIGNMENT_ACTION_ID in number,
779: P_EFFECTIVE_DATE in date,
780: P_ASSIGNMENT_ID in number,

Line 849: P_STATUS in varchar2 default hr_api.g_varchar2,

845: procedure update_dep_oe(
846: P_VALIDATE in boolean default false,
847: P_ACTION_INFORMATION_ID in number,
848: P_OBJECT_VERSION_NUMBER in out nocopy number,
849: P_STATUS in varchar2 default hr_api.g_varchar2,
850: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
851: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
852: P_CHANGE_DATE in date default hr_api.g_date,
853: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,

Line 850: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,

846: P_VALIDATE in boolean default false,
847: P_ACTION_INFORMATION_ID in number,
848: P_OBJECT_VERSION_NUMBER in out nocopy number,
849: P_STATUS in varchar2 default hr_api.g_varchar2,
850: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
851: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
852: P_CHANGE_DATE in date default hr_api.g_date,
853: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
854: P_OCCUPATION in varchar2 default hr_api.g_varchar2,

Line 851: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,

847: P_ACTION_INFORMATION_ID in number,
848: P_OBJECT_VERSION_NUMBER in out nocopy number,
849: P_STATUS in varchar2 default hr_api.g_varchar2,
850: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
851: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
852: P_CHANGE_DATE in date default hr_api.g_date,
853: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
854: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
855: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,

Line 852: P_CHANGE_DATE in date default hr_api.g_date,

848: P_OBJECT_VERSION_NUMBER in out nocopy number,
849: P_STATUS in varchar2 default hr_api.g_varchar2,
850: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
851: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
852: P_CHANGE_DATE in date default hr_api.g_date,
853: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
854: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
855: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
856: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,

Line 853: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,

849: P_STATUS in varchar2 default hr_api.g_varchar2,
850: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
851: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
852: P_CHANGE_DATE in date default hr_api.g_date,
853: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
854: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
855: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
856: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
857: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,

Line 854: P_OCCUPATION in varchar2 default hr_api.g_varchar2,

850: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
851: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
852: P_CHANGE_DATE in date default hr_api.g_date,
853: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
854: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
855: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
856: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
857: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
858: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,

Line 855: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,

851: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
852: P_CHANGE_DATE in date default hr_api.g_date,
853: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
854: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
855: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
856: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
857: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
858: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
859: p_address in varchar2 default hr_api.g_varchar2)

Line 856: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,

852: P_CHANGE_DATE in date default hr_api.g_date,
853: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
854: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
855: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
856: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
857: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
858: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
859: p_address in varchar2 default hr_api.g_varchar2)
860: is

Line 857: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,

853: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
854: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
855: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
856: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
857: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
858: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
859: p_address in varchar2 default hr_api.g_varchar2)
860: is
861: begin

Line 858: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,

854: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
855: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
856: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
857: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
858: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
859: p_address in varchar2 default hr_api.g_varchar2)
860: is
861: begin
862: --

Line 859: p_address in varchar2 default hr_api.g_varchar2)

855: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
856: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
857: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
858: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
859: p_address in varchar2 default hr_api.g_varchar2)
860: is
861: begin
862: --
863: pay_action_information_api.update_action_information(

Line 882: P_VALIDATE in number default hr_api.g_false_num,

878: --
879: end update_dep_oe;
880: --
881: procedure update_dep_oe(
882: P_VALIDATE in number default hr_api.g_false_num,
883: P_ACTION_INFORMATION_ID in number,
884: P_OBJECT_VERSION_NUMBER in out nocopy number,
885: P_STATUS in varchar2 default hr_api.g_varchar2,
886: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,

Line 885: P_STATUS in varchar2 default hr_api.g_varchar2,

881: procedure update_dep_oe(
882: P_VALIDATE in number default hr_api.g_false_num,
883: P_ACTION_INFORMATION_ID in number,
884: P_OBJECT_VERSION_NUMBER in out nocopy number,
885: P_STATUS in varchar2 default hr_api.g_varchar2,
886: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
887: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
888: P_CHANGE_DATE in date default hr_api.g_date,
889: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,

Line 886: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,

882: P_VALIDATE in number default hr_api.g_false_num,
883: P_ACTION_INFORMATION_ID in number,
884: P_OBJECT_VERSION_NUMBER in out nocopy number,
885: P_STATUS in varchar2 default hr_api.g_varchar2,
886: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
887: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
888: P_CHANGE_DATE in date default hr_api.g_date,
889: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
890: P_OCCUPATION in varchar2 default hr_api.g_varchar2,

Line 887: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,

883: P_ACTION_INFORMATION_ID in number,
884: P_OBJECT_VERSION_NUMBER in out nocopy number,
885: P_STATUS in varchar2 default hr_api.g_varchar2,
886: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
887: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
888: P_CHANGE_DATE in date default hr_api.g_date,
889: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
890: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
891: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,

Line 888: P_CHANGE_DATE in date default hr_api.g_date,

884: P_OBJECT_VERSION_NUMBER in out nocopy number,
885: P_STATUS in varchar2 default hr_api.g_varchar2,
886: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
887: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
888: P_CHANGE_DATE in date default hr_api.g_date,
889: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
890: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
891: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
892: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,

Line 889: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,

885: P_STATUS in varchar2 default hr_api.g_varchar2,
886: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
887: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
888: P_CHANGE_DATE in date default hr_api.g_date,
889: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
890: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
891: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
892: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
893: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,

Line 890: P_OCCUPATION in varchar2 default hr_api.g_varchar2,

886: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
887: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
888: P_CHANGE_DATE in date default hr_api.g_date,
889: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
890: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
891: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
892: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
893: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
894: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,

Line 891: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,

887: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
888: P_CHANGE_DATE in date default hr_api.g_date,
889: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
890: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
891: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
892: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
893: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
894: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
895: p_address in varchar2 default hr_api.g_varchar2,

Line 892: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,

888: P_CHANGE_DATE in date default hr_api.g_date,
889: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
890: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
891: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
892: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
893: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
894: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
895: p_address in varchar2 default hr_api.g_varchar2,
896: p_return_status out nocopy varchar2)

Line 893: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,

889: P_CHANGE_REASON in varchar2 default hr_api.g_varchar2,
890: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
891: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
892: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
893: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
894: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
895: p_address in varchar2 default hr_api.g_varchar2,
896: p_return_status out nocopy varchar2)
897: is

Line 894: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,

890: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
891: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
892: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
893: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
894: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
895: p_address in varchar2 default hr_api.g_varchar2,
896: p_return_status out nocopy varchar2)
897: is
898: begin

Line 895: p_address in varchar2 default hr_api.g_varchar2,

891: P_OE_CONTACT_RELATIONSHIP_ID in number default hr_api.g_number,
892: P_OE_FULL_NAME in varchar2 default hr_api.g_varchar2,
893: P_OE_CONTACT_TYPE in varchar2 default hr_api.g_varchar2,
894: P_OE_ADDRESS in varchar2 default hr_api.g_varchar2,
895: p_address in varchar2 default hr_api.g_varchar2,
896: p_return_status out nocopy varchar2)
897: is
898: begin
899: --

Line 980: P_VALIDATE in number default hr_api.g_false_num,

976: P_OBJECT_VERSION_NUMBER => p_object_version_number);
977: end create_dep_os;
978: --
979: procedure create_dep_os(
980: P_VALIDATE in number default hr_api.g_false_num,
981: P_ACTION_INFORMATION_ID in number,
982: P_ASSIGNMENT_ACTION_ID in number,
983: P_EFFECTIVE_DATE in date,
984: P_ASSIGNMENT_ID in number,

Line 1045: P_STATUS in varchar2 default hr_api.g_varchar2,

1041: procedure update_dep_os(
1042: P_VALIDATE in boolean default false,
1043: P_ACTION_INFORMATION_ID in number,
1044: P_OBJECT_VERSION_NUMBER in out nocopy number,
1045: P_STATUS in varchar2 default hr_api.g_varchar2,
1046: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1047: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1048: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1049: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,

Line 1046: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,

1042: P_VALIDATE in boolean default false,
1043: P_ACTION_INFORMATION_ID in number,
1044: P_OBJECT_VERSION_NUMBER in out nocopy number,
1045: P_STATUS in varchar2 default hr_api.g_varchar2,
1046: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1047: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1048: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1049: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1050: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2)

Line 1047: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,

1043: P_ACTION_INFORMATION_ID in number,
1044: P_OBJECT_VERSION_NUMBER in out nocopy number,
1045: P_STATUS in varchar2 default hr_api.g_varchar2,
1046: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1047: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1048: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1049: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1050: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2)
1051: is

Line 1048: P_OCCUPATION in varchar2 default hr_api.g_varchar2,

1044: P_OBJECT_VERSION_NUMBER in out nocopy number,
1045: P_STATUS in varchar2 default hr_api.g_varchar2,
1046: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1047: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1048: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1049: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1050: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2)
1051: is
1052: begin

Line 1049: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,

1045: P_STATUS in varchar2 default hr_api.g_varchar2,
1046: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1047: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1048: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1049: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1050: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2)
1051: is
1052: begin
1053: pay_action_information_api.update_action_information(

Line 1050: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2)

1046: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1047: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1048: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1049: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1050: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2)
1051: is
1052: begin
1053: pay_action_information_api.update_action_information(
1054: P_VALIDATE => P_VALIDATE,

Line 1066: P_VALIDATE in number default hr_api.g_false_num,

1062: P_ACTION_INFORMATION18 => P_OS_SALARY_PAYER_ADDRESS);
1063: end update_dep_os;
1064: --
1065: procedure update_dep_os(
1066: P_VALIDATE in number default hr_api.g_false_num,
1067: P_ACTION_INFORMATION_ID in number,
1068: P_OBJECT_VERSION_NUMBER in out nocopy number,
1069: P_STATUS in varchar2 default hr_api.g_varchar2,
1070: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,

Line 1069: P_STATUS in varchar2 default hr_api.g_varchar2,

1065: procedure update_dep_os(
1066: P_VALIDATE in number default hr_api.g_false_num,
1067: P_ACTION_INFORMATION_ID in number,
1068: P_OBJECT_VERSION_NUMBER in out nocopy number,
1069: P_STATUS in varchar2 default hr_api.g_varchar2,
1070: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1071: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1072: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1073: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,

Line 1070: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,

1066: P_VALIDATE in number default hr_api.g_false_num,
1067: P_ACTION_INFORMATION_ID in number,
1068: P_OBJECT_VERSION_NUMBER in out nocopy number,
1069: P_STATUS in varchar2 default hr_api.g_varchar2,
1070: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1071: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1072: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1073: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1074: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,

Line 1071: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,

1067: P_ACTION_INFORMATION_ID in number,
1068: P_OBJECT_VERSION_NUMBER in out nocopy number,
1069: P_STATUS in varchar2 default hr_api.g_varchar2,
1070: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1071: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1072: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1073: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1074: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
1075: p_return_status out nocopy varchar2)

Line 1072: P_OCCUPATION in varchar2 default hr_api.g_varchar2,

1068: P_OBJECT_VERSION_NUMBER in out nocopy number,
1069: P_STATUS in varchar2 default hr_api.g_varchar2,
1070: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1071: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1072: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1073: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1074: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
1075: p_return_status out nocopy varchar2)
1076: is

Line 1073: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,

1069: P_STATUS in varchar2 default hr_api.g_varchar2,
1070: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1071: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1072: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1073: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1074: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
1075: p_return_status out nocopy varchar2)
1076: is
1077: begin

Line 1074: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,

1070: P_CONTACT_EXTRA_INFO_ID in number default hr_api.g_number,
1071: P_CEI_OBJECT_VERSION_NUMBER in number default hr_api.g_number,
1072: P_OCCUPATION in varchar2 default hr_api.g_varchar2,
1073: P_OS_SALARY_PAYER_NAME in varchar2 default hr_api.g_varchar2,
1074: P_OS_SALARY_PAYER_ADDRESS in varchar2 default hr_api.g_varchar2,
1075: p_return_status out nocopy varchar2)
1076: is
1077: begin
1078: pay_action_information_swi.update_action_information(

Line 1129: p_status in varchar2 default hr_api.g_varchar2,

1125: procedure update_entry_os(
1126: p_validate in boolean default false,
1127: p_action_information_id in number,
1128: p_object_version_number in out nocopy number,
1129: p_status in varchar2 default hr_api.g_varchar2,
1130: p_element_entry_id in number default hr_api.g_number,
1131: p_ee_object_version_number in number default hr_api.g_number,
1132: p_sec_sal_submit_flag in varchar2 default hr_api.g_varchar2)
1133: is

Line 1130: p_element_entry_id in number default hr_api.g_number,

1126: p_validate in boolean default false,
1127: p_action_information_id in number,
1128: p_object_version_number in out nocopy number,
1129: p_status in varchar2 default hr_api.g_varchar2,
1130: p_element_entry_id in number default hr_api.g_number,
1131: p_ee_object_version_number in number default hr_api.g_number,
1132: p_sec_sal_submit_flag in varchar2 default hr_api.g_varchar2)
1133: is
1134: begin

Line 1131: p_ee_object_version_number in number default hr_api.g_number,

1127: p_action_information_id in number,
1128: p_object_version_number in out nocopy number,
1129: p_status in varchar2 default hr_api.g_varchar2,
1130: p_element_entry_id in number default hr_api.g_number,
1131: p_ee_object_version_number in number default hr_api.g_number,
1132: p_sec_sal_submit_flag in varchar2 default hr_api.g_varchar2)
1133: is
1134: begin
1135: --

Line 1132: p_sec_sal_submit_flag in varchar2 default hr_api.g_varchar2)

1128: p_object_version_number in out nocopy number,
1129: p_status in varchar2 default hr_api.g_varchar2,
1130: p_element_entry_id in number default hr_api.g_number,
1131: p_ee_object_version_number in number default hr_api.g_number,
1132: p_sec_sal_submit_flag in varchar2 default hr_api.g_varchar2)
1133: is
1134: begin
1135: --
1136: pay_action_information_api.update_action_information(

Line 1177: p_num_junior_deps in number default hr_api.g_number)

1173: procedure update_entry_dep(
1174: p_validate in boolean default false,
1175: p_action_information_id in number,
1176: p_object_version_number in out nocopy number,
1177: p_num_junior_deps in number default hr_api.g_number)
1178: is
1179: begin
1180: --
1181: pay_action_information_api.update_action_information(