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.PAY_FR_SICKNESS_CALC dependencies on PAY_FR_SICK_PAY_PROCESSING

Line 640: p_asg IN pay_fr_sick_pay_processing.t_asg,

636:
637: PROCEDURE Calculate_Sickness_Deduction
638: (p_absence_start_date IN date,
639: p_absence_end_date IN date,
640: p_asg IN pay_fr_sick_pay_processing.t_asg,
641: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch) IS
642:
643: /* declare local variables */
644:

Line 641: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch) IS

637: PROCEDURE Calculate_Sickness_Deduction
638: (p_absence_start_date IN date,
639: p_absence_end_date IN date,
640: p_asg IN pay_fr_sick_pay_processing.t_asg,
641: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch) IS
642:
643: /* declare local variables */
644:
645: l_inputs ff_exec.inputs_t;

Line 1862: (p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch

1858: -- Function to compare the best net guarantee and to return the
1859: -- adjustment to previous paymnts if the best method changes
1860: -----------------------------------------------------------------
1861: PROCEDURE Compare_Guarantee
1862: (p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch
1863: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages) IS
1864: --
1865: total_net number;
1866: best_net number;

Line 1863: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages) IS

1859: -- adjustment to previous paymnts if the best method changes
1860: -----------------------------------------------------------------
1861: PROCEDURE Compare_Guarantee
1862: (p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch
1863: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages) IS
1864: --
1865: total_net number;
1866: best_net number;
1867: best_net_index number;

Line 1940: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages

1936: PROCEDURE Calc_IJSS_Gross
1937: (p_IJSS_Gross_Start_Date IN Date
1938: ,p_IJSS_Gross_End_Date IN Date
1939: ,p_coverage_idx IN Number
1940: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages
1941: ,p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch) IS
1942: --
1943: TYPE t_ijss_gross_rec IS RECORD
1944: (Gross number

Line 1941: ,p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch) IS

