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_ELEMENT_TEMPLATE_GEN dependencies on PAY_ELEMENT_TEMPLATE_UTIL

Line 589: (p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects

585: -- ----------------------------------------------------------------------------
586: -- |------------------------< flush_generation_tables >-----------------------|
587: -- ----------------------------------------------------------------------------
588: procedure flush_generation_tables
589: (p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects
590: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
591: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
592: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
593: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 590: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects

586: -- |------------------------< flush_generation_tables >-----------------------|
587: -- ----------------------------------------------------------------------------
588: procedure flush_generation_tables
589: (p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects
590: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
591: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
592: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
593: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
594: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 591: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects

587: -- ----------------------------------------------------------------------------
588: procedure flush_generation_tables
589: (p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects
590: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
591: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
592: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
593: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
594: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
595: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 592: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects

588: procedure flush_generation_tables
589: (p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects
590: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
591: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
592: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
593: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
594: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
595: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
596: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 593: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects

589: (p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects
590: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
591: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
592: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
593: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
594: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
595: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
596: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
597: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 594: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects

590: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
591: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
592: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
593: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
594: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
595: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
596: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
597: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
598: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 595: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects

591: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
592: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
593: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
594: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
595: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
596: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
597: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
598: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
599: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 596: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects

592: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
593: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
594: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
595: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
596: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
597: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
598: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
599: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
600: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 597: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects

593: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
594: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
595: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
596: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
597: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
598: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
599: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
600: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
601: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 598: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects

594: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
595: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
596: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
597: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
598: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
599: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
600: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
601: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
602: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 599: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects

595: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
596: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
597: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
598: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
599: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
600: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
601: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
602: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects
603: ) is

Line 600: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects

596: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
597: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
598: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
599: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
600: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
601: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
602: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects
603: ) is
604: l_proc varchar2(72) := g_package||'flush_generation_tables';

Line 601: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects

597: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
598: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
599: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
600: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
601: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
602: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects
603: ) is
604: l_proc varchar2(72) := g_package||'flush_generation_tables';
605: begin

Line 602: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects

598: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
599: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
600: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
601: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
602: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects
603: ) is
604: l_proc varchar2(72) := g_package||'flush_generation_tables';
605: begin
606: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 627: (p_all_core_objects in pay_element_template_util.t_core_objects

623: -- ----------------------------------------------------------------------------
624: -- |----------------------< create_generation_tables >------------------------|
625: -- ----------------------------------------------------------------------------
626: procedure create_generation_tables
627: (p_all_core_objects in pay_element_template_util.t_core_objects
628: ,p_index_by_core_object_id in boolean default false
629: ,p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects
630: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
631: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 629: ,p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects

625: -- ----------------------------------------------------------------------------
626: procedure create_generation_tables
627: (p_all_core_objects in pay_element_template_util.t_core_objects
628: ,p_index_by_core_object_id in boolean default false
629: ,p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects
630: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
631: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
632: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
633: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 630: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects

626: procedure create_generation_tables
627: (p_all_core_objects in pay_element_template_util.t_core_objects
628: ,p_index_by_core_object_id in boolean default false
629: ,p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects
630: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
631: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
632: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
633: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
634: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 631: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects

627: (p_all_core_objects in pay_element_template_util.t_core_objects
628: ,p_index_by_core_object_id in boolean default false
629: ,p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects
630: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
631: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
632: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
633: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
634: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
635: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 632: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects

628: ,p_index_by_core_object_id in boolean default false
629: ,p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects
630: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
631: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
632: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
633: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
634: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
635: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
636: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 633: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects

629: ,p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects
630: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
631: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
632: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
633: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
634: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
635: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
636: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
637: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 634: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects

630: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
631: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
632: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
633: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
634: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
635: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
636: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
637: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
638: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 635: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects

631: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
632: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
633: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
634: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
635: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
636: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
637: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
638: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
639: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 636: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects

632: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
633: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
634: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
635: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
636: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
637: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
638: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
639: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
640: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 637: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects

633: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
634: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
635: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
636: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
637: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
638: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
639: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
640: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
641: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 638: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects

634: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
635: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
636: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
637: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
638: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
639: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
640: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
641: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
642: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 639: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects

635: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
636: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
637: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
638: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
639: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
640: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
641: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
642: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects
643: ) is

Line 640: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects

636: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
637: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
638: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
639: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
640: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
641: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
642: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects
643: ) is
644: l_proc varchar2(72) := g_package||'create_generation_tables';

Line 641: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects

637: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
638: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
639: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
640: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
641: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
642: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects
643: ) is
644: l_proc varchar2(72) := g_package||'create_generation_tables';
645: i number;

Line 642: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects

638: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
639: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
640: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
641: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
642: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects
643: ) is
644: l_proc varchar2(72) := g_package||'create_generation_tables';
645: i number;
646: l_index number;

Line 727: ,p_core_objects in pay_element_template_util.t_core_objects

723: -- ----------------------------------------------------------------------------
724: function core_object_exists
725: (p_shadow_object_id in number
726: ,p_object_type in varchar2
727: ,p_core_objects in pay_element_template_util.t_core_objects
728: ) return boolean is
729: l_proc varchar2(72) := g_package||'core_object_exists';
730: l_core_object_id number;
731: l_count number;

Line 978: ,p_core_objects in out nocopy pay_element_template_util.t_core_objects

974: ,p_template_id in number
975: ,p_core_object_type in varchar2
976: ,p_shadow_object_id in number
977: ,p_core_object_id in number
978: ,p_core_objects in out nocopy pay_element_template_util.t_core_objects
979: ) is
980: l_proc varchar2(72) := g_package||'update_core_objects';
981: l_core_object pay_tco_shd.g_rec_type;
982: begin

Line 1008: ,p_all_core_objects in pay_element_template_util.t_core_objects

1004: -- |---------------------------< new_core_object >----------------------------|
1005: -- ----------------------------------------------------------------------------
1006: function new_core_object
1007: (p_core_object in pay_tco_shd.g_rec_type
1008: ,p_all_core_objects in pay_element_template_util.t_core_objects
1009: ) return boolean is
1010: l_proc varchar2(72) := g_package||'new_core_object';
1011: l_template_core_object_id number;
1012: begin

Line 1024: ,p_formulas in pay_element_template_util.t_formulas

1020: procedure gen_formulas
1021: (p_effective_date in date
1022: ,p_template_id in number
1023: ,p_hr_only in boolean
1024: ,p_formulas in pay_element_template_util.t_formulas
1025: ,p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects
1026: ) is
1027: l_proc varchar2(72) := g_package||'gen_formulas';
1028: l_shadow_object_id number;

Line 1025: ,p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects

1021: (p_effective_date in date
1022: ,p_template_id in number
1023: ,p_hr_only in boolean
1024: ,p_formulas in pay_element_template_util.t_formulas
1025: ,p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects
1026: ) is
1027: l_proc varchar2(72) := g_package||'gen_formulas';
1028: l_shadow_object_id number;
1029: i number;

Line 1126: ,p_balance_types in pay_element_template_util.t_balance_types

1122: ,p_template_id in number
1123: ,p_business_group_id in number
1124: ,p_legislation_code in varchar2
1125: ,p_balance_type_id in number
1126: ,p_balance_types in pay_element_template_util.t_balance_types
1127: ,p_siv_core_objects in pay_element_template_util.t_core_objects
1128: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
1129: ) is
1130: l_proc varchar2(72) := g_package||'gen_balance_type';

Line 1127: ,p_siv_core_objects in pay_element_template_util.t_core_objects

1123: ,p_business_group_id in number
1124: ,p_legislation_code in varchar2
1125: ,p_balance_type_id in number
1126: ,p_balance_types in pay_element_template_util.t_balance_types
1127: ,p_siv_core_objects in pay_element_template_util.t_core_objects
1128: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
1129: ) is
1130: l_proc varchar2(72) := g_package||'gen_balance_type';
1131: l_rowid varchar2(128);

Line 1128: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects

1124: ,p_legislation_code in varchar2
1125: ,p_balance_type_id in number
1126: ,p_balance_types in pay_element_template_util.t_balance_types
1127: ,p_siv_core_objects in pay_element_template_util.t_core_objects
1128: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
1129: ) is
1130: l_proc varchar2(72) := g_package||'gen_balance_type';
1131: l_rowid varchar2(128);
1132: l_balance_type_id number;

Line 1284: ,p_balance_types in pay_element_template_util.t_balance_types

1280: (p_effective_date in date
1281: ,p_template_id in number
1282: ,p_business_group_id in number
1283: ,p_legislation_code in varchar2
1284: ,p_balance_types in pay_element_template_util.t_balance_types
1285: ,p_siv_core_objects in pay_element_template_util.t_core_objects
1286: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
1287: ) is
1288: l_proc varchar2(72) := g_package||'gen_balance_types';

Line 1285: ,p_siv_core_objects in pay_element_template_util.t_core_objects

1281: ,p_template_id in number
1282: ,p_business_group_id in number
1283: ,p_legislation_code in varchar2
1284: ,p_balance_types in pay_element_template_util.t_balance_types
1285: ,p_siv_core_objects in pay_element_template_util.t_core_objects
1286: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
1287: ) is
1288: l_proc varchar2(72) := g_package||'gen_balance_types';
1289: i number;

Line 1286: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects

1282: ,p_business_group_id in number
1283: ,p_legislation_code in varchar2
1284: ,p_balance_types in pay_element_template_util.t_balance_types
1285: ,p_siv_core_objects in pay_element_template_util.t_core_objects
1286: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
1287: ) is
1288: l_proc varchar2(72) := g_package||'gen_balance_types';
1289: i number;
1290: --

Line 1322: ,p_defined_balances in pay_element_template_util.t_defined_balances

