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_PAYROLL_API dependencies on PAY_ALL_PAYROLLS_F

Line 520: l_payroll_id pay_all_payrolls_f.payroll_id%type;

516:
517: l_effective_date date;
518: l_first_period_end_date date;
519:
520: l_payroll_id pay_all_payrolls_f.payroll_id%type;
521: l_object_version_number pay_all_payrolls_f.object_version_number%type;
522: l_effective_start_date pay_all_payrolls_f.effective_start_date%type;
523: l_effective_end_date pay_all_payrolls_f.effective_end_date%type;
524: c_eot constant date := to_date('4712/12/31','YYYY/MM/DD');

Line 521: l_object_version_number pay_all_payrolls_f.object_version_number%type;

517: l_effective_date date;
518: l_first_period_end_date date;
519:
520: l_payroll_id pay_all_payrolls_f.payroll_id%type;
521: l_object_version_number pay_all_payrolls_f.object_version_number%type;
522: l_effective_start_date pay_all_payrolls_f.effective_start_date%type;
523: l_effective_end_date pay_all_payrolls_f.effective_end_date%type;
524: c_eot constant date := to_date('4712/12/31','YYYY/MM/DD');
525: l_opm_object_version_number number;

Line 522: l_effective_start_date pay_all_payrolls_f.effective_start_date%type;

518: l_first_period_end_date date;
519:
520: l_payroll_id pay_all_payrolls_f.payroll_id%type;
521: l_object_version_number pay_all_payrolls_f.object_version_number%type;
522: l_effective_start_date pay_all_payrolls_f.effective_start_date%type;
523: l_effective_end_date pay_all_payrolls_f.effective_end_date%type;
524: c_eot constant date := to_date('4712/12/31','YYYY/MM/DD');
525: l_opm_object_version_number number;
526: l_created_by pay_all_payrolls_f.created_by%TYPE;

Line 523: l_effective_end_date pay_all_payrolls_f.effective_end_date%type;

519:
520: l_payroll_id pay_all_payrolls_f.payroll_id%type;
521: l_object_version_number pay_all_payrolls_f.object_version_number%type;
522: l_effective_start_date pay_all_payrolls_f.effective_start_date%type;
523: l_effective_end_date pay_all_payrolls_f.effective_end_date%type;
524: c_eot constant date := to_date('4712/12/31','YYYY/MM/DD');
525: l_opm_object_version_number number;
526: l_created_by pay_all_payrolls_f.created_by%TYPE;
527: l_creation_date pay_all_payrolls_f.creation_date%TYPE;

Line 526: l_created_by pay_all_payrolls_f.created_by%TYPE;

522: l_effective_start_date pay_all_payrolls_f.effective_start_date%type;
523: l_effective_end_date pay_all_payrolls_f.effective_end_date%type;
524: c_eot constant date := to_date('4712/12/31','YYYY/MM/DD');
525: l_opm_object_version_number number;
526: l_created_by pay_all_payrolls_f.created_by%TYPE;
527: l_creation_date pay_all_payrolls_f.creation_date%TYPE;
528: l_last_update_date pay_all_payrolls_f.last_update_date%TYPE := sysdate;
529: l_last_updated_by pay_all_payrolls_f.last_updated_by%TYPE := fnd_global.user_id;
530: l_last_update_login pay_all_payrolls_f.last_update_login%TYPE := fnd_global.login_id;

Line 527: l_creation_date pay_all_payrolls_f.creation_date%TYPE;

523: l_effective_end_date pay_all_payrolls_f.effective_end_date%type;
524: c_eot constant date := to_date('4712/12/31','YYYY/MM/DD');
525: l_opm_object_version_number number;
526: l_created_by pay_all_payrolls_f.created_by%TYPE;
527: l_creation_date pay_all_payrolls_f.creation_date%TYPE;
528: l_last_update_date pay_all_payrolls_f.last_update_date%TYPE := sysdate;
529: l_last_updated_by pay_all_payrolls_f.last_updated_by%TYPE := fnd_global.user_id;
530: l_last_update_login pay_all_payrolls_f.last_update_login%TYPE := fnd_global.login_id;
531: l_comment_id pay_all_payrolls_f.comment_id%TYPE := p_comment_id;

Line 528: l_last_update_date pay_all_payrolls_f.last_update_date%TYPE := sysdate;

