28: --------------------------------------------------------------------------------
29: --
30: -- Cache all comp object stuff
31: --
32: type g_cache_elig_prte_rec_table is table of ben_elig_to_prte_rsn_f%rowtype
33: index by binary_integer;
34: --
35: type g_cache_elig_rec_table is table of ben_prtn_elig_f%rowtype
36: index by binary_integer;
48: --
49: -- Set object routines
50: --
51: procedure set_object(p_pgm_id in number,
52: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
53: procedure set_object(p_pl_id in number,
54: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
55: procedure set_object(p_oipl_id in number,
56: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
50: --
51: procedure set_object(p_pgm_id in number,
52: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
53: procedure set_object(p_pl_id in number,
54: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
55: procedure set_object(p_oipl_id in number,
56: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
57: procedure set_object(p_plip_id in number,
58: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
52: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
53: procedure set_object(p_pl_id in number,
54: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
55: procedure set_object(p_oipl_id in number,
56: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
57: procedure set_object(p_plip_id in number,
58: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
59: procedure set_object(p_ptip_id in number,
60: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
54: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
55: procedure set_object(p_oipl_id in number,
56: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
57: procedure set_object(p_plip_id in number,
58: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
59: procedure set_object(p_ptip_id in number,
60: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
61: --
62: procedure set_object(p_pgm_id in number,
56: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
57: procedure set_object(p_plip_id in number,
58: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
59: procedure set_object(p_ptip_id in number,
60: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
61: --
62: procedure set_object(p_pgm_id in number,
63: p_rec in out NOCOPY ben_prtn_elig_f%rowtype);
64: procedure set_object(p_pl_id in number,
73: procedure set_object(p_pl_id in number,
74: p_ler_id in number,
75: p_business_group_id in number,
76: p_effective_date in date,
77: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype
78: );
79: procedure set_object(p_pgm_id in number,
80: p_ler_id in number,
81: p_business_group_id in number,
79: procedure set_object(p_pgm_id in number,
80: p_ler_id in number,
81: p_business_group_id in number,
82: p_effective_date in date,
83: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype
84: );
85: procedure set_object(p_oipl_id in number,
86: p_ler_id in number,
87: p_business_group_id in number,
85: procedure set_object(p_oipl_id in number,
86: p_ler_id in number,
87: p_business_group_id in number,
88: p_effective_date in date,
89: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype
90: );
91: procedure set_object(p_plip_id in number,
92: p_ler_id in number,
93: p_business_group_id in number,
91: procedure set_object(p_plip_id in number,
92: p_ler_id in number,
93: p_business_group_id in number,
94: p_effective_date in date,
95: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype
96: );
97: procedure set_object(p_ptip_id in number,
98: p_ler_id in number,
99: p_business_group_id in number,
97: procedure set_object(p_ptip_id in number,
98: p_ler_id in number,
99: p_business_group_id in number,
100: p_effective_date in date,
101: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype
102: );
103: --
104: procedure set_object(p_pl_id in number,
105: p_business_group_id in number,
120: -- Get object routines
121: --
122: procedure get_object(p_pgm_id in number,
123: p_ler_id in number default null,
124: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
125: procedure get_object(p_pl_id in number,
126: p_ler_id in number default null,
127: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
128: procedure get_object(p_oipl_id in number,
123: p_ler_id in number default null,
124: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
125: procedure get_object(p_pl_id in number,
126: p_ler_id in number default null,
127: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
128: procedure get_object(p_oipl_id in number,
129: p_ler_id in number default null,
130: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
131: procedure get_object(p_plip_id in number,
126: p_ler_id in number default null,
127: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
128: procedure get_object(p_oipl_id in number,
129: p_ler_id in number default null,
130: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
131: procedure get_object(p_plip_id in number,
132: p_ler_id in number default null,
133: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
134: procedure get_object(p_ptip_id in number,
129: p_ler_id in number default null,
130: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
131: procedure get_object(p_plip_id in number,
132: p_ler_id in number default null,
133: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
134: procedure get_object(p_ptip_id in number,
135: p_ler_id in number default null,
136: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
137: --
132: p_ler_id in number default null,
133: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
134: procedure get_object(p_ptip_id in number,
135: p_ler_id in number default null,
136: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
137: --
138: procedure get_object(p_pgm_id in number,
139: p_rec in out NOCOPY ben_prtn_elig_f%rowtype);
140: procedure get_object(p_pl_id in number,