1 package hr_gbnicar AUTHID CURRENT_USER as
2 /* $Header: pygbnicr.pkh 115.1 99/07/17 06:08:16 porting shi $ */
3 --
4 /*
5 /* Name : NICAR_CLASS1A_YTD
6 Parameters : Period end date - the end date of the payroll period
7 Termination date - The employment termination date for the employee
8 Assignment ID -
9 Element Type ID - The ID for either 'NI Car Primary' or 'NI Car Secondary'
10 Values Returned : NI Class1A Year-to-date - The Summed NI Class1A
11 for all Cars allocated to the employee (Pro-rata)
12 Description : Returns the summed NI Class1A employer's liability for the given
13 assignment ID from the start of the tax year to either the current period end date
14 or the employee's termination date, whichever is the earlier
15 */
16 function nicar_class1a_ytd
17 (p_business_group_id number,
18 p_assignment_id number,
19 p_element_type_id number,
20 p_end_of_period_date date,
21 p_term_date date
22 )
23 return number ;
24 --
25 --
26 /*
27 Name : NICAR_DAYS_BETWEEN
28 Parameters : Start date
29 End date
30 Values Returned : Days between the two input dates, ignoring 29-Feb
31 Description : Returns the number of days between the two input dates. If 29-Feb appears
32 between them, then 1 is subtracted from the normal result
33 */
34 function nicar_days_between
35 (p_start_date date,
36 p_end_date date) return number ;
37 --
38 --
39 /*
40 Name : NICAR_PAYMENT_YTD
41 Parameters : Period end date - the end date of the payroll period
42 Termination date - The employment termination date for the employee
43 Assignment ID -
44 Element Type ID - The ID for either 'NI Car Primary' or 'NI Car Secondary'
45 Values Returned : NI Class1A Year-to-date - The Summed NI Class1A
46 for all Cars allocated to the employee (Pro-rata)
47 Description : Returns the summed employee contributions for private use of a company car for
48 the given assignment ID from the start of the tax year to either the current
49 period end date or the employee's termination date, whichever is the earlier
50 */
51 --
52 function nicar_payment_ytd
53 (p_assignment_id number,
54 p_element_type_id number,
55 p_end_of_period_date date,
56 p_term_date date
57 )
58 return number;
59 --
60 --
61 /*
62 Name : NICAR_SESSION_DATE
63 Parameters : Dummy (Number) Not used
64 Values Returned : Session date
65 Description : Returns the session date for the calling session
66 */
67 --
68 function nicar_session_date
69 (p_dummy number)
70 return date;
71 --
72 --
73 /*
74 Name : UK_TAX_YR_START
75 Parameters : Input date
76 Values Returned : Tax year start date
77 Description : Returns the start date of the tax year wherein lies the input date
78 */
79 --
80 function uk_tax_yr_start
81 (p_input_date date) return date;
82 --
83 pragma restrict_references (uk_tax_yr_start, WNDS, WNPS);
84 --
85 /*
86 Name : UK_TAX_YR_END
87 Parameters : Input date
88 Values Returned : Tax year end date
89 Description : Returns the end date of the tax year wherein lies the input date
90 */
91 --
92 function uk_tax_yr_end
93 (p_input_date date) return date;
94 --
95 pragma restrict_references (uk_tax_yr_end, WNDS, WNPS);
96 --
97 /*
98 Name : NICAR_NIABLE_VALUE
99 Parameters : Price - List price of car when new
100 Price Max - Price cap for car benefit purposes
101 Price Benefit - Fraction of (capped) price for car
102 benefit purposes
103 Mileage factor - Range of business mileage for full tax year
104 Primary/Secondary Indicator - Primary or secondary car
105 Registration date - Date car was registered
106 Fuel Scale charge - Scale charge for private fuel in company car
107 Annual Payment - Total payment made by employee in full
108 tax year for private use of company car
109 Values Returned : NI-able value of car benefit
110 Description : Returns the NI-able value of a car benefit (1994/95 legislation)
111 for the given input parameters listed above.
112 */
113 --
114 function nicar_niable_value
115 (p_price number,
116 p_price_cap number,
117 p_mileage_factor number,
118 p_pri_sec_ind char,
119 p_reg_date date,
120 p_fuel_scale number,
121 p_ann_payment number,
122 p_start_date date,
123 p_end_date date,
124 p_tax_end_date date) return number ;
125 --
126 end hr_gbnicar;