[Home] [Help]
36: person_type_info
37: 115.7 16-Aug-99 gperry Added nocopy compiler directive.
38: 115.8 17-Aug-99 gperry Removed business group id from
39: set_ast_object.
40: 115.9 18-Aug-99 gperry Added cache for ben_bnfts_bal_f
41: 115.10 23-Aug-99 gperry Cache full time info using assignment id.
42: 115.11 26-Aug-99 gperry Added cache for benefits assignment.
43: Added cache for applicants assignment.
44: Made assignment cache get employee
108: --
109: type g_cache_bal_table is table of ben_per_bnfts_bal_f%rowtype index
110: by binary_integer;
111: --
112: type g_cache_bnb_table is table of ben_bnfts_bal_f%rowtype index
113: by binary_integer;
114: --
115: type g_cache_hsc_table is table of hr_soft_coding_keyflex%rowtype index
116: by binary_integer;
182: g_cache_last_appass_rec g_cache_ass_table;
183: g_cache_last_allass_rec g_cache_ass_table;
184: g_cache_last_typ_rec g_cache_typ_table;
185: g_cache_last_bal_rec ben_per_bnfts_bal_f%rowtype;
186: g_cache_last_bnb_rec ben_bnfts_bal_f%rowtype;
187: --
188: -- Set object routines
189: --
190: procedure set_object
209: (p_rec in out nocopy hr_soft_coding_keyflex%rowtype);
210: procedure set_object
211: (p_rec in out nocopy ben_per_in_ler%rowtype);
212: procedure set_object
213: (p_rec in out nocopy ben_bnfts_bal_f%rowtype);
214: procedure set_object
215: (p_rec in out nocopy ben_per_bnfts_bal_f%rowtype);
216: procedure set_object
217: (p_rec in out nocopy per_contact_relationships%rowtype);
258: procedure set_bnb_object
259: (p_bnfts_bal_id in number,
260: p_business_group_id in number,
261: p_effective_date in date,
262: p_rec in out nocopy ben_bnfts_bal_f%rowtype);
263: procedure set_ass_object
264: (p_assignment_id in number,
265: p_rec in out nocopy per_assignment_extra_info%rowtype);
266: procedure set_hsc_object
336: (p_person_id in number,
337: p_rec in out nocopy per_all_assignments_f%rowtype);
338: procedure get_object
339: (p_bnfts_bal_id in number,
340: p_rec in out nocopy ben_bnfts_bal_f%rowtype);
341: procedure get_object
342: (p_assignment_status_type_id in number,
343: p_rec in out nocopy per_assignment_status_types%rowtype);
344: procedure get_object