DBA Data[Home] [Help]

APPS.PAY_US_EMP_PAYSLIP_ACCRUAL_WEB dependencies on PAY_US_EMP_PAYSLIP_ACCRUAL_WEB

Line 1: PACKAGE BODY pay_us_emp_payslip_accrual_web

1: PACKAGE BODY pay_us_emp_payslip_accrual_web
2: /* $Header: pyusacrw.pkb 120.5.12000000.3 2007/03/05 06:20:04 sackumar ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_us_emp_payslip_accrual_web

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_us_emp_payslip_accrual_web
21:
22: Description : Package gets all the Accrual plans for an
23: Employee and populates a PL/SQL table -
24: LTR_ASSIGNMENT_ACCRUALS.

Line 71: gv_package_name VARCHAR2(100) := 'pay_us_emp_payslip_accrual_web';

67: AS
68: /*****************************************************
69: ** Global Package Body Variables
70: ******************************************************/
71: gv_package_name VARCHAR2(100) := 'pay_us_emp_payslip_accrual_web';
72:
73:
74: PROCEDURE get_emp_net_accrual (
75: p_assignment_action_id in number

Line 306: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_code

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;
308: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_category
309: := lv_accrual_category;
310: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_cur_value

Line 308: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_category

304: lc_plan_exists := 'N';
305:
306: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_code
307: := lv_accrual_code;
308: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_category
309: := lv_accrual_category;
310: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_cur_value
311: := l_cur_tot_accrual_hours;
312: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_net_value

Line 310: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_cur_value

306: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_code
307: := lv_accrual_code;
308: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_category
309: := lv_accrual_category;
310: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_cur_value
311: := l_cur_tot_accrual_hours;
312: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_net_value
313: := l_net_tot_accrual_hours;
314:

Line 312: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_net_value

308: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_category
309: := lv_accrual_category;
310: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_cur_value
311: := l_cur_tot_accrual_hours;
312: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_net_value
313: := l_net_tot_accrual_hours;
314:
315: lv_accrual_category := null;
316: lv_accrual_code := null;

Line 330: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code);

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 = '
334: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);

Line 332: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);

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 = '
336: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);

Line 334: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);

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;
338:

Line 336: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);

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);
340: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 110);

Line 369: END pay_us_emp_payslip_accrual_web;

365:
366: --BEGIN
367: -- hr_utility.trace_on(null, 'ORACLE');
368:
369: END pay_us_emp_payslip_accrual_web;