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 592: (p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 593: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 594: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 595: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 596: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 597: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects

593: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
594: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
595: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
596: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
597: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
598: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
599: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
600: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
601: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 598: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects

594: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
595: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
596: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
597: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
598: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
599: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
600: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
601: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
602: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 599: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects

595: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
596: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
597: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
598: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
599: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
600: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
601: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
602: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
603: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 600: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects

596: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
597: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
598: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
599: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
600: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
601: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
602: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
603: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
604: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 601: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects

597: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
598: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
599: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
600: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
601: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
602: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
603: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
604: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
605: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 602: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 603: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 604: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 605: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 630: (p_all_core_objects in pay_element_template_util.t_core_objects

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

Line 632: ,p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 633: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 634: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 635: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 636: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects

632: ,p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects
633: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
634: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
635: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
636: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
637: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
638: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
639: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
640: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 637: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects

633: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
634: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
635: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
636: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
637: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
638: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
639: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
640: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
641: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 638: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects

634: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
635: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
636: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
637: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
638: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
639: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
640: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
641: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
642: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 639: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects

635: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
636: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
637: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
638: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
639: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
640: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
641: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
642: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
643: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 640: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects

636: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
637: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
638: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
639: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
640: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
641: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
642: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
643: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
644: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 641: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects

637: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
638: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
639: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
640: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
641: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
642: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
643: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
644: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
645: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 642: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 643: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 644: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 645: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 730: ,p_core_objects in pay_element_template_util.t_core_objects

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

Line 981: ,p_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 1011: ,p_all_core_objects in pay_element_template_util.t_core_objects

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

Line 1027: ,p_formulas in pay_element_template_util.t_formulas

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

Line 1028: ,p_sf_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 1129: ,p_balance_types in pay_element_template_util.t_balance_types

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

Line 1130: ,p_siv_core_objects in pay_element_template_util.t_core_objects

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

Line 1131: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects

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

Line 1297: ,p_balance_types in pay_element_template_util.t_balance_types

1293: (p_effective_date in date
1294: ,p_template_id in number
1295: ,p_business_group_id in number
1296: ,p_legislation_code in varchar2
1297: ,p_balance_types in pay_element_template_util.t_balance_types
1298: ,p_siv_core_objects in pay_element_template_util.t_core_objects
1299: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
1300: ) is
1301: l_proc varchar2(72) := g_package||'gen_balance_types';

Line 1298: ,p_siv_core_objects in pay_element_template_util.t_core_objects

1294: ,p_template_id in number
1295: ,p_business_group_id in number
1296: ,p_legislation_code in varchar2
1297: ,p_balance_types in pay_element_template_util.t_balance_types
1298: ,p_siv_core_objects in pay_element_template_util.t_core_objects
1299: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
1300: ) is
1301: l_proc varchar2(72) := g_package||'gen_balance_types';
1302: i number;

Line 1299: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects

1295: ,p_business_group_id in number
1296: ,p_legislation_code in varchar2
1297: ,p_balance_types in pay_element_template_util.t_balance_types
1298: ,p_siv_core_objects in pay_element_template_util.t_core_objects
1299: ,p_sbt_core_objects in out nocopy pay_element_template_util.t_core_objects
1300: ) is
1301: l_proc varchar2(72) := g_package||'gen_balance_types';
1302: i number;
1303: --

Line 1335: ,p_defined_balances in pay_element_template_util.t_defined_balances

1331: (p_effective_date in date
1332: ,p_template_id in number
1333: ,p_business_group_id in number
1334: ,p_legislation_code in varchar2
1335: ,p_defined_balances in pay_element_template_util.t_defined_balances
1336: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
1337: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
1338: ) is
1339: l_proc varchar2(72) := g_package||'gen_defined_balances';

Line 1336: ,p_sbt_core_objects in pay_element_template_util.t_core_objects

1332: ,p_template_id in number
1333: ,p_business_group_id in number
1334: ,p_legislation_code in varchar2
1335: ,p_defined_balances in pay_element_template_util.t_defined_balances
1336: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
1337: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
1338: ) is
1339: l_proc varchar2(72) := g_package||'gen_defined_balances';
1340: l_shadow_object_id number;

Line 1337: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects

1333: ,p_business_group_id in number
1334: ,p_legislation_code in varchar2
1335: ,p_defined_balances in pay_element_template_util.t_defined_balances
1336: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
1337: ,p_sdb_core_objects in out nocopy pay_element_template_util.t_core_objects
1338: ) is
1339: l_proc varchar2(72) := g_package||'gen_defined_balances';
1340: l_shadow_object_id number;
1341: i number;

Line 1431: ,p_element_types in pay_element_template_util.t_element_types

1427: ,p_business_group_id in number
1428: ,p_hr_only in boolean
1429: ,p_legislation_code in varchar2
1430: ,p_base_processing_priority in number
1431: ,p_element_types in pay_element_template_util.t_element_types
1432: ,p_sf_core_objects in pay_element_template_util.t_core_objects
1433: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
1434: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
1435: ) is

Line 1432: ,p_sf_core_objects in pay_element_template_util.t_core_objects

1428: ,p_hr_only in boolean
1429: ,p_legislation_code in varchar2
1430: ,p_base_processing_priority in number
1431: ,p_element_types in pay_element_template_util.t_element_types
1432: ,p_sf_core_objects in pay_element_template_util.t_core_objects
1433: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
1434: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
1435: ) is
1436: l_proc varchar2(72) := g_package||'gen_element_types';

Line 1433: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects

1429: ,p_legislation_code in varchar2
1430: ,p_base_processing_priority in number
1431: ,p_element_types in pay_element_template_util.t_element_types
1432: ,p_sf_core_objects in pay_element_template_util.t_core_objects
1433: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
1434: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
1435: ) is
1436: l_proc varchar2(72) := g_package||'gen_element_types';
1437: l_shadow_object_id number;

Line 1434: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects

1430: ,p_base_processing_priority in number
1431: ,p_element_types in pay_element_template_util.t_element_types
1432: ,p_sf_core_objects in pay_element_template_util.t_core_objects
1433: ,p_set_core_objects in out nocopy pay_element_template_util.t_core_objects
1434: ,p_spr_core_objects in out nocopy pay_element_template_util.t_core_objects
1435: ) is
1436: l_proc varchar2(72) := g_package||'gen_element_types';
1437: l_shadow_object_id number;
1438: i number;

Line 1781: ,p_all_core_objects in pay_element_template_util.t_core_objects

1777: (p_effective_date in date
1778: ,p_template_id in number
1779: ,p_business_group_id in number
1780: ,p_legislation_code in varchar2
1781: ,p_all_core_objects in pay_element_template_util.t_core_objects
1782: ,p_set_core_objects in pay_element_template_util.t_core_objects
1783: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules
1784: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
1785: ) is

Line 1782: ,p_set_core_objects in pay_element_template_util.t_core_objects

1778: ,p_template_id in number
1779: ,p_business_group_id in number
1780: ,p_legislation_code in varchar2
1781: ,p_all_core_objects in pay_element_template_util.t_core_objects
1782: ,p_set_core_objects in pay_element_template_util.t_core_objects
1783: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules
1784: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
1785: ) is
1786: l_proc varchar2(72) := g_package||'implicit_sub_classi_rules';

Line 1783: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules

1779: ,p_business_group_id in number
1780: ,p_legislation_code in varchar2
1781: ,p_all_core_objects in pay_element_template_util.t_core_objects
1782: ,p_set_core_objects in pay_element_template_util.t_core_objects
1783: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules
1784: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
1785: ) is
1786: l_proc varchar2(72) := g_package||'implicit_sub_classi_rules';
1787: i number;

Line 1784: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects

1780: ,p_legislation_code in varchar2
1781: ,p_all_core_objects in pay_element_template_util.t_core_objects
1782: ,p_set_core_objects in pay_element_template_util.t_core_objects
1783: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules
1784: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
1785: ) is
1786: l_proc varchar2(72) := g_package||'implicit_sub_classi_rules';
1787: i number;
1788: l_shadow_object_id number;

Line 1878: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules

1874: (p_effective_date in date
1875: ,p_template_id in number
1876: ,p_business_group_id in number
1877: ,p_legislation_code in varchar2
1878: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules
1879: ,p_set_core_objects in pay_element_template_util.t_core_objects
1880: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
1881: ) is
1882: l_proc varchar2(72) := g_package||'gen_sub_classi_rules';

Line 1879: ,p_set_core_objects in pay_element_template_util.t_core_objects

1875: ,p_template_id in number
1876: ,p_business_group_id in number
1877: ,p_legislation_code in varchar2
1878: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules
1879: ,p_set_core_objects in pay_element_template_util.t_core_objects
1880: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
1881: ) is
1882: l_proc varchar2(72) := g_package||'gen_sub_classi_rules';
1883: l_shadow_object_id number;

Line 1880: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects

1876: ,p_business_group_id in number
1877: ,p_legislation_code in varchar2
1878: ,p_sub_classi_rules in pay_element_template_util.t_sub_classi_rules
1879: ,p_set_core_objects in pay_element_template_util.t_core_objects
1880: ,p_ssr_core_objects in out nocopy pay_element_template_util.t_core_objects
1881: ) is
1882: l_proc varchar2(72) := g_package||'gen_sub_classi_rules';
1883: l_shadow_object_id number;
1884: i number;

