[Home] [Help]
PACKAGE: APPS.HR_GBNIDIR
Source
1 package hr_gbnidir as
2 /* $Header: pygbnicd.pkh 120.0.12000000.1 2007/01/17 20:24:36 appldev noship $ */
3 --
4 -----------------------------------------------------------------
5 function ni_able_dir_ytd
6 (
7 p_assignment_action_id IN number ,
8 p_category IN varchar2 ,
9 p_pension IN varchar2
10 ) return number;
11 pragma restrict_references (ni_able_dir_ytd, WNDS, WNPS);
12 --
13 function ni_balances_per_dir_td_ytd
14 (
15 p_assignment_action_id IN number,
16 p_global_name IN varchar2
17 )
18 return number ;
19 --
20 function director_weeks
21 (
22 p_assignment_id IN number
23 ) return number;
24 pragma restrict_references (director_weeks, WNDS, WNPS);
25 --
26 --
27 function validate_user_value
28 ( p_user_table IN varchar2,
29 p_user_column IN varchar2,
30 p_user_value IN varchar2
31 )
32 return number;
33 pragma restrict_references (validate_user_value, WNDS, WNPS);
34 --
35 function user_value_by_label
36 ( p_user_table IN varchar2,
37 p_user_column IN varchar2,
38 p_label IN varchar2)
39 return number ;
40 pragma restrict_references (user_value_by_label, WNDS, WNPS);
41 --
42 function user_range_by_label
43 ( p_user_table IN varchar2,
44 p_high_or_low IN varchar2,
45 p_label IN varchar2)
46 return number ;
47 pragma restrict_references (user_range_by_label, WNDS, WNPS);
48 --
49 function ni_co_rate_from_ci_rate
50 ( p_ci_rate IN number)
51 return number ;
52 pragma restrict_references (ni_co_rate_from_ci_rate, WNDS, WNPS);
53 --
54 function ni_cm_rate_from_ci_rate
55 ( p_ci_rate IN number)
56 return number ;
57 pragma restrict_references (ni_cm_rate_from_ci_rate, WNDS, WNPS);
58 --
59 function statutory_period_start_date
60 ( p_assignment_action_id number )
61 return date ;
62
63 pragma restrict_references (statutory_period_start_date, WNDS, WNPS);
64 --
65 function statutory_period_number
66 ( p_date in date ,
67 p_period_type in varchar2 )
68 return number ;
69
70 pragma restrict_references (statutory_period_number, WNDS, WNPS);
71 --
72 --
73 function ni_able_per_ptd
74 (
75 p_assignment_action_id IN number ,
76 p_category IN varchar2 ,
77 p_pension IN varchar2
78 ) return number;
79 --pragma restrict_references (ni_able_per_ptd, WNDS, WNPS);
80 --
81 function count_assignments
82 (
83 p_assignment_id IN number
84 )
85 return number ;
86
87 pragma restrict_references (count_assignments, WNDS, WNPS);
88 --
89 function count_assignments_on_payroll
90 (
91 p_date IN date,
92 p_payroll_id in number
93 )
94 return number ;
95
96 pragma restrict_references (count_assignments_on_payroll, WNDS, WNPS);
97 --
98 function period_type_check
99 ( p_assignment_id number )
100 return number ;
101
102 pragma restrict_references (period_type_check, WNDS, WNPS);
103 --
104 function PAYE_STAT_PERIOD_START_DATE
105 ( p_assignment_action_id number )
106 return date;
107 --
108 pragma restrict_references (paye_stat_period_start_date, WNDS, WNPS);
109
110 function ELEMENT_ENTRY_VALUE
111 ( p_assignment_id number,
112 p_effective_date date,
113 p_element_name varchar2,
114 p_input_name varchar2)
115 return varchar2;
116 --
117 pragma restrict_references (element_entry_value, WNDS, WNPS);
118 --
119 function NI_ELEMENT_ENTRY_VALUE
120 ( p_assignment_id number,
121 p_effective_date date)
122 return varchar2;
123 --
124 pragma restrict_references (ni_element_entry_value, WNDS);
125 --
126 function NI_BALANCES_PER_NI_PTD
127 (
128 p_assignment_action_id IN number,
129 p_global_name IN varchar2
130 )
131 return number ;
132 --
133 function statutory_period_date_mode (p_assignment_id IN NUMBER,
134 p_effective_date IN DATE) RETURN DATE;
135 pragma restrict_references (statutory_period_date_mode, WNDS, WNPS);
136 --
137 function niable_bands (L_NIABLE IN NUMBER,
138 L_NI_CAT_ABLE IN NUMBER,
139 L_TOT_NIABLE IN NUMBER,
140 L_LEL IN NUMBER,
141 L_EET IN NUMBER,
142 L_ET IN NUMBER,
143 L_UEL IN NUMBER,
144 NI_ABLE_LEL IN OUT NOCOPY NUMBER,
145 NI_ABLE_EET IN OUT NOCOPY NUMBER,
146 NI_ABLE_ET IN OUT NOCOPY NUMBER,
147 NI_ABLE_UEL IN OUT NOCOPY NUMBER,
148 NI_UPPER IN OUT NOCOPY NUMBER,
149 NI_LOWER IN OUT NOCOPY NUMBER
150 ) RETURN NUMBER;
151
152 end hr_gbnidir;