1318: (p_effective_date in date
1319: ,p_template_id in number
1320: ,p_business_group_id in number
1321: ,p_legislation_code in varchar2
1322: ,p_defined_balances in pay_element_template_util.t_defined_balances
1323: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
1324: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
1325: ) is
1326: l_proc varchar2(72) := g_package||'gen_defined_balances';

Line 1323: ,p_sbt_core_objects in pay_element_template_util.t_core_objects

1319: ,p_template_id in number
1320: ,p_business_group_id in number
1321: ,p_legislation_code in varchar2
1322: ,p_defined_balances in pay_element_template_util.t_defined_balances
1323: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
1324: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
1325: ) is
1326: l_proc varchar2(72) := g_package||'gen_defined_balances';
1327: l_shadow_object_id number;

Line 1324: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects

1320: ,p_business_group_id in number
1321: ,p_legislation_code in varchar2
1322: ,p_defined_balances in pay_element_template_util.t_defined_balances
1323: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
1324: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
1325: ) is
1326: l_proc varchar2(72) := g_package||'gen_defined_balances';
1327: l_shadow_object_id number;
1328: i number;

Line 1418: ,p_element_types in pay_element_template_util.t_element_types

1414: ,p_business_group_id in number
1415: ,p_hr_only in boolean
1416: ,p_legislation_code in varchar2
1417: ,p_base_processing_priority in number
1418: ,p_element_types in pay_element_template_util.t_element_types
1419: ,p_sf_core_objects in pay_element_template_util.t_core_objects
1420: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
1421: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
1422: ) is

Line 1419: ,p_sf_core_objects in pay_element_template_util.t_core_objects

1415: ,p_hr_only in boolean
1416: ,p_legislation_code in varchar2
1417: ,p_base_processing_priority in number
1418: ,p_element_types in pay_element_template_util.t_element_types
1419: ,p_sf_core_objects in pay_element_template_util.t_core_objects
1420: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
1421: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
1422: ) is
1423: l_proc varchar2(72) := g_package||'gen_element_types';

Line 1420: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects

1416: ,p_legislation_code in varchar2
1417: ,p_base_processing_priority in number
1418: ,p_element_types in pay_element_template_util.t_element_types
1419: ,p_sf_core_objects in pay_element_template_util.t_core_objects
1420: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
1421: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
1422: ) is
1423: l_proc varchar2(72) := g_package||'gen_element_types';
1424: l_shadow_object_id number;

Line 1421: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects

1417: ,p_base_processing_priority in number
1418: ,p_element_types in pay_element_template_util.t_element_types
1419: ,p_sf_core_objects in pay_element_template_util.t_core_objects
1420: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
1421: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
1422: ) is
1423: l_proc varchar2(72) := g_package||'gen_element_types';
1424: l_shadow_object_id number;
1425: i number;

Line 1763: ,p_all_core_objects in pay_element_template_util.t_core_objects

1759: (p_effective_date in date
1760: ,p_template_id in number
1761: ,p_business_group_id in number
1762: ,p_legislation_code in varchar2
1763: ,p_all_core_objects in pay_element_template_util.t_core_objects
1764: ,p_set_core_objects in pay_element_template_util.t_core_objects
1765: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules
1766: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
1767: ) is

Line 1764: ,p_set_core_objects in pay_element_template_util.t_core_objects

1760: ,p_template_id in number
1761: ,p_business_group_id in number
1762: ,p_legislation_code in varchar2
1763: ,p_all_core_objects in pay_element_template_util.t_core_objects
1764: ,p_set_core_objects in pay_element_template_util.t_core_objects
1765: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules
1766: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
1767: ) is
1768: l_proc varchar2(72) := g_package||'implicit_sub_classi_rules';

Line 1765: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules

1761: ,p_business_group_id in number
1762: ,p_legislation_code in varchar2
1763: ,p_all_core_objects in pay_element_template_util.t_core_objects
1764: ,p_set_core_objects in pay_element_template_util.t_core_objects
1765: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules
1766: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
1767: ) is
1768: l_proc varchar2(72) := g_package||'implicit_sub_classi_rules';
1769: i number;

Line 1766: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects

1762: ,p_legislation_code in varchar2
1763: ,p_all_core_objects in pay_element_template_util.t_core_objects
1764: ,p_set_core_objects in pay_element_template_util.t_core_objects
1765: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules
1766: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
1767: ) is
1768: l_proc varchar2(72) := g_package||'implicit_sub_classi_rules';
1769: i number;
1770: l_shadow_object_id number;

Line 1860: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules

1856: (p_effective_date in date
1857: ,p_template_id in number
1858: ,p_business_group_id in number
1859: ,p_legislation_code in varchar2
1860: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules
1861: ,p_set_core_objects in pay_element_template_util.t_core_objects
1862: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
1863: ) is
1864: l_proc varchar2(72) := g_package||'gen_sub_classi_rules';

Line 1861: ,p_set_core_objects in pay_element_template_util.t_core_objects

1857: ,p_template_id in number
1858: ,p_business_group_id in number
1859: ,p_legislation_code in varchar2
1860: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules
1861: ,p_set_core_objects in pay_element_template_util.t_core_objects
1862: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
1863: ) is
1864: l_proc varchar2(72) := g_package||'gen_sub_classi_rules';
1865: l_shadow_object_id number;

Line 1862: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects

1858: ,p_business_group_id in number
1859: ,p_legislation_code in varchar2
1860: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules
1861: ,p_set_core_objects in pay_element_template_util.t_core_objects
1862: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
1863: ) is
1864: l_proc varchar2(72) := g_package||'gen_sub_classi_rules';
1865: l_shadow_object_id number;
1866: i number;

Line 1956: ,p_balance_classis in pay_element_template_util.t_balance_classis

1952: (p_effective_date in date
1953: ,p_template_id in number
1954: ,p_business_group_id in number
1955: ,p_legislation_code in varchar2
1956: ,p_balance_classis in pay_element_template_util.t_balance_classis
1957: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
1958: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
1959: ) is
1960: l_proc varchar2(72) := g_package||'gen_balance_classis';

Line 1957: ,p_sbt_core_objects in pay_element_template_util.t_core_objects

1953: ,p_template_id in number
1954: ,p_business_group_id in number
1955: ,p_legislation_code in varchar2
1956: ,p_balance_classis in pay_element_template_util.t_balance_classis
1957: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
1958: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
1959: ) is
1960: l_proc varchar2(72) := g_package||'gen_balance_classis';
1961: l_shadow_object_id number;

Line 1958: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects

1954: ,p_business_group_id in number
1955: ,p_legislation_code in varchar2
1956: ,p_balance_classis in pay_element_template_util.t_balance_classis
1957: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
1958: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
1959: ) is
1960: l_proc varchar2(72) := g_package||'gen_balance_classis';
1961: l_shadow_object_id number;
1962: i number;

Line 2044: ,p_all_core_objects in pay_element_template_util.t_core_objects

2040: -- ----------------------------------------------------------------------------
2041: procedure implicit_input_values
2042: (p_effective_date in date
2043: ,p_template_id in number
2044: ,p_all_core_objects in pay_element_template_util.t_core_objects
2045: ,p_set_core_objects in pay_element_template_util.t_core_objects
2046: ,p_input_values in pay_element_template_util.t_input_values
2047: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
2048: ) is

Line 2045: ,p_set_core_objects in pay_element_template_util.t_core_objects

2041: procedure implicit_input_values
2042: (p_effective_date in date
2043: ,p_template_id in number
2044: ,p_all_core_objects in pay_element_template_util.t_core_objects
2045: ,p_set_core_objects in pay_element_template_util.t_core_objects
2046: ,p_input_values in pay_element_template_util.t_input_values
2047: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
2048: ) is
2049: l_proc varchar2(72) := g_package||'implicit_input_values';

Line 2046: ,p_input_values in pay_element_template_util.t_input_values

2042: (p_effective_date in date
2043: ,p_template_id in number
2044: ,p_all_core_objects in pay_element_template_util.t_core_objects
2045: ,p_set_core_objects in pay_element_template_util.t_core_objects
2046: ,p_input_values in pay_element_template_util.t_input_values
2047: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
2048: ) is
2049: l_proc varchar2(72) := g_package||'implicit_input_values';
2050: i number;

Line 2047: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects

2043: ,p_template_id in number
2044: ,p_all_core_objects in pay_element_template_util.t_core_objects
2045: ,p_set_core_objects in pay_element_template_util.t_core_objects
2046: ,p_input_values in pay_element_template_util.t_input_values
2047: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
2048: ) is
2049: l_proc varchar2(72) := g_package||'implicit_input_values';
2050: i number;
2051: l_shadow_element_type_id number;

Line 2182: ,p_input_values in pay_element_template_util.t_input_values

2178: (p_effective_date in date
2179: ,p_template_id in number
2180: ,p_business_group_id in number
2181: ,p_legislation_code in varchar2
2182: ,p_input_values in pay_element_template_util.t_input_values
2183: ,p_set_core_objects in pay_element_template_util.t_core_objects
2184: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2185: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
2186: ) is

Line 2183: ,p_set_core_objects in pay_element_template_util.t_core_objects

2179: ,p_template_id in number
2180: ,p_business_group_id in number
2181: ,p_legislation_code in varchar2
2182: ,p_input_values in pay_element_template_util.t_input_values
2183: ,p_set_core_objects in pay_element_template_util.t_core_objects
2184: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2185: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
2186: ) is
2187: l_proc varchar2(72) := g_package||'gen_input_values';

Line 2184: ,p_sf_core_objects in pay_element_template_util.t_core_objects