524: c_eot constant date := to_date('4712/12/31','YYYY/MM/DD');
525: l_opm_object_version_number number;
526: l_created_by pay_all_payrolls_f.created_by%TYPE;
527: l_creation_date pay_all_payrolls_f.creation_date%TYPE;
528: l_last_update_date pay_all_payrolls_f.last_update_date%TYPE := sysdate;
529: l_last_updated_by pay_all_payrolls_f.last_updated_by%TYPE := fnd_global.user_id;
530: l_last_update_login pay_all_payrolls_f.last_update_login%TYPE := fnd_global.login_id;
531: l_comment_id pay_all_payrolls_f.comment_id%TYPE := p_comment_id;
532: l_prl_information_category pay_all_payrolls_f.prl_information_category%TYPE := null;

Line 529: l_last_updated_by pay_all_payrolls_f.last_updated_by%TYPE := fnd_global.user_id;

525: l_opm_object_version_number number;
526: l_created_by pay_all_payrolls_f.created_by%TYPE;
527: l_creation_date pay_all_payrolls_f.creation_date%TYPE;
528: l_last_update_date pay_all_payrolls_f.last_update_date%TYPE := sysdate;
529: l_last_updated_by pay_all_payrolls_f.last_updated_by%TYPE := fnd_global.user_id;
530: l_last_update_login pay_all_payrolls_f.last_update_login%TYPE := fnd_global.login_id;
531: l_comment_id pay_all_payrolls_f.comment_id%TYPE := p_comment_id;
532: l_prl_information_category pay_all_payrolls_f.prl_information_category%TYPE := null;
533: l_org_pay_method_usage_id number;

Line 530: l_last_update_login pay_all_payrolls_f.last_update_login%TYPE := fnd_global.login_id;

526: l_created_by pay_all_payrolls_f.created_by%TYPE;
527: l_creation_date pay_all_payrolls_f.creation_date%TYPE;
528: l_last_update_date pay_all_payrolls_f.last_update_date%TYPE := sysdate;
529: l_last_updated_by pay_all_payrolls_f.last_updated_by%TYPE := fnd_global.user_id;
530: l_last_update_login pay_all_payrolls_f.last_update_login%TYPE := fnd_global.login_id;
531: l_comment_id pay_all_payrolls_f.comment_id%TYPE := p_comment_id;
532: l_prl_information_category pay_all_payrolls_f.prl_information_category%TYPE := null;
533: l_org_pay_method_usage_id number;
534: l_workload_shifting_level varchar2(30) :='N';

Line 531: l_comment_id pay_all_payrolls_f.comment_id%TYPE := p_comment_id;

527: l_creation_date pay_all_payrolls_f.creation_date%TYPE;
528: l_last_update_date pay_all_payrolls_f.last_update_date%TYPE := sysdate;
529: l_last_updated_by pay_all_payrolls_f.last_updated_by%TYPE := fnd_global.user_id;
530: l_last_update_login pay_all_payrolls_f.last_update_login%TYPE := fnd_global.login_id;
531: l_comment_id pay_all_payrolls_f.comment_id%TYPE := p_comment_id;
532: l_prl_information_category pay_all_payrolls_f.prl_information_category%TYPE := null;
533: l_org_pay_method_usage_id number;
534: l_workload_shifting_level varchar2(30) :='N';
535: l_dummy number(15);

Line 532: l_prl_information_category pay_all_payrolls_f.prl_information_category%TYPE := null;

528: l_last_update_date pay_all_payrolls_f.last_update_date%TYPE := sysdate;
529: l_last_updated_by pay_all_payrolls_f.last_updated_by%TYPE := fnd_global.user_id;
530: l_last_update_login pay_all_payrolls_f.last_update_login%TYPE := fnd_global.login_id;
531: l_comment_id pay_all_payrolls_f.comment_id%TYPE := p_comment_id;
532: l_prl_information_category pay_all_payrolls_f.prl_information_category%TYPE := null;
533: l_org_pay_method_usage_id number;
534: l_workload_shifting_level varchar2(30) :='N';
535: l_dummy number(15);
536:

Line 544: l_business_group_id pay_all_payrolls_f.business_group_id%TYPE;

540:
541: l_cost_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
542: l_susp_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
543: l_scl_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
544: l_business_group_id pay_all_payrolls_f.business_group_id%TYPE;
545: l_legislation_code varchar2(150);
546:
547: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE := p_cost_concat_segments_in;
548: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE := p_susp_concat_segments_in;

