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.PER_ZA_PTO_ACCRUAL_PERIOD dependencies on PER_FORMULA_FUNCTIONS

Line 90: l_Last_Period_SD := per_formula_functions.get_date('LAST_PERIOD_SD');

86: l_anniversary_date date;
87: l_diff number := 0;
88: begin
89: /* Get global variables. */
90: l_Last_Period_SD := per_formula_functions.get_date('LAST_PERIOD_SD');
91: l_Last_Period_ED := per_formula_functions.get_date('LAST_PERIOD_ED');
92: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');
93: l_Beginning_Calc_Year_SD := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');
94: l_Pay_Periods_Year := per_formula_functions.get_number('PAYROLL_YEAR_NUMBER_OF_PERIODS');

Line 91: l_Last_Period_ED := per_formula_functions.get_date('LAST_PERIOD_ED');

87: l_diff number := 0;
88: begin
89: /* Get global variables. */
90: l_Last_Period_SD := per_formula_functions.get_date('LAST_PERIOD_SD');
91: l_Last_Period_ED := per_formula_functions.get_date('LAST_PERIOD_ED');
92: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');
93: l_Beginning_Calc_Year_SD := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');
94: l_Pay_Periods_Year := per_formula_functions.get_number('PAYROLL_YEAR_NUMBER_OF_PERIODS');
95: l_Acc_Freq := per_formula_functions.get_text('ACCRUING_FREQUENCY');

Line 92: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');

88: begin
89: /* Get global variables. */
90: l_Last_Period_SD := per_formula_functions.get_date('LAST_PERIOD_SD');
91: l_Last_Period_ED := per_formula_functions.get_date('LAST_PERIOD_ED');
92: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');
93: l_Beginning_Calc_Year_SD := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');
94: l_Pay_Periods_Year := per_formula_functions.get_number('PAYROLL_YEAR_NUMBER_OF_PERIODS');
95: l_Acc_Freq := per_formula_functions.get_text('ACCRUING_FREQUENCY');
96: l_Acc_Mult := per_formula_functions.get_number('ACCRUING_MULTIPLIER');

Line 93: l_Beginning_Calc_Year_SD := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');

89: /* Get global variables. */
90: l_Last_Period_SD := per_formula_functions.get_date('LAST_PERIOD_SD');
91: l_Last_Period_ED := per_formula_functions.get_date('LAST_PERIOD_ED');
92: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');
93: l_Beginning_Calc_Year_SD := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');
94: l_Pay_Periods_Year := per_formula_functions.get_number('PAYROLL_YEAR_NUMBER_OF_PERIODS');
95: l_Acc_Freq := per_formula_functions.get_text('ACCRUING_FREQUENCY');
96: l_Acc_Mult := per_formula_functions.get_number('ACCRUING_MULTIPLIER');
97:

Line 94: l_Pay_Periods_Year := per_formula_functions.get_number('PAYROLL_YEAR_NUMBER_OF_PERIODS');

90: l_Last_Period_SD := per_formula_functions.get_date('LAST_PERIOD_SD');
91: l_Last_Period_ED := per_formula_functions.get_date('LAST_PERIOD_ED');
92: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');
93: l_Beginning_Calc_Year_SD := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');
94: l_Pay_Periods_Year := per_formula_functions.get_number('PAYROLL_YEAR_NUMBER_OF_PERIODS');
95: l_Acc_Freq := per_formula_functions.get_text('ACCRUING_FREQUENCY');
96: l_Acc_Mult := per_formula_functions.get_number('ACCRUING_MULTIPLIER');
97:
98: hr_utility.set_location('ZA_PTO_ANNLEAVE_PERIOD_LOOP', 26);

Line 95: l_Acc_Freq := per_formula_functions.get_text('ACCRUING_FREQUENCY');

91: l_Last_Period_ED := per_formula_functions.get_date('LAST_PERIOD_ED');
92: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');
93: l_Beginning_Calc_Year_SD := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');
94: l_Pay_Periods_Year := per_formula_functions.get_number('PAYROLL_YEAR_NUMBER_OF_PERIODS');
95: l_Acc_Freq := per_formula_functions.get_text('ACCRUING_FREQUENCY');
96: l_Acc_Mult := per_formula_functions.get_number('ACCRUING_MULTIPLIER');
97:
98: hr_utility.set_location('ZA_PTO_ANNLEAVE_PERIOD_LOOP', 26);
99:

Line 96: l_Acc_Mult := per_formula_functions.get_number('ACCRUING_MULTIPLIER');

92: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');
93: l_Beginning_Calc_Year_SD := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');
94: l_Pay_Periods_Year := per_formula_functions.get_number('PAYROLL_YEAR_NUMBER_OF_PERIODS');
95: l_Acc_Freq := per_formula_functions.get_text('ACCRUING_FREQUENCY');
96: l_Acc_Mult := per_formula_functions.get_number('ACCRUING_MULTIPLIER');
97:
98: hr_utility.set_location('ZA_PTO_ANNLEAVE_PERIOD_LOOP', 26);
99:
100: /* - P.Vaish - Defined for Bug No. - 2266289 - */

Line 168: l_Left_Over := per_formula_functions.get_number('MAX_CARRY_OVER');

164: END IF;
165: ELSIF ((l_Years_Service > 0) and (l_six_month_current < l_Last_Period_ED)) THEN
166: hr_utility.trace('After Six Month');
167: IF (per_utility_functions.get_accrual_band(p_Plan_ID, l_Years_Service) = 0 ) THEN
168: l_Left_Over := per_formula_functions.get_number('MAX_CARRY_OVER');
169: l_Annual_Rate := 0;
170: l_Upper_Limit := 0;
171: l_Ceiling := 0;
172: ELSE

Line 183: l_Period_SD := per_formula_functions.get_date('PERIOD_SD');

179:
180: hr_utility.set_location('Before LOOP', 27);
181:
182: while l_Continue_Processing_Flag loop
183: l_Period_SD := per_formula_functions.get_date('PERIOD_SD');
184: l_Period_ED := per_formula_functions.get_date('PERIOD_ED');
185: l_Years_Service := Floor(Months_Between(l_Period_ED,l_CSDate) / 12);
186:
187: /* Accrual bands based on length of service, but could also use grades */

Line 184: l_Period_ED := per_formula_functions.get_date('PERIOD_ED');

180: hr_utility.set_location('Before LOOP', 27);
181:
182: while l_Continue_Processing_Flag loop
183: l_Period_SD := per_formula_functions.get_date('PERIOD_SD');
184: l_Period_ED := per_formula_functions.get_date('PERIOD_ED');
185: l_Years_Service := Floor(Months_Between(l_Period_ED,l_CSDate) / 12);
186:
187: /* Accrual bands based on length of service, but could also use grades */
188: if l_Upper_Limit = 0

Line 191: l_Annual_Rate := per_formula_functions.get_number('ANNUAL_RATE');

187: /* Accrual bands based on length of service, but could also use grades */
188: if l_Upper_Limit = 0
189: or (l_Years_service >= l_Upper_Limit) then
190: if (per_utility_functions.get_accrual_band(p_Plan_ID, l_Years_Service) = 0 ) then
191: l_Annual_Rate := per_formula_functions.get_number('ANNUAL_RATE');
192: l_Upper_Limit := per_formula_functions.get_number('UPPER_LIMIT');
193: l_Ceiling := per_formula_functions.get_number('CEILING');
194: else
195: exit;

Line 192: l_Upper_Limit := per_formula_functions.get_number('UPPER_LIMIT');

188: if l_Upper_Limit = 0
189: or (l_Years_service >= l_Upper_Limit) then
190: if (per_utility_functions.get_accrual_band(p_Plan_ID, l_Years_Service) = 0 ) then
191: l_Annual_Rate := per_formula_functions.get_number('ANNUAL_RATE');
192: l_Upper_Limit := per_formula_functions.get_number('UPPER_LIMIT');
193: l_Ceiling := per_formula_functions.get_number('CEILING');
194: else
195: exit;
196: end if;

Line 193: l_Ceiling := per_formula_functions.get_number('CEILING');

189: or (l_Years_service >= l_Upper_Limit) then
190: if (per_utility_functions.get_accrual_band(p_Plan_ID, l_Years_Service) = 0 ) then
191: l_Annual_Rate := per_formula_functions.get_number('ANNUAL_RATE');
192: l_Upper_Limit := per_formula_functions.get_number('UPPER_LIMIT');
193: l_Ceiling := per_formula_functions.get_number('CEILING');
194: else
195: exit;
196: end if;
197: end if;

