DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_TCO_SHD

Line 32: g_sf_lookup_type constant varchar2(30) default pay_tco_shd.g_sf_lookup_type;

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;

Line 33: g_sbt_lookup_type constant varchar2(30) default pay_tco_shd.g_sbt_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;

Line 34: g_sdb_lookup_type constant varchar2(30) default pay_tco_shd.g_sdb_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;

Line 35: g_set_lookup_type constant varchar2(30) default pay_tco_shd.g_set_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;

Line 36: g_ssr_lookup_type constant varchar2(30) default pay_tco_shd.g_ssr_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;

Line 37: g_sbc_lookup_type constant varchar2(30) default pay_tco_shd.g_sbc_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;

Line 38: g_siv_lookup_type constant varchar2(30) default pay_tco_shd.g_siv_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;

Line 39: g_sbf_lookup_type constant varchar2(30) default pay_tco_shd.g_sbf_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;

Line 40: g_sfr_lookup_type constant varchar2(30) default pay_tco_shd.g_sfr_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;

Line 41: g_spr_lookup_type constant varchar2(30) default pay_tco_shd.g_spr_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;

Line 42: g_sir_lookup_type constant varchar2(30) default pay_tco_shd.g_sir_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: --------------------------------------------------

Line 43: g_seu_lookup_type constant varchar2(30) default pay_tco_shd.g_seu_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: --------------------------------------------------
47: -- Constant definitions for formula type names. --

Line 44: g_sgb_lookup_type constant varchar2(30) default pay_tco_shd.g_sgb_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. --
48: --------------------------------------------------

Line 45: g_sba_lookup_type constant varchar2(30) default pay_tco_shd.g_sba_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: --------------------------------------------------
49: g_skip_formula_type constant varchar2(30) default

Line 981: l_core_object pay_tco_shd.g_rec_type;

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

Line 1007: (p_core_object in pay_tco_shd.g_rec_type

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;