eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_RT_PRFL_CACHE dependencies on BEN_RT_PRFL_CACHE

Line 1: package body ben_rt_prfl_cache AS

1: package body ben_rt_prfl_cache AS
2: /* $Header: bertprch.pkb 120.0.12000000.2 2007/09/14 09:50:37 rgajula noship $ */
3: --
4: /*
5: +==============================================================================+

Line 63: g_package varchar2(50) := 'ben_rt_prfl_cache.';

59: */
60: --
61: -- Globals.
62: --
63: g_package varchar2(50) := 'ben_rt_prfl_cache.';
64: --
65: -- ----------------------------------------------------------------------------
66: -- |-----------------------< get_cached_data >--------------------------------|
67: -- ----------------------------------------------------------------------------

Line 184: 'ben_rt_prfl_cache.g_inst_count := l_torrwnum; ' ||

180: 'l_torrwnum := l_torrwnum + 1; ' ||
181: --
182: 'end loop; ' ||
183: --
184: 'ben_rt_prfl_cache.g_inst_count := l_torrwnum; ' ||
185: --
186: 'END;';
187:
188: EXECUTE IMMEDIATE l_plsql_str;

Line 319: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_pg_inst_tbl

315: (p_vrbl_rt_prfl_id in number
316: ,p_effective_date in date
317: ,p_lf_evt_ocrd_dt in date
318: ,p_business_group_id in number
319: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_pg_inst_tbl
320: ,p_inst_count out nocopy number)
321: is
322: --
323: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache people group';

Line 455: ,p_lkup_name => 'ben_rt_prfl_cache.g_pg_lookup'

451: --
452: ben_cache.write_mastDet_Cache
453: (p_mastercol_name => 'vrbl_rt_prfl_id'
454: ,p_detailcol_name => 'vrbl_rt_prfl_id'
455: ,p_lkup_name => 'ben_rt_prfl_cache.g_pg_lookup'
456: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'
457: ,p_lkup_query => l_lookup_query
458: ,p_inst_query => l_inst_query
459: ,p_instcolnm_set => l_instcolnm_set

Line 456: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'

452: ben_cache.write_mastDet_Cache
453: (p_mastercol_name => 'vrbl_rt_prfl_id'
454: ,p_detailcol_name => 'vrbl_rt_prfl_id'
455: ,p_lkup_name => 'ben_rt_prfl_cache.g_pg_lookup'
456: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'
457: ,p_lkup_query => l_lookup_query
458: ,p_inst_query => l_inst_query
459: ,p_instcolnm_set => l_instcolnm_set
460: );

Line 468: ,p_lookup_name => 'ben_rt_prfl_cache.g_pg_lookup'

464: -- Cache already populated. Get record set.
465: --
466: get_cached_data
467: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
468: ,p_lookup_name => 'ben_rt_prfl_cache.g_pg_lookup'
469: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'
470: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pg_inst_tbl'
471: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pg_out'
472: );

Line 469: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'

465: --
466: get_cached_data
467: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
468: ,p_lookup_name => 'ben_rt_prfl_cache.g_pg_lookup'
469: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'
470: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pg_inst_tbl'
471: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pg_out'
472: );
473: --

Line 470: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pg_inst_tbl'

466: get_cached_data
467: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
468: ,p_lookup_name => 'ben_rt_prfl_cache.g_pg_lookup'
469: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'
470: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pg_inst_tbl'
471: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pg_out'
472: );
473: --
474: p_inst_set := g_pg_out;

Line 471: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pg_out'

467: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
468: ,p_lookup_name => 'ben_rt_prfl_cache.g_pg_lookup'
469: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'
470: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pg_inst_tbl'
471: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pg_out'
472: );
473: --
474: p_inst_set := g_pg_out;
475: p_inst_count := g_inst_count;

Line 492: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_pg_inst_tbl

488: (p_vrbl_rt_prfl_id in number
489: ,p_effective_date in date
490: ,p_lf_evt_ocrd_dt in date
491: ,p_business_group_id in number
492: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_pg_inst_tbl
493: ,p_inst_count out nocopy number)
494: is
495: --
496: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache people group';

Line 541: ,p_lkup_name => 'ben_rt_prfl_cache.g_pg_lookup'

537: --
538: ben_cache.write_mastDet_Cache
539: (p_mastercol_name => 'vrbl_rt_prfl_id'
540: ,p_detailcol_name => 'vrbl_rt_prfl_id'
541: ,p_lkup_name => 'ben_rt_prfl_cache.g_pg_lookup'
542: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'
543: ,p_lkup_query => l_lookup_query
544: ,p_inst_query => l_inst_query
545: ,p_instcolnm_set => l_instcolnm_set

Line 542: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'

538: ben_cache.write_mastDet_Cache
539: (p_mastercol_name => 'vrbl_rt_prfl_id'
540: ,p_detailcol_name => 'vrbl_rt_prfl_id'
541: ,p_lkup_name => 'ben_rt_prfl_cache.g_pg_lookup'
542: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'
543: ,p_lkup_query => l_lookup_query
544: ,p_inst_query => l_inst_query
545: ,p_instcolnm_set => l_instcolnm_set
546: );

Line 554: ,p_lookup_name => 'ben_rt_prfl_cache.g_pg_lookup'

550: -- Cache already populated. Get record set.
551: --
552: get_cached_data
553: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
554: ,p_lookup_name => 'ben_rt_prfl_cache.g_pg_lookup'
555: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'
556: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pg_inst_tbl'
557: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pg_out'
558: );

Line 555: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'

551: --
552: get_cached_data
553: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
554: ,p_lookup_name => 'ben_rt_prfl_cache.g_pg_lookup'
555: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'
556: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pg_inst_tbl'
557: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pg_out'
558: );
559: --

Line 556: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pg_inst_tbl'

552: get_cached_data
553: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
554: ,p_lookup_name => 'ben_rt_prfl_cache.g_pg_lookup'
555: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'
556: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pg_inst_tbl'
557: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pg_out'
558: );
559: --
560: p_inst_set := g_pg_out;

Line 557: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pg_out'

553: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
554: ,p_lookup_name => 'ben_rt_prfl_cache.g_pg_lookup'
555: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'
556: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pg_inst_tbl'
557: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pg_out'
558: );
559: --
560: p_inst_set := g_pg_out;
561: p_inst_count := g_inst_count;

Line 581: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_rl_inst_tbl

577: (p_vrbl_rt_prfl_id in number
578: ,p_effective_date in date
579: ,p_lf_evt_ocrd_dt in date
580: ,p_business_group_id in number
581: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_rl_inst_tbl
582: ,p_inst_count out nocopy number)
583: is
584: --
585: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache RULES';

Line 625: ,p_lkup_name => 'ben_rt_prfl_cache.g_rl_lookup'

621: l_instcolnm_set(1).caccol_name := 'formula_id';
622: ben_cache.write_mastDet_Cache
623: (p_mastercol_name => 'vrbl_rt_prfl_id'
624: ,p_detailcol_name => 'vrbl_rt_prfl_id'
625: ,p_lkup_name => 'ben_rt_prfl_cache.g_rl_lookup'
626: ,p_inst_name => 'ben_rt_prfl_cache.g_rl_instance'
627: ,p_lkup_query => l_lookup_query
628: ,p_inst_query => l_inst_query
629: ,p_instcolnm_set => l_instcolnm_set

Line 626: ,p_inst_name => 'ben_rt_prfl_cache.g_rl_instance'

622: ben_cache.write_mastDet_Cache
623: (p_mastercol_name => 'vrbl_rt_prfl_id'
624: ,p_detailcol_name => 'vrbl_rt_prfl_id'
625: ,p_lkup_name => 'ben_rt_prfl_cache.g_rl_lookup'
626: ,p_inst_name => 'ben_rt_prfl_cache.g_rl_instance'
627: ,p_lkup_query => l_lookup_query
628: ,p_inst_query => l_inst_query
629: ,p_instcolnm_set => l_instcolnm_set
630: );

Line 637: ,p_lookup_name => 'ben_rt_prfl_cache.g_rl_lookup'

633: -- Cache already populated. Get record set.
634: --
635: get_cached_data
636: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
637: ,p_lookup_name => 'ben_rt_prfl_cache.g_rl_lookup'
638: ,p_inst_name => 'ben_rt_prfl_cache.g_rl_instance'
639: ,p_inst_set_type => 'ben_rt_prfl_cache.g_rl_inst_tbl'
640: ,p_out_inst_name => 'ben_rt_prfl_cache.g_rl_out'
641: );

Line 638: ,p_inst_name => 'ben_rt_prfl_cache.g_rl_instance'

634: --
635: get_cached_data
636: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
637: ,p_lookup_name => 'ben_rt_prfl_cache.g_rl_lookup'
638: ,p_inst_name => 'ben_rt_prfl_cache.g_rl_instance'
639: ,p_inst_set_type => 'ben_rt_prfl_cache.g_rl_inst_tbl'
640: ,p_out_inst_name => 'ben_rt_prfl_cache.g_rl_out'
641: );
642: --

Line 639: ,p_inst_set_type => 'ben_rt_prfl_cache.g_rl_inst_tbl'

635: get_cached_data
636: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
637: ,p_lookup_name => 'ben_rt_prfl_cache.g_rl_lookup'
638: ,p_inst_name => 'ben_rt_prfl_cache.g_rl_instance'
639: ,p_inst_set_type => 'ben_rt_prfl_cache.g_rl_inst_tbl'
640: ,p_out_inst_name => 'ben_rt_prfl_cache.g_rl_out'
641: );
642: --
643: p_inst_set := g_rl_out;

Line 640: ,p_out_inst_name => 'ben_rt_prfl_cache.g_rl_out'

636: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
637: ,p_lookup_name => 'ben_rt_prfl_cache.g_rl_lookup'
638: ,p_inst_name => 'ben_rt_prfl_cache.g_rl_instance'
639: ,p_inst_set_type => 'ben_rt_prfl_cache.g_rl_inst_tbl'
640: ,p_out_inst_name => 'ben_rt_prfl_cache.g_rl_out'
641: );
642: --
643: p_inst_set := g_rl_out;
644: p_inst_count := g_inst_count;

Line 662: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_tbco_inst_tbl

658: (p_vrbl_rt_prfl_id in number
659: ,p_effective_date in date
660: ,p_lf_evt_ocrd_dt in date
661: ,p_business_group_id in number
662: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_tbco_inst_tbl
663: ,p_inst_count out nocopy number)
664: is
665: --
666: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 711: ,p_lkup_name => 'ben_rt_prfl_cache.g_tbco_lookup'

707: --
708: ben_cache.write_mastDet_Cache
709: (p_mastercol_name => 'vrbl_rt_prfl_id'
710: ,p_detailcol_name => 'vrbl_rt_prfl_id'
711: ,p_lkup_name => 'ben_rt_prfl_cache.g_tbco_lookup'
712: ,p_inst_name => 'ben_rt_prfl_cache.g_tbco_instance'
713: ,p_lkup_query => l_lookup_query
714: ,p_inst_query => l_inst_query
715: ,p_instcolnm_set => l_instcolnm_set

Line 712: ,p_inst_name => 'ben_rt_prfl_cache.g_tbco_instance'

708: ben_cache.write_mastDet_Cache
709: (p_mastercol_name => 'vrbl_rt_prfl_id'
710: ,p_detailcol_name => 'vrbl_rt_prfl_id'
711: ,p_lkup_name => 'ben_rt_prfl_cache.g_tbco_lookup'
712: ,p_inst_name => 'ben_rt_prfl_cache.g_tbco_instance'
713: ,p_lkup_query => l_lookup_query
714: ,p_inst_query => l_inst_query
715: ,p_instcolnm_set => l_instcolnm_set
716: );

Line 724: ,p_lookup_name => 'ben_rt_prfl_cache.g_tbco_lookup'

720: -- Cache already populated. Get record set.
721: --
722: get_cached_data
723: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
724: ,p_lookup_name => 'ben_rt_prfl_cache.g_tbco_lookup'
725: ,p_inst_name => 'ben_rt_prfl_cache.g_tbco_instance'
726: ,p_inst_set_type => 'ben_rt_prfl_cache.g_tbco_inst_tbl'
727: ,p_out_inst_name => 'ben_rt_prfl_cache.g_tbco_out'
728: );

Line 725: ,p_inst_name => 'ben_rt_prfl_cache.g_tbco_instance'

721: --
722: get_cached_data
723: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
724: ,p_lookup_name => 'ben_rt_prfl_cache.g_tbco_lookup'
725: ,p_inst_name => 'ben_rt_prfl_cache.g_tbco_instance'
726: ,p_inst_set_type => 'ben_rt_prfl_cache.g_tbco_inst_tbl'
727: ,p_out_inst_name => 'ben_rt_prfl_cache.g_tbco_out'
728: );
729: --

Line 726: ,p_inst_set_type => 'ben_rt_prfl_cache.g_tbco_inst_tbl'

722: get_cached_data
723: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
724: ,p_lookup_name => 'ben_rt_prfl_cache.g_tbco_lookup'
725: ,p_inst_name => 'ben_rt_prfl_cache.g_tbco_instance'
726: ,p_inst_set_type => 'ben_rt_prfl_cache.g_tbco_inst_tbl'
727: ,p_out_inst_name => 'ben_rt_prfl_cache.g_tbco_out'
728: );
729: --
730: p_inst_set := g_tbco_out;

Line 727: ,p_out_inst_name => 'ben_rt_prfl_cache.g_tbco_out'

723: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
724: ,p_lookup_name => 'ben_rt_prfl_cache.g_tbco_lookup'
725: ,p_inst_name => 'ben_rt_prfl_cache.g_tbco_instance'
726: ,p_inst_set_type => 'ben_rt_prfl_cache.g_tbco_inst_tbl'
727: ,p_out_inst_name => 'ben_rt_prfl_cache.g_tbco_out'
728: );
729: --
730: p_inst_set := g_tbco_out;
731: p_inst_count := g_inst_count;

Line 750: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_gndr_inst_tbl

746: (p_vrbl_rt_prfl_id in number
747: ,p_effective_date in date
748: ,p_lf_evt_ocrd_dt in date
749: ,p_business_group_id in number
750: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_gndr_inst_tbl
751: ,p_inst_count out nocopy number)
752: is
753: --
754: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 799: ,p_lkup_name => 'ben_rt_prfl_cache.g_gndr_lookup'

795: --
796: ben_cache.write_mastDet_Cache
797: (p_mastercol_name => 'vrbl_rt_prfl_id'
798: ,p_detailcol_name => 'vrbl_rt_prfl_id'
799: ,p_lkup_name => 'ben_rt_prfl_cache.g_gndr_lookup'
800: ,p_inst_name => 'ben_rt_prfl_cache.g_gndr_instance'
801: ,p_lkup_query => l_lookup_query
802: ,p_inst_query => l_inst_query
803: ,p_instcolnm_set => l_instcolnm_set

Line 800: ,p_inst_name => 'ben_rt_prfl_cache.g_gndr_instance'

796: ben_cache.write_mastDet_Cache
797: (p_mastercol_name => 'vrbl_rt_prfl_id'
798: ,p_detailcol_name => 'vrbl_rt_prfl_id'
799: ,p_lkup_name => 'ben_rt_prfl_cache.g_gndr_lookup'
800: ,p_inst_name => 'ben_rt_prfl_cache.g_gndr_instance'
801: ,p_lkup_query => l_lookup_query
802: ,p_inst_query => l_inst_query
803: ,p_instcolnm_set => l_instcolnm_set
804: );

Line 812: ,p_lookup_name => 'ben_rt_prfl_cache.g_gndr_lookup'

808: -- Cache already populated. Get record set.
809: --
810: get_cached_data
811: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
812: ,p_lookup_name => 'ben_rt_prfl_cache.g_gndr_lookup'
813: ,p_inst_name => 'ben_rt_prfl_cache.g_gndr_instance'
814: ,p_inst_set_type => 'ben_rt_prfl_cache.g_gndr_inst_tbl'
815: ,p_out_inst_name => 'ben_rt_prfl_cache.g_gndr_out'
816: );

Line 813: ,p_inst_name => 'ben_rt_prfl_cache.g_gndr_instance'

809: --
810: get_cached_data
811: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
812: ,p_lookup_name => 'ben_rt_prfl_cache.g_gndr_lookup'
813: ,p_inst_name => 'ben_rt_prfl_cache.g_gndr_instance'
814: ,p_inst_set_type => 'ben_rt_prfl_cache.g_gndr_inst_tbl'
815: ,p_out_inst_name => 'ben_rt_prfl_cache.g_gndr_out'
816: );
817: --

Line 814: ,p_inst_set_type => 'ben_rt_prfl_cache.g_gndr_inst_tbl'

810: get_cached_data
811: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
812: ,p_lookup_name => 'ben_rt_prfl_cache.g_gndr_lookup'
813: ,p_inst_name => 'ben_rt_prfl_cache.g_gndr_instance'
814: ,p_inst_set_type => 'ben_rt_prfl_cache.g_gndr_inst_tbl'
815: ,p_out_inst_name => 'ben_rt_prfl_cache.g_gndr_out'
816: );
817: --
818: p_inst_set := g_gndr_out;

Line 815: ,p_out_inst_name => 'ben_rt_prfl_cache.g_gndr_out'

811: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
812: ,p_lookup_name => 'ben_rt_prfl_cache.g_gndr_lookup'
813: ,p_inst_name => 'ben_rt_prfl_cache.g_gndr_instance'
814: ,p_inst_set_type => 'ben_rt_prfl_cache.g_gndr_inst_tbl'
815: ,p_out_inst_name => 'ben_rt_prfl_cache.g_gndr_out'
816: );
817: --
818: p_inst_set := g_gndr_out;
819: p_inst_count := g_inst_count;

Line 838: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_dsbld_inst_tbl

834: (p_vrbl_rt_prfl_id in number
835: ,p_effective_date in date
836: ,p_lf_evt_ocrd_dt in date
837: ,p_business_group_id in number
838: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_dsbld_inst_tbl
839: ,p_inst_count out nocopy number)
840: is
841: --
842: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 887: ,p_lkup_name => 'ben_rt_prfl_cache.g_dsbld_lookup'

883: --
884: ben_cache.write_mastDet_Cache
885: (p_mastercol_name => 'vrbl_rt_prfl_id'
886: ,p_detailcol_name => 'vrbl_rt_prfl_id'
887: ,p_lkup_name => 'ben_rt_prfl_cache.g_dsbld_lookup'
888: ,p_inst_name => 'ben_rt_prfl_cache.g_dsbld_instance'
889: ,p_lkup_query => l_lookup_query
890: ,p_inst_query => l_inst_query
891: ,p_instcolnm_set => l_instcolnm_set

Line 888: ,p_inst_name => 'ben_rt_prfl_cache.g_dsbld_instance'

884: ben_cache.write_mastDet_Cache
885: (p_mastercol_name => 'vrbl_rt_prfl_id'
886: ,p_detailcol_name => 'vrbl_rt_prfl_id'
887: ,p_lkup_name => 'ben_rt_prfl_cache.g_dsbld_lookup'
888: ,p_inst_name => 'ben_rt_prfl_cache.g_dsbld_instance'
889: ,p_lkup_query => l_lookup_query
890: ,p_inst_query => l_inst_query
891: ,p_instcolnm_set => l_instcolnm_set
892: );

Line 900: ,p_lookup_name => 'ben_rt_prfl_cache.g_dsbld_lookup'

896: -- Cache already populated. Get record set.
897: --
898: get_cached_data
899: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
900: ,p_lookup_name => 'ben_rt_prfl_cache.g_dsbld_lookup'
901: ,p_inst_name => 'ben_rt_prfl_cache.g_dsbld_instance'
902: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dsbld_inst_tbl'
903: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dsbld_out'
904: );

Line 901: ,p_inst_name => 'ben_rt_prfl_cache.g_dsbld_instance'

897: --
898: get_cached_data
899: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
900: ,p_lookup_name => 'ben_rt_prfl_cache.g_dsbld_lookup'
901: ,p_inst_name => 'ben_rt_prfl_cache.g_dsbld_instance'
902: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dsbld_inst_tbl'
903: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dsbld_out'
904: );
905: --

Line 902: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dsbld_inst_tbl'

898: get_cached_data
899: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
900: ,p_lookup_name => 'ben_rt_prfl_cache.g_dsbld_lookup'
901: ,p_inst_name => 'ben_rt_prfl_cache.g_dsbld_instance'
902: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dsbld_inst_tbl'
903: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dsbld_out'
904: );
905: --
906: p_inst_set := g_dsbld_out;

Line 903: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dsbld_out'

899: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
900: ,p_lookup_name => 'ben_rt_prfl_cache.g_dsbld_lookup'
901: ,p_inst_name => 'ben_rt_prfl_cache.g_dsbld_instance'
902: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dsbld_inst_tbl'
903: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dsbld_out'
904: );
905: --
906: p_inst_set := g_dsbld_out;
907: p_inst_count := g_inst_count;

Line 926: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_brgng_inst_tbl

922: (p_vrbl_rt_prfl_id in number
923: ,p_effective_date in date
924: ,p_lf_evt_ocrd_dt in date
925: ,p_business_group_id in number
926: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_brgng_inst_tbl
927: ,p_inst_count out nocopy number)
928: is
929: --
930: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 975: ,p_lkup_name => 'ben_rt_prfl_cache.g_brgng_lookup'

971: --
972: ben_cache.write_mastDet_Cache
973: (p_mastercol_name => 'vrbl_rt_prfl_id'
974: ,p_detailcol_name => 'vrbl_rt_prfl_id'
975: ,p_lkup_name => 'ben_rt_prfl_cache.g_brgng_lookup'
976: ,p_inst_name => 'ben_rt_prfl_cache.g_brgng_instance'
977: ,p_lkup_query => l_lookup_query
978: ,p_inst_query => l_inst_query
979: ,p_instcolnm_set => l_instcolnm_set

Line 976: ,p_inst_name => 'ben_rt_prfl_cache.g_brgng_instance'

972: ben_cache.write_mastDet_Cache
973: (p_mastercol_name => 'vrbl_rt_prfl_id'
974: ,p_detailcol_name => 'vrbl_rt_prfl_id'
975: ,p_lkup_name => 'ben_rt_prfl_cache.g_brgng_lookup'
976: ,p_inst_name => 'ben_rt_prfl_cache.g_brgng_instance'
977: ,p_lkup_query => l_lookup_query
978: ,p_inst_query => l_inst_query
979: ,p_instcolnm_set => l_instcolnm_set
980: );

Line 988: ,p_lookup_name => 'ben_rt_prfl_cache.g_brgng_lookup'

984: -- Cache already populated. Get record set.
985: --
986: get_cached_data
987: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
988: ,p_lookup_name => 'ben_rt_prfl_cache.g_brgng_lookup'
989: ,p_inst_name => 'ben_rt_prfl_cache.g_brgng_instance'
990: ,p_inst_set_type => 'ben_rt_prfl_cache.g_brgng_inst_tbl'
991: ,p_out_inst_name => 'ben_rt_prfl_cache.g_brgng_out'
992: );

