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_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_EMP_ACTION_ARCH

Line 1233: Payroll Archive Package PAY_EMP_ACTION_ARCH. If anything

1229: provided only for informative purpose and also to make
1230: sure that we have same user experience with Simulation
1231: Payslip as we have with Regular Payslip.
1232: Important : This procedure borrows most of the Code from the Parent
1233: Payroll Archive Package PAY_EMP_ACTION_ARCH. If anything
1234: needs to be archived in addition to or different from the
1235: current data, then it is highly necessary to create own
1236: procedures. It is mostly desired not to alter the Regular
1237: Archiver Code for Payroll Simulation purpose.

Line 1432: pay_emp_action_arch.initialization_process;

1428: lv_exists := 'N';
1429:
1430: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1431:
1432: pay_emp_action_arch.initialization_process;
1433:
1434: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1435:
1436: OPEN c_employee_details(p_assignment_id,p_effective_date,p_date_earned);

Line 1476: lv_gre_name := pay_emp_action_arch.get_organization_name(p_tax_unit_id);

1472: CLOSE c_period_details;
1473:
1474: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1475:
1476: lv_gre_name := pay_emp_action_arch.get_organization_name(p_tax_unit_id);
1477: lv_organization_name := pay_emp_action_arch.get_organization_name(ln_organization_id);
1478:
1479: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1480:

Line 1477: lv_organization_name := pay_emp_action_arch.get_organization_name(ln_organization_id);

1473:
1474: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1475:
1476: lv_gre_name := pay_emp_action_arch.get_organization_name(p_tax_unit_id);
1477: lv_organization_name := pay_emp_action_arch.get_organization_name(ln_organization_id);
1478:
1479: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1480:
1481: IF ln_job_id IS NOT NULL THEN

