eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_WORKING_TAX_CREDIT dependencies on HR_UTILITY

Line 111: hr_utility.set_location(g_package_name||'.'||l_function_name,1);

107: group by peef.effective_start_date, peef.effective_end_date;
108:
109: begin
110:
111: hr_utility.set_location(g_package_name||'.'||l_function_name,1);
112:
113: hr_utility.trace('p_start_date: '||p_start_date);
114: hr_utility.trace('p_end_date: '||p_end_date);
115:

Line 113: hr_utility.trace('p_start_date: '||p_start_date);

109: begin
110:
111: hr_utility.set_location(g_package_name||'.'||l_function_name,1);
112:
113: hr_utility.trace('p_start_date: '||p_start_date);
114: hr_utility.trace('p_end_date: '||p_end_date);
115:
116: /* Get Daily Amount input value */
117: open csr_daily_amt_iv_id;

Line 114: hr_utility.trace('p_end_date: '||p_end_date);

110:
111: hr_utility.set_location(g_package_name||'.'||l_function_name,1);
112:
113: hr_utility.trace('p_start_date: '||p_start_date);
114: hr_utility.trace('p_end_date: '||p_end_date);
115:
116: /* Get Daily Amount input value */
117: open csr_daily_amt_iv_id;
118: fetch csr_daily_amt_iv_id into l_daily_amt_iv_id;

Line 121: hr_utility.set_location(g_package_name||'.'||l_function_name,2);

117: open csr_daily_amt_iv_id;
118: fetch csr_daily_amt_iv_id into l_daily_amt_iv_id;
119: close csr_daily_amt_iv_id;
120:
121: hr_utility.set_location(g_package_name||'.'||l_function_name,2);
122:
123: /* Open cursor to retrieve working tax credit element entries up to p_end_date */
124: /* Loop round until all relevant entries retrieved */
125:

Line 128: hr_utility.set_location(g_package_name||'.'||l_function_name,3);

124: /* Loop round until all relevant entries retrieved */
125:
126: for current_entry in csr_wtc_entries loop
127:
128: hr_utility.set_location(g_package_name||'.'||l_function_name,3);
129:
130: hr_utility.trace('current_entry.start_date: '||current_entry.start_date);
131: hr_utility.trace('current_entry.end_date: '||current_entry.end_date);
132:

Line 130: hr_utility.trace('current_entry.start_date: '||current_entry.start_date);

126: for current_entry in csr_wtc_entries loop
127:
128: hr_utility.set_location(g_package_name||'.'||l_function_name,3);
129:
130: hr_utility.trace('current_entry.start_date: '||current_entry.start_date);
131: hr_utility.trace('current_entry.end_date: '||current_entry.end_date);
132:
133: /* Initialise calculation start and end dates to null */
134: l_calc_start_date := null;

Line 131: hr_utility.trace('current_entry.end_date: '||current_entry.end_date);

127:
128: hr_utility.set_location(g_package_name||'.'||l_function_name,3);
129:
130: hr_utility.trace('current_entry.start_date: '||current_entry.start_date);
131: hr_utility.trace('current_entry.end_date: '||current_entry.end_date);
132:
133: /* Initialise calculation start and end dates to null */
134: l_calc_start_date := null;
135: l_calc_end_date := null;

Line 176: hr_utility.trace('Calculation start date: '||l_calc_start_date);

172: l_calc_end_date := current_entry.end_date;
173:
174: end if;
175:
176: hr_utility.trace('Calculation start date: '||l_calc_start_date);
177: hr_utility.trace('Calculation end date: '||l_calc_end_date);
178:
179: hr_utility.set_location(g_package_name||'.'||l_function_name,4);
180:

Line 177: hr_utility.trace('Calculation end date: '||l_calc_end_date);

173:
174: end if;
175:
176: hr_utility.trace('Calculation start date: '||l_calc_start_date);
177: hr_utility.trace('Calculation end date: '||l_calc_end_date);
178:
179: hr_utility.set_location(g_package_name||'.'||l_function_name,4);
180:
181: /* Work out number of days between calculation start and end date */

Line 179: hr_utility.set_location(g_package_name||'.'||l_function_name,4);

175:
176: hr_utility.trace('Calculation start date: '||l_calc_start_date);
177: hr_utility.trace('Calculation end date: '||l_calc_end_date);
178:
179: hr_utility.set_location(g_package_name||'.'||l_function_name,4);
180:
181: /* Work out number of days between calculation start and end date */
182:
183: l_days_payable := pay_gb_working_tax_credit.days_between(l_calc_start_date, l_calc_end_date);

Line 188: hr_utility.trace('Days payable: '||l_days_payable||' * current daily amount: '||

184:
185:
186: /* Multiply days payable for this loop by daily rate for current entry */
187: /* Add this amount to the running total amount for entries retrieved */
188: hr_utility.trace('Days payable: '||l_days_payable||' * current daily amount: '||
189: current_entry.daily_amount||' = '||(l_days_payable * current_entry.daily_amount));
190:
191: l_running_total := l_running_total + (l_days_payable * current_entry.daily_amount);
192:

Line 193: hr_utility.trace('l_running_total: '||l_running_total);

189: current_entry.daily_amount||' = '||(l_days_payable * current_entry.daily_amount));
190:
191: l_running_total := l_running_total + (l_days_payable * current_entry.daily_amount);
192:
193: hr_utility.trace('l_running_total: '||l_running_total);
194:
195: hr_utility.set_location(g_package_name||'.'||l_function_name,5);
196:
197: end loop;

Line 195: hr_utility.set_location(g_package_name||'.'||l_function_name,5);

191: l_running_total := l_running_total + (l_days_payable * current_entry.daily_amount);
192:
193: hr_utility.trace('l_running_total: '||l_running_total);
194:
195: hr_utility.set_location(g_package_name||'.'||l_function_name,5);
196:
197: end loop;
198:
199: hr_utility.set_location(g_package_name||'.'||l_function_name,6);

Line 199: hr_utility.set_location(g_package_name||'.'||l_function_name,6);

195: hr_utility.set_location(g_package_name||'.'||l_function_name,5);
196:
197: end loop;
198:
199: hr_utility.set_location(g_package_name||'.'||l_function_name,6);
200:
201: l_total_payable := l_running_total;
202:
203: hr_utility.trace('Total amount payable: '||l_total_payable);

Line 203: hr_utility.trace('Total amount payable: '||l_total_payable);

199: hr_utility.set_location(g_package_name||'.'||l_function_name,6);
200:
201: l_total_payable := l_running_total;
202:
203: hr_utility.trace('Total amount payable: '||l_total_payable);
204:
205: hr_utility.set_location(g_package_name||'.'||l_function_name,7);
206:
207: return l_total_payable;

Line 205: hr_utility.set_location(g_package_name||'.'||l_function_name,7);

201: l_total_payable := l_running_total;
202:
203: hr_utility.trace('Total amount payable: '||l_total_payable);
204:
205: hr_utility.set_location(g_package_name||'.'||l_function_name,7);
206:
207: return l_total_payable;
208:
209: end calculate_payable;