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

Line 14: (p_validate in number default hr_api.g_false_num

10: -- ----------------------------------------------------------------------------
11: -- |----------------------< create_statutory_situation >----------------------|
12: -- ----------------------------------------------------------------------------
13: PROCEDURE create_statutory_situation
14: (p_validate in number default hr_api.g_false_num
15: ,p_effective_date in date default null
16: ,p_business_group_id in number
17: ,p_situation_name in varchar2
18: ,p_type_of_ps in varchar2

Line 84: hr_api.constant_to_boolean

80: --
81: -- Convert constant values to their corresponding boolean value
82: --
83: l_validate :=
84: hr_api.constant_to_boolean
85: (p_constant_value => p_validate);
86: --
87: -- Register Surrogate ID or user key values
88: --

Line 210: (p_validate in number default hr_api.g_false_num

206: -- ----------------------------------------------------------------------------
207: -- |----------------------< delete_statutory_situation >----------------------|
208: -- ----------------------------------------------------------------------------
209: PROCEDURE delete_statutory_situation
210: (p_validate in number default hr_api.g_false_num
211: ,p_statutory_situation_id in number
212: ,p_object_version_number in number
213: ,p_return_status out nocopy varchar2
214: ) is

Line 255: hr_api.constant_to_boolean

251: --
252: -- Convert constant values to their corresponding boolean value
253: --
254: l_validate :=
255: hr_api.constant_to_boolean
256: (p_constant_value => p_validate);
257: --
258: -- Register Surrogate ID or user key values
259: --

Line 355: (p_validate in number default hr_api.g_false_num

351: -- ----------------------------------------------------------------------------
352: -- |----------------------< update_statutory_situation >----------------------|
353: -- ----------------------------------------------------------------------------
354: PROCEDURE update_statutory_situation
355: (p_validate in number default hr_api.g_false_num
356: ,p_effective_date in date default hr_api.g_date
357: ,p_statutory_situation_id in number
358: ,p_object_version_number in out nocopy number
359: ,p_business_group_id in number default hr_api.g_number

Line 356: ,p_effective_date in date default hr_api.g_date

352: -- |----------------------< update_statutory_situation >----------------------|
353: -- ----------------------------------------------------------------------------
354: PROCEDURE update_statutory_situation
355: (p_validate in number default hr_api.g_false_num
356: ,p_effective_date in date default hr_api.g_date
357: ,p_statutory_situation_id in number
358: ,p_object_version_number in out nocopy number
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_situation_name in varchar2 default hr_api.g_varchar2

Line 359: ,p_business_group_id in number default hr_api.g_number

355: (p_validate in number default hr_api.g_false_num
356: ,p_effective_date in date default hr_api.g_date
357: ,p_statutory_situation_id in number
358: ,p_object_version_number in out nocopy number
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_situation_name in varchar2 default hr_api.g_varchar2
361: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
362: ,p_situation_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2

Line 360: ,p_situation_name in varchar2 default hr_api.g_varchar2

356: ,p_effective_date in date default hr_api.g_date
357: ,p_statutory_situation_id in number
358: ,p_object_version_number in out nocopy number
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_situation_name in varchar2 default hr_api.g_varchar2
361: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
362: ,p_situation_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2

Line 361: ,p_type_of_ps in varchar2 default hr_api.g_varchar2

357: ,p_statutory_situation_id in number
358: ,p_object_version_number in out nocopy number
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_situation_name in varchar2 default hr_api.g_varchar2
361: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
362: ,p_situation_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2

Line 362: ,p_situation_type in varchar2 default hr_api.g_varchar2

358: ,p_object_version_number in out nocopy number
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_situation_name in varchar2 default hr_api.g_varchar2
361: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
362: ,p_situation_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2

Line 363: ,p_sub_type in varchar2 default hr_api.g_varchar2

359: ,p_business_group_id in number default hr_api.g_number
360: ,p_situation_name in varchar2 default hr_api.g_varchar2
361: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
362: ,p_situation_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2

Line 364: ,p_source in varchar2 default hr_api.g_varchar2

360: ,p_situation_name in varchar2 default hr_api.g_varchar2
361: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
362: ,p_situation_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date

Line 365: ,p_location in varchar2 default hr_api.g_varchar2

361: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
362: ,p_situation_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date
369: ,p_date_to in date default hr_api.g_date

Line 366: ,p_reason in varchar2 default hr_api.g_varchar2

362: ,p_situation_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date
369: ,p_date_to in date default hr_api.g_date
370: ,p_request_type in varchar2 default hr_api.g_varchar2

Line 367: ,p_is_default in varchar2 default hr_api.g_varchar2

363: ,p_sub_type in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date
369: ,p_date_to in date default hr_api.g_date
370: ,p_request_type in varchar2 default hr_api.g_varchar2
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2

Line 368: ,p_date_from in date default hr_api.g_date

364: ,p_source in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date
369: ,p_date_to in date default hr_api.g_date
370: ,p_request_type in varchar2 default hr_api.g_varchar2
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2

Line 369: ,p_date_to in date default hr_api.g_date

365: ,p_location in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date
369: ,p_date_to in date default hr_api.g_date
370: ,p_request_type in varchar2 default hr_api.g_varchar2
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2

Line 370: ,p_request_type in varchar2 default hr_api.g_varchar2

366: ,p_reason in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date
369: ,p_date_to in date default hr_api.g_date
370: ,p_request_type in varchar2 default hr_api.g_varchar2
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2

Line 371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2

367: ,p_is_default in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date
369: ,p_date_to in date default hr_api.g_date
370: ,p_request_type in varchar2 default hr_api.g_varchar2
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2

Line 372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2

368: ,p_date_from in date default hr_api.g_date
369: ,p_date_to in date default hr_api.g_date
370: ,p_request_type in varchar2 default hr_api.g_varchar2
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2

Line 373: ,p_print_arrette in varchar2 default hr_api.g_varchar2

369: ,p_date_to in date default hr_api.g_date
370: ,p_request_type in varchar2 default hr_api.g_varchar2
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2

Line 374: ,p_reserve_position in varchar2 default hr_api.g_varchar2

370: ,p_request_type in varchar2 default hr_api.g_varchar2
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number

Line 375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2

371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number

Line 376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2

372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2

Line 377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2

373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2
381: ,p_first_period_max_duration in number default hr_api.g_number

Line 378: ,p_pay_share in number default hr_api.g_number

374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2
381: ,p_first_period_max_duration in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number

Line 379: ,p_pay_periods in number default hr_api.g_number

375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2
381: ,p_first_period_max_duration in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number
383: ,p_max_duration_per_request in number default hr_api.g_number

Line 380: ,p_frequency in varchar2 default hr_api.g_varchar2

376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2
381: ,p_first_period_max_duration in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number
383: ,p_max_duration_per_request in number default hr_api.g_number
384: ,p_max_duration_whole_career in number default hr_api.g_number

Line 381: ,p_first_period_max_duration in number default hr_api.g_number

377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2
381: ,p_first_period_max_duration in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number
383: ,p_max_duration_per_request in number default hr_api.g_number
384: ,p_max_duration_whole_career in number default hr_api.g_number
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2

Line 382: ,p_min_duration_per_request in number default hr_api.g_number

378: ,p_pay_share in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2
381: ,p_first_period_max_duration in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number
383: ,p_max_duration_per_request in number default hr_api.g_number
384: ,p_max_duration_whole_career in number default hr_api.g_number
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
386: ,p_max_no_of_renewals in number default hr_api.g_number

Line 383: ,p_max_duration_per_request in number default hr_api.g_number

379: ,p_pay_periods in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2
381: ,p_first_period_max_duration in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number
383: ,p_max_duration_per_request in number default hr_api.g_number
384: ,p_max_duration_whole_career in number default hr_api.g_number
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
386: ,p_max_no_of_renewals in number default hr_api.g_number
387: ,p_max_duration_per_renewal in number default hr_api.g_number

Line 384: ,p_max_duration_whole_career in number default hr_api.g_number

380: ,p_frequency in varchar2 default hr_api.g_varchar2
381: ,p_first_period_max_duration in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number
383: ,p_max_duration_per_request in number default hr_api.g_number
384: ,p_max_duration_whole_career in number default hr_api.g_number
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
386: ,p_max_no_of_renewals in number default hr_api.g_number
387: ,p_max_duration_per_renewal in number default hr_api.g_number
388: ,p_max_tot_continuous_duration in number default hr_api.g_number

Line 385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2

381: ,p_first_period_max_duration in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number
383: ,p_max_duration_per_request in number default hr_api.g_number
384: ,p_max_duration_whole_career in number default hr_api.g_number
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
386: ,p_max_no_of_renewals in number default hr_api.g_number
387: ,p_max_duration_per_renewal in number default hr_api.g_number
388: ,p_max_tot_continuous_duration in number default hr_api.g_number
389: ,p_remunerate_assign_status_id in number default hr_api.g_number

Line 386: ,p_max_no_of_renewals in number default hr_api.g_number

382: ,p_min_duration_per_request in number default hr_api.g_number
383: ,p_max_duration_per_request in number default hr_api.g_number
384: ,p_max_duration_whole_career in number default hr_api.g_number
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
386: ,p_max_no_of_renewals in number default hr_api.g_number
387: ,p_max_duration_per_renewal in number default hr_api.g_number
388: ,p_max_tot_continuous_duration in number default hr_api.g_number
389: ,p_remunerate_assign_status_id in number default hr_api.g_number
390: ,p_return_status out nocopy varchar2

Line 387: ,p_max_duration_per_renewal in number default hr_api.g_number

383: ,p_max_duration_per_request in number default hr_api.g_number
384: ,p_max_duration_whole_career in number default hr_api.g_number
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
386: ,p_max_no_of_renewals in number default hr_api.g_number
387: ,p_max_duration_per_renewal in number default hr_api.g_number
388: ,p_max_tot_continuous_duration in number default hr_api.g_number
389: ,p_remunerate_assign_status_id in number default hr_api.g_number
390: ,p_return_status out nocopy varchar2
391: ) is

Line 388: ,p_max_tot_continuous_duration in number default hr_api.g_number

384: ,p_max_duration_whole_career in number default hr_api.g_number
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
386: ,p_max_no_of_renewals in number default hr_api.g_number
387: ,p_max_duration_per_renewal in number default hr_api.g_number
388: ,p_max_tot_continuous_duration in number default hr_api.g_number
389: ,p_remunerate_assign_status_id in number default hr_api.g_number
390: ,p_return_status out nocopy varchar2
391: ) is
392: --

Line 389: ,p_remunerate_assign_status_id in number default hr_api.g_number

385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
386: ,p_max_no_of_renewals in number default hr_api.g_number
387: ,p_max_duration_per_renewal in number default hr_api.g_number
388: ,p_max_tot_continuous_duration in number default hr_api.g_number
389: ,p_remunerate_assign_status_id in number default hr_api.g_number
390: ,p_return_status out nocopy varchar2
391: ) is
392: --
393: -- Variables for API Boolean parameters

Line 426: hr_api.constant_to_boolean

422: --
423: -- Convert constant values to their corresponding boolean value
424: --
425: l_validate :=
426: hr_api.constant_to_boolean
427: (p_constant_value => p_validate);
428: --
429: -- Register Surrogate ID or user key values
430: --