Line 1974: ,p_balance_classis in pay_element_template_util.t_balance_classis

1970: (p_effective_date in date
1971: ,p_template_id in number
1972: ,p_business_group_id in number
1973: ,p_legislation_code in varchar2
1974: ,p_balance_classis in pay_element_template_util.t_balance_classis
1975: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
1976: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
1977: ) is
1978: l_proc varchar2(72) := g_package||'gen_balance_classis';

Line 1975: ,p_sbt_core_objects in pay_element_template_util.t_core_objects

1971: ,p_template_id in number
1972: ,p_business_group_id in number
1973: ,p_legislation_code in varchar2
1974: ,p_balance_classis in pay_element_template_util.t_balance_classis
1975: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
1976: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
1977: ) is
1978: l_proc varchar2(72) := g_package||'gen_balance_classis';
1979: l_shadow_object_id number;

Line 1976: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects

1972: ,p_business_group_id in number
1973: ,p_legislation_code in varchar2
1974: ,p_balance_classis in pay_element_template_util.t_balance_classis
1975: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
1976: ,p_sbc_core_objects in out nocopy pay_element_template_util.t_core_objects
1977: ) is
1978: l_proc varchar2(72) := g_package||'gen_balance_classis';
1979: l_shadow_object_id number;
1980: i number;

Line 2062: ,p_all_core_objects in pay_element_template_util.t_core_objects

2058: -- ----------------------------------------------------------------------------
2059: procedure implicit_input_values
2060: (p_effective_date in date
2061: ,p_template_id in number
2062: ,p_all_core_objects in pay_element_template_util.t_core_objects
2063: ,p_set_core_objects in pay_element_template_util.t_core_objects
2064: ,p_input_values in pay_element_template_util.t_input_values
2065: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
2066: ) is

Line 2063: ,p_set_core_objects in pay_element_template_util.t_core_objects

2059: procedure implicit_input_values
2060: (p_effective_date in date
2061: ,p_template_id in number
2062: ,p_all_core_objects in pay_element_template_util.t_core_objects
2063: ,p_set_core_objects in pay_element_template_util.t_core_objects
2064: ,p_input_values in pay_element_template_util.t_input_values
2065: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
2066: ) is
2067: l_proc varchar2(72) := g_package||'implicit_input_values';

Line 2064: ,p_input_values in pay_element_template_util.t_input_values

2060: (p_effective_date in date
2061: ,p_template_id in number
2062: ,p_all_core_objects in pay_element_template_util.t_core_objects
2063: ,p_set_core_objects in pay_element_template_util.t_core_objects
2064: ,p_input_values in pay_element_template_util.t_input_values
2065: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
2066: ) is
2067: l_proc varchar2(72) := g_package||'implicit_input_values';
2068: i number;

Line 2065: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects

2061: ,p_template_id in number
2062: ,p_all_core_objects in pay_element_template_util.t_core_objects
2063: ,p_set_core_objects in pay_element_template_util.t_core_objects
2064: ,p_input_values in pay_element_template_util.t_input_values
2065: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
2066: ) is
2067: l_proc varchar2(72) := g_package||'implicit_input_values';
2068: i number;
2069: l_shadow_element_type_id number;

Line 2200: ,p_input_values in pay_element_template_util.t_input_values

2196: (p_effective_date in date
2197: ,p_template_id in number
2198: ,p_business_group_id in number
2199: ,p_legislation_code in varchar2
2200: ,p_input_values in pay_element_template_util.t_input_values
2201: ,p_set_core_objects in pay_element_template_util.t_core_objects
2202: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2203: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
2204: ) is

Line 2201: ,p_set_core_objects in pay_element_template_util.t_core_objects

2197: ,p_template_id in number
2198: ,p_business_group_id in number
2199: ,p_legislation_code in varchar2
2200: ,p_input_values in pay_element_template_util.t_input_values
2201: ,p_set_core_objects in pay_element_template_util.t_core_objects
2202: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2203: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
2204: ) is
2205: l_proc varchar2(72) := g_package||'gen_input_values';

Line 2202: ,p_sf_core_objects in pay_element_template_util.t_core_objects

2198: ,p_business_group_id in number
2199: ,p_legislation_code in varchar2
2200: ,p_input_values in pay_element_template_util.t_input_values
2201: ,p_set_core_objects in pay_element_template_util.t_core_objects
2202: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2203: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
2204: ) is
2205: l_proc varchar2(72) := g_package||'gen_input_values';
2206: l_shadow_object_id number;

Line 2203: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects

2199: ,p_legislation_code in varchar2
2200: ,p_input_values in pay_element_template_util.t_input_values
2201: ,p_set_core_objects in pay_element_template_util.t_core_objects
2202: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2203: ,p_siv_core_objects in out nocopy pay_element_template_util.t_core_objects
2204: ) is
2205: l_proc varchar2(72) := g_package||'gen_input_values';
2206: l_shadow_object_id number;
2207: i number;

Line 2328: ,p_balance_feeds in pay_element_template_util.t_balance_feeds

2324: (p_effective_date in date
2325: ,p_template_id in number
2326: ,p_business_group_id in number
2327: ,p_legislation_code in varchar2
2328: ,p_balance_feeds in pay_element_template_util.t_balance_feeds
2329: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
2330: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2331: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
2332: ) is

Line 2329: ,p_sbt_core_objects in pay_element_template_util.t_core_objects

2325: ,p_template_id in number
2326: ,p_business_group_id in number
2327: ,p_legislation_code in varchar2
2328: ,p_balance_feeds in pay_element_template_util.t_balance_feeds
2329: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
2330: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2331: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
2332: ) is
2333: l_proc varchar2(72) := g_package||'gen_balance_feeds';

Line 2330: ,p_siv_core_objects in pay_element_template_util.t_core_objects

2326: ,p_business_group_id in number
2327: ,p_legislation_code in varchar2
2328: ,p_balance_feeds in pay_element_template_util.t_balance_feeds
2329: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
2330: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2331: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
2332: ) is
2333: l_proc varchar2(72) := g_package||'gen_balance_feeds';
2334: l_shadow_object_id number;

Line 2331: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects

2327: ,p_legislation_code in varchar2
2328: ,p_balance_feeds in pay_element_template_util.t_balance_feeds
2329: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
2330: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2331: ,p_sbf_core_objects in out nocopy pay_element_template_util.t_core_objects
2332: ) is
2333: l_proc varchar2(72) := g_package||'gen_balance_feeds';
2334: l_shadow_object_id number;
2335: i number;

Line 2455: ,p_formula_rules in pay_element_template_util.t_formula_rules

2451: (p_effective_date in date
2452: ,p_template_id in number
2453: ,p_business_group_id in number
2454: ,p_legislation_code in varchar2
2455: ,p_formula_rules in pay_element_template_util.t_formula_rules
2456: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2457: ,p_set_core_objects in pay_element_template_util.t_core_objects
2458: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2459: ,p_spr_core_objects in pay_element_template_util.t_core_objects

Line 2456: ,p_sf_core_objects in pay_element_template_util.t_core_objects

2452: ,p_template_id in number
2453: ,p_business_group_id in number
2454: ,p_legislation_code in varchar2
2455: ,p_formula_rules in pay_element_template_util.t_formula_rules
2456: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2457: ,p_set_core_objects in pay_element_template_util.t_core_objects
2458: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2459: ,p_spr_core_objects in pay_element_template_util.t_core_objects
2460: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects

Line 2457: ,p_set_core_objects in pay_element_template_util.t_core_objects

2453: ,p_business_group_id in number
2454: ,p_legislation_code in varchar2
2455: ,p_formula_rules in pay_element_template_util.t_formula_rules
2456: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2457: ,p_set_core_objects in pay_element_template_util.t_core_objects
2458: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2459: ,p_spr_core_objects in pay_element_template_util.t_core_objects
2460: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
2461: ) is

Line 2458: ,p_siv_core_objects in pay_element_template_util.t_core_objects

2454: ,p_legislation_code in varchar2
2455: ,p_formula_rules in pay_element_template_util.t_formula_rules
2456: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2457: ,p_set_core_objects in pay_element_template_util.t_core_objects
2458: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2459: ,p_spr_core_objects in pay_element_template_util.t_core_objects
2460: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
2461: ) is
2462: l_proc varchar2(72) := g_package||'gen_formula_rules';

Line 2459: ,p_spr_core_objects in pay_element_template_util.t_core_objects

2455: ,p_formula_rules in pay_element_template_util.t_formula_rules
2456: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2457: ,p_set_core_objects in pay_element_template_util.t_core_objects
2458: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2459: ,p_spr_core_objects in pay_element_template_util.t_core_objects
2460: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
2461: ) is
2462: l_proc varchar2(72) := g_package||'gen_formula_rules';
2463: l_shadow_object_id number;

Line 2460: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects

2456: ,p_sf_core_objects in pay_element_template_util.t_core_objects
2457: ,p_set_core_objects in pay_element_template_util.t_core_objects
2458: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2459: ,p_spr_core_objects in pay_element_template_util.t_core_objects
2460: ,p_sfr_core_objects in out nocopy pay_element_template_util.t_core_objects
2461: ) is
2462: l_proc varchar2(72) := g_package||'gen_formula_rules';
2463: l_shadow_object_id number;
2464: i number;

Line 2606: ,p_iterative_rules in pay_element_template_util.t_iterative_rules

2602: procedure gen_iterative_rules
2603: (p_effective_date in date
2604: ,p_template_id in number
2605: ,p_business_group_id in number
2606: ,p_iterative_rules in pay_element_template_util.t_iterative_rules
2607: ,p_set_core_objects in pay_element_template_util.t_core_objects
2608: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2609: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
2610: ) is

Line 2607: ,p_set_core_objects in pay_element_template_util.t_core_objects

2603: (p_effective_date in date
2604: ,p_template_id in number
2605: ,p_business_group_id in number
2606: ,p_iterative_rules in pay_element_template_util.t_iterative_rules
2607: ,p_set_core_objects in pay_element_template_util.t_core_objects
2608: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2609: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
2610: ) is
2611: l_proc varchar2(72) := g_package||'gen_iterative_rules';

Line 2608: ,p_siv_core_objects in pay_element_template_util.t_core_objects

2604: ,p_template_id in number
2605: ,p_business_group_id in number
2606: ,p_iterative_rules in pay_element_template_util.t_iterative_rules
2607: ,p_set_core_objects in pay_element_template_util.t_core_objects
2608: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2609: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
2610: ) is
2611: l_proc varchar2(72) := g_package||'gen_iterative_rules';
2612: l_shadow_object_id number;

Line 2609: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects

2605: ,p_business_group_id in number
2606: ,p_iterative_rules in pay_element_template_util.t_iterative_rules
2607: ,p_set_core_objects in pay_element_template_util.t_core_objects
2608: ,p_siv_core_objects in pay_element_template_util.t_core_objects
2609: ,p_sir_core_objects in out nocopy pay_element_template_util.t_core_objects
2610: ) is
2611: l_proc varchar2(72) := g_package||'gen_iterative_rules';
2612: l_shadow_object_id number;
2613: i number;

Line 2730: ,p_ele_type_usages in pay_element_template_util.t_ele_type_usages

2726: (p_effective_date in date
2727: ,p_template_id in number
2728: ,p_business_group_id in number
2729: ,p_legislation_code in varchar2
2730: ,p_ele_type_usages in pay_element_template_util.t_ele_type_usages
2731: ,p_set_core_objects in pay_element_template_util.t_core_objects
2732: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
2733: ) is
2734: l_proc varchar2(72) := g_package||'gen_ele_type_usages';

Line 2731: ,p_set_core_objects in pay_element_template_util.t_core_objects

2727: ,p_template_id in number
2728: ,p_business_group_id in number
2729: ,p_legislation_code in varchar2
2730: ,p_ele_type_usages in pay_element_template_util.t_ele_type_usages
2731: ,p_set_core_objects in pay_element_template_util.t_core_objects
2732: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
2733: ) is
2734: l_proc varchar2(72) := g_package||'gen_ele_type_usages';
2735: l_shadow_object_id number;

Line 2732: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects

2728: ,p_business_group_id in number
2729: ,p_legislation_code in varchar2
2730: ,p_ele_type_usages in pay_element_template_util.t_ele_type_usages
2731: ,p_set_core_objects in pay_element_template_util.t_core_objects
2732: ,p_seu_core_objects in out nocopy pay_element_template_util.t_core_objects
2733: ) is
2734: l_proc varchar2(72) := g_package||'gen_ele_type_usages';
2735: l_shadow_object_id number;
2736: i number;

Line 2826: ,p_gu_bal_exclusions in pay_element_template_util.t_gu_bal_exclusions

2822: (p_effective_date in date
2823: ,p_template_id in number
2824: ,p_business_group_id in number
2825: ,p_legislation_code in varchar2
2826: ,p_gu_bal_exclusions in pay_element_template_util.t_gu_bal_exclusions
2827: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
2828: ,p_set_core_objects in pay_element_template_util.t_core_objects
2829: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
2830: ) is

Line 2827: ,p_sbt_core_objects in pay_element_template_util.t_core_objects

2823: ,p_template_id in number
2824: ,p_business_group_id in number
2825: ,p_legislation_code in varchar2
2826: ,p_gu_bal_exclusions in pay_element_template_util.t_gu_bal_exclusions
2827: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
2828: ,p_set_core_objects in pay_element_template_util.t_core_objects
2829: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
2830: ) is
2831: l_proc varchar2(72) := g_package||'gen_gu_bal_exclusions';

Line 2828: ,p_set_core_objects in pay_element_template_util.t_core_objects

2824: ,p_business_group_id in number
2825: ,p_legislation_code in varchar2
2826: ,p_gu_bal_exclusions in pay_element_template_util.t_gu_bal_exclusions
2827: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
2828: ,p_set_core_objects in pay_element_template_util.t_core_objects
2829: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
2830: ) is
2831: l_proc varchar2(72) := g_package||'gen_gu_bal_exclusions';
2832: l_shadow_object_id number;

Line 2829: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects

2825: ,p_legislation_code in varchar2
2826: ,p_gu_bal_exclusions in pay_element_template_util.t_gu_bal_exclusions
2827: ,p_sbt_core_objects in pay_element_template_util.t_core_objects
2828: ,p_set_core_objects in pay_element_template_util.t_core_objects
2829: ,p_sgb_core_objects in out nocopy pay_element_template_util.t_core_objects
2830: ) is
2831: l_proc varchar2(72) := g_package||'gen_gu_bal_exclusions';
2832: l_shadow_object_id number;
2833: i number;

Line 2952: ,p_bal_attributes in pay_element_template_util.t_bal_attributes

2948: (p_effective_date in date
2949: ,p_template_id in number
2950: ,p_business_group_id in number
2951: ,p_legislation_code in varchar2
2952: ,p_bal_attributes in pay_element_template_util.t_bal_attributes
2953: ,p_sdb_core_objects in pay_element_template_util.t_core_objects
2954: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects
2955: ) is
2956: l_proc varchar2(72) := g_package||'gen_balance_attributes';

Line 2953: ,p_sdb_core_objects in pay_element_template_util.t_core_objects

2949: ,p_template_id in number
2950: ,p_business_group_id in number
2951: ,p_legislation_code in varchar2
2952: ,p_bal_attributes in pay_element_template_util.t_bal_attributes
2953: ,p_sdb_core_objects in pay_element_template_util.t_core_objects
2954: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects
2955: ) is
2956: l_proc varchar2(72) := g_package||'gen_balance_attributes';
2957: l_shadow_object_id number;

Line 2954: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects

2950: ,p_business_group_id in number
2951: ,p_legislation_code in varchar2
2952: ,p_bal_attributes in pay_element_template_util.t_bal_attributes
2953: ,p_sdb_core_objects in pay_element_template_util.t_core_objects
2954: ,p_sba_core_objects in out nocopy pay_element_template_util.t_core_objects
2955: ) is
2956: l_proc varchar2(72) := g_package||'gen_balance_attributes';
2957: l_shadow_object_id number;
2958: i number;

Line 3042: l_exclusion_rules pay_element_template_util.t_exclusion_rules;

3038: -----------------------------
3039: -- PL/SQL template tables. --
3040: -----------------------------
3041: l_element_template pay_etm_shd.g_rec_type;
3042: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3043: l_formulas pay_element_template_util.t_formulas;
3044: l_balance_types pay_element_template_util.t_balance_types;
3045: l_defined_balances pay_element_template_util.t_defined_balances;
3046: l_element_types pay_element_template_util.t_element_types;

Line 3043: l_formulas pay_element_template_util.t_formulas;

3039: -- PL/SQL template tables. --
3040: -----------------------------
3041: l_element_template pay_etm_shd.g_rec_type;
3042: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3043: l_formulas pay_element_template_util.t_formulas;
3044: l_balance_types pay_element_template_util.t_balance_types;
3045: l_defined_balances pay_element_template_util.t_defined_balances;
3046: l_element_types pay_element_template_util.t_element_types;
3047: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;

Line 3044: l_balance_types pay_element_template_util.t_balance_types;

3040: -----------------------------
3041: l_element_template pay_etm_shd.g_rec_type;
3042: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3043: l_formulas pay_element_template_util.t_formulas;
3044: l_balance_types pay_element_template_util.t_balance_types;
3045: l_defined_balances pay_element_template_util.t_defined_balances;
3046: l_element_types pay_element_template_util.t_element_types;
3047: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3048: l_balance_classis pay_element_template_util.t_balance_classis;

Line 3045: l_defined_balances pay_element_template_util.t_defined_balances;

3041: l_element_template pay_etm_shd.g_rec_type;
3042: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3043: l_formulas pay_element_template_util.t_formulas;
3044: l_balance_types pay_element_template_util.t_balance_types;
3045: l_defined_balances pay_element_template_util.t_defined_balances;
3046: l_element_types pay_element_template_util.t_element_types;
3047: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3048: l_balance_classis pay_element_template_util.t_balance_classis;
3049: l_input_values pay_element_template_util.t_input_values;