1937: (p_IJSS_Gross_Start_Date IN Date
1938: ,p_IJSS_Gross_End_Date IN Date
1939: ,p_coverage_idx IN Number
1940: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages
1941: ,p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch) IS
1942: --
1943: TYPE t_ijss_gross_rec IS RECORD
1944: (Gross number
1945: ,Rate number

Line 2060: ( p_asg In pay_fr_sick_pay_processing.t_asg

2056: --This will be called from calc_sicknes procedure
2057: ------------------------------------------------------------------------
2058:
2059: Procedure absence_not_processed
2060: ( p_asg In pay_fr_sick_pay_processing.t_asg
2061: ,p_sickness_start_date In Date
2062: ) As
2063:
2064: -- Added another parameters to fetch IJSS estimation flag

Line 2284: p_asg IN OUT NOCOPY pay_fr_sick_pay_processing.t_asg,

2280: End absence_not_processed;
2281: --
2282: PROCEDURE Calc_Sickness(
2283: P_mode IN OUT NOCOPY VARCHAR2 ,
2284: p_asg IN OUT NOCOPY pay_fr_sick_pay_processing.t_asg,
2285: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch,
2286: p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages) IS
2287: --
2288: -- cursor added for CPAM payment

Line 2285: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch,

2281: --
2282: PROCEDURE Calc_Sickness(
2283: P_mode IN OUT NOCOPY VARCHAR2 ,
2284: p_asg IN OUT NOCOPY pay_fr_sick_pay_processing.t_asg,
2285: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch,
2286: p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages) IS
2287: --
2288: -- cursor added for CPAM payment
2289: -- to get period start and end dates for absence being processed

Line 2286: p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages) IS

2282: PROCEDURE Calc_Sickness(
2283: P_mode IN OUT NOCOPY VARCHAR2 ,
2284: p_asg IN OUT NOCOPY pay_fr_sick_pay_processing.t_asg,
2285: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch,
2286: p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages) IS
2287: --
2288: -- cursor added for CPAM payment
2289: -- to get period start and end dates for absence being processed
2290: cursor csr_abs_period_dates (c_business_group_id number

Line 2444: := pay_fr_sick_pay_processing.get_guarantee_id('NO_G');

2440: -- Populate a row for No Guarantee always
2441: --
2442: l_index := nvl(p_coverages.LAST, 0) + 1;
2443: p_coverages(l_index).g_type
2444: := pay_fr_sick_pay_processing.get_guarantee_id('NO_G');
2445:
2446: --
2447: else -- p_mode = 'C'
2448: Compare_Guarantee

Line 2473: p_coverages(l_idx_bm).g_type = pay_fr_sick_pay_processing.get_guarantee_id('GN') THEN

2469:
2470: -- Check g_type, overlapping it with the g_guarantee_type_lookups
2471: IF l_idx_bm <> -1 THEN
2472: IF p_coverages(l_idx_bm).g_type <> -1 AND
2473: p_coverages(l_idx_bm).g_type = pay_fr_sick_pay_processing.get_guarantee_id('GN') THEN
2474: hr_utility.set_location('Calculations when guarantee is GN', 22);
2475: p_absence_arch.partial_paid_days := 0;
2476: p_absence_arch.unpaid_days := l_total_days - (p_coverages(l_idx_bm).gi_days1 + p_coverages(l_idx_bm).gi_days2);
2477: ELSE

Line 2634: p_asg IN pay_fr_sick_pay_processing.t_asg,

2630: -----------------------------------------------------------------------
2631: --
2632: PROCEDURE Get_GI_Payments_Audit
2633: (p_GI_id IN Number,
2634: p_asg IN pay_fr_sick_pay_processing.t_asg,
2635: p_parent_absence_id IN Number,
2636: p_current_date IN Date,
2637: p_GI_Previous_Net OUT NOCOPY Number,
2638: p_GI_Previous_Payment OUT NOCOPY Number,

Line 2797: p_asg IN pay_fr_sick_pay_processing.t_asg)

2793: p_ov_band4_days IN OUT NOCOPY NUMBER,
2794: p_ov_gi_id IN NUMBER,
2795: p_date_from IN DATE,
2796: p_date_to IN DATE,
2797: p_asg IN pay_fr_sick_pay_processing.t_asg)
2798: IS
2799:
2800: l_proc varchar2(72) := g_package||'Band_Overlaps';
2801: l_ov_gi_id_chr varchar2(100) := to_char(p_ov_gi_id);

Line 2966: p_asg IN pay_fr_sick_pay_processing.t_asg,

2962: -- Uses Band_overlaps from above
2963: -----------------------------------------------------------------------
2964: PROCEDURE Get_GI_Bands_Audit
2965: (p_GI_id IN Number,
2966: p_asg IN pay_fr_sick_pay_processing.t_asg,
2967: p_date_to IN Date,
2968: p_band_expiry_duration IN Varchar2,
2969: p_band1_days OUT NOCOPY Number,
2970: p_band2_days OUT NOCOPY Number,

Line 3201: p_asg IN pay_fr_sick_pay_processing.t_asg,

3197: --------------********************--------------
3198: -- CALC_LEGAL_GI
3199: -- Calculate Legal Guaranteed Income
3200: PROCEDURE Calc_LEGAL_GI(
3201: p_asg IN pay_fr_sick_pay_processing.t_asg,
3202: p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages,
3203: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch ) IS
3204:
3205: --

Line 3202: p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages,

3198: -- CALC_LEGAL_GI
3199: -- Calculate Legal Guaranteed Income
3200: PROCEDURE Calc_LEGAL_GI(
3201: p_asg IN pay_fr_sick_pay_processing.t_asg,
3202: p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages,
3203: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch ) IS
3204:
3205: --
3206: l_assgt_id NUMBER := p_asg.assignment_id;

Line 3203: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch ) IS

3199: -- Calculate Legal Guaranteed Income
3200: PROCEDURE Calc_LEGAL_GI(
3201: p_asg IN pay_fr_sick_pay_processing.t_asg,
3202: p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages,
3203: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch ) IS
3204:
3205: --
3206: l_assgt_id NUMBER := p_asg.assignment_id;
3207: l_business_group_id NUMBER := p_asg.business_group_id;

Line 3359: -- Get numeric code for the Guarantee type from global table g_guarantee_lookup_types in the PAY_FR_SICK_PAY_PROCESSING package

3355:
3356: -- Get index for g_coverages table
3357: l_idx := nvl(p_coverages.LAST, 0) + 1;
3358:
3359: -- Get numeric code for the Guarantee type from global table g_guarantee_lookup_types in the PAY_FR_SICK_PAY_PROCESSING package
3360: -- This should use a common function for both LEGI and CAGR
3361: -- For LEGI, the code returned would have a value of 20
3362: l_legi_code := PAY_FR_SICK_PAY_PROCESSING.Get_guarantee_id('LE');
3363:

Line 3362: l_legi_code := PAY_FR_SICK_PAY_PROCESSING.Get_guarantee_id('LE');

3358:
3359: -- Get numeric code for the Guarantee type from global table g_guarantee_lookup_types in the PAY_FR_SICK_PAY_PROCESSING package
3360: -- This should use a common function for both LEGI and CAGR
3361: -- For LEGI, the code returned would have a value of 20
3362: l_legi_code := PAY_FR_SICK_PAY_PROCESSING.Get_guarantee_id('LE');
3363:
3364: -- Only if values are not null, should a row be populated in g_coverages for the current GI
3365: IF nvl(l_GI_previous_net,0) > 0
3366: OR nvl(l_GI_previous_payment,0) > 0

Line 3386: -- A global held in Pay_fr_sick_pay_processing p_asg.lg_ref_salary holds the Balance value

3382: L_B1_avail_days := l_B1_days - l_B1_used_days;
3383: L_B2_avail_days := l_B2_days - l_B2_used_days;
3384:
3385: -- Calculate Daily Ref Salary for LEGI
3386: -- A global held in Pay_fr_sick_pay_processing p_asg.lg_ref_salary holds the Balance value
3387: -- 'FR_SICKNESS_LEGAL_GUARANTEE_REFERENCE_SALARY_ASG_PRO_RUN'
3388: -- and proration dates p_asg.action_start_date and p_asg.action_end_date
3389: -- Raising an error if the reference salary is null
3390: l_LEGI_ref_sal := p_asg.lg_ref_salary;

Line 3502: p_asg in pay_fr_sick_pay_processing.t_asg) return number