Line 989: ,p_inst_name => 'ben_rt_prfl_cache.g_brgng_instance'

985: --
986: get_cached_data
987: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
988: ,p_lookup_name => 'ben_rt_prfl_cache.g_brgng_lookup'
989: ,p_inst_name => 'ben_rt_prfl_cache.g_brgng_instance'
990: ,p_inst_set_type => 'ben_rt_prfl_cache.g_brgng_inst_tbl'
991: ,p_out_inst_name => 'ben_rt_prfl_cache.g_brgng_out'
992: );
993: --

Line 990: ,p_inst_set_type => 'ben_rt_prfl_cache.g_brgng_inst_tbl'

986: get_cached_data
987: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
988: ,p_lookup_name => 'ben_rt_prfl_cache.g_brgng_lookup'
989: ,p_inst_name => 'ben_rt_prfl_cache.g_brgng_instance'
990: ,p_inst_set_type => 'ben_rt_prfl_cache.g_brgng_inst_tbl'
991: ,p_out_inst_name => 'ben_rt_prfl_cache.g_brgng_out'
992: );
993: --
994: p_inst_set := g_brgng_out;

Line 991: ,p_out_inst_name => 'ben_rt_prfl_cache.g_brgng_out'

987: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
988: ,p_lookup_name => 'ben_rt_prfl_cache.g_brgng_lookup'
989: ,p_inst_name => 'ben_rt_prfl_cache.g_brgng_instance'
990: ,p_inst_set_type => 'ben_rt_prfl_cache.g_brgng_inst_tbl'
991: ,p_out_inst_name => 'ben_rt_prfl_cache.g_brgng_out'
992: );
993: --
994: p_inst_set := g_brgng_out;
995: p_inst_count := g_inst_count;

Line 1014: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_bnfgrp_inst_tbl

1010: (p_vrbl_rt_prfl_id in number
1011: ,p_effective_date in date
1012: ,p_lf_evt_ocrd_dt in date
1013: ,p_business_group_id in number
1014: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_bnfgrp_inst_tbl
1015: ,p_inst_count out nocopy number)
1016: is
1017: --
1018: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 1063: ,p_lkup_name => 'ben_rt_prfl_cache.g_bnfgrp_lookup'

1059: --
1060: ben_cache.write_mastDet_Cache
1061: (p_mastercol_name => 'vrbl_rt_prfl_id'
1062: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1063: ,p_lkup_name => 'ben_rt_prfl_cache.g_bnfgrp_lookup'
1064: ,p_inst_name => 'ben_rt_prfl_cache.g_bnfgrp_instance'
1065: ,p_lkup_query => l_lookup_query
1066: ,p_inst_query => l_inst_query
1067: ,p_instcolnm_set => l_instcolnm_set

Line 1064: ,p_inst_name => 'ben_rt_prfl_cache.g_bnfgrp_instance'

1060: ben_cache.write_mastDet_Cache
1061: (p_mastercol_name => 'vrbl_rt_prfl_id'
1062: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1063: ,p_lkup_name => 'ben_rt_prfl_cache.g_bnfgrp_lookup'
1064: ,p_inst_name => 'ben_rt_prfl_cache.g_bnfgrp_instance'
1065: ,p_lkup_query => l_lookup_query
1066: ,p_inst_query => l_inst_query
1067: ,p_instcolnm_set => l_instcolnm_set
1068: );

Line 1076: ,p_lookup_name => 'ben_rt_prfl_cache.g_bnfgrp_lookup'

1072: -- Cache already populated. Get record set.
1073: --
1074: get_cached_data
1075: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1076: ,p_lookup_name => 'ben_rt_prfl_cache.g_bnfgrp_lookup'
1077: ,p_inst_name => 'ben_rt_prfl_cache.g_bnfgrp_instance'
1078: ,p_inst_set_type => 'ben_rt_prfl_cache.g_bnfgrp_inst_tbl'
1079: ,p_out_inst_name => 'ben_rt_prfl_cache.g_bnfgrp_out'
1080: );

Line 1077: ,p_inst_name => 'ben_rt_prfl_cache.g_bnfgrp_instance'

1073: --
1074: get_cached_data
1075: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1076: ,p_lookup_name => 'ben_rt_prfl_cache.g_bnfgrp_lookup'
1077: ,p_inst_name => 'ben_rt_prfl_cache.g_bnfgrp_instance'
1078: ,p_inst_set_type => 'ben_rt_prfl_cache.g_bnfgrp_inst_tbl'
1079: ,p_out_inst_name => 'ben_rt_prfl_cache.g_bnfgrp_out'
1080: );
1081: --

Line 1078: ,p_inst_set_type => 'ben_rt_prfl_cache.g_bnfgrp_inst_tbl'

1074: get_cached_data
1075: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1076: ,p_lookup_name => 'ben_rt_prfl_cache.g_bnfgrp_lookup'
1077: ,p_inst_name => 'ben_rt_prfl_cache.g_bnfgrp_instance'
1078: ,p_inst_set_type => 'ben_rt_prfl_cache.g_bnfgrp_inst_tbl'
1079: ,p_out_inst_name => 'ben_rt_prfl_cache.g_bnfgrp_out'
1080: );
1081: --
1082: p_inst_set := g_bnfgrp_out;

Line 1079: ,p_out_inst_name => 'ben_rt_prfl_cache.g_bnfgrp_out'

1075: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1076: ,p_lookup_name => 'ben_rt_prfl_cache.g_bnfgrp_lookup'
1077: ,p_inst_name => 'ben_rt_prfl_cache.g_bnfgrp_instance'
1078: ,p_inst_set_type => 'ben_rt_prfl_cache.g_bnfgrp_inst_tbl'
1079: ,p_out_inst_name => 'ben_rt_prfl_cache.g_bnfgrp_out'
1080: );
1081: --
1082: p_inst_set := g_bnfgrp_out;
1083: p_inst_count := g_inst_count;

Line 1102: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_eestat_inst_tbl

1098: (p_vrbl_rt_prfl_id in number
1099: ,p_effective_date in date
1100: ,p_lf_evt_ocrd_dt in date
1101: ,p_business_group_id in number
1102: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_eestat_inst_tbl
1103: ,p_inst_count out nocopy number)
1104: is
1105: --
1106: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 1152: ,p_lkup_name => 'ben_rt_prfl_cache.g_eestat_lookup'

1148: --
1149: ben_cache.write_mastDet_Cache
1150: (p_mastercol_name => 'vrbl_rt_prfl_id'
1151: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1152: ,p_lkup_name => 'ben_rt_prfl_cache.g_eestat_lookup'
1153: ,p_inst_name => 'ben_rt_prfl_cache.g_eestat_instance'
1154: ,p_lkup_query => l_lookup_query
1155: ,p_inst_query => l_inst_query
1156: ,p_instcolnm_set => l_instcolnm_set

Line 1153: ,p_inst_name => 'ben_rt_prfl_cache.g_eestat_instance'

1149: ben_cache.write_mastDet_Cache
1150: (p_mastercol_name => 'vrbl_rt_prfl_id'
1151: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1152: ,p_lkup_name => 'ben_rt_prfl_cache.g_eestat_lookup'
1153: ,p_inst_name => 'ben_rt_prfl_cache.g_eestat_instance'
1154: ,p_lkup_query => l_lookup_query
1155: ,p_inst_query => l_inst_query
1156: ,p_instcolnm_set => l_instcolnm_set
1157: );

Line 1165: ,p_lookup_name => 'ben_rt_prfl_cache.g_eestat_lookup'

1161: -- Cache already populated. Get record set.
1162: --
1163: get_cached_data
1164: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1165: ,p_lookup_name => 'ben_rt_prfl_cache.g_eestat_lookup'
1166: ,p_inst_name => 'ben_rt_prfl_cache.g_eestat_instance'
1167: ,p_inst_set_type => 'ben_rt_prfl_cache.g_eestat_inst_tbl'
1168: ,p_out_inst_name => 'ben_rt_prfl_cache.g_eestat_out'
1169: );

Line 1166: ,p_inst_name => 'ben_rt_prfl_cache.g_eestat_instance'

1162: --
1163: get_cached_data
1164: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1165: ,p_lookup_name => 'ben_rt_prfl_cache.g_eestat_lookup'
1166: ,p_inst_name => 'ben_rt_prfl_cache.g_eestat_instance'
1167: ,p_inst_set_type => 'ben_rt_prfl_cache.g_eestat_inst_tbl'
1168: ,p_out_inst_name => 'ben_rt_prfl_cache.g_eestat_out'
1169: );
1170: --

Line 1167: ,p_inst_set_type => 'ben_rt_prfl_cache.g_eestat_inst_tbl'

1163: get_cached_data
1164: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1165: ,p_lookup_name => 'ben_rt_prfl_cache.g_eestat_lookup'
1166: ,p_inst_name => 'ben_rt_prfl_cache.g_eestat_instance'
1167: ,p_inst_set_type => 'ben_rt_prfl_cache.g_eestat_inst_tbl'
1168: ,p_out_inst_name => 'ben_rt_prfl_cache.g_eestat_out'
1169: );
1170: --
1171: p_inst_set := g_eestat_out;

Line 1168: ,p_out_inst_name => 'ben_rt_prfl_cache.g_eestat_out'

1164: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1165: ,p_lookup_name => 'ben_rt_prfl_cache.g_eestat_lookup'
1166: ,p_inst_name => 'ben_rt_prfl_cache.g_eestat_instance'
1167: ,p_inst_set_type => 'ben_rt_prfl_cache.g_eestat_inst_tbl'
1168: ,p_out_inst_name => 'ben_rt_prfl_cache.g_eestat_out'
1169: );
1170: --
1171: p_inst_set := g_eestat_out;
1172: p_inst_count := g_inst_count;

Line 1191: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_ftpt_inst_tbl

1187: (p_vrbl_rt_prfl_id in number
1188: ,p_effective_date in date
1189: ,p_lf_evt_ocrd_dt in date
1190: ,p_business_group_id in number
1191: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_ftpt_inst_tbl
1192: ,p_inst_count out nocopy number) is
1193: --
1194: l_proc varchar2(72) := 'get_rt_prfl_cache';
1195: --

Line 1219: l_lkup_name := 'ben_rt_prfl_cache.g_ftpt_lookup';

1215: -- Build the cache
1216: --
1217: l_mastertab_name := 'ben_vrbl_rt_prfl_f';
1218: l_masterpkcol_name := 'vrbl_rt_prfl_id';
1219: l_lkup_name := 'ben_rt_prfl_cache.g_ftpt_lookup';
1220: l_inst_name := 'ben_rt_prfl_cache.g_ftpt_instance';
1221: --
1222: l_instcolnm_num := 0;
1223: --

Line 1220: l_inst_name := 'ben_rt_prfl_cache.g_ftpt_instance';

1216: --
1217: l_mastertab_name := 'ben_vrbl_rt_prfl_f';
1218: l_masterpkcol_name := 'vrbl_rt_prfl_id';
1219: l_lkup_name := 'ben_rt_prfl_cache.g_ftpt_lookup';
1220: l_inst_name := 'ben_rt_prfl_cache.g_ftpt_instance';
1221: --
1222: l_instcolnm_num := 0;
1223: --
1224: l_instcolnm_set(l_instcolnm_num).col_name := l_masterpkcol_name;

Line 1320: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_grd_inst_tbl

1316: (p_vrbl_rt_prfl_id in number
1317: ,p_effective_date in date
1318: ,p_lf_evt_ocrd_dt in date
1319: ,p_business_group_id in number
1320: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_grd_inst_tbl
1321: ,p_inst_count out nocopy number)
1322: is
1323: --
1324: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 1369: ,p_lkup_name => 'ben_rt_prfl_cache.g_grd_lookup'

1365: --
1366: ben_cache.write_mastDet_Cache
1367: (p_mastercol_name => 'vrbl_rt_prfl_id'
1368: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1369: ,p_lkup_name => 'ben_rt_prfl_cache.g_grd_lookup'
1370: ,p_inst_name => 'ben_rt_prfl_cache.g_grd_instance'
1371: ,p_lkup_query => l_lookup_query
1372: ,p_inst_query => l_inst_query
1373: ,p_instcolnm_set => l_instcolnm_set

Line 1370: ,p_inst_name => 'ben_rt_prfl_cache.g_grd_instance'

1366: ben_cache.write_mastDet_Cache
1367: (p_mastercol_name => 'vrbl_rt_prfl_id'
1368: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1369: ,p_lkup_name => 'ben_rt_prfl_cache.g_grd_lookup'
1370: ,p_inst_name => 'ben_rt_prfl_cache.g_grd_instance'
1371: ,p_lkup_query => l_lookup_query
1372: ,p_inst_query => l_inst_query
1373: ,p_instcolnm_set => l_instcolnm_set
1374: );

Line 1382: ,p_lookup_name => 'ben_rt_prfl_cache.g_grd_lookup'

1378: -- Cache already populated. Get record set.
1379: --
1380: get_cached_data
1381: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1382: ,p_lookup_name => 'ben_rt_prfl_cache.g_grd_lookup'
1383: ,p_inst_name => 'ben_rt_prfl_cache.g_grd_instance'
1384: ,p_inst_set_type => 'ben_rt_prfl_cache.g_grd_inst_tbl'
1385: ,p_out_inst_name => 'ben_rt_prfl_cache.g_grd_out'
1386: );

Line 1383: ,p_inst_name => 'ben_rt_prfl_cache.g_grd_instance'

1379: --
1380: get_cached_data
1381: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1382: ,p_lookup_name => 'ben_rt_prfl_cache.g_grd_lookup'
1383: ,p_inst_name => 'ben_rt_prfl_cache.g_grd_instance'
1384: ,p_inst_set_type => 'ben_rt_prfl_cache.g_grd_inst_tbl'
1385: ,p_out_inst_name => 'ben_rt_prfl_cache.g_grd_out'
1386: );
1387: --

Line 1384: ,p_inst_set_type => 'ben_rt_prfl_cache.g_grd_inst_tbl'

1380: get_cached_data
1381: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1382: ,p_lookup_name => 'ben_rt_prfl_cache.g_grd_lookup'
1383: ,p_inst_name => 'ben_rt_prfl_cache.g_grd_instance'
1384: ,p_inst_set_type => 'ben_rt_prfl_cache.g_grd_inst_tbl'
1385: ,p_out_inst_name => 'ben_rt_prfl_cache.g_grd_out'
1386: );
1387: --
1388: p_inst_set := g_grd_out;

Line 1385: ,p_out_inst_name => 'ben_rt_prfl_cache.g_grd_out'

1381: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1382: ,p_lookup_name => 'ben_rt_prfl_cache.g_grd_lookup'
1383: ,p_inst_name => 'ben_rt_prfl_cache.g_grd_instance'
1384: ,p_inst_set_type => 'ben_rt_prfl_cache.g_grd_inst_tbl'
1385: ,p_out_inst_name => 'ben_rt_prfl_cache.g_grd_out'
1386: );
1387: --
1388: p_inst_set := g_grd_out;
1389: p_inst_count := g_inst_count;

Line 1408: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_pctft_inst_tbl

1404: (p_vrbl_rt_prfl_id in number
1405: ,p_effective_date in date
1406: ,p_lf_evt_ocrd_dt in date
1407: ,p_business_group_id in number
1408: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_pctft_inst_tbl
1409: ,p_inst_count out nocopy number)
1410: is
1411: --
1412: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 1465: ,p_lkup_name => 'ben_rt_prfl_cache.g_pctft_lookup'

1461: --
1462: ben_cache.write_mastDet_Cache
1463: (p_mastercol_name => 'vrbl_rt_prfl_id'
1464: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1465: ,p_lkup_name => 'ben_rt_prfl_cache.g_pctft_lookup'
1466: ,p_inst_name => 'ben_rt_prfl_cache.g_pctft_instance'
1467: ,p_lkup_query => l_lookup_query
1468: ,p_inst_query => l_inst_query
1469: ,p_instcolnm_set => l_instcolnm_set

Line 1466: ,p_inst_name => 'ben_rt_prfl_cache.g_pctft_instance'

1462: ben_cache.write_mastDet_Cache
1463: (p_mastercol_name => 'vrbl_rt_prfl_id'
1464: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1465: ,p_lkup_name => 'ben_rt_prfl_cache.g_pctft_lookup'
1466: ,p_inst_name => 'ben_rt_prfl_cache.g_pctft_instance'
1467: ,p_lkup_query => l_lookup_query
1468: ,p_inst_query => l_inst_query
1469: ,p_instcolnm_set => l_instcolnm_set
1470: );

Line 1478: ,p_lookup_name => 'ben_rt_prfl_cache.g_pctft_lookup'

1474: -- Cache already populated. Get record set.
1475: --
1476: get_cached_data
1477: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1478: ,p_lookup_name => 'ben_rt_prfl_cache.g_pctft_lookup'
1479: ,p_inst_name => 'ben_rt_prfl_cache.g_pctft_instance'
1480: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pctft_inst_tbl'
1481: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pctft_out'
1482: );

Line 1479: ,p_inst_name => 'ben_rt_prfl_cache.g_pctft_instance'

1475: --
1476: get_cached_data
1477: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1478: ,p_lookup_name => 'ben_rt_prfl_cache.g_pctft_lookup'
1479: ,p_inst_name => 'ben_rt_prfl_cache.g_pctft_instance'
1480: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pctft_inst_tbl'
1481: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pctft_out'
1482: );
1483: --

Line 1480: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pctft_inst_tbl'

1476: get_cached_data
1477: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1478: ,p_lookup_name => 'ben_rt_prfl_cache.g_pctft_lookup'
1479: ,p_inst_name => 'ben_rt_prfl_cache.g_pctft_instance'
1480: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pctft_inst_tbl'
1481: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pctft_out'
1482: );
1483: --
1484: p_inst_set := g_pctft_out;

Line 1481: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pctft_out'

1477: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1478: ,p_lookup_name => 'ben_rt_prfl_cache.g_pctft_lookup'
1479: ,p_inst_name => 'ben_rt_prfl_cache.g_pctft_instance'
1480: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pctft_inst_tbl'
1481: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pctft_out'
1482: );
1483: --
1484: p_inst_set := g_pctft_out;
1485: p_inst_count := g_inst_count;

Line 1504: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_hrswkd_inst_tbl

1500: (p_vrbl_rt_prfl_id in number
1501: ,p_effective_date in date
1502: ,p_lf_evt_ocrd_dt in date
1503: ,p_business_group_id in number
1504: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_hrswkd_inst_tbl
1505: ,p_inst_count out nocopy number)
1506: is
1507: --
1508: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 1561: ,p_lkup_name => 'ben_rt_prfl_cache.g_hrswkd_lookup'

1557: --
1558: ben_cache.write_mastDet_Cache
1559: (p_mastercol_name => 'vrbl_rt_prfl_id'
1560: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1561: ,p_lkup_name => 'ben_rt_prfl_cache.g_hrswkd_lookup'
1562: ,p_inst_name => 'ben_rt_prfl_cache.g_hrswkd_instance'
1563: ,p_lkup_query => l_lookup_query
1564: ,p_inst_query => l_inst_query
1565: ,p_instcolnm_set => l_instcolnm_set

Line 1562: ,p_inst_name => 'ben_rt_prfl_cache.g_hrswkd_instance'

1558: ben_cache.write_mastDet_Cache
1559: (p_mastercol_name => 'vrbl_rt_prfl_id'
1560: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1561: ,p_lkup_name => 'ben_rt_prfl_cache.g_hrswkd_lookup'
1562: ,p_inst_name => 'ben_rt_prfl_cache.g_hrswkd_instance'
1563: ,p_lkup_query => l_lookup_query
1564: ,p_inst_query => l_inst_query
1565: ,p_instcolnm_set => l_instcolnm_set
1566: );

Line 1574: ,p_lookup_name => 'ben_rt_prfl_cache.g_hrswkd_lookup'

1570: -- Cache already populated. Get record set.
1571: --
1572: get_cached_data
1573: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1574: ,p_lookup_name => 'ben_rt_prfl_cache.g_hrswkd_lookup'
1575: ,p_inst_name => 'ben_rt_prfl_cache.g_hrswkd_instance'
1576: ,p_inst_set_type => 'ben_rt_prfl_cache.g_hrswkd_inst_tbl'
1577: ,p_out_inst_name => 'ben_rt_prfl_cache.g_hrswkd_out'
1578: );

Line 1575: ,p_inst_name => 'ben_rt_prfl_cache.g_hrswkd_instance'

1571: --
1572: get_cached_data
1573: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1574: ,p_lookup_name => 'ben_rt_prfl_cache.g_hrswkd_lookup'
1575: ,p_inst_name => 'ben_rt_prfl_cache.g_hrswkd_instance'
1576: ,p_inst_set_type => 'ben_rt_prfl_cache.g_hrswkd_inst_tbl'
1577: ,p_out_inst_name => 'ben_rt_prfl_cache.g_hrswkd_out'
1578: );
1579: --

Line 1576: ,p_inst_set_type => 'ben_rt_prfl_cache.g_hrswkd_inst_tbl'

1572: get_cached_data
1573: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1574: ,p_lookup_name => 'ben_rt_prfl_cache.g_hrswkd_lookup'
1575: ,p_inst_name => 'ben_rt_prfl_cache.g_hrswkd_instance'
1576: ,p_inst_set_type => 'ben_rt_prfl_cache.g_hrswkd_inst_tbl'
1577: ,p_out_inst_name => 'ben_rt_prfl_cache.g_hrswkd_out'
1578: );
1579: --
1580: p_inst_set := g_hrswkd_out;

Line 1577: ,p_out_inst_name => 'ben_rt_prfl_cache.g_hrswkd_out'

1573: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1574: ,p_lookup_name => 'ben_rt_prfl_cache.g_hrswkd_lookup'
1575: ,p_inst_name => 'ben_rt_prfl_cache.g_hrswkd_instance'
1576: ,p_inst_set_type => 'ben_rt_prfl_cache.g_hrswkd_inst_tbl'
1577: ,p_out_inst_name => 'ben_rt_prfl_cache.g_hrswkd_out'
1578: );
1579: --
1580: p_inst_set := g_hrswkd_out;
1581: p_inst_count := g_inst_count;

