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.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on HR_GB_PROCESS_P11D_ENTRIES_PKG

Line 1: PACKAGE BODY HR_GB_PROCESS_P11D_ENTRIES_PKG as

1: PACKAGE BODY HR_GB_PROCESS_P11D_ENTRIES_PKG as
2: /* $Header: pygbp11d.pkb 120.43.12020000.3 2012/07/06 10:43:01 vmaripal ship $ */
3: g_package constant VARCHAR2(33) := ' hr_gb_process_p11d_entries_pkg.';
4: procedure clob_to_blob(p_clob clob,
5: p_blob in out nocopy Blob)

Line 3: g_package constant VARCHAR2(33) := ' hr_gb_process_p11d_entries_pkg.';

1: PACKAGE BODY HR_GB_PROCESS_P11D_ENTRIES_PKG as
2: /* $Header: pygbp11d.pkb 120.43.12020000.3 2012/07/06 10:43:01 vmaripal ship $ */
3: g_package constant VARCHAR2(33) := ' hr_gb_process_p11d_entries_pkg.';
4: procedure clob_to_blob(p_clob clob,
5: p_blob in out nocopy Blob)
6: is
7: l_length_clob number;

Line 3823: --hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_CO2_EMISSIONS',l_BEN_ED_DATE)

3819: if (to_number(l_rep_run)) > 2008 then --P11D 08/09
3820: if fnd_date.canonical_to_date( car_rec.date_registered)
3821: >= to_date('01-01-1998','dd-mm-yyyy') and car_rec.CO2 is not null
3822: and car_rec.CO2 > 120 -- P11D 08/09
3823: --hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_CO2_EMISSIONS',l_BEN_ED_DATE)
3824: then
3825: hr_utility.trace('a');
3826: -- Bug 13618076: Co2 value should not be rounded for values between 121 to 124
3827: if car_rec.CO2 > 125 then

Line 3851: -- hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_CO2_EMISSIONS',l_BEN_ED_DATE)

3847: /* bug 8277887 car_rec.CO2 is not null to nvl(car_rec.CO2,0) > 0 */
3848: elsif fnd_date.canonical_to_date(car_rec.date_registered)
3849: >= to_date('01-01-1998','dd-mm-yyyy') and nvl(car_rec.CO2,0) > 0
3850: and car_rec.CO2 <= 120 then -- P11D 08/09
3851: -- hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_CO2_EMISSIONS',l_BEN_ED_DATE)
3852: /* The below if condition will check for all the fuel types except for type 'D' Bug:10432169 */
3853: if car_rec.f_fuel = 'B' OR car_rec.f_fuel = 'C' OR car_rec.f_fuel = 'G' OR
3854: car_rec.f_fuel = 'H' OR car_rec.f_fuel = 'P' OR ( car_rec.f_fuel = 'L' AND fnd_date.canonical_to_date(car_rec.date_registered)
3855: < to_date('01-01-2006','dd-mm-yyyy')) then

Line 3857: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_PERCENTAGE_LOWER',car_rec.full_end_date) ;

3853: if car_rec.f_fuel = 'B' OR car_rec.f_fuel = 'C' OR car_rec.f_fuel = 'G' OR
3854: car_rec.f_fuel = 'H' OR car_rec.f_fuel = 'P' OR ( car_rec.f_fuel = 'L' AND fnd_date.canonical_to_date(car_rec.date_registered)
3855: < to_date('01-01-2006','dd-mm-yyyy')) then
3856: if car_rec.CO2 <= 75 then
3857: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_PERCENTAGE_LOWER',car_rec.full_end_date) ;
3858: else
3859: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_PERCENTAGE',car_rec.full_end_date) ;
3860: end if;
3861: /* The below if condition checks for the fuel type L and date registered should be greater than 1-1-2006 Bug:10432169 */

Line 3859: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_PERCENTAGE',car_rec.full_end_date) ;