Line 3046: l_element_types pay_element_template_util.t_element_types;

3042: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3043: l_formulas pay_element_template_util.t_formulas;
3044: l_balance_types pay_element_template_util.t_balance_types;
3045: l_defined_balances pay_element_template_util.t_defined_balances;
3046: l_element_types pay_element_template_util.t_element_types;
3047: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3048: l_balance_classis pay_element_template_util.t_balance_classis;
3049: l_input_values pay_element_template_util.t_input_values;
3050: l_balance_feeds pay_element_template_util.t_balance_feeds;

Line 3047: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;

3043: l_formulas pay_element_template_util.t_formulas;
3044: l_balance_types pay_element_template_util.t_balance_types;
3045: l_defined_balances pay_element_template_util.t_defined_balances;
3046: l_element_types pay_element_template_util.t_element_types;
3047: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3048: l_balance_classis pay_element_template_util.t_balance_classis;
3049: l_input_values pay_element_template_util.t_input_values;
3050: l_balance_feeds pay_element_template_util.t_balance_feeds;
3051: l_formula_rules pay_element_template_util.t_formula_rules;

Line 3048: l_balance_classis pay_element_template_util.t_balance_classis;

3044: l_balance_types pay_element_template_util.t_balance_types;
3045: l_defined_balances pay_element_template_util.t_defined_balances;
3046: l_element_types pay_element_template_util.t_element_types;
3047: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3048: l_balance_classis pay_element_template_util.t_balance_classis;
3049: l_input_values pay_element_template_util.t_input_values;
3050: l_balance_feeds pay_element_template_util.t_balance_feeds;
3051: l_formula_rules pay_element_template_util.t_formula_rules;
3052: l_iterative_rules pay_element_template_util.t_iterative_rules;

Line 3049: l_input_values pay_element_template_util.t_input_values;

3045: l_defined_balances pay_element_template_util.t_defined_balances;
3046: l_element_types pay_element_template_util.t_element_types;
3047: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3048: l_balance_classis pay_element_template_util.t_balance_classis;
3049: l_input_values pay_element_template_util.t_input_values;
3050: l_balance_feeds pay_element_template_util.t_balance_feeds;
3051: l_formula_rules pay_element_template_util.t_formula_rules;
3052: l_iterative_rules pay_element_template_util.t_iterative_rules;
3053: l_ele_type_usages pay_element_template_util.t_ele_type_usages;

Line 3050: l_balance_feeds pay_element_template_util.t_balance_feeds;

3046: l_element_types pay_element_template_util.t_element_types;
3047: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3048: l_balance_classis pay_element_template_util.t_balance_classis;
3049: l_input_values pay_element_template_util.t_input_values;
3050: l_balance_feeds pay_element_template_util.t_balance_feeds;
3051: l_formula_rules pay_element_template_util.t_formula_rules;
3052: l_iterative_rules pay_element_template_util.t_iterative_rules;
3053: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3054: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;

Line 3051: l_formula_rules pay_element_template_util.t_formula_rules;

3047: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3048: l_balance_classis pay_element_template_util.t_balance_classis;
3049: l_input_values pay_element_template_util.t_input_values;
3050: l_balance_feeds pay_element_template_util.t_balance_feeds;
3051: l_formula_rules pay_element_template_util.t_formula_rules;
3052: l_iterative_rules pay_element_template_util.t_iterative_rules;
3053: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3054: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3055: l_bal_attributes pay_element_template_util.t_bal_attributes;

Line 3052: l_iterative_rules pay_element_template_util.t_iterative_rules;

3048: l_balance_classis pay_element_template_util.t_balance_classis;
3049: l_input_values pay_element_template_util.t_input_values;
3050: l_balance_feeds pay_element_template_util.t_balance_feeds;
3051: l_formula_rules pay_element_template_util.t_formula_rules;
3052: l_iterative_rules pay_element_template_util.t_iterative_rules;
3053: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3054: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3055: l_bal_attributes pay_element_template_util.t_bal_attributes;
3056: l_template_ff_usages pay_element_template_util.t_template_ff_usages;

Line 3053: l_ele_type_usages pay_element_template_util.t_ele_type_usages;

3049: l_input_values pay_element_template_util.t_input_values;
3050: l_balance_feeds pay_element_template_util.t_balance_feeds;
3051: l_formula_rules pay_element_template_util.t_formula_rules;
3052: l_iterative_rules pay_element_template_util.t_iterative_rules;
3053: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3054: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3055: l_bal_attributes pay_element_template_util.t_bal_attributes;
3056: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3057: ------------------------

Line 3054: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;

3050: l_balance_feeds pay_element_template_util.t_balance_feeds;
3051: l_formula_rules pay_element_template_util.t_formula_rules;
3052: l_iterative_rules pay_element_template_util.t_iterative_rules;
3053: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3054: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3055: l_bal_attributes pay_element_template_util.t_bal_attributes;
3056: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3057: ------------------------
3058: -- Generation tables. --

Line 3055: l_bal_attributes pay_element_template_util.t_bal_attributes;

3051: l_formula_rules pay_element_template_util.t_formula_rules;
3052: l_iterative_rules pay_element_template_util.t_iterative_rules;
3053: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3054: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3055: l_bal_attributes pay_element_template_util.t_bal_attributes;
3056: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3057: ------------------------
3058: -- Generation tables. --
3059: ------------------------

Line 3056: l_template_ff_usages pay_element_template_util.t_template_ff_usages;

3052: l_iterative_rules pay_element_template_util.t_iterative_rules;
3053: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3054: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3055: l_bal_attributes pay_element_template_util.t_bal_attributes;
3056: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3057: ------------------------
3058: -- Generation tables. --
3059: ------------------------
3060: l_all_core_objects pay_element_template_util.t_core_objects;

Line 3060: l_all_core_objects pay_element_template_util.t_core_objects;

3056: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3057: ------------------------
3058: -- Generation tables. --
3059: ------------------------
3060: l_all_core_objects pay_element_template_util.t_core_objects;
3061: l_sf_core_objects pay_element_template_util.t_core_objects;
3062: l_sbt_core_objects pay_element_template_util.t_core_objects;
3063: l_sdb_core_objects pay_element_template_util.t_core_objects;
3064: l_set_core_objects pay_element_template_util.t_core_objects;

Line 3061: l_sf_core_objects pay_element_template_util.t_core_objects;

3057: ------------------------
3058: -- Generation tables. --
3059: ------------------------
3060: l_all_core_objects pay_element_template_util.t_core_objects;
3061: l_sf_core_objects pay_element_template_util.t_core_objects;
3062: l_sbt_core_objects pay_element_template_util.t_core_objects;
3063: l_sdb_core_objects pay_element_template_util.t_core_objects;
3064: l_set_core_objects pay_element_template_util.t_core_objects;
3065: l_ssr_core_objects pay_element_template_util.t_core_objects;

Line 3062: l_sbt_core_objects pay_element_template_util.t_core_objects;

3058: -- Generation tables. --
3059: ------------------------
3060: l_all_core_objects pay_element_template_util.t_core_objects;
3061: l_sf_core_objects pay_element_template_util.t_core_objects;
3062: l_sbt_core_objects pay_element_template_util.t_core_objects;
3063: l_sdb_core_objects pay_element_template_util.t_core_objects;
3064: l_set_core_objects pay_element_template_util.t_core_objects;
3065: l_ssr_core_objects pay_element_template_util.t_core_objects;
3066: l_sbc_core_objects pay_element_template_util.t_core_objects;

Line 3063: l_sdb_core_objects pay_element_template_util.t_core_objects;

3059: ------------------------
3060: l_all_core_objects pay_element_template_util.t_core_objects;
3061: l_sf_core_objects pay_element_template_util.t_core_objects;
3062: l_sbt_core_objects pay_element_template_util.t_core_objects;
3063: l_sdb_core_objects pay_element_template_util.t_core_objects;
3064: l_set_core_objects pay_element_template_util.t_core_objects;
3065: l_ssr_core_objects pay_element_template_util.t_core_objects;
3066: l_sbc_core_objects pay_element_template_util.t_core_objects;
3067: l_siv_core_objects pay_element_template_util.t_core_objects;

Line 3064: l_set_core_objects pay_element_template_util.t_core_objects;

3060: l_all_core_objects pay_element_template_util.t_core_objects;
3061: l_sf_core_objects pay_element_template_util.t_core_objects;
3062: l_sbt_core_objects pay_element_template_util.t_core_objects;
3063: l_sdb_core_objects pay_element_template_util.t_core_objects;
3064: l_set_core_objects pay_element_template_util.t_core_objects;
3065: l_ssr_core_objects pay_element_template_util.t_core_objects;
3066: l_sbc_core_objects pay_element_template_util.t_core_objects;
3067: l_siv_core_objects pay_element_template_util.t_core_objects;
3068: l_sbf_core_objects pay_element_template_util.t_core_objects;

Line 3065: l_ssr_core_objects pay_element_template_util.t_core_objects;