Line 551: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE := p_cost_alloc_keyflex_id_in;

547: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE := p_cost_concat_segments_in;
548: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE := p_susp_concat_segments_in;
549: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE := p_scl_concat_segments_in;
550:
551: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE := p_cost_alloc_keyflex_id_in;
552: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE := p_susp_account_keyflex_id_in;
553: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE := p_soft_coding_keyflex_id_in;
554:
555:

Line 552: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE := p_susp_account_keyflex_id_in;

548: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE := p_susp_concat_segments_in;
549: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE := p_scl_concat_segments_in;
550:
551: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE := p_cost_alloc_keyflex_id_in;
552: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE := p_susp_account_keyflex_id_in;
553: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE := p_soft_coding_keyflex_id_in;
554:
555:
556: --Cursor for fetching the Cost allocation structure id from the business group.

Line 553: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE := p_soft_coding_keyflex_id_in;

549: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE := p_scl_concat_segments_in;
550:
551: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE := p_cost_alloc_keyflex_id_in;
552: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE := p_susp_account_keyflex_id_in;
553: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE := p_soft_coding_keyflex_id_in;
554:
555:
556: --Cursor for fetching the Cost allocation structure id from the business group.
557: cursor csr_cost_id_flex_num(c_business_group_id PER_BUSINESS_GROUPS_PERF.business_group_id%TYPE) is

Line 571: cursor csr_cost_alloc_exists(c_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE) is

567: where lr.legislation_code = c_legislation_code
568: and upper(lr.rule_type) = 'S';
569:
570: --Cursor for checking whether the given Cost Keyflex id is there or not
571: cursor csr_cost_alloc_exists(c_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE) is
572: select pca.cost_allocation_keyflex_id
573: from pay_cost_allocation_keyflex pca
574: where pca.cost_allocation_keyflex_id = c_cost_allocation_keyflex_id;
575:

Line 617: ,p_associated_column1 => 'PAY_ALL_PAYROLLS_F'

613: -- Validate the business group and set the CLIENT_INFO.
614: --
615: hr_api.validate_bus_grp_id
616: (p_business_group_id => l_business_group_id
617: ,p_associated_column1 => 'PAY_ALL_PAYROLLS_F'
618: || '.BUSINESS_GROUP_ID');
619:
620: --
621: --Checking whether the specified cost allocation kff ID is there.

Line 1728: l_object_version_number pay_all_payrolls_f.object_version_number%type;

1724:
1725: ) is
1726:
1727: l_effective_date date;
1728: l_object_version_number pay_all_payrolls_f.object_version_number%type;
1729: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1730: l_proc varchar2(72) := g_package||'update_payroll';
1731: l_effective_start_date pay_all_payrolls_f.effective_start_date%type;
1732: l_effective_end_date pay_all_payrolls_f.effective_end_date%type;

Line 1729: l_payroll_id pay_all_payrolls_f.payroll_id%type;

1725: ) is
1726:
1727: l_effective_date date;
1728: l_object_version_number pay_all_payrolls_f.object_version_number%type;
1729: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1730: l_proc varchar2(72) := g_package||'update_payroll';
1731: l_effective_start_date pay_all_payrolls_f.effective_start_date%type;
1732: l_effective_end_date pay_all_payrolls_f.effective_end_date%type;
1733: l_dummy number(15);

Line 1731: l_effective_start_date pay_all_payrolls_f.effective_start_date%type;

1727: l_effective_date date;
1728: l_object_version_number pay_all_payrolls_f.object_version_number%type;
1729: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1730: l_proc varchar2(72) := g_package||'update_payroll';
1731: l_effective_start_date pay_all_payrolls_f.effective_start_date%type;
1732: l_effective_end_date pay_all_payrolls_f.effective_end_date%type;
1733: l_dummy number(15);
1734: l_dummy_char varchar2(1);
1735:

Line 1732: l_effective_end_date pay_all_payrolls_f.effective_end_date%type;

1728: l_object_version_number pay_all_payrolls_f.object_version_number%type;
1729: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1730: l_proc varchar2(72) := g_package||'update_payroll';
1731: l_effective_start_date pay_all_payrolls_f.effective_start_date%type;
1732: l_effective_end_date pay_all_payrolls_f.effective_end_date%type;
1733: l_dummy number(15);
1734: l_dummy_char varchar2(1);
1735:
1736: l_cost_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 1739: l_business_group_id pay_all_payrolls_f.business_group_id%TYPE;