2180: ,p_business_group_id in number
2181: ,p_legislation_code in varchar2
2182: ,p_input_values in pay_element_template_util.t_input_values
2183: ,p_set_core_objects in pay_element_template_util.t_core_objects
2184: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2185: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
2186: ) is
2187: l_proc varchar2(72) := g_package||'gen_input_values';
2188: l_shadow_object_id number;

Line 2185: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects

2181: ,p_legislation_code in varchar2
2182: ,p_input_values in pay_element_template_util.t_input_values
2183: ,p_set_core_objects in pay_element_template_util.t_core_objects
2184: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2185: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
2186: ) is
2187: l_proc varchar2(72) := g_package||'gen_input_values';
2188: l_shadow_object_id number;
2189: i number;

Line 2310: ,p_balance_feeds in pay_element_template_util.t_balance_feeds

2306: (p_effective_date in date
2307: ,p_template_id in number
2308: ,p_business_group_id in number
2309: ,p_legislation_code in varchar2
2310: ,p_balance_feeds in pay_element_template_util.t_balance_feeds
2311: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
2312: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2313: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
2314: ) is

Line 2311: ,p_sbt_core_objects in pay_element_template_util.t_core_objects

2307: ,p_template_id in number
2308: ,p_business_group_id in number
2309: ,p_legislation_code in varchar2
2310: ,p_balance_feeds in pay_element_template_util.t_balance_feeds
2311: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
2312: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2313: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
2314: ) is
2315: l_proc varchar2(72) := g_package||'gen_balance_feeds';

Line 2312: ,p_siv_core_objects in pay_element_template_util.t_core_objects

2308: ,p_business_group_id in number
2309: ,p_legislation_code in varchar2
2310: ,p_balance_feeds in pay_element_template_util.t_balance_feeds
2311: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
2312: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2313: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
2314: ) is
2315: l_proc varchar2(72) := g_package||'gen_balance_feeds';
2316: l_shadow_object_id number;

Line 2313: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects

2309: ,p_legislation_code in varchar2
2310: ,p_balance_feeds in pay_element_template_util.t_balance_feeds
2311: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
2312: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2313: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
2314: ) is
2315: l_proc varchar2(72) := g_package||'gen_balance_feeds';
2316: l_shadow_object_id number;
2317: i number;

Line 2437: ,p_formula_rules in pay_element_template_util.t_formula_rules

2433: (p_effective_date in date
2434: ,p_template_id in number
2435: ,p_business_group_id in number
2436: ,p_legislation_code in varchar2
2437: ,p_formula_rules in pay_element_template_util.t_formula_rules
2438: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2439: ,p_set_core_objects in pay_element_template_util.t_core_objects
2440: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2441: ,p_spr_core_objects in pay_element_template_util.t_core_objects

Line 2438: ,p_sf_core_objects in pay_element_template_util.t_core_objects

2434: ,p_template_id in number
2435: ,p_business_group_id in number
2436: ,p_legislation_code in varchar2
2437: ,p_formula_rules in pay_element_template_util.t_formula_rules
2438: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2439: ,p_set_core_objects in pay_element_template_util.t_core_objects
2440: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2441: ,p_spr_core_objects in pay_element_template_util.t_core_objects
2442: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 2439: ,p_set_core_objects in pay_element_template_util.t_core_objects

2435: ,p_business_group_id in number
2436: ,p_legislation_code in varchar2
2437: ,p_formula_rules in pay_element_template_util.t_formula_rules
2438: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2439: ,p_set_core_objects in pay_element_template_util.t_core_objects
2440: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2441: ,p_spr_core_objects in pay_element_template_util.t_core_objects
2442: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
2443: ) is

Line 2440: ,p_siv_core_objects in pay_element_template_util.t_core_objects

2436: ,p_legislation_code in varchar2
2437: ,p_formula_rules in pay_element_template_util.t_formula_rules
2438: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2439: ,p_set_core_objects in pay_element_template_util.t_core_objects
2440: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2441: ,p_spr_core_objects in pay_element_template_util.t_core_objects
2442: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
2443: ) is
2444: l_proc varchar2(72) := g_package||'gen_formula_rules';

Line 2441: ,p_spr_core_objects in pay_element_template_util.t_core_objects

2437: ,p_formula_rules in pay_element_template_util.t_formula_rules
2438: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2439: ,p_set_core_objects in pay_element_template_util.t_core_objects
2440: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2441: ,p_spr_core_objects in pay_element_template_util.t_core_objects
2442: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
2443: ) is
2444: l_proc varchar2(72) := g_package||'gen_formula_rules';
2445: l_shadow_object_id number;

Line 2442: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects

2438: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2439: ,p_set_core_objects in pay_element_template_util.t_core_objects
2440: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2441: ,p_spr_core_objects in pay_element_template_util.t_core_objects
2442: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
2443: ) is
2444: l_proc varchar2(72) := g_package||'gen_formula_rules';
2445: l_shadow_object_id number;
2446: i number;

Line 2588: ,p_iterative_rules in pay_element_template_util.t_iterative_rules

2584: procedure gen_iterative_rules
2585: (p_effective_date in date
2586: ,p_template_id in number
2587: ,p_business_group_id in number
2588: ,p_iterative_rules in pay_element_template_util.t_iterative_rules
2589: ,p_set_core_objects in pay_element_template_util.t_core_objects
2590: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2591: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
2592: ) is

Line 2589: ,p_set_core_objects in pay_element_template_util.t_core_objects

2585: (p_effective_date in date
2586: ,p_template_id in number
2587: ,p_business_group_id in number
2588: ,p_iterative_rules in pay_element_template_util.t_iterative_rules
2589: ,p_set_core_objects in pay_element_template_util.t_core_objects
2590: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2591: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
2592: ) is
2593: l_proc varchar2(72) := g_package||'gen_iterative_rules';

Line 2590: ,p_siv_core_objects in pay_element_template_util.t_core_objects

2586: ,p_template_id in number
2587: ,p_business_group_id in number
2588: ,p_iterative_rules in pay_element_template_util.t_iterative_rules
2589: ,p_set_core_objects in pay_element_template_util.t_core_objects
2590: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2591: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
2592: ) is
2593: l_proc varchar2(72) := g_package||'gen_iterative_rules';
2594: l_shadow_object_id number;

Line 2591: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects

2587: ,p_business_group_id in number
2588: ,p_iterative_rules in pay_element_template_util.t_iterative_rules
2589: ,p_set_core_objects in pay_element_template_util.t_core_objects
2590: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2591: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
2592: ) is
2593: l_proc varchar2(72) := g_package||'gen_iterative_rules';
2594: l_shadow_object_id number;
2595: i number;

Line 2712: ,p_ele_type_usages in pay_element_template_util.t_ele_type_usages

2708: (p_effective_date in date
2709: ,p_template_id in number
2710: ,p_business_group_id in number
2711: ,p_legislation_code in varchar2
2712: ,p_ele_type_usages in pay_element_template_util.t_ele_type_usages
2713: ,p_set_core_objects in pay_element_template_util.t_core_objects
2714: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
2715: ) is
2716: l_proc varchar2(72) := g_package||'gen_ele_type_usages';

Line 2713: ,p_set_core_objects in pay_element_template_util.t_core_objects

2709: ,p_template_id in number
2710: ,p_business_group_id in number
2711: ,p_legislation_code in varchar2
2712: ,p_ele_type_usages in pay_element_template_util.t_ele_type_usages
2713: ,p_set_core_objects in pay_element_template_util.t_core_objects
2714: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
2715: ) is
2716: l_proc varchar2(72) := g_package||'gen_ele_type_usages';
2717: l_shadow_object_id number;

Line 2714: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects

2710: ,p_business_group_id in number
2711: ,p_legislation_code in varchar2
2712: ,p_ele_type_usages in pay_element_template_util.t_ele_type_usages
2713: ,p_set_core_objects in pay_element_template_util.t_core_objects
2714: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
2715: ) is
2716: l_proc varchar2(72) := g_package||'gen_ele_type_usages';
2717: l_shadow_object_id number;
2718: i number;

Line 2808: ,p_gu_bal_exclusions in pay_element_template_util.t_gu_bal_exclusions

2804: (p_effective_date in date
2805: ,p_template_id in number
2806: ,p_business_group_id in number
2807: ,p_legislation_code in varchar2
2808: ,p_gu_bal_exclusions in pay_element_template_util.t_gu_bal_exclusions
2809: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
2810: ,p_set_core_objects in pay_element_template_util.t_core_objects
2811: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
2812: ) is

Line 2809: ,p_sbt_core_objects in pay_element_template_util.t_core_objects

2805: ,p_template_id in number
2806: ,p_business_group_id in number
2807: ,p_legislation_code in varchar2
2808: ,p_gu_bal_exclusions in pay_element_template_util.t_gu_bal_exclusions
2809: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
2810: ,p_set_core_objects in pay_element_template_util.t_core_objects
2811: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
2812: ) is
2813: l_proc varchar2(72) := g_package||'gen_gu_bal_exclusions';

Line 2810: ,p_set_core_objects in pay_element_template_util.t_core_objects

2806: ,p_business_group_id in number
2807: ,p_legislation_code in varchar2
2808: ,p_gu_bal_exclusions in pay_element_template_util.t_gu_bal_exclusions
2809: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
2810: ,p_set_core_objects in pay_element_template_util.t_core_objects
2811: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
2812: ) is
2813: l_proc varchar2(72) := g_package||'gen_gu_bal_exclusions';
2814: l_shadow_object_id number;

Line 2811: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects

2807: ,p_legislation_code in varchar2
2808: ,p_gu_bal_exclusions in pay_element_template_util.t_gu_bal_exclusions
2809: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
2810: ,p_set_core_objects in pay_element_template_util.t_core_objects
2811: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
2812: ) is
2813: l_proc varchar2(72) := g_package||'gen_gu_bal_exclusions';
2814: l_shadow_object_id number;
2815: i number;

