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.BEN_EXT_FMT dependencies on BEN_EXT_THREAD

Line 3511: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

3507: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3508: p_jurisdiction_code => l_jurisdiction_code,
3509: p_per_cm_id => ben_ext_person.g_per_cm_id
3510: ,p_param1 => 'EXT_DFN_ID'
3511: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3512: ,p_param2 => 'EXT_RSLT_ID'
3513: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3514: ,p_param3 => 'EXT_PERSON_ID'
3515: ,p_param3_value => to_char(nvl(ben_ext_person.g_person_id, -1))

Line 3513: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

3509: p_per_cm_id => ben_ext_person.g_per_cm_id
3510: ,p_param1 => 'EXT_DFN_ID'
3511: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3512: ,p_param2 => 'EXT_RSLT_ID'
3513: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3514: ,p_param3 => 'EXT_PERSON_ID'
3515: ,p_param3_value => to_char(nvl(ben_ext_person.g_person_id, -1))
3516: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3517: ,p_param4_value => to_char(p_business_group_id)

Line 3543: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

3539: p_opt_id => ben_ext_person.g_enrt_opt_id,
3540: p_ler_id => ben_ext_person.g_enrt_ler_id
3541: --RChase pass extract definition id as input value
3542: ,p_param1 => 'EXT_DFN_ID'
3543: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3544: ,p_param2 => 'EXT_RSLT_ID'
3545: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3546: /* Start of Changes for WWBUG: 1828349: addition */
3547: ,p_param3 => 'PRTT_ENRT_RSLT_ID'

Line 3545: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

3541: --RChase pass extract definition id as input value
3542: ,p_param1 => 'EXT_DFN_ID'
3543: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3544: ,p_param2 => 'EXT_RSLT_ID'
3545: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3546: /* Start of Changes for WWBUG: 1828349: addition */
3547: ,p_param3 => 'PRTT_ENRT_RSLT_ID'
3548: ,p_param3_value => to_char(nvl(ben_ext_person.g_enrt_prtt_enrt_rslt_id, -1))
3549: /* for the ansi dpnt person id is necessary 3419446 */

Line 3572: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

3568: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3569: p_elig_per_elctbl_chc_id => ben_ext_person.g_elig_per_elctbl_chc_id
3570: --RChase pass extract definition id as input value
3571: ,p_param1 => 'EXT_DFN_ID'
3572: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3573: ,p_param2 => 'EXT_RSLT_ID'
3574: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3575: ,p_param3 => 'EXT_PROCESS_BUSINESS_GROUP'
3576: ,p_param3_value => to_char(p_business_group_id)

Line 3574: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

3570: --RChase pass extract definition id as input value
3571: ,p_param1 => 'EXT_DFN_ID'
3572: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3573: ,p_param2 => 'EXT_RSLT_ID'
3574: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3575: ,p_param3 => 'EXT_PROCESS_BUSINESS_GROUP'
3576: ,p_param3_value => to_char(p_business_group_id)
3577: ,p_param4 => 'EXT_USER_VALUE'
3578: ,p_param4_value => p_String_Val

Line 3596: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

3592: p_param1_value => to_char(ben_ext_person.g_prtt_prem_by_mo_id),
3593: p_param2 => 'ACTL_PREM_ID',
3594: p_param2_value => to_char(ben_ext_person.g_prem_actl_prem_id)
3595: ,p_param3 => 'EXT_DFN_ID'
3596: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3597: ,p_param4 => 'EXT_RSLT_ID'
3598: ,p_param4_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3599: ,p_param5 => 'EXT_PROCESS_BUSINESS_GROUP'
3600: ,p_param5_value => to_char(p_business_group_id)

Line 3598: ,p_param4_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

