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
977: ,p_core_object_id in number
978: ,p_core_objects in out nocopy pay_element_template_util.t_core_objects
979: ) is
980: l_proc varchar2(72) := g_package||'update_core_objects';
981: l_core_object pay_tco_shd.g_rec_type;
982: begin
983: hr_utility.set_location('Entering:'|| l_proc, 10);
984: --
985: if p_core_objects.exists(p_shadow_object_id) then
1003: -- ----------------------------------------------------------------------------
1004: -- |---------------------------< new_core_object >----------------------------|
1005: -- ----------------------------------------------------------------------------
1006: function new_core_object
1007: (p_core_object in pay_tco_shd.g_rec_type
1008: ,p_all_core_objects in pay_element_template_util.t_core_objects
1009: ) return boolean is
1010: l_proc varchar2(72) := g_package||'new_core_object';
1011: l_template_core_object_id number;