DBA Data[Home] [Help]

APPS.PAY_FR_SICKNESS_CALC dependencies on PAY_FR_SICK_PAY_PROCESSING

Line 128: p_asg IN pay_fr_sick_pay_processing.t_asg,

124:
125: PROCEDURE Calculate_Sickness_Deduction
126: (p_absence_start_date IN date,
127: p_absence_end_date IN date,
128: p_asg IN pay_fr_sick_pay_processing.t_asg,
129: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch);
130:
131: -- GET_OPEN_DAYS
132: -- Function to calculate open days between two dates

Line 129: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch);

125: PROCEDURE Calculate_Sickness_Deduction
126: (p_absence_start_date IN date,
127: p_absence_end_date IN date,
128: p_asg IN pay_fr_sick_pay_processing.t_asg,
129: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch);
130:
131: -- GET_OPEN_DAYS
132: -- Function to calculate open days between two dates
133: FUNCTION Get_Open_Days

Line 165: p_asg IN pay_fr_sick_pay_processing.t_asg,

161: -- Common Functions for LEGI / CAGR
162: --
163: PROCEDURE Get_GI_Bands_Audit
164: (p_GI_id IN Number,
165: p_asg IN pay_fr_sick_pay_processing.t_asg,
166: p_date_to IN Date,
167: p_band_expiry_duration IN Varchar2,
168: p_band1_days OUT NOCOPY Number,
169: p_band2_days OUT NOCOPY Number,

Line 183: p_asg IN pay_fr_sick_pay_processing.t_asg,

179: --
180:
181: PROCEDURE Get_GI_Payments_Audit
182: (p_GI_id IN Number,
183: p_asg IN pay_fr_sick_pay_processing.t_asg,
184: p_parent_absence_id IN Number,
185: p_current_date IN Date,
186: p_GI_Previous_Net OUT NOCOPY Number,
187: p_GI_Previous_Payment OUT NOCOPY Number,

Line 217: (p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch

213: RETURN Varchar2;
214: --
215:
216: PROCEDURE Compare_Guarantee
217: (p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch
218: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages);
219: --
220: -- CALC_SICKNESS
221: -- initiates all sickness calculations and performs comparison of

Line 218: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages);

214: --
215:
216: PROCEDURE Compare_Guarantee
217: (p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch
218: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages);
219: --
220: -- CALC_SICKNESS
221: -- initiates all sickness calculations and performs comparison of
222: -- most beneficial guarantee over the whole absence period.

Line 226: p_asg IN OUT NOCOPY pay_fr_sick_pay_processing.t_asg,

222: -- most beneficial guarantee over the whole absence period.
223: --
224: PROCEDURE calc_sickness(
225: P_mode IN OUT NOCOPY VARCHAR2 ,
226: p_asg IN OUT NOCOPY pay_fr_sick_pay_processing.t_asg,
227: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch,
228: p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages);
229: --
230: -----------------------------------------------------------------------

Line 227: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch,

223: --
224: PROCEDURE calc_sickness(
225: P_mode IN OUT NOCOPY VARCHAR2 ,
226: p_asg IN OUT NOCOPY pay_fr_sick_pay_processing.t_asg,
227: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch,
228: p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages);
229: --
230: -----------------------------------------------------------------------
231: -- Function FR_ROLLING_BALANCE

Line 228: p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages);

224: PROCEDURE calc_sickness(
225: P_mode IN OUT NOCOPY VARCHAR2 ,
226: p_asg IN OUT NOCOPY pay_fr_sick_pay_processing.t_asg,
227: p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch,
228: p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages);
229: --
230: -----------------------------------------------------------------------
231: -- Function FR_ROLLING_BALANCE
232: ----------------------------------------------------------------------

Line 245: (p_asg IN pay_fr_sick_pay_processing.t_asg

241: -----------------------------------------------------------------------
242: -- Calculate Legal Guaranteed Income
243: --
244: PROCEDURE Calc_LEGAL_GI
245: (p_asg IN pay_fr_sick_pay_processing.t_asg
246: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages
247: ,p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch);
248:
249: -- CALC_CAGR_GI

Line 246: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages

242: -- Calculate Legal Guaranteed Income
243: --
244: PROCEDURE Calc_LEGAL_GI
245: (p_asg IN pay_fr_sick_pay_processing.t_asg
246: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages
247: ,p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch);
248:
249: -- CALC_CAGR_GI
250: PROCEDURE Calc_CAGR_GI

Line 247: ,p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch);

243: --
244: PROCEDURE Calc_LEGAL_GI
245: (p_asg IN pay_fr_sick_pay_processing.t_asg
246: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages
247: ,p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch);
248:
249: -- CALC_CAGR_GI
250: PROCEDURE Calc_CAGR_GI
251: (p_asg IN pay_fr_sick_pay_processing.t_asg

Line 251: (p_asg IN pay_fr_sick_pay_processing.t_asg

247: ,p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch);
248:
249: -- CALC_CAGR_GI
250: PROCEDURE Calc_CAGR_GI
251: (p_asg IN pay_fr_sick_pay_processing.t_asg
252: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages
253: ,p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch);
254:
255: -- Addded functions and procedures for CPAM processing

Line 252: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages

248:
249: -- CALC_CAGR_GI
250: PROCEDURE Calc_CAGR_GI
251: (p_asg IN pay_fr_sick_pay_processing.t_asg
252: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages
253: ,p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch);
254:
255: -- Addded functions and procedures for CPAM processing
256: FUNCTION get_sickness_cpam_skip(

Line 253: ,p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch);

249: -- CALC_CAGR_GI
250: PROCEDURE Calc_CAGR_GI
251: (p_asg IN pay_fr_sick_pay_processing.t_asg
252: ,p_coverages IN OUT NOCOPY pay_fr_sick_pay_processing.t_coverages
253: ,p_absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_absence_arch);
254:
255: -- Addded functions and procedures for CPAM processing
256: FUNCTION get_sickness_cpam_skip(
257: p_business_group_id IN Number,

Line 270: P_Absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_asg);

266:
267: PROCEDURE Get_CPAM_Ref_salary(
268: P_Business_group_id IN Number,
269: P_Assignment_id IN Number,
270: P_Absence_arch IN OUT NOCOPY pay_fr_sick_pay_processing.t_asg);
271:
272: PROCEDURE get_sickness_CPAM_IJSS(
273: p_business_group_id IN Number,
274: p_assignment_id IN Number,