1735:
1736: l_cost_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
1737: l_susp_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
1738: l_scl_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
1739: l_business_group_id pay_all_payrolls_f.business_group_id%TYPE;
1740: l_prl_information_category pay_all_payrolls_f.prl_information_category%TYPE := hr_api.g_varchar2;
1741: l_legislation_code varchar2(150);
1742:
1743: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;

Line 1740: l_prl_information_category pay_all_payrolls_f.prl_information_category%TYPE := hr_api.g_varchar2;

1736: l_cost_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
1737: l_susp_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
1738: l_scl_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
1739: l_business_group_id pay_all_payrolls_f.business_group_id%TYPE;
1740: l_prl_information_category pay_all_payrolls_f.prl_information_category%TYPE := hr_api.g_varchar2;
1741: l_legislation_code varchar2(150);
1742:
1743: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
1744: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;

Line 1747: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE := p_cost_alloc_keyflex_id_in;

1743: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
1744: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
1745: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;
1746:
1747: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE := p_cost_alloc_keyflex_id_in;
1748: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE := p_susp_account_keyflex_id_in;
1749: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE := p_soft_coding_keyflex_id_in;
1750:
1751: l_cost_flag boolean := false;

Line 1748: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE := p_susp_account_keyflex_id_in;

1744: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
1745: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;
1746:
1747: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE := p_cost_alloc_keyflex_id_in;
1748: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE := p_susp_account_keyflex_id_in;
1749: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE := p_soft_coding_keyflex_id_in;
1750:
1751: l_cost_flag boolean := false;
1752: l_susp_flag boolean := false;

Line 1749: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE := p_soft_coding_keyflex_id_in;

1745: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;
1746:
1747: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE := p_cost_alloc_keyflex_id_in;
1748: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE := p_susp_account_keyflex_id_in;
1749: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE := p_soft_coding_keyflex_id_in;
1750:
1751: l_cost_flag boolean := false;
1752: l_susp_flag boolean := false;
1753: l_soft_flag boolean := false;

Line 1775: cursor csr_cost_alloc_exists(c_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE) is

1771:
1772: --
1773: --Cursor for checking whether the given Cost Keyflex id is there or not.
1774: --
1775: cursor csr_cost_alloc_exists(c_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE) is
1776: select pca.cost_allocation_keyflex_id
1777: from pay_cost_allocation_keyflex pca
1778: where pca.cost_allocation_keyflex_id = c_cost_allocation_keyflex_id;
1779:

Line 1791: cursor csr_get_bg_grp(c_payroll_id PAY_ALL_PAYROLLS_F.payroll_id%TYPE) is

1787:
1788: --
1789: --Cursor for getting the business group id from the payroll id.
1790: --
1791: cursor csr_get_bg_grp(c_payroll_id PAY_ALL_PAYROLLS_F.payroll_id%TYPE) is
1792: select prl.business_group_id
1793: from PAY_ALL_PAYROLLS_F prl
1794: where prl.payroll_id = c_payroll_id
1795: and trunc(p_effective_date)

Line 1793: from PAY_ALL_PAYROLLS_F prl

1789: --Cursor for getting the business group id from the payroll id.
1790: --
1791: cursor csr_get_bg_grp(c_payroll_id PAY_ALL_PAYROLLS_F.payroll_id%TYPE) is
1792: select prl.business_group_id
1793: from PAY_ALL_PAYROLLS_F prl
1794: where prl.payroll_id = c_payroll_id
1795: and trunc(p_effective_date)
1796: between prl.effective_start_date and prl.effective_end_date;
1797:

Line 1803: from pay_all_payrolls_f prl

1799: --Cursor for checking the payroll is valid or not
1800: --
1801: cursor csr_chk_payroll is
1802: select null
1803: from pay_all_payrolls_f prl
1804: where prl.payroll_id = p_payroll_id
1805: and trunc(p_effective_date)
1806: between prl.effective_start_date and prl.effective_end_date;
1807:

Line 1809: --Cursor for getting the cost allocation keyflex id from the PAY_ALL_PAYROLLS_F