3061: l_sf_core_objects pay_element_template_util.t_core_objects;
3062: l_sbt_core_objects pay_element_template_util.t_core_objects;
3063: l_sdb_core_objects pay_element_template_util.t_core_objects;
3064: l_set_core_objects pay_element_template_util.t_core_objects;
3065: l_ssr_core_objects pay_element_template_util.t_core_objects;
3066: l_sbc_core_objects pay_element_template_util.t_core_objects;
3067: l_siv_core_objects pay_element_template_util.t_core_objects;
3068: l_sbf_core_objects pay_element_template_util.t_core_objects;
3069: l_spr_core_objects pay_element_template_util.t_core_objects;

Line 3066: l_sbc_core_objects pay_element_template_util.t_core_objects;

3062: l_sbt_core_objects pay_element_template_util.t_core_objects;
3063: l_sdb_core_objects pay_element_template_util.t_core_objects;
3064: l_set_core_objects pay_element_template_util.t_core_objects;
3065: l_ssr_core_objects pay_element_template_util.t_core_objects;
3066: l_sbc_core_objects pay_element_template_util.t_core_objects;
3067: l_siv_core_objects pay_element_template_util.t_core_objects;
3068: l_sbf_core_objects pay_element_template_util.t_core_objects;
3069: l_spr_core_objects pay_element_template_util.t_core_objects;
3070: l_sfr_core_objects pay_element_template_util.t_core_objects;

Line 3067: l_siv_core_objects pay_element_template_util.t_core_objects;

3063: l_sdb_core_objects pay_element_template_util.t_core_objects;
3064: l_set_core_objects pay_element_template_util.t_core_objects;
3065: l_ssr_core_objects pay_element_template_util.t_core_objects;
3066: l_sbc_core_objects pay_element_template_util.t_core_objects;
3067: l_siv_core_objects pay_element_template_util.t_core_objects;
3068: l_sbf_core_objects pay_element_template_util.t_core_objects;
3069: l_spr_core_objects pay_element_template_util.t_core_objects;
3070: l_sfr_core_objects pay_element_template_util.t_core_objects;
3071: l_sir_core_objects pay_element_template_util.t_core_objects;

Line 3068: l_sbf_core_objects pay_element_template_util.t_core_objects;

3064: l_set_core_objects pay_element_template_util.t_core_objects;
3065: l_ssr_core_objects pay_element_template_util.t_core_objects;
3066: l_sbc_core_objects pay_element_template_util.t_core_objects;
3067: l_siv_core_objects pay_element_template_util.t_core_objects;
3068: l_sbf_core_objects pay_element_template_util.t_core_objects;
3069: l_spr_core_objects pay_element_template_util.t_core_objects;
3070: l_sfr_core_objects pay_element_template_util.t_core_objects;
3071: l_sir_core_objects pay_element_template_util.t_core_objects;
3072: l_seu_core_objects pay_element_template_util.t_core_objects;

Line 3069: l_spr_core_objects pay_element_template_util.t_core_objects;

3065: l_ssr_core_objects pay_element_template_util.t_core_objects;
3066: l_sbc_core_objects pay_element_template_util.t_core_objects;
3067: l_siv_core_objects pay_element_template_util.t_core_objects;
3068: l_sbf_core_objects pay_element_template_util.t_core_objects;
3069: l_spr_core_objects pay_element_template_util.t_core_objects;
3070: l_sfr_core_objects pay_element_template_util.t_core_objects;
3071: l_sir_core_objects pay_element_template_util.t_core_objects;
3072: l_seu_core_objects pay_element_template_util.t_core_objects;
3073: l_sgb_core_objects pay_element_template_util.t_core_objects;

Line 3070: l_sfr_core_objects pay_element_template_util.t_core_objects;

3066: l_sbc_core_objects pay_element_template_util.t_core_objects;
3067: l_siv_core_objects pay_element_template_util.t_core_objects;
3068: l_sbf_core_objects pay_element_template_util.t_core_objects;
3069: l_spr_core_objects pay_element_template_util.t_core_objects;
3070: l_sfr_core_objects pay_element_template_util.t_core_objects;
3071: l_sir_core_objects pay_element_template_util.t_core_objects;
3072: l_seu_core_objects pay_element_template_util.t_core_objects;
3073: l_sgb_core_objects pay_element_template_util.t_core_objects;
3074: l_sba_core_objects pay_element_template_util.t_core_objects;

Line 3071: l_sir_core_objects pay_element_template_util.t_core_objects;

3067: l_siv_core_objects pay_element_template_util.t_core_objects;
3068: l_sbf_core_objects pay_element_template_util.t_core_objects;
3069: l_spr_core_objects pay_element_template_util.t_core_objects;
3070: l_sfr_core_objects pay_element_template_util.t_core_objects;
3071: l_sir_core_objects pay_element_template_util.t_core_objects;
3072: l_seu_core_objects pay_element_template_util.t_core_objects;
3073: l_sgb_core_objects pay_element_template_util.t_core_objects;
3074: l_sba_core_objects pay_element_template_util.t_core_objects;
3075: begin

Line 3072: l_seu_core_objects pay_element_template_util.t_core_objects;

3068: l_sbf_core_objects pay_element_template_util.t_core_objects;
3069: l_spr_core_objects pay_element_template_util.t_core_objects;
3070: l_sfr_core_objects pay_element_template_util.t_core_objects;
3071: l_sir_core_objects pay_element_template_util.t_core_objects;
3072: l_seu_core_objects pay_element_template_util.t_core_objects;
3073: l_sgb_core_objects pay_element_template_util.t_core_objects;
3074: l_sba_core_objects pay_element_template_util.t_core_objects;
3075: begin
3076: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3073: l_sgb_core_objects pay_element_template_util.t_core_objects;

3069: l_spr_core_objects pay_element_template_util.t_core_objects;
3070: l_sfr_core_objects pay_element_template_util.t_core_objects;
3071: l_sir_core_objects pay_element_template_util.t_core_objects;
3072: l_seu_core_objects pay_element_template_util.t_core_objects;
3073: l_sgb_core_objects pay_element_template_util.t_core_objects;
3074: l_sba_core_objects pay_element_template_util.t_core_objects;
3075: begin
3076: hr_utility.set_location('Entering:'|| l_proc, 10);
3077: ----------------------------------------------

Line 3074: l_sba_core_objects pay_element_template_util.t_core_objects;

3070: l_sfr_core_objects pay_element_template_util.t_core_objects;
3071: l_sir_core_objects pay_element_template_util.t_core_objects;
3072: l_seu_core_objects pay_element_template_util.t_core_objects;
3073: l_sgb_core_objects pay_element_template_util.t_core_objects;
3074: l_sba_core_objects pay_element_template_util.t_core_objects;
3075: begin
3076: hr_utility.set_location('Entering:'|| l_proc, 10);
3077: ----------------------------------------------
3078: -- Check that the template type is correct. --

Line 3081: pay_element_template_util.get_template_type(p_template_id);

3077: ----------------------------------------------
3078: -- Check that the template type is correct. --
3079: ----------------------------------------------
3080: l_template_type :=
3081: pay_element_template_util.get_template_type(p_template_id);
3082: if l_template_type is null or l_template_type <> 'U' then
3083: hr_utility.set_message(801, 'PAY_50065_BAD_USER_TEMPLATE');
3084: hr_utility.raise_error;
3085: end if;

Line 3089: pay_element_template_util.create_plsql_template

