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.GHR_US_NFC_EXTRACTS dependencies on FND_DATE

Line 1354: g_rpa_awd_attr(p_request_id).authentication_dt := fnd_date.date_to_canonical(l_auth_date);

1350:
1351: l_no_rpa_count := FALSE;
1352: -- End Bug 4990382
1353:
1354: g_rpa_awd_attr(p_request_id).authentication_dt := fnd_date.date_to_canonical(l_auth_date);
1355: l_get_ei_val:=NULL;
1356:
1357: l_get_ei_val:=get_rpa_extra_info_val (p_request_id
1358: ,'GHR_US_PAR_NFC_AWARD_INFO'

Line 1539: g_rpa_attr(p_request_id).Date_entered_present_grade := fnd_date.date_to_canonical

1535: p_sec_noa_cd = '866' THEN
1536: IF l_per_ei_data.pei_information6 IS NOT NULL THEN
1537: g_rpa_attr(p_request_id).Date_entered_present_grade :=l_per_ei_data.pei_information6;
1538: ELSE
1539: g_rpa_attr(p_request_id).Date_entered_present_grade := fnd_date.date_to_canonical
1540: (g_rpa_rec(p_request_id).effective_date);
1541: END IF;
1542:
1543: ELSE

Line 1957: g_rpa_attr(p_request_id).authentication_dt := fnd_date.date_to_canonical(l_auth_date);

1953: END IF;
1954:
1955: l_no_rpa_count := FALSE;
1956:
1957: g_rpa_attr(p_request_id).authentication_dt := fnd_date.date_to_canonical(l_auth_date);
1958:
1959: /*l_get_ei_val:=get_rpa_extra_info_val (p_request_id
1960: ,'GHR_US_PAR_NFC_INFO'
1961: ); */

Line 2748: l_return_value :=fnd_date.date_to_canonical(

2744: g_rpa_rec.exists(l_pa_request_id))then
2745:
2746: if p_input_value ='RPA_DOB' then
2747:
2748: l_return_value :=fnd_date.date_to_canonical(
2749: g_rpa_rec(l_pa_request_id).employee_date_of_birth);
2750:
2751: elsif p_input_value ='RPA_MNAME' then
2752:

Line 2786: l_return_value := fnd_date.date_to_canonical(

2782: elsif p_input_value ='RPA_ALT_REQ' then
2783:
2784: l_return_value := g_rpa_rec(l_pa_request_id).altered_pa_request_id;
2785: elsif p_input_value ='RPA_SCD_LEAVE' then
2786: l_return_value := fnd_date.date_to_canonical(
2787: g_rpa_rec(l_pa_request_id).service_comp_date);
2788: elsif p_input_value ='RPA_CSC_AUTH_CODE_1NOA' then
2789: l_return_value := g_rpa_rec(l_pa_request_id).first_action_la_code1;
2790: elsif p_input_value ='RPA_CSC_AUTH_2CODE_1NOA' then

Line 2810: l_return_value := fnd_date.date_to_canonical(

2806: l_return_value := g_rpa_rec(l_pa_request_id).first_noa_code;
2807: elsif p_input_value ='RPA_SEC_NOA_CD' then
2808: l_return_value := g_rpa_rec(l_pa_request_id).second_noa_code;
2809: elsif p_input_value ='RPA_EFF_DATE' then
2810: l_return_value := fnd_date.date_to_canonical(
2811: g_rpa_rec(l_pa_request_id).effective_date);
2812: elsif p_input_value ='RPA_CSC_OTH_LEG_AUTH' then
2813: l_return_value := g_rpa_rec(l_pa_request_id).first_action_la_desc1;
2814: elsif p_input_value ='RPA_CSC_OTH_LEG_AUTH2' then

Line 2870: /*l_return_value :=fnd_date.date_to_canonical(

2866: l_return_value :=g_rpa_attr(l_pa_request_id).Frozen_CSRS_service;
2867: elsif p_input_value ='RPA_CSRS_COV_AT_APT' then
2868: l_return_value :=g_rpa_attr(l_pa_request_id).CSRS_coverage_at_appointment;
2869: elsif p_input_value ='RPA_DATE_SICK_LEAVE_EXP_RET' then
2870: /*l_return_value :=fnd_date.date_to_canonical(
2871: g_rpa_attr(l_pa_request_id).Date_sick_leave_exp_ret);*/
2872: l_return_value :=(
2873: g_rpa_attr(l_pa_request_id).Date_sick_leave_exp_ret);
2874: elsif p_input_value ='RPA_ANNUAL_LEAVE_CATEGORY' then

Line 2897: /*l_return_value := fnd_date.date_to_canonical(

2893: g_rpa_attr(l_pa_request_id).Date_Supv_Mgr_Prob);
2894: elsif p_input_value ='RPA_DATE_SPVR_MGR_PROB_ENDS' then
2895: l_return_value := g_rpa_attr(l_pa_request_id).Date_Spvr_Mgr_Prob_Ends;
2896: elsif p_input_value ='RPA_DATE_PROB_PERIOD_START' then
2897: /*l_return_value := fnd_date.date_to_canonical(
2898: g_rpa_attr(l_pa_request_id).Date_Prob_period_start) ;*/
2899: l_return_value := (
2900: g_rpa_attr(l_pa_request_id).Date_Prob_period_start) ;
2901: elsif p_input_value ='RPA_SUPV_MGR_PROB_PERIOD_REQ' then

Line 2904: /* l_return_value := fnd_date.date_to_canonical(

2900: g_rpa_attr(l_pa_request_id).Date_Prob_period_start) ;
2901: elsif p_input_value ='RPA_SUPV_MGR_PROB_PERIOD_REQ' then
2902: l_return_value := g_rpa_attr(l_pa_request_id).Supv_mgr_prob_period_req ;
2903: elsif p_input_value ='RPA_DATE_CAREER_PERMA_TEN_ST' then
2904: /* l_return_value := fnd_date.date_to_canonical(
2905: g_rpa_attr(l_pa_request_id).Date_Career_perma_Ten_St) ; */
2906: l_return_value := (
2907: g_rpa_attr(l_pa_request_id).Date_Career_perma_Ten_St) ;
2908: elsif p_input_value ='RPA_DATE_RET_RGHT_END' then

Line 2928: l_return_value := fnd_date.date_to_canonical(

2924: l_return_value := g_rpa_attr(l_pa_request_id).Saved_Grd_Pay_Plan ;
2925: elsif p_input_value ='RPA_SAVED_GRADE' then
2926: l_return_value := g_rpa_attr(l_pa_request_id).Saved_Grade ;
2927: elsif p_input_value ='RPA_DATE_CORR_NOA' then
2928: l_return_value := fnd_date.date_to_canonical(
2929: g_rpa_attr(l_pa_request_id).Date_Corr_NoA) ;
2930: elsif p_input_value ='RPA_DATE_NTE_SF50' then
2931: l_return_value := (
2932: g_rpa_attr(l_pa_request_id).Date_NTE_SF50) ;

Line 3014: /*l_return_value := fnd_date.date_to_canonical(

3010: END IF;
3011: END IF;
3012:
3013: elsif p_input_value ='RPA_DATE_SCD_WGI' then
3014: /*l_return_value := fnd_date.date_to_canonical(
3015: g_rpa_attr(l_pa_request_id).dt_scd_wgi);*/
3016: l_return_value := (
3017: g_rpa_attr(l_pa_request_id).dt_scd_wgi);
3018: elsif p_input_value ='RPA_AUTH_DT' then

Line 3206: l_return_value :=fnd_date.date_to_canonical(g_rpa_rec(l_pa_request_id).effective_date);

3202: l_return_value :=
3203: g_rpa_rec(l_pa_request_id).altered_pa_request_id;
3204: elsif p_input_value ='REM_PA_DATE' then
3205:
3206: l_return_value :=fnd_date.date_to_canonical(g_rpa_rec(l_pa_request_id).effective_date);
3207: -- FND_DATE.CANONICAL_TO_DATE(g_rpa_rec(l_pa_request_id).effective_date);
3208:
3209: elsif p_input_value ='REM_DESC_0109' then
3210: --Hr_Utility.set_location(' p_input_value: '||p_input_value, 6);

Line 3207: -- FND_DATE.CANONICAL_TO_DATE(g_rpa_rec(l_pa_request_id).effective_date);

3203: g_rpa_rec(l_pa_request_id).altered_pa_request_id;
3204: elsif p_input_value ='REM_PA_DATE' then
3205:
3206: l_return_value :=fnd_date.date_to_canonical(g_rpa_rec(l_pa_request_id).effective_date);
3207: -- FND_DATE.CANONICAL_TO_DATE(g_rpa_rec(l_pa_request_id).effective_date);
3208:
3209: elsif p_input_value ='REM_DESC_0109' then
3210: --Hr_Utility.set_location(' p_input_value: '||p_input_value, 6);
3211: l_return_value :=SUBSTR(l_value,0,524);

Line 3295: l_return_value :=FND_DATE.date_to_canonical(g_awd_rec(l_pa_request_id).effective_date);

3291: l_return_value :=
3292: g_awd_rec(l_pa_request_id).altered_pa_request_id;
3293: elsif p_input_value ='REM_PA_DATE' then
3294:
3295: l_return_value :=FND_DATE.date_to_canonical(g_awd_rec(l_pa_request_id).effective_date);
3296: -- FND_DATE.CANONICAL_TO_DATE(g_rpa_rec(l_pa_request_id).effective_date);
3297:
3298: elsif p_input_value ='REM_DESC_0109' then
3299: --Hr_Utility.set_location(' p_input_value: '||p_input_value, 6);

Line 3296: -- FND_DATE.CANONICAL_TO_DATE(g_rpa_rec(l_pa_request_id).effective_date);

3292: g_awd_rec(l_pa_request_id).altered_pa_request_id;
3293: elsif p_input_value ='REM_PA_DATE' then
3294:
3295: l_return_value :=FND_DATE.date_to_canonical(g_awd_rec(l_pa_request_id).effective_date);
3296: -- FND_DATE.CANONICAL_TO_DATE(g_rpa_rec(l_pa_request_id).effective_date);
3297:
3298: elsif p_input_value ='REM_DESC_0109' then
3299: --Hr_Utility.set_location(' p_input_value: '||p_input_value, 6);
3300: l_return_value :=SUBSTR(l_value,0,524);

Line 3420: l_return_value := FND_DATE.date_to_canonical(g_awd_rec(l_pa_request_id).effective_date);

3416:
3417:
3418: elsif p_input_value ='AWD_PERS_EFF_DT' then
3419:
3420: l_return_value := FND_DATE.date_to_canonical(g_awd_rec(l_pa_request_id).effective_date);
3421:
3422: elsif p_input_value ='AWD_CSC_OTH_LEG_AUTH' then
3423:
3424: l_return_value := g_awd_rec(l_pa_request_id).FIRST_ACTION_LA_DESC1;

Line 3434: l_return_value := fnd_date.date_to_canonical(g_rpa_awd_attr(l_pa_request_id).dt_cash_awd_from);

3430:
3431: l_return_value := g_rpa_awd_attr(l_pa_request_id).dept_code;
3432:
3433: elsif p_input_value ='AWD_DT_CSH_AWD_FRM' then
3434: l_return_value := fnd_date.date_to_canonical(g_rpa_awd_attr(l_pa_request_id).dt_cash_awd_from);
3435:
3436: elsif p_input_value ='AWD_DT_CSH_AWD_TO' then
3437:
3438: l_return_value := fnd_date.date_to_canonical(g_rpa_awd_attr(l_pa_request_id).dt_cash_awd_to) ;

Line 3438: l_return_value := fnd_date.date_to_canonical(g_rpa_awd_attr(l_pa_request_id).dt_cash_awd_to) ;

3434: l_return_value := fnd_date.date_to_canonical(g_rpa_awd_attr(l_pa_request_id).dt_cash_awd_from);
3435:
3436: elsif p_input_value ='AWD_DT_CSH_AWD_TO' then
3437:
3438: l_return_value := fnd_date.date_to_canonical(g_rpa_awd_attr(l_pa_request_id).dt_cash_awd_to) ;
3439: elsif p_input_value ='AWD_TANG_BEN' then
3440:
3441: l_return_value := g_rpa_awd_attr(l_pa_request_id).tangible_ben ;
3442:

Line 3599: l_return_value := fnd_date.date_to_canonical(

3595: if (l_address_id is not null )then
3596:
3597: if p_input_value ='ADD_EFF_DATE' then
3598:
3599: l_return_value := fnd_date.date_to_canonical(
3600: g_address_rec(p_assignment_id).effective_date);
3601:
3602: elsif p_input_value ='ADD_LINE1' then
3603:

Line 5312: l_ff_value_fmt := Ben_Ext_Fmt.apply_format_mask(Fnd_Date.canonical_to_date(l_ff_value),

5308: l_ff_value_fmt := Ben_Ext_Fmt.apply_format_mask(To_Number(l_ff_value), i.frmt_mask_cd);
5309: l_ff_value := l_ff_value_fmt;
5310: elsif Substr(i.frmt_mask_lookup_cd,1,1) = 'D' then
5311: Hr_Utility.set_location('..Applying Date format mask :ben_ext_fmt.apply_format_mask',55);
5312: l_ff_value_fmt := Ben_Ext_Fmt.apply_format_mask(Fnd_Date.canonical_to_date(l_ff_value),
5313: i.frmt_mask_cd);
5314: l_ff_value := l_ff_value_fmt;
5315: end if;
5316: end if;

Line 6204: g_extract_params(j).from_date := Fnd_Date.canonical_to_date(l_req_params.argument12);

6200: g_extract_params(j).transmission_type := l_req_params.argument7;
6201: g_extract_params(j).date_criteria := l_req_params.argument8;
6202: Hr_Utility.set_location('..Extract params', 17);
6203:
6204: g_extract_params(j).from_date := Fnd_Date.canonical_to_date(l_req_params.argument12);
6205: g_extract_params(j).to_date := Fnd_Date.canonical_to_date(l_req_params.argument13);
6206: Hr_Utility.set_location('..Extract params', 20);
6207: g_extract_params(j).agency_code := l_req_params.argument14;
6208: g_extract_params(j).personnel_office_id := l_req_params.argument15;

Line 6205: g_extract_params(j).to_date := Fnd_Date.canonical_to_date(l_req_params.argument13);

6201: g_extract_params(j).date_criteria := l_req_params.argument8;
6202: Hr_Utility.set_location('..Extract params', 17);
6203:
6204: g_extract_params(j).from_date := Fnd_Date.canonical_to_date(l_req_params.argument12);
6205: g_extract_params(j).to_date := Fnd_Date.canonical_to_date(l_req_params.argument13);
6206: Hr_Utility.set_location('..Extract params', 20);
6207: g_extract_params(j).agency_code := l_req_params.argument14;
6208: g_extract_params(j).personnel_office_id := l_req_params.argument15;
6209: g_extract_params(j).transmission_indicator := l_req_params.argument16;