DBA Data[Home] [Help]

APPS.BEN_ELIG_OBJECT dependencies on BEN_ELIG_TO_PRTE_RSN_F

Line 48: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is

44: g_hash_key number := ben_hash_utility.get_hash_key;
45: g_hash_jump number := ben_hash_utility.get_hash_jump;
46: --
47: procedure set_object(p_pgm_id in number,
48: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is
49: --
50: l_proc varchar2(80) := g_package||'set_object pgmelpr';
51: l_index pls_integer;
52: --l_not_hash_found boolean;

Line 96: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is

92: --
93: end set_object;
94: --
95: procedure set_object(p_pl_id in number,
96: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is
97: --
98: l_proc varchar2(80) := g_package||'set_object plnelpr';
99: l_index pls_integer;
100: --l_not_hash_found boolean;

Line 143: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is

139: --
140: end set_object;
141: --
142: procedure set_object(p_oipl_id in number,
143: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is
144: --
145: l_proc varchar2(80) := g_package||'set_object oiplelpr';
146: l_index pls_integer;
147: --l_not_hash_found boolean;

Line 189: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is

185: --
186: end set_object;
187: --
188: procedure set_object(p_plip_id in number,
189: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is
190: --
191: l_proc varchar2(80) := g_package||'set_object plipelpr';
192: l_index pls_integer;
193: --l_not_hash_found boolean;

Line 236: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is

232: --
233: end set_object;
234: --
235: procedure set_object(p_ptip_id in number,
236: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is
237: --
238: l_proc varchar2(80) := g_package||'set_object ptipelpr';
239: l_index pls_integer;
240: --l_not_hash_found boolean;

Line 519: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype

515: procedure set_object(p_pl_id in number,
516: p_ler_id in number,
517: p_business_group_id in number,
518: p_effective_date in date,
519: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype
520: ) is
521: --
522: l_proc varchar2(80) := g_package||'set_object plnler';
523: --

Line 526: from ben_elig_to_prte_rsn_f peo

522: l_proc varchar2(80) := g_package||'set_object plnler';
523: --
524: cursor c1 is
525: select peo.*
526: from ben_elig_to_prte_rsn_f peo
527: where peo.business_group_id = p_business_group_id
528: and peo.ler_id = p_ler_id
529: and peo.pl_id = p_pl_id
530: and p_effective_date

Line 534: l_rec ben_elig_to_prte_rsn_f%rowtype;

530: and p_effective_date
531: between peo.effective_start_date
532: and peo.effective_end_date;
533: --
534: l_rec ben_elig_to_prte_rsn_f%rowtype;
535: --
536: begin
537: --
538: open c1;

Line 557: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype

553: procedure set_object(p_pgm_id in number,
554: p_ler_id in number,
555: p_business_group_id in number,
556: p_effective_date in date,
557: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype
558: )
559: is
560: --
561: l_proc varchar2(80) := g_package||'set_object pgmler';

Line 565: from ben_elig_to_prte_rsn_f peo

561: l_proc varchar2(80) := g_package||'set_object pgmler';
562: --
563: cursor c1 is
564: select peo.*
565: from ben_elig_to_prte_rsn_f peo
566: where peo.business_group_id = p_business_group_id
567: and peo.ler_id = p_ler_id
568: and peo.pgm_id = p_pgm_id
569: and p_effective_date

Line 573: l_rec ben_elig_to_prte_rsn_f%rowtype;

569: and p_effective_date
570: between peo.effective_start_date
571: and peo.effective_end_date;
572: --
573: l_rec ben_elig_to_prte_rsn_f%rowtype;
574: --
575: begin
576: --
577: -- hr_utility.set_location('Entering '||l_proc,10);

Line 600: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype

596: procedure set_object(p_oipl_id in number,
597: p_ler_id in number,
598: p_business_group_id in number,
599: p_effective_date in date,
600: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype
601: ) is
602: --
603: l_proc varchar2(80) := g_package||'set_object oipller';
604: --

Line 607: from ben_elig_to_prte_rsn_f peo

603: l_proc varchar2(80) := g_package||'set_object oipller';
604: --
605: cursor c1 is
606: select peo.*
607: from ben_elig_to_prte_rsn_f peo
608: where peo.business_group_id = p_business_group_id
609: and peo.ler_id = p_ler_id
610: and peo.oipl_id = p_oipl_id
611: and p_effective_date

Line 615: l_rec ben_elig_to_prte_rsn_f%rowtype;

611: and p_effective_date
612: between peo.effective_start_date
613: and peo.effective_end_date;
614: --
615: l_rec ben_elig_to_prte_rsn_f%rowtype;
616: --
617: begin
618: --
619: open c1;

Line 638: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype

634: procedure set_object(p_plip_id in number,
635: p_ler_id in number,
636: p_business_group_id in number,
637: p_effective_date in date,
638: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype
639: ) is
640: --
641: l_proc varchar2(80) := g_package||'set_object plipler';
642: --

Line 645: from ben_elig_to_prte_rsn_f peo

641: l_proc varchar2(80) := g_package||'set_object plipler';
642: --
643: cursor c1 is
644: select peo.*
645: from ben_elig_to_prte_rsn_f peo
646: where peo.business_group_id = p_business_group_id
647: and peo.ler_id = p_ler_id
648: and peo.plip_id = p_plip_id
649: and p_effective_date

Line 653: l_rec ben_elig_to_prte_rsn_f%rowtype;

649: and p_effective_date
650: between peo.effective_start_date
651: and peo.effective_end_date;
652: --
653: l_rec ben_elig_to_prte_rsn_f%rowtype;
654: --
655: begin
656: --
657: open c1;

Line 676: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype

672: procedure set_object(p_ptip_id in number,
673: p_ler_id in number,
674: p_business_group_id in number,
675: p_effective_date in date,
676: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype
677: ) is
678: --
679: l_proc varchar2(80) := g_package||'set_object ptipler';
680: --

Line 683: from ben_elig_to_prte_rsn_f peo

679: l_proc varchar2(80) := g_package||'set_object ptipler';
680: --
681: cursor c1 is
682: select peo.*
683: from ben_elig_to_prte_rsn_f peo
684: where peo.business_group_id = p_business_group_id
685: and peo.ler_id = p_ler_id
686: and peo.ptip_id = p_ptip_id
687: and p_effective_date

Line 691: l_rec ben_elig_to_prte_rsn_f%rowtype;

687: and p_effective_date
688: between peo.effective_start_date
689: and peo.effective_end_date;
690: --
691: l_rec ben_elig_to_prte_rsn_f%rowtype;
692: --
693: begin
694: --
695: open c1;

Line 878: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is

874: -- Get object routines
875: --
876: procedure get_object(p_pgm_id in number,
877: p_ler_id in number default null,
878: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is
879: --
880: l_proc varchar2(80) := g_package||'get_object pgmelpr';
881: --
882: l_env ben_env_object.g_global_env_rec_type;

Line 940: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is

936: end get_object;
937: --
938: procedure get_object(p_pl_id in number,
939: p_ler_id in number default null,
940: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is
941: --
942: l_proc varchar2(80) := g_package||'get_object plnelpr';
943: --
944: l_env ben_env_object.g_global_env_rec_type;

Line 1004: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is

1000: end get_object;
1001: --
1002: procedure get_object(p_oipl_id in number,
1003: p_ler_id in number default null,
1004: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is
1005: --
1006: l_proc varchar2(80) := g_package||'get_object oiplelpr';
1007: --
1008: l_env ben_env_object.g_global_env_rec_type;

Line 1070: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is

1066: end get_object;
1067: --
1068: procedure get_object(p_plip_id in number,
1069: p_ler_id in number default null,
1070: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is
1071: --
1072: l_proc varchar2(80) := g_package||'get_object plipelpr';
1073: --
1074: l_env ben_env_object.g_global_env_rec_type;

Line 1134: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is

1130: end get_object;
1131: --
1132: procedure get_object(p_ptip_id in number,
1133: p_ler_id in number default null,
1134: p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype) is
1135: --
1136: l_proc varchar2(80) := g_package||'get_object ptipelpr';
1137: --
1138: l_env ben_env_object.g_global_env_rec_type;