3085: end if;
3086: ---------------------------------------
3087: -- Read in the template information. --
3088: ---------------------------------------
3089: pay_element_template_util.create_plsql_template
3090: (p_template_id => p_template_id
3091: ,p_generate_part1 => true
3092: ,p_core_objects => l_all_core_objects
3093: ,p_element_template => l_element_template

Line 3337: l_exclusion_rules pay_element_template_util.t_exclusion_rules;

3333: -----------------------------
3334: -- PL/SQL template tables. --
3335: -----------------------------
3336: l_element_template pay_etm_shd.g_rec_type;
3337: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3338: l_formulas pay_element_template_util.t_formulas;
3339: l_balance_types pay_element_template_util.t_balance_types;
3340: l_defined_balances pay_element_template_util.t_defined_balances;
3341: l_element_types pay_element_template_util.t_element_types;

Line 3338: l_formulas pay_element_template_util.t_formulas;

3334: -- PL/SQL template tables. --
3335: -----------------------------
3336: l_element_template pay_etm_shd.g_rec_type;
3337: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3338: l_formulas pay_element_template_util.t_formulas;
3339: l_balance_types pay_element_template_util.t_balance_types;
3340: l_defined_balances pay_element_template_util.t_defined_balances;
3341: l_element_types pay_element_template_util.t_element_types;
3342: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;

Line 3339: l_balance_types pay_element_template_util.t_balance_types;

3335: -----------------------------
3336: l_element_template pay_etm_shd.g_rec_type;
3337: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3338: l_formulas pay_element_template_util.t_formulas;
3339: l_balance_types pay_element_template_util.t_balance_types;
3340: l_defined_balances pay_element_template_util.t_defined_balances;
3341: l_element_types pay_element_template_util.t_element_types;
3342: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3343: l_balance_classis pay_element_template_util.t_balance_classis;

Line 3340: l_defined_balances pay_element_template_util.t_defined_balances;

3336: l_element_template pay_etm_shd.g_rec_type;
3337: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3338: l_formulas pay_element_template_util.t_formulas;
3339: l_balance_types pay_element_template_util.t_balance_types;
3340: l_defined_balances pay_element_template_util.t_defined_balances;
3341: l_element_types pay_element_template_util.t_element_types;
3342: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3343: l_balance_classis pay_element_template_util.t_balance_classis;
3344: l_input_values pay_element_template_util.t_input_values;

Line 3341: l_element_types pay_element_template_util.t_element_types;

3337: l_exclusion_rules pay_element_template_util.t_exclusion_rules;
3338: l_formulas pay_element_template_util.t_formulas;
3339: l_balance_types pay_element_template_util.t_balance_types;
3340: l_defined_balances pay_element_template_util.t_defined_balances;
3341: l_element_types pay_element_template_util.t_element_types;
3342: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3343: l_balance_classis pay_element_template_util.t_balance_classis;
3344: l_input_values pay_element_template_util.t_input_values;
3345: l_balance_feeds pay_element_template_util.t_balance_feeds;

Line 3342: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;

3338: l_formulas pay_element_template_util.t_formulas;
3339: l_balance_types pay_element_template_util.t_balance_types;
3340: l_defined_balances pay_element_template_util.t_defined_balances;
3341: l_element_types pay_element_template_util.t_element_types;
3342: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3343: l_balance_classis pay_element_template_util.t_balance_classis;
3344: l_input_values pay_element_template_util.t_input_values;
3345: l_balance_feeds pay_element_template_util.t_balance_feeds;
3346: l_formula_rules pay_element_template_util.t_formula_rules;

Line 3343: l_balance_classis pay_element_template_util.t_balance_classis;

3339: l_balance_types pay_element_template_util.t_balance_types;
3340: l_defined_balances pay_element_template_util.t_defined_balances;
3341: l_element_types pay_element_template_util.t_element_types;
3342: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3343: l_balance_classis pay_element_template_util.t_balance_classis;
3344: l_input_values pay_element_template_util.t_input_values;
3345: l_balance_feeds pay_element_template_util.t_balance_feeds;
3346: l_formula_rules pay_element_template_util.t_formula_rules;
3347: l_iterative_rules pay_element_template_util.t_iterative_rules;

Line 3344: l_input_values pay_element_template_util.t_input_values;

3340: l_defined_balances pay_element_template_util.t_defined_balances;
3341: l_element_types pay_element_template_util.t_element_types;
3342: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3343: l_balance_classis pay_element_template_util.t_balance_classis;
3344: l_input_values pay_element_template_util.t_input_values;
3345: l_balance_feeds pay_element_template_util.t_balance_feeds;
3346: l_formula_rules pay_element_template_util.t_formula_rules;
3347: l_iterative_rules pay_element_template_util.t_iterative_rules;
3348: l_ele_type_usages pay_element_template_util.t_ele_type_usages;

Line 3345: l_balance_feeds pay_element_template_util.t_balance_feeds;

3341: l_element_types pay_element_template_util.t_element_types;
3342: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3343: l_balance_classis pay_element_template_util.t_balance_classis;
3344: l_input_values pay_element_template_util.t_input_values;
3345: l_balance_feeds pay_element_template_util.t_balance_feeds;
3346: l_formula_rules pay_element_template_util.t_formula_rules;
3347: l_iterative_rules pay_element_template_util.t_iterative_rules;
3348: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3349: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;

Line 3346: l_formula_rules pay_element_template_util.t_formula_rules;

3342: l_sub_classi_rules pay_element_template_util.t_sub_classi_rules;
3343: l_balance_classis pay_element_template_util.t_balance_classis;
3344: l_input_values pay_element_template_util.t_input_values;
3345: l_balance_feeds pay_element_template_util.t_balance_feeds;
3346: l_formula_rules pay_element_template_util.t_formula_rules;
3347: l_iterative_rules pay_element_template_util.t_iterative_rules;
3348: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3349: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3350: l_template_ff_usages pay_element_template_util.t_template_ff_usages;

Line 3347: l_iterative_rules pay_element_template_util.t_iterative_rules;

3343: l_balance_classis pay_element_template_util.t_balance_classis;
3344: l_input_values pay_element_template_util.t_input_values;
3345: l_balance_feeds pay_element_template_util.t_balance_feeds;
3346: l_formula_rules pay_element_template_util.t_formula_rules;
3347: l_iterative_rules pay_element_template_util.t_iterative_rules;
3348: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3349: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3350: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3351: l_bal_attributes pay_element_template_util.t_bal_attributes;

Line 3348: l_ele_type_usages pay_element_template_util.t_ele_type_usages;

3344: l_input_values pay_element_template_util.t_input_values;
3345: l_balance_feeds pay_element_template_util.t_balance_feeds;
3346: l_formula_rules pay_element_template_util.t_formula_rules;
3347: l_iterative_rules pay_element_template_util.t_iterative_rules;
3348: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3349: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3350: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3351: l_bal_attributes pay_element_template_util.t_bal_attributes;
3352: ------------------------

Line 3349: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;

3345: l_balance_feeds pay_element_template_util.t_balance_feeds;
3346: l_formula_rules pay_element_template_util.t_formula_rules;
3347: l_iterative_rules pay_element_template_util.t_iterative_rules;
3348: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3349: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3350: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3351: l_bal_attributes pay_element_template_util.t_bal_attributes;
3352: ------------------------
3353: -- Generation tables. --

Line 3350: l_template_ff_usages pay_element_template_util.t_template_ff_usages;

3346: l_formula_rules pay_element_template_util.t_formula_rules;
3347: l_iterative_rules pay_element_template_util.t_iterative_rules;
3348: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3349: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3350: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3351: l_bal_attributes pay_element_template_util.t_bal_attributes;
3352: ------------------------
3353: -- Generation tables. --
3354: ------------------------

Line 3351: l_bal_attributes pay_element_template_util.t_bal_attributes;

3347: l_iterative_rules pay_element_template_util.t_iterative_rules;
3348: l_ele_type_usages pay_element_template_util.t_ele_type_usages;
3349: l_gu_bal_exclusions pay_element_template_util.t_gu_bal_exclusions;
3350: l_template_ff_usages pay_element_template_util.t_template_ff_usages;
3351: l_bal_attributes pay_element_template_util.t_bal_attributes;
3352: ------------------------
3353: -- Generation tables. --
3354: ------------------------
3355: l_all_core_objects pay_element_template_util.t_core_objects;

Line 3355: l_all_core_objects pay_element_template_util.t_core_objects;

3351: l_bal_attributes pay_element_template_util.t_bal_attributes;
3352: ------------------------
3353: -- Generation tables. --
3354: ------------------------
3355: l_all_core_objects pay_element_template_util.t_core_objects;
3356: l_sf_core_objects pay_element_template_util.t_core_objects;
3357: l_sbt_core_objects pay_element_template_util.t_core_objects;
3358: l_sdb_core_objects pay_element_template_util.t_core_objects;
3359: l_set_core_objects pay_element_template_util.t_core_objects;

Line 3356: l_sf_core_objects pay_element_template_util.t_core_objects;

3352: ------------------------
3353: -- Generation tables. --
3354: ------------------------
3355: l_all_core_objects pay_element_template_util.t_core_objects;
3356: l_sf_core_objects pay_element_template_util.t_core_objects;
3357: l_sbt_core_objects pay_element_template_util.t_core_objects;
3358: l_sdb_core_objects pay_element_template_util.t_core_objects;
3359: l_set_core_objects pay_element_template_util.t_core_objects;
3360: l_ssr_core_objects pay_element_template_util.t_core_objects;

Line 3357: l_sbt_core_objects pay_element_template_util.t_core_objects;

3353: -- Generation tables. --
3354: ------------------------
3355: l_all_core_objects pay_element_template_util.t_core_objects;
3356: l_sf_core_objects pay_element_template_util.t_core_objects;
3357: l_sbt_core_objects pay_element_template_util.t_core_objects;
3358: l_sdb_core_objects pay_element_template_util.t_core_objects;
3359: l_set_core_objects pay_element_template_util.t_core_objects;
3360: l_ssr_core_objects pay_element_template_util.t_core_objects;
3361: l_sbc_core_objects pay_element_template_util.t_core_objects;

Line 3358: l_sdb_core_objects pay_element_template_util.t_core_objects;

3354: ------------------------
3355: l_all_core_objects pay_element_template_util.t_core_objects;
3356: l_sf_core_objects pay_element_template_util.t_core_objects;
3357: l_sbt_core_objects pay_element_template_util.t_core_objects;
3358: l_sdb_core_objects pay_element_template_util.t_core_objects;
3359: l_set_core_objects pay_element_template_util.t_core_objects;
3360: l_ssr_core_objects pay_element_template_util.t_core_objects;
3361: l_sbc_core_objects pay_element_template_util.t_core_objects;
3362: l_siv_core_objects pay_element_template_util.t_core_objects;

Line 3359: l_set_core_objects pay_element_template_util.t_core_objects;

3355: l_all_core_objects pay_element_template_util.t_core_objects;
3356: l_sf_core_objects pay_element_template_util.t_core_objects;
3357: l_sbt_core_objects pay_element_template_util.t_core_objects;
3358: l_sdb_core_objects pay_element_template_util.t_core_objects;
3359: l_set_core_objects pay_element_template_util.t_core_objects;
3360: l_ssr_core_objects pay_element_template_util.t_core_objects;
3361: l_sbc_core_objects pay_element_template_util.t_core_objects;
3362: l_siv_core_objects pay_element_template_util.t_core_objects;
3363: l_sbf_core_objects pay_element_template_util.t_core_objects;

Line 3360: l_ssr_core_objects pay_element_template_util.t_core_objects;

3356: l_sf_core_objects pay_element_template_util.t_core_objects;
3357: l_sbt_core_objects pay_element_template_util.t_core_objects;
3358: l_sdb_core_objects pay_element_template_util.t_core_objects;
3359: l_set_core_objects pay_element_template_util.t_core_objects;
3360: l_ssr_core_objects pay_element_template_util.t_core_objects;
3361: l_sbc_core_objects pay_element_template_util.t_core_objects;
3362: l_siv_core_objects pay_element_template_util.t_core_objects;
3363: l_sbf_core_objects pay_element_template_util.t_core_objects;
3364: l_spr_core_objects pay_element_template_util.t_core_objects;

Line 3361: l_sbc_core_objects pay_element_template_util.t_core_objects;

3357: l_sbt_core_objects pay_element_template_util.t_core_objects;
3358: l_sdb_core_objects pay_element_template_util.t_core_objects;
3359: l_set_core_objects pay_element_template_util.t_core_objects;
3360: l_ssr_core_objects pay_element_template_util.t_core_objects;
3361: l_sbc_core_objects pay_element_template_util.t_core_objects;
3362: l_siv_core_objects pay_element_template_util.t_core_objects;
3363: l_sbf_core_objects pay_element_template_util.t_core_objects;
3364: l_spr_core_objects pay_element_template_util.t_core_objects;
3365: l_sfr_core_objects pay_element_template_util.t_core_objects;

Line 3362: l_siv_core_objects pay_element_template_util.t_core_objects;

3358: l_sdb_core_objects pay_element_template_util.t_core_objects;
3359: l_set_core_objects pay_element_template_util.t_core_objects;
3360: l_ssr_core_objects pay_element_template_util.t_core_objects;
3361: l_sbc_core_objects pay_element_template_util.t_core_objects;
3362: l_siv_core_objects pay_element_template_util.t_core_objects;
3363: l_sbf_core_objects pay_element_template_util.t_core_objects;
3364: l_spr_core_objects pay_element_template_util.t_core_objects;
3365: l_sfr_core_objects pay_element_template_util.t_core_objects;
3366: l_sir_core_objects pay_element_template_util.t_core_objects;

Line 3363: l_sbf_core_objects pay_element_template_util.t_core_objects;

3359: l_set_core_objects pay_element_template_util.t_core_objects;
3360: l_ssr_core_objects pay_element_template_util.t_core_objects;
3361: l_sbc_core_objects pay_element_template_util.t_core_objects;
3362: l_siv_core_objects pay_element_template_util.t_core_objects;
3363: l_sbf_core_objects pay_element_template_util.t_core_objects;
3364: l_spr_core_objects pay_element_template_util.t_core_objects;
3365: l_sfr_core_objects pay_element_template_util.t_core_objects;
3366: l_sir_core_objects pay_element_template_util.t_core_objects;
3367: l_seu_core_objects pay_element_template_util.t_core_objects;

Line 3364: l_spr_core_objects pay_element_template_util.t_core_objects;

3360: l_ssr_core_objects pay_element_template_util.t_core_objects;
3361: l_sbc_core_objects pay_element_template_util.t_core_objects;
3362: l_siv_core_objects pay_element_template_util.t_core_objects;
3363: l_sbf_core_objects pay_element_template_util.t_core_objects;
3364: l_spr_core_objects pay_element_template_util.t_core_objects;
3365: l_sfr_core_objects pay_element_template_util.t_core_objects;
3366: l_sir_core_objects pay_element_template_util.t_core_objects;
3367: l_seu_core_objects pay_element_template_util.t_core_objects;
3368: l_sgb_core_objects pay_element_template_util.t_core_objects;

Line 3365: l_sfr_core_objects pay_element_template_util.t_core_objects;

3361: l_sbc_core_objects pay_element_template_util.t_core_objects;
3362: l_siv_core_objects pay_element_template_util.t_core_objects;
3363: l_sbf_core_objects pay_element_template_util.t_core_objects;
3364: l_spr_core_objects pay_element_template_util.t_core_objects;
3365: l_sfr_core_objects pay_element_template_util.t_core_objects;
3366: l_sir_core_objects pay_element_template_util.t_core_objects;
3367: l_seu_core_objects pay_element_template_util.t_core_objects;
3368: l_sgb_core_objects pay_element_template_util.t_core_objects;
3369: l_sba_core_objects pay_element_template_util.t_core_objects;

Line 3366: l_sir_core_objects pay_element_template_util.t_core_objects;

3362: l_siv_core_objects pay_element_template_util.t_core_objects;
3363: l_sbf_core_objects pay_element_template_util.t_core_objects;
3364: l_spr_core_objects pay_element_template_util.t_core_objects;
3365: l_sfr_core_objects pay_element_template_util.t_core_objects;
3366: l_sir_core_objects pay_element_template_util.t_core_objects;
3367: l_seu_core_objects pay_element_template_util.t_core_objects;
3368: l_sgb_core_objects pay_element_template_util.t_core_objects;
3369: l_sba_core_objects pay_element_template_util.t_core_objects;
3370: --

Line 3367: l_seu_core_objects pay_element_template_util.t_core_objects;

3363: l_sbf_core_objects pay_element_template_util.t_core_objects;
3364: l_spr_core_objects pay_element_template_util.t_core_objects;
3365: l_sfr_core_objects pay_element_template_util.t_core_objects;
3366: l_sir_core_objects pay_element_template_util.t_core_objects;
3367: l_seu_core_objects pay_element_template_util.t_core_objects;
3368: l_sgb_core_objects pay_element_template_util.t_core_objects;
3369: l_sba_core_objects pay_element_template_util.t_core_objects;
3370: --
3371: begin

Line 3368: l_sgb_core_objects pay_element_template_util.t_core_objects;

3364: l_spr_core_objects pay_element_template_util.t_core_objects;
3365: l_sfr_core_objects pay_element_template_util.t_core_objects;
3366: l_sir_core_objects pay_element_template_util.t_core_objects;
3367: l_seu_core_objects pay_element_template_util.t_core_objects;
3368: l_sgb_core_objects pay_element_template_util.t_core_objects;
3369: l_sba_core_objects pay_element_template_util.t_core_objects;
3370: --
3371: begin
3372: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3369: l_sba_core_objects pay_element_template_util.t_core_objects;

3365: l_sfr_core_objects pay_element_template_util.t_core_objects;
3366: l_sir_core_objects pay_element_template_util.t_core_objects;
3367: l_seu_core_objects pay_element_template_util.t_core_objects;
3368: l_sgb_core_objects pay_element_template_util.t_core_objects;
3369: l_sba_core_objects pay_element_template_util.t_core_objects;
3370: --
3371: begin
3372: hr_utility.set_location('Entering:'|| l_proc, 10);
3373: ----------------------------------------------

Line 3377: pay_element_template_util.get_template_type(p_template_id);

3373: ----------------------------------------------
3374: -- Check that the template type is correct. --
3375: ----------------------------------------------
3376: l_template_type :=
3377: pay_element_template_util.get_template_type(p_template_id);
3378: if l_template_type is null or l_template_type <> 'U' then
3379: hr_utility.set_message(801, 'PAY_50065_BAD_USER_TEMPLATE');
3380: hr_utility.raise_error;
3381: end if;

Line 3385: pay_element_template_util.create_plsql_template

3381: end if;
3382: ---------------------------------------
3383: -- Read in the template information. --
3384: ---------------------------------------
3385: pay_element_template_util.create_plsql_template
3386: (p_template_id => p_template_id
3387: ,p_generate_part2 => true
3388: ,p_element_template => l_element_template
3389: ,p_core_objects => l_all_core_objects

Line 3476: ,p_core_objects in pay_element_template_util.t_core_objects

3472: -- |---------------------------< core_objects_lock >--------------------------|
3473: -- ----------------------------------------------------------------------------
3474: procedure core_objects_lock
3475: (p_core_object_type in varchar2
3476: ,p_core_objects in pay_element_template_util.t_core_objects
3477: ,p_rowid_id_recs in out nocopy t_rowid_id_recs
3478: ,p_id_ovn_recs in out nocopy t_id_ovn_recs
3479: ) is
3480: l_proc varchar2(72) := g_package||'core_objects_lock';

Line 4536: (p_all_core_objects in pay_element_template_util.t_core_objects

4532: -- ----------------------------------------------------------------------------
4533: -- |-----------------------------< zap_core_objects >-------------------------|
4534: -- ----------------------------------------------------------------------------
4535: procedure zap_core_objects
4536: (p_all_core_objects in pay_element_template_util.t_core_objects
4537: ,p_drop_formula_packages in boolean
4538: ) is
4539: l_proc varchar2(72) := g_package||'zap_core_objects';
4540: --

Line 4543: l_sf_core_objects pay_element_template_util.t_core_objects;

4539: l_proc varchar2(72) := g_package||'zap_core_objects';
4540: --
4541: -- Generation tables.
4542: --
4543: l_sf_core_objects pay_element_template_util.t_core_objects;
4544: l_sbt_core_objects pay_element_template_util.t_core_objects;
4545: l_sdb_core_objects pay_element_template_util.t_core_objects;
4546: l_set_core_objects pay_element_template_util.t_core_objects;
4547: l_ssr_core_objects pay_element_template_util.t_core_objects;

Line 4544: l_sbt_core_objects pay_element_template_util.t_core_objects;

4540: --
4541: -- Generation tables.
4542: --
4543: l_sf_core_objects pay_element_template_util.t_core_objects;
4544: l_sbt_core_objects pay_element_template_util.t_core_objects;
4545: l_sdb_core_objects pay_element_template_util.t_core_objects;
4546: l_set_core_objects pay_element_template_util.t_core_objects;
4547: l_ssr_core_objects pay_element_template_util.t_core_objects;
4548: l_sbc_core_objects pay_element_template_util.t_core_objects;

Line 4545: l_sdb_core_objects pay_element_template_util.t_core_objects;

4541: -- Generation tables.
4542: --
4543: l_sf_core_objects pay_element_template_util.t_core_objects;
4544: l_sbt_core_objects pay_element_template_util.t_core_objects;
4545: l_sdb_core_objects pay_element_template_util.t_core_objects;
4546: l_set_core_objects pay_element_template_util.t_core_objects;
4547: l_ssr_core_objects pay_element_template_util.t_core_objects;
4548: l_sbc_core_objects pay_element_template_util.t_core_objects;
4549: l_siv_core_objects pay_element_template_util.t_core_objects;

Line 4546: l_set_core_objects pay_element_template_util.t_core_objects;

4542: --
4543: l_sf_core_objects pay_element_template_util.t_core_objects;
4544: l_sbt_core_objects pay_element_template_util.t_core_objects;
4545: l_sdb_core_objects pay_element_template_util.t_core_objects;
4546: l_set_core_objects pay_element_template_util.t_core_objects;
4547: l_ssr_core_objects pay_element_template_util.t_core_objects;
4548: l_sbc_core_objects pay_element_template_util.t_core_objects;
4549: l_siv_core_objects pay_element_template_util.t_core_objects;
4550: l_sbf_core_objects pay_element_template_util.t_core_objects;

Line 4547: l_ssr_core_objects pay_element_template_util.t_core_objects;

4543: l_sf_core_objects pay_element_template_util.t_core_objects;
4544: l_sbt_core_objects pay_element_template_util.t_core_objects;
4545: l_sdb_core_objects pay_element_template_util.t_core_objects;
4546: l_set_core_objects pay_element_template_util.t_core_objects;
4547: l_ssr_core_objects pay_element_template_util.t_core_objects;
4548: l_sbc_core_objects pay_element_template_util.t_core_objects;
4549: l_siv_core_objects pay_element_template_util.t_core_objects;
4550: l_sbf_core_objects pay_element_template_util.t_core_objects;
4551: l_spr_core_objects pay_element_template_util.t_core_objects;

Line 4548: l_sbc_core_objects pay_element_template_util.t_core_objects;

4544: l_sbt_core_objects pay_element_template_util.t_core_objects;
4545: l_sdb_core_objects pay_element_template_util.t_core_objects;
4546: l_set_core_objects pay_element_template_util.t_core_objects;
4547: l_ssr_core_objects pay_element_template_util.t_core_objects;
4548: l_sbc_core_objects pay_element_template_util.t_core_objects;
4549: l_siv_core_objects pay_element_template_util.t_core_objects;
4550: l_sbf_core_objects pay_element_template_util.t_core_objects;
4551: l_spr_core_objects pay_element_template_util.t_core_objects;
4552: l_sfr_core_objects pay_element_template_util.t_core_objects;

Line 4549: l_siv_core_objects pay_element_template_util.t_core_objects;

4545: l_sdb_core_objects pay_element_template_util.t_core_objects;
4546: l_set_core_objects pay_element_template_util.t_core_objects;
4547: l_ssr_core_objects pay_element_template_util.t_core_objects;
4548: l_sbc_core_objects pay_element_template_util.t_core_objects;
4549: l_siv_core_objects pay_element_template_util.t_core_objects;
4550: l_sbf_core_objects pay_element_template_util.t_core_objects;
4551: l_spr_core_objects pay_element_template_util.t_core_objects;
4552: l_sfr_core_objects pay_element_template_util.t_core_objects;
4553: l_sir_core_objects pay_element_template_util.t_core_objects;

Line 4550: l_sbf_core_objects pay_element_template_util.t_core_objects;

4546: l_set_core_objects pay_element_template_util.t_core_objects;
4547: l_ssr_core_objects pay_element_template_util.t_core_objects;
4548: l_sbc_core_objects pay_element_template_util.t_core_objects;
4549: l_siv_core_objects pay_element_template_util.t_core_objects;
4550: l_sbf_core_objects pay_element_template_util.t_core_objects;
4551: l_spr_core_objects pay_element_template_util.t_core_objects;
4552: l_sfr_core_objects pay_element_template_util.t_core_objects;
4553: l_sir_core_objects pay_element_template_util.t_core_objects;
4554: l_seu_core_objects pay_element_template_util.t_core_objects;

Line 4551: l_spr_core_objects pay_element_template_util.t_core_objects;

4547: l_ssr_core_objects pay_element_template_util.t_core_objects;
4548: l_sbc_core_objects pay_element_template_util.t_core_objects;
4549: l_siv_core_objects pay_element_template_util.t_core_objects;
4550: l_sbf_core_objects pay_element_template_util.t_core_objects;
4551: l_spr_core_objects pay_element_template_util.t_core_objects;
4552: l_sfr_core_objects pay_element_template_util.t_core_objects;
4553: l_sir_core_objects pay_element_template_util.t_core_objects;
4554: l_seu_core_objects pay_element_template_util.t_core_objects;
4555: l_sgb_core_objects pay_element_template_util.t_core_objects;

Line 4552: l_sfr_core_objects pay_element_template_util.t_core_objects;

4548: l_sbc_core_objects pay_element_template_util.t_core_objects;
4549: l_siv_core_objects pay_element_template_util.t_core_objects;
4550: l_sbf_core_objects pay_element_template_util.t_core_objects;
4551: l_spr_core_objects pay_element_template_util.t_core_objects;
4552: l_sfr_core_objects pay_element_template_util.t_core_objects;
4553: l_sir_core_objects pay_element_template_util.t_core_objects;
4554: l_seu_core_objects pay_element_template_util.t_core_objects;
4555: l_sgb_core_objects pay_element_template_util.t_core_objects;
4556: l_sba_core_objects pay_element_template_util.t_core_objects;

Line 4553: l_sir_core_objects pay_element_template_util.t_core_objects;

4549: l_siv_core_objects pay_element_template_util.t_core_objects;
4550: l_sbf_core_objects pay_element_template_util.t_core_objects;
4551: l_spr_core_objects pay_element_template_util.t_core_objects;
4552: l_sfr_core_objects pay_element_template_util.t_core_objects;
4553: l_sir_core_objects pay_element_template_util.t_core_objects;
4554: l_seu_core_objects pay_element_template_util.t_core_objects;
4555: l_sgb_core_objects pay_element_template_util.t_core_objects;
4556: l_sba_core_objects pay_element_template_util.t_core_objects;
4557: --

Line 4554: l_seu_core_objects pay_element_template_util.t_core_objects;

4550: l_sbf_core_objects pay_element_template_util.t_core_objects;
4551: l_spr_core_objects pay_element_template_util.t_core_objects;
4552: l_sfr_core_objects pay_element_template_util.t_core_objects;
4553: l_sir_core_objects pay_element_template_util.t_core_objects;
4554: l_seu_core_objects pay_element_template_util.t_core_objects;
4555: l_sgb_core_objects pay_element_template_util.t_core_objects;
4556: l_sba_core_objects pay_element_template_util.t_core_objects;
4557: --
4558: -- Deletion tables for the generated objects.

Line 4555: l_sgb_core_objects pay_element_template_util.t_core_objects;

4551: l_spr_core_objects pay_element_template_util.t_core_objects;
4552: l_sfr_core_objects pay_element_template_util.t_core_objects;
4553: l_sir_core_objects pay_element_template_util.t_core_objects;
4554: l_seu_core_objects pay_element_template_util.t_core_objects;
4555: l_sgb_core_objects pay_element_template_util.t_core_objects;
4556: l_sba_core_objects pay_element_template_util.t_core_objects;
4557: --
4558: -- Deletion tables for the generated objects.
4559: --

Line 4556: l_sba_core_objects pay_element_template_util.t_core_objects;

4552: l_sfr_core_objects pay_element_template_util.t_core_objects;
4553: l_sir_core_objects pay_element_template_util.t_core_objects;
4554: l_seu_core_objects pay_element_template_util.t_core_objects;
4555: l_sgb_core_objects pay_element_template_util.t_core_objects;
4556: l_sba_core_objects pay_element_template_util.t_core_objects;
4557: --
4558: -- Deletion tables for the generated objects.
4559: --
4560: l_sf_rowid_id_recs t_rowid_id_recs;