Line 1600: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_poe_inst_tbl

1596: (p_vrbl_rt_prfl_id in number
1597: ,p_effective_date in date
1598: ,p_lf_evt_ocrd_dt in date
1599: ,p_business_group_id in number
1600: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_poe_inst_tbl
1601: ,p_inst_count out nocopy number)
1602: is
1603: --
1604: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 1663: ,p_lkup_name => 'ben_rt_prfl_cache.g_poe_lookup'

1659: --
1660: ben_cache.write_mastDet_Cache
1661: (p_mastercol_name => 'vrbl_rt_prfl_id'
1662: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1663: ,p_lkup_name => 'ben_rt_prfl_cache.g_poe_lookup'
1664: ,p_inst_name => 'ben_rt_prfl_cache.g_poe_instance'
1665: ,p_lkup_query => l_lookup_query
1666: ,p_inst_query => l_inst_query
1667: ,p_instcolnm_set => l_instcolnm_set

Line 1664: ,p_inst_name => 'ben_rt_prfl_cache.g_poe_instance'

1660: ben_cache.write_mastDet_Cache
1661: (p_mastercol_name => 'vrbl_rt_prfl_id'
1662: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1663: ,p_lkup_name => 'ben_rt_prfl_cache.g_poe_lookup'
1664: ,p_inst_name => 'ben_rt_prfl_cache.g_poe_instance'
1665: ,p_lkup_query => l_lookup_query
1666: ,p_inst_query => l_inst_query
1667: ,p_instcolnm_set => l_instcolnm_set
1668: );

Line 1676: ,p_lookup_name => 'ben_rt_prfl_cache.g_poe_lookup'

1672: -- Cache already populated. Get record set.
1673: --
1674: get_cached_data
1675: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1676: ,p_lookup_name => 'ben_rt_prfl_cache.g_poe_lookup'
1677: ,p_inst_name => 'ben_rt_prfl_cache.g_poe_instance'
1678: ,p_inst_set_type => 'ben_rt_prfl_cache.g_poe_inst_tbl'
1679: ,p_out_inst_name => 'ben_rt_prfl_cache.g_poe_out'
1680: );

Line 1677: ,p_inst_name => 'ben_rt_prfl_cache.g_poe_instance'

1673: --
1674: get_cached_data
1675: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1676: ,p_lookup_name => 'ben_rt_prfl_cache.g_poe_lookup'
1677: ,p_inst_name => 'ben_rt_prfl_cache.g_poe_instance'
1678: ,p_inst_set_type => 'ben_rt_prfl_cache.g_poe_inst_tbl'
1679: ,p_out_inst_name => 'ben_rt_prfl_cache.g_poe_out'
1680: );
1681: --

Line 1678: ,p_inst_set_type => 'ben_rt_prfl_cache.g_poe_inst_tbl'

1674: get_cached_data
1675: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1676: ,p_lookup_name => 'ben_rt_prfl_cache.g_poe_lookup'
1677: ,p_inst_name => 'ben_rt_prfl_cache.g_poe_instance'
1678: ,p_inst_set_type => 'ben_rt_prfl_cache.g_poe_inst_tbl'
1679: ,p_out_inst_name => 'ben_rt_prfl_cache.g_poe_out'
1680: );
1681: --
1682: p_inst_set := g_poe_out;

Line 1679: ,p_out_inst_name => 'ben_rt_prfl_cache.g_poe_out'

1675: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1676: ,p_lookup_name => 'ben_rt_prfl_cache.g_poe_lookup'
1677: ,p_inst_name => 'ben_rt_prfl_cache.g_poe_instance'
1678: ,p_inst_set_type => 'ben_rt_prfl_cache.g_poe_inst_tbl'
1679: ,p_out_inst_name => 'ben_rt_prfl_cache.g_poe_out'
1680: );
1681: --
1682: p_inst_set := g_poe_out;
1683: p_inst_count := g_inst_count;

Line 1702: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_lbrmmbr_inst_tbl

1698: (p_vrbl_rt_prfl_id in number
1699: ,p_effective_date in date
1700: ,p_lf_evt_ocrd_dt in date
1701: ,p_business_group_id in number
1702: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_lbrmmbr_inst_tbl
1703: ,p_inst_count out nocopy number)
1704: is
1705: --
1706: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 1751: ,p_lkup_name => 'ben_rt_prfl_cache.g_lbrmmbr_lookup'

1747: --
1748: ben_cache.write_mastDet_Cache
1749: (p_mastercol_name => 'vrbl_rt_prfl_id'
1750: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1751: ,p_lkup_name => 'ben_rt_prfl_cache.g_lbrmmbr_lookup'
1752: ,p_inst_name => 'ben_rt_prfl_cache.g_lbrmmbr_instance'
1753: ,p_lkup_query => l_lookup_query
1754: ,p_inst_query => l_inst_query
1755: ,p_instcolnm_set => l_instcolnm_set

Line 1752: ,p_inst_name => 'ben_rt_prfl_cache.g_lbrmmbr_instance'

1748: ben_cache.write_mastDet_Cache
1749: (p_mastercol_name => 'vrbl_rt_prfl_id'
1750: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1751: ,p_lkup_name => 'ben_rt_prfl_cache.g_lbrmmbr_lookup'
1752: ,p_inst_name => 'ben_rt_prfl_cache.g_lbrmmbr_instance'
1753: ,p_lkup_query => l_lookup_query
1754: ,p_inst_query => l_inst_query
1755: ,p_instcolnm_set => l_instcolnm_set
1756: );

Line 1764: ,p_lookup_name => 'ben_rt_prfl_cache.g_lbrmmbr_lookup'

1760: -- Cache already populated. Get record set.
1761: --
1762: get_cached_data
1763: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1764: ,p_lookup_name => 'ben_rt_prfl_cache.g_lbrmmbr_lookup'
1765: ,p_inst_name => 'ben_rt_prfl_cache.g_lbrmmbr_instance'
1766: ,p_inst_set_type => 'ben_rt_prfl_cache.g_lbrmmbr_inst_tbl'
1767: ,p_out_inst_name => 'ben_rt_prfl_cache.g_lbrmmbr_out'
1768: );

Line 1765: ,p_inst_name => 'ben_rt_prfl_cache.g_lbrmmbr_instance'

1761: --
1762: get_cached_data
1763: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1764: ,p_lookup_name => 'ben_rt_prfl_cache.g_lbrmmbr_lookup'
1765: ,p_inst_name => 'ben_rt_prfl_cache.g_lbrmmbr_instance'
1766: ,p_inst_set_type => 'ben_rt_prfl_cache.g_lbrmmbr_inst_tbl'
1767: ,p_out_inst_name => 'ben_rt_prfl_cache.g_lbrmmbr_out'
1768: );
1769: --

Line 1766: ,p_inst_set_type => 'ben_rt_prfl_cache.g_lbrmmbr_inst_tbl'

1762: get_cached_data
1763: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1764: ,p_lookup_name => 'ben_rt_prfl_cache.g_lbrmmbr_lookup'
1765: ,p_inst_name => 'ben_rt_prfl_cache.g_lbrmmbr_instance'
1766: ,p_inst_set_type => 'ben_rt_prfl_cache.g_lbrmmbr_inst_tbl'
1767: ,p_out_inst_name => 'ben_rt_prfl_cache.g_lbrmmbr_out'
1768: );
1769: --
1770: p_inst_set := g_lbrmmbr_out;

Line 1767: ,p_out_inst_name => 'ben_rt_prfl_cache.g_lbrmmbr_out'

1763: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1764: ,p_lookup_name => 'ben_rt_prfl_cache.g_lbrmmbr_lookup'
1765: ,p_inst_name => 'ben_rt_prfl_cache.g_lbrmmbr_instance'
1766: ,p_inst_set_type => 'ben_rt_prfl_cache.g_lbrmmbr_inst_tbl'
1767: ,p_out_inst_name => 'ben_rt_prfl_cache.g_lbrmmbr_out'
1768: );
1769: --
1770: p_inst_set := g_lbrmmbr_out;
1771: p_inst_count := g_inst_count;

Line 1790: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_lglenty_inst_tbl

1786: (p_vrbl_rt_prfl_id in number
1787: ,p_effective_date in date
1788: ,p_lf_evt_ocrd_dt in date
1789: ,p_business_group_id in number
1790: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_lglenty_inst_tbl
1791: ,p_inst_count out nocopy number)
1792: is
1793: --
1794: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 1839: ,p_lkup_name => 'ben_rt_prfl_cache.g_lglenty_lookup'

1835: --
1836: ben_cache.write_mastDet_Cache
1837: (p_mastercol_name => 'vrbl_rt_prfl_id'
1838: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1839: ,p_lkup_name => 'ben_rt_prfl_cache.g_lglenty_lookup'
1840: ,p_inst_name => 'ben_rt_prfl_cache.g_lglenty_instance'
1841: ,p_lkup_query => l_lookup_query
1842: ,p_inst_query => l_inst_query
1843: ,p_instcolnm_set => l_instcolnm_set

Line 1840: ,p_inst_name => 'ben_rt_prfl_cache.g_lglenty_instance'

1836: ben_cache.write_mastDet_Cache
1837: (p_mastercol_name => 'vrbl_rt_prfl_id'
1838: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1839: ,p_lkup_name => 'ben_rt_prfl_cache.g_lglenty_lookup'
1840: ,p_inst_name => 'ben_rt_prfl_cache.g_lglenty_instance'
1841: ,p_lkup_query => l_lookup_query
1842: ,p_inst_query => l_inst_query
1843: ,p_instcolnm_set => l_instcolnm_set
1844: );

Line 1852: ,p_lookup_name => 'ben_rt_prfl_cache.g_lglenty_lookup'

1848: -- Cache already populated. Get record set.
1849: --
1850: get_cached_data
1851: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1852: ,p_lookup_name => 'ben_rt_prfl_cache.g_lglenty_lookup'
1853: ,p_inst_name => 'ben_rt_prfl_cache.g_lglenty_instance'
1854: ,p_inst_set_type => 'ben_rt_prfl_cache.g_lglenty_inst_tbl'
1855: ,p_out_inst_name => 'ben_rt_prfl_cache.g_lglenty_out'
1856: );

Line 1853: ,p_inst_name => 'ben_rt_prfl_cache.g_lglenty_instance'

1849: --
1850: get_cached_data
1851: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1852: ,p_lookup_name => 'ben_rt_prfl_cache.g_lglenty_lookup'
1853: ,p_inst_name => 'ben_rt_prfl_cache.g_lglenty_instance'
1854: ,p_inst_set_type => 'ben_rt_prfl_cache.g_lglenty_inst_tbl'
1855: ,p_out_inst_name => 'ben_rt_prfl_cache.g_lglenty_out'
1856: );
1857: --

Line 1854: ,p_inst_set_type => 'ben_rt_prfl_cache.g_lglenty_inst_tbl'

1850: get_cached_data
1851: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1852: ,p_lookup_name => 'ben_rt_prfl_cache.g_lglenty_lookup'
1853: ,p_inst_name => 'ben_rt_prfl_cache.g_lglenty_instance'
1854: ,p_inst_set_type => 'ben_rt_prfl_cache.g_lglenty_inst_tbl'
1855: ,p_out_inst_name => 'ben_rt_prfl_cache.g_lglenty_out'
1856: );
1857: --
1858: p_inst_set := g_lglenty_out;

Line 1855: ,p_out_inst_name => 'ben_rt_prfl_cache.g_lglenty_out'

1851: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1852: ,p_lookup_name => 'ben_rt_prfl_cache.g_lglenty_lookup'
1853: ,p_inst_name => 'ben_rt_prfl_cache.g_lglenty_instance'
1854: ,p_inst_set_type => 'ben_rt_prfl_cache.g_lglenty_inst_tbl'
1855: ,p_out_inst_name => 'ben_rt_prfl_cache.g_lglenty_out'
1856: );
1857: --
1858: p_inst_set := g_lglenty_out;
1859: p_inst_count := g_inst_count;

Line 1878: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_loa_inst_tbl

1874: (p_vrbl_rt_prfl_id in number
1875: ,p_effective_date in date
1876: ,p_lf_evt_ocrd_dt in date
1877: ,p_business_group_id in number
1878: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_loa_inst_tbl
1879: ,p_inst_count out nocopy number) is
1880: --
1881: l_proc varchar2(72) := 'get_rt_prfl_cache';
1882: --

Line 1906: l_lkup_name := 'ben_rt_prfl_cache.g_loa_lookup';

1902: -- Build the cache
1903: --
1904: l_mastertab_name := 'ben_vrbl_rt_prfl_f';
1905: l_masterpkcol_name := 'vrbl_rt_prfl_id';
1906: l_lkup_name := 'ben_rt_prfl_cache.g_loa_lookup';
1907: l_inst_name := 'ben_rt_prfl_cache.g_loa_instance';
1908: --
1909: l_instcolnm_num := 0;
1910: --

Line 1907: l_inst_name := 'ben_rt_prfl_cache.g_loa_instance';

1903: --
1904: l_mastertab_name := 'ben_vrbl_rt_prfl_f';
1905: l_masterpkcol_name := 'vrbl_rt_prfl_id';
1906: l_lkup_name := 'ben_rt_prfl_cache.g_loa_lookup';
1907: l_inst_name := 'ben_rt_prfl_cache.g_loa_instance';
1908: --
1909: l_instcolnm_num := 0;
1910: --
1911: l_instcolnm_set(l_instcolnm_num).col_name := l_masterpkcol_name;

Line 2012: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_org_inst_tbl

2008: (p_vrbl_rt_prfl_id in number
2009: ,p_effective_date in date
2010: ,p_lf_evt_ocrd_dt in date
2011: ,p_business_group_id in number
2012: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_org_inst_tbl
2013: ,p_inst_count out nocopy number) is
2014: --
2015: l_proc varchar2(72) := 'get_rt_prfl_cache';
2016: --

Line 2040: l_lkup_name := 'ben_rt_prfl_cache.g_org_lookup';

2036: -- Build the cache
2037: --
2038: l_mastertab_name := 'ben_vrbl_rt_prfl_f';
2039: l_masterpkcol_name := 'vrbl_rt_prfl_id';
2040: l_lkup_name := 'ben_rt_prfl_cache.g_org_lookup';
2041: l_inst_name := 'ben_rt_prfl_cache.g_org_instance';
2042: --
2043: l_instcolnm_num := 0;
2044: --

Line 2041: l_inst_name := 'ben_rt_prfl_cache.g_org_instance';

2037: --
2038: l_mastertab_name := 'ben_vrbl_rt_prfl_f';
2039: l_masterpkcol_name := 'vrbl_rt_prfl_id';
2040: l_lkup_name := 'ben_rt_prfl_cache.g_org_lookup';
2041: l_inst_name := 'ben_rt_prfl_cache.g_org_instance';
2042: --
2043: l_instcolnm_num := 0;
2044: --
2045: l_instcolnm_set(l_instcolnm_num).col_name := l_masterpkcol_name;

Line 2141: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_pertyp_inst_tbl

2137: (p_vrbl_rt_prfl_id in number
2138: ,p_effective_date in date
2139: ,p_lf_evt_ocrd_dt in date
2140: ,p_business_group_id in number
2141: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_pertyp_inst_tbl
2142: ,p_inst_count out nocopy number)
2143: is
2144: --
2145: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 2197: ,p_lkup_name => 'ben_rt_prfl_cache.g_pertyp_lookup'

2193: --
2194: ben_cache.write_mastDet_Cache
2195: (p_mastercol_name => 'vrbl_rt_prfl_id'
2196: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2197: ,p_lkup_name => 'ben_rt_prfl_cache.g_pertyp_lookup'
2198: ,p_inst_name => 'ben_rt_prfl_cache.g_pertyp_instance'
2199: ,p_lkup_query => l_lookup_query
2200: ,p_inst_query => l_inst_query
2201: ,p_instcolnm_set => l_instcolnm_set

Line 2198: ,p_inst_name => 'ben_rt_prfl_cache.g_pertyp_instance'

2194: ben_cache.write_mastDet_Cache
2195: (p_mastercol_name => 'vrbl_rt_prfl_id'
2196: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2197: ,p_lkup_name => 'ben_rt_prfl_cache.g_pertyp_lookup'
2198: ,p_inst_name => 'ben_rt_prfl_cache.g_pertyp_instance'
2199: ,p_lkup_query => l_lookup_query
2200: ,p_inst_query => l_inst_query
2201: ,p_instcolnm_set => l_instcolnm_set
2202: );

Line 2210: ,p_lookup_name => 'ben_rt_prfl_cache.g_pertyp_lookup'

2206: -- Cache already populated. Get record set.
2207: --
2208: get_cached_data
2209: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2210: ,p_lookup_name => 'ben_rt_prfl_cache.g_pertyp_lookup'
2211: ,p_inst_name => 'ben_rt_prfl_cache.g_pertyp_instance'
2212: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pertyp_inst_tbl'
2213: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pertyp_out'
2214: );

Line 2211: ,p_inst_name => 'ben_rt_prfl_cache.g_pertyp_instance'

2207: --
2208: get_cached_data
2209: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2210: ,p_lookup_name => 'ben_rt_prfl_cache.g_pertyp_lookup'
2211: ,p_inst_name => 'ben_rt_prfl_cache.g_pertyp_instance'
2212: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pertyp_inst_tbl'
2213: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pertyp_out'
2214: );
2215: --

Line 2212: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pertyp_inst_tbl'

2208: get_cached_data
2209: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2210: ,p_lookup_name => 'ben_rt_prfl_cache.g_pertyp_lookup'
2211: ,p_inst_name => 'ben_rt_prfl_cache.g_pertyp_instance'
2212: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pertyp_inst_tbl'
2213: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pertyp_out'
2214: );
2215: --
2216: p_inst_set := g_pertyp_out;

Line 2213: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pertyp_out'

2209: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2210: ,p_lookup_name => 'ben_rt_prfl_cache.g_pertyp_lookup'
2211: ,p_inst_name => 'ben_rt_prfl_cache.g_pertyp_instance'
2212: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pertyp_inst_tbl'
2213: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pertyp_out'
2214: );
2215: --
2216: p_inst_set := g_pertyp_out;
2217: p_inst_count := g_inst_count;

Line 2236: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_ziprng_inst_tbl

2232: (p_vrbl_rt_prfl_id in number
2233: ,p_effective_date in date
2234: ,p_lf_evt_ocrd_dt in date
2235: ,p_business_group_id in number
2236: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_ziprng_inst_tbl
2237: ,p_inst_count out nocopy number)
2238: is
2239: --
2240: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 2289: ,p_lkup_name => 'ben_rt_prfl_cache.g_ziprng_lookup'

2285: --
2286: ben_cache.write_mastDet_Cache
2287: (p_mastercol_name => 'vrbl_rt_prfl_id'
2288: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2289: ,p_lkup_name => 'ben_rt_prfl_cache.g_ziprng_lookup'
2290: ,p_inst_name => 'ben_rt_prfl_cache.g_ziprng_instance'
2291: ,p_lkup_query => l_lookup_query
2292: ,p_inst_query => l_inst_query
2293: ,p_instcolnm_set => l_instcolnm_set

Line 2290: ,p_inst_name => 'ben_rt_prfl_cache.g_ziprng_instance'

2286: ben_cache.write_mastDet_Cache
2287: (p_mastercol_name => 'vrbl_rt_prfl_id'
2288: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2289: ,p_lkup_name => 'ben_rt_prfl_cache.g_ziprng_lookup'
2290: ,p_inst_name => 'ben_rt_prfl_cache.g_ziprng_instance'
2291: ,p_lkup_query => l_lookup_query
2292: ,p_inst_query => l_inst_query
2293: ,p_instcolnm_set => l_instcolnm_set
2294: );

Line 2302: ,p_lookup_name => 'ben_rt_prfl_cache.g_ziprng_lookup'

2298: -- Cache already populated. Get record set.
2299: --
2300: get_cached_data
2301: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2302: ,p_lookup_name => 'ben_rt_prfl_cache.g_ziprng_lookup'
2303: ,p_inst_name => 'ben_rt_prfl_cache.g_ziprng_instance'
2304: ,p_inst_set_type => 'ben_rt_prfl_cache.g_ziprng_inst_tbl'
2305: ,p_out_inst_name => 'ben_rt_prfl_cache.g_ziprng_out'
2306: );

Line 2303: ,p_inst_name => 'ben_rt_prfl_cache.g_ziprng_instance'

2299: --
2300: get_cached_data
2301: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2302: ,p_lookup_name => 'ben_rt_prfl_cache.g_ziprng_lookup'
2303: ,p_inst_name => 'ben_rt_prfl_cache.g_ziprng_instance'
2304: ,p_inst_set_type => 'ben_rt_prfl_cache.g_ziprng_inst_tbl'
2305: ,p_out_inst_name => 'ben_rt_prfl_cache.g_ziprng_out'
2306: );
2307: --

Line 2304: ,p_inst_set_type => 'ben_rt_prfl_cache.g_ziprng_inst_tbl'

2300: get_cached_data
2301: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2302: ,p_lookup_name => 'ben_rt_prfl_cache.g_ziprng_lookup'
2303: ,p_inst_name => 'ben_rt_prfl_cache.g_ziprng_instance'
2304: ,p_inst_set_type => 'ben_rt_prfl_cache.g_ziprng_inst_tbl'
2305: ,p_out_inst_name => 'ben_rt_prfl_cache.g_ziprng_out'
2306: );
2307: --
2308: p_inst_set := g_ziprng_out;

Line 2305: ,p_out_inst_name => 'ben_rt_prfl_cache.g_ziprng_out'

2301: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2302: ,p_lookup_name => 'ben_rt_prfl_cache.g_ziprng_lookup'
2303: ,p_inst_name => 'ben_rt_prfl_cache.g_ziprng_instance'
2304: ,p_inst_set_type => 'ben_rt_prfl_cache.g_ziprng_inst_tbl'
2305: ,p_out_inst_name => 'ben_rt_prfl_cache.g_ziprng_out'
2306: );
2307: --
2308: p_inst_set := g_ziprng_out;
2309: p_inst_count := g_inst_count;

Line 2328: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_pyrl_inst_tbl

2324: (p_vrbl_rt_prfl_id in number
2325: ,p_effective_date in date
2326: ,p_lf_evt_ocrd_dt in date
2327: ,p_business_group_id in number
2328: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_pyrl_inst_tbl
2329: ,p_inst_count out nocopy number)
2330: is
2331: --
2332: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 2377: ,p_lkup_name => 'ben_rt_prfl_cache.g_pyrl_lookup'