Line 2934: ,p_bal_attributes in pay_element_template_util.t_bal_attributes

2930: (p_effective_date in date
2931: ,p_template_id in number
2932: ,p_business_group_id in number
2933: ,p_legislation_code in varchar2
2934: ,p_bal_attributes in pay_element_template_util.t_bal_attributes
2935: ,p_sdb_core_objects in pay_element_template_util.t_core_objects
2936: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects
2937: ) is
2938: l_proc varchar2(72) := g_package||'gen_balance_attributes';

Line 2935: ,p_sdb_core_objects in pay_element_template_util.t_core_objects

2931: ,p_template_id in number
2932: ,p_business_group_id in number
2933: ,p_legislation_code in varchar2
2934: ,p_bal_attributes in pay_element_template_util.t_bal_attributes
2935: ,p_sdb_core_objects in pay_element_template_util.t_core_objects
2936: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects
2937: ) is
2938: l_proc varchar2(72) := g_package||'gen_balance_attributes';
2939: l_shadow_object_id number;

Line 2936: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects

2932: ,p_business_group_id in number
2933: ,p_legislation_code in varchar2
2934: ,p_bal_attributes in pay_element_template_util.t_bal_attributes
2935: ,p_sdb_core_objects in pay_element_template_util.t_core_objects
2936: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects
2937: ) is
2938: l_proc varchar2(72) := g_package||'gen_balance_attributes';
2939: l_shadow_object_id number;
2940: i number;

Line 3024: l_exclusion_rules pay_element_template_util.t_exclusion_rules;

3020: -----------------------------
3021: -- PL/SQL template tables. --
3022: -----------------------------
3023: l_element_template pay_etm_shd.g_rec_type;
3024: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3025: l_formulas pay_element_template_util.t_formulas;
3026: l_balance_types pay_element_template_util.t_balance_types;
3027: l_defined_balances pay_element_template_util.t_defined_balances;
3028: l_element_types pay_element_template_util.t_element_types;

Line 3025: l_formulas pay_element_template_util.t_formulas;

3021: -- PL/SQL template tables. --
3022: -----------------------------
3023: l_element_template pay_etm_shd.g_rec_type;
3024: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3025: l_formulas pay_element_template_util.t_formulas;
3026: l_balance_types pay_element_template_util.t_balance_types;
3027: l_defined_balances pay_element_template_util.t_defined_balances;
3028: l_element_types pay_element_template_util.t_element_types;
3029: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;

Line 3026: l_balance_types pay_element_template_util.t_balance_types;

3022: -----------------------------
3023: l_element_template pay_etm_shd.g_rec_type;
3024: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3025: l_formulas pay_element_template_util.t_formulas;
3026: l_balance_types pay_element_template_util.t_balance_types;
3027: l_defined_balances pay_element_template_util.t_defined_balances;
3028: l_element_types pay_element_template_util.t_element_types;
3029: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3030: l_balance_classis pay_element_template_util.t_balance_classis;

Line 3027: l_defined_balances pay_element_template_util.t_defined_balances;

3023: l_element_template pay_etm_shd.g_rec_type;
3024: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3025: l_formulas pay_element_template_util.t_formulas;
3026: l_balance_types pay_element_template_util.t_balance_types;
3027: l_defined_balances pay_element_template_util.t_defined_balances;
3028: l_element_types pay_element_template_util.t_element_types;
3029: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3030: l_balance_classis pay_element_template_util.t_balance_classis;
3031: l_input_values pay_element_template_util.t_input_values;

Line 3028: l_element_types pay_element_template_util.t_element_types;

3024: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3025: l_formulas pay_element_template_util.t_formulas;
3026: l_balance_types pay_element_template_util.t_balance_types;
3027: l_defined_balances pay_element_template_util.t_defined_balances;
3028: l_element_types pay_element_template_util.t_element_types;
3029: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3030: l_balance_classis pay_element_template_util.t_balance_classis;
3031: l_input_values pay_element_template_util.t_input_values;
3032: l_balance_feeds pay_element_template_util.t_balance_feeds;

Line 3029: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;

3025: l_formulas pay_element_template_util.t_formulas;
3026: l_balance_types pay_element_template_util.t_balance_types;
3027: l_defined_balances pay_element_template_util.t_defined_balances;
3028: l_element_types pay_element_template_util.t_element_types;
3029: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3030: l_balance_classis pay_element_template_util.t_balance_classis;
3031: l_input_values pay_element_template_util.t_input_values;
3032: l_balance_feeds pay_element_template_util.t_balance_feeds;
3033: l_formula_rules pay_element_template_util.t_formula_rules;

Line 3030: l_balance_classis pay_element_template_util.t_balance_classis;

3026: l_balance_types pay_element_template_util.t_balance_types;
3027: l_defined_balances pay_element_template_util.t_defined_balances;
3028: l_element_types pay_element_template_util.t_element_types;
3029: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3030: l_balance_classis pay_element_template_util.t_balance_classis;
3031: l_input_values pay_element_template_util.t_input_values;
3032: l_balance_feeds pay_element_template_util.t_balance_feeds;
3033: l_formula_rules pay_element_template_util.t_formula_rules;
3034: l_iterative_rules pay_element_template_util.t_iterative_rules;

Line 3031: l_input_values pay_element_template_util.t_input_values;

3027: l_defined_balances pay_element_template_util.t_defined_balances;
3028: l_element_types pay_element_template_util.t_element_types;
3029: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3030: l_balance_classis pay_element_template_util.t_balance_classis;
3031: l_input_values pay_element_template_util.t_input_values;
3032: l_balance_feeds pay_element_template_util.t_balance_feeds;
3033: l_formula_rules pay_element_template_util.t_formula_rules;
3034: l_iterative_rules pay_element_template_util.t_iterative_rules;
3035: l_ele_type_usages pay_element_template_util.t_ele_type_usages;

Line 3032: l_balance_feeds pay_element_template_util.t_balance_feeds;

3028: l_element_types pay_element_template_util.t_element_types;
3029: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3030: l_balance_classis pay_element_template_util.t_balance_classis;
3031: l_input_values pay_element_template_util.t_input_values;
3032: l_balance_feeds pay_element_template_util.t_balance_feeds;
3033: l_formula_rules pay_element_template_util.t_formula_rules;
3034: l_iterative_rules pay_element_template_util.t_iterative_rules;
3035: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3036: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;

Line 3033: l_formula_rules pay_element_template_util.t_formula_rules;

3029: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3030: l_balance_classis pay_element_template_util.t_balance_classis;
3031: l_input_values pay_element_template_util.t_input_values;
3032: l_balance_feeds pay_element_template_util.t_balance_feeds;
3033: l_formula_rules pay_element_template_util.t_formula_rules;
3034: l_iterative_rules pay_element_template_util.t_iterative_rules;
3035: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3036: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3037: l_bal_attributes pay_element_template_util.t_bal_attributes;

Line 3034: l_iterative_rules pay_element_template_util.t_iterative_rules;

3030: l_balance_classis pay_element_template_util.t_balance_classis;
3031: l_input_values pay_element_template_util.t_input_values;
3032: l_balance_feeds pay_element_template_util.t_balance_feeds;
3033: l_formula_rules pay_element_template_util.t_formula_rules;
3034: l_iterative_rules pay_element_template_util.t_iterative_rules;
3035: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3036: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3037: l_bal_attributes pay_element_template_util.t_bal_attributes;
3038: l_template_ff_usages pay_element_template_util.t_template_ff_usages;

Line 3035: l_ele_type_usages pay_element_template_util.t_ele_type_usages;

3031: l_input_values pay_element_template_util.t_input_values;
3032: l_balance_feeds pay_element_template_util.t_balance_feeds;
3033: l_formula_rules pay_element_template_util.t_formula_rules;
3034: l_iterative_rules pay_element_template_util.t_iterative_rules;
3035: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3036: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3037: l_bal_attributes pay_element_template_util.t_bal_attributes;
3038: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3039: ------------------------

Line 3036: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;

3032: l_balance_feeds pay_element_template_util.t_balance_feeds;
3033: l_formula_rules pay_element_template_util.t_formula_rules;
3034: l_iterative_rules pay_element_template_util.t_iterative_rules;
3035: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3036: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3037: l_bal_attributes pay_element_template_util.t_bal_attributes;
3038: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3039: ------------------------
3040: -- Generation tables. --

Line 3037: l_bal_attributes pay_element_template_util.t_bal_attributes;

3033: l_formula_rules pay_element_template_util.t_formula_rules;
3034: l_iterative_rules pay_element_template_util.t_iterative_rules;
3035: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3036: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3037: l_bal_attributes pay_element_template_util.t_bal_attributes;
3038: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3039: ------------------------
3040: -- Generation tables. --
3041: ------------------------

Line 3038: l_template_ff_usages pay_element_template_util.t_template_ff_usages;

3034: l_iterative_rules pay_element_template_util.t_iterative_rules;
3035: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3036: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3037: l_bal_attributes pay_element_template_util.t_bal_attributes;
3038: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3039: ------------------------
3040: -- Generation tables. --
3041: ------------------------
3042: l_all_core_objects pay_element_template_util.t_core_objects;

Line 3042: l_all_core_objects pay_element_template_util.t_core_objects;

3038: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3039: ------------------------
3040: -- Generation tables. --
3041: ------------------------
3042: l_all_core_objects pay_element_template_util.t_core_objects;
3043: l_sf_core_objects pay_element_template_util.t_core_objects;
3044: l_sbt_core_objects pay_element_template_util.t_core_objects;
3045: l_sdb_core_objects pay_element_template_util.t_core_objects;
3046: l_set_core_objects pay_element_template_util.t_core_objects;

Line 3043: l_sf_core_objects pay_element_template_util.t_core_objects;

