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 3517: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

3513: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3514: p_jurisdiction_code => l_jurisdiction_code,
3515: p_per_cm_id => ben_ext_person.g_per_cm_id
3516: ,p_param1 => 'EXT_DFN_ID'
3517: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3518: ,p_param2 => 'EXT_RSLT_ID'
3519: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3520: ,p_param3 => 'EXT_PERSON_ID'
3521: ,p_param3_value => to_char(nvl(ben_ext_person.g_person_id, -1))

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

3515: p_per_cm_id => ben_ext_person.g_per_cm_id
3516: ,p_param1 => 'EXT_DFN_ID'
3517: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3518: ,p_param2 => 'EXT_RSLT_ID'
3519: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3520: ,p_param3 => 'EXT_PERSON_ID'
3521: ,p_param3_value => to_char(nvl(ben_ext_person.g_person_id, -1))
3522: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3523: ,p_param4_value => to_char(p_business_group_id)

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

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

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

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

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

3574: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3575: p_elig_per_elctbl_chc_id => ben_ext_person.g_elig_per_elctbl_chc_id
3576: --RChase pass extract definition id as input value
3577: ,p_param1 => 'EXT_DFN_ID'
3578: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3579: ,p_param2 => 'EXT_RSLT_ID'
3580: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3581: ,p_param3 => 'EXT_PROCESS_BUSINESS_GROUP'
3582: ,p_param3_value => to_char(p_business_group_id)

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

3576: --RChase pass extract definition id as input value
3577: ,p_param1 => 'EXT_DFN_ID'
3578: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3579: ,p_param2 => 'EXT_RSLT_ID'
3580: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3581: ,p_param3 => 'EXT_PROCESS_BUSINESS_GROUP'
3582: ,p_param3_value => to_char(p_business_group_id)
3583: ,p_param4 => 'EXT_USER_VALUE'
3584: ,p_param4_value => p_String_Val

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

3598: p_param1_value => to_char(ben_ext_person.g_prtt_prem_by_mo_id),
3599: p_param2 => 'ACTL_PREM_ID',
3600: p_param2_value => to_char(ben_ext_person.g_prem_actl_prem_id)
3601: ,p_param3 => 'EXT_DFN_ID'
3602: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3603: ,p_param4 => 'EXT_RSLT_ID'
3604: ,p_param4_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3605: ,p_param5 => 'EXT_PROCESS_BUSINESS_GROUP'
3606: ,p_param5_value => to_char(p_business_group_id)

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

3600: p_param2_value => to_char(ben_ext_person.g_prem_actl_prem_id)
3601: ,p_param3 => 'EXT_DFN_ID'
3602: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3603: ,p_param4 => 'EXT_RSLT_ID'
3604: ,p_param4_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3605: ,p_param5 => 'EXT_PROCESS_BUSINESS_GROUP'
3606: ,p_param5_value => to_char(p_business_group_id)
3607: ,p_param6 => 'EXT_USER_VALUE'
3608: ,p_param6_value => p_String_Val

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

3619: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3620: p_param1 => 'ELIG_CVRD_DPNT_ID',
3621: p_param1_value => to_char(ben_ext_person.g_dpnt_cvrd_dpnt_id)
3622: ,p_param2 => 'EXT_DFN_ID'
3623: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3624: ,p_param3 => 'EXT_RSLT_ID'
3625: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3626: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3627: ,p_param4_value => to_char(p_business_group_id)

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

3621: p_param1_value => to_char(ben_ext_person.g_dpnt_cvrd_dpnt_id)
3622: ,p_param2 => 'EXT_DFN_ID'
3623: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3624: ,p_param3 => 'EXT_RSLT_ID'
3625: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3626: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3627: ,p_param4_value => to_char(p_business_group_id)
3628: ,p_param5 => 'EXT_USER_VALUE'
3629: ,p_param5_value => p_String_Val

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

3639: p_assignment_id => l_asg.assignment_id,
3640: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3641: p_prtt_enrt_actn_id => ben_ext_person.g_actn_prtt_enrt_actn_id
3642: ,p_param1 => 'EXT_DFN_ID'
3643: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3644: ,p_param2 => 'EXT_RSLT_ID'
3645: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3646: ,p_param3 => 'EXT_PROCESS_BUSINESS_GROUP'
3647: ,p_param3_value => to_char(p_business_group_id)

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

3641: p_prtt_enrt_actn_id => ben_ext_person.g_actn_prtt_enrt_actn_id
3642: ,p_param1 => 'EXT_DFN_ID'
3643: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3644: ,p_param2 => 'EXT_RSLT_ID'
3645: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3646: ,p_param3 => 'EXT_PROCESS_BUSINESS_GROUP'
3647: ,p_param3_value => to_char(p_business_group_id)
3648: ,p_param4 => 'EXT_USER_VALUE'
3649: ,p_param4_value => p_string_Val

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