2373: --
2374: ben_cache.write_mastDet_Cache
2375: (p_mastercol_name => 'vrbl_rt_prfl_id'
2376: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2377: ,p_lkup_name => 'ben_rt_prfl_cache.g_pyrl_lookup'
2378: ,p_inst_name => 'ben_rt_prfl_cache.g_pyrl_instance'
2379: ,p_lkup_query => l_lookup_query
2380: ,p_inst_query => l_inst_query
2381: ,p_instcolnm_set => l_instcolnm_set

Line 2378: ,p_inst_name => 'ben_rt_prfl_cache.g_pyrl_instance'

2374: ben_cache.write_mastDet_Cache
2375: (p_mastercol_name => 'vrbl_rt_prfl_id'
2376: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2377: ,p_lkup_name => 'ben_rt_prfl_cache.g_pyrl_lookup'
2378: ,p_inst_name => 'ben_rt_prfl_cache.g_pyrl_instance'
2379: ,p_lkup_query => l_lookup_query
2380: ,p_inst_query => l_inst_query
2381: ,p_instcolnm_set => l_instcolnm_set
2382: );

Line 2390: ,p_lookup_name => 'ben_rt_prfl_cache.g_pyrl_lookup'

2386: -- Cache already populated. Get record set.
2387: --
2388: get_cached_data
2389: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2390: ,p_lookup_name => 'ben_rt_prfl_cache.g_pyrl_lookup'
2391: ,p_inst_name => 'ben_rt_prfl_cache.g_pyrl_instance'
2392: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pyrl_inst_tbl'
2393: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pyrl_out'
2394: );

Line 2391: ,p_inst_name => 'ben_rt_prfl_cache.g_pyrl_instance'

2387: --
2388: get_cached_data
2389: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2390: ,p_lookup_name => 'ben_rt_prfl_cache.g_pyrl_lookup'
2391: ,p_inst_name => 'ben_rt_prfl_cache.g_pyrl_instance'
2392: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pyrl_inst_tbl'
2393: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pyrl_out'
2394: );
2395: --

Line 2392: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pyrl_inst_tbl'

2388: get_cached_data
2389: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2390: ,p_lookup_name => 'ben_rt_prfl_cache.g_pyrl_lookup'
2391: ,p_inst_name => 'ben_rt_prfl_cache.g_pyrl_instance'
2392: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pyrl_inst_tbl'
2393: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pyrl_out'
2394: );
2395: --
2396: p_inst_set := g_pyrl_out;

Line 2393: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pyrl_out'

2389: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2390: ,p_lookup_name => 'ben_rt_prfl_cache.g_pyrl_lookup'
2391: ,p_inst_name => 'ben_rt_prfl_cache.g_pyrl_instance'
2392: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pyrl_inst_tbl'
2393: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pyrl_out'
2394: );
2395: --
2396: p_inst_set := g_pyrl_out;
2397: p_inst_count := g_inst_count;

Line 2416: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_py_bss_inst_tbl

2412: (p_vrbl_rt_prfl_id in number
2413: ,p_effective_date in date
2414: ,p_lf_evt_ocrd_dt in date
2415: ,p_business_group_id in number
2416: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_py_bss_inst_tbl
2417: ,p_inst_count out nocopy number)
2418: is
2419: --
2420: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 2465: ,p_lkup_name => 'ben_rt_prfl_cache.g_py_bss_lookup'

2461: --
2462: ben_cache.write_mastDet_Cache
2463: (p_mastercol_name => 'vrbl_rt_prfl_id'
2464: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2465: ,p_lkup_name => 'ben_rt_prfl_cache.g_py_bss_lookup'
2466: ,p_inst_name => 'ben_rt_prfl_cache.g_py_bss_instance'
2467: ,p_lkup_query => l_lookup_query
2468: ,p_inst_query => l_inst_query
2469: ,p_instcolnm_set => l_instcolnm_set

Line 2466: ,p_inst_name => 'ben_rt_prfl_cache.g_py_bss_instance'

2462: ben_cache.write_mastDet_Cache
2463: (p_mastercol_name => 'vrbl_rt_prfl_id'
2464: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2465: ,p_lkup_name => 'ben_rt_prfl_cache.g_py_bss_lookup'
2466: ,p_inst_name => 'ben_rt_prfl_cache.g_py_bss_instance'
2467: ,p_lkup_query => l_lookup_query
2468: ,p_inst_query => l_inst_query
2469: ,p_instcolnm_set => l_instcolnm_set
2470: );

Line 2478: ,p_lookup_name => 'ben_rt_prfl_cache.g_py_bss_lookup'

2474: -- Cache already populated. Get record set.
2475: --
2476: get_cached_data
2477: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2478: ,p_lookup_name => 'ben_rt_prfl_cache.g_py_bss_lookup'
2479: ,p_inst_name => 'ben_rt_prfl_cache.g_py_bss_instance'
2480: ,p_inst_set_type => 'ben_rt_prfl_cache.g_py_bss_inst_tbl'
2481: ,p_out_inst_name => 'ben_rt_prfl_cache.g_py_bss_out'
2482: );

Line 2479: ,p_inst_name => 'ben_rt_prfl_cache.g_py_bss_instance'

2475: --
2476: get_cached_data
2477: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2478: ,p_lookup_name => 'ben_rt_prfl_cache.g_py_bss_lookup'
2479: ,p_inst_name => 'ben_rt_prfl_cache.g_py_bss_instance'
2480: ,p_inst_set_type => 'ben_rt_prfl_cache.g_py_bss_inst_tbl'
2481: ,p_out_inst_name => 'ben_rt_prfl_cache.g_py_bss_out'
2482: );
2483: --

Line 2480: ,p_inst_set_type => 'ben_rt_prfl_cache.g_py_bss_inst_tbl'

2476: get_cached_data
2477: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2478: ,p_lookup_name => 'ben_rt_prfl_cache.g_py_bss_lookup'
2479: ,p_inst_name => 'ben_rt_prfl_cache.g_py_bss_instance'
2480: ,p_inst_set_type => 'ben_rt_prfl_cache.g_py_bss_inst_tbl'
2481: ,p_out_inst_name => 'ben_rt_prfl_cache.g_py_bss_out'
2482: );
2483: --
2484: p_inst_set := g_py_bss_out;

Line 2481: ,p_out_inst_name => 'ben_rt_prfl_cache.g_py_bss_out'

2477: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2478: ,p_lookup_name => 'ben_rt_prfl_cache.g_py_bss_lookup'
2479: ,p_inst_name => 'ben_rt_prfl_cache.g_py_bss_instance'
2480: ,p_inst_set_type => 'ben_rt_prfl_cache.g_py_bss_inst_tbl'
2481: ,p_out_inst_name => 'ben_rt_prfl_cache.g_py_bss_out'
2482: );
2483: --
2484: p_inst_set := g_py_bss_out;
2485: p_inst_count := g_inst_count;

Line 2504: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_scdhrs_inst_tbl

2500: (p_vrbl_rt_prfl_id in number
2501: ,p_effective_date in date
2502: ,p_lf_evt_ocrd_dt in date
2503: ,p_business_group_id in number
2504: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_scdhrs_inst_tbl
2505: ,p_inst_count out nocopy number)
2506: is
2507: --
2508: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 2571: ,p_lkup_name => 'ben_rt_prfl_cache.g_scdhrs_lookup'

2567: --
2568: ben_cache.write_mastDet_Cache
2569: (p_mastercol_name => 'vrbl_rt_prfl_id'
2570: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2571: ,p_lkup_name => 'ben_rt_prfl_cache.g_scdhrs_lookup'
2572: ,p_inst_name => 'ben_rt_prfl_cache.g_scdhrs_instance'
2573: ,p_lkup_query => l_lookup_query
2574: ,p_inst_query => l_inst_query
2575: ,p_instcolnm_set => l_instcolnm_set

Line 2572: ,p_inst_name => 'ben_rt_prfl_cache.g_scdhrs_instance'

2568: ben_cache.write_mastDet_Cache
2569: (p_mastercol_name => 'vrbl_rt_prfl_id'
2570: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2571: ,p_lkup_name => 'ben_rt_prfl_cache.g_scdhrs_lookup'
2572: ,p_inst_name => 'ben_rt_prfl_cache.g_scdhrs_instance'
2573: ,p_lkup_query => l_lookup_query
2574: ,p_inst_query => l_inst_query
2575: ,p_instcolnm_set => l_instcolnm_set
2576: );

Line 2584: ,p_lookup_name => 'ben_rt_prfl_cache.g_scdhrs_lookup'

2580: -- Cache already populated. Get record set.
2581: --
2582: get_cached_data
2583: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2584: ,p_lookup_name => 'ben_rt_prfl_cache.g_scdhrs_lookup'
2585: ,p_inst_name => 'ben_rt_prfl_cache.g_scdhrs_instance'
2586: ,p_inst_set_type => 'ben_rt_prfl_cache.g_scdhrs_inst_tbl'
2587: ,p_out_inst_name => 'ben_rt_prfl_cache.g_scdhrs_out'
2588: );

Line 2585: ,p_inst_name => 'ben_rt_prfl_cache.g_scdhrs_instance'

2581: --
2582: get_cached_data
2583: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2584: ,p_lookup_name => 'ben_rt_prfl_cache.g_scdhrs_lookup'
2585: ,p_inst_name => 'ben_rt_prfl_cache.g_scdhrs_instance'
2586: ,p_inst_set_type => 'ben_rt_prfl_cache.g_scdhrs_inst_tbl'
2587: ,p_out_inst_name => 'ben_rt_prfl_cache.g_scdhrs_out'
2588: );
2589: --

Line 2586: ,p_inst_set_type => 'ben_rt_prfl_cache.g_scdhrs_inst_tbl'

2582: get_cached_data
2583: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2584: ,p_lookup_name => 'ben_rt_prfl_cache.g_scdhrs_lookup'
2585: ,p_inst_name => 'ben_rt_prfl_cache.g_scdhrs_instance'
2586: ,p_inst_set_type => 'ben_rt_prfl_cache.g_scdhrs_inst_tbl'
2587: ,p_out_inst_name => 'ben_rt_prfl_cache.g_scdhrs_out'
2588: );
2589: --
2590: p_inst_set := g_scdhrs_out;

Line 2587: ,p_out_inst_name => 'ben_rt_prfl_cache.g_scdhrs_out'

2583: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2584: ,p_lookup_name => 'ben_rt_prfl_cache.g_scdhrs_lookup'
2585: ,p_inst_name => 'ben_rt_prfl_cache.g_scdhrs_instance'
2586: ,p_inst_set_type => 'ben_rt_prfl_cache.g_scdhrs_inst_tbl'
2587: ,p_out_inst_name => 'ben_rt_prfl_cache.g_scdhrs_out'
2588: );
2589: --
2590: p_inst_set := g_scdhrs_out;
2591: p_inst_count := g_inst_count;

Line 2611: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_wkloc_inst_tbl

2607: (p_vrbl_rt_prfl_id in number
2608: ,p_effective_date in date
2609: ,p_lf_evt_ocrd_dt in date
2610: ,p_business_group_id in number
2611: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_wkloc_inst_tbl
2612: ,p_inst_count out nocopy number)
2613: is
2614: --
2615: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 2660: ,p_lkup_name => 'ben_rt_prfl_cache.g_wkloc_lookup'

2656: --
2657: ben_cache.write_mastDet_Cache
2658: (p_mastercol_name => 'vrbl_rt_prfl_id'
2659: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2660: ,p_lkup_name => 'ben_rt_prfl_cache.g_wkloc_lookup'
2661: ,p_inst_name => 'ben_rt_prfl_cache.g_wkloc_instance'
2662: ,p_lkup_query => l_lookup_query
2663: ,p_inst_query => l_inst_query
2664: ,p_instcolnm_set => l_instcolnm_set

Line 2661: ,p_inst_name => 'ben_rt_prfl_cache.g_wkloc_instance'

2657: ben_cache.write_mastDet_Cache
2658: (p_mastercol_name => 'vrbl_rt_prfl_id'
2659: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2660: ,p_lkup_name => 'ben_rt_prfl_cache.g_wkloc_lookup'
2661: ,p_inst_name => 'ben_rt_prfl_cache.g_wkloc_instance'
2662: ,p_lkup_query => l_lookup_query
2663: ,p_inst_query => l_inst_query
2664: ,p_instcolnm_set => l_instcolnm_set
2665: );

Line 2673: ,p_lookup_name => 'ben_rt_prfl_cache.g_wkloc_lookup'

2669: -- Cache already populated. Get record set.
2670: --
2671: get_cached_data
2672: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2673: ,p_lookup_name => 'ben_rt_prfl_cache.g_wkloc_lookup'
2674: ,p_inst_name => 'ben_rt_prfl_cache.g_wkloc_instance'
2675: ,p_inst_set_type => 'ben_rt_prfl_cache.g_wkloc_inst_tbl'
2676: ,p_out_inst_name => 'ben_rt_prfl_cache.g_wkloc_out'
2677: );

Line 2674: ,p_inst_name => 'ben_rt_prfl_cache.g_wkloc_instance'

2670: --
2671: get_cached_data
2672: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2673: ,p_lookup_name => 'ben_rt_prfl_cache.g_wkloc_lookup'
2674: ,p_inst_name => 'ben_rt_prfl_cache.g_wkloc_instance'
2675: ,p_inst_set_type => 'ben_rt_prfl_cache.g_wkloc_inst_tbl'
2676: ,p_out_inst_name => 'ben_rt_prfl_cache.g_wkloc_out'
2677: );
2678: --

Line 2675: ,p_inst_set_type => 'ben_rt_prfl_cache.g_wkloc_inst_tbl'

2671: get_cached_data
2672: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2673: ,p_lookup_name => 'ben_rt_prfl_cache.g_wkloc_lookup'
2674: ,p_inst_name => 'ben_rt_prfl_cache.g_wkloc_instance'
2675: ,p_inst_set_type => 'ben_rt_prfl_cache.g_wkloc_inst_tbl'
2676: ,p_out_inst_name => 'ben_rt_prfl_cache.g_wkloc_out'
2677: );
2678: --
2679: p_inst_set := g_wkloc_out;

Line 2676: ,p_out_inst_name => 'ben_rt_prfl_cache.g_wkloc_out'

2672: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2673: ,p_lookup_name => 'ben_rt_prfl_cache.g_wkloc_lookup'
2674: ,p_inst_name => 'ben_rt_prfl_cache.g_wkloc_instance'
2675: ,p_inst_set_type => 'ben_rt_prfl_cache.g_wkloc_inst_tbl'
2676: ,p_out_inst_name => 'ben_rt_prfl_cache.g_wkloc_out'
2677: );
2678: --
2679: p_inst_set := g_wkloc_out;
2680: p_inst_count := g_inst_count;

Line 2699: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_svcarea_inst_tbl

2695: (p_vrbl_rt_prfl_id in number
2696: ,p_effective_date in date
2697: ,p_lf_evt_ocrd_dt in date
2698: ,p_business_group_id in number
2699: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_svcarea_inst_tbl
2700: ,p_inst_count out nocopy number)
2701: is
2702: --
2703: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 2760: ,p_lkup_name => 'ben_rt_prfl_cache.g_svcarea_lookup'

2756: --
2757: ben_cache.write_mastDet_Cache
2758: (p_mastercol_name => 'vrbl_rt_prfl_id'
2759: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2760: ,p_lkup_name => 'ben_rt_prfl_cache.g_svcarea_lookup'
2761: ,p_inst_name => 'ben_rt_prfl_cache.g_svcarea_instance'
2762: ,p_lkup_query => l_lookup_query
2763: ,p_inst_query => l_inst_query
2764: ,p_instcolnm_set => l_instcolnm_set

Line 2761: ,p_inst_name => 'ben_rt_prfl_cache.g_svcarea_instance'

2757: ben_cache.write_mastDet_Cache
2758: (p_mastercol_name => 'vrbl_rt_prfl_id'
2759: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2760: ,p_lkup_name => 'ben_rt_prfl_cache.g_svcarea_lookup'
2761: ,p_inst_name => 'ben_rt_prfl_cache.g_svcarea_instance'
2762: ,p_lkup_query => l_lookup_query
2763: ,p_inst_query => l_inst_query
2764: ,p_instcolnm_set => l_instcolnm_set
2765: );

Line 2773: ,p_lookup_name => 'ben_rt_prfl_cache.g_svcarea_lookup'

2769: -- Cache already populated. Get record set.
2770: --
2771: get_cached_data
2772: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2773: ,p_lookup_name => 'ben_rt_prfl_cache.g_svcarea_lookup'
2774: ,p_inst_name => 'ben_rt_prfl_cache.g_svcarea_instance'
2775: ,p_inst_set_type => 'ben_rt_prfl_cache.g_svcarea_inst_tbl'
2776: ,p_out_inst_name => 'ben_rt_prfl_cache.g_svcarea_out'
2777: );

Line 2774: ,p_inst_name => 'ben_rt_prfl_cache.g_svcarea_instance'

2770: --
2771: get_cached_data
2772: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2773: ,p_lookup_name => 'ben_rt_prfl_cache.g_svcarea_lookup'
2774: ,p_inst_name => 'ben_rt_prfl_cache.g_svcarea_instance'
2775: ,p_inst_set_type => 'ben_rt_prfl_cache.g_svcarea_inst_tbl'
2776: ,p_out_inst_name => 'ben_rt_prfl_cache.g_svcarea_out'
2777: );
2778: --

Line 2775: ,p_inst_set_type => 'ben_rt_prfl_cache.g_svcarea_inst_tbl'

2771: get_cached_data
2772: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2773: ,p_lookup_name => 'ben_rt_prfl_cache.g_svcarea_lookup'
2774: ,p_inst_name => 'ben_rt_prfl_cache.g_svcarea_instance'
2775: ,p_inst_set_type => 'ben_rt_prfl_cache.g_svcarea_inst_tbl'
2776: ,p_out_inst_name => 'ben_rt_prfl_cache.g_svcarea_out'
2777: );
2778: --
2779: p_inst_set := g_svcarea_out;

Line 2776: ,p_out_inst_name => 'ben_rt_prfl_cache.g_svcarea_out'

2772: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2773: ,p_lookup_name => 'ben_rt_prfl_cache.g_svcarea_lookup'
2774: ,p_inst_name => 'ben_rt_prfl_cache.g_svcarea_instance'
2775: ,p_inst_set_type => 'ben_rt_prfl_cache.g_svcarea_inst_tbl'
2776: ,p_out_inst_name => 'ben_rt_prfl_cache.g_svcarea_out'
2777: );
2778: --
2779: p_inst_set := g_svcarea_out;
2780: p_inst_count := g_inst_count;

Line 2799: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_hrlyslrd_inst_tbl

2795: (p_vrbl_rt_prfl_id in number
2796: ,p_effective_date in date
2797: ,p_lf_evt_ocrd_dt in date
2798: ,p_business_group_id in number
2799: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_hrlyslrd_inst_tbl
2800: ,p_inst_count out nocopy number)
2801: is
2802: --
2803: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 2848: ,p_lkup_name => 'ben_rt_prfl_cache.g_hrlyslrd_lookup'

2844: --
2845: ben_cache.write_mastDet_Cache
2846: (p_mastercol_name => 'vrbl_rt_prfl_id'
2847: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2848: ,p_lkup_name => 'ben_rt_prfl_cache.g_hrlyslrd_lookup'
2849: ,p_inst_name => 'ben_rt_prfl_cache.g_hrlyslrd_instance'
2850: ,p_lkup_query => l_lookup_query
2851: ,p_inst_query => l_inst_query
2852: ,p_instcolnm_set => l_instcolnm_set

Line 2849: ,p_inst_name => 'ben_rt_prfl_cache.g_hrlyslrd_instance'

2845: ben_cache.write_mastDet_Cache
2846: (p_mastercol_name => 'vrbl_rt_prfl_id'
2847: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2848: ,p_lkup_name => 'ben_rt_prfl_cache.g_hrlyslrd_lookup'
2849: ,p_inst_name => 'ben_rt_prfl_cache.g_hrlyslrd_instance'
2850: ,p_lkup_query => l_lookup_query
2851: ,p_inst_query => l_inst_query
2852: ,p_instcolnm_set => l_instcolnm_set
2853: );

Line 2861: ,p_lookup_name => 'ben_rt_prfl_cache.g_hrlyslrd_lookup'

2857: -- Cache already populated. Get record set.
2858: --
2859: get_cached_data
2860: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2861: ,p_lookup_name => 'ben_rt_prfl_cache.g_hrlyslrd_lookup'
2862: ,p_inst_name => 'ben_rt_prfl_cache.g_hrlyslrd_instance'
2863: ,p_inst_set_type => 'ben_rt_prfl_cache.g_hrlyslrd_inst_tbl'
2864: ,p_out_inst_name => 'ben_rt_prfl_cache.g_hrlyslrd_out'
2865: );

Line 2862: ,p_inst_name => 'ben_rt_prfl_cache.g_hrlyslrd_instance'

2858: --
2859: get_cached_data
2860: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2861: ,p_lookup_name => 'ben_rt_prfl_cache.g_hrlyslrd_lookup'
2862: ,p_inst_name => 'ben_rt_prfl_cache.g_hrlyslrd_instance'
2863: ,p_inst_set_type => 'ben_rt_prfl_cache.g_hrlyslrd_inst_tbl'
2864: ,p_out_inst_name => 'ben_rt_prfl_cache.g_hrlyslrd_out'
2865: );
2866: --

Line 2863: ,p_inst_set_type => 'ben_rt_prfl_cache.g_hrlyslrd_inst_tbl'

2859: get_cached_data
2860: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2861: ,p_lookup_name => 'ben_rt_prfl_cache.g_hrlyslrd_lookup'
2862: ,p_inst_name => 'ben_rt_prfl_cache.g_hrlyslrd_instance'
2863: ,p_inst_set_type => 'ben_rt_prfl_cache.g_hrlyslrd_inst_tbl'
2864: ,p_out_inst_name => 'ben_rt_prfl_cache.g_hrlyslrd_out'
2865: );
2866: --
2867: p_inst_set := g_hrlyslrd_out;

Line 2864: ,p_out_inst_name => 'ben_rt_prfl_cache.g_hrlyslrd_out'

2860: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2861: ,p_lookup_name => 'ben_rt_prfl_cache.g_hrlyslrd_lookup'
2862: ,p_inst_name => 'ben_rt_prfl_cache.g_hrlyslrd_instance'
2863: ,p_inst_set_type => 'ben_rt_prfl_cache.g_hrlyslrd_inst_tbl'
2864: ,p_out_inst_name => 'ben_rt_prfl_cache.g_hrlyslrd_out'
2865: );
2866: --
2867: p_inst_set := g_hrlyslrd_out;
2868: p_inst_count := g_inst_count;