3594: p_param2_value => to_char(ben_ext_person.g_prem_actl_prem_id)
3595: ,p_param3 => 'EXT_DFN_ID'
3596: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3597: ,p_param4 => 'EXT_RSLT_ID'
3598: ,p_param4_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3599: ,p_param5 => 'EXT_PROCESS_BUSINESS_GROUP'
3600: ,p_param5_value => to_char(p_business_group_id)
3601: ,p_param6 => 'EXT_USER_VALUE'
3602: ,p_param6_value => p_String_Val

Line 3617: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

3613: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3614: p_param1 => 'ELIG_CVRD_DPNT_ID',
3615: p_param1_value => to_char(ben_ext_person.g_dpnt_cvrd_dpnt_id)
3616: ,p_param2 => 'EXT_DFN_ID'
3617: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3618: ,p_param3 => 'EXT_RSLT_ID'
3619: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3620: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3621: ,p_param4_value => to_char(p_business_group_id)

Line 3619: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

3615: p_param1_value => to_char(ben_ext_person.g_dpnt_cvrd_dpnt_id)
3616: ,p_param2 => 'EXT_DFN_ID'
3617: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3618: ,p_param3 => 'EXT_RSLT_ID'
3619: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3620: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3621: ,p_param4_value => to_char(p_business_group_id)
3622: ,p_param5 => 'EXT_USER_VALUE'
3623: ,p_param5_value => p_String_Val

Line 3637: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

3633: p_assignment_id => l_asg.assignment_id,
3634: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3635: p_prtt_enrt_actn_id => ben_ext_person.g_actn_prtt_enrt_actn_id
3636: ,p_param1 => 'EXT_DFN_ID'
3637: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3638: ,p_param2 => 'EXT_RSLT_ID'
3639: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3640: ,p_param3 => 'EXT_PROCESS_BUSINESS_GROUP'
3641: ,p_param3_value => to_char(p_business_group_id)

Line 3639: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

3635: p_prtt_enrt_actn_id => ben_ext_person.g_actn_prtt_enrt_actn_id
3636: ,p_param1 => 'EXT_DFN_ID'
3637: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3638: ,p_param2 => 'EXT_RSLT_ID'
3639: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3640: ,p_param3 => 'EXT_PROCESS_BUSINESS_GROUP'
3641: ,p_param3_value => to_char(p_business_group_id)
3642: ,p_param4 => 'EXT_USER_VALUE'
3643: ,p_param4_value => p_string_Val

Line 3658: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

3654: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3655: p_param1 => 'PL_BNF_ID',
3656: p_param1_value => to_char(ben_ext_person.g_bnf_pl_bnf_id)
3657: ,p_param2 => 'EXT_DFN_ID'
3658: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3659: ,p_param3 => 'EXT_RSLT_ID'
3660: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3661: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3662: ,p_param4_value => to_char(p_business_group_id)

Line 3660: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

3656: p_param1_value => to_char(ben_ext_person.g_bnf_pl_bnf_id)
3657: ,p_param2 => 'EXT_DFN_ID'
3658: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3659: ,p_param3 => 'EXT_RSLT_ID'
3660: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3661: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3662: ,p_param4_value => to_char(p_business_group_id)
3663: ,p_param5 => 'EXT_USER_VALUE'
3664: ,p_param5_value => p_String_Val

Line 3680: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

3676: p_param1 => 'BNFT_PRVDR_POOL_ID',
3677: p_param1_value => to_char(ben_ext_person.g_flex_bnft_pool_id)
3678: --RChase pass extract definition id as input value
3679: ,p_param2 => 'EXT_DFN_ID'
3680: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3681: ,p_param3 => 'EXT_RSLT_ID'
3682: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3683: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3684: ,p_param4_value => to_char(p_business_group_id)

Line 3682: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

3678: --RChase pass extract definition id as input value
3679: ,p_param2 => 'EXT_DFN_ID'
3680: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3681: ,p_param3 => 'EXT_RSLT_ID'
3682: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3683: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3684: ,p_param4_value => to_char(p_business_group_id)
3685: ,p_param5 => 'EXT_USER_VALUE'
3686: ,p_param5_value => p_String_Val

