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.PSP_EFF_REPORT_APPROVALS_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |----------------------< delete_eff_report_approvals >---------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE delete_eff_report_approvals
12: (p_validate in number default hr_api.g_false_num
13: ,p_effort_report_approval_id in number
14: ,p_object_version_number in out nocopy number
15: ,p_return_status out nocopy varchar2
16: ) is

Line 45: hr_api.constant_to_boolean

41: --
42: -- Convert constant values to their corresponding boolean value
43: --
44: l_validate :=
45: hr_api.constant_to_boolean
46: (p_constant_value => p_validate);
47: l_return_status :=
48: hr_api.constant_to_boolean
49: (p_constant_value => p_return_status);

Line 48: hr_api.constant_to_boolean

44: l_validate :=
45: hr_api.constant_to_boolean
46: (p_constant_value => p_validate);
47: l_return_status :=
48: hr_api.constant_to_boolean
49: (p_constant_value => p_return_status);
50: --
51: -- Register Surrogate ID or user key values
52: --

Line 70: hr_api.boolean_to_constant

66: --
67: -- Convert API non-warning boolean parameter values
68: --
69: p_return_status :=
70: hr_api.boolean_to_constant
71: (p_boolean_value => l_return_status
72: );
73: --
74: -- Derive the API return status value based on whether

