312: ,update_mode varchar2(20)
313: );
314:
315: Type g_prem_mo_rec_type is RECORD
316: (prtt_prem_id ben_prtt_prem_by_mo_f.prtt_prem_id%type
317: ,val ben_prtt_prem_by_mo_f.val%type
318: ,effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%type
319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
313: );
314:
315: Type g_prem_mo_rec_type is RECORD
316: (prtt_prem_id ben_prtt_prem_by_mo_f.prtt_prem_id%type
317: ,val ben_prtt_prem_by_mo_f.val%type
318: ,effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%type
319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type
314:
315: Type g_prem_mo_rec_type is RECORD
316: (prtt_prem_id ben_prtt_prem_by_mo_f.prtt_prem_id%type
317: ,val ben_prtt_prem_by_mo_f.val%type
318: ,effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%type
319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type
322: ,yr_num ben_prtt_prem_by_mo_f.yr_num%type
315: Type g_prem_mo_rec_type is RECORD
316: (prtt_prem_id ben_prtt_prem_by_mo_f.prtt_prem_id%type
317: ,val ben_prtt_prem_by_mo_f.val%type
318: ,effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%type
319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type
322: ,yr_num ben_prtt_prem_by_mo_f.yr_num%type
323: ,cr_val ben_prtt_prem_by_mo_f.cr_val%type
316: (prtt_prem_id ben_prtt_prem_by_mo_f.prtt_prem_id%type
317: ,val ben_prtt_prem_by_mo_f.val%type
318: ,effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%type
319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type
322: ,yr_num ben_prtt_prem_by_mo_f.yr_num%type
323: ,cr_val ben_prtt_prem_by_mo_f.cr_val%type
324: ,uom ben_prtt_prem_by_mo_f.uom%type
317: ,val ben_prtt_prem_by_mo_f.val%type
318: ,effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%type
319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type
322: ,yr_num ben_prtt_prem_by_mo_f.yr_num%type
323: ,cr_val ben_prtt_prem_by_mo_f.cr_val%type
324: ,uom ben_prtt_prem_by_mo_f.uom%type
325: ,update_mode varchar2(20)
318: ,effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%type
319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type
322: ,yr_num ben_prtt_prem_by_mo_f.yr_num%type
323: ,cr_val ben_prtt_prem_by_mo_f.cr_val%type
324: ,uom ben_prtt_prem_by_mo_f.uom%type
325: ,update_mode varchar2(20)
326: );
319: ,effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%type
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type
322: ,yr_num ben_prtt_prem_by_mo_f.yr_num%type
323: ,cr_val ben_prtt_prem_by_mo_f.cr_val%type
324: ,uom ben_prtt_prem_by_mo_f.uom%type
325: ,update_mode varchar2(20)
326: );
327: --
320: ,business_group_id ben_prtt_prem_by_mo_f.business_group_id%type
321: ,mo_num ben_prtt_prem_by_mo_f.mo_num%type
322: ,yr_num ben_prtt_prem_by_mo_f.yr_num%type
323: ,cr_val ben_prtt_prem_by_mo_f.cr_val%type
324: ,uom ben_prtt_prem_by_mo_f.uom%type
325: ,update_mode varchar2(20)
326: );
327: --
328: -- added for bug 6517369 to audit changes to per_disabilities_f