172: lc_plan_exists VARCHAR2(1) := 'N';
173:
174: BEGIN
175:
176: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 10);
177: hr_utility.trace('p_assignment_action_id = ' || p_assignment_action_id);
178: hr_utility.trace('p_assignment_id = ' || p_assignment_id );
179: hr_utility.trace('p_cur_earned_date = ' || p_cur_earned_date );
180:
173:
174: BEGIN
175:
176: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 10);
177: hr_utility.trace('p_assignment_action_id = ' || p_assignment_action_id);
178: hr_utility.trace('p_assignment_id = ' || p_assignment_id );
179: hr_utility.trace('p_cur_earned_date = ' || p_cur_earned_date );
180:
181: open c_payroll_id(p_assignment_action_id);
174: BEGIN
175:
176: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 10);
177: hr_utility.trace('p_assignment_action_id = ' || p_assignment_action_id);
178: hr_utility.trace('p_assignment_id = ' || p_assignment_id );
179: hr_utility.trace('p_cur_earned_date = ' || p_cur_earned_date );
180:
181: open c_payroll_id(p_assignment_action_id);
182: fetch c_payroll_id into ln_payroll_id, ln_business_group_id;
175:
176: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 10);
177: hr_utility.trace('p_assignment_action_id = ' || p_assignment_action_id);
178: hr_utility.trace('p_assignment_id = ' || p_assignment_id );
179: hr_utility.trace('p_cur_earned_date = ' || p_cur_earned_date );
180:
181: open c_payroll_id(p_assignment_action_id);
182: fetch c_payroll_id into ln_payroll_id, ln_business_group_id;
183: if c_payroll_id%found then
187: close c_time_periods;
188: end if;
189: close c_payroll_id;
190:
191: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 30);
192: hr_utility.trace('Payroll Start Date = ' || ld_period_start_date);
193: hr_utility.trace('Payroll End Date = ' || ld_period_end_date);
194:
195: lv_correspndence_lang := pay_emp_action_arch.gv_correspondence_language;
188: end if;
189: close c_payroll_id;
190:
191: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 30);
192: hr_utility.trace('Payroll Start Date = ' || ld_period_start_date);
193: hr_utility.trace('Payroll End Date = ' || ld_period_end_date);
194:
195: lv_correspndence_lang := pay_emp_action_arch.gv_correspondence_language;
196:
189: close c_payroll_id;
190:
191: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 30);
192: hr_utility.trace('Payroll Start Date = ' || ld_period_start_date);
193: hr_utility.trace('Payroll End Date = ' || ld_period_end_date);
194:
195: lv_correspndence_lang := pay_emp_action_arch.gv_correspondence_language;
196:
197: hr_utility.trace('lv_correspndence_lang = ' || lv_correspndence_lang);
193: hr_utility.trace('Payroll End Date = ' || ld_period_end_date);
194:
195: lv_correspndence_lang := pay_emp_action_arch.gv_correspondence_language;
196:
197: hr_utility.trace('lv_correspndence_lang = ' || lv_correspndence_lang);
198:
199: open c_accrual_category(lv_correspndence_lang);
200: loop
201: fetch c_accrual_category into lv_accrual_code, lv_accrual_category;
202: if c_accrual_category%notfound then
203: exit;
204: end if;
205:
206: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 50);
207: hr_utility.trace('Accrual Category = ' || lv_accrual_code);
208:
209: open c_accrual_plan( p_assignment_id
210: ,p_cur_earned_date
203: exit;
204: end if;
205:
206: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 50);
207: hr_utility.trace('Accrual Category = ' || lv_accrual_code);
208:
209: open c_accrual_plan( p_assignment_id
210: ,p_cur_earned_date
211: ,lv_accrual_code
213: loop
214: fetch c_accrual_plan into ln_accrual_plan_id
215: ,ln_accrual_ele_type_id;
216: if c_accrual_plan%notfound then
217: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 60);
218: exit;
219: end if;
220:
221: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 70);
217: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 60);
218: exit;
219: end if;
220:
221: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 70);
222: hr_utility.trace('Accrual Plan ID = ' || ln_accrual_plan_id);
223: hr_utility.trace('Accrual Elem ID = ' || ln_accrual_ele_type_id);
224:
225:
218: exit;
219: end if;
220:
221: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 70);
222: hr_utility.trace('Accrual Plan ID = ' || ln_accrual_plan_id);
223: hr_utility.trace('Accrual Elem ID = ' || ln_accrual_ele_type_id);
224:
225:
226: /*************************************************************
219: end if;
220:
221: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 70);
222: hr_utility.trace('Accrual Plan ID = ' || ln_accrual_plan_id);
223: hr_utility.trace('Accrual Elem ID = ' || ln_accrual_ele_type_id);
224:
225:
226: /*************************************************************
227: ** Set Var. if Plan Exists.
242: ,p_assignment_action_id => -1
243: );
244:
245:
246: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 80);
247:
248: per_accrual_calc_functions.get_net_accrual(
249: p_assignment_id => p_assignment_id,
250: p_plan_id => ln_accrual_plan_id,
299: if lc_plan_exists = 'Y' then
300:
301: i_count := i_count + 1;
302:
303: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 100);
304: lc_plan_exists := 'N';
305:
306: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_code
307: := lv_accrual_code;
325: p_total_acc_category := i_count;
326:
327:
328: for i in 1 .. i_count loop
329: hr_utility.trace('Accrual Code = '
330: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code);
331: hr_utility.trace('Accrual Type = '
332: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);
333: hr_utility.trace('Accrual Current = '
327:
328: for i in 1 .. i_count loop
329: hr_utility.trace('Accrual Code = '
330: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code);
331: hr_utility.trace('Accrual Type = '
332: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);
333: hr_utility.trace('Accrual Current = '
334: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
335: hr_utility.trace('Accrual Bal = '
329: hr_utility.trace('Accrual Code = '
330: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code);
331: hr_utility.trace('Accrual Type = '
332: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);
333: hr_utility.trace('Accrual Current = '
334: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
335: hr_utility.trace('Accrual Bal = '
336: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
337: end loop;
331: hr_utility.trace('Accrual Type = '
332: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);
333: hr_utility.trace('Accrual Current = '
334: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
335: hr_utility.trace('Accrual Bal = '
336: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
337: end loop;
338:
339: hr_utility.trace('Total Accrual Account = ' || i_count);
335: hr_utility.trace('Accrual Bal = '
336: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
337: end loop;
338:
339: hr_utility.trace('Total Accrual Account = ' || i_count);
340: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 110);
341:
342: END get_emp_net_accrual;
343:
336: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
337: end loop;
338:
339: hr_utility.trace('Total Accrual Account = ' || i_count);
340: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 110);
341:
342: END get_emp_net_accrual;
343:
344:
363: END delete_ltr_assignment_accrual;
364:
365:
366: --BEGIN
367: -- hr_utility.trace_on(null, 'ORACLE');
368:
369: END pay_us_emp_payslip_accrual_web;