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.7.12020000.4 2013/01/09 12:11:55 agarai 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 78: gv_package_name VARCHAR2(100) := 'pay_us_emp_payslip_accrual_web';

74: AS
75: /*****************************************************
76: ** Global Package Body Variables
77: ******************************************************/
78: gv_package_name VARCHAR2(100) := 'pay_us_emp_payslip_accrual_web';
79:
80:
81: PROCEDURE get_emp_net_accrual (
82: p_assignment_action_id in number

Line 323: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_code

319:
320: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 100);
321: lc_plan_exists := 'N';
322:
323: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_code
324: := lv_accrual_code;
325: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_category
326: := lv_accrual_category;
327: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_cur_value

Line 325: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_category

321: lc_plan_exists := 'N';
322:
323: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_code
324: := lv_accrual_code;
325: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_category
326: := lv_accrual_category;
327: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_cur_value
328: := l_cur_tot_accrual_hours;
329: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_net_value

Line 327: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_cur_value

323: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_code
324: := lv_accrual_code;
325: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_category
326: := lv_accrual_category;
327: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_cur_value
328: := l_cur_tot_accrual_hours;
329: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_net_value
330: := l_net_tot_accrual_hours;
331:

Line 329: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_net_value

325: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_category
326: := lv_accrual_category;
327: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_cur_value
328: := l_cur_tot_accrual_hours;
329: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_net_value
330: := l_net_tot_accrual_hours;
331:
332: lv_accrual_category := null;
333: lv_accrual_code := null;

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

343:
344:
345: for i in 1 .. i_count loop
346: hr_utility.trace('Accrual Code = '
347: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code);
348: hr_utility.trace('Accrual Type = '
349: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);
350: hr_utility.trace('Accrual Current = '
351: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);

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

345: for i in 1 .. i_count loop
346: hr_utility.trace('Accrual Code = '
347: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code);
348: hr_utility.trace('Accrual Type = '
349: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);
350: hr_utility.trace('Accrual Current = '
351: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
352: hr_utility.trace('Accrual Bal = '
353: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);

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

347: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code);
348: hr_utility.trace('Accrual Type = '
349: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);
350: hr_utility.trace('Accrual Current = '
351: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
352: hr_utility.trace('Accrual Bal = '
353: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
354: end loop;
355:

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

349: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);
350: hr_utility.trace('Accrual Current = '
351: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
352: hr_utility.trace('Accrual Bal = '
353: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
354: end loop;
355:
356: hr_utility.trace('Total Accrual Account = ' || i_count);
357: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 110);

Line 386: END pay_us_emp_payslip_accrual_web;

382:
383: --BEGIN
384: -- hr_utility.trace_on(null, 'ORACLE');
385:
386: END pay_us_emp_payslip_accrual_web;