DBA Data[Home] [Help]

APPS.BEN_ELIG_OBJECT dependencies on BEN_PRTN_ELIG_F

Line 21: 07 May 99 G Perry 115.3 Added cache for ben_prtn_elig_f

17: ---- --- ------- -----
18: 05 May 99 G Perry 115.0 Created
19: 06 May 99 G Perry 115.1 Backport for Fidelity.
20: 06 May 99 G Perry 115.2 Leapfrog of 115.0
21: 07 May 99 G Perry 115.3 Added cache for ben_prtn_elig_f
22: for Bala.
23: 07 May 99 G Perry 115.4 Fixed typos in PTIP call.
24: 25 May 99 G Perry 115.5 Added context to messages.
25: 11-Jul-99 mhoyes 115.6 - Removed + 0s from all cursors.

Line 282: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is

278: --
279: end set_object;
280: --
281: procedure set_object(p_pgm_id in number,
282: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is
283: --
284: l_proc varchar2(80) := g_package||'set_object pgmpel';
285: l_index pls_integer;
286: --l_not_hash_found boolean;

Line 330: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is

326: --
327: end set_object;
328: --
329: procedure set_object(p_pl_id in number,
330: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is
331: --
332: l_proc varchar2(80) := g_package||'set_object plnpel';
333: l_index pls_integer;
334: --l_not_hash_found boolean;

Line 377: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is

373: --
374: end set_object;
375: --
376: procedure set_object(p_oipl_id in number,
377: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is
378: --
379: l_proc varchar2(80) := g_package||'set_object oiplpel';
380: l_index pls_integer;
381: --l_not_hash_found boolean;

Line 424: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is

420: --
421: end set_object;
422: --
423: procedure set_object(p_plip_id in number,
424: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is
425: --
426: l_proc varchar2(80) := g_package||'set_object plippel';
427: l_index pls_integer;
428: --l_not_hash_found boolean;

Line 470: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is

466: --
467: end set_object;
468: --
469: procedure set_object(p_ptip_id in number,
470: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is
471: --
472: l_proc varchar2(80) := g_package||'set_object ptippel';
473: l_index pls_integer;
474: --l_not_hash_found boolean;

Line 718: from ben_prtn_elig_f epa

714: l_proc varchar2(80) := g_package||'set_object pln';
715: --
716: cursor c1 is
717: select epa.*
718: from ben_prtn_elig_f epa
719: where epa.business_group_id = p_business_group_id
720: and epa.pl_id = p_pl_id
721: and p_effective_date
722: between epa.effective_start_date

Line 725: l_rec ben_prtn_elig_f%rowtype;

721: and p_effective_date
722: between epa.effective_start_date
723: and epa.effective_end_date;
724: --
725: l_rec ben_prtn_elig_f%rowtype;
726: --
727: begin
728: --
729: open c1;

Line 750: from ben_prtn_elig_f epa

746: l_proc varchar2(80) := g_package||'set_object pgm';
747: --
748: cursor c1 is
749: select epa.*
750: from ben_prtn_elig_f epa
751: where epa.business_group_id = p_business_group_id
752: and epa.pgm_id = p_pgm_id
753: and p_effective_date
754: between epa.effective_start_date

Line 757: l_rec ben_prtn_elig_f%rowtype;

753: and p_effective_date
754: between epa.effective_start_date
755: and epa.effective_end_date;
756: --
757: l_rec ben_prtn_elig_f%rowtype;
758: --
759: begin
760: --
761: -- hr_utility.set_location('Entering '||l_proc,10);

Line 786: from ben_prtn_elig_f epa

782: l_proc varchar2(80) := g_package||'set_object oipl';
783: --
784: cursor c1 is
785: select epa.*
786: from ben_prtn_elig_f epa
787: where epa.business_group_id = p_business_group_id
788: and epa.oipl_id = p_oipl_id
789: and p_effective_date
790: between epa.effective_start_date

Line 793: l_rec ben_prtn_elig_f%rowtype;

789: and p_effective_date
790: between epa.effective_start_date
791: and epa.effective_end_date;
792: --
793: l_rec ben_prtn_elig_f%rowtype;
794: --
795: begin
796: --
797: open c1;

Line 818: from ben_prtn_elig_f epa

814: l_proc varchar2(80) := g_package||'set_object plip';
815: --
816: cursor c1 is
817: select epa.*
818: from ben_prtn_elig_f epa
819: where epa.business_group_id = p_business_group_id
820: and epa.plip_id = p_plip_id
821: and p_effective_date
822: between epa.effective_start_date

Line 825: l_rec ben_prtn_elig_f%rowtype;

821: and p_effective_date
822: between epa.effective_start_date
823: and epa.effective_end_date;
824: --
825: l_rec ben_prtn_elig_f%rowtype;
826: --
827: begin
828: --
829: open c1;

Line 850: from ben_prtn_elig_f epa

846: l_proc varchar2(80) := g_package||'set_object ptip';
847: --
848: cursor c1 is
849: select epa.*
850: from ben_prtn_elig_f epa
851: where epa.business_group_id = p_business_group_id
852: and epa.ptip_id = p_ptip_id
853: and p_effective_date
854: between epa.effective_start_date

Line 857: l_rec ben_prtn_elig_f%rowtype;

853: and p_effective_date
854: between epa.effective_start_date
855: and epa.effective_end_date;
856: --
857: l_rec ben_prtn_elig_f%rowtype;
858: --
859: begin
860: --
861: open c1;

Line 1197: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is

1193: --
1194: end get_object;
1195: --
1196: procedure get_object(p_pgm_id in number,
1197: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is
1198: --
1199: l_proc varchar2(80) := g_package||'get_object pgmpel';
1200: --
1201: l_env ben_env_object.g_global_env_rec_type;

Line 1261: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is

1257: --
1258: end get_object;
1259: --
1260: procedure get_object(p_pl_id in number,
1261: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is
1262: --
1263: l_proc varchar2(80) := g_package||'get_object plnpel';
1264: --
1265: l_env ben_env_object.g_global_env_rec_type;

Line 1325: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is

1321: --
1322: end get_object;
1323: --
1324: procedure get_object(p_oipl_id in number,
1325: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is
1326: --
1327: l_proc varchar2(80) := g_package||'get_object oiplpel';
1328: --
1329: l_env ben_env_object.g_global_env_rec_type;

Line 1388: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is

1384: --
1385: end get_object;
1386: --
1387: procedure get_object(p_plip_id in number,
1388: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is
1389: --
1390: l_proc varchar2(80) := g_package||'get_object plippel';
1391: --
1392: l_env ben_env_object.g_global_env_rec_type;

Line 1452: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is

1448: --
1449: end get_object;
1450: --
1451: procedure get_object(p_ptip_id in number,
1452: p_rec in out NOCOPY ben_prtn_elig_f%rowtype) is
1453: --
1454: l_proc varchar2(80) := g_package||'get_object ptippel';
1455: --
1456: l_env ben_env_object.g_global_env_rec_type;