Line 234: l_error := per_formula_functions.set_date('PERIOD_SD',

230: l_error := per_utility_functions.GET_PERIOD_DATES( l_Period_ED
231: ,l_Acc_Freq
232: ,l_Beginning_Calc_Year_SD
233: ,l_Acc_Mult);
234: l_error := per_formula_functions.set_date('PERIOD_SD',
235: per_formula_functions.get_date('PERIOD_START_DATE'));
236: l_error := per_formula_functions.set_date('PERIOD_ED',
237: per_formula_functions.get_date('PERIOD_END_DATE'));
238: l_Continue_Processing_Flag := true;

Line 235: per_formula_functions.get_date('PERIOD_START_DATE'));

231: ,l_Acc_Freq
232: ,l_Beginning_Calc_Year_SD
233: ,l_Acc_Mult);
234: l_error := per_formula_functions.set_date('PERIOD_SD',
235: per_formula_functions.get_date('PERIOD_START_DATE'));
236: l_error := per_formula_functions.set_date('PERIOD_ED',
237: per_formula_functions.get_date('PERIOD_END_DATE'));
238: l_Continue_Processing_Flag := true;
239: end if;

Line 236: l_error := per_formula_functions.set_date('PERIOD_ED',

232: ,l_Beginning_Calc_Year_SD
233: ,l_Acc_Mult);
234: l_error := per_formula_functions.set_date('PERIOD_SD',
235: per_formula_functions.get_date('PERIOD_START_DATE'));
236: l_error := per_formula_functions.set_date('PERIOD_ED',
237: per_formula_functions.get_date('PERIOD_END_DATE'));
238: l_Continue_Processing_Flag := true;
239: end if;
240: end loop;

Line 237: per_formula_functions.get_date('PERIOD_END_DATE'));

233: ,l_Acc_Mult);
234: l_error := per_formula_functions.set_date('PERIOD_SD',
235: per_formula_functions.get_date('PERIOD_START_DATE'));
236: l_error := per_formula_functions.set_date('PERIOD_ED',
237: per_formula_functions.get_date('PERIOD_END_DATE'));
238: l_Continue_Processing_Flag := true;
239: end if;
240: end loop;
241:

Line 242: l_error := per_formula_functions.set_number('TOTAL_ACCRUED_PTO', l_Total_Accrued_PTO);

238: l_Continue_Processing_Flag := true;
239: end if;
240: end loop;
241:
242: l_error := per_formula_functions.set_number('TOTAL_ACCRUED_PTO', l_Total_Accrued_PTO);
243:
244: Return l_Total_Accrued_PTO;
245:
246: end ZA_PTO_ANNLEAVE_PERIOD_LOOP;

Line 281: l_Beginning_Calc_Year_SD := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');

277: l_prev_period_SD date;
278: l_prev_period_ED date;
279:
280: begin
281: l_Beginning_Calc_Year_SD := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');
282: l_Last_Period_SD := per_formula_functions.get_date('LAST_PERIOD_SD');
283: l_Last_Period_ED := per_formula_functions.get_date('LAST_PERIOD_ED');
284: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');
285: -- l_Accrual_Rate := per_formula_functions.get_number('ACCRUAL_RATE');

Line 282: l_Last_Period_SD := per_formula_functions.get_date('LAST_PERIOD_SD');

278: l_prev_period_ED date;
279:
280: begin
281: l_Beginning_Calc_Year_SD := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');
282: l_Last_Period_SD := per_formula_functions.get_date('LAST_PERIOD_SD');
283: l_Last_Period_ED := per_formula_functions.get_date('LAST_PERIOD_ED');
284: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');
285: -- l_Accrual_Rate := per_formula_functions.get_number('ACCRUAL_RATE');
286: l_Accrual_Rate := per_formula_functions.get_number('ZA_SICK_LEAVE_ACCRUAL_RATE');

Line 283: l_Last_Period_ED := per_formula_functions.get_date('LAST_PERIOD_ED');

279:
280: begin
281: l_Beginning_Calc_Year_SD := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');
282: l_Last_Period_SD := per_formula_functions.get_date('LAST_PERIOD_SD');
283: l_Last_Period_ED := per_formula_functions.get_date('LAST_PERIOD_ED');
284: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');
285: -- l_Accrual_Rate := per_formula_functions.get_number('ACCRUAL_RATE');
286: l_Accrual_Rate := per_formula_functions.get_number('ZA_SICK_LEAVE_ACCRUAL_RATE');
287: l_Acc_Freq := per_formula_functions.get_text('ACCRUING_FREQUENCY');