3855: < to_date('01-01-2006','dd-mm-yyyy')) then
3856: if car_rec.CO2 <= 75 then
3857: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_PERCENTAGE_LOWER',car_rec.full_end_date) ;
3858: else
3859: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_PERCENTAGE',car_rec.full_end_date) ;
3860: end if;
3861: /* The below if condition checks for the fuel type L and date registered should be greater than 1-1-2006 Bug:10432169 */
3862: elsif (car_rec.f_fuel = 'L' AND fnd_date.canonical_to_date(car_rec.date_registered)
3863: >= to_date('01-01-2006','dd-mm-yyyy')) OR car_rec.f_fuel = 'D' then

Line 3865: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_DIESEL_PERCENTAGE_LOWER',car_rec.full_end_date) ;

3861: /* The below if condition checks for the fuel type L and date registered should be greater than 1-1-2006 Bug:10432169 */
3862: elsif (car_rec.f_fuel = 'L' AND fnd_date.canonical_to_date(car_rec.date_registered)
3863: >= to_date('01-01-2006','dd-mm-yyyy')) OR car_rec.f_fuel = 'D' then
3864: if car_rec.CO2 <= 75 then
3865: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_DIESEL_PERCENTAGE_LOWER',car_rec.full_end_date) ;
3866: else
3867: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_DIESEL_PERCENTAGE',car_rec.full_end_date) ;
3868: end if;
3869: end if;

Line 3867: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_DIESEL_PERCENTAGE',car_rec.full_end_date) ;

3863: >= to_date('01-01-2006','dd-mm-yyyy')) OR car_rec.f_fuel = 'D' then
3864: if car_rec.CO2 <= 75 then
3865: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_DIESEL_PERCENTAGE_LOWER',car_rec.full_end_date) ;
3866: else
3867: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_DIESEL_PERCENTAGE',car_rec.full_end_date) ;
3868: end if;
3869: end if;
3870:
3871:

Line 3878: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_PERCENTAGE_LOWER',car_rec.full_end_date) ;

3874: IF (to_number(l_rep_run)) > 2011 THEN
3875: if car_rec.f_fuel = 'B' OR car_rec.f_fuel = 'C' OR car_rec.f_fuel = 'G' OR
3876: car_rec.f_fuel = 'H' OR car_rec.f_fuel = 'P' then
3877: if car_rec.CO2 <= 75 then
3878: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_PERCENTAGE_LOWER',car_rec.full_end_date) ;
3879: else
3880: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_PERCENTAGE',car_rec.full_end_date) ;
3881: end if;
3882:

Line 3880: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_PERCENTAGE',car_rec.full_end_date) ;

3876: car_rec.f_fuel = 'H' OR car_rec.f_fuel = 'P' then
3877: if car_rec.CO2 <= 75 then
3878: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_PERCENTAGE_LOWER',car_rec.full_end_date) ;
3879: else
3880: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_PERCENTAGE',car_rec.full_end_date) ;
3881: end if;
3882:
3883: elsif car_rec.f_fuel = 'L' OR car_rec.f_fuel = 'D' then
3884: if car_rec.CO2 <= 75 then

Line 3885: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_DIESEL_PERCENTAGE_LOWER',car_rec.full_end_date) ;

3881: end if;
3882:
3883: elsif car_rec.f_fuel = 'L' OR car_rec.f_fuel = 'D' then
3884: if car_rec.CO2 <= 75 then
3885: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_DIESEL_PERCENTAGE_LOWER',car_rec.full_end_date) ;
3886: else
3887: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_DIESEL_PERCENTAGE',car_rec.full_end_date) ;
3888: end if;
3889: end if;

Line 3887: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_DIESEL_PERCENTAGE',car_rec.full_end_date) ;

3883: elsif car_rec.f_fuel = 'L' OR car_rec.f_fuel = 'D' then
3884: if car_rec.CO2 <= 75 then
3885: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_DIESEL_PERCENTAGE_LOWER',car_rec.full_end_date) ;
3886: else
3887: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_DIESEL_PERCENTAGE',car_rec.full_end_date) ;
3888: end if;
3889: end if;
3890: END IF;
3891:

Line 6699: end hr_gb_process_p11d_entries_pkg;

6695: p_INT_MAX_AMT_OUTSTANDING := nvl(l_ce_values_c.action_information21,'0');
6696: END IF;
6697: RETURN l_write_to_magtape;
6698: END;
6699: end hr_gb_process_p11d_entries_pkg;