[Home] [Help]
87: --
88: type g_cache_per_table is table of per_all_people_f%rowtype index
89: by binary_integer;
90: --
91: type g_cache_ass_table is table of per_all_assignments_f%rowtype index
92: by binary_integer;
93: --
94: type g_cache_ast_table is table of per_assignment_status_types%rowtype index
95: by binary_integer;
167: --
168: -- Latest record caches
169: --
170: g_cache_last_per_rec per_all_people_f%rowtype;
171: g_cache_last_benass_rec per_all_assignments_f%rowtype;
172: g_cache_last_ass_rec per_all_assignments_f%rowtype;
173: g_cache_last_ast_rec per_assignment_status_types%rowtype;
174: g_cache_last_aei_rec per_assignment_extra_info%rowtype;
175: g_cache_last_pps_rec per_periods_of_service%rowtype;
168: -- Latest record caches
169: --
170: g_cache_last_per_rec per_all_people_f%rowtype;
171: g_cache_last_benass_rec per_all_assignments_f%rowtype;
172: g_cache_last_ass_rec per_all_assignments_f%rowtype;
173: g_cache_last_ast_rec per_assignment_status_types%rowtype;
174: g_cache_last_aei_rec per_assignment_extra_info%rowtype;
175: g_cache_last_pps_rec per_periods_of_service%rowtype;
176: g_cache_last_pad_rec per_addresses%rowtype;
187: --
188: -- Set object routines
189: --
190: procedure set_object
191: (p_rec in out nocopy per_all_assignments_f%rowtype);
192: procedure set_benass_object
193: (p_rec in out nocopy per_all_assignments_f%rowtype);
194: procedure set_appass_object
195: (p_rec in out nocopy per_all_assignments_f%rowtype);
189: --
190: procedure set_object
191: (p_rec in out nocopy per_all_assignments_f%rowtype);
192: procedure set_benass_object
193: (p_rec in out nocopy per_all_assignments_f%rowtype);
194: procedure set_appass_object
195: (p_rec in out nocopy per_all_assignments_f%rowtype);
196: procedure set_allass_object
197: (p_rec in out nocopy per_all_assignments_f%rowtype);
191: (p_rec in out nocopy per_all_assignments_f%rowtype);
192: procedure set_benass_object
193: (p_rec in out nocopy per_all_assignments_f%rowtype);
194: procedure set_appass_object
195: (p_rec in out nocopy per_all_assignments_f%rowtype);
196: procedure set_allass_object
197: (p_rec in out nocopy per_all_assignments_f%rowtype);
198: procedure set_object
199: (p_rec in out nocopy per_assignment_status_types%rowtype);
193: (p_rec in out nocopy per_all_assignments_f%rowtype);
194: procedure set_appass_object
195: (p_rec in out nocopy per_all_assignments_f%rowtype);
196: procedure set_allass_object
197: (p_rec in out nocopy per_all_assignments_f%rowtype);
198: procedure set_object
199: (p_rec in out nocopy per_assignment_status_types%rowtype);
200: procedure set_object
201: (p_rec in out nocopy per_assignment_extra_info%rowtype);
235: procedure set_ass_object
236: (p_person_id in number,
237: p_business_group_id in number,
238: p_effective_date in date,
239: p_rec in out nocopy per_all_assignments_f%rowtype);
240: procedure set_benass_object
241: (p_person_id in number,
242: p_business_group_id in number,
243: p_effective_date in date,
240: procedure set_benass_object
241: (p_person_id in number,
242: p_business_group_id in number,
243: p_effective_date in date,
244: p_rec in out nocopy per_all_assignments_f%rowtype);
245: procedure set_appass_object
246: (p_person_id in number,
247: p_business_group_id in number,
248: p_effective_date in date,
323: --ud changes start
324: -- adding new procedure taking latest assignment_id as input
325: procedure get_object
326: (p_person_id in number,
327: p_rec in out nocopy per_all_assignments_f%rowtype,
328: p_assignment_id in number);
329: --us changes end
330: --Bug 12664112
331:
330: --Bug 12664112
331:
332: procedure get_object
333: (p_person_id in number,
334: p_rec in out nocopy per_all_assignments_f%rowtype);
335: procedure get_benass_object
336: (p_person_id in number,
337: p_rec in out nocopy per_all_assignments_f%rowtype);
338: procedure get_object
333: (p_person_id in number,
334: p_rec in out nocopy per_all_assignments_f%rowtype);
335: procedure get_benass_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
395: (p_person_id in number,
396: p_assignment_id in number,
397: p_business_group_id in number,
398: p_effective_date in date,
399: p_rec in out nocopy per_all_assignments_f%rowtype);
400: procedure get_assgn_object
401: (p_person_id in number,
402: p_assignment_id in number,
403: p_rec in out nocopy per_all_assignments_f%rowtype);
399: p_rec in out nocopy per_all_assignments_f%rowtype);
400: procedure get_assgn_object
401: (p_person_id in number,
402: p_assignment_id in number,
403: p_rec in out nocopy per_all_assignments_f%rowtype);
404: /*End Enh: 13478736*/
405: --
406: end ben_person_object;