Line 284: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');

280: begin
281: l_Beginning_Calc_Year_SD := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');
282: l_Last_Period_SD := per_formula_functions.get_date('LAST_PERIOD_SD');
283: l_Last_Period_ED := per_formula_functions.get_date('LAST_PERIOD_ED');
284: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');
285: -- l_Accrual_Rate := per_formula_functions.get_number('ACCRUAL_RATE');
286: l_Accrual_Rate := per_formula_functions.get_number('ZA_SICK_LEAVE_ACCRUAL_RATE');
287: l_Acc_Freq := per_formula_functions.get_text('ACCRUING_FREQUENCY');
288: l_Acc_Mult := per_formula_functions.get_number('ACCRUING_MULTIPLIER');

Line 285: -- l_Accrual_Rate := per_formula_functions.get_number('ACCRUAL_RATE');

281: l_Beginning_Calc_Year_SD := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');
282: l_Last_Period_SD := per_formula_functions.get_date('LAST_PERIOD_SD');
283: l_Last_Period_ED := per_formula_functions.get_date('LAST_PERIOD_ED');
284: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');
285: -- l_Accrual_Rate := per_formula_functions.get_number('ACCRUAL_RATE');
286: l_Accrual_Rate := per_formula_functions.get_number('ZA_SICK_LEAVE_ACCRUAL_RATE');
287: l_Acc_Freq := per_formula_functions.get_text('ACCRUING_FREQUENCY');
288: l_Acc_Mult := per_formula_functions.get_number('ACCRUING_MULTIPLIER');
289: --Added for Bug 8192694

Line 286: l_Accrual_Rate := per_formula_functions.get_number('ZA_SICK_LEAVE_ACCRUAL_RATE');

282: l_Last_Period_SD := per_formula_functions.get_date('LAST_PERIOD_SD');
283: l_Last_Period_ED := per_formula_functions.get_date('LAST_PERIOD_ED');
284: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');
285: -- l_Accrual_Rate := per_formula_functions.get_number('ACCRUAL_RATE');
286: l_Accrual_Rate := per_formula_functions.get_number('ZA_SICK_LEAVE_ACCRUAL_RATE');
287: l_Acc_Freq := per_formula_functions.get_text('ACCRUING_FREQUENCY');
288: l_Acc_Mult := per_formula_functions.get_number('ACCRUING_MULTIPLIER');
289: --Added for Bug 8192694
290: l_calc_date := per_formula_functions.get_date('CALC_DATE');

Line 287: l_Acc_Freq := per_formula_functions.get_text('ACCRUING_FREQUENCY');

283: l_Last_Period_ED := per_formula_functions.get_date('LAST_PERIOD_ED');
284: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');
285: -- l_Accrual_Rate := per_formula_functions.get_number('ACCRUAL_RATE');
286: l_Accrual_Rate := per_formula_functions.get_number('ZA_SICK_LEAVE_ACCRUAL_RATE');
287: l_Acc_Freq := per_formula_functions.get_text('ACCRUING_FREQUENCY');
288: l_Acc_Mult := per_formula_functions.get_number('ACCRUING_MULTIPLIER');
289: --Added for Bug 8192694
290: l_calc_date := per_formula_functions.get_date('CALC_DATE');
291:

Line 288: l_Acc_Mult := per_formula_functions.get_number('ACCRUING_MULTIPLIER');

284: l_CSDate := per_formula_functions.get_date('CONTINUOUS_SERVICE_DATE');
285: -- l_Accrual_Rate := per_formula_functions.get_number('ACCRUAL_RATE');
286: l_Accrual_Rate := per_formula_functions.get_number('ZA_SICK_LEAVE_ACCRUAL_RATE');
287: l_Acc_Freq := per_formula_functions.get_text('ACCRUING_FREQUENCY');
288: l_Acc_Mult := per_formula_functions.get_number('ACCRUING_MULTIPLIER');
289: --Added for Bug 8192694
290: l_calc_date := per_formula_functions.get_date('CALC_DATE');
291:
292: hr_utility.set_location(l_proc,5);

Line 290: l_calc_date := per_formula_functions.get_date('CALC_DATE');