Line 2887: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_age_inst_tbl

2883: (p_vrbl_rt_prfl_id in number
2884: ,p_effective_date in date
2885: ,p_lf_evt_ocrd_dt in date
2886: ,p_business_group_id in number
2887: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_age_inst_tbl
2888: ,p_inst_count out nocopy number) is
2889: --
2890: l_proc varchar2(72) := 'get_rt_prfl_cache';
2891: --

Line 2916: l_lkup_name := 'ben_rt_prfl_cache.g_age_lookup';

2912: -- Build the cache
2913: --
2914: l_mastertab_name := 'ben_vrbl_rt_prfl_f';
2915: l_masterpkcol_name := 'vrbl_rt_prfl_id';
2916: l_lkup_name := 'ben_rt_prfl_cache.g_age_lookup';
2917: l_inst_name := 'ben_rt_prfl_cache.g_age_instance';
2918: --
2919: l_tabdet_set(0).tab_name := 'ben_age_rt_f';
2920: l_tabdet_set(0).tab_jncolnm := 'age_fctr_id';

Line 2917: l_inst_name := 'ben_rt_prfl_cache.g_age_instance';

2913: --
2914: l_mastertab_name := 'ben_vrbl_rt_prfl_f';
2915: l_masterpkcol_name := 'vrbl_rt_prfl_id';
2916: l_lkup_name := 'ben_rt_prfl_cache.g_age_lookup';
2917: l_inst_name := 'ben_rt_prfl_cache.g_age_instance';
2918: --
2919: l_tabdet_set(0).tab_name := 'ben_age_rt_f';
2920: l_tabdet_set(0).tab_jncolnm := 'age_fctr_id';
2921: l_tabdet_set(1).tab_name := 'ben_age_fctr';

Line 3049: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_complvl_inst_tbl

3045: (p_vrbl_rt_prfl_id in number
3046: ,p_effective_date in date
3047: ,p_lf_evt_ocrd_dt in date
3048: ,p_business_group_id in number
3049: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_complvl_inst_tbl
3050: ,p_inst_count out nocopy number)
3051: is
3052: --
3053: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 3109: ,p_lkup_name => 'ben_rt_prfl_cache.g_complvl_lookup'

3105: --
3106: ben_cache.write_mastDet_Cache
3107: (p_mastercol_name => 'vrbl_rt_prfl_id'
3108: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3109: ,p_lkup_name => 'ben_rt_prfl_cache.g_complvl_lookup'
3110: ,p_inst_name => 'ben_rt_prfl_cache.g_complvl_instance'
3111: ,p_lkup_query => l_lookup_query
3112: ,p_inst_query => l_inst_query
3113: ,p_instcolnm_set => l_instcolnm_set

Line 3110: ,p_inst_name => 'ben_rt_prfl_cache.g_complvl_instance'

3106: ben_cache.write_mastDet_Cache
3107: (p_mastercol_name => 'vrbl_rt_prfl_id'
3108: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3109: ,p_lkup_name => 'ben_rt_prfl_cache.g_complvl_lookup'
3110: ,p_inst_name => 'ben_rt_prfl_cache.g_complvl_instance'
3111: ,p_lkup_query => l_lookup_query
3112: ,p_inst_query => l_inst_query
3113: ,p_instcolnm_set => l_instcolnm_set
3114: );

Line 3122: ,p_lookup_name => 'ben_rt_prfl_cache.g_complvl_lookup'

3118: -- Cache already populated. Get record set.
3119: --
3120: get_cached_data
3121: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3122: ,p_lookup_name => 'ben_rt_prfl_cache.g_complvl_lookup'
3123: ,p_inst_name => 'ben_rt_prfl_cache.g_complvl_instance'
3124: ,p_inst_set_type => 'ben_rt_prfl_cache.g_complvl_inst_tbl'
3125: ,p_out_inst_name => 'ben_rt_prfl_cache.g_complvl_out'
3126: );

Line 3123: ,p_inst_name => 'ben_rt_prfl_cache.g_complvl_instance'

3119: --
3120: get_cached_data
3121: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3122: ,p_lookup_name => 'ben_rt_prfl_cache.g_complvl_lookup'
3123: ,p_inst_name => 'ben_rt_prfl_cache.g_complvl_instance'
3124: ,p_inst_set_type => 'ben_rt_prfl_cache.g_complvl_inst_tbl'
3125: ,p_out_inst_name => 'ben_rt_prfl_cache.g_complvl_out'
3126: );
3127: --

Line 3124: ,p_inst_set_type => 'ben_rt_prfl_cache.g_complvl_inst_tbl'

3120: get_cached_data
3121: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3122: ,p_lookup_name => 'ben_rt_prfl_cache.g_complvl_lookup'
3123: ,p_inst_name => 'ben_rt_prfl_cache.g_complvl_instance'
3124: ,p_inst_set_type => 'ben_rt_prfl_cache.g_complvl_inst_tbl'
3125: ,p_out_inst_name => 'ben_rt_prfl_cache.g_complvl_out'
3126: );
3127: --
3128: p_inst_set := g_complvl_out;

Line 3125: ,p_out_inst_name => 'ben_rt_prfl_cache.g_complvl_out'

3121: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3122: ,p_lookup_name => 'ben_rt_prfl_cache.g_complvl_lookup'
3123: ,p_inst_name => 'ben_rt_prfl_cache.g_complvl_instance'
3124: ,p_inst_set_type => 'ben_rt_prfl_cache.g_complvl_inst_tbl'
3125: ,p_out_inst_name => 'ben_rt_prfl_cache.g_complvl_out'
3126: );
3127: --
3128: p_inst_set := g_complvl_out;
3129: p_inst_count := g_inst_count;

Line 3148: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_los_inst_tbl

3144: (p_vrbl_rt_prfl_id in number
3145: ,p_effective_date in date
3146: ,p_lf_evt_ocrd_dt in date
3147: ,p_business_group_id in number
3148: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_los_inst_tbl
3149: ,p_inst_count out nocopy number) is
3150: --
3151: l_proc varchar2(72) := 'get_rt_prfl_cache';
3152: --

Line 3177: l_lkup_name := 'ben_rt_prfl_cache.g_los_lookup';

3173: -- Build the cache
3174: --
3175: l_mastertab_name := 'ben_vrbl_rt_prfl_f';
3176: l_masterpkcol_name := 'vrbl_rt_prfl_id';
3177: l_lkup_name := 'ben_rt_prfl_cache.g_los_lookup';
3178: l_inst_name := 'ben_rt_prfl_cache.g_los_instance';
3179: --
3180: l_tabdet_set(0).tab_name := 'ben_los_rt_f';
3181: l_tabdet_set(0).tab_jncolnm := 'los_fctr_id';

Line 3178: l_inst_name := 'ben_rt_prfl_cache.g_los_instance';

3174: --
3175: l_mastertab_name := 'ben_vrbl_rt_prfl_f';
3176: l_masterpkcol_name := 'vrbl_rt_prfl_id';
3177: l_lkup_name := 'ben_rt_prfl_cache.g_los_lookup';
3178: l_inst_name := 'ben_rt_prfl_cache.g_los_instance';
3179: --
3180: l_tabdet_set(0).tab_name := 'ben_los_rt_f';
3181: l_tabdet_set(0).tab_jncolnm := 'los_fctr_id';
3182: l_tabdet_set(1).tab_name := 'ben_los_fctr';

Line 3311: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_los_inst_tbl

3307: (p_vrbl_rt_prfl_id in number
3308: ,p_effective_date in date
3309: ,p_lf_evt_ocrd_dt in date
3310: ,p_business_group_id in number
3311: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_los_inst_tbl
3312: ,p_inst_count out nocopy number)
3313: is
3314: --
3315: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 3372: ,p_lkup_name => 'ben_rt_prfl_cache.g_los_lookup'

3368: --
3369: ben_cache.write_mastDet_Cache
3370: (p_mastercol_name => 'vrbl_rt_prfl_id'
3371: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3372: ,p_lkup_name => 'ben_rt_prfl_cache.g_los_lookup'
3373: ,p_inst_name => 'ben_rt_prfl_cache.g_los_instance'
3374: ,p_lkup_query => l_lookup_query
3375: ,p_inst_query => l_inst_query
3376: ,p_instcolnm_set => l_instcolnm_set

Line 3373: ,p_inst_name => 'ben_rt_prfl_cache.g_los_instance'

3369: ben_cache.write_mastDet_Cache
3370: (p_mastercol_name => 'vrbl_rt_prfl_id'
3371: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3372: ,p_lkup_name => 'ben_rt_prfl_cache.g_los_lookup'
3373: ,p_inst_name => 'ben_rt_prfl_cache.g_los_instance'
3374: ,p_lkup_query => l_lookup_query
3375: ,p_inst_query => l_inst_query
3376: ,p_instcolnm_set => l_instcolnm_set
3377: );

Line 3385: ,p_lookup_name => 'ben_rt_prfl_cache.g_los_lookup'

3381: -- Cache already populated. Get record set.
3382: --
3383: get_cached_data
3384: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3385: ,p_lookup_name => 'ben_rt_prfl_cache.g_los_lookup'
3386: ,p_inst_name => 'ben_rt_prfl_cache.g_los_instance'
3387: ,p_inst_set_type => 'ben_rt_prfl_cache.g_los_inst_tbl'
3388: ,p_out_inst_name => 'ben_rt_prfl_cache.g_los_out'
3389: );

Line 3386: ,p_inst_name => 'ben_rt_prfl_cache.g_los_instance'

3382: --
3383: get_cached_data
3384: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3385: ,p_lookup_name => 'ben_rt_prfl_cache.g_los_lookup'
3386: ,p_inst_name => 'ben_rt_prfl_cache.g_los_instance'
3387: ,p_inst_set_type => 'ben_rt_prfl_cache.g_los_inst_tbl'
3388: ,p_out_inst_name => 'ben_rt_prfl_cache.g_los_out'
3389: );
3390: --

Line 3387: ,p_inst_set_type => 'ben_rt_prfl_cache.g_los_inst_tbl'

3383: get_cached_data
3384: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3385: ,p_lookup_name => 'ben_rt_prfl_cache.g_los_lookup'
3386: ,p_inst_name => 'ben_rt_prfl_cache.g_los_instance'
3387: ,p_inst_set_type => 'ben_rt_prfl_cache.g_los_inst_tbl'
3388: ,p_out_inst_name => 'ben_rt_prfl_cache.g_los_out'
3389: );
3390: --
3391: p_inst_set := g_los_out;

Line 3388: ,p_out_inst_name => 'ben_rt_prfl_cache.g_los_out'

3384: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3385: ,p_lookup_name => 'ben_rt_prfl_cache.g_los_lookup'
3386: ,p_inst_name => 'ben_rt_prfl_cache.g_los_instance'
3387: ,p_inst_set_type => 'ben_rt_prfl_cache.g_los_inst_tbl'
3388: ,p_out_inst_name => 'ben_rt_prfl_cache.g_los_out'
3389: );
3390: --
3391: p_inst_set := g_los_out;
3392: p_inst_count := g_inst_count;

Line 3412: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_age_los_inst_tbl

3408: (p_vrbl_rt_prfl_id in number
3409: ,p_effective_date in date
3410: ,p_lf_evt_ocrd_dt in date
3411: ,p_business_group_id in number
3412: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_age_los_inst_tbl
3413: ,p_inst_count out nocopy number)
3414: is
3415: --
3416: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 3468: ,p_lkup_name => 'ben_rt_prfl_cache.g_age_los_lookup'

3464: --
3465: ben_cache.write_mastDet_Cache
3466: (p_mastercol_name => 'vrbl_rt_prfl_id'
3467: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3468: ,p_lkup_name => 'ben_rt_prfl_cache.g_age_los_lookup'
3469: ,p_inst_name => 'ben_rt_prfl_cache.g_age_los_instance'
3470: ,p_lkup_query => l_lookup_query
3471: ,p_inst_query => l_inst_query
3472: ,p_instcolnm_set => l_instcolnm_set

Line 3469: ,p_inst_name => 'ben_rt_prfl_cache.g_age_los_instance'

3465: ben_cache.write_mastDet_Cache
3466: (p_mastercol_name => 'vrbl_rt_prfl_id'
3467: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3468: ,p_lkup_name => 'ben_rt_prfl_cache.g_age_los_lookup'
3469: ,p_inst_name => 'ben_rt_prfl_cache.g_age_los_instance'
3470: ,p_lkup_query => l_lookup_query
3471: ,p_inst_query => l_inst_query
3472: ,p_instcolnm_set => l_instcolnm_set
3473: );

Line 3481: ,p_lookup_name => 'ben_rt_prfl_cache.g_age_los_lookup'

3477: -- Cache already populated. Get record set.
3478: --
3479: get_cached_data
3480: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3481: ,p_lookup_name => 'ben_rt_prfl_cache.g_age_los_lookup'
3482: ,p_inst_name => 'ben_rt_prfl_cache.g_age_los_instance'
3483: ,p_inst_set_type => 'ben_rt_prfl_cache.g_age_los_inst_tbl'
3484: ,p_out_inst_name => 'ben_rt_prfl_cache.g_age_los_out'
3485: );

Line 3482: ,p_inst_name => 'ben_rt_prfl_cache.g_age_los_instance'

3478: --
3479: get_cached_data
3480: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3481: ,p_lookup_name => 'ben_rt_prfl_cache.g_age_los_lookup'
3482: ,p_inst_name => 'ben_rt_prfl_cache.g_age_los_instance'
3483: ,p_inst_set_type => 'ben_rt_prfl_cache.g_age_los_inst_tbl'
3484: ,p_out_inst_name => 'ben_rt_prfl_cache.g_age_los_out'
3485: );
3486: --

Line 3483: ,p_inst_set_type => 'ben_rt_prfl_cache.g_age_los_inst_tbl'

3479: get_cached_data
3480: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3481: ,p_lookup_name => 'ben_rt_prfl_cache.g_age_los_lookup'
3482: ,p_inst_name => 'ben_rt_prfl_cache.g_age_los_instance'
3483: ,p_inst_set_type => 'ben_rt_prfl_cache.g_age_los_inst_tbl'
3484: ,p_out_inst_name => 'ben_rt_prfl_cache.g_age_los_out'
3485: );
3486: --
3487: p_inst_set := g_age_los_out;

Line 3484: ,p_out_inst_name => 'ben_rt_prfl_cache.g_age_los_out'

3480: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3481: ,p_lookup_name => 'ben_rt_prfl_cache.g_age_los_lookup'
3482: ,p_inst_name => 'ben_rt_prfl_cache.g_age_los_instance'
3483: ,p_inst_set_type => 'ben_rt_prfl_cache.g_age_los_inst_tbl'
3484: ,p_out_inst_name => 'ben_rt_prfl_cache.g_age_los_out'
3485: );
3486: --
3487: p_inst_set := g_age_los_out;
3488: p_inst_count := g_inst_count;

Line 3507: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_ttl_prtt_inst_tbl

3503: (p_vrbl_rt_prfl_id in number
3504: ,p_effective_date in date
3505: ,p_lf_evt_ocrd_dt in date
3506: ,p_business_group_id in number
3507: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_ttl_prtt_inst_tbl
3508: ,p_inst_count out nocopy number) is
3509: --
3510: l_proc varchar2(72) := 'get_rt_prfl_cache';
3511: --

Line 3535: l_lkup_name := 'ben_rt_prfl_cache.g_ttl_prtt_lookup';

3531: -- Build the cache
3532: --
3533: l_mastertab_name := 'ben_vrbl_rt_prfl_f';
3534: l_masterpkcol_name := 'vrbl_rt_prfl_id';
3535: l_lkup_name := 'ben_rt_prfl_cache.g_ttl_prtt_lookup';
3536: l_inst_name := 'ben_rt_prfl_cache.g_ttl_prtt_instance';
3537: --
3538: l_instcolnm_num := 0;
3539: --

Line 3536: l_inst_name := 'ben_rt_prfl_cache.g_ttl_prtt_instance';

3532: --
3533: l_mastertab_name := 'ben_vrbl_rt_prfl_f';
3534: l_masterpkcol_name := 'vrbl_rt_prfl_id';
3535: l_lkup_name := 'ben_rt_prfl_cache.g_ttl_prtt_lookup';
3536: l_inst_name := 'ben_rt_prfl_cache.g_ttl_prtt_instance';
3537: --
3538: l_instcolnm_num := 0;
3539: --
3540: l_instcolnm_set(l_instcolnm_num).col_name := l_masterpkcol_name;

Line 3636: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_ttl_cvg_inst_tbl

3632: (p_vrbl_rt_prfl_id in number
3633: ,p_effective_date in date
3634: ,p_lf_evt_ocrd_dt in date
3635: ,p_business_group_id in number
3636: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_ttl_cvg_inst_tbl
3637: ,p_inst_count out nocopy number)
3638: is
3639: --
3640: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache, ttl cvg';

Line 3685: ,p_lkup_name => 'ben_rt_prfl_cache.g_ttl_cvg_lookup'

3681:
3682: ben_cache.write_mastDet_Cache
3683: (p_mastercol_name => 'vrbl_rt_prfl_id'
3684: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3685: ,p_lkup_name => 'ben_rt_prfl_cache.g_ttl_cvg_lookup'
3686: ,p_inst_name => 'ben_rt_prfl_cache.g_ttl_cvg_instance'
3687: ,p_lkup_query => l_lookup_query
3688: ,p_inst_query => l_inst_query
3689: ,p_instcolnm_set => l_instcolnm_set

Line 3686: ,p_inst_name => 'ben_rt_prfl_cache.g_ttl_cvg_instance'

3682: ben_cache.write_mastDet_Cache
3683: (p_mastercol_name => 'vrbl_rt_prfl_id'
3684: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3685: ,p_lkup_name => 'ben_rt_prfl_cache.g_ttl_cvg_lookup'
3686: ,p_inst_name => 'ben_rt_prfl_cache.g_ttl_cvg_instance'
3687: ,p_lkup_query => l_lookup_query
3688: ,p_inst_query => l_inst_query
3689: ,p_instcolnm_set => l_instcolnm_set
3690: );

Line 3698: ,p_lookup_name => 'ben_rt_prfl_cache.g_ttl_cvg_lookup'

3694: -- Cache already populated. Get record set.
3695: --
3696: get_cached_data
3697: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3698: ,p_lookup_name => 'ben_rt_prfl_cache.g_ttl_cvg_lookup'
3699: ,p_inst_name => 'ben_rt_prfl_cache.g_ttl_cvg_instance'
3700: ,p_inst_set_type => 'ben_rt_prfl_cache.g_ttl_cvg_inst_tbl'
3701: ,p_out_inst_name => 'ben_rt_prfl_cache.g_ttl_cvg_out'
3702: );

Line 3699: ,p_inst_name => 'ben_rt_prfl_cache.g_ttl_cvg_instance'

3695: --
3696: get_cached_data
3697: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3698: ,p_lookup_name => 'ben_rt_prfl_cache.g_ttl_cvg_lookup'
3699: ,p_inst_name => 'ben_rt_prfl_cache.g_ttl_cvg_instance'
3700: ,p_inst_set_type => 'ben_rt_prfl_cache.g_ttl_cvg_inst_tbl'
3701: ,p_out_inst_name => 'ben_rt_prfl_cache.g_ttl_cvg_out'
3702: );
3703: --

Line 3700: ,p_inst_set_type => 'ben_rt_prfl_cache.g_ttl_cvg_inst_tbl'

3696: get_cached_data
3697: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3698: ,p_lookup_name => 'ben_rt_prfl_cache.g_ttl_cvg_lookup'
3699: ,p_inst_name => 'ben_rt_prfl_cache.g_ttl_cvg_instance'
3700: ,p_inst_set_type => 'ben_rt_prfl_cache.g_ttl_cvg_inst_tbl'
3701: ,p_out_inst_name => 'ben_rt_prfl_cache.g_ttl_cvg_out'
3702: );
3703: --
3704: p_inst_set := g_ttl_cvg_out;

Line 3701: ,p_out_inst_name => 'ben_rt_prfl_cache.g_ttl_cvg_out'

3697: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3698: ,p_lookup_name => 'ben_rt_prfl_cache.g_ttl_cvg_lookup'
3699: ,p_inst_name => 'ben_rt_prfl_cache.g_ttl_cvg_instance'
3700: ,p_inst_set_type => 'ben_rt_prfl_cache.g_ttl_cvg_inst_tbl'
3701: ,p_out_inst_name => 'ben_rt_prfl_cache.g_ttl_cvg_out'
3702: );
3703: --
3704: p_inst_set := g_ttl_cvg_out;
3705: p_inst_count := g_inst_count;

Line 3727: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_job_inst_tbl

3723: (p_vrbl_rt_prfl_id in number
3724: ,p_effective_date in date
3725: ,p_lf_evt_ocrd_dt in date
3726: ,p_business_group_id in number
3727: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_job_inst_tbl
3728: ,p_inst_count out nocopy number)
3729: is
3730: --
3731: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 3776: ,p_lkup_name => 'ben_rt_prfl_cache.g_job_lookup'

3772: --
3773: ben_cache.write_mastDet_Cache
3774: (p_mastercol_name => 'vrbl_rt_prfl_id'
3775: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3776: ,p_lkup_name => 'ben_rt_prfl_cache.g_job_lookup'
3777: ,p_inst_name => 'ben_rt_prfl_cache.g_job_instance'
3778: ,p_lkup_query => l_lookup_query
3779: ,p_inst_query => l_inst_query
3780: ,p_instcolnm_set => l_instcolnm_set

Line 3777: ,p_inst_name => 'ben_rt_prfl_cache.g_job_instance'

3773: ben_cache.write_mastDet_Cache
3774: (p_mastercol_name => 'vrbl_rt_prfl_id'
3775: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3776: ,p_lkup_name => 'ben_rt_prfl_cache.g_job_lookup'
3777: ,p_inst_name => 'ben_rt_prfl_cache.g_job_instance'
3778: ,p_lkup_query => l_lookup_query
3779: ,p_inst_query => l_inst_query
3780: ,p_instcolnm_set => l_instcolnm_set
3781: );

Line 3789: ,p_lookup_name => 'ben_rt_prfl_cache.g_job_lookup'

3785: -- Cache already populated. Get record set.
3786: --
3787: get_cached_data
3788: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3789: ,p_lookup_name => 'ben_rt_prfl_cache.g_job_lookup'
3790: ,p_inst_name => 'ben_rt_prfl_cache.g_job_instance'
3791: ,p_inst_set_type => 'ben_rt_prfl_cache.g_job_inst_tbl'
3792: ,p_out_inst_name => 'ben_rt_prfl_cache.g_job_out'
3793: );