Line 3702: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

3698: p_param1 => 'ELEMENT_ENTRY_VALUE_ID',
3699: p_param1_value => to_char(ben_ext_person.g_element_entry_value_id)
3700: --RChase pass extract definition id as input value
3701: ,p_param2 => 'EXT_DFN_ID'
3702: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3703: ,p_param3 => 'EXT_RSLT_ID'
3704: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3705: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3706: ,p_param4_value => to_char(p_business_group_id)

Line 3704: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

3700: --RChase pass extract definition id as input value
3701: ,p_param2 => 'EXT_DFN_ID'
3702: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3703: ,p_param3 => 'EXT_RSLT_ID'
3704: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3705: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3706: ,p_param4_value => to_char(p_business_group_id)
3707: ,p_param5 => 'EXT_USER_VALUE'
3708: ,p_param5_value => p_String_Val

Line 3724: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

3720: p_param1 => 'RUN_RESULT_ID',
3721: p_param1_value => to_char(ben_ext_person.g_runrslt_identifier)
3722: --RChase pass extract definition id as input value
3723: ,p_param2 => 'EXT_DFN_ID'
3724: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3725: ,p_param3 => 'EXT_RSLT_ID'
3726: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3727: ---bug : 1724999
3728: ,p_param4 => 'INPUT_VALUE_ID'

Line 3726: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

3722: --RChase pass extract definition id as input value
3723: ,p_param2 => 'EXT_DFN_ID'
3724: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3725: ,p_param3 => 'EXT_RSLT_ID'
3726: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3727: ---bug : 1724999
3728: ,p_param4 => 'INPUT_VALUE_ID'
3729: ,p_param4_value => to_char(nvl(ben_ext_person.g_runrslt_input_value_id,-1))
3730: ,p_param5 => 'RESULT_VALUE'

Line 3751: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

3747: p_param1 => 'CONTACT_RELATIONSHIP_ID',
3748: p_param1_value => to_char(ben_ext_person.g_contact_rlshp_id)
3749: --RChase pass extract definition id as input value
3750: ,p_param2 => 'EXT_DFN_ID'
3751: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3752: ,p_param3 => 'EXT_RSLT_ID'
3753: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3754: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3755: ,p_param4_value => to_char(p_business_group_id)

Line 3753: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

3749: --RChase pass extract definition id as input value
3750: ,p_param2 => 'EXT_DFN_ID'
3751: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3752: ,p_param3 => 'EXT_RSLT_ID'
3753: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3754: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3755: ,p_param4_value => to_char(p_business_group_id)
3756: ,p_param5 => 'EXT_USER_VALUE'
3757: ,p_param5_value => p_String_Val

Line 3773: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

3769: p_param1 => 'ELIG_DPNT_ID',
3770: p_param1_value => to_char(ben_ext_person.g_elig_dpnt_id)
3771: --RChase pass extract definition id as input value
3772: ,p_param2 => 'EXT_DFN_ID'
3773: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3774: ,p_param3 => 'EXT_RSLT_ID'
3775: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3776: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3777: ,p_param4_value => to_char(p_business_group_id)

Line 3775: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

3771: --RChase pass extract definition id as input value
3772: ,p_param2 => 'EXT_DFN_ID'
3773: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3774: ,p_param3 => 'EXT_RSLT_ID'
3775: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3776: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3777: ,p_param4_value => to_char(p_business_group_id)
3778: ,p_param5 => 'EXT_USER_VALUE'
3779: ,p_param5_value => p_String_Val

Line 3790: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

3786: (p_formula_id => p_data_elmt_rl,
3787: p_effective_date => p_effective_date ,
3788: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id)
3789: ,p_param1 => 'EXT_DFN_ID'
3790: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3791: ,p_param2 => 'EXT_RSLT_ID'
3792: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3793: ,p_param3 => 'EXT_GROUP_VALUE_01'
3794: ,p_param3_value => ben_ext_person.g_group_elmt_value1