3039: ------------------------
3040: -- Generation tables. --
3041: ------------------------
3042: l_all_core_objects pay_element_template_util.t_core_objects;
3043: l_sf_core_objects pay_element_template_util.t_core_objects;
3044: l_sbt_core_objects pay_element_template_util.t_core_objects;
3045: l_sdb_core_objects pay_element_template_util.t_core_objects;
3046: l_set_core_objects pay_element_template_util.t_core_objects;
3047: l_ssr_core_objects pay_element_template_util.t_core_objects;

Line 3044: l_sbt_core_objects pay_element_template_util.t_core_objects;

3040: -- Generation tables. --
3041: ------------------------
3042: l_all_core_objects pay_element_template_util.t_core_objects;
3043: l_sf_core_objects pay_element_template_util.t_core_objects;
3044: l_sbt_core_objects pay_element_template_util.t_core_objects;
3045: l_sdb_core_objects pay_element_template_util.t_core_objects;
3046: l_set_core_objects pay_element_template_util.t_core_objects;
3047: l_ssr_core_objects pay_element_template_util.t_core_objects;
3048: l_sbc_core_objects pay_element_template_util.t_core_objects;

Line 3045: l_sdb_core_objects pay_element_template_util.t_core_objects;

3041: ------------------------
3042: l_all_core_objects pay_element_template_util.t_core_objects;
3043: l_sf_core_objects pay_element_template_util.t_core_objects;
3044: l_sbt_core_objects pay_element_template_util.t_core_objects;
3045: l_sdb_core_objects pay_element_template_util.t_core_objects;
3046: l_set_core_objects pay_element_template_util.t_core_objects;
3047: l_ssr_core_objects pay_element_template_util.t_core_objects;
3048: l_sbc_core_objects pay_element_template_util.t_core_objects;
3049: l_siv_core_objects pay_element_template_util.t_core_objects;

Line 3046: l_set_core_objects pay_element_template_util.t_core_objects;

3042: l_all_core_objects pay_element_template_util.t_core_objects;
3043: l_sf_core_objects pay_element_template_util.t_core_objects;
3044: l_sbt_core_objects pay_element_template_util.t_core_objects;
3045: l_sdb_core_objects pay_element_template_util.t_core_objects;
3046: l_set_core_objects pay_element_template_util.t_core_objects;
3047: l_ssr_core_objects pay_element_template_util.t_core_objects;
3048: l_sbc_core_objects pay_element_template_util.t_core_objects;
3049: l_siv_core_objects pay_element_template_util.t_core_objects;
3050: l_sbf_core_objects pay_element_template_util.t_core_objects;

Line 3047: l_ssr_core_objects pay_element_template_util.t_core_objects;

3043: l_sf_core_objects pay_element_template_util.t_core_objects;
3044: l_sbt_core_objects pay_element_template_util.t_core_objects;
3045: l_sdb_core_objects pay_element_template_util.t_core_objects;
3046: l_set_core_objects pay_element_template_util.t_core_objects;
3047: l_ssr_core_objects pay_element_template_util.t_core_objects;
3048: l_sbc_core_objects pay_element_template_util.t_core_objects;
3049: l_siv_core_objects pay_element_template_util.t_core_objects;
3050: l_sbf_core_objects pay_element_template_util.t_core_objects;
3051: l_spr_core_objects pay_element_template_util.t_core_objects;

Line 3048: l_sbc_core_objects pay_element_template_util.t_core_objects;

3044: l_sbt_core_objects pay_element_template_util.t_core_objects;
3045: l_sdb_core_objects pay_element_template_util.t_core_objects;
3046: l_set_core_objects pay_element_template_util.t_core_objects;
3047: l_ssr_core_objects pay_element_template_util.t_core_objects;
3048: l_sbc_core_objects pay_element_template_util.t_core_objects;
3049: l_siv_core_objects pay_element_template_util.t_core_objects;
3050: l_sbf_core_objects pay_element_template_util.t_core_objects;
3051: l_spr_core_objects pay_element_template_util.t_core_objects;
3052: l_sfr_core_objects pay_element_template_util.t_core_objects;

Line 3049: l_siv_core_objects pay_element_template_util.t_core_objects;

3045: l_sdb_core_objects pay_element_template_util.t_core_objects;
3046: l_set_core_objects pay_element_template_util.t_core_objects;
3047: l_ssr_core_objects pay_element_template_util.t_core_objects;
3048: l_sbc_core_objects pay_element_template_util.t_core_objects;
3049: l_siv_core_objects pay_element_template_util.t_core_objects;
3050: l_sbf_core_objects pay_element_template_util.t_core_objects;
3051: l_spr_core_objects pay_element_template_util.t_core_objects;
3052: l_sfr_core_objects pay_element_template_util.t_core_objects;
3053: l_sir_core_objects pay_element_template_util.t_core_objects;

Line 3050: l_sbf_core_objects pay_element_template_util.t_core_objects;

3046: l_set_core_objects pay_element_template_util.t_core_objects;
3047: l_ssr_core_objects pay_element_template_util.t_core_objects;
3048: l_sbc_core_objects pay_element_template_util.t_core_objects;
3049: l_siv_core_objects pay_element_template_util.t_core_objects;
3050: l_sbf_core_objects pay_element_template_util.t_core_objects;
3051: l_spr_core_objects pay_element_template_util.t_core_objects;
3052: l_sfr_core_objects pay_element_template_util.t_core_objects;
3053: l_sir_core_objects pay_element_template_util.t_core_objects;
3054: l_seu_core_objects pay_element_template_util.t_core_objects;

Line 3051: l_spr_core_objects pay_element_template_util.t_core_objects;

3047: l_ssr_core_objects pay_element_template_util.t_core_objects;
3048: l_sbc_core_objects pay_element_template_util.t_core_objects;
3049: l_siv_core_objects pay_element_template_util.t_core_objects;
3050: l_sbf_core_objects pay_element_template_util.t_core_objects;
3051: l_spr_core_objects pay_element_template_util.t_core_objects;
3052: l_sfr_core_objects pay_element_template_util.t_core_objects;
3053: l_sir_core_objects pay_element_template_util.t_core_objects;
3054: l_seu_core_objects pay_element_template_util.t_core_objects;
3055: l_sgb_core_objects pay_element_template_util.t_core_objects;

Line 3052: l_sfr_core_objects pay_element_template_util.t_core_objects;

3048: l_sbc_core_objects pay_element_template_util.t_core_objects;
3049: l_siv_core_objects pay_element_template_util.t_core_objects;
3050: l_sbf_core_objects pay_element_template_util.t_core_objects;
3051: l_spr_core_objects pay_element_template_util.t_core_objects;
3052: l_sfr_core_objects pay_element_template_util.t_core_objects;
3053: l_sir_core_objects pay_element_template_util.t_core_objects;
3054: l_seu_core_objects pay_element_template_util.t_core_objects;
3055: l_sgb_core_objects pay_element_template_util.t_core_objects;
3056: l_sba_core_objects pay_element_template_util.t_core_objects;

Line 3053: l_sir_core_objects pay_element_template_util.t_core_objects;

3049: l_siv_core_objects pay_element_template_util.t_core_objects;
3050: l_sbf_core_objects pay_element_template_util.t_core_objects;
3051: l_spr_core_objects pay_element_template_util.t_core_objects;
3052: l_sfr_core_objects pay_element_template_util.t_core_objects;
3053: l_sir_core_objects pay_element_template_util.t_core_objects;
3054: l_seu_core_objects pay_element_template_util.t_core_objects;
3055: l_sgb_core_objects pay_element_template_util.t_core_objects;
3056: l_sba_core_objects pay_element_template_util.t_core_objects;
3057: begin

Line 3054: l_seu_core_objects pay_element_template_util.t_core_objects;

3050: l_sbf_core_objects pay_element_template_util.t_core_objects;
3051: l_spr_core_objects pay_element_template_util.t_core_objects;
3052: l_sfr_core_objects pay_element_template_util.t_core_objects;
3053: l_sir_core_objects pay_element_template_util.t_core_objects;
3054: l_seu_core_objects pay_element_template_util.t_core_objects;
3055: l_sgb_core_objects pay_element_template_util.t_core_objects;
3056: l_sba_core_objects pay_element_template_util.t_core_objects;
3057: begin
3058: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3055: l_sgb_core_objects pay_element_template_util.t_core_objects;

3051: l_spr_core_objects pay_element_template_util.t_core_objects;
3052: l_sfr_core_objects pay_element_template_util.t_core_objects;
3053: l_sir_core_objects pay_element_template_util.t_core_objects;
3054: l_seu_core_objects pay_element_template_util.t_core_objects;
3055: l_sgb_core_objects pay_element_template_util.t_core_objects;
3056: l_sba_core_objects pay_element_template_util.t_core_objects;
3057: begin
3058: hr_utility.set_location('Entering:'|| l_proc, 10);
3059: ----------------------------------------------

Line 3056: l_sba_core_objects pay_element_template_util.t_core_objects;

3052: l_sfr_core_objects pay_element_template_util.t_core_objects;
3053: l_sir_core_objects pay_element_template_util.t_core_objects;
3054: l_seu_core_objects pay_element_template_util.t_core_objects;
3055: l_sgb_core_objects pay_element_template_util.t_core_objects;
3056: l_sba_core_objects pay_element_template_util.t_core_objects;
3057: begin
3058: hr_utility.set_location('Entering:'|| l_proc, 10);
3059: ----------------------------------------------
3060: -- Check that the template type is correct. --

Line 3063: pay_element_template_util.get_template_type(p_template_id);

3059: ----------------------------------------------
3060: -- Check that the template type is correct. --
3061: ----------------------------------------------
3062: l_template_type :=
3063: pay_element_template_util.get_template_type(p_template_id);
3064: if l_template_type is null or l_template_type <> 'U' then
3065: hr_utility.set_message(801, 'PAY_50065_BAD_USER_TEMPLATE');
3066: hr_utility.raise_error;
3067: end if;

