132: function periods_since_hire_date
133: (
134: p_payroll_id in number,
135: p_assignment_id in per_all_assignments_f.assignment_id%type,
136: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type, --2610141
137: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type, /*Bug 4451088 */
138: p_period_num in number,
139: p_period_start in date,
140: p_emp_hire_date in date,
133: (
134: p_payroll_id in number,
135: p_assignment_id in per_all_assignments_f.assignment_id%type,
136: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type, --2610141
137: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type, /*Bug 4451088 */
138: p_period_num in number,
139: p_period_start in date,
140: p_emp_hire_date in date,
141: p_use_tax_flag IN VARCHAR2 --2610141
254: function get_retro_period
255: (
256: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
257: p_date_earned in pay_payroll_actions.date_earned%TYPE,
258: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE, /*Bug 4418107*/
259: p_retro_start_date out NOCOPY date,
260: p_retro_end_date out NOCOPY date
261: )return number;
262:
261: )return number;
262:
263: function count_retro_periods
264: (
265: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
266: p_date_earned in pay_payroll_actions.date_earned%TYPE,
267: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE, /*Bug 4418107*/
268: p_use_tax_flag IN VARCHAR2, --4415795
269: p_mode IN VARCHAR2 DEFAULT 'E' --7665727
263: function count_retro_periods
264: (
265: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
266: p_date_earned in pay_payroll_actions.date_earned%TYPE,
267: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE, /*Bug 4418107*/
268: p_use_tax_flag IN VARCHAR2, --4415795
269: p_mode IN VARCHAR2 DEFAULT 'E' --7665727
270: )return number;
271:
271:
272: /*bug 7665727*/
273: function count_retro_periods_2009
274: (
275: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
276: p_date_earned in pay_payroll_actions.date_earned%TYPE,
277: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE, /*Bug 4418107*/
278: p_use_tax_flag IN VARCHAR2, --4415795
279: p_mode IN VARCHAR2 --7665727
273: function count_retro_periods_2009
274: (
275: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
276: p_date_earned in pay_payroll_actions.date_earned%TYPE,
277: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE, /*Bug 4418107*/
278: p_use_tax_flag IN VARCHAR2, --4415795
279: p_mode IN VARCHAR2 --7665727
280: )return number;
281:
309: It return value of Hours in case the element_id passed is attached to the Salary Basis
310: */
311: FUNCTION get_salary_basis_hours
312: (
313: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
314: p_element_type_id in pay_element_entries_f.element_entry_id%TYPE,
315: p_pay_bases_id in per_all_assignments_f.pay_basis_id%TYPE
316: )
317: RETURN NUMBER;
337: FUNCTION get_enhanced_retro_period
338: (
339: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,
340: p_date_earned IN pay_payroll_actions.date_earned%TYPE,
341: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
342: p_retro_start_date OUT NOCOPY date,
343: p_retro_end_date OUT NOCOPY date,
344: p_orig_effective_date OUT NOCOPY date,
345: p_retro_effective_date OUT NOCOPY date,
362: FUNCTION get_retro_time_span
363: (
364: p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE,
365: p_date_earned IN pay_payroll_actions.date_earned%TYPE,
366: p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
367: p_retro_start_date OUT NOCOPY date,
368: p_retro_end_date OUT NOCOPY date,
369: p_orig_effective_date OUT NOCOPY date,
370: p_retro_effective_date OUT NOCOPY date,
372: p_retro_type OUT NOCOPY varchar2
373: )return number;
374: /* Bug#5934468 */
375: function get_spread_earning
376: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
377: p_date_paid in date,
378: p_pre_tax in number,
379: p_spread_earning in number) return number;
380:
378: p_pre_tax in number,
379: p_spread_earning in number) return number;
380:
381: function get_retro_spread_earning
382: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
383: p_date_paid in date,
384: p_pre_tax in number,
385: p_spread_earning in number) return number;
386:
388: ( p_assignment_id in per_all_assignments_f.assignment_id%type,
389: p_date_earned in date) return varchar2;
390:
391: FUNCTION calc_average_earnings
392: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE
393: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
394: ,p_payroll_id IN pay_payroll_actions.payroll_id%TYPE
395: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
396: ,p_business_group_id IN per_business_groups.business_group_id%TYPE
389: p_date_earned in date) return varchar2;
390:
391: FUNCTION calc_average_earnings
392: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE
393: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
394: ,p_payroll_id IN pay_payroll_actions.payroll_id%TYPE
395: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
396: ,p_business_group_id IN per_business_groups.business_group_id%TYPE
397: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE
391: FUNCTION calc_average_earnings
392: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE
393: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
394: ,p_payroll_id IN pay_payroll_actions.payroll_id%TYPE
395: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
396: ,p_business_group_id IN per_business_groups.business_group_id%TYPE
397: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE
398: ,p_period_start_date IN DATE
399: ,p_emp_hire_date IN DATE
404: ,p_case OUT NOCOPY VARCHAR2)
405: RETURN NUMBER;
406:
407: FUNCTION calc_lt12_prev_spread_tax
408: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE
409: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
410: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
411: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE
412: ,p_business_group_id IN pay_payroll_actions.business_group_id%TYPE
405: RETURN NUMBER;
406:
407: FUNCTION calc_lt12_prev_spread_tax
408: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE
409: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
410: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
411: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE
412: ,p_business_group_id IN pay_payroll_actions.business_group_id%TYPE
413: ,p_average_earnings IN NUMBER
406:
407: FUNCTION calc_lt12_prev_spread_tax
408: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE
409: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
410: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
411: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE
412: ,p_business_group_id IN pay_payroll_actions.business_group_id%TYPE
413: ,p_average_earnings IN NUMBER
414: ,p_tax_scale IN VARCHAR2