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_PERSON dependencies on BEN_EXT_THREAD

Line 3236: if ben_ext_thread.g_effective_start_date is not null then

3232: p_chg_eff_strt_dt => l_chg_eff_strt_dt, --out
3233: p_chg_eff_end_dt => l_chg_eff_end_dt); --out
3234:
3235: -- if the parameter passed from extract , then overide the criteria dates
3236: if ben_ext_thread.g_effective_start_date is not null then
3237: l_chg_eff_strt_dt := ben_ext_thread.g_effective_start_date ;
3238: l_chg_eff_end_dt := ben_ext_thread.g_effective_end_date ;
3239: end if ;
3240:

Line 3237: l_chg_eff_strt_dt := ben_ext_thread.g_effective_start_date ;

3233: p_chg_eff_end_dt => l_chg_eff_end_dt); --out
3234:
3235: -- if the parameter passed from extract , then overide the criteria dates
3236: if ben_ext_thread.g_effective_start_date is not null then
3237: l_chg_eff_strt_dt := ben_ext_thread.g_effective_start_date ;
3238: l_chg_eff_end_dt := ben_ext_thread.g_effective_end_date ;
3239: end if ;
3240:
3241: if ben_ext_thread.g_actual_start_date is not null then

Line 3238: l_chg_eff_end_dt := ben_ext_thread.g_effective_end_date ;

3234:
3235: -- if the parameter passed from extract , then overide the criteria dates
3236: if ben_ext_thread.g_effective_start_date is not null then
3237: l_chg_eff_strt_dt := ben_ext_thread.g_effective_start_date ;
3238: l_chg_eff_end_dt := ben_ext_thread.g_effective_end_date ;
3239: end if ;
3240:
3241: if ben_ext_thread.g_actual_start_date is not null then
3242: l_chg_actl_strt_dt := ben_ext_thread.g_actual_start_date ;

Line 3241: if ben_ext_thread.g_actual_start_date is not null then

3237: l_chg_eff_strt_dt := ben_ext_thread.g_effective_start_date ;
3238: l_chg_eff_end_dt := ben_ext_thread.g_effective_end_date ;
3239: end if ;
3240:
3241: if ben_ext_thread.g_actual_start_date is not null then
3242: l_chg_actl_strt_dt := ben_ext_thread.g_actual_start_date ;
3243: l_chg_actl_end_dt := ben_ext_thread.g_actual_end_date ;
3244: end if ;
3245:

Line 3242: l_chg_actl_strt_dt := ben_ext_thread.g_actual_start_date ;

3238: l_chg_eff_end_dt := ben_ext_thread.g_effective_end_date ;
3239: end if ;
3240:
3241: if ben_ext_thread.g_actual_start_date is not null then
3242: l_chg_actl_strt_dt := ben_ext_thread.g_actual_start_date ;
3243: l_chg_actl_end_dt := ben_ext_thread.g_actual_end_date ;
3244: end if ;
3245:
3246: hr_utility.set_location( 'chg actl date ' || l_chg_actl_strt_dt || ' / ' || l_chg_actl_end_dt, 99 );

Line 3243: l_chg_actl_end_dt := ben_ext_thread.g_actual_end_date ;

3239: end if ;
3240:
3241: if ben_ext_thread.g_actual_start_date is not null then
3242: l_chg_actl_strt_dt := ben_ext_thread.g_actual_start_date ;
3243: l_chg_actl_end_dt := ben_ext_thread.g_actual_end_date ;
3244: end if ;
3245:
3246: hr_utility.set_location( 'chg actl date ' || l_chg_actl_strt_dt || ' / ' || l_chg_actl_end_dt, 99 );
3247: hr_utility.set_location( 'chg eff date ' || l_chg_eff_strt_dt || ' / ' || l_chg_eff_end_dt , 99 );

Line 3249: if ben_ext_thread.g_chg_ext_from_ben = 'Y' then

3245:
3246: hr_utility.set_location( 'chg actl date ' || l_chg_actl_strt_dt || ' / ' || l_chg_actl_end_dt, 99 );
3247: hr_utility.set_location( 'chg eff date ' || l_chg_eff_strt_dt || ' / ' || l_chg_eff_end_dt , 99 );
3248: --
3249: if ben_ext_thread.g_chg_ext_from_ben = 'Y' then
3250: hr_utility.set_location( ' extract chg evt log included ' , 99 );
3251: open c_changes_only_extract (l_chg_actl_strt_dt,
3252: l_chg_actl_end_dt,
3253: l_chg_eff_strt_dt,

Line 3469: if ben_ext_thread.g_chg_ext_from_pay = 'Y' then

3465: --
3466: end if ; --- for extract chg logs
3467:
3468:
3469: if ben_ext_thread.g_chg_ext_from_pay = 'Y' then
3470: hr_utility.set_location( ' PAY event log included ' , 99 );
3471: -- Loop thorough all the assignment id for a person
3472: -- within the extract period
3473: --- get the primary assg as of effective date

Line 5533: if l_err_num >= ben_ext_thread.g_max_errors_allowed then

5529: fetch err_cnt_c into l_err_num;
5530: close err_cnt_c;
5531: --
5532:
5533: if l_err_num >= ben_ext_thread.g_max_errors_allowed then
5534: --
5535: ben_ext_thread.g_err_num := 91947;
5536: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';
5537: raise ben_ext_thread.g_job_failure_error;

Line 5535: ben_ext_thread.g_err_num := 91947;

5531: --
5532:
5533: if l_err_num >= ben_ext_thread.g_max_errors_allowed then
5534: --
5535: ben_ext_thread.g_err_num := 91947;
5536: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';
5537: raise ben_ext_thread.g_job_failure_error;
5538: --
5539: end if;

Line 5536: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';

5532:
5533: if l_err_num >= ben_ext_thread.g_max_errors_allowed then
5534: --
5535: ben_ext_thread.g_err_num := 91947;
5536: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';
5537: raise ben_ext_thread.g_job_failure_error;
5538: --
5539: end if;
5540: --

Line 5537: raise ben_ext_thread.g_job_failure_error;

5533: if l_err_num >= ben_ext_thread.g_max_errors_allowed then
5534: --
5535: ben_ext_thread.g_err_num := 91947;
5536: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';
5537: raise ben_ext_thread.g_job_failure_error;
5538: --
5539: end if;
5540: --
5541: if g_business_group_id is not null then