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

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

1344: l_ff_value_fmt := Ben_Ext_Fmt .apply_format_mask (To_Number(l_ff_value), i.frmt_mask_cd);
1345: l_ff_value := l_ff_value_fmt;
1346: ELSIF Substr(i.frmt_mask_lookup_cd,1,1) = 'D' THEN
1347: Hr_Utility.set_location('..Applying Date format mask :ben_ext_fmt.apply_format_mask' ,55);
1348: l_ff_value_fmt := Ben_Ext_Fmt .apply_format_mask (Fnd_Date.canonical_to_date(l_ff_value),
1349: i.frmt_mask_cd);
1350: l_ff_value := l_ff_value_fmt;
1351: END IF;
1352: END IF;

Line 2372: Fnd_Date.canonical_to_date(l_ext_params.attribute3);

2368: g_extract_params(bg_id).payroll_id := l_ext_params.value2;
2369: g_extract_params(bg_id).con_set_id := l_ext_params.value3;
2370: g_extract_params(bg_id).org_id := l_ext_params.value4;
2371: g_extract_params(bg_id).extract_start_date :=
2372: Fnd_Date.canonical_to_date(l_ext_params.attribute3);
2373: g_extract_params(bg_id).extract_end_date :=
2374: Fnd_Date.canonical_to_date(l_ext_params.attribute4);
2375: g_extract_params(bg_id).extract_type := l_ext_params.attribute5;
2376:

Line 2374: Fnd_Date.canonical_to_date(l_ext_params.attribute4);

2370: g_extract_params(bg_id).org_id := l_ext_params.value4;
2371: g_extract_params(bg_id).extract_start_date :=
2372: Fnd_Date.canonical_to_date(l_ext_params.attribute3);
2373: g_extract_params(bg_id).extract_end_date :=
2374: Fnd_Date.canonical_to_date(l_ext_params.attribute4);
2375: g_extract_params(bg_id).extract_type := l_ext_params.attribute5;
2376:
2377: OPEN csr_leg_code (c_business_group_id => p_business_group_id);
2378: FETCH csr_leg_code INTO g_extract_params(bg_id).legislation_code,

Line 3407: fnd_date.canonical_to_date (org_information1)

3403: FROM hr_organization_information
3404: WHERE org_information_context = 'PQP_NL_PGGM_INFO'
3405: AND organization_id = c_org_id
3406: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN
3407: fnd_date.canonical_to_date (org_information1)
3408: AND nvl(fnd_date.canonical_to_date (org_information2), to_date('47121231','YYYYMMDD'));
3409:
3410: l_proc_name Varchar2(150) :=g_proc_name || 'Get_CAO_Code';
3411: l_ret_val Number:=0;

Line 3408: AND nvl(fnd_date.canonical_to_date (org_information2), to_date('47121231','YYYYMMDD'));

3404: WHERE org_information_context = 'PQP_NL_PGGM_INFO'
3405: AND organization_id = c_org_id
3406: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN
3407: fnd_date.canonical_to_date (org_information1)
3408: AND nvl(fnd_date.canonical_to_date (org_information2), to_date('47121231','YYYYMMDD'));
3409:
3410: l_proc_name Varchar2(150) :=g_proc_name || 'Get_CAO_Code';
3411: l_ret_val Number:=0;
3412: l_cao_code varchar2(10):='';

Line 3486: fnd_date.canonical_to_date (org_information1)

3482: FROM hr_organization_information
3483: WHERE organization_id = c_org_id
3484: AND org_information_context = 'PQP_NL_PGGM_INFO'
3485: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN
3486: fnd_date.canonical_to_date (org_information1)
3487: AND nvl(fnd_date.canonical_to_date (org_information2), to_date('47121231','YYYYMMDD'));
3488:
3489: l_proc_name Varchar2(150) :=g_proc_name || 'Get_Emp_Reg_Num';
3490: l_ret_val Number:=0;

Line 3487: AND nvl(fnd_date.canonical_to_date (org_information2), to_date('47121231','YYYYMMDD'));

3483: WHERE organization_id = c_org_id
3484: AND org_information_context = 'PQP_NL_PGGM_INFO'
3485: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN
3486: fnd_date.canonical_to_date (org_information1)
3487: AND nvl(fnd_date.canonical_to_date (org_information2), to_date('47121231','YYYYMMDD'));
3488:
3489: l_proc_name Varchar2(150) :=g_proc_name || 'Get_Emp_Reg_Num';
3490: l_ret_val Number:=0;
3491: l_emp_reg_num varchar2(16):='';