1 package pygbexc as
2 /* $Header: pygbexc.pkh 120.0.12010000.2 2008/08/06 07:17:16 ubhat ship $ */
3 /*------------------------------ ASG_RUN_EC ----------------------------*/
4 /*
5 NAME
6 ASG_RUN_EC - Assignment Run to Date expiry check.
7 DESCRIPTION
8 Expiry checking code for the following:
9 GB Assignment-level Run To Date Balance Dimension
10 NOTES
11 The associtated dimension is expiry checked at payroll action level
12 */
13 procedure ASG_RUN_EC
14 (
15 p_owner_payroll_action_id in number, -- run created balance.
16 p_user_payroll_action_id in number, -- current run.
17 p_owner_assignment_action_id in number, -- assact created balance.
18 p_user_assignment_action_id in number, -- current assact..
19 p_owner_effective_date in date, -- eff date of balance.
20 p_user_effective_date in date, -- eff date of current run.
21 p_dimension_name in varchar2, -- balance dimension name.
22 p_expiry_information out nocopy number -- dimension expired flag.
23 ) ;
24
25 /*------------------------------ ASG_PROC_PTD_EC ----------------------------*/
26 /*
27 NAME
28 ASG_PROC_PTD_EC - Assignment Processing Period to Date expiry check.
29 DESCRIPTION
30 Expiry checking code for the following:
31 GB Assignment-level Process Period To Date Balance Dimension
32 NOTES
33 The associtated dimension is expiry checked at assignment action level
34 */
35 procedure ASG_PROC_PTD_EC
36 (
37 p_owner_payroll_action_id in number, -- run created balance.
38 p_user_payroll_action_id in number, -- current run.
39 p_owner_assignment_action_id in number, -- assact created balance.
40 p_user_assignment_action_id in number, -- current assact..
41 p_owner_effective_date in date, -- eff date of balance.
42 p_user_effective_date in date, -- eff date of current run.
43 p_dimension_name in varchar2, -- balance dimension name.
44 p_expiry_information out nocopy number -- dimension expired flag.
45 ) ;
46
47 /*------------------------------ ASG_PROC_YTD_EC ----------------------------*/
48 /*
49 NAME
50 ASG_PROC_YTD_EC - Assignment Processing Year to Date expiry check.
51 DESCRIPTION
52 Expiry checking code for the following:
53 GB Assignment-level Process Year To Date Balance Dimension
54 NOTES
55 The associated dimension is expiry checked at assignment action level
56 */
57 procedure ASG_PROC_YTD_EC
58 (
59 p_owner_payroll_action_id in number, -- run created balance.
60 p_user_payroll_action_id in number, -- current run.
61 p_owner_assignment_action_id in number, -- assact created balance.
62 p_user_assignment_action_id in number, -- current assact..
63 p_owner_effective_date in date, -- eff date of balance.
64 p_user_effective_date in date, -- eff date of current run.
65 p_dimension_name in varchar2, -- balance dimension name.
66 p_expiry_information out nocopy number -- dimension expired flag.
67 ) ;
68
69 -- For 115.8
70 /*------------------------------ ASG_PEN_YTD_EC ----------------------------*/
71 /*
72 NAME
73 ASG_PEN_YTD_EC - Assignment Processing Pension Year to Date expiry check.
74 DESCRIPTION
75 Expiry checking code for the following:
76 GB Assignment-level Process Pension Year To Date Balance Dimension
77 NOTES
78 The associated dimension is expiry checked at assignment action level
79 */
80 procedure ASG_PEN_YTD_EC
81 (
82 p_owner_payroll_action_id in number, -- run created balance.
83 p_user_payroll_action_id in number, -- current run.
84 p_owner_assignment_action_id in number, -- assact created balance.
85 p_user_assignment_action_id in number, -- current assact..
86 p_owner_effective_date in date, -- eff date of balance.
87 p_user_effective_date in date, -- eff date of current run.
88 p_dimension_name in varchar2, -- balance dimension name.
89 p_expiry_information out nocopy number -- dimension expired flag.
90 ) ;
91
92 /*------------------------------ ASG_STAT_YTD_EC -------------------------*/
93 /*
94 NAME
95 ASG_STAT_YTD_EC - Assignment Statutory Year to DAte expiry check
96 DESCRIPTION
97 Expiry checking code for the following:
98 GB Assignment-level Statutory Year to Date dimension
99 NOTES
100 The associated dimension is expiry checked at payroll action level
101 */
102 procedure ASG_STAT_YTD_EC
103 (
104 p_owner_payroll_action_id in number, -- run created balance.
105 p_user_payroll_action_id in number, -- current run.
106 p_owner_assignment_action_id in number, -- assact created balance.
107 p_user_assignment_action_id in number, -- current assact..
108 p_owner_effective_date in date, -- eff date of balance.
109 p_user_effective_date in date, -- eff date of current run.
110 p_dimension_name in varchar2, -- balance dimension name.
111 p_expiry_information out nocopy number -- dimension expired flag.
112 ) ;
113 /*------------------------------ ASG_PROC_TWO_YTD_EC ----------------------------*/
114 /*
115 NAME
116 ASG_PROC_TWO_YTD_EC - Assignment Processing Year to Date expiry check
117 for 2 yearly balance.
118 DESCRIPTION
119 Expiry checking code for the following:
120 GB Assignment level Last Two Years to Date
121 NOTES
122 The associated dimension is expiry checked at payroll action level
123 */
124 procedure ASG_PROC_TWO_YTD_EC
125 (
126 p_owner_payroll_action_id in number, -- run created balance.
127 p_user_payroll_action_id in number, -- current run.
128 p_owner_assignment_action_id in number, -- assact created balance.
129 p_user_assignment_action_id in number, -- current assact..
130 p_owner_effective_date in date, -- eff date of balance.
131 p_user_effective_date in date, -- eff date of current run.
132 p_dimension_name in varchar2, -- balance dimension name.
133 p_expiry_information out nocopy number -- dimension expired flag.
134 );
135 /*---------------------------- PER_TD_STAT_PTD_EC ----------------------------*/
136 /*
137 NAME
138 PER_TD_STAT_PTD_EC Person level TD Stat Expiry Checking
139 DESCRIPTION
140 Expiry checking code for the following:
141 GB PERSON level TD Statutory Period Dimension
142 NOTES
143 The associated dimension is expiry checked at ASSIGNMENT Action level
144 hence requires one extra parameter.
145
146 */
147 procedure PER_TD_STAT_PTD_EC
148 (
149 p_owner_payroll_action_id in number, -- run created balance.
150 p_user_payroll_action_id in number, -- current run.
151 p_owner_assignment_action_id in number, -- assact created balance.
152 p_user_assignment_action_id in number, -- current assact..
153 p_owner_effective_date in date, -- eff date of balance.
154 p_user_effective_date in date, -- eff date of current run.
155 p_dimension_name in varchar2, -- balance dimension name.
156 p_balance_context_values in varchar2, -- list of context values
157 p_expiry_information out nocopy number -- dimension expired flag.
158 );
159 procedure proc_ytd_start(p_period_type in varchar2 default null,
160 p_effective_date in date default null,
161 p_start_date out nocopy date,
162 p_start_date_code in varchar2 default null,
163 p_payroll_id in number,
164 p_bus_grp in number default null,
165 p_action_type in varchar2 default null,
166 p_asg_action in number);
167
168 procedure proc_odd_ytd_start(p_period_type in varchar2 default null,
169 p_effective_date in date default null,
170 p_start_date out nocopy date,
171 p_start_date_code in varchar2 default null,
172 p_payroll_id in number,
173 p_bus_grp in number default null,
174 p_action_type in varchar2 default null,
175 p_asg_action in number);
176
177 procedure proc_even_ytd_start(p_period_type in varchar2 default null,
178 p_effective_date in date default null,
179 p_start_date out nocopy date,
180 p_start_date_code in varchar2 default null,
181 p_payroll_id in number,
182 p_bus_grp in number default null,
183 p_action_type in varchar2 default null,
184 p_asg_action in number);
185
186 --For 115.8
187 procedure proc_pen_ytd_start(p_period_type in varchar2 default null,
188 p_effective_date in date default null,
189 p_start_date out nocopy date,
190 p_start_date_code in varchar2 default null,
191 p_payroll_id in number,
192 p_bus_grp in number default null,
193 p_action_type in varchar2 default null,
194 p_asg_action in number);
195
196
197 end pygbexc;