286: l_Accrual_Rate := per_formula_functions.get_number('ZA_SICK_LEAVE_ACCRUAL_RATE');
287: l_Acc_Freq := per_formula_functions.get_text('ACCRUING_FREQUENCY');
288: l_Acc_Mult := per_formula_functions.get_number('ACCRUING_MULTIPLIER');
289: --Added for Bug 8192694
290: l_calc_date := per_formula_functions.get_date('CALC_DATE');
291:
292: hr_utility.set_location(l_proc,5);
293: hr_utility.trace('l_Accrual_Rate: '||to_char(l_Accrual_Rate));
294:

Line 303: l_Period_SD := per_formula_functions.get_date('PERIOD_SD');

299: of a leave based on the days worked (previous logic)*/
300: IF l_calc_date IS NOT NULL then
301: while l_Continue_Processing_Flag loop
302: /*Get the first period start and end dates */
303: l_Period_SD := per_formula_functions.get_date('PERIOD_SD');
304: l_Period_ED := per_formula_functions.get_date('PERIOD_ED');
305:
306: --Calculate the days off in the particular period
307: l_daysoff :=PER_ZA_ABS_DURATION.ZA_DAYSOFF(l_Period_SD,l_Period_ED);

Line 304: l_Period_ED := per_formula_functions.get_date('PERIOD_ED');

300: IF l_calc_date IS NOT NULL then
301: while l_Continue_Processing_Flag loop
302: /*Get the first period start and end dates */
303: l_Period_SD := per_formula_functions.get_date('PERIOD_SD');
304: l_Period_ED := per_formula_functions.get_date('PERIOD_ED');
305:
306: --Calculate the days off in the particular period
307: l_daysoff :=PER_ZA_ABS_DURATION.ZA_DAYSOFF(l_Period_SD,l_Period_ED);
308: hr_utility.trace('l_daysoff: '||to_char(l_daysoff));

