28: type t_id_ovn_recs is table of g_id_ovn_rec index by binary_integer;
29: --------------------------------------------------------
30: -- Constant definitions for CORE_OBJECT_TYPE lookups. --
31: --------------------------------------------------------
32: g_sf_lookup_type constant varchar2(30) default pay_tco_shd.g_sf_lookup_type;
33: g_sbt_lookup_type constant varchar2(30) default pay_tco_shd.g_sbt_lookup_type;
34: g_sdb_lookup_type constant varchar2(30) default pay_tco_shd.g_sdb_lookup_type;
35: g_set_lookup_type constant varchar2(30) default pay_tco_shd.g_set_lookup_type;
36: g_ssr_lookup_type constant varchar2(30) default pay_tco_shd.g_ssr_lookup_type;
29: --------------------------------------------------------
30: -- Constant definitions for CORE_OBJECT_TYPE lookups. --
31: --------------------------------------------------------
32: g_sf_lookup_type constant varchar2(30) default pay_tco_shd.g_sf_lookup_type;
33: g_sbt_lookup_type constant varchar2(30) default pay_tco_shd.g_sbt_lookup_type;
34: g_sdb_lookup_type constant varchar2(30) default pay_tco_shd.g_sdb_lookup_type;
35: g_set_lookup_type constant varchar2(30) default pay_tco_shd.g_set_lookup_type;
36: g_ssr_lookup_type constant varchar2(30) default pay_tco_shd.g_ssr_lookup_type;
37: g_sbc_lookup_type constant varchar2(30) default pay_tco_shd.g_sbc_lookup_type;
30: -- Constant definitions for CORE_OBJECT_TYPE lookups. --
31: --------------------------------------------------------
32: g_sf_lookup_type constant varchar2(30) default pay_tco_shd.g_sf_lookup_type;
33: g_sbt_lookup_type constant varchar2(30) default pay_tco_shd.g_sbt_lookup_type;
34: g_sdb_lookup_type constant varchar2(30) default pay_tco_shd.g_sdb_lookup_type;
35: g_set_lookup_type constant varchar2(30) default pay_tco_shd.g_set_lookup_type;
36: g_ssr_lookup_type constant varchar2(30) default pay_tco_shd.g_ssr_lookup_type;
37: g_sbc_lookup_type constant varchar2(30) default pay_tco_shd.g_sbc_lookup_type;
38: g_siv_lookup_type constant varchar2(30) default pay_tco_shd.g_siv_lookup_type;
31: --------------------------------------------------------
32: g_sf_lookup_type constant varchar2(30) default pay_tco_shd.g_sf_lookup_type;
33: g_sbt_lookup_type constant varchar2(30) default pay_tco_shd.g_sbt_lookup_type;
34: g_sdb_lookup_type constant varchar2(30) default pay_tco_shd.g_sdb_lookup_type;
35: g_set_lookup_type constant varchar2(30) default pay_tco_shd.g_set_lookup_type;
36: g_ssr_lookup_type constant varchar2(30) default pay_tco_shd.g_ssr_lookup_type;
37: g_sbc_lookup_type constant varchar2(30) default pay_tco_shd.g_sbc_lookup_type;
38: g_siv_lookup_type constant varchar2(30) default pay_tco_shd.g_siv_lookup_type;
39: g_sbf_lookup_type constant varchar2(30) default pay_tco_shd.g_sbf_lookup_type;
32: g_sf_lookup_type constant varchar2(30) default pay_tco_shd.g_sf_lookup_type;
33: g_sbt_lookup_type constant varchar2(30) default pay_tco_shd.g_sbt_lookup_type;
34: g_sdb_lookup_type constant varchar2(30) default pay_tco_shd.g_sdb_lookup_type;
35: g_set_lookup_type constant varchar2(30) default pay_tco_shd.g_set_lookup_type;
36: g_ssr_lookup_type constant varchar2(30) default pay_tco_shd.g_ssr_lookup_type;
37: g_sbc_lookup_type constant varchar2(30) default pay_tco_shd.g_sbc_lookup_type;
38: g_siv_lookup_type constant varchar2(30) default pay_tco_shd.g_siv_lookup_type;
39: g_sbf_lookup_type constant varchar2(30) default pay_tco_shd.g_sbf_lookup_type;
40: g_sfr_lookup_type constant varchar2(30) default pay_tco_shd.g_sfr_lookup_type;
33: g_sbt_lookup_type constant varchar2(30) default pay_tco_shd.g_sbt_lookup_type;
34: g_sdb_lookup_type constant varchar2(30) default pay_tco_shd.g_sdb_lookup_type;
35: g_set_lookup_type constant varchar2(30) default pay_tco_shd.g_set_lookup_type;
36: g_ssr_lookup_type constant varchar2(30) default pay_tco_shd.g_ssr_lookup_type;
37: g_sbc_lookup_type constant varchar2(30) default pay_tco_shd.g_sbc_lookup_type;
38: g_siv_lookup_type constant varchar2(30) default pay_tco_shd.g_siv_lookup_type;
39: g_sbf_lookup_type constant varchar2(30) default pay_tco_shd.g_sbf_lookup_type;
40: g_sfr_lookup_type constant varchar2(30) default pay_tco_shd.g_sfr_lookup_type;
41: g_spr_lookup_type constant varchar2(30) default pay_tco_shd.g_spr_lookup_type;
34: g_sdb_lookup_type constant varchar2(30) default pay_tco_shd.g_sdb_lookup_type;
35: g_set_lookup_type constant varchar2(30) default pay_tco_shd.g_set_lookup_type;
36: g_ssr_lookup_type constant varchar2(30) default pay_tco_shd.g_ssr_lookup_type;
37: g_sbc_lookup_type constant varchar2(30) default pay_tco_shd.g_sbc_lookup_type;
38: g_siv_lookup_type constant varchar2(30) default pay_tco_shd.g_siv_lookup_type;
39: g_sbf_lookup_type constant varchar2(30) default pay_tco_shd.g_sbf_lookup_type;
40: g_sfr_lookup_type constant varchar2(30) default pay_tco_shd.g_sfr_lookup_type;
41: g_spr_lookup_type constant varchar2(30) default pay_tco_shd.g_spr_lookup_type;
42: g_sir_lookup_type constant varchar2(30) default pay_tco_shd.g_sir_lookup_type;
35: g_set_lookup_type constant varchar2(30) default pay_tco_shd.g_set_lookup_type;
36: g_ssr_lookup_type constant varchar2(30) default pay_tco_shd.g_ssr_lookup_type;
37: g_sbc_lookup_type constant varchar2(30) default pay_tco_shd.g_sbc_lookup_type;
38: g_siv_lookup_type constant varchar2(30) default pay_tco_shd.g_siv_lookup_type;
39: g_sbf_lookup_type constant varchar2(30) default pay_tco_shd.g_sbf_lookup_type;
40: g_sfr_lookup_type constant varchar2(30) default pay_tco_shd.g_sfr_lookup_type;
41: g_spr_lookup_type constant varchar2(30) default pay_tco_shd.g_spr_lookup_type;
42: g_sir_lookup_type constant varchar2(30) default pay_tco_shd.g_sir_lookup_type;
43: g_seu_lookup_type constant varchar2(30) default pay_tco_shd.g_seu_lookup_type;
36: g_ssr_lookup_type constant varchar2(30) default pay_tco_shd.g_ssr_lookup_type;
37: g_sbc_lookup_type constant varchar2(30) default pay_tco_shd.g_sbc_lookup_type;
38: g_siv_lookup_type constant varchar2(30) default pay_tco_shd.g_siv_lookup_type;
39: g_sbf_lookup_type constant varchar2(30) default pay_tco_shd.g_sbf_lookup_type;
40: g_sfr_lookup_type constant varchar2(30) default pay_tco_shd.g_sfr_lookup_type;
41: g_spr_lookup_type constant varchar2(30) default pay_tco_shd.g_spr_lookup_type;
42: g_sir_lookup_type constant varchar2(30) default pay_tco_shd.g_sir_lookup_type;
43: g_seu_lookup_type constant varchar2(30) default pay_tco_shd.g_seu_lookup_type;
44: g_sgb_lookup_type constant varchar2(30) default pay_tco_shd.g_sgb_lookup_type;
37: g_sbc_lookup_type constant varchar2(30) default pay_tco_shd.g_sbc_lookup_type;
38: g_siv_lookup_type constant varchar2(30) default pay_tco_shd.g_siv_lookup_type;
39: g_sbf_lookup_type constant varchar2(30) default pay_tco_shd.g_sbf_lookup_type;
40: g_sfr_lookup_type constant varchar2(30) default pay_tco_shd.g_sfr_lookup_type;
41: g_spr_lookup_type constant varchar2(30) default pay_tco_shd.g_spr_lookup_type;
42: g_sir_lookup_type constant varchar2(30) default pay_tco_shd.g_sir_lookup_type;
43: g_seu_lookup_type constant varchar2(30) default pay_tco_shd.g_seu_lookup_type;
44: g_sgb_lookup_type constant varchar2(30) default pay_tco_shd.g_sgb_lookup_type;
45: g_sba_lookup_type constant varchar2(30) default pay_tco_shd.g_sba_lookup_type;
38: g_siv_lookup_type constant varchar2(30) default pay_tco_shd.g_siv_lookup_type;
39: g_sbf_lookup_type constant varchar2(30) default pay_tco_shd.g_sbf_lookup_type;
40: g_sfr_lookup_type constant varchar2(30) default pay_tco_shd.g_sfr_lookup_type;
41: g_spr_lookup_type constant varchar2(30) default pay_tco_shd.g_spr_lookup_type;
42: g_sir_lookup_type constant varchar2(30) default pay_tco_shd.g_sir_lookup_type;
43: g_seu_lookup_type constant varchar2(30) default pay_tco_shd.g_seu_lookup_type;
44: g_sgb_lookup_type constant varchar2(30) default pay_tco_shd.g_sgb_lookup_type;
45: g_sba_lookup_type constant varchar2(30) default pay_tco_shd.g_sba_lookup_type;
46: --------------------------------------------------
39: g_sbf_lookup_type constant varchar2(30) default pay_tco_shd.g_sbf_lookup_type;
40: g_sfr_lookup_type constant varchar2(30) default pay_tco_shd.g_sfr_lookup_type;
41: g_spr_lookup_type constant varchar2(30) default pay_tco_shd.g_spr_lookup_type;
42: g_sir_lookup_type constant varchar2(30) default pay_tco_shd.g_sir_lookup_type;
43: g_seu_lookup_type constant varchar2(30) default pay_tco_shd.g_seu_lookup_type;
44: g_sgb_lookup_type constant varchar2(30) default pay_tco_shd.g_sgb_lookup_type;
45: g_sba_lookup_type constant varchar2(30) default pay_tco_shd.g_sba_lookup_type;
46: --------------------------------------------------
47: -- Constant definitions for formula type names. --
40: g_sfr_lookup_type constant varchar2(30) default pay_tco_shd.g_sfr_lookup_type;
41: g_spr_lookup_type constant varchar2(30) default pay_tco_shd.g_spr_lookup_type;
42: g_sir_lookup_type constant varchar2(30) default pay_tco_shd.g_sir_lookup_type;
43: g_seu_lookup_type constant varchar2(30) default pay_tco_shd.g_seu_lookup_type;
44: g_sgb_lookup_type constant varchar2(30) default pay_tco_shd.g_sgb_lookup_type;
45: g_sba_lookup_type constant varchar2(30) default pay_tco_shd.g_sba_lookup_type;
46: --------------------------------------------------
47: -- Constant definitions for formula type names. --
48: --------------------------------------------------
41: g_spr_lookup_type constant varchar2(30) default pay_tco_shd.g_spr_lookup_type;
42: g_sir_lookup_type constant varchar2(30) default pay_tco_shd.g_sir_lookup_type;
43: g_seu_lookup_type constant varchar2(30) default pay_tco_shd.g_seu_lookup_type;
44: g_sgb_lookup_type constant varchar2(30) default pay_tco_shd.g_sgb_lookup_type;
45: g_sba_lookup_type constant varchar2(30) default pay_tco_shd.g_sba_lookup_type;
46: --------------------------------------------------
47: -- Constant definitions for formula type names. --
48: --------------------------------------------------
49: g_skip_formula_type constant varchar2(30) default
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
986: hr_utility.set_location('Entering:'|| l_proc, 10);
987: --
988: if p_core_objects.exists(p_shadow_object_id) then
1006: -- ----------------------------------------------------------------------------
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;