1805: and trunc(p_effective_date)
1806: between prl.effective_start_date and prl.effective_end_date;
1807:
1808: --
1809: --Cursor for getting the cost allocation keyflex id from the PAY_ALL_PAYROLLS_F
1810: --
1811: cursor csr_get_costKFF is
1812: select cost_allocation_keyflex_id
1813: from PAY_ALL_PAYROLLS_F prl

Line 1813: from PAY_ALL_PAYROLLS_F prl

1809: --Cursor for getting the cost allocation keyflex id from the PAY_ALL_PAYROLLS_F
1810: --
1811: cursor csr_get_costKFF is
1812: select cost_allocation_keyflex_id
1813: from PAY_ALL_PAYROLLS_F prl
1814: where prl.payroll_id = p_payroll_id
1815: and trunc(p_effective_date)
1816: between prl.effective_start_date and prl.effective_end_date;
1817:

Line 1819: --Cursor for getting the suspense account keyflex id from the PAY_ALL_PAYROLLS_F

1815: and trunc(p_effective_date)
1816: between prl.effective_start_date and prl.effective_end_date;
1817:
1818: --
1819: --Cursor for getting the suspense account keyflex id from the PAY_ALL_PAYROLLS_F
1820: --
1821: cursor csr_get_suspenseKFF is
1822: select suspense_account_keyflex_id
1823: from PAY_ALL_PAYROLLS_F prl

Line 1823: from PAY_ALL_PAYROLLS_F prl

1819: --Cursor for getting the suspense account keyflex id from the PAY_ALL_PAYROLLS_F
1820: --
1821: cursor csr_get_suspenseKFF is
1822: select suspense_account_keyflex_id
1823: from PAY_ALL_PAYROLLS_F prl
1824: where prl.payroll_id = p_payroll_id
1825: and trunc(p_effective_date)
1826: between prl.effective_start_date and prl.effective_end_date;
1827:

Line 1829: --Cursor for getting the soft coding keyflex id from the PAY_ALL_PAYROLLS_F

1825: and trunc(p_effective_date)
1826: between prl.effective_start_date and prl.effective_end_date;
1827:
1828: --
1829: --Cursor for getting the soft coding keyflex id from the PAY_ALL_PAYROLLS_F
1830: --
1831: cursor csr_get_softKFF is
1832: select soft_coding_keyflex_id
1833: from PAY_ALL_PAYROLLS_F prl

Line 1833: from PAY_ALL_PAYROLLS_F prl

1829: --Cursor for getting the soft coding keyflex id from the PAY_ALL_PAYROLLS_F
1830: --
1831: cursor csr_get_softKFF is
1832: select soft_coding_keyflex_id
1833: from PAY_ALL_PAYROLLS_F prl
1834: where prl.payroll_id = p_payroll_id
1835: and trunc(p_effective_date)
1836: between prl.effective_start_date and prl.effective_end_date;
1837:

Line 1890: ,p_associated_column1 => 'PAY_ALL_PAYROLLS_F'

1886: -- Validate the business group id.
1887: --
1888: hr_api.validate_bus_grp_id
1889: (p_business_group_id => L_business_group_id
1890: ,p_associated_column1 => 'PAY_ALL_PAYROLLS_F'
1891: || '.BUSINESS_GROUP_ID');
1892:
1893: hr_multi_message.end_validation_set;
1894:

Line 2802: l_object_version_number pay_all_payrolls_f.object_version_number%type;

2798: p_effective_end_date out nocopy date
2799: ) is
2800:
2801: l_effective_date date;
2802: l_object_version_number pay_all_payrolls_f.object_version_number%type;
2803: l_effective_start_date pay_all_payrolls_f.effective_start_date%TYPE;
2804: l_effective_end_date pay_all_payrolls_f.effective_end_date%TYPE;
2805: l_proc varchar2(72) := g_package||'delete_payroll';
2806:

Line 2803: l_effective_start_date pay_all_payrolls_f.effective_start_date%TYPE;

2799: ) is
2800:
2801: l_effective_date date;
2802: l_object_version_number pay_all_payrolls_f.object_version_number%type;
2803: l_effective_start_date pay_all_payrolls_f.effective_start_date%TYPE;
2804: l_effective_end_date pay_all_payrolls_f.effective_end_date%TYPE;
2805: l_proc varchar2(72) := g_package||'delete_payroll';
2806:
2807: begin

Line 2804: l_effective_end_date pay_all_payrolls_f.effective_end_date%TYPE;