Line 3792: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

3788: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id)
3789: ,p_param1 => 'EXT_DFN_ID'
3790: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3791: ,p_param2 => 'EXT_RSLT_ID'
3792: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3793: ,p_param3 => 'EXT_GROUP_VALUE_01'
3794: ,p_param3_value => ben_ext_person.g_group_elmt_value1
3795: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3796: ,p_param4_value => to_char(p_business_group_id)

Line 4362: if ben_ext_thread.g_ext_group_elmt1 is not null then

4358: exit ;
4359: end if ;
4360:
4361: --- decide the grouping element subhead
4362: if ben_ext_thread.g_ext_group_elmt1 is not null then
4363: hr_utility.set_location(' GROUP ' || ben_ext_thread.g_ext_group_elmt1 || ' / ' ||elmt.short_name , 99 ) ;
4364: if ben_ext_thread.g_ext_group_elmt1 = elmt.short_name then
4365: ben_ext_person.g_group_elmt_value1 := l_rslt_elmt ;
4366: end if ;

Line 4363: hr_utility.set_location(' GROUP ' || ben_ext_thread.g_ext_group_elmt1 || ' / ' ||elmt.short_name , 99 ) ;

4359: end if ;
4360:
4361: --- decide the grouping element subhead
4362: if ben_ext_thread.g_ext_group_elmt1 is not null then
4363: hr_utility.set_location(' GROUP ' || ben_ext_thread.g_ext_group_elmt1 || ' / ' ||elmt.short_name , 99 ) ;
4364: if ben_ext_thread.g_ext_group_elmt1 = elmt.short_name then
4365: ben_ext_person.g_group_elmt_value1 := l_rslt_elmt ;
4366: end if ;
4367: if ben_ext_thread.g_ext_group_elmt2 is not null then

Line 4364: if ben_ext_thread.g_ext_group_elmt1 = elmt.short_name then

4360:
4361: --- decide the grouping element subhead
4362: if ben_ext_thread.g_ext_group_elmt1 is not null then
4363: hr_utility.set_location(' GROUP ' || ben_ext_thread.g_ext_group_elmt1 || ' / ' ||elmt.short_name , 99 ) ;
4364: if ben_ext_thread.g_ext_group_elmt1 = elmt.short_name then
4365: ben_ext_person.g_group_elmt_value1 := l_rslt_elmt ;
4366: end if ;
4367: if ben_ext_thread.g_ext_group_elmt2 is not null then
4368: if ben_ext_thread.g_ext_group_elmt2 = elmt.short_name then

Line 4367: if ben_ext_thread.g_ext_group_elmt2 is not null then

4363: hr_utility.set_location(' GROUP ' || ben_ext_thread.g_ext_group_elmt1 || ' / ' ||elmt.short_name , 99 ) ;
4364: if ben_ext_thread.g_ext_group_elmt1 = elmt.short_name then
4365: ben_ext_person.g_group_elmt_value1 := l_rslt_elmt ;
4366: end if ;
4367: if ben_ext_thread.g_ext_group_elmt2 is not null then
4368: if ben_ext_thread.g_ext_group_elmt2 = elmt.short_name then
4369: ben_ext_person.g_group_elmt_value2 := l_rslt_elmt ;
4370: end if ;
4371: else

Line 4368: if ben_ext_thread.g_ext_group_elmt2 = elmt.short_name then

4364: if ben_ext_thread.g_ext_group_elmt1 = elmt.short_name then
4365: ben_ext_person.g_group_elmt_value1 := l_rslt_elmt ;
4366: end if ;
4367: if ben_ext_thread.g_ext_group_elmt2 is not null then
4368: if ben_ext_thread.g_ext_group_elmt2 = elmt.short_name then
4369: ben_ext_person.g_group_elmt_value2 := l_rslt_elmt ;
4370: end if ;
4371: else
4372: if p_rcd_typ_cd = 'S' then