DBA Data[Home] [Help]

APPS.PYZAEXC dependencies on HR_UTILITY

Line 161: --hr_utility.trace_on(null,'ZAEXC');

157: l_tax_year varchar2(50);
158: l_tax_year_start_date date;
159: --
160: BEGIN
161: --hr_utility.trace_on(null,'ZAEXC');
162: hr_utility.set_location('p_owner_payroll_action_id: '||to_char(p_owner_payroll_action_id),10);
163: hr_utility.set_location('p_user_payroll_action_id: '||to_char(p_user_payroll_action_id),10);
164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);
165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);

Line 162: hr_utility.set_location('p_owner_payroll_action_id: '||to_char(p_owner_payroll_action_id),10);

158: l_tax_year_start_date date;
159: --
160: BEGIN
161: --hr_utility.trace_on(null,'ZAEXC');
162: hr_utility.set_location('p_owner_payroll_action_id: '||to_char(p_owner_payroll_action_id),10);
163: hr_utility.set_location('p_user_payroll_action_id: '||to_char(p_user_payroll_action_id),10);
164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);
165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);
166: hr_utility.set_location('p_owner_effective_date: '||to_char(p_owner_effective_date),10);

Line 163: hr_utility.set_location('p_user_payroll_action_id: '||to_char(p_user_payroll_action_id),10);

159: --
160: BEGIN
161: --hr_utility.trace_on(null,'ZAEXC');
162: hr_utility.set_location('p_owner_payroll_action_id: '||to_char(p_owner_payroll_action_id),10);
163: hr_utility.set_location('p_user_payroll_action_id: '||to_char(p_user_payroll_action_id),10);
164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);
165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);
166: hr_utility.set_location('p_owner_effective_date: '||to_char(p_owner_effective_date),10);
167: hr_utility.set_location('p_user_effective_date: '||to_char(p_user_effective_date),10);

Line 164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);

160: BEGIN
161: --hr_utility.trace_on(null,'ZAEXC');
162: hr_utility.set_location('p_owner_payroll_action_id: '||to_char(p_owner_payroll_action_id),10);
163: hr_utility.set_location('p_user_payroll_action_id: '||to_char(p_user_payroll_action_id),10);
164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);
165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);
166: hr_utility.set_location('p_owner_effective_date: '||to_char(p_owner_effective_date),10);
167: hr_utility.set_location('p_user_effective_date: '||to_char(p_user_effective_date),10);
168: hr_utility.set_location('p_dimension_name: '||to_char(p_dimension_name),10);

Line 165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);

161: --hr_utility.trace_on(null,'ZAEXC');
162: hr_utility.set_location('p_owner_payroll_action_id: '||to_char(p_owner_payroll_action_id),10);
163: hr_utility.set_location('p_user_payroll_action_id: '||to_char(p_user_payroll_action_id),10);
164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);
165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);
166: hr_utility.set_location('p_owner_effective_date: '||to_char(p_owner_effective_date),10);
167: hr_utility.set_location('p_user_effective_date: '||to_char(p_user_effective_date),10);
168: hr_utility.set_location('p_dimension_name: '||to_char(p_dimension_name),10);
169:

Line 166: hr_utility.set_location('p_owner_effective_date: '||to_char(p_owner_effective_date),10);

162: hr_utility.set_location('p_owner_payroll_action_id: '||to_char(p_owner_payroll_action_id),10);
163: hr_utility.set_location('p_user_payroll_action_id: '||to_char(p_user_payroll_action_id),10);
164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);
165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);
166: hr_utility.set_location('p_owner_effective_date: '||to_char(p_owner_effective_date),10);
167: hr_utility.set_location('p_user_effective_date: '||to_char(p_user_effective_date),10);
168: hr_utility.set_location('p_dimension_name: '||to_char(p_dimension_name),10);
169:
170: select rule_mode

Line 167: hr_utility.set_location('p_user_effective_date: '||to_char(p_user_effective_date),10);

163: hr_utility.set_location('p_user_payroll_action_id: '||to_char(p_user_payroll_action_id),10);
164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);
165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);
166: hr_utility.set_location('p_owner_effective_date: '||to_char(p_owner_effective_date),10);
167: hr_utility.set_location('p_user_effective_date: '||to_char(p_user_effective_date),10);
168: hr_utility.set_location('p_dimension_name: '||to_char(p_dimension_name),10);
169:
170: select rule_mode
171: into l_tax_start_day

Line 168: hr_utility.set_location('p_dimension_name: '||to_char(p_dimension_name),10);

164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);
165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);
166: hr_utility.set_location('p_owner_effective_date: '||to_char(p_owner_effective_date),10);
167: hr_utility.set_location('p_user_effective_date: '||to_char(p_user_effective_date),10);
168: hr_utility.set_location('p_dimension_name: '||to_char(p_dimension_name),10);
169:
170: select rule_mode
171: into l_tax_start_day
172: from pay_legislation_rules

Line 176: hr_utility.set_location('l_tax_start_day: '||to_char(l_tax_start_day),10);

172: from pay_legislation_rules
173: where legislation_code = 'ZA'
174: and rule_type = 'L';
175:
176: hr_utility.set_location('l_tax_start_day: '||to_char(l_tax_start_day),10);
177: --
178: select to_char(p_owner_effective_date,'YYYY')
179: into l_tax_year
180: from dual;

Line 181: hr_utility.set_location('l_tax_year: '||to_char(l_tax_year),20);

177: --
178: select to_char(p_owner_effective_date,'YYYY')
179: into l_tax_year
180: from dual;
181: hr_utility.set_location('l_tax_year: '||to_char(l_tax_year),20);
182:
183: --
184: SELECT to_date(l_tax_start_day||'-'||l_tax_year,'DD/MM/YYYY')
185: INTO l_tax_year_start_date

Line 187: hr_utility.set_location('l_tax_year_start_date: '||to_char(l_tax_year_start_date),30);

183: --
184: SELECT to_date(l_tax_start_day||'-'||l_tax_year,'DD/MM/YYYY')
185: INTO l_tax_year_start_date
186: FROM dual;
187: hr_utility.set_location('l_tax_year_start_date: '||to_char(l_tax_year_start_date),30);
188: --
189: SELECT (add_months(l_tax_year_start_date,
190: (floor(months_between(p_owner_effective_date, l_tax_year_start_date) / 12) + 1) * 12) -1)
191: INTO p_expiry_information

Line 194: hr_utility.set_location('p_expiry_information: '||to_char(p_expiry_information),40);

190: (floor(months_between(p_owner_effective_date, l_tax_year_start_date) / 12) + 1) * 12) -1)
191: INTO p_expiry_information
192: from dual;
193:
194: hr_utility.set_location('p_expiry_information: '||to_char(p_expiry_information),40);
195: --hr_utility.trace_off;
196: --
197: end ASG_TAX_YTD_EC;
198: --------------------------------- ASG_CAL_YTD_EC --------------------------------------

Line 195: --hr_utility.trace_off;

191: INTO p_expiry_information
192: from dual;
193:
194: hr_utility.set_location('p_expiry_information: '||to_char(p_expiry_information),40);
195: --hr_utility.trace_off;
196: --
197: end ASG_TAX_YTD_EC;
198: --------------------------------- ASG_CAL_YTD_EC --------------------------------------
199: -- NAME