2800:
2801: l_effective_date date;
2802: l_object_version_number pay_all_payrolls_f.object_version_number%type;
2803: l_effective_start_date pay_all_payrolls_f.effective_start_date%TYPE;
2804: l_effective_end_date pay_all_payrolls_f.effective_end_date%TYPE;
2805: l_proc varchar2(72) := g_package||'delete_payroll';
2806:
2807: begin
2808: --

Line 3006: l_business_group_id PAY_ALL_PAYROLLS_F.business_group_id%TYPE;

3002: l_opm_effective_start_date date;
3003: l_opm_effective_end_date date;
3004: l_comment_id number;
3005:
3006: l_business_group_id PAY_ALL_PAYROLLS_F.business_group_id%TYPE;
3007: l_legislation_code varchar2(150);
3008:
3009: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;
3010: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;

Line 3009: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;

3005:
3006: l_business_group_id PAY_ALL_PAYROLLS_F.business_group_id%TYPE;
3007: l_legislation_code varchar2(150);
3008:
3009: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;
3010: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;
3011: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;
3012:
3013: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;

Line 3010: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;

3006: l_business_group_id PAY_ALL_PAYROLLS_F.business_group_id%TYPE;
3007: l_legislation_code varchar2(150);
3008:
3009: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;
3010: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;
3011: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;
3012:
3013: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
3014: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;

Line 3011: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;

3007: l_legislation_code varchar2(150);
3008:
3009: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;
3010: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;
3011: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;
3012:
3013: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
3014: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
3015: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;

Line 3222: l_payroll_id PAY_ALL_PAYROLLS_F.payroll_id%TYPE := p_payroll_id;

3218: ) is
3219: --
3220: l_proc varchar2(72) := g_package||'update_payroll';
3221:
3222: l_payroll_id PAY_ALL_PAYROLLS_F.payroll_id%TYPE := p_payroll_id;
3223: l_object_version_number PAY_ALL_PAYROLLS_F.object_version_number%TYPE := p_object_version_number;
3224: l_prl_effective_start_date date;
3225: l_prl_effective_end_date date;
3226: l_comment_id number;

Line 3223: l_object_version_number PAY_ALL_PAYROLLS_F.object_version_number%TYPE := p_object_version_number;

3219: --
3220: l_proc varchar2(72) := g_package||'update_payroll';
3221:
3222: l_payroll_id PAY_ALL_PAYROLLS_F.payroll_id%TYPE := p_payroll_id;
3223: l_object_version_number PAY_ALL_PAYROLLS_F.object_version_number%TYPE := p_object_version_number;
3224: l_prl_effective_start_date date;
3225: l_prl_effective_end_date date;
3226: l_comment_id number;
3227:

Line 3228: l_business_group_id PAY_ALL_PAYROLLS_F.business_group_id%TYPE;

3224: l_prl_effective_start_date date;
3225: l_prl_effective_end_date date;
3226: l_comment_id number;
3227:
3228: l_business_group_id PAY_ALL_PAYROLLS_F.business_group_id%TYPE;
3229: l_legislation_code varchar2(150);
3230:
3231: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;
3232: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;

Line 3231: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;

3227:
3228: l_business_group_id PAY_ALL_PAYROLLS_F.business_group_id%TYPE;
3229: l_legislation_code varchar2(150);
3230:
3231: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;
3232: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;
3233: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;
3234:
3235: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;

Line 3232: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;

3228: l_business_group_id PAY_ALL_PAYROLLS_F.business_group_id%TYPE;
3229: l_legislation_code varchar2(150);
3230:
3231: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;
3232: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;
3233: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;
3234:
3235: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
3236: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;

Line 3233: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;

3229: l_legislation_code varchar2(150);
3230:
3231: l_cost_allocation_keyflex_id PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID%TYPE ;
3232: l_suspense_account_keyflex_id PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID%TYPE ;
3233: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE ;
3234:
3235: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
3236: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
3237: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;

Line 3241: from PAY_ALL_PAYROLLS_F

3237: l_scl_concat_segments HR_SOFT_CODING_KEYFLEX.concatenated_segments%TYPE;
3238:
3239: cursor csr_get_BG is
3240: select business_group_id
3241: from PAY_ALL_PAYROLLS_F
3242: where payroll_id = p_payroll_id;
3243: begin
3244: --
3245: hr_utility.set_location('Entering:'||l_proc, 5);