Line 326: l_error := per_formula_functions.set_date('PERIOD_SD',

322:
323: l_Continue_Processing_Flag := false;
324: l_month_PTO:=0;
325: hr_utility.trace('l_Period_ED >=l_calc_date');
326: l_error := per_formula_functions.set_date('PERIOD_SD',
327: l_prev_period_SD);
328: l_error := per_formula_functions.set_date('PERIOD_ED',
329: l_prev_period_ED);
330: exit;

Line 328: l_error := per_formula_functions.set_date('PERIOD_ED',

324: l_month_PTO:=0;
325: hr_utility.trace('l_Period_ED >=l_calc_date');
326: l_error := per_formula_functions.set_date('PERIOD_SD',
327: l_prev_period_SD);
328: l_error := per_formula_functions.set_date('PERIOD_ED',
329: l_prev_period_ED);
330: exit;
331: else
332: l_daysoff1:=PER_ZA_ABS_DURATION.ZA_DAYSOFF(l_Period_SD,l_Period_ED);

Line 348: l_error := per_formula_functions.set_date('PERIOD_SD',

344: l_Period_ED := l_Period_ED + 1;
345: l_month_PTO:=1;
346: l_prev_period_SD:=l_Period_SD;
347: l_prev_period_ED:=l_Period_ED -1;
348: l_error := per_formula_functions.set_date('PERIOD_SD',
349: l_Period_ED);
350: l_error := per_formula_functions.set_date('PERIOD_ED',
351: l_Period_ED + 31);
352: end if;

Line 350: l_error := per_formula_functions.set_date('PERIOD_ED',

346: l_prev_period_SD:=l_Period_SD;
347: l_prev_period_ED:=l_Period_ED -1;
348: l_error := per_formula_functions.set_date('PERIOD_SD',
349: l_Period_ED);
350: l_error := per_formula_functions.set_date('PERIOD_ED',
351: l_Period_ED + 31);
352: end if;
353:
354: l_Total_Accrued_PTO:=l_Total_Accrued_PTO+l_month_PTO;

Line 361: l_Period_SD := per_formula_functions.get_date('PERIOD_SD');

357: end loop;
358: -- End changes for Bug 8192694
359: else
360: while l_Continue_Processing_Flag loop
361: l_Period_SD := per_formula_functions.get_date('PERIOD_SD');
362: l_Period_ED := per_formula_functions.get_date('PERIOD_ED');
363:
364: -- Bug 5043294; Removed comments and unnessary if/else logic
365: -- Calculating the working days in the period

Line 362: l_Period_ED := per_formula_functions.get_date('PERIOD_ED');

358: -- End changes for Bug 8192694
359: else
360: while l_Continue_Processing_Flag loop
361: l_Period_SD := per_formula_functions.get_date('PERIOD_SD');
362: l_Period_ED := per_formula_functions.get_date('PERIOD_ED');
363:
364: -- Bug 5043294; Removed comments and unnessary if/else logic
365: -- Calculating the working days in the period
366: l_daysoff :=PER_ZA_ABS_DURATION.ZA_DAYSOFF(l_Period_SD,l_Period_ED);

Line 378: l_error := per_formula_functions.set_date('PERIOD_SD',

374: l_error := per_utility_functions.GET_PERIOD_DATES( l_Period_ED
375: ,l_Acc_Freq
376: ,l_Beginning_Calc_Year_SD
377: ,l_Acc_Mult);
378: l_error := per_formula_functions.set_date('PERIOD_SD',
379: per_formula_functions.get_date('PERIOD_START_DATE'));
380: l_error := per_formula_functions.set_date('PERIOD_ED',
381: per_formula_functions.get_date('PERIOD_END_DATE'));
382: l_Continue_Processing_Flag := true;

Line 379: per_formula_functions.get_date('PERIOD_START_DATE'));

375: ,l_Acc_Freq
376: ,l_Beginning_Calc_Year_SD
377: ,l_Acc_Mult);
378: l_error := per_formula_functions.set_date('PERIOD_SD',
379: per_formula_functions.get_date('PERIOD_START_DATE'));
380: l_error := per_formula_functions.set_date('PERIOD_ED',
381: per_formula_functions.get_date('PERIOD_END_DATE'));
382: l_Continue_Processing_Flag := true;
383:

Line 380: l_error := per_formula_functions.set_date('PERIOD_ED',

376: ,l_Beginning_Calc_Year_SD
377: ,l_Acc_Mult);
378: l_error := per_formula_functions.set_date('PERIOD_SD',
379: per_formula_functions.get_date('PERIOD_START_DATE'));
380: l_error := per_formula_functions.set_date('PERIOD_ED',
381: per_formula_functions.get_date('PERIOD_END_DATE'));
382: l_Continue_Processing_Flag := true;
383:
384: end if;

Line 381: per_formula_functions.get_date('PERIOD_END_DATE'));

377: ,l_Acc_Mult);
378: l_error := per_formula_functions.set_date('PERIOD_SD',
379: per_formula_functions.get_date('PERIOD_START_DATE'));
380: l_error := per_formula_functions.set_date('PERIOD_ED',
381: per_formula_functions.get_date('PERIOD_END_DATE'));
382: l_Continue_Processing_Flag := true;
383:
384: end if;
385: end loop;

Line 387: l_error := per_formula_functions.set_number('TOTAL_ACCRUED_PTO', l_Total_Accrued_PTO);

383:
384: end if;
385: end loop;
386: END if;
387: l_error := per_formula_functions.set_number('TOTAL_ACCRUED_PTO', l_Total_Accrued_PTO);
388: Return l_Total_Accrued_PTO;
389:
390: end ZA_PTO_SICKLEAVE_PERIOD_LOOP;
391: --

Line 465: l_Beginning_Calc_Year := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');

461:
462: if l_net_entitlement <= l_max_carryover then
463: --
464: hr_utility.set_location(l_proc,10);
465: l_Beginning_Calc_Year := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');
466: --
467: IF (l_net_entitlement <= 0
468: AND to_char(l_effective_date + 1,'MM') <> to_char(l_Beginning_Calc_Year,'MM')
469: )THEN

Line 517: l_Beginning_Calc_Year := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');

513:
514: -- The other contributions(leave adjustments) need to be subtracted before the residual value
515: -- is calculated. The adjustments in the current accrual cycle must not be forfeited.
516: -- Only for semi-annual run.
517: l_Beginning_Calc_Year := per_formula_functions.get_date('BEGINNING_OF_CALCULATION_YEAR');
518:
519: IF to_char(l_effective_date + 1,'MM') <> to_char(l_Beginning_Calc_Year,'MM') THEN
520: hr_utility.set_location(l_proc, 15);
521: l_other2 := per_accrual_calc_functions.Get_Other_Net_Contribution(