Line 3790: ,p_inst_name => 'ben_rt_prfl_cache.g_job_instance'

3786: --
3787: get_cached_data
3788: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3789: ,p_lookup_name => 'ben_rt_prfl_cache.g_job_lookup'
3790: ,p_inst_name => 'ben_rt_prfl_cache.g_job_instance'
3791: ,p_inst_set_type => 'ben_rt_prfl_cache.g_job_inst_tbl'
3792: ,p_out_inst_name => 'ben_rt_prfl_cache.g_job_out'
3793: );
3794: --

Line 3791: ,p_inst_set_type => 'ben_rt_prfl_cache.g_job_inst_tbl'

3787: get_cached_data
3788: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3789: ,p_lookup_name => 'ben_rt_prfl_cache.g_job_lookup'
3790: ,p_inst_name => 'ben_rt_prfl_cache.g_job_instance'
3791: ,p_inst_set_type => 'ben_rt_prfl_cache.g_job_inst_tbl'
3792: ,p_out_inst_name => 'ben_rt_prfl_cache.g_job_out'
3793: );
3794: --
3795: p_inst_set := g_job_out;

Line 3792: ,p_out_inst_name => 'ben_rt_prfl_cache.g_job_out'

3788: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3789: ,p_lookup_name => 'ben_rt_prfl_cache.g_job_lookup'
3790: ,p_inst_name => 'ben_rt_prfl_cache.g_job_instance'
3791: ,p_inst_set_type => 'ben_rt_prfl_cache.g_job_inst_tbl'
3792: ,p_out_inst_name => 'ben_rt_prfl_cache.g_job_out'
3793: );
3794: --
3795: p_inst_set := g_job_out;
3796: p_inst_count := g_inst_count;

Line 3816: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_optd_mdcr_inst_tbl

3812: (p_vrbl_rt_prfl_id in number
3813: ,p_effective_date in date
3814: ,p_lf_evt_ocrd_dt in date
3815: ,p_business_group_id in number
3816: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_optd_mdcr_inst_tbl
3817: ,p_inst_count out nocopy number)
3818: is
3819: --
3820: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 3863: ,p_lkup_name => 'ben_rt_prfl_cache.g_optd_mdcr_lookup'

3859: --
3860: ben_cache.write_mastDet_Cache
3861: (p_mastercol_name => 'vrbl_rt_prfl_id'
3862: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3863: ,p_lkup_name => 'ben_rt_prfl_cache.g_optd_mdcr_lookup'
3864: ,p_inst_name => 'ben_rt_prfl_cache.g_optd_mdcr_instance'
3865: ,p_lkup_query => l_lookup_query
3866: ,p_inst_query => l_inst_query
3867: ,p_instcolnm_set => l_instcolnm_set

Line 3864: ,p_inst_name => 'ben_rt_prfl_cache.g_optd_mdcr_instance'

3860: ben_cache.write_mastDet_Cache
3861: (p_mastercol_name => 'vrbl_rt_prfl_id'
3862: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3863: ,p_lkup_name => 'ben_rt_prfl_cache.g_optd_mdcr_lookup'
3864: ,p_inst_name => 'ben_rt_prfl_cache.g_optd_mdcr_instance'
3865: ,p_lkup_query => l_lookup_query
3866: ,p_inst_query => l_inst_query
3867: ,p_instcolnm_set => l_instcolnm_set
3868: );

Line 3876: ,p_lookup_name => 'ben_rt_prfl_cache.g_optd_mdcr_lookup'

3872: -- Cache already populated. Get record set.
3873: --
3874: get_cached_data
3875: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3876: ,p_lookup_name => 'ben_rt_prfl_cache.g_optd_mdcr_lookup'
3877: ,p_inst_name => 'ben_rt_prfl_cache.g_optd_mdcr_instance'
3878: ,p_inst_set_type => 'ben_rt_prfl_cache.g_optd_mdcr_inst_tbl'
3879: ,p_out_inst_name => 'ben_rt_prfl_cache.g_optd_mdcr_out'
3880: );

Line 3877: ,p_inst_name => 'ben_rt_prfl_cache.g_optd_mdcr_instance'

3873: --
3874: get_cached_data
3875: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3876: ,p_lookup_name => 'ben_rt_prfl_cache.g_optd_mdcr_lookup'
3877: ,p_inst_name => 'ben_rt_prfl_cache.g_optd_mdcr_instance'
3878: ,p_inst_set_type => 'ben_rt_prfl_cache.g_optd_mdcr_inst_tbl'
3879: ,p_out_inst_name => 'ben_rt_prfl_cache.g_optd_mdcr_out'
3880: );
3881: --

Line 3878: ,p_inst_set_type => 'ben_rt_prfl_cache.g_optd_mdcr_inst_tbl'

3874: get_cached_data
3875: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3876: ,p_lookup_name => 'ben_rt_prfl_cache.g_optd_mdcr_lookup'
3877: ,p_inst_name => 'ben_rt_prfl_cache.g_optd_mdcr_instance'
3878: ,p_inst_set_type => 'ben_rt_prfl_cache.g_optd_mdcr_inst_tbl'
3879: ,p_out_inst_name => 'ben_rt_prfl_cache.g_optd_mdcr_out'
3880: );
3881: --
3882: p_inst_set := g_optd_mdcr_out;

Line 3879: ,p_out_inst_name => 'ben_rt_prfl_cache.g_optd_mdcr_out'

3875: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3876: ,p_lookup_name => 'ben_rt_prfl_cache.g_optd_mdcr_lookup'
3877: ,p_inst_name => 'ben_rt_prfl_cache.g_optd_mdcr_instance'
3878: ,p_inst_set_type => 'ben_rt_prfl_cache.g_optd_mdcr_inst_tbl'
3879: ,p_out_inst_name => 'ben_rt_prfl_cache.g_optd_mdcr_out'
3880: );
3881: --
3882: p_inst_set := g_optd_mdcr_out;
3883: p_inst_count := g_inst_count;

Line 3902: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_lvg_rsn_inst_tbl

3898: (p_vrbl_rt_prfl_id in number
3899: ,p_effective_date in date
3900: ,p_lf_evt_ocrd_dt in date
3901: ,p_business_group_id in number
3902: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_lvg_rsn_inst_tbl
3903: ,p_inst_count out nocopy number)
3904: is
3905: --
3906: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 3951: ,p_lkup_name => 'ben_rt_prfl_cache.g_lvg_rsn_lookup'

3947: --
3948: ben_cache.write_mastDet_Cache
3949: (p_mastercol_name => 'vrbl_rt_prfl_id'
3950: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3951: ,p_lkup_name => 'ben_rt_prfl_cache.g_lvg_rsn_lookup'
3952: ,p_inst_name => 'ben_rt_prfl_cache.g_lvg_rsn_instance'
3953: ,p_lkup_query => l_lookup_query
3954: ,p_inst_query => l_inst_query
3955: ,p_instcolnm_set => l_instcolnm_set

Line 3952: ,p_inst_name => 'ben_rt_prfl_cache.g_lvg_rsn_instance'

3948: ben_cache.write_mastDet_Cache
3949: (p_mastercol_name => 'vrbl_rt_prfl_id'
3950: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3951: ,p_lkup_name => 'ben_rt_prfl_cache.g_lvg_rsn_lookup'
3952: ,p_inst_name => 'ben_rt_prfl_cache.g_lvg_rsn_instance'
3953: ,p_lkup_query => l_lookup_query
3954: ,p_inst_query => l_inst_query
3955: ,p_instcolnm_set => l_instcolnm_set
3956: );

Line 3964: ,p_lookup_name => 'ben_rt_prfl_cache.g_lvg_rsn_lookup'

3960: -- Cache already populated. Get record set.
3961: --
3962: get_cached_data
3963: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3964: ,p_lookup_name => 'ben_rt_prfl_cache.g_lvg_rsn_lookup'
3965: ,p_inst_name => 'ben_rt_prfl_cache.g_lvg_rsn_instance'
3966: ,p_inst_set_type => 'ben_rt_prfl_cache.g_lvg_rsn_inst_tbl'
3967: ,p_out_inst_name => 'ben_rt_prfl_cache.g_lvg_rsn_out'
3968: );

Line 3965: ,p_inst_name => 'ben_rt_prfl_cache.g_lvg_rsn_instance'

3961: --
3962: get_cached_data
3963: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3964: ,p_lookup_name => 'ben_rt_prfl_cache.g_lvg_rsn_lookup'
3965: ,p_inst_name => 'ben_rt_prfl_cache.g_lvg_rsn_instance'
3966: ,p_inst_set_type => 'ben_rt_prfl_cache.g_lvg_rsn_inst_tbl'
3967: ,p_out_inst_name => 'ben_rt_prfl_cache.g_lvg_rsn_out'
3968: );
3969: --

Line 3966: ,p_inst_set_type => 'ben_rt_prfl_cache.g_lvg_rsn_inst_tbl'

3962: get_cached_data
3963: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3964: ,p_lookup_name => 'ben_rt_prfl_cache.g_lvg_rsn_lookup'
3965: ,p_inst_name => 'ben_rt_prfl_cache.g_lvg_rsn_instance'
3966: ,p_inst_set_type => 'ben_rt_prfl_cache.g_lvg_rsn_inst_tbl'
3967: ,p_out_inst_name => 'ben_rt_prfl_cache.g_lvg_rsn_out'
3968: );
3969: --
3970: p_inst_set := g_lvg_rsn_out;

Line 3967: ,p_out_inst_name => 'ben_rt_prfl_cache.g_lvg_rsn_out'

3963: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3964: ,p_lookup_name => 'ben_rt_prfl_cache.g_lvg_rsn_lookup'
3965: ,p_inst_name => 'ben_rt_prfl_cache.g_lvg_rsn_instance'
3966: ,p_inst_set_type => 'ben_rt_prfl_cache.g_lvg_rsn_inst_tbl'
3967: ,p_out_inst_name => 'ben_rt_prfl_cache.g_lvg_rsn_out'
3968: );
3969: --
3970: p_inst_set := g_lvg_rsn_out;
3971: p_inst_count := g_inst_count;

Line 3991: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_cbr_qual_bnf_inst_tbl

3987: (p_vrbl_rt_prfl_id in number
3988: ,p_effective_date in date
3989: ,p_lf_evt_ocrd_dt in date
3990: ,p_business_group_id in number
3991: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_cbr_qual_bnf_inst_tbl
3992: ,p_inst_count out nocopy number)
3993: is
3994: --
3995: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 4044: ,p_lkup_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_lookup'

4040: --
4041: ben_cache.write_mastDet_Cache
4042: (p_mastercol_name => 'vrbl_rt_prfl_id'
4043: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4044: ,p_lkup_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_lookup'
4045: ,p_inst_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_instance'
4046: ,p_lkup_query => l_lookup_query
4047: ,p_inst_query => l_inst_query
4048: ,p_instcolnm_set => l_instcolnm_set

Line 4045: ,p_inst_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_instance'

4041: ben_cache.write_mastDet_Cache
4042: (p_mastercol_name => 'vrbl_rt_prfl_id'
4043: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4044: ,p_lkup_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_lookup'
4045: ,p_inst_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_instance'
4046: ,p_lkup_query => l_lookup_query
4047: ,p_inst_query => l_inst_query
4048: ,p_instcolnm_set => l_instcolnm_set
4049: );

Line 4057: ,p_lookup_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_lookup'

4053: -- Cache already populated. Get record set.
4054: --
4055: get_cached_data
4056: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4057: ,p_lookup_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_lookup'
4058: ,p_inst_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_instance'
4059: ,p_inst_set_type => 'ben_rt_prfl_cache.g_cbr_qual_bnf_inst_tbl'
4060: ,p_out_inst_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_out'
4061: );

Line 4058: ,p_inst_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_instance'

4054: --
4055: get_cached_data
4056: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4057: ,p_lookup_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_lookup'
4058: ,p_inst_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_instance'
4059: ,p_inst_set_type => 'ben_rt_prfl_cache.g_cbr_qual_bnf_inst_tbl'
4060: ,p_out_inst_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_out'
4061: );
4062: --

Line 4059: ,p_inst_set_type => 'ben_rt_prfl_cache.g_cbr_qual_bnf_inst_tbl'

4055: get_cached_data
4056: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4057: ,p_lookup_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_lookup'
4058: ,p_inst_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_instance'
4059: ,p_inst_set_type => 'ben_rt_prfl_cache.g_cbr_qual_bnf_inst_tbl'
4060: ,p_out_inst_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_out'
4061: );
4062: --
4063: p_inst_set := g_cbr_qual_bnf_out;

Line 4060: ,p_out_inst_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_out'

4056: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4057: ,p_lookup_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_lookup'
4058: ,p_inst_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_instance'
4059: ,p_inst_set_type => 'ben_rt_prfl_cache.g_cbr_qual_bnf_inst_tbl'
4060: ,p_out_inst_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_out'
4061: );
4062: --
4063: p_inst_set := g_cbr_qual_bnf_out;
4064: p_inst_count := g_inst_count;

Line 4084: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_cntng_prtn_prfl_inst_tbl

4080: (p_vrbl_rt_prfl_id in number
4081: ,p_effective_date in date
4082: ,p_lf_evt_ocrd_dt in date
4083: ,p_business_group_id in number
4084: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_cntng_prtn_prfl_inst_tbl
4085: ,p_inst_count out nocopy number)
4086: is
4087: --
4088: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 4137: ,p_lkup_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_lookup'

4133: --
4134: ben_cache.write_mastDet_Cache
4135: (p_mastercol_name => 'vrbl_rt_prfl_id'
4136: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4137: ,p_lkup_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_lookup'
4138: ,p_inst_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_instance'
4139: ,p_lkup_query => l_lookup_query
4140: ,p_inst_query => l_inst_query
4141: ,p_instcolnm_set => l_instcolnm_set

Line 4138: ,p_inst_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_instance'

4134: ben_cache.write_mastDet_Cache
4135: (p_mastercol_name => 'vrbl_rt_prfl_id'
4136: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4137: ,p_lkup_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_lookup'
4138: ,p_inst_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_instance'
4139: ,p_lkup_query => l_lookup_query
4140: ,p_inst_query => l_inst_query
4141: ,p_instcolnm_set => l_instcolnm_set
4142: );

Line 4150: ,p_lookup_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_lookup'

4146: -- Cache already populated. Get record set.
4147: --
4148: get_cached_data
4149: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4150: ,p_lookup_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_lookup'
4151: ,p_inst_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_instance'
4152: ,p_inst_set_type => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_inst_tbl'
4153: ,p_out_inst_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_out'
4154: );

Line 4151: ,p_inst_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_instance'

4147: --
4148: get_cached_data
4149: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4150: ,p_lookup_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_lookup'
4151: ,p_inst_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_instance'
4152: ,p_inst_set_type => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_inst_tbl'
4153: ,p_out_inst_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_out'
4154: );
4155: --

Line 4152: ,p_inst_set_type => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_inst_tbl'

4148: get_cached_data
4149: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4150: ,p_lookup_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_lookup'
4151: ,p_inst_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_instance'
4152: ,p_inst_set_type => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_inst_tbl'
4153: ,p_out_inst_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_out'
4154: );
4155: --
4156: p_inst_set := g_cntng_prtn_prfl_out;

Line 4153: ,p_out_inst_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_out'

4149: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4150: ,p_lookup_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_lookup'
4151: ,p_inst_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_instance'
4152: ,p_inst_set_type => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_inst_tbl'
4153: ,p_out_inst_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_out'
4154: );
4155: --
4156: p_inst_set := g_cntng_prtn_prfl_out;
4157: p_inst_count := g_inst_count;

Line 4178: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_pstn_inst_tbl

4174: (p_vrbl_rt_prfl_id in number
4175: ,p_effective_date in date
4176: ,p_lf_evt_ocrd_dt in date
4177: ,p_business_group_id in number
4178: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_pstn_inst_tbl
4179: ,p_inst_count out nocopy number)
4180: is
4181: --
4182: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 4227: ,p_lkup_name => 'ben_rt_prfl_cache.g_pstn_lookup'

4223: --
4224: ben_cache.write_mastDet_Cache
4225: (p_mastercol_name => 'vrbl_rt_prfl_id'
4226: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4227: ,p_lkup_name => 'ben_rt_prfl_cache.g_pstn_lookup'
4228: ,p_inst_name => 'ben_rt_prfl_cache.g_pstn_instance'
4229: ,p_lkup_query => l_lookup_query
4230: ,p_inst_query => l_inst_query
4231: ,p_instcolnm_set => l_instcolnm_set

Line 4228: ,p_inst_name => 'ben_rt_prfl_cache.g_pstn_instance'

4224: ben_cache.write_mastDet_Cache
4225: (p_mastercol_name => 'vrbl_rt_prfl_id'
4226: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4227: ,p_lkup_name => 'ben_rt_prfl_cache.g_pstn_lookup'
4228: ,p_inst_name => 'ben_rt_prfl_cache.g_pstn_instance'
4229: ,p_lkup_query => l_lookup_query
4230: ,p_inst_query => l_inst_query
4231: ,p_instcolnm_set => l_instcolnm_set
4232: );

Line 4240: ,p_lookup_name => 'ben_rt_prfl_cache.g_pstn_lookup'

4236: -- Cache already populated. Get record set.
4237: --
4238: get_cached_data
4239: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4240: ,p_lookup_name => 'ben_rt_prfl_cache.g_pstn_lookup'
4241: ,p_inst_name => 'ben_rt_prfl_cache.g_pstn_instance'
4242: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pstn_inst_tbl'
4243: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pstn_out'
4244: );

Line 4241: ,p_inst_name => 'ben_rt_prfl_cache.g_pstn_instance'

4237: --
4238: get_cached_data
4239: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4240: ,p_lookup_name => 'ben_rt_prfl_cache.g_pstn_lookup'
4241: ,p_inst_name => 'ben_rt_prfl_cache.g_pstn_instance'
4242: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pstn_inst_tbl'
4243: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pstn_out'
4244: );
4245: --

Line 4242: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pstn_inst_tbl'

4238: get_cached_data
4239: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4240: ,p_lookup_name => 'ben_rt_prfl_cache.g_pstn_lookup'
4241: ,p_inst_name => 'ben_rt_prfl_cache.g_pstn_instance'
4242: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pstn_inst_tbl'
4243: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pstn_out'
4244: );
4245: --
4246: p_inst_set := g_pstn_out;

Line 4243: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pstn_out'

4239: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4240: ,p_lookup_name => 'ben_rt_prfl_cache.g_pstn_lookup'
4241: ,p_inst_name => 'ben_rt_prfl_cache.g_pstn_instance'
4242: ,p_inst_set_type => 'ben_rt_prfl_cache.g_pstn_inst_tbl'
4243: ,p_out_inst_name => 'ben_rt_prfl_cache.g_pstn_out'
4244: );
4245: --
4246: p_inst_set := g_pstn_out;
4247: p_inst_count := g_inst_count;

Line 4268: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_comptncy_inst_tbl

4264: (p_vrbl_rt_prfl_id in number
4265: ,p_effective_date in date
4266: ,p_lf_evt_ocrd_dt in date
4267: ,p_business_group_id in number
4268: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_comptncy_inst_tbl
4269: ,p_inst_count out nocopy number)
4270: is
4271: --
4272: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 4320: ,p_lkup_name => 'ben_rt_prfl_cache.g_comptncy_lookup'

4316: --
4317: ben_cache.write_mastDet_Cache
4318: (p_mastercol_name => 'vrbl_rt_prfl_id'
4319: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4320: ,p_lkup_name => 'ben_rt_prfl_cache.g_comptncy_lookup'
4321: ,p_inst_name => 'ben_rt_prfl_cache.g_comptncy_instance'
4322: ,p_lkup_query => l_lookup_query
4323: ,p_inst_query => l_inst_query
4324: ,p_instcolnm_set => l_instcolnm_set

Line 4321: ,p_inst_name => 'ben_rt_prfl_cache.g_comptncy_instance'

4317: ben_cache.write_mastDet_Cache
4318: (p_mastercol_name => 'vrbl_rt_prfl_id'
4319: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4320: ,p_lkup_name => 'ben_rt_prfl_cache.g_comptncy_lookup'
4321: ,p_inst_name => 'ben_rt_prfl_cache.g_comptncy_instance'
4322: ,p_lkup_query => l_lookup_query
4323: ,p_inst_query => l_inst_query
4324: ,p_instcolnm_set => l_instcolnm_set
4325: );

Line 4333: ,p_lookup_name => 'ben_rt_prfl_cache.g_comptncy_lookup'

4329: -- Cache already populated. Get record set.
4330: --
4331: get_cached_data
4332: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4333: ,p_lookup_name => 'ben_rt_prfl_cache.g_comptncy_lookup'
4334: ,p_inst_name => 'ben_rt_prfl_cache.g_comptncy_instance'
4335: ,p_inst_set_type => 'ben_rt_prfl_cache.g_comptncy_inst_tbl'
4336: ,p_out_inst_name => 'ben_rt_prfl_cache.g_comptncy_out'
4337: );

Line 4334: ,p_inst_name => 'ben_rt_prfl_cache.g_comptncy_instance'

4330: --
4331: get_cached_data
4332: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4333: ,p_lookup_name => 'ben_rt_prfl_cache.g_comptncy_lookup'
4334: ,p_inst_name => 'ben_rt_prfl_cache.g_comptncy_instance'
4335: ,p_inst_set_type => 'ben_rt_prfl_cache.g_comptncy_inst_tbl'
4336: ,p_out_inst_name => 'ben_rt_prfl_cache.g_comptncy_out'
4337: );
4338: --

Line 4335: ,p_inst_set_type => 'ben_rt_prfl_cache.g_comptncy_inst_tbl'

4331: get_cached_data
4332: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4333: ,p_lookup_name => 'ben_rt_prfl_cache.g_comptncy_lookup'
4334: ,p_inst_name => 'ben_rt_prfl_cache.g_comptncy_instance'
4335: ,p_inst_set_type => 'ben_rt_prfl_cache.g_comptncy_inst_tbl'
4336: ,p_out_inst_name => 'ben_rt_prfl_cache.g_comptncy_out'
4337: );
4338: --
4339: p_inst_set := g_comptncy_out;

Line 4336: ,p_out_inst_name => 'ben_rt_prfl_cache.g_comptncy_out'

4332: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4333: ,p_lookup_name => 'ben_rt_prfl_cache.g_comptncy_lookup'
4334: ,p_inst_name => 'ben_rt_prfl_cache.g_comptncy_instance'
4335: ,p_inst_set_type => 'ben_rt_prfl_cache.g_comptncy_inst_tbl'
4336: ,p_out_inst_name => 'ben_rt_prfl_cache.g_comptncy_out'
4337: );
4338: --
4339: p_inst_set := g_comptncy_out;
4340: p_inst_count := g_inst_count;

