[Home] [Help]
46: ,p_inst_row in out NOCOPY g_oiplip_inst_row
47: );
48: --
49: type g_opt_inst_row is record
50: (opt_id ben_opt_f.opt_id%type
51: ,name ben_opt_f.name%type
52: ,effective_start_date ben_opt_f.effective_start_date%type
53: ,effective_end_date ben_opt_f.effective_end_date%type
54: ,rqd_perd_enrt_nenrt_uom ben_opt_f.rqd_perd_enrt_nenrt_uom%type
47: );
48: --
49: type g_opt_inst_row is record
50: (opt_id ben_opt_f.opt_id%type
51: ,name ben_opt_f.name%type
52: ,effective_start_date ben_opt_f.effective_start_date%type
53: ,effective_end_date ben_opt_f.effective_end_date%type
54: ,rqd_perd_enrt_nenrt_uom ben_opt_f.rqd_perd_enrt_nenrt_uom%type
55: ,rqd_perd_enrt_nenrt_val ben_opt_f.rqd_perd_enrt_nenrt_val%type
48: --
49: type g_opt_inst_row is record
50: (opt_id ben_opt_f.opt_id%type
51: ,name ben_opt_f.name%type
52: ,effective_start_date ben_opt_f.effective_start_date%type
53: ,effective_end_date ben_opt_f.effective_end_date%type
54: ,rqd_perd_enrt_nenrt_uom ben_opt_f.rqd_perd_enrt_nenrt_uom%type
55: ,rqd_perd_enrt_nenrt_val ben_opt_f.rqd_perd_enrt_nenrt_val%type
56: ,rqd_perd_enrt_nenrt_rl ben_opt_f.rqd_perd_enrt_nenrt_rl%type
49: type g_opt_inst_row is record
50: (opt_id ben_opt_f.opt_id%type
51: ,name ben_opt_f.name%type
52: ,effective_start_date ben_opt_f.effective_start_date%type
53: ,effective_end_date ben_opt_f.effective_end_date%type
54: ,rqd_perd_enrt_nenrt_uom ben_opt_f.rqd_perd_enrt_nenrt_uom%type
55: ,rqd_perd_enrt_nenrt_val ben_opt_f.rqd_perd_enrt_nenrt_val%type
56: ,rqd_perd_enrt_nenrt_rl ben_opt_f.rqd_perd_enrt_nenrt_rl%type
57: );
50: (opt_id ben_opt_f.opt_id%type
51: ,name ben_opt_f.name%type
52: ,effective_start_date ben_opt_f.effective_start_date%type
53: ,effective_end_date ben_opt_f.effective_end_date%type
54: ,rqd_perd_enrt_nenrt_uom ben_opt_f.rqd_perd_enrt_nenrt_uom%type
55: ,rqd_perd_enrt_nenrt_val ben_opt_f.rqd_perd_enrt_nenrt_val%type
56: ,rqd_perd_enrt_nenrt_rl ben_opt_f.rqd_perd_enrt_nenrt_rl%type
57: );
58: --
51: ,name ben_opt_f.name%type
52: ,effective_start_date ben_opt_f.effective_start_date%type
53: ,effective_end_date ben_opt_f.effective_end_date%type
54: ,rqd_perd_enrt_nenrt_uom ben_opt_f.rqd_perd_enrt_nenrt_uom%type
55: ,rqd_perd_enrt_nenrt_val ben_opt_f.rqd_perd_enrt_nenrt_val%type
56: ,rqd_perd_enrt_nenrt_rl ben_opt_f.rqd_perd_enrt_nenrt_rl%type
57: );
58: --
59: type g_opt_inst_tbl is table of g_opt_inst_row
52: ,effective_start_date ben_opt_f.effective_start_date%type
53: ,effective_end_date ben_opt_f.effective_end_date%type
54: ,rqd_perd_enrt_nenrt_uom ben_opt_f.rqd_perd_enrt_nenrt_uom%type
55: ,rqd_perd_enrt_nenrt_val ben_opt_f.rqd_perd_enrt_nenrt_val%type
56: ,rqd_perd_enrt_nenrt_rl ben_opt_f.rqd_perd_enrt_nenrt_rl%type
57: );
58: --
59: type g_opt_inst_tbl is table of g_opt_inst_row
60: index by binary_integer;