3498: ----------------------------------------------------------------------
3499: Function Get_CAGR_reference_salary (
3500: p_balance_name in varchar2,
3501: p_gi_type in varchar2,
3502: p_asg in pay_fr_sick_pay_processing.t_asg) return number
3503: IS
3504: Cursor csr_def_bal_id IS
3505: SELECT pdb.defined_balance_id
3506: FROM pay_balance_types_tl pbt,

Line 3592: (p_asg IN pay_fr_sick_pay_processing.t_asg

3588: -- CALC_CAGR_GI
3589: -- Calculate Legal Guaranteed Income
3590:
3591: PROCEDURE Calc_CAGR_GI
3592: (p_asg IN pay_fr_sick_pay_processing.t_asg
3593: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages
3594: ,p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch) is
3595:
3596: --

Line 3593: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages

3589: -- Calculate Legal Guaranteed Income
3590:
3591: PROCEDURE Calc_CAGR_GI
3592: (p_asg IN pay_fr_sick_pay_processing.t_asg
3593: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages
3594: ,p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch) is
3595:
3596: --
3597: l_proc varchar2(72) := g_package||'calc_cagr_gi';

Line 3594: ,p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch) is

3590:
3591: PROCEDURE Calc_CAGR_GI
3592: (p_asg IN pay_fr_sick_pay_processing.t_asg
3593: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages
3594: ,p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch) is
3595:
3596: --
3597: l_proc varchar2(72) := g_package||'calc_cagr_gi';
3598:

Line 3825: -- in the PAY_FR_SICK_PAY_PROCESSING package.

3821:
3822: hr_utility.set_location(' IN:'|| l_proc,45);
3823: --
3824: -- Get numeric code for the Guarantee type from global table g_guarantee_lookup_types
3825: -- in the PAY_FR_SICK_PAY_PROCESSING package.
3826: -- Using a common function for both LEGI and CAGR
3827:
3828: l_gi_code := PAY_FR_SICK_PAY_PROCESSING.Get_guarantee_id(l_ben.guarantee_type);
3829:

Line 3828: l_gi_code := PAY_FR_SICK_PAY_PROCESSING.Get_guarantee_id(l_ben.guarantee_type);

3824: -- Get numeric code for the Guarantee type from global table g_guarantee_lookup_types
3825: -- in the PAY_FR_SICK_PAY_PROCESSING package.
3826: -- Using a common function for both LEGI and CAGR
3827:
3828: l_gi_code := PAY_FR_SICK_PAY_PROCESSING.Get_guarantee_id(l_ben.guarantee_type);
3829:
3830: -- Get Daily Reference Salary for guarantee
3831: l_CAGR_daily_ref_sal := Get_CAGR_reference_salary(
3832: p_balance_name => l_ben.balance,

Line 4243: P_Absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_asg)

4239: -- Procedure for reference salary balances
4240: PROCEDURE Get_CPAM_Ref_salary(
4241: P_Business_group_id IN Number,
4242: P_Assignment_id IN Number,
4243: P_Absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_asg)
4244:
4245: IS
4246: --
4247: cursor c_get_defined_balance(p_balance_name VARCHAR2) is