3660: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3661: p_param1 => 'PL_BNF_ID',
3662: p_param1_value => to_char(ben_ext_person.g_bnf_pl_bnf_id)
3663: ,p_param2 => 'EXT_DFN_ID'
3664: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3665: ,p_param3 => 'EXT_RSLT_ID'
3666: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3667: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3668: ,p_param4_value => to_char(p_business_group_id)

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

3662: p_param1_value => to_char(ben_ext_person.g_bnf_pl_bnf_id)
3663: ,p_param2 => 'EXT_DFN_ID'
3664: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3665: ,p_param3 => 'EXT_RSLT_ID'
3666: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3667: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3668: ,p_param4_value => to_char(p_business_group_id)
3669: ,p_param5 => 'EXT_USER_VALUE'
3670: ,p_param5_value => p_String_Val

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

3682: p_param1 => 'BNFT_PRVDR_POOL_ID',
3683: p_param1_value => to_char(ben_ext_person.g_flex_bnft_pool_id)
3684: --RChase pass extract definition id as input value
3685: ,p_param2 => 'EXT_DFN_ID'
3686: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3687: ,p_param3 => 'EXT_RSLT_ID'
3688: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3689: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3690: ,p_param4_value => to_char(p_business_group_id)

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

3684: --RChase pass extract definition id as input value
3685: ,p_param2 => 'EXT_DFN_ID'
3686: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3687: ,p_param3 => 'EXT_RSLT_ID'
3688: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3689: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3690: ,p_param4_value => to_char(p_business_group_id)
3691: ,p_param5 => 'EXT_USER_VALUE'
3692: ,p_param5_value => p_String_Val

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

3704: p_param1 => 'ELEMENT_ENTRY_VALUE_ID',
3705: p_param1_value => to_char(ben_ext_person.g_element_entry_value_id)
3706: --RChase pass extract definition id as input value
3707: ,p_param2 => 'EXT_DFN_ID'
3708: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3709: ,p_param3 => 'EXT_RSLT_ID'
3710: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3711: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3712: ,p_param4_value => to_char(p_business_group_id)

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

3706: --RChase pass extract definition id as input value
3707: ,p_param2 => 'EXT_DFN_ID'
3708: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3709: ,p_param3 => 'EXT_RSLT_ID'
3710: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3711: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3712: ,p_param4_value => to_char(p_business_group_id)
3713: ,p_param5 => 'EXT_USER_VALUE'
3714: ,p_param5_value => p_String_Val

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

3726: p_param1 => 'RUN_RESULT_ID',
3727: p_param1_value => to_char(ben_ext_person.g_runrslt_identifier)
3728: --RChase pass extract definition id as input value
3729: ,p_param2 => 'EXT_DFN_ID'
3730: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3731: ,p_param3 => 'EXT_RSLT_ID'
3732: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3733: ---bug : 1724999
3734: ,p_param4 => 'INPUT_VALUE_ID'

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

3728: --RChase pass extract definition id as input value
3729: ,p_param2 => 'EXT_DFN_ID'
3730: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3731: ,p_param3 => 'EXT_RSLT_ID'
3732: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3733: ---bug : 1724999
3734: ,p_param4 => 'INPUT_VALUE_ID'
3735: ,p_param4_value => to_char(nvl(ben_ext_person.g_runrslt_input_value_id,-1))
3736: ,p_param5 => 'RESULT_VALUE'

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

3753: p_param1 => 'CONTACT_RELATIONSHIP_ID',
3754: p_param1_value => to_char(ben_ext_person.g_contact_rlshp_id)
3755: --RChase pass extract definition id as input value
3756: ,p_param2 => 'EXT_DFN_ID'
3757: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3758: ,p_param3 => 'EXT_RSLT_ID'
3759: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3760: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3761: ,p_param4_value => to_char(p_business_group_id)

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

3755: --RChase pass extract definition id as input value
3756: ,p_param2 => 'EXT_DFN_ID'
3757: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3758: ,p_param3 => 'EXT_RSLT_ID'
3759: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3760: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3761: ,p_param4_value => to_char(p_business_group_id)
3762: ,p_param5 => 'EXT_USER_VALUE'
3763: ,p_param5_value => p_String_Val

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