Line 1482: lv_job_name := pay_emp_action_arch.get_job_name(ln_job_id

1478:
1479: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1480:
1481: IF ln_job_id IS NOT NULL THEN
1482: lv_job_name := pay_emp_action_arch.get_job_name(ln_job_id
1483: ,p_effective_date);
1484: END IF ;
1485:
1486: hr_utility.set_location(gv_package || lv_procedure_name, 50);

Line 1489: lv_position_name := pay_emp_action_arch.get_position(ln_position_id

1485:
1486: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1487:
1488: IF ln_position_id IS NOT NULL THEN
1489: lv_position_name := pay_emp_action_arch.get_position(ln_position_id
1490: ,p_effective_date);
1491: END IF;
1492:
1493: hr_utility.set_location(gv_package || lv_procedure_name, 60);

Line 1496: lv_pay_basis := pay_emp_action_arch.get_pay_basis(ln_pay_basis_id

1492:
1493: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1494:
1495: IF ln_pay_basis_id IS NOT NULL THEN
1496: lv_pay_basis := pay_emp_action_arch.get_pay_basis(ln_pay_basis_id
1497: ,p_effective_date);
1498: END IF;
1499:
1500: hr_utility.set_location(gv_package || lv_procedure_name, 70);

Line 1503: lv_location_code := pay_emp_action_arch.get_location(ln_location_id);

1499:
1500: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1501:
1502: IF ln_location_id IS NOT NULL THEN
1503: lv_location_code := pay_emp_action_arch.get_location(ln_location_id);
1504: END IF;
1505:
1506: hr_utility.set_location(gv_package || lv_procedure_name, 80);
1507:

Line 1508: ln_proposed_salary := pay_emp_action_arch.get_proposed_emp_salary(p_assignment_id

1504: END IF;
1505:
1506: hr_utility.set_location(gv_package || lv_procedure_name, 80);
1507:
1508: ln_proposed_salary := pay_emp_action_arch.get_proposed_emp_salary(p_assignment_id
1509: ,ln_pay_basis_id
1510: ,lv_pay_basis
1511: ,p_date_earned);
1512:

Line 1515: ln_pay_annualization_factor := pay_emp_action_arch.get_emp_annualization_factor(

1511: ,p_date_earned);
1512:
1513: hr_utility.set_location(gv_package || lv_procedure_name, 90);
1514:
1515: ln_pay_annualization_factor := pay_emp_action_arch.get_emp_annualization_factor(
1516: ln_pay_basis_id
1517: ,lv_period_type
1518: ,lv_pay_basis
1519: ,p_assignment_id

Line 1525: lv_frequency_desc := pay_emp_action_arch.get_frequency(lv_frequency

1521:
1522: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1523:
1524: IF lv_frequency IS NOT NULL THEN
1525: lv_frequency_desc := pay_emp_action_arch.get_frequency(lv_frequency
1526: ,p_effective_date);
1527: END IF;
1528:
1529: hr_utility.set_location(gv_package || lv_procedure_name, 110);

Line 1532: lv_grade := pay_emp_action_arch.get_grade(ln_grade_id

1528:
1529: hr_utility.set_location(gv_package || lv_procedure_name, 110);
1530:
1531: IF ln_grade_id IS NOT NULL THEN
1532: lv_grade := pay_emp_action_arch.get_grade(ln_grade_id
1533: ,p_effective_date);
1534: END IF;
1535:
1536: hr_utility.set_location(gv_package || lv_procedure_name, 120);

Line 1539: lv_bargaining_unit := pay_emp_action_arch.get_bargaining_unit(lv_bargaining_unit_code

1535:
1536: hr_utility.set_location(gv_package || lv_procedure_name, 120);
1537:
1538: IF lv_bargaining_unit_code IS NOT NULL THEN
1539: lv_bargaining_unit := pay_emp_action_arch.get_bargaining_unit(lv_bargaining_unit_code
1540: ,p_effective_date);
1541: END IF;
1542:
1543: hr_utility.set_location(gv_package || lv_procedure_name, 130);

Line 1546: lv_collective_agreement := pay_emp_action_arch.get_collective_agreement(

1542:
1543: hr_utility.set_location(gv_package || lv_procedure_name, 130);
1544:
1545: IF ln_collective_agreement_id IS NOT NULL THEN
1546: lv_collective_agreement := pay_emp_action_arch.get_collective_agreement(
1547: ln_collective_agreement_id
1548: ,p_effective_date
1549: );
1550: END IF;

Line 1555: lv_contract := pay_emp_action_arch.get_contract(ln_contract_id

1551:
1552: hr_utility.set_location(gv_package || lv_procedure_name, 140);
1553:
1554: IF ln_contract_id IS NOT NULL THEN
1555: lv_contract := pay_emp_action_arch.get_contract(ln_contract_id
1556: ,p_effective_date) ;
1557: END IF;
1558:
1559: hr_utility.set_location(gv_package || lv_procedure_name, 150);

Line 1562: lv_hourly_salaried_desc := pay_emp_action_arch.get_hourly_salaried_code(

1558:
1559: hr_utility.set_location(gv_package || lv_procedure_name, 150);
1560:
1561: IF lv_hourly_salaried_code IS NOT NULL THEN
1562: lv_hourly_salaried_desc := pay_emp_action_arch.get_hourly_salaried_code(
1563: lv_hourly_salaried_code
1564: ,p_effective_date) ;
1565: END IF;
1566:

Line 1570: lv_shift_desc := pay_emp_action_arch.get_shift( ln_soft_coding_keyflex_id

1566:
1567: hr_utility.set_location(gv_package || lv_procedure_name, 160);
1568:
1569: IF ln_soft_coding_keyflex_id IS NOT NULL THEN
1570: lv_shift_desc := pay_emp_action_arch.get_shift( ln_soft_coding_keyflex_id
1571: ,p_effective_date,ln_business_group_id) ;
1572: END IF;
1573:
1574: hr_utility.set_location(gv_package || lv_procedure_name, 170);

Line 1588: ln_index := pay_emp_action_arch.lrr_act_tab.count;

1584: END IF;
1585:
1586: hr_utility.set_location(gv_package || lv_procedure_name, 180);
1587:
1588: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1589:
1590: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1591: := 'EMPLOYEE DETAILS';
1592: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code

Line 1590: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category

1586: hr_utility.set_location(gv_package || lv_procedure_name, 180);
1587:
1588: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1589:
1590: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1591: := 'EMPLOYEE DETAILS';
1592: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1593: := '00-000-0000';
1594: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1

Line 1592: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code

1588: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1589:
1590: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1591: := 'EMPLOYEE DETAILS';
1592: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1593: := '00-000-0000';
1594: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1595: := lv_full_name;
1596:

Line 1594: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1

1590: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1591: := 'EMPLOYEE DETAILS';
1592: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1593: := '00-000-0000';
1594: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1595: := lv_full_name;
1596:
1597: OPEN get_legislation_code(ln_business_group_id,p_effective_date);
1598: FETCH get_legislation_code INTO lv_legislation_code;

Line 1607: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1

1603: OPEN c_get_employee_name(ln_person_id,p_effective_date);
1604: FETCH c_get_employee_name INTO lv_employee_name;
1605: CLOSE c_get_employee_name;
1606:
1607: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
1608: := lv_employee_name;
1609:
1610: END IF;
1611:

Line 1614: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2

1610: END IF;
1611:
1612: hr_utility.trace('lv_full_name is'||lv_full_name);
1613:
1614: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1615: := ln_organization_id;
1616: hr_utility.trace('ln_organization_id is'||ln_organization_id);
1617:
1618: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4

Line 1618: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4

1614: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
1615: := ln_organization_id;
1616: hr_utility.trace('ln_organization_id is'||ln_organization_id);
1617:
1618: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
1619: := lv_national_identifier ;
1620:
1621: hr_utility.trace('lv_national_identifier is'||lv_national_identifier);
1622:

Line 1623: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5 := lv_pay_basis;

1619: := lv_national_identifier ;
1620:
1621: hr_utility.trace('lv_national_identifier is'||lv_national_identifier);
1622:
1623: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5 := lv_pay_basis;
1624:
1625: hr_utility.trace('lv_pay_basis is'||lv_pay_basis);
1626:
1627: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6

Line 1627: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6

1623: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5 := lv_pay_basis;
1624:
1625: hr_utility.trace('lv_pay_basis is'||lv_pay_basis);
1626:
1627: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
1628: := lv_frequency_desc;
1629:
1630: hr_utility.trace('lv_frequency_desc is'||lv_frequency_desc);
1631:

Line 1632: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7

1628: := lv_frequency_desc;
1629:
1630: hr_utility.trace('lv_frequency_desc is'||lv_frequency_desc);
1631:
1632: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
1633: := lv_grade;
1634:
1635: hr_utility.trace('lv_grade is'||lv_grade);
1636:

Line 1637: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8

1633: := lv_grade;
1634:
1635: hr_utility.trace('lv_grade is'||lv_grade);
1636:
1637: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1638: := lv_bargaining_unit;
1639:
1640: hr_utility.trace('lv_bargaining_unit is'||lv_bargaining_unit);
1641: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9

Line 1641: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9

1637: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
1638: := lv_bargaining_unit;
1639:
1640: hr_utility.trace('lv_bargaining_unit is'||lv_bargaining_unit);
1641: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1642: := lv_collective_agreement;
1643:
1644: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);
1645: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10

Line 1645: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10

1641: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
1642: := lv_collective_agreement;
1643:
1644: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);
1645: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1646: := lv_employee_number ;
1647:
1648: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1649: := fnd_date.date_to_canonical(ld_date_start);

Line 1648: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11

1644: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);
1645: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
1646: := lv_employee_number ;
1647:
1648: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1649: := fnd_date.date_to_canonical(ld_date_start);
1650:
1651: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1652: := fnd_date.date_to_canonical(ld_original_date_of_hire);

Line 1651: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12

1647:
1648: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11
1649: := fnd_date.date_to_canonical(ld_date_start);
1650:
1651: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1652: := fnd_date.date_to_canonical(ld_original_date_of_hire);
1653:
1654: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1655: := fnd_date.date_to_canonical(ld_adjusted_svc_date);

Line 1654: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13

1650:
1651: pay_emp_action_arch.lrr_act_tab(ln_index).act_info12
1652: := fnd_date.date_to_canonical(ld_original_date_of_hire);
1653:
1654: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1655: := fnd_date.date_to_canonical(ld_adjusted_svc_date);
1656:
1657: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1658: := lv_assignment_number;

Line 1657: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14

1653:
1654: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1655: := fnd_date.date_to_canonical(ld_adjusted_svc_date);
1656:
1657: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1658: := lv_assignment_number;
1659:
1660: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
1661: := lv_organization_name;

Line 1660: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15

1656:
1657: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1658: := lv_assignment_number;
1659:
1660: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
1661: := lv_organization_name;
1662: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
1663: := p_time_period_id;
1664: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17

Line 1662: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16

1658: := lv_assignment_number;
1659:
1660: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
1661: := lv_organization_name;
1662: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
1663: := p_time_period_id;
1664: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
1665: := lv_job_name ;
1666: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18

Line 1664: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17

1660: pay_emp_action_arch.lrr_act_tab(ln_index).act_info15
1661: := lv_organization_name;
1662: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
1663: := p_time_period_id;
1664: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
1665: := lv_job_name ;
1666: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
1667: := lv_gre_name;
1668: pay_emp_action_arch.lrr_act_tab(ln_index).act_info19

Line 1666: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18

1662: pay_emp_action_arch.lrr_act_tab(ln_index).act_info16
1663: := p_time_period_id;
1664: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
1665: := lv_job_name ;
1666: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
1667: := lv_gre_name;
1668: pay_emp_action_arch.lrr_act_tab(ln_index).act_info19
1669: := lv_position_name;
1670: pay_emp_action_arch.lrr_act_tab(ln_index).act_info20

Line 1668: pay_emp_action_arch.lrr_act_tab(ln_index).act_info19

1664: pay_emp_action_arch.lrr_act_tab(ln_index).act_info17
1665: := lv_job_name ;
1666: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
1667: := lv_gre_name;
1668: pay_emp_action_arch.lrr_act_tab(ln_index).act_info19
1669: := lv_position_name;
1670: pay_emp_action_arch.lrr_act_tab(ln_index).act_info20
1671: := lv_contract;
1672: pay_emp_action_arch.lrr_act_tab(ln_index).act_info21

Line 1670: pay_emp_action_arch.lrr_act_tab(ln_index).act_info20

1666: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
1667: := lv_gre_name;
1668: pay_emp_action_arch.lrr_act_tab(ln_index).act_info19
1669: := lv_position_name;
1670: pay_emp_action_arch.lrr_act_tab(ln_index).act_info20
1671: := lv_contract;
1672: pay_emp_action_arch.lrr_act_tab(ln_index).act_info21
1673: := lv_time_normal_start ;
1674: pay_emp_action_arch.lrr_act_tab(ln_index).act_info22

Line 1672: pay_emp_action_arch.lrr_act_tab(ln_index).act_info21

1668: pay_emp_action_arch.lrr_act_tab(ln_index).act_info19
1669: := lv_position_name;
1670: pay_emp_action_arch.lrr_act_tab(ln_index).act_info20
1671: := lv_contract;
1672: pay_emp_action_arch.lrr_act_tab(ln_index).act_info21
1673: := lv_time_normal_start ;
1674: pay_emp_action_arch.lrr_act_tab(ln_index).act_info22
1675: := lv_time_normal_finish;
1676: pay_emp_action_arch.lrr_act_tab(ln_index).act_info23

Line 1674: pay_emp_action_arch.lrr_act_tab(ln_index).act_info22

1670: pay_emp_action_arch.lrr_act_tab(ln_index).act_info20
1671: := lv_contract;
1672: pay_emp_action_arch.lrr_act_tab(ln_index).act_info21
1673: := lv_time_normal_start ;
1674: pay_emp_action_arch.lrr_act_tab(ln_index).act_info22
1675: := lv_time_normal_finish;
1676: pay_emp_action_arch.lrr_act_tab(ln_index).act_info23
1677: := lv_pay_calc_method;
1678: pay_emp_action_arch.lrr_act_tab(ln_index).act_info24

Line 1676: pay_emp_action_arch.lrr_act_tab(ln_index).act_info23

1672: pay_emp_action_arch.lrr_act_tab(ln_index).act_info21
1673: := lv_time_normal_start ;
1674: pay_emp_action_arch.lrr_act_tab(ln_index).act_info22
1675: := lv_time_normal_finish;
1676: pay_emp_action_arch.lrr_act_tab(ln_index).act_info23
1677: := lv_pay_calc_method;
1678: pay_emp_action_arch.lrr_act_tab(ln_index).act_info24
1679: := lv_shift_desc;
1680: pay_emp_action_arch.lrr_act_tab(ln_index).act_info25

Line 1678: pay_emp_action_arch.lrr_act_tab(ln_index).act_info24

1674: pay_emp_action_arch.lrr_act_tab(ln_index).act_info22
1675: := lv_time_normal_finish;
1676: pay_emp_action_arch.lrr_act_tab(ln_index).act_info23
1677: := lv_pay_calc_method;
1678: pay_emp_action_arch.lrr_act_tab(ln_index).act_info24
1679: := lv_shift_desc;
1680: pay_emp_action_arch.lrr_act_tab(ln_index).act_info25
1681: := lv_er_phone_number;
1682: pay_emp_action_arch.lrr_act_tab(ln_index).act_info26

Line 1680: pay_emp_action_arch.lrr_act_tab(ln_index).act_info25

1676: pay_emp_action_arch.lrr_act_tab(ln_index).act_info23
1677: := lv_pay_calc_method;
1678: pay_emp_action_arch.lrr_act_tab(ln_index).act_info24
1679: := lv_shift_desc;
1680: pay_emp_action_arch.lrr_act_tab(ln_index).act_info25
1681: := lv_er_phone_number;
1682: pay_emp_action_arch.lrr_act_tab(ln_index).act_info26
1683: := lv_hourly_salaried_desc;
1684: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27

Line 1682: pay_emp_action_arch.lrr_act_tab(ln_index).act_info26

1678: pay_emp_action_arch.lrr_act_tab(ln_index).act_info24
1679: := lv_shift_desc;
1680: pay_emp_action_arch.lrr_act_tab(ln_index).act_info25
1681: := lv_er_phone_number;
1682: pay_emp_action_arch.lrr_act_tab(ln_index).act_info26
1683: := lv_hourly_salaried_desc;
1684: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27
1685: := lv_step ;
1686: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28

Line 1684: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27

1680: pay_emp_action_arch.lrr_act_tab(ln_index).act_info25
1681: := lv_er_phone_number;
1682: pay_emp_action_arch.lrr_act_tab(ln_index).act_info26
1683: := lv_hourly_salaried_desc;
1684: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27
1685: := lv_step ;
1686: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28
1687: := fnd_number.number_to_canonical(ln_proposed_salary) ;
1688: pay_emp_action_arch.lrr_act_tab(ln_index).act_info29

Line 1686: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28

1682: pay_emp_action_arch.lrr_act_tab(ln_index).act_info26
1683: := lv_hourly_salaried_desc;
1684: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27
1685: := lv_step ;
1686: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28
1687: := fnd_number.number_to_canonical(ln_proposed_salary) ;
1688: pay_emp_action_arch.lrr_act_tab(ln_index).act_info29
1689: := fnd_number.number_to_canonical(ln_pay_annualization_factor) ;
1690: pay_emp_action_arch.lrr_act_tab(ln_index).act_info30

Line 1688: pay_emp_action_arch.lrr_act_tab(ln_index).act_info29

1684: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27
1685: := lv_step ;
1686: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28
1687: := fnd_number.number_to_canonical(ln_proposed_salary) ;
1688: pay_emp_action_arch.lrr_act_tab(ln_index).act_info29
1689: := fnd_number.number_to_canonical(ln_pay_annualization_factor) ;
1690: pay_emp_action_arch.lrr_act_tab(ln_index).act_info30
1691: := lv_location_code ;
1692:

Line 1690: pay_emp_action_arch.lrr_act_tab(ln_index).act_info30

1686: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28
1687: := fnd_number.number_to_canonical(ln_proposed_salary) ;
1688: pay_emp_action_arch.lrr_act_tab(ln_index).act_info29
1689: := fnd_number.number_to_canonical(ln_pay_annualization_factor) ;
1690: pay_emp_action_arch.lrr_act_tab(ln_index).act_info30
1691: := lv_location_code ;
1692:
1693: hr_utility.set_location(gv_package || lv_procedure_name, 190);
1694:

Line 1702: pay_emp_action_arch.get_employee_other_info(p_run_action_id => p_assignment_action_id

1698: this data and XML also gets generated including this information. But the Payroll
1699: Simulator Output will not have these details. Any customer who needs this extra
1700: information can add the required sections in their template.*/
1701:
1702: pay_emp_action_arch.get_employee_other_info(p_run_action_id => p_assignment_action_id
1703: ,p_assignment_id => p_assignment_id
1704: ,p_organization_id => ln_organization_id
1705: ,p_business_group_id => ln_business_group_id
1706: ,p_curr_pymt_eff_date => p_effective_date

Line 1714: pay_emp_action_arch.get_employee_addr (ln_person_id

1710: ) ;
1711:
1712: hr_utility.set_location(gv_package || lv_procedure_name, 200);
1713:
1714: pay_emp_action_arch.get_employee_addr (ln_person_id
1715: ,p_effective_date);
1716:
1717: hr_utility.set_location(gv_package || lv_procedure_name, 210);
1718:

Line 1719: IF pay_emp_action_arch.lrr_act_tab.count > 0 THEN

1715: ,p_effective_date);
1716:
1717: hr_utility.set_location(gv_package || lv_procedure_name, 210);
1718:
1719: IF pay_emp_action_arch.lrr_act_tab.count > 0 THEN
1720:
1721: hr_utility.set_location(gv_package || lv_procedure_name, 220);
1722:
1723: pay_simulator_pkg.insert_simulation_rows(

Line 1729: ,p_tab_rec_data => pay_emp_action_arch.lrr_act_tab

1725: ,p_action_context_type => 'AAP'
1726: ,p_assignment_id => p_assignment_id
1727: ,p_tax_unit_id => p_tax_unit_id
1728: ,p_effective_date => p_effective_date
1729: ,p_tab_rec_data => pay_emp_action_arch.lrr_act_tab
1730: );
1731: END IF;
1732:
1733: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

Line 1839: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN

1835: BEGIN
1836:
1837: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
1838:
1839: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
1840:
1841: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1842:
1843: pay_emp_action_arch.gv_multi_leg_rule

Line 1843: pay_emp_action_arch.gv_multi_leg_rule

1839: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
1840:
1841: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1842:
1843: pay_emp_action_arch.gv_multi_leg_rule
1844: := pay_emp_action_arch.get_multi_legislative_rule(
1845: p_legislation_code);
1846:
1847: END IF;

Line 1844: := pay_emp_action_arch.get_multi_legislative_rule(

1840:
1841: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1842:
1843: pay_emp_action_arch.gv_multi_leg_rule
1844: := pay_emp_action_arch.get_multi_legislative_rule(
1845: p_legislation_code);
1846:
1847: END IF;
1848:

Line 3424: ltr_info_arch pay_emp_action_arch.action_info_table;

3420: IS
3421:
3422: lv_procedure_name VARCHAR2(100) := '.archive_action_information';
3423:
3424: ltr_info_arch pay_emp_action_arch.action_info_table;
3425:
3426: ln_index NUMBER;
3427:
3428: BEGIN

Line 3503: pay_emp_action_arch.get_org_other_info(ln_organization_id,

3499: IF c_get_organization%NOTFOUND THEN
3500: EXIT;
3501: END IF;
3502:
3503: pay_emp_action_arch.get_org_other_info(ln_organization_id,
3504: ln_business_group_id);
3505: pay_emp_action_arch.get_org_address(ln_organization_id);
3506:
3507: IF ln_business_group_id <> ln_organization_id

Line 3505: pay_emp_action_arch.get_org_address(ln_organization_id);

3501: END IF;
3502:
3503: pay_emp_action_arch.get_org_other_info(ln_organization_id,
3504: ln_business_group_id);
3505: pay_emp_action_arch.get_org_address(ln_organization_id);
3506:
3507: IF ln_business_group_id <> ln_organization_id
3508: THEN
3509:

Line 3510: pay_emp_action_arch.get_org_address(ln_business_group_id);

3506:
3507: IF ln_business_group_id <> ln_organization_id
3508: THEN
3509:
3510: pay_emp_action_arch.get_org_address(ln_business_group_id);
3511:
3512: END IF;
3513:
3514: ln_tax_unit_id := -1;

Line 3525: pay_emp_action_arch.get_org_address(ln_tax_unit_id);

3521: AND ln_tax_unit_id <> ln_business_group_id
3522: AND ln_tax_unit_id <> ln_organization_id
3523: THEN
3524:
3525: pay_emp_action_arch.get_org_address(ln_tax_unit_id);
3526:
3527: END IF;
3528:
3529: END LOOP;

Line 3533: IF pay_emp_action_arch.ltr_ppa_arch.count > 0 THEN

3529: END LOOP;
3530:
3531: CLOSE c_get_organization;
3532:
3533: IF pay_emp_action_arch.ltr_ppa_arch.count > 0 THEN
3534:
3535: pay_simulator_pkg.insert_simulation_rows(p_action_context_id => p_payroll_action_id
3536: ,p_action_context_type => 'PA'
3537: ,p_assignment_id => p_assignment_id

Line 3540: ,p_tab_rec_data => pay_emp_action_arch.ltr_ppa_arch

3536: ,p_action_context_type => 'PA'
3537: ,p_assignment_id => p_assignment_id
3538: ,p_tax_unit_id => NULL
3539: ,p_effective_date => p_effective_date
3540: ,p_tab_rec_data => pay_emp_action_arch.ltr_ppa_arch
3541: );
3542:
3543: END IF;
3544:

Line 4689: pay_emp_action_arch.get_proposed_emp_salary(p_assignment_id

4685: FETCH get_pay_basis INTO lv_pay_basis;
4686: CLOSE get_pay_basis;
4687:
4688: ln_proposed_salary :=
4689: pay_emp_action_arch.get_proposed_emp_salary(p_assignment_id
4690: ,ln_pay_basis_id
4691: ,lv_pay_basis
4692: ,ld_effective_date);
4693:

Line 4699: pay_emp_action_arch.get_emp_annualization_factor(

4695: FETCH get_period_type INTO lv_period_type;
4696: CLOSE get_period_type;
4697:
4698: ln_pay_annualization_factor :=
4699: pay_emp_action_arch.get_emp_annualization_factor(
4700: ln_pay_basis_id
4701: ,lv_period_type
4702: ,lv_pay_basis
4703: ,p_assignment_id