Line 3071: pay_element_template_util.create_plsql_template

3067: end if;
3068: ---------------------------------------
3069: -- Read in the template information. --
3070: ---------------------------------------
3071: pay_element_template_util.create_plsql_template
3072: (p_template_id => p_template_id
3073: ,p_generate_part1 => true
3074: ,p_core_objects => l_all_core_objects
3075: ,p_element_template => l_element_template

Line 3319: l_exclusion_rules pay_element_template_util.t_exclusion_rules;

3315: -----------------------------
3316: -- PL/SQL template tables. --
3317: -----------------------------
3318: l_element_template pay_etm_shd.g_rec_type;
3319: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3320: l_formulas pay_element_template_util.t_formulas;
3321: l_balance_types pay_element_template_util.t_balance_types;
3322: l_defined_balances pay_element_template_util.t_defined_balances;
3323: l_element_types pay_element_template_util.t_element_types;

Line 3320: l_formulas pay_element_template_util.t_formulas;

3316: -- PL/SQL template tables. --
3317: -----------------------------
3318: l_element_template pay_etm_shd.g_rec_type;
3319: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3320: l_formulas pay_element_template_util.t_formulas;
3321: l_balance_types pay_element_template_util.t_balance_types;
3322: l_defined_balances pay_element_template_util.t_defined_balances;
3323: l_element_types pay_element_template_util.t_element_types;
3324: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;

Line 3321: l_balance_types pay_element_template_util.t_balance_types;

3317: -----------------------------
3318: l_element_template pay_etm_shd.g_rec_type;
3319: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3320: l_formulas pay_element_template_util.t_formulas;
3321: l_balance_types pay_element_template_util.t_balance_types;
3322: l_defined_balances pay_element_template_util.t_defined_balances;
3323: l_element_types pay_element_template_util.t_element_types;
3324: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3325: l_balance_classis pay_element_template_util.t_balance_classis;

Line 3322: l_defined_balances pay_element_template_util.t_defined_balances;

3318: l_element_template pay_etm_shd.g_rec_type;
3319: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3320: l_formulas pay_element_template_util.t_formulas;
3321: l_balance_types pay_element_template_util.t_balance_types;
3322: l_defined_balances pay_element_template_util.t_defined_balances;
3323: l_element_types pay_element_template_util.t_element_types;
3324: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3325: l_balance_classis pay_element_template_util.t_balance_classis;
3326: l_input_values pay_element_template_util.t_input_values;

Line 3323: l_element_types pay_element_template_util.t_element_types;

3319: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3320: l_formulas pay_element_template_util.t_formulas;
3321: l_balance_types pay_element_template_util.t_balance_types;
3322: l_defined_balances pay_element_template_util.t_defined_balances;
3323: l_element_types pay_element_template_util.t_element_types;
3324: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3325: l_balance_classis pay_element_template_util.t_balance_classis;
3326: l_input_values pay_element_template_util.t_input_values;
3327: l_balance_feeds pay_element_template_util.t_balance_feeds;

Line 3324: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;

3320: l_formulas pay_element_template_util.t_formulas;
3321: l_balance_types pay_element_template_util.t_balance_types;
3322: l_defined_balances pay_element_template_util.t_defined_balances;
3323: l_element_types pay_element_template_util.t_element_types;
3324: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3325: l_balance_classis pay_element_template_util.t_balance_classis;
3326: l_input_values pay_element_template_util.t_input_values;
3327: l_balance_feeds pay_element_template_util.t_balance_feeds;
3328: l_formula_rules pay_element_template_util.t_formula_rules;

Line 3325: l_balance_classis pay_element_template_util.t_balance_classis;

3321: l_balance_types pay_element_template_util.t_balance_types;
3322: l_defined_balances pay_element_template_util.t_defined_balances;
3323: l_element_types pay_element_template_util.t_element_types;
3324: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3325: l_balance_classis pay_element_template_util.t_balance_classis;
3326: l_input_values pay_element_template_util.t_input_values;
3327: l_balance_feeds pay_element_template_util.t_balance_feeds;
3328: l_formula_rules pay_element_template_util.t_formula_rules;
3329: l_iterative_rules pay_element_template_util.t_iterative_rules;

Line 3326: l_input_values pay_element_template_util.t_input_values;

3322: l_defined_balances pay_element_template_util.t_defined_balances;
3323: l_element_types pay_element_template_util.t_element_types;
3324: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3325: l_balance_classis pay_element_template_util.t_balance_classis;
3326: l_input_values pay_element_template_util.t_input_values;
3327: l_balance_feeds pay_element_template_util.t_balance_feeds;
3328: l_formula_rules pay_element_template_util.t_formula_rules;
3329: l_iterative_rules pay_element_template_util.t_iterative_rules;
3330: l_ele_type_usages pay_element_template_util.t_ele_type_usages;

Line 3327: l_balance_feeds pay_element_template_util.t_balance_feeds;

3323: l_element_types pay_element_template_util.t_element_types;
3324: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3325: l_balance_classis pay_element_template_util.t_balance_classis;
3326: l_input_values pay_element_template_util.t_input_values;
3327: l_balance_feeds pay_element_template_util.t_balance_feeds;
3328: l_formula_rules pay_element_template_util.t_formula_rules;
3329: l_iterative_rules pay_element_template_util.t_iterative_rules;
3330: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3331: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;

Line 3328: l_formula_rules pay_element_template_util.t_formula_rules;

3324: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3325: l_balance_classis pay_element_template_util.t_balance_classis;
3326: l_input_values pay_element_template_util.t_input_values;
3327: l_balance_feeds pay_element_template_util.t_balance_feeds;
3328: l_formula_rules pay_element_template_util.t_formula_rules;
3329: l_iterative_rules pay_element_template_util.t_iterative_rules;
3330: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3331: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3332: l_template_ff_usages pay_element_template_util.t_template_ff_usages;

Line 3329: l_iterative_rules pay_element_template_util.t_iterative_rules;

3325: l_balance_classis pay_element_template_util.t_balance_classis;
3326: l_input_values pay_element_template_util.t_input_values;
3327: l_balance_feeds pay_element_template_util.t_balance_feeds;
3328: l_formula_rules pay_element_template_util.t_formula_rules;
3329: l_iterative_rules pay_element_template_util.t_iterative_rules;
3330: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3331: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3332: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3333: l_bal_attributes pay_element_template_util.t_bal_attributes;

Line 3330: l_ele_type_usages pay_element_template_util.t_ele_type_usages;

3326: l_input_values pay_element_template_util.t_input_values;
3327: l_balance_feeds pay_element_template_util.t_balance_feeds;
3328: l_formula_rules pay_element_template_util.t_formula_rules;
3329: l_iterative_rules pay_element_template_util.t_iterative_rules;
3330: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3331: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3332: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3333: l_bal_attributes pay_element_template_util.t_bal_attributes;
3334: ------------------------

Line 3331: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;

3327: l_balance_feeds pay_element_template_util.t_balance_feeds;
3328: l_formula_rules pay_element_template_util.t_formula_rules;
3329: l_iterative_rules pay_element_template_util.t_iterative_rules;
3330: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3331: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3332: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3333: l_bal_attributes pay_element_template_util.t_bal_attributes;
3334: ------------------------
3335: -- Generation tables. --

Line 3332: l_template_ff_usages pay_element_template_util.t_template_ff_usages;

3328: l_formula_rules pay_element_template_util.t_formula_rules;
3329: l_iterative_rules pay_element_template_util.t_iterative_rules;
3330: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3331: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3332: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3333: l_bal_attributes pay_element_template_util.t_bal_attributes;
3334: ------------------------
3335: -- Generation tables. --
3336: ------------------------

Line 3333: l_bal_attributes pay_element_template_util.t_bal_attributes;

3329: l_iterative_rules pay_element_template_util.t_iterative_rules;
3330: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3331: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3332: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3333: l_bal_attributes pay_element_template_util.t_bal_attributes;
3334: ------------------------
3335: -- Generation tables. --
3336: ------------------------
3337: l_all_core_objects pay_element_template_util.t_core_objects;

Line 3337: l_all_core_objects pay_element_template_util.t_core_objects;

3333: l_bal_attributes pay_element_template_util.t_bal_attributes;
3334: ------------------------
3335: -- Generation tables. --
3336: ------------------------
3337: l_all_core_objects pay_element_template_util.t_core_objects;
3338: l_sf_core_objects pay_element_template_util.t_core_objects;
3339: l_sbt_core_objects pay_element_template_util.t_core_objects;
3340: l_sdb_core_objects pay_element_template_util.t_core_objects;
3341: l_set_core_objects pay_element_template_util.t_core_objects;

Line 3338: l_sf_core_objects pay_element_template_util.t_core_objects;

3334: ------------------------
3335: -- Generation tables. --
3336: ------------------------
3337: l_all_core_objects pay_element_template_util.t_core_objects;
3338: l_sf_core_objects pay_element_template_util.t_core_objects;
3339: l_sbt_core_objects pay_element_template_util.t_core_objects;
3340: l_sdb_core_objects pay_element_template_util.t_core_objects;
3341: l_set_core_objects pay_element_template_util.t_core_objects;
3342: l_ssr_core_objects pay_element_template_util.t_core_objects;

Line 3339: l_sbt_core_objects pay_element_template_util.t_core_objects;

3335: -- Generation tables. --
3336: ------------------------
3337: l_all_core_objects pay_element_template_util.t_core_objects;
3338: l_sf_core_objects pay_element_template_util.t_core_objects;
3339: l_sbt_core_objects pay_element_template_util.t_core_objects;
3340: l_sdb_core_objects pay_element_template_util.t_core_objects;
3341: l_set_core_objects pay_element_template_util.t_core_objects;
3342: l_ssr_core_objects pay_element_template_util.t_core_objects;
3343: l_sbc_core_objects pay_element_template_util.t_core_objects;

Line 3340: l_sdb_core_objects pay_element_template_util.t_core_objects;

3336: ------------------------
3337: l_all_core_objects pay_element_template_util.t_core_objects;
3338: l_sf_core_objects pay_element_template_util.t_core_objects;
3339: l_sbt_core_objects pay_element_template_util.t_core_objects;
3340: l_sdb_core_objects pay_element_template_util.t_core_objects;
3341: l_set_core_objects pay_element_template_util.t_core_objects;
3342: l_ssr_core_objects pay_element_template_util.t_core_objects;
3343: l_sbc_core_objects pay_element_template_util.t_core_objects;
3344: l_siv_core_objects pay_element_template_util.t_core_objects;

Line 3341: l_set_core_objects pay_element_template_util.t_core_objects;

3337: l_all_core_objects pay_element_template_util.t_core_objects;
3338: l_sf_core_objects pay_element_template_util.t_core_objects;
3339: l_sbt_core_objects pay_element_template_util.t_core_objects;
3340: l_sdb_core_objects pay_element_template_util.t_core_objects;
3341: l_set_core_objects pay_element_template_util.t_core_objects;
3342: l_ssr_core_objects pay_element_template_util.t_core_objects;
3343: l_sbc_core_objects pay_element_template_util.t_core_objects;
3344: l_siv_core_objects pay_element_template_util.t_core_objects;
3345: l_sbf_core_objects pay_element_template_util.t_core_objects;

Line 3342: l_ssr_core_objects pay_element_template_util.t_core_objects;

3338: l_sf_core_objects pay_element_template_util.t_core_objects;
3339: l_sbt_core_objects pay_element_template_util.t_core_objects;
3340: l_sdb_core_objects pay_element_template_util.t_core_objects;
3341: l_set_core_objects pay_element_template_util.t_core_objects;
3342: l_ssr_core_objects pay_element_template_util.t_core_objects;
3343: l_sbc_core_objects pay_element_template_util.t_core_objects;
3344: l_siv_core_objects pay_element_template_util.t_core_objects;
3345: l_sbf_core_objects pay_element_template_util.t_core_objects;
3346: l_spr_core_objects pay_element_template_util.t_core_objects;

Line 3343: l_sbc_core_objects pay_element_template_util.t_core_objects;

3339: l_sbt_core_objects pay_element_template_util.t_core_objects;
3340: l_sdb_core_objects pay_element_template_util.t_core_objects;
3341: l_set_core_objects pay_element_template_util.t_core_objects;
3342: l_ssr_core_objects pay_element_template_util.t_core_objects;
3343: l_sbc_core_objects pay_element_template_util.t_core_objects;
3344: l_siv_core_objects pay_element_template_util.t_core_objects;
3345: l_sbf_core_objects pay_element_template_util.t_core_objects;
3346: l_spr_core_objects pay_element_template_util.t_core_objects;
3347: l_sfr_core_objects pay_element_template_util.t_core_objects;

Line 3344: l_siv_core_objects pay_element_template_util.t_core_objects;

3340: l_sdb_core_objects pay_element_template_util.t_core_objects;
3341: l_set_core_objects pay_element_template_util.t_core_objects;
3342: l_ssr_core_objects pay_element_template_util.t_core_objects;
3343: l_sbc_core_objects pay_element_template_util.t_core_objects;
3344: l_siv_core_objects pay_element_template_util.t_core_objects;
3345: l_sbf_core_objects pay_element_template_util.t_core_objects;
3346: l_spr_core_objects pay_element_template_util.t_core_objects;
3347: l_sfr_core_objects pay_element_template_util.t_core_objects;
3348: l_sir_core_objects pay_element_template_util.t_core_objects;

Line 3345: l_sbf_core_objects pay_element_template_util.t_core_objects;

3341: l_set_core_objects pay_element_template_util.t_core_objects;
3342: l_ssr_core_objects pay_element_template_util.t_core_objects;
3343: l_sbc_core_objects pay_element_template_util.t_core_objects;
3344: l_siv_core_objects pay_element_template_util.t_core_objects;
3345: l_sbf_core_objects pay_element_template_util.t_core_objects;
3346: l_spr_core_objects pay_element_template_util.t_core_objects;
3347: l_sfr_core_objects pay_element_template_util.t_core_objects;
3348: l_sir_core_objects pay_element_template_util.t_core_objects;
3349: l_seu_core_objects pay_element_template_util.t_core_objects;

Line 3346: l_spr_core_objects pay_element_template_util.t_core_objects;

3342: l_ssr_core_objects pay_element_template_util.t_core_objects;
3343: l_sbc_core_objects pay_element_template_util.t_core_objects;
3344: l_siv_core_objects pay_element_template_util.t_core_objects;
3345: l_sbf_core_objects pay_element_template_util.t_core_objects;
3346: l_spr_core_objects pay_element_template_util.t_core_objects;
3347: l_sfr_core_objects pay_element_template_util.t_core_objects;
3348: l_sir_core_objects pay_element_template_util.t_core_objects;
3349: l_seu_core_objects pay_element_template_util.t_core_objects;
3350: l_sgb_core_objects pay_element_template_util.t_core_objects;

Line 3347: l_sfr_core_objects pay_element_template_util.t_core_objects;

3343: l_sbc_core_objects pay_element_template_util.t_core_objects;
3344: l_siv_core_objects pay_element_template_util.t_core_objects;
3345: l_sbf_core_objects pay_element_template_util.t_core_objects;
3346: l_spr_core_objects pay_element_template_util.t_core_objects;
3347: l_sfr_core_objects pay_element_template_util.t_core_objects;
3348: l_sir_core_objects pay_element_template_util.t_core_objects;
3349: l_seu_core_objects pay_element_template_util.t_core_objects;
3350: l_sgb_core_objects pay_element_template_util.t_core_objects;
3351: l_sba_core_objects pay_element_template_util.t_core_objects;

Line 3348: l_sir_core_objects pay_element_template_util.t_core_objects;

3344: l_siv_core_objects pay_element_template_util.t_core_objects;
3345: l_sbf_core_objects pay_element_template_util.t_core_objects;
3346: l_spr_core_objects pay_element_template_util.t_core_objects;
3347: l_sfr_core_objects pay_element_template_util.t_core_objects;
3348: l_sir_core_objects pay_element_template_util.t_core_objects;
3349: l_seu_core_objects pay_element_template_util.t_core_objects;
3350: l_sgb_core_objects pay_element_template_util.t_core_objects;
3351: l_sba_core_objects pay_element_template_util.t_core_objects;
3352: --

Line 3349: l_seu_core_objects pay_element_template_util.t_core_objects;

3345: l_sbf_core_objects pay_element_template_util.t_core_objects;
3346: l_spr_core_objects pay_element_template_util.t_core_objects;
3347: l_sfr_core_objects pay_element_template_util.t_core_objects;
3348: l_sir_core_objects pay_element_template_util.t_core_objects;
3349: l_seu_core_objects pay_element_template_util.t_core_objects;
3350: l_sgb_core_objects pay_element_template_util.t_core_objects;
3351: l_sba_core_objects pay_element_template_util.t_core_objects;
3352: --
3353: begin

Line 3350: l_sgb_core_objects pay_element_template_util.t_core_objects;

3346: l_spr_core_objects pay_element_template_util.t_core_objects;
3347: l_sfr_core_objects pay_element_template_util.t_core_objects;
3348: l_sir_core_objects pay_element_template_util.t_core_objects;
3349: l_seu_core_objects pay_element_template_util.t_core_objects;
3350: l_sgb_core_objects pay_element_template_util.t_core_objects;
3351: l_sba_core_objects pay_element_template_util.t_core_objects;
3352: --
3353: begin
3354: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3351: l_sba_core_objects pay_element_template_util.t_core_objects;

3347: l_sfr_core_objects pay_element_template_util.t_core_objects;
3348: l_sir_core_objects pay_element_template_util.t_core_objects;
3349: l_seu_core_objects pay_element_template_util.t_core_objects;
3350: l_sgb_core_objects pay_element_template_util.t_core_objects;
3351: l_sba_core_objects pay_element_template_util.t_core_objects;
3352: --
3353: begin
3354: hr_utility.set_location('Entering:'|| l_proc, 10);
3355: ----------------------------------------------

Line 3359: pay_element_template_util.get_template_type(p_template_id);

3355: ----------------------------------------------
3356: -- Check that the template type is correct. --
3357: ----------------------------------------------
3358: l_template_type :=
3359: pay_element_template_util.get_template_type(p_template_id);
3360: if l_template_type is null or l_template_type <> 'U' then
3361: hr_utility.set_message(801, 'PAY_50065_BAD_USER_TEMPLATE');
3362: hr_utility.raise_error;
3363: end if;

Line 3367: pay_element_template_util.create_plsql_template

3363: end if;
3364: ---------------------------------------
3365: -- Read in the template information. --
3366: ---------------------------------------
3367: pay_element_template_util.create_plsql_template
3368: (p_template_id => p_template_id
3369: ,p_generate_part2 => true
3370: ,p_element_template => l_element_template
3371: ,p_core_objects => l_all_core_objects

Line 3458: ,p_core_objects in pay_element_template_util.t_core_objects

3454: -- |---------------------------< core_objects_lock >--------------------------|
3455: -- ----------------------------------------------------------------------------
3456: procedure core_objects_lock
3457: (p_core_object_type in varchar2
3458: ,p_core_objects in pay_element_template_util.t_core_objects
3459: ,p_rowid_id_recs in out nocopy t_rowid_id_recs
3460: ,p_id_ovn_recs in out nocopy t_id_ovn_recs
3461: ) is
3462: l_proc varchar2(72) := g_package||'core_objects_lock';

Line 4518: (p_all_core_objects in pay_element_template_util.t_core_objects

4514: -- ----------------------------------------------------------------------------
4515: -- |-----------------------------< zap_core_objects >-------------------------|
4516: -- ----------------------------------------------------------------------------
4517: procedure zap_core_objects
4518: (p_all_core_objects in pay_element_template_util.t_core_objects
4519: ,p_drop_formula_packages in boolean
4520: ) is
4521: l_proc varchar2(72) := g_package||'zap_core_objects';
4522: --

Line 4525: l_sf_core_objects pay_element_template_util.t_core_objects;

4521: l_proc varchar2(72) := g_package||'zap_core_objects';
4522: --
4523: -- Generation tables.
4524: --
4525: l_sf_core_objects pay_element_template_util.t_core_objects;
4526: l_sbt_core_objects pay_element_template_util.t_core_objects;
4527: l_sdb_core_objects pay_element_template_util.t_core_objects;
4528: l_set_core_objects pay_element_template_util.t_core_objects;
4529: l_ssr_core_objects pay_element_template_util.t_core_objects;

Line 4526: l_sbt_core_objects pay_element_template_util.t_core_objects;

4522: --
4523: -- Generation tables.
4524: --
4525: l_sf_core_objects pay_element_template_util.t_core_objects;
4526: l_sbt_core_objects pay_element_template_util.t_core_objects;
4527: l_sdb_core_objects pay_element_template_util.t_core_objects;
4528: l_set_core_objects pay_element_template_util.t_core_objects;
4529: l_ssr_core_objects pay_element_template_util.t_core_objects;
4530: l_sbc_core_objects pay_element_template_util.t_core_objects;

Line 4527: l_sdb_core_objects pay_element_template_util.t_core_objects;

4523: -- Generation tables.
4524: --
4525: l_sf_core_objects pay_element_template_util.t_core_objects;
4526: l_sbt_core_objects pay_element_template_util.t_core_objects;
4527: l_sdb_core_objects pay_element_template_util.t_core_objects;
4528: l_set_core_objects pay_element_template_util.t_core_objects;
4529: l_ssr_core_objects pay_element_template_util.t_core_objects;
4530: l_sbc_core_objects pay_element_template_util.t_core_objects;
4531: l_siv_core_objects pay_element_template_util.t_core_objects;

Line 4528: l_set_core_objects pay_element_template_util.t_core_objects;

4524: --
4525: l_sf_core_objects pay_element_template_util.t_core_objects;
4526: l_sbt_core_objects pay_element_template_util.t_core_objects;
4527: l_sdb_core_objects pay_element_template_util.t_core_objects;
4528: l_set_core_objects pay_element_template_util.t_core_objects;
4529: l_ssr_core_objects pay_element_template_util.t_core_objects;
4530: l_sbc_core_objects pay_element_template_util.t_core_objects;
4531: l_siv_core_objects pay_element_template_util.t_core_objects;
4532: l_sbf_core_objects pay_element_template_util.t_core_objects;

Line 4529: l_ssr_core_objects pay_element_template_util.t_core_objects;

4525: l_sf_core_objects pay_element_template_util.t_core_objects;
4526: l_sbt_core_objects pay_element_template_util.t_core_objects;
4527: l_sdb_core_objects pay_element_template_util.t_core_objects;
4528: l_set_core_objects pay_element_template_util.t_core_objects;
4529: l_ssr_core_objects pay_element_template_util.t_core_objects;
4530: l_sbc_core_objects pay_element_template_util.t_core_objects;
4531: l_siv_core_objects pay_element_template_util.t_core_objects;
4532: l_sbf_core_objects pay_element_template_util.t_core_objects;
4533: l_spr_core_objects pay_element_template_util.t_core_objects;

Line 4530: l_sbc_core_objects pay_element_template_util.t_core_objects;

4526: l_sbt_core_objects pay_element_template_util.t_core_objects;
4527: l_sdb_core_objects pay_element_template_util.t_core_objects;
4528: l_set_core_objects pay_element_template_util.t_core_objects;
4529: l_ssr_core_objects pay_element_template_util.t_core_objects;
4530: l_sbc_core_objects pay_element_template_util.t_core_objects;
4531: l_siv_core_objects pay_element_template_util.t_core_objects;
4532: l_sbf_core_objects pay_element_template_util.t_core_objects;
4533: l_spr_core_objects pay_element_template_util.t_core_objects;
4534: l_sfr_core_objects pay_element_template_util.t_core_objects;

Line 4531: l_siv_core_objects pay_element_template_util.t_core_objects;

4527: l_sdb_core_objects pay_element_template_util.t_core_objects;
4528: l_set_core_objects pay_element_template_util.t_core_objects;
4529: l_ssr_core_objects pay_element_template_util.t_core_objects;
4530: l_sbc_core_objects pay_element_template_util.t_core_objects;
4531: l_siv_core_objects pay_element_template_util.t_core_objects;
4532: l_sbf_core_objects pay_element_template_util.t_core_objects;
4533: l_spr_core_objects pay_element_template_util.t_core_objects;
4534: l_sfr_core_objects pay_element_template_util.t_core_objects;
4535: l_sir_core_objects pay_element_template_util.t_core_objects;

Line 4532: l_sbf_core_objects pay_element_template_util.t_core_objects;

4528: l_set_core_objects pay_element_template_util.t_core_objects;
4529: l_ssr_core_objects pay_element_template_util.t_core_objects;
4530: l_sbc_core_objects pay_element_template_util.t_core_objects;
4531: l_siv_core_objects pay_element_template_util.t_core_objects;
4532: l_sbf_core_objects pay_element_template_util.t_core_objects;
4533: l_spr_core_objects pay_element_template_util.t_core_objects;
4534: l_sfr_core_objects pay_element_template_util.t_core_objects;
4535: l_sir_core_objects pay_element_template_util.t_core_objects;
4536: l_seu_core_objects pay_element_template_util.t_core_objects;

Line 4533: l_spr_core_objects pay_element_template_util.t_core_objects;

4529: l_ssr_core_objects pay_element_template_util.t_core_objects;
4530: l_sbc_core_objects pay_element_template_util.t_core_objects;
4531: l_siv_core_objects pay_element_template_util.t_core_objects;
4532: l_sbf_core_objects pay_element_template_util.t_core_objects;
4533: l_spr_core_objects pay_element_template_util.t_core_objects;
4534: l_sfr_core_objects pay_element_template_util.t_core_objects;
4535: l_sir_core_objects pay_element_template_util.t_core_objects;
4536: l_seu_core_objects pay_element_template_util.t_core_objects;
4537: l_sgb_core_objects pay_element_template_util.t_core_objects;

Line 4534: l_sfr_core_objects pay_element_template_util.t_core_objects;

4530: l_sbc_core_objects pay_element_template_util.t_core_objects;
4531: l_siv_core_objects pay_element_template_util.t_core_objects;
4532: l_sbf_core_objects pay_element_template_util.t_core_objects;
4533: l_spr_core_objects pay_element_template_util.t_core_objects;
4534: l_sfr_core_objects pay_element_template_util.t_core_objects;
4535: l_sir_core_objects pay_element_template_util.t_core_objects;
4536: l_seu_core_objects pay_element_template_util.t_core_objects;
4537: l_sgb_core_objects pay_element_template_util.t_core_objects;
4538: l_sba_core_objects pay_element_template_util.t_core_objects;

Line 4535: l_sir_core_objects pay_element_template_util.t_core_objects;

4531: l_siv_core_objects pay_element_template_util.t_core_objects;
4532: l_sbf_core_objects pay_element_template_util.t_core_objects;
4533: l_spr_core_objects pay_element_template_util.t_core_objects;
4534: l_sfr_core_objects pay_element_template_util.t_core_objects;
4535: l_sir_core_objects pay_element_template_util.t_core_objects;
4536: l_seu_core_objects pay_element_template_util.t_core_objects;
4537: l_sgb_core_objects pay_element_template_util.t_core_objects;
4538: l_sba_core_objects pay_element_template_util.t_core_objects;
4539: --

Line 4536: l_seu_core_objects pay_element_template_util.t_core_objects;

4532: l_sbf_core_objects pay_element_template_util.t_core_objects;
4533: l_spr_core_objects pay_element_template_util.t_core_objects;
4534: l_sfr_core_objects pay_element_template_util.t_core_objects;
4535: l_sir_core_objects pay_element_template_util.t_core_objects;
4536: l_seu_core_objects pay_element_template_util.t_core_objects;
4537: l_sgb_core_objects pay_element_template_util.t_core_objects;
4538: l_sba_core_objects pay_element_template_util.t_core_objects;
4539: --
4540: -- Deletion tables for the generated objects.

Line 4537: l_sgb_core_objects pay_element_template_util.t_core_objects;

4533: l_spr_core_objects pay_element_template_util.t_core_objects;
4534: l_sfr_core_objects pay_element_template_util.t_core_objects;
4535: l_sir_core_objects pay_element_template_util.t_core_objects;
4536: l_seu_core_objects pay_element_template_util.t_core_objects;
4537: l_sgb_core_objects pay_element_template_util.t_core_objects;
4538: l_sba_core_objects pay_element_template_util.t_core_objects;
4539: --
4540: -- Deletion tables for the generated objects.
4541: --

Line 4538: l_sba_core_objects pay_element_template_util.t_core_objects;

4534: l_sfr_core_objects pay_element_template_util.t_core_objects;
4535: l_sir_core_objects pay_element_template_util.t_core_objects;
4536: l_seu_core_objects pay_element_template_util.t_core_objects;
4537: l_sgb_core_objects pay_element_template_util.t_core_objects;
4538: l_sba_core_objects pay_element_template_util.t_core_objects;
4539: --
4540: -- Deletion tables for the generated objects.
4541: --
4542: l_sf_rowid_id_recs t_rowid_id_recs;