Line 4361: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_qual_titl_inst_tbl

4357: (p_vrbl_rt_prfl_id in number
4358: ,p_effective_date in date
4359: ,p_lf_evt_ocrd_dt in date
4360: ,p_business_group_id in number
4361: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_qual_titl_inst_tbl
4362: ,p_inst_count out nocopy number)
4363: is
4364: --
4365: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 4413: ,p_lkup_name => 'ben_rt_prfl_cache.g_qual_titl_lookup'

4409: --
4410: ben_cache.write_mastDet_Cache
4411: (p_mastercol_name => 'vrbl_rt_prfl_id'
4412: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4413: ,p_lkup_name => 'ben_rt_prfl_cache.g_qual_titl_lookup'
4414: ,p_inst_name => 'ben_rt_prfl_cache.g_qual_titl_instance'
4415: ,p_lkup_query => l_lookup_query
4416: ,p_inst_query => l_inst_query
4417: ,p_instcolnm_set => l_instcolnm_set

Line 4414: ,p_inst_name => 'ben_rt_prfl_cache.g_qual_titl_instance'

4410: ben_cache.write_mastDet_Cache
4411: (p_mastercol_name => 'vrbl_rt_prfl_id'
4412: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4413: ,p_lkup_name => 'ben_rt_prfl_cache.g_qual_titl_lookup'
4414: ,p_inst_name => 'ben_rt_prfl_cache.g_qual_titl_instance'
4415: ,p_lkup_query => l_lookup_query
4416: ,p_inst_query => l_inst_query
4417: ,p_instcolnm_set => l_instcolnm_set
4418: );

Line 4426: ,p_lookup_name => 'ben_rt_prfl_cache.g_qual_titl_lookup'

4422: -- Cache already populated. Get record set.
4423: --
4424: get_cached_data
4425: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4426: ,p_lookup_name => 'ben_rt_prfl_cache.g_qual_titl_lookup'
4427: ,p_inst_name => 'ben_rt_prfl_cache.g_qual_titl_instance'
4428: ,p_inst_set_type => 'ben_rt_prfl_cache.g_qual_titl_inst_tbl'
4429: ,p_out_inst_name => 'ben_rt_prfl_cache.g_qual_titl_out'
4430: );

Line 4427: ,p_inst_name => 'ben_rt_prfl_cache.g_qual_titl_instance'

4423: --
4424: get_cached_data
4425: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4426: ,p_lookup_name => 'ben_rt_prfl_cache.g_qual_titl_lookup'
4427: ,p_inst_name => 'ben_rt_prfl_cache.g_qual_titl_instance'
4428: ,p_inst_set_type => 'ben_rt_prfl_cache.g_qual_titl_inst_tbl'
4429: ,p_out_inst_name => 'ben_rt_prfl_cache.g_qual_titl_out'
4430: );
4431: --

Line 4428: ,p_inst_set_type => 'ben_rt_prfl_cache.g_qual_titl_inst_tbl'

4424: get_cached_data
4425: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4426: ,p_lookup_name => 'ben_rt_prfl_cache.g_qual_titl_lookup'
4427: ,p_inst_name => 'ben_rt_prfl_cache.g_qual_titl_instance'
4428: ,p_inst_set_type => 'ben_rt_prfl_cache.g_qual_titl_inst_tbl'
4429: ,p_out_inst_name => 'ben_rt_prfl_cache.g_qual_titl_out'
4430: );
4431: --
4432: p_inst_set := g_qual_titl_out;

Line 4429: ,p_out_inst_name => 'ben_rt_prfl_cache.g_qual_titl_out'

4425: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4426: ,p_lookup_name => 'ben_rt_prfl_cache.g_qual_titl_lookup'
4427: ,p_inst_name => 'ben_rt_prfl_cache.g_qual_titl_instance'
4428: ,p_inst_set_type => 'ben_rt_prfl_cache.g_qual_titl_inst_tbl'
4429: ,p_out_inst_name => 'ben_rt_prfl_cache.g_qual_titl_out'
4430: );
4431: --
4432: p_inst_set := g_qual_titl_out;
4433: p_inst_count := g_inst_count;

Line 4455: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_inst_tbl

4451: (p_vrbl_rt_prfl_id in number
4452: ,p_effective_date in date
4453: ,p_lf_evt_ocrd_dt in date
4454: ,p_business_group_id in number
4455: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_inst_tbl
4456: ,p_inst_count out nocopy number) as
4457:
4458: --
4459: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 4507: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_lookup'

4503: --
4504: ben_cache.write_mastDet_Cache
4505: (p_mastercol_name => 'vrbl_rt_prfl_id'
4506: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4507: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_lookup'
4508: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_instance'
4509: ,p_lkup_query => l_lookup_query
4510: ,p_inst_query => l_inst_query
4511: ,p_instcolnm_set => l_instcolnm_set

Line 4508: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_instance'

4504: ben_cache.write_mastDet_Cache
4505: (p_mastercol_name => 'vrbl_rt_prfl_id'
4506: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4507: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_lookup'
4508: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_instance'
4509: ,p_lkup_query => l_lookup_query
4510: ,p_inst_query => l_inst_query
4511: ,p_instcolnm_set => l_instcolnm_set
4512: );

Line 4520: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_lookup'

4516: -- Cache already populated. Get record set.
4517: --
4518: get_cached_data
4519: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4520: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_lookup'
4521: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_instance'
4522: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_inst_tbl'
4523: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_out'
4524: );

Line 4521: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_instance'

4517: --
4518: get_cached_data
4519: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4520: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_lookup'
4521: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_instance'
4522: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_inst_tbl'
4523: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_out'
4524: );
4525: --

Line 4522: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_inst_tbl'

4518: get_cached_data
4519: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4520: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_lookup'
4521: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_instance'
4522: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_inst_tbl'
4523: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_out'
4524: );
4525: --
4526: p_inst_set := g_dpnt_cvrd_othr_pl_out;

Line 4523: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_out'

4519: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4520: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_lookup'
4521: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_instance'
4522: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_inst_tbl'
4523: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_out'
4524: );
4525: --
4526: p_inst_set := g_dpnt_cvrd_othr_pl_out;
4527: p_inst_count := g_inst_count;

Line 4547: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_inst_tbl

4543: (p_vrbl_rt_prfl_id in number
4544: ,p_effective_date in date
4545: ,p_lf_evt_ocrd_dt in date
4546: ,p_business_group_id in number
4547: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_inst_tbl
4548: ,p_inst_count out nocopy number) as
4549: --
4550: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
4551: l_lookup_query long;

Line 4598: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_lookup'

4594: --
4595: ben_cache.write_mastDet_Cache
4596: (p_mastercol_name => 'vrbl_rt_prfl_id'
4597: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4598: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_lookup'
4599: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_instance'
4600: ,p_lkup_query => l_lookup_query
4601: ,p_inst_query => l_inst_query
4602: ,p_instcolnm_set => l_instcolnm_set

Line 4599: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_instance'

4595: ben_cache.write_mastDet_Cache
4596: (p_mastercol_name => 'vrbl_rt_prfl_id'
4597: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4598: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_lookup'
4599: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_instance'
4600: ,p_lkup_query => l_lookup_query
4601: ,p_inst_query => l_inst_query
4602: ,p_instcolnm_set => l_instcolnm_set
4603: );

Line 4611: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_lookup'

4607: -- Cache already populated. Get record set.
4608: --
4609: get_cached_data
4610: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4611: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_lookup'
4612: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_instance'
4613: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_inst_tbl'
4614: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_out'
4615: );

Line 4612: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_instance'

4608: --
4609: get_cached_data
4610: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4611: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_lookup'
4612: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_instance'
4613: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_inst_tbl'
4614: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_out'
4615: );
4616: --

Line 4613: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_inst_tbl'

4609: get_cached_data
4610: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4611: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_lookup'
4612: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_instance'
4613: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_inst_tbl'
4614: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_out'
4615: );
4616: --
4617: p_inst_set := g_dpnt_cvrd_othr_plip_out;

Line 4614: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_out'

4610: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4611: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_lookup'
4612: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_instance'
4613: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_inst_tbl'
4614: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_out'
4615: );
4616: --
4617: p_inst_set := g_dpnt_cvrd_othr_plip_out;
4618: p_inst_count := g_inst_count;

Line 4638: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_inst_tbl

4634: (p_vrbl_rt_prfl_id in number
4635: ,p_effective_date in date
4636: ,p_lf_evt_ocrd_dt in date
4637: ,p_business_group_id in number
4638: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_inst_tbl
4639: ,p_inst_count out nocopy number) as
4640:
4641: --
4642: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 4693: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_lookup'

4689: --
4690: ben_cache.write_mastDet_Cache
4691: (p_mastercol_name => 'vrbl_rt_prfl_id'
4692: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4693: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_lookup'
4694: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_instance'
4695: ,p_lkup_query => l_lookup_query
4696: ,p_inst_query => l_inst_query
4697: ,p_instcolnm_set => l_instcolnm_set

Line 4694: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_instance'

4690: ben_cache.write_mastDet_Cache
4691: (p_mastercol_name => 'vrbl_rt_prfl_id'
4692: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4693: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_lookup'
4694: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_instance'
4695: ,p_lkup_query => l_lookup_query
4696: ,p_inst_query => l_inst_query
4697: ,p_instcolnm_set => l_instcolnm_set
4698: );

Line 4706: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_lookup'

4702: -- Cache already populated. Get record set.
4703: --
4704: get_cached_data
4705: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4706: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_lookup'
4707: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_instance'
4708: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_inst_tbl'
4709: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_out'
4710: );

Line 4707: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_instance'

4703: --
4704: get_cached_data
4705: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4706: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_lookup'
4707: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_instance'
4708: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_inst_tbl'
4709: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_out'
4710: );
4711: --

Line 4708: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_inst_tbl'

4704: get_cached_data
4705: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4706: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_lookup'
4707: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_instance'
4708: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_inst_tbl'
4709: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_out'
4710: );
4711: --
4712: p_inst_set := g_dpnt_cvrd_othr_ptip_out;

Line 4709: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_out'

4705: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4706: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_lookup'
4707: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_instance'
4708: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_inst_tbl'
4709: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_out'
4710: );
4711: --
4712: p_inst_set := g_dpnt_cvrd_othr_ptip_out;
4713: p_inst_count := g_inst_count;

Line 4734: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_inst_tbl

4730: (p_vrbl_rt_prfl_id in number
4731: ,p_effective_date in date
4732: ,p_lf_evt_ocrd_dt in date
4733: ,p_business_group_id in number
4734: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_inst_tbl
4735: ,p_inst_count out nocopy number) as
4736: --
4737: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
4738: l_lookup_query long;

Line 4788: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_lookup'

4784: --
4785: ben_cache.write_mastDet_Cache
4786: (p_mastercol_name => 'vrbl_rt_prfl_id'
4787: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4788: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_lookup'
4789: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_instance'
4790: ,p_lkup_query => l_lookup_query
4791: ,p_inst_query => l_inst_query
4792: ,p_instcolnm_set => l_instcolnm_set

Line 4789: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_instance'

4785: ben_cache.write_mastDet_Cache
4786: (p_mastercol_name => 'vrbl_rt_prfl_id'
4787: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4788: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_lookup'
4789: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_instance'
4790: ,p_lkup_query => l_lookup_query
4791: ,p_inst_query => l_inst_query
4792: ,p_instcolnm_set => l_instcolnm_set
4793: );

Line 4801: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_lookup'

4797: -- Cache already populated. Get record set.
4798: --
4799: get_cached_data
4800: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4801: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_lookup'
4802: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_instance'
4803: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_inst_tbl'
4804: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_out'
4805: );

Line 4802: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_instance'

4798: --
4799: get_cached_data
4800: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4801: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_lookup'
4802: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_instance'
4803: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_inst_tbl'
4804: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_out'
4805: );
4806: --

Line 4803: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_inst_tbl'

4799: get_cached_data
4800: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4801: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_lookup'
4802: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_instance'
4803: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_inst_tbl'
4804: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_out'
4805: );
4806: --
4807: p_inst_set := g_dpnt_cvrd_othr_pgm_out;

Line 4804: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_out'

4800: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4801: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_lookup'
4802: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_instance'
4803: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_inst_tbl'
4804: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_out'
4805: );
4806: --
4807: p_inst_set := g_dpnt_cvrd_othr_pgm_out;
4808: p_inst_count := g_inst_count;

Line 4829: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_prtt_anthr_pl_inst_tbl

4825: (p_vrbl_rt_prfl_id in number
4826: ,p_effective_date in date
4827: ,p_lf_evt_ocrd_dt in date
4828: ,p_business_group_id in number
4829: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_prtt_anthr_pl_inst_tbl
4830: ,p_inst_count out nocopy number) as
4831: --
4832: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
4833: l_lookup_query long;

Line 4879: ,p_lkup_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_lookup'

4875: --
4876: ben_cache.write_mastDet_Cache
4877: (p_mastercol_name => 'vrbl_rt_prfl_id'
4878: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4879: ,p_lkup_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_lookup'
4880: ,p_inst_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_instance'
4881: ,p_lkup_query => l_lookup_query
4882: ,p_inst_query => l_inst_query
4883: ,p_instcolnm_set => l_instcolnm_set

Line 4880: ,p_inst_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_instance'

4876: ben_cache.write_mastDet_Cache
4877: (p_mastercol_name => 'vrbl_rt_prfl_id'
4878: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4879: ,p_lkup_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_lookup'
4880: ,p_inst_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_instance'
4881: ,p_lkup_query => l_lookup_query
4882: ,p_inst_query => l_inst_query
4883: ,p_instcolnm_set => l_instcolnm_set
4884: );

Line 4892: ,p_lookup_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_lookup'

4888: -- Cache already populated. Get record set.
4889: --
4890: get_cached_data
4891: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4892: ,p_lookup_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_lookup'
4893: ,p_inst_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_instance'
4894: ,p_inst_set_type => 'ben_rt_prfl_cache.g_prtt_anthr_pl_inst_tbl'
4895: ,p_out_inst_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_out'
4896: );

Line 4893: ,p_inst_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_instance'

4889: --
4890: get_cached_data
4891: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4892: ,p_lookup_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_lookup'
4893: ,p_inst_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_instance'
4894: ,p_inst_set_type => 'ben_rt_prfl_cache.g_prtt_anthr_pl_inst_tbl'
4895: ,p_out_inst_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_out'
4896: );
4897: --

Line 4894: ,p_inst_set_type => 'ben_rt_prfl_cache.g_prtt_anthr_pl_inst_tbl'

4890: get_cached_data
4891: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4892: ,p_lookup_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_lookup'
4893: ,p_inst_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_instance'
4894: ,p_inst_set_type => 'ben_rt_prfl_cache.g_prtt_anthr_pl_inst_tbl'
4895: ,p_out_inst_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_out'
4896: );
4897: --
4898: p_inst_set := g_prtt_anthr_pl_out;

Line 4895: ,p_out_inst_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_out'

4891: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4892: ,p_lookup_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_lookup'
4893: ,p_inst_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_instance'
4894: ,p_inst_set_type => 'ben_rt_prfl_cache.g_prtt_anthr_pl_inst_tbl'
4895: ,p_out_inst_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_out'
4896: );
4897: --
4898: p_inst_set := g_prtt_anthr_pl_out;
4899: p_inst_count := g_inst_count;

Line 4920: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_othr_ptip_inst_tbl

4916: (p_vrbl_rt_prfl_id in number
4917: ,p_effective_date in date
4918: ,p_lf_evt_ocrd_dt in date
4919: ,p_business_group_id in number
4920: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_othr_ptip_inst_tbl
4921: ,p_inst_count out nocopy number) as
4922: --
4923: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
4924: l_lookup_query long;

Line 4973: ,p_lkup_name => 'ben_rt_prfl_cache.g_othr_ptip_lookup'

4969: --
4970: ben_cache.write_mastDet_Cache
4971: (p_mastercol_name => 'vrbl_rt_prfl_id'
4972: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4973: ,p_lkup_name => 'ben_rt_prfl_cache.g_othr_ptip_lookup'
4974: ,p_inst_name => 'ben_rt_prfl_cache.g_othr_ptip_instance'
4975: ,p_lkup_query => l_lookup_query
4976: ,p_inst_query => l_inst_query
4977: ,p_instcolnm_set => l_instcolnm_set

Line 4974: ,p_inst_name => 'ben_rt_prfl_cache.g_othr_ptip_instance'

4970: ben_cache.write_mastDet_Cache
4971: (p_mastercol_name => 'vrbl_rt_prfl_id'
4972: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4973: ,p_lkup_name => 'ben_rt_prfl_cache.g_othr_ptip_lookup'
4974: ,p_inst_name => 'ben_rt_prfl_cache.g_othr_ptip_instance'
4975: ,p_lkup_query => l_lookup_query
4976: ,p_inst_query => l_inst_query
4977: ,p_instcolnm_set => l_instcolnm_set
4978: );

Line 4986: ,p_lookup_name => 'ben_rt_prfl_cache.g_othr_ptip_lookup'

4982: -- Cache already populated. Get record set.
4983: --
4984: get_cached_data
4985: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4986: ,p_lookup_name => 'ben_rt_prfl_cache.g_othr_ptip_lookup'
4987: ,p_inst_name => 'ben_rt_prfl_cache.g_othr_ptip_instance'
4988: ,p_inst_set_type => 'ben_rt_prfl_cache.g_othr_ptip_inst_tbl'
4989: ,p_out_inst_name => 'ben_rt_prfl_cache.g_othr_ptip_out'
4990: );

Line 4987: ,p_inst_name => 'ben_rt_prfl_cache.g_othr_ptip_instance'

4983: --
4984: get_cached_data
4985: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4986: ,p_lookup_name => 'ben_rt_prfl_cache.g_othr_ptip_lookup'
4987: ,p_inst_name => 'ben_rt_prfl_cache.g_othr_ptip_instance'
4988: ,p_inst_set_type => 'ben_rt_prfl_cache.g_othr_ptip_inst_tbl'
4989: ,p_out_inst_name => 'ben_rt_prfl_cache.g_othr_ptip_out'
4990: );
4991: --

Line 4988: ,p_inst_set_type => 'ben_rt_prfl_cache.g_othr_ptip_inst_tbl'

4984: get_cached_data
4985: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4986: ,p_lookup_name => 'ben_rt_prfl_cache.g_othr_ptip_lookup'
4987: ,p_inst_name => 'ben_rt_prfl_cache.g_othr_ptip_instance'
4988: ,p_inst_set_type => 'ben_rt_prfl_cache.g_othr_ptip_inst_tbl'
4989: ,p_out_inst_name => 'ben_rt_prfl_cache.g_othr_ptip_out'
4990: );
4991: --
4992: p_inst_set := g_othr_ptip_out;

Line 4989: ,p_out_inst_name => 'ben_rt_prfl_cache.g_othr_ptip_out'

4985: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
4986: ,p_lookup_name => 'ben_rt_prfl_cache.g_othr_ptip_lookup'
4987: ,p_inst_name => 'ben_rt_prfl_cache.g_othr_ptip_instance'
4988: ,p_inst_set_type => 'ben_rt_prfl_cache.g_othr_ptip_inst_tbl'
4989: ,p_out_inst_name => 'ben_rt_prfl_cache.g_othr_ptip_out'
4990: );
4991: --
4992: p_inst_set := g_othr_ptip_out;
4993: p_inst_count := g_inst_count;

Line 5014: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_enrld_anthr_pl_inst_tbl

5010: (p_vrbl_rt_prfl_id in number
5011: ,p_effective_date in date
5012: ,p_lf_evt_ocrd_dt in date
5013: ,p_business_group_id in number
5014: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_enrld_anthr_pl_inst_tbl
5015: ,p_inst_count out nocopy number) as
5016: --
5017: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
5018: l_lookup_query long;

Line 5066: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_lookup'

5062: --
5063: ben_cache.write_mastDet_Cache
5064: (p_mastercol_name => 'vrbl_rt_prfl_id'
5065: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5066: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_lookup'
5067: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_instance'
5068: ,p_lkup_query => l_lookup_query
5069: ,p_inst_query => l_inst_query
5070: ,p_instcolnm_set => l_instcolnm_set

Line 5067: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_instance'

5063: ben_cache.write_mastDet_Cache
5064: (p_mastercol_name => 'vrbl_rt_prfl_id'
5065: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5066: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_lookup'
5067: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_instance'
5068: ,p_lkup_query => l_lookup_query
5069: ,p_inst_query => l_inst_query
5070: ,p_instcolnm_set => l_instcolnm_set
5071: );

Line 5079: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_lookup'

5075: -- Cache already populated. Get record set.
5076: --
5077: get_cached_data
5078: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5079: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_lookup'
5080: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_instance'
5081: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_pl_inst_tbl'
5082: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_out'
5083: );

Line 5080: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_instance'

5076: --
5077: get_cached_data
5078: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5079: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_lookup'
5080: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_instance'
5081: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_pl_inst_tbl'
5082: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_out'
5083: );
5084: --

Line 5081: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_pl_inst_tbl'

5077: get_cached_data
5078: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5079: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_lookup'
5080: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_instance'
5081: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_pl_inst_tbl'
5082: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_out'
5083: );
5084: --
5085: p_inst_set := g_enrld_anthr_pl_out;

Line 5082: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_out'

5078: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5079: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_lookup'
5080: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_instance'
5081: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_pl_inst_tbl'
5082: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_out'
5083: );
5084: --
5085: p_inst_set := g_enrld_anthr_pl_out;
5086: p_inst_count := g_inst_count;

Line 5107: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_enrld_anthr_oipl_inst_tbl

5103: (p_vrbl_rt_prfl_id in number
5104: ,p_effective_date in date
5105: ,p_lf_evt_ocrd_dt in date
5106: ,p_business_group_id in number
5107: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_enrld_anthr_oipl_inst_tbl
5108: ,p_inst_count out nocopy number) as
5109: --
5110: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
5111: l_lookup_query long;

Line 5159: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_lookup'