Line 121: (p_validate in number default hr_api.g_false_num

117: -- ----------------------------------------------------------------------------
118: -- |----------------------< insert_eff_report_approvals >---------------------|
119: -- ----------------------------------------------------------------------------
120: PROCEDURE insert_eff_report_approvals
121: (p_validate in number default hr_api.g_false_num
122: ,p_effort_report_detail_id in number
123: ,p_wf_role_name in varchar2
124: ,p_wf_orig_system_id in number
125: ,p_wf_orig_system in varchar2

Line 201: hr_api.constant_to_boolean

197: --
198: -- Convert constant values to their corresponding boolean value
199: --
200: l_validate :=
201: hr_api.constant_to_boolean
202: (p_constant_value => p_validate);
203: l_return_status :=
204: hr_api.constant_to_boolean
205: (p_constant_value => p_return_status);

Line 204: hr_api.constant_to_boolean

200: l_validate :=
201: hr_api.constant_to_boolean
202: (p_constant_value => p_validate);
203: l_return_status :=
204: hr_api.constant_to_boolean
205: (p_constant_value => p_return_status);
206: --
207: -- Register Surrogate ID or user key values
208: --

Line 278: hr_api.boolean_to_constant

274: --
275: -- Convert API non-warning boolean parameter values
276: --
277: p_return_status :=
278: hr_api.boolean_to_constant
279: (p_boolean_value => l_return_status
280: );
281: --
282: -- Derive the API return status value based on whether

Line 331: (p_validate in number default hr_api.g_false_num

327: -- ----------------------------------------------------------------------------
328: -- |----------------------< update_eff_report_approvals >---------------------|
329: -- ----------------------------------------------------------------------------
330: PROCEDURE update_eff_report_approvals
331: (p_validate in number default hr_api.g_false_num
332: ,p_effort_report_approval_id in number
333: ,p_effort_report_detail_id in number default hr_api.g_number
334: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
335: ,p_wf_orig_system_id in number default hr_api.g_number

Line 333: ,p_effort_report_detail_id in number default hr_api.g_number

329: -- ----------------------------------------------------------------------------
330: PROCEDURE update_eff_report_approvals
331: (p_validate in number default hr_api.g_false_num
332: ,p_effort_report_approval_id in number
333: ,p_effort_report_detail_id in number default hr_api.g_number
334: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
335: ,p_wf_orig_system_id in number default hr_api.g_number
336: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
337: ,p_approver_order_num in number default hr_api.g_number

Line 334: ,p_wf_role_name in varchar2 default hr_api.g_varchar2

330: PROCEDURE update_eff_report_approvals
331: (p_validate in number default hr_api.g_false_num
332: ,p_effort_report_approval_id in number
333: ,p_effort_report_detail_id in number default hr_api.g_number
334: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
335: ,p_wf_orig_system_id in number default hr_api.g_number
336: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
337: ,p_approver_order_num in number default hr_api.g_number
338: ,p_approval_status in varchar2 default hr_api.g_varchar2

Line 335: ,p_wf_orig_system_id in number default hr_api.g_number

331: (p_validate in number default hr_api.g_false_num
332: ,p_effort_report_approval_id in number
333: ,p_effort_report_detail_id in number default hr_api.g_number
334: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
335: ,p_wf_orig_system_id in number default hr_api.g_number
336: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
337: ,p_approver_order_num in number default hr_api.g_number
338: ,p_approval_status in varchar2 default hr_api.g_varchar2
339: ,p_response_date in date default hr_api.g_date

Line 336: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2

332: ,p_effort_report_approval_id in number
333: ,p_effort_report_detail_id in number default hr_api.g_number
334: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
335: ,p_wf_orig_system_id in number default hr_api.g_number
336: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
337: ,p_approver_order_num in number default hr_api.g_number
338: ,p_approval_status in varchar2 default hr_api.g_varchar2
339: ,p_response_date in date default hr_api.g_date
340: ,p_actual_cost_share in number default hr_api.g_number

Line 337: ,p_approver_order_num in number default hr_api.g_number

333: ,p_effort_report_detail_id in number default hr_api.g_number
334: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
335: ,p_wf_orig_system_id in number default hr_api.g_number
336: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
337: ,p_approver_order_num in number default hr_api.g_number
338: ,p_approval_status in varchar2 default hr_api.g_varchar2
339: ,p_response_date in date default hr_api.g_date
340: ,p_actual_cost_share in number default hr_api.g_number
341: ,p_overwritten_effort_percent in number default hr_api.g_number

Line 338: ,p_approval_status in varchar2 default hr_api.g_varchar2

334: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
335: ,p_wf_orig_system_id in number default hr_api.g_number
336: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
337: ,p_approver_order_num in number default hr_api.g_number
338: ,p_approval_status in varchar2 default hr_api.g_varchar2
339: ,p_response_date in date default hr_api.g_date
340: ,p_actual_cost_share in number default hr_api.g_number
341: ,p_overwritten_effort_percent in number default hr_api.g_number
342: ,p_wf_item_key in varchar2 default hr_api.g_varchar2

Line 339: ,p_response_date in date default hr_api.g_date

335: ,p_wf_orig_system_id in number default hr_api.g_number
336: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
337: ,p_approver_order_num in number default hr_api.g_number
338: ,p_approval_status in varchar2 default hr_api.g_varchar2
339: ,p_response_date in date default hr_api.g_date
340: ,p_actual_cost_share in number default hr_api.g_number
341: ,p_overwritten_effort_percent in number default hr_api.g_number
342: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
343: ,p_comments in varchar2 default hr_api.g_varchar2

Line 340: ,p_actual_cost_share in number default hr_api.g_number

336: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
337: ,p_approver_order_num in number default hr_api.g_number
338: ,p_approval_status in varchar2 default hr_api.g_varchar2
339: ,p_response_date in date default hr_api.g_date
340: ,p_actual_cost_share in number default hr_api.g_number
341: ,p_overwritten_effort_percent in number default hr_api.g_number
342: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
343: ,p_comments in varchar2 default hr_api.g_varchar2
344: ,p_pera_information_category in varchar2 default hr_api.g_varchar2

Line 341: ,p_overwritten_effort_percent in number default hr_api.g_number

337: ,p_approver_order_num in number default hr_api.g_number
338: ,p_approval_status in varchar2 default hr_api.g_varchar2
339: ,p_response_date in date default hr_api.g_date
340: ,p_actual_cost_share in number default hr_api.g_number
341: ,p_overwritten_effort_percent in number default hr_api.g_number
342: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
343: ,p_comments in varchar2 default hr_api.g_varchar2
344: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
345: ,p_pera_information1 in varchar2 default hr_api.g_varchar2

Line 342: ,p_wf_item_key in varchar2 default hr_api.g_varchar2

338: ,p_approval_status in varchar2 default hr_api.g_varchar2
339: ,p_response_date in date default hr_api.g_date
340: ,p_actual_cost_share in number default hr_api.g_number
341: ,p_overwritten_effort_percent in number default hr_api.g_number
342: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
343: ,p_comments in varchar2 default hr_api.g_varchar2
344: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
345: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
346: ,p_pera_information2 in varchar2 default hr_api.g_varchar2

Line 343: ,p_comments in varchar2 default hr_api.g_varchar2

339: ,p_response_date in date default hr_api.g_date
340: ,p_actual_cost_share in number default hr_api.g_number
341: ,p_overwritten_effort_percent in number default hr_api.g_number
342: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
343: ,p_comments in varchar2 default hr_api.g_varchar2
344: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
345: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
346: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
347: ,p_pera_information3 in varchar2 default hr_api.g_varchar2

Line 344: ,p_pera_information_category in varchar2 default hr_api.g_varchar2

340: ,p_actual_cost_share in number default hr_api.g_number
341: ,p_overwritten_effort_percent in number default hr_api.g_number
342: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
343: ,p_comments in varchar2 default hr_api.g_varchar2
344: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
345: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
346: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
347: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
348: ,p_pera_information4 in varchar2 default hr_api.g_varchar2

Line 345: ,p_pera_information1 in varchar2 default hr_api.g_varchar2

341: ,p_overwritten_effort_percent in number default hr_api.g_number
342: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
343: ,p_comments in varchar2 default hr_api.g_varchar2
344: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
345: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
346: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
347: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
348: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
349: ,p_pera_information5 in varchar2 default hr_api.g_varchar2

Line 346: ,p_pera_information2 in varchar2 default hr_api.g_varchar2

342: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
343: ,p_comments in varchar2 default hr_api.g_varchar2
344: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
345: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
346: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
347: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
348: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
349: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
350: ,p_pera_information6 in varchar2 default hr_api.g_varchar2

Line 347: ,p_pera_information3 in varchar2 default hr_api.g_varchar2

343: ,p_comments in varchar2 default hr_api.g_varchar2
344: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
345: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
346: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
347: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
348: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
349: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
350: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
351: ,p_pera_information7 in varchar2 default hr_api.g_varchar2

Line 348: ,p_pera_information4 in varchar2 default hr_api.g_varchar2

344: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
345: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
346: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
347: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
348: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
349: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
350: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
351: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
352: ,p_pera_information8 in varchar2 default hr_api.g_varchar2

Line 349: ,p_pera_information5 in varchar2 default hr_api.g_varchar2

345: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
346: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
347: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
348: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
349: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
350: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
351: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
352: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
353: ,p_pera_information9 in varchar2 default hr_api.g_varchar2

Line 350: ,p_pera_information6 in varchar2 default hr_api.g_varchar2

346: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
347: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
348: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
349: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
350: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
351: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
352: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
353: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
354: ,p_pera_information10 in varchar2 default hr_api.g_varchar2

Line 351: ,p_pera_information7 in varchar2 default hr_api.g_varchar2

347: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
348: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
349: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
350: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
351: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
352: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
353: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
354: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
355: ,p_pera_information11 in varchar2 default hr_api.g_varchar2

Line 352: ,p_pera_information8 in varchar2 default hr_api.g_varchar2

348: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
349: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
350: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
351: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
352: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
353: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
354: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
355: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
356: ,p_pera_information12 in varchar2 default hr_api.g_varchar2

Line 353: ,p_pera_information9 in varchar2 default hr_api.g_varchar2

349: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
350: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
351: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
352: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
353: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
354: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
355: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
356: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
357: ,p_pera_information13 in varchar2 default hr_api.g_varchar2

Line 354: ,p_pera_information10 in varchar2 default hr_api.g_varchar2

350: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
351: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
352: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
353: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
354: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
355: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
356: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
357: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
358: ,p_pera_information14 in varchar2 default hr_api.g_varchar2

Line 355: ,p_pera_information11 in varchar2 default hr_api.g_varchar2

351: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
352: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
353: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
354: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
355: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
356: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
357: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
358: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
359: ,p_pera_information15 in varchar2 default hr_api.g_varchar2

Line 356: ,p_pera_information12 in varchar2 default hr_api.g_varchar2

352: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
353: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
354: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
355: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
356: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
357: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
358: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
359: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
360: ,p_pera_information16 in varchar2 default hr_api.g_varchar2

Line 357: ,p_pera_information13 in varchar2 default hr_api.g_varchar2

353: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
354: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
355: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
356: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
357: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
358: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
359: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
360: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
361: ,p_pera_information17 in varchar2 default hr_api.g_varchar2

Line 358: ,p_pera_information14 in varchar2 default hr_api.g_varchar2

354: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
355: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
356: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
357: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
358: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
359: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
360: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
361: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
362: ,p_pera_information18 in varchar2 default hr_api.g_varchar2

Line 359: ,p_pera_information15 in varchar2 default hr_api.g_varchar2

355: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
356: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
357: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
358: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
359: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
360: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
361: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
362: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
363: ,p_pera_information19 in varchar2 default hr_api.g_varchar2

Line 360: ,p_pera_information16 in varchar2 default hr_api.g_varchar2

356: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
357: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
358: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
359: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
360: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
361: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
362: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
363: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
364: ,p_pera_information20 in varchar2 default hr_api.g_varchar2

Line 361: ,p_pera_information17 in varchar2 default hr_api.g_varchar2

357: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
358: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
359: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
360: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
361: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
362: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
363: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
364: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
365: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2

Line 362: ,p_pera_information18 in varchar2 default hr_api.g_varchar2

358: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
359: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
360: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
361: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
362: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
363: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
364: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
365: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
366: ,p_eff_information_category in varchar2 default hr_api.g_varchar2

Line 363: ,p_pera_information19 in varchar2 default hr_api.g_varchar2

359: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
360: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
361: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
362: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
363: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
364: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
365: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
366: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
367: ,p_eff_information1 in varchar2 default hr_api.g_varchar2

Line 364: ,p_pera_information20 in varchar2 default hr_api.g_varchar2

360: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
361: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
362: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
363: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
364: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
365: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
366: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
367: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
368: ,p_eff_information2 in varchar2 default hr_api.g_varchar2

Line 365: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2

361: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
362: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
363: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
364: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
365: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
366: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
367: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
368: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
369: ,p_eff_information3 in varchar2 default hr_api.g_varchar2

Line 366: ,p_eff_information_category in varchar2 default hr_api.g_varchar2

362: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
363: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
364: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
365: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
366: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
367: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
368: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
369: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
370: ,p_eff_information4 in varchar2 default hr_api.g_varchar2

Line 367: ,p_eff_information1 in varchar2 default hr_api.g_varchar2

363: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
364: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
365: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
366: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
367: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
368: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
369: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
370: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
371: ,p_eff_information5 in varchar2 default hr_api.g_varchar2

Line 368: ,p_eff_information2 in varchar2 default hr_api.g_varchar2

364: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
365: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
366: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
367: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
368: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
369: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
370: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
371: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
372: ,p_eff_information6 in varchar2 default hr_api.g_varchar2

Line 369: ,p_eff_information3 in varchar2 default hr_api.g_varchar2

365: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
366: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
367: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
368: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
369: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
370: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
371: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
372: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
373: ,p_eff_information7 in varchar2 default hr_api.g_varchar2

Line 370: ,p_eff_information4 in varchar2 default hr_api.g_varchar2

366: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
367: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
368: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
369: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
370: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
371: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
372: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
373: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
374: ,p_eff_information8 in varchar2 default hr_api.g_varchar2

Line 371: ,p_eff_information5 in varchar2 default hr_api.g_varchar2

367: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
368: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
369: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
370: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
371: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
372: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
373: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
374: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
375: ,p_eff_information9 in varchar2 default hr_api.g_varchar2

Line 372: ,p_eff_information6 in varchar2 default hr_api.g_varchar2

368: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
369: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
370: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
371: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
372: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
373: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
374: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
375: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
376: ,p_eff_information10 in varchar2 default hr_api.g_varchar2

Line 373: ,p_eff_information7 in varchar2 default hr_api.g_varchar2

369: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
370: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
371: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
372: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
373: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
374: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
375: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
376: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
377: ,p_eff_information11 in varchar2 default hr_api.g_varchar2

Line 374: ,p_eff_information8 in varchar2 default hr_api.g_varchar2

370: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
371: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
372: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
373: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
374: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
375: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
376: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
377: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
378: ,p_eff_information12 in varchar2 default hr_api.g_varchar2

Line 375: ,p_eff_information9 in varchar2 default hr_api.g_varchar2

371: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
372: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
373: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
374: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
375: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
376: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
377: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
378: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
379: ,p_eff_information13 in varchar2 default hr_api.g_varchar2

Line 376: ,p_eff_information10 in varchar2 default hr_api.g_varchar2

372: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
373: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
374: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
375: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
376: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
377: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
378: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
379: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
380: ,p_eff_information14 in varchar2 default hr_api.g_varchar2

Line 377: ,p_eff_information11 in varchar2 default hr_api.g_varchar2

373: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
374: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
375: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
376: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
377: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
378: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
379: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
380: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
381: ,p_eff_information15 in varchar2 default hr_api.g_varchar2

Line 378: ,p_eff_information12 in varchar2 default hr_api.g_varchar2

374: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
375: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
376: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
377: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
378: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
379: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
380: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
381: ,p_eff_information15 in varchar2 default hr_api.g_varchar2
382: ,p_object_version_number in out nocopy number

Line 379: ,p_eff_information13 in varchar2 default hr_api.g_varchar2

375: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
376: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
377: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
378: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
379: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
380: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
381: ,p_eff_information15 in varchar2 default hr_api.g_varchar2
382: ,p_object_version_number in out nocopy number
383: ,p_return_status out nocopy varchar2

Line 380: ,p_eff_information14 in varchar2 default hr_api.g_varchar2

376: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
377: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
378: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
379: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
380: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
381: ,p_eff_information15 in varchar2 default hr_api.g_varchar2
382: ,p_object_version_number in out nocopy number
383: ,p_return_status out nocopy varchar2
384: ) is

Line 381: ,p_eff_information15 in varchar2 default hr_api.g_varchar2

377: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
378: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
379: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
380: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
381: ,p_eff_information15 in varchar2 default hr_api.g_varchar2
382: ,p_object_version_number in out nocopy number
383: ,p_return_status out nocopy varchar2
384: ) is
385: --

Line 413: hr_api.constant_to_boolean

409: --
410: -- Convert constant values to their corresponding boolean value
411: --
412: l_validate :=
413: hr_api.constant_to_boolean
414: (p_constant_value => p_validate);
415: l_return_status :=
416: hr_api.constant_to_boolean
417: (p_constant_value => p_return_status);

Line 416: hr_api.constant_to_boolean

412: l_validate :=
413: hr_api.constant_to_boolean
414: (p_constant_value => p_validate);
415: l_return_status :=
416: hr_api.constant_to_boolean
417: (p_constant_value => p_return_status);
418: --
419: -- Register Surrogate ID or user key values
420: --

Line 487: hr_api.boolean_to_constant

483: --
484: -- Convert API non-warning boolean parameter values
485: --
486: p_return_status :=
487: hr_api.boolean_to_constant
488: (p_boolean_value => l_return_status
489: );
490: --
491: -- Derive the API return status value based on whether