3775: p_param1 => 'ELIG_DPNT_ID',
3776: p_param1_value => to_char(ben_ext_person.g_elig_dpnt_id)
3777: --RChase pass extract definition id as input value
3778: ,p_param2 => 'EXT_DFN_ID'
3779: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3780: ,p_param3 => 'EXT_RSLT_ID'
3781: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3782: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3783: ,p_param4_value => to_char(p_business_group_id)

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

3777: --RChase pass extract definition id as input value
3778: ,p_param2 => 'EXT_DFN_ID'
3779: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3780: ,p_param3 => 'EXT_RSLT_ID'
3781: ,p_param3_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3782: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3783: ,p_param4_value => to_char(p_business_group_id)
3784: ,p_param5 => 'EXT_USER_VALUE'
3785: ,p_param5_value => p_String_Val

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

3792: (p_formula_id => p_data_elmt_rl,
3793: p_effective_date => p_effective_date ,
3794: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id)
3795: ,p_param1 => 'EXT_DFN_ID'
3796: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3797: ,p_param2 => 'EXT_RSLT_ID'
3798: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3799: ,p_param3 => 'EXT_GROUP_VALUE_01'
3800: ,p_param3_value => ben_ext_person.g_group_elmt_value1

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

3794: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id)
3795: ,p_param1 => 'EXT_DFN_ID'
3796: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
3797: ,p_param2 => 'EXT_RSLT_ID'
3798: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
3799: ,p_param3 => 'EXT_GROUP_VALUE_01'
3800: ,p_param3_value => ben_ext_person.g_group_elmt_value1
3801: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
3802: ,p_param4_value => to_char(p_business_group_id)

Line 4368: if ben_ext_thread.g_ext_group_elmt1 is not null then

4364: exit ;
4365: end if ;
4366:
4367: --- decide the grouping element subhead
4368: if ben_ext_thread.g_ext_group_elmt1 is not null then
4369: hr_utility.set_location(' GROUP ' || ben_ext_thread.g_ext_group_elmt1 || ' / ' ||elmt.short_name , 99 ) ;
4370: if ben_ext_thread.g_ext_group_elmt1 = elmt.short_name then
4371: ben_ext_person.g_group_elmt_value1 := l_rslt_elmt ;
4372: end if ;

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

4365: end if ;
4366:
4367: --- decide the grouping element subhead
4368: if ben_ext_thread.g_ext_group_elmt1 is not null then
4369: hr_utility.set_location(' GROUP ' || ben_ext_thread.g_ext_group_elmt1 || ' / ' ||elmt.short_name , 99 ) ;
4370: if ben_ext_thread.g_ext_group_elmt1 = elmt.short_name then
4371: ben_ext_person.g_group_elmt_value1 := l_rslt_elmt ;
4372: end if ;
4373: if ben_ext_thread.g_ext_group_elmt2 is not null then

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

4366:
4367: --- decide the grouping element subhead
4368: if ben_ext_thread.g_ext_group_elmt1 is not null then
4369: hr_utility.set_location(' GROUP ' || ben_ext_thread.g_ext_group_elmt1 || ' / ' ||elmt.short_name , 99 ) ;
4370: if ben_ext_thread.g_ext_group_elmt1 = elmt.short_name then
4371: ben_ext_person.g_group_elmt_value1 := l_rslt_elmt ;
4372: end if ;
4373: if ben_ext_thread.g_ext_group_elmt2 is not null then
4374: if ben_ext_thread.g_ext_group_elmt2 = elmt.short_name then

Line 4373: if ben_ext_thread.g_ext_group_elmt2 is not null then

4369: hr_utility.set_location(' GROUP ' || ben_ext_thread.g_ext_group_elmt1 || ' / ' ||elmt.short_name , 99 ) ;
4370: if ben_ext_thread.g_ext_group_elmt1 = elmt.short_name then
4371: ben_ext_person.g_group_elmt_value1 := l_rslt_elmt ;
4372: end if ;
4373: if ben_ext_thread.g_ext_group_elmt2 is not null then
4374: if ben_ext_thread.g_ext_group_elmt2 = elmt.short_name then
4375: ben_ext_person.g_group_elmt_value2 := l_rslt_elmt ;
4376: end if ;
4377: else

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

4370: if ben_ext_thread.g_ext_group_elmt1 = elmt.short_name then
4371: ben_ext_person.g_group_elmt_value1 := l_rslt_elmt ;
4372: end if ;
4373: if ben_ext_thread.g_ext_group_elmt2 is not null then
4374: if ben_ext_thread.g_ext_group_elmt2 = elmt.short_name then
4375: ben_ext_person.g_group_elmt_value2 := l_rslt_elmt ;
4376: end if ;
4377: else
4378: if p_rcd_typ_cd = 'S' then