5155: --
5156: ben_cache.write_mastDet_Cache
5157: (p_mastercol_name => 'vrbl_rt_prfl_id'
5158: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5159: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_lookup'
5160: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_instance'
5161: ,p_lkup_query => l_lookup_query
5162: ,p_inst_query => l_inst_query
5163: ,p_instcolnm_set => l_instcolnm_set

Line 5160: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_instance'

5156: ben_cache.write_mastDet_Cache
5157: (p_mastercol_name => 'vrbl_rt_prfl_id'
5158: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5159: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_lookup'
5160: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_instance'
5161: ,p_lkup_query => l_lookup_query
5162: ,p_inst_query => l_inst_query
5163: ,p_instcolnm_set => l_instcolnm_set
5164: );

Line 5172: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_lookup'

5168: -- Cache already populated. Get record set.
5169: --
5170: get_cached_data
5171: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5172: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_lookup'
5173: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_instance'
5174: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_inst_tbl'
5175: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_out'
5176: );

Line 5173: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_instance'

5169: --
5170: get_cached_data
5171: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5172: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_lookup'
5173: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_instance'
5174: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_inst_tbl'
5175: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_out'
5176: );
5177: --

Line 5174: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_inst_tbl'

5170: get_cached_data
5171: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5172: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_lookup'
5173: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_instance'
5174: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_inst_tbl'
5175: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_out'
5176: );
5177: --
5178: p_inst_set := g_enrld_anthr_oipl_out;

Line 5175: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_out'

5171: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5172: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_lookup'
5173: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_instance'
5174: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_inst_tbl'
5175: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_out'
5176: );
5177: --
5178: p_inst_set := g_enrld_anthr_oipl_out;
5179: p_inst_count := g_inst_count;

Line 5200: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_enrld_anthr_plip_inst_tbl

5196: (p_vrbl_rt_prfl_id in number
5197: ,p_effective_date in date
5198: ,p_lf_evt_ocrd_dt in date
5199: ,p_business_group_id in number
5200: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_enrld_anthr_plip_inst_tbl
5201: ,p_inst_count out nocopy number) as
5202: --
5203: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
5204: l_lookup_query long;

Line 5252: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_lookup'

5248: --
5249: ben_cache.write_mastDet_Cache
5250: (p_mastercol_name => 'vrbl_rt_prfl_id'
5251: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5252: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_lookup'
5253: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_instance'
5254: ,p_lkup_query => l_lookup_query
5255: ,p_inst_query => l_inst_query
5256: ,p_instcolnm_set => l_instcolnm_set

Line 5253: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_instance'

5249: ben_cache.write_mastDet_Cache
5250: (p_mastercol_name => 'vrbl_rt_prfl_id'
5251: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5252: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_lookup'
5253: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_instance'
5254: ,p_lkup_query => l_lookup_query
5255: ,p_inst_query => l_inst_query
5256: ,p_instcolnm_set => l_instcolnm_set
5257: );

Line 5265: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_lookup'

5261: -- Cache already populated. Get record set.
5262: --
5263: get_cached_data
5264: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5265: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_lookup'
5266: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_instance'
5267: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_plip_inst_tbl'
5268: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_out'
5269: );

Line 5266: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_instance'

5262: --
5263: get_cached_data
5264: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5265: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_lookup'
5266: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_instance'
5267: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_plip_inst_tbl'
5268: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_out'
5269: );
5270: --

Line 5267: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_plip_inst_tbl'

5263: get_cached_data
5264: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5265: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_lookup'
5266: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_instance'
5267: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_plip_inst_tbl'
5268: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_out'
5269: );
5270: --
5271: p_inst_set := g_enrld_anthr_plip_out;

Line 5268: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_out'

5264: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5265: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_lookup'
5266: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_instance'
5267: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_plip_inst_tbl'
5268: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_out'
5269: );
5270: --
5271: p_inst_set := g_enrld_anthr_plip_out;
5272: p_inst_count := g_inst_count;

Line 5293: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_enrld_anthr_ptip_inst_tbl

5289: (p_vrbl_rt_prfl_id in number
5290: ,p_effective_date in date
5291: ,p_lf_evt_ocrd_dt in date
5292: ,p_business_group_id in number
5293: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_enrld_anthr_ptip_inst_tbl
5294: ,p_inst_count out nocopy number) as
5295: --
5296: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
5297: l_lookup_query long;

Line 5348: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_lookup'

5344: --
5345: ben_cache.write_mastDet_Cache
5346: (p_mastercol_name => 'vrbl_rt_prfl_id'
5347: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5348: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_lookup'
5349: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_instance'
5350: ,p_lkup_query => l_lookup_query
5351: ,p_inst_query => l_inst_query
5352: ,p_instcolnm_set => l_instcolnm_set

Line 5349: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_instance'

5345: ben_cache.write_mastDet_Cache
5346: (p_mastercol_name => 'vrbl_rt_prfl_id'
5347: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5348: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_lookup'
5349: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_instance'
5350: ,p_lkup_query => l_lookup_query
5351: ,p_inst_query => l_inst_query
5352: ,p_instcolnm_set => l_instcolnm_set
5353: );

Line 5361: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_lookup'

5357: -- Cache already populated. Get record set.
5358: --
5359: get_cached_data
5360: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5361: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_lookup'
5362: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_instance'
5363: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_inst_tbl'
5364: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_out'
5365: );

Line 5362: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_instance'

5358: --
5359: get_cached_data
5360: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5361: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_lookup'
5362: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_instance'
5363: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_inst_tbl'
5364: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_out'
5365: );
5366: --

Line 5363: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_inst_tbl'

5359: get_cached_data
5360: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5361: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_lookup'
5362: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_instance'
5363: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_inst_tbl'
5364: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_out'
5365: );
5366: --
5367: p_inst_set := g_enrld_anthr_ptip_out;

Line 5364: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_out'

5360: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5361: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_lookup'
5362: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_instance'
5363: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_inst_tbl'
5364: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_out'
5365: );
5366: --
5367: p_inst_set := g_enrld_anthr_ptip_out;
5368: p_inst_count := g_inst_count;

Line 5389: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_enrld_anthr_pgm_inst_tbl

5385: (p_vrbl_rt_prfl_id in number
5386: ,p_effective_date in date
5387: ,p_lf_evt_ocrd_dt in date
5388: ,p_business_group_id in number
5389: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_enrld_anthr_pgm_inst_tbl
5390: ,p_inst_count out nocopy number) as
5391: --
5392: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
5393: l_lookup_query long;

Line 5442: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_lookup'

5438: --
5439: ben_cache.write_mastDet_Cache
5440: (p_mastercol_name => 'vrbl_rt_prfl_id'
5441: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5442: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_lookup'
5443: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_instance'
5444: ,p_lkup_query => l_lookup_query
5445: ,p_inst_query => l_inst_query
5446: ,p_instcolnm_set => l_instcolnm_set

Line 5443: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_instance'

5439: ben_cache.write_mastDet_Cache
5440: (p_mastercol_name => 'vrbl_rt_prfl_id'
5441: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5442: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_lookup'
5443: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_instance'
5444: ,p_lkup_query => l_lookup_query
5445: ,p_inst_query => l_inst_query
5446: ,p_instcolnm_set => l_instcolnm_set
5447: );

Line 5455: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_lookup'

5451: -- Cache already populated. Get record set.
5452: --
5453: get_cached_data
5454: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5455: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_lookup'
5456: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_instance'
5457: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_inst_tbl'
5458: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_out'
5459: );

Line 5456: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_instance'

5452: --
5453: get_cached_data
5454: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5455: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_lookup'
5456: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_instance'
5457: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_inst_tbl'
5458: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_out'
5459: );
5460: --

Line 5457: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_inst_tbl'

5453: get_cached_data
5454: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5455: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_lookup'
5456: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_instance'
5457: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_inst_tbl'
5458: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_out'
5459: );
5460: --
5461: p_inst_set := g_enrld_anthr_pgm_out;

Line 5458: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_out'

5454: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5455: ,p_lookup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_lookup'
5456: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_instance'
5457: ,p_inst_set_type => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_inst_tbl'
5458: ,p_out_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_out'
5459: );
5460: --
5461: p_inst_set := g_enrld_anthr_pgm_out;
5462: p_inst_count := g_inst_count;

Line 5483: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_dpnt_othr_ptip_inst_tbl

5479: (p_vrbl_rt_prfl_id in number
5480: ,p_effective_date in date
5481: ,p_lf_evt_ocrd_dt in date
5482: ,p_business_group_id in number
5483: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_dpnt_othr_ptip_inst_tbl
5484: ,p_inst_count out nocopy number) as
5485: --
5486: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
5487: l_lookup_query long;

Line 5534: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_lookup'

5530: --
5531: ben_cache.write_mastDet_Cache
5532: (p_mastercol_name => 'vrbl_rt_prfl_id'
5533: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5534: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_lookup'
5535: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_instance'
5536: ,p_lkup_query => l_lookup_query
5537: ,p_inst_query => l_inst_query
5538: ,p_instcolnm_set => l_instcolnm_set

Line 5535: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_instance'

5531: ben_cache.write_mastDet_Cache
5532: (p_mastercol_name => 'vrbl_rt_prfl_id'
5533: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5534: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_lookup'
5535: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_instance'
5536: ,p_lkup_query => l_lookup_query
5537: ,p_inst_query => l_inst_query
5538: ,p_instcolnm_set => l_instcolnm_set
5539: );

Line 5547: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_lookup'

5543: -- Cache already populated. Get record set.
5544: --
5545: get_cached_data
5546: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5547: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_lookup'
5548: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_instance'
5549: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_inst_tbl'
5550: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_out'
5551: );

Line 5548: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_instance'

5544: --
5545: get_cached_data
5546: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5547: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_lookup'
5548: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_instance'
5549: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_inst_tbl'
5550: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_out'
5551: );
5552: --

Line 5549: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_inst_tbl'

5545: get_cached_data
5546: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5547: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_lookup'
5548: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_instance'
5549: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_inst_tbl'
5550: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_out'
5551: );
5552: --
5553: p_inst_set := g_dpnt_othr_ptip_out;

Line 5550: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_out'

5546: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5547: ,p_lookup_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_lookup'
5548: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_instance'
5549: ,p_inst_set_type => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_inst_tbl'
5550: ,p_out_inst_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_out'
5551: );
5552: --
5553: p_inst_set := g_dpnt_othr_ptip_out;
5554: p_inst_count := g_inst_count;

Line 5574: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_no_othr_cvg_inst_tbl

5570: (p_vrbl_rt_prfl_id in number
5571: ,p_effective_date in date
5572: ,p_lf_evt_ocrd_dt in date
5573: ,p_business_group_id in number
5574: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_no_othr_cvg_inst_tbl
5575: ,p_inst_count out nocopy number) as
5576: --
5577: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
5578: l_lookup_query long;

Line 5621: ,p_lkup_name => 'ben_rt_prfl_cache.g_no_othr_cvg_lookup'

5617: --
5618: ben_cache.write_mastDet_Cache
5619: (p_mastercol_name => 'vrbl_rt_prfl_id'
5620: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5621: ,p_lkup_name => 'ben_rt_prfl_cache.g_no_othr_cvg_lookup'
5622: ,p_inst_name => 'ben_rt_prfl_cache.g_no_othr_cvg_instance'
5623: ,p_lkup_query => l_lookup_query
5624: ,p_inst_query => l_inst_query
5625: ,p_instcolnm_set => l_instcolnm_set

Line 5622: ,p_inst_name => 'ben_rt_prfl_cache.g_no_othr_cvg_instance'

5618: ben_cache.write_mastDet_Cache
5619: (p_mastercol_name => 'vrbl_rt_prfl_id'
5620: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5621: ,p_lkup_name => 'ben_rt_prfl_cache.g_no_othr_cvg_lookup'
5622: ,p_inst_name => 'ben_rt_prfl_cache.g_no_othr_cvg_instance'
5623: ,p_lkup_query => l_lookup_query
5624: ,p_inst_query => l_inst_query
5625: ,p_instcolnm_set => l_instcolnm_set
5626: );

Line 5634: ,p_lookup_name => 'ben_rt_prfl_cache.g_no_othr_cvg_lookup'

5630: -- Cache already populated. Get record set.
5631: --
5632: get_cached_data
5633: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5634: ,p_lookup_name => 'ben_rt_prfl_cache.g_no_othr_cvg_lookup'
5635: ,p_inst_name => 'ben_rt_prfl_cache.g_no_othr_cvg_instance'
5636: ,p_inst_set_type => 'ben_rt_prfl_cache.g_no_othr_cvg_inst_tbl'
5637: ,p_out_inst_name => 'ben_rt_prfl_cache.g_no_othr_cvg_out'
5638: );

Line 5635: ,p_inst_name => 'ben_rt_prfl_cache.g_no_othr_cvg_instance'

5631: --
5632: get_cached_data
5633: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5634: ,p_lookup_name => 'ben_rt_prfl_cache.g_no_othr_cvg_lookup'
5635: ,p_inst_name => 'ben_rt_prfl_cache.g_no_othr_cvg_instance'
5636: ,p_inst_set_type => 'ben_rt_prfl_cache.g_no_othr_cvg_inst_tbl'
5637: ,p_out_inst_name => 'ben_rt_prfl_cache.g_no_othr_cvg_out'
5638: );
5639: --

Line 5636: ,p_inst_set_type => 'ben_rt_prfl_cache.g_no_othr_cvg_inst_tbl'

5632: get_cached_data
5633: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5634: ,p_lookup_name => 'ben_rt_prfl_cache.g_no_othr_cvg_lookup'
5635: ,p_inst_name => 'ben_rt_prfl_cache.g_no_othr_cvg_instance'
5636: ,p_inst_set_type => 'ben_rt_prfl_cache.g_no_othr_cvg_inst_tbl'
5637: ,p_out_inst_name => 'ben_rt_prfl_cache.g_no_othr_cvg_out'
5638: );
5639: --
5640: p_inst_set := g_no_othr_cvg_out;

Line 5637: ,p_out_inst_name => 'ben_rt_prfl_cache.g_no_othr_cvg_out'

5633: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5634: ,p_lookup_name => 'ben_rt_prfl_cache.g_no_othr_cvg_lookup'
5635: ,p_inst_name => 'ben_rt_prfl_cache.g_no_othr_cvg_instance'
5636: ,p_inst_set_type => 'ben_rt_prfl_cache.g_no_othr_cvg_inst_tbl'
5637: ,p_out_inst_name => 'ben_rt_prfl_cache.g_no_othr_cvg_out'
5638: );
5639: --
5640: p_inst_set := g_no_othr_cvg_out;
5641: p_inst_count := g_inst_count;

Line 5661: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_qua_in_gr_inst_tbl

5657: (p_vrbl_rt_prfl_id in number
5658: ,p_effective_date in date
5659: ,p_lf_evt_ocrd_dt in date
5660: ,p_business_group_id in number
5661: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_qua_in_gr_inst_tbl
5662: ,p_inst_count out nocopy number)
5663: is
5664: --
5665: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 5710: ,p_lkup_name => 'ben_rt_prfl_cache.g_qua_in_gr_lookup'

5706: --
5707: ben_cache.write_mastDet_Cache
5708: (p_mastercol_name => 'vrbl_rt_prfl_id'
5709: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5710: ,p_lkup_name => 'ben_rt_prfl_cache.g_qua_in_gr_lookup'
5711: ,p_inst_name => 'ben_rt_prfl_cache.g_qua_in_gr_instance'
5712: ,p_lkup_query => l_lookup_query
5713: ,p_inst_query => l_inst_query
5714: ,p_instcolnm_set => l_instcolnm_set

Line 5711: ,p_inst_name => 'ben_rt_prfl_cache.g_qua_in_gr_instance'

5707: ben_cache.write_mastDet_Cache
5708: (p_mastercol_name => 'vrbl_rt_prfl_id'
5709: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5710: ,p_lkup_name => 'ben_rt_prfl_cache.g_qua_in_gr_lookup'
5711: ,p_inst_name => 'ben_rt_prfl_cache.g_qua_in_gr_instance'
5712: ,p_lkup_query => l_lookup_query
5713: ,p_inst_query => l_inst_query
5714: ,p_instcolnm_set => l_instcolnm_set
5715: );

Line 5723: ,p_lookup_name => 'ben_rt_prfl_cache.g_qua_in_gr_lookup'

5719: -- Cache already populated. Get record set.
5720: --
5721: get_cached_data
5722: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5723: ,p_lookup_name => 'ben_rt_prfl_cache.g_qua_in_gr_lookup'
5724: ,p_inst_name => 'ben_rt_prfl_cache.g_qua_in_gr_instance'
5725: ,p_inst_set_type => 'ben_rt_prfl_cache.g_qua_in_gr_inst_tbl'
5726: ,p_out_inst_name => 'ben_rt_prfl_cache.g_qua_in_gr_out'
5727: );

Line 5724: ,p_inst_name => 'ben_rt_prfl_cache.g_qua_in_gr_instance'

5720: --
5721: get_cached_data
5722: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5723: ,p_lookup_name => 'ben_rt_prfl_cache.g_qua_in_gr_lookup'
5724: ,p_inst_name => 'ben_rt_prfl_cache.g_qua_in_gr_instance'
5725: ,p_inst_set_type => 'ben_rt_prfl_cache.g_qua_in_gr_inst_tbl'
5726: ,p_out_inst_name => 'ben_rt_prfl_cache.g_qua_in_gr_out'
5727: );
5728: --

Line 5725: ,p_inst_set_type => 'ben_rt_prfl_cache.g_qua_in_gr_inst_tbl'

5721: get_cached_data
5722: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5723: ,p_lookup_name => 'ben_rt_prfl_cache.g_qua_in_gr_lookup'
5724: ,p_inst_name => 'ben_rt_prfl_cache.g_qua_in_gr_instance'
5725: ,p_inst_set_type => 'ben_rt_prfl_cache.g_qua_in_gr_inst_tbl'
5726: ,p_out_inst_name => 'ben_rt_prfl_cache.g_qua_in_gr_out'
5727: );
5728: --
5729: p_inst_set := g_qua_in_gr_out;

Line 5726: ,p_out_inst_name => 'ben_rt_prfl_cache.g_qua_in_gr_out'

5722: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5723: ,p_lookup_name => 'ben_rt_prfl_cache.g_qua_in_gr_lookup'
5724: ,p_inst_name => 'ben_rt_prfl_cache.g_qua_in_gr_instance'
5725: ,p_inst_set_type => 'ben_rt_prfl_cache.g_qua_in_gr_inst_tbl'
5726: ,p_out_inst_name => 'ben_rt_prfl_cache.g_qua_in_gr_out'
5727: );
5728: --
5729: p_inst_set := g_qua_in_gr_out;
5730: p_inst_count := g_inst_count;

Line 5750: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_perf_rtng_inst_tbl

5746: (p_vrbl_rt_prfl_id in number
5747: ,p_effective_date in date
5748: ,p_lf_evt_ocrd_dt in date
5749: ,p_business_group_id in number
5750: ,p_inst_set in out NOCOPY ben_rt_prfl_cache.g_perf_rtng_inst_tbl
5751: ,p_inst_count out nocopy number)
5752: is
5753: --
5754: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';

Line 5802: ,p_lkup_name => 'ben_rt_prfl_cache.g_perf_rtng_lookup'

5798: --
5799: ben_cache.write_mastDet_Cache
5800: (p_mastercol_name => 'vrbl_rt_prfl_id'
5801: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5802: ,p_lkup_name => 'ben_rt_prfl_cache.g_perf_rtng_lookup'
5803: ,p_inst_name => 'ben_rt_prfl_cache.g_perf_rtng_instance'
5804: ,p_lkup_query => l_lookup_query
5805: ,p_inst_query => l_inst_query
5806: ,p_instcolnm_set => l_instcolnm_set

Line 5803: ,p_inst_name => 'ben_rt_prfl_cache.g_perf_rtng_instance'

5799: ben_cache.write_mastDet_Cache
5800: (p_mastercol_name => 'vrbl_rt_prfl_id'
5801: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5802: ,p_lkup_name => 'ben_rt_prfl_cache.g_perf_rtng_lookup'
5803: ,p_inst_name => 'ben_rt_prfl_cache.g_perf_rtng_instance'
5804: ,p_lkup_query => l_lookup_query
5805: ,p_inst_query => l_inst_query
5806: ,p_instcolnm_set => l_instcolnm_set
5807: );

Line 5815: ,p_lookup_name => 'ben_rt_prfl_cache.g_perf_rtng_lookup'

5811: -- Cache already populated. Get record set.
5812: --
5813: get_cached_data
5814: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5815: ,p_lookup_name => 'ben_rt_prfl_cache.g_perf_rtng_lookup'
5816: ,p_inst_name => 'ben_rt_prfl_cache.g_perf_rtng_instance'
5817: ,p_inst_set_type => 'ben_rt_prfl_cache.g_perf_rtng_inst_tbl'
5818: ,p_out_inst_name => 'ben_rt_prfl_cache.g_perf_rtng_out'
5819: );

Line 5816: ,p_inst_name => 'ben_rt_prfl_cache.g_perf_rtng_instance'

5812: --
5813: get_cached_data
5814: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5815: ,p_lookup_name => 'ben_rt_prfl_cache.g_perf_rtng_lookup'
5816: ,p_inst_name => 'ben_rt_prfl_cache.g_perf_rtng_instance'
5817: ,p_inst_set_type => 'ben_rt_prfl_cache.g_perf_rtng_inst_tbl'
5818: ,p_out_inst_name => 'ben_rt_prfl_cache.g_perf_rtng_out'
5819: );
5820: --

Line 5817: ,p_inst_set_type => 'ben_rt_prfl_cache.g_perf_rtng_inst_tbl'

5813: get_cached_data
5814: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5815: ,p_lookup_name => 'ben_rt_prfl_cache.g_perf_rtng_lookup'
5816: ,p_inst_name => 'ben_rt_prfl_cache.g_perf_rtng_instance'
5817: ,p_inst_set_type => 'ben_rt_prfl_cache.g_perf_rtng_inst_tbl'
5818: ,p_out_inst_name => 'ben_rt_prfl_cache.g_perf_rtng_out'
5819: );
5820: --
5821: p_inst_set := g_perf_rtng_out;

Line 5818: ,p_out_inst_name => 'ben_rt_prfl_cache.g_perf_rtng_out'

5814: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
5815: ,p_lookup_name => 'ben_rt_prfl_cache.g_perf_rtng_lookup'
5816: ,p_inst_name => 'ben_rt_prfl_cache.g_perf_rtng_instance'
5817: ,p_inst_set_type => 'ben_rt_prfl_cache.g_perf_rtng_inst_tbl'
5818: ,p_out_inst_name => 'ben_rt_prfl_cache.g_perf_rtng_out'
5819: );
5820: --
5821: p_inst_set := g_perf_rtng_out;
5822: p_inst_count := g_inst_count;

Line 5974: end ben_rt_prfl_cache;

5970: --End Bug 6412287
5971:
5972: end clear_down_cache;
5973: --
5974: end ben_rt_prfl_cache;