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_CEL_CACHE dependencies on BEN_CEL_CACHE

Line 1: package body ben_cel_cache as

1: package body ben_cel_cache as
2: /* $Header: bencelch.pkb 115.9 2002/12/24 15:44:13 bmanyam ship $ */
3: --
4: g_package varchar2(50) := 'ben_cel_cache.';
5: --

Line 4: g_package varchar2(50) := 'ben_cel_cache.';

1: package body ben_cel_cache as
2: /* $Header: bencelch.pkb 115.9 2002/12/24 15:44:13 bmanyam ship $ */
3: --
4: g_package varchar2(50) := 'ben_cel_cache.';
5: --
6: --
7: -- Hand coded
8: --

Line 12: g_cache_plnelp_inst ben_cel_cache.g_cache_cepelp_instor;

8: --
9: -- plan participating eligibility profile by plan
10: --
11: g_cache_plnelp_lookup ben_cache.g_cache_lookup_table;
12: g_cache_plnelp_inst ben_cel_cache.g_cache_cepelp_instor;
13: --
14: -- program participating eligibility profile by program
15: --
16: g_cache_pgmelp_lookup ben_cache.g_cache_lookup_table;

Line 17: g_cache_pgmelp_inst ben_cel_cache.g_cache_cepelp_instor;

13: --
14: -- program participating eligibility profile by program
15: --
16: g_cache_pgmelp_lookup ben_cache.g_cache_lookup_table;
17: g_cache_pgmelp_inst ben_cel_cache.g_cache_cepelp_instor;
18: --
19: -- oipl participating eligibility profile by oipl
20: --
21: g_cache_copelp_lookup ben_cache.g_cache_lookup_table;

Line 22: g_cache_copelp_inst ben_cel_cache.g_cache_cepelp_instor;

18: --
19: -- oipl participating eligibility profile by oipl
20: --
21: g_cache_copelp_lookup ben_cache.g_cache_lookup_table;
22: g_cache_copelp_inst ben_cel_cache.g_cache_cepelp_instor;
23: --
24: -- plip participating eligibility profile by plip
25: --
26: g_cache_cppelp_lookup ben_cache.g_cache_lookup_table;

Line 27: g_cache_cppelp_inst ben_cel_cache.g_cache_cepelp_instor;

23: --
24: -- plip participating eligibility profile by plip
25: --
26: g_cache_cppelp_lookup ben_cache.g_cache_lookup_table;
27: g_cache_cppelp_inst ben_cel_cache.g_cache_cepelp_instor;
28: --
29: -- ptip participating eligibility profile by ptip
30: --
31: g_cache_ctpelp_lookup ben_cache.g_cache_lookup_table;

Line 32: g_cache_ctpelp_inst ben_cel_cache.g_cache_cepelp_instor;

28: --
29: -- ptip participating eligibility profile by ptip
30: --
31: g_cache_ctpelp_lookup ben_cache.g_cache_lookup_table;
32: g_cache_ctpelp_inst ben_cel_cache.g_cache_cepelp_instor;
33: --
34: procedure plnelp_writecache
35: (p_effective_date in date,
36: p_refresh_cache in boolean default FALSE) is

Line 213: p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,

209: (p_effective_date in date,
210: p_business_group_id in number,
211: p_pl_id in number,
212: p_refresh_cache in boolean default FALSE,
213: p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,
214: p_inst_count out nocopy number) is
215: --
216: l_proc varchar2(72) := g_package||'plnelp_getcacdets';
217: l_torrwnum binary_integer;

Line 239: ben_cel_cache.plnelp_writecache

235: if g_cache_plnelp_lookup.count = 0 then
236: --
237: -- Build the cache
238: --
239: ben_cel_cache.plnelp_writecache
240: (p_effective_date => p_effective_date,
241: p_refresh_cache => p_refresh_cache);
242: --
243: end if;

Line 485: p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,

481: (p_effective_date in date,
482: p_business_group_id in number,
483: p_pgm_id in number,
484: p_refresh_cache in boolean default FALSE,
485: p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,
486: p_inst_count out nocopy number) is
487: --
488: l_proc varchar2(72) := g_package||'pgmelp_getcacdets';
489: l_torrwnum binary_integer;

Line 511: ben_cel_cache.pgmelp_writecache

507: if g_cache_pgmelp_lookup.count = 0 then
508: --
509: -- Build the cache
510: --
511: ben_cel_cache.pgmelp_writecache
512: (p_effective_date => p_effective_date,
513: p_refresh_cache => p_refresh_cache);
514: --
515: end if;

Line 757: p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,

753: (p_effective_date in date,
754: p_business_group_id in number,
755: p_oipl_id in number,
756: p_refresh_cache in boolean default FALSE,
757: p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,
758: p_inst_count out nocopy number) is
759: --
760: l_proc varchar2(72) := g_package||'copelp_getcacdets';
761: l_torrwnum binary_integer;

Line 783: ben_cel_cache.copelp_writecache

779: if g_cache_copelp_lookup.count = 0 then
780: --
781: -- Build the cache
782: --
783: ben_cel_cache.copelp_writecache
784: (p_effective_date => p_effective_date,
785: p_refresh_cache => p_refresh_cache);
786: --
787: end if;

Line 1029: p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,

1025: (p_effective_date in date,
1026: p_business_group_id in number,
1027: p_plip_id in number,
1028: p_refresh_cache in boolean default FALSE,
1029: p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,
1030: p_inst_count out nocopy number) is
1031: --
1032: l_proc varchar2(72) := g_package||'cppelp_getcacdets';
1033: l_torrwnum binary_integer;

Line 1055: ben_cel_cache.cppelp_writecache

1051: if g_cache_cppelp_lookup.count = 0 then
1052: --
1053: -- Build the cache
1054: --
1055: ben_cel_cache.cppelp_writecache
1056: (p_effective_date => p_effective_date,
1057: p_refresh_cache => p_refresh_cache);
1058: --
1059: end if;

Line 1301: p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,

1297: (p_effective_date in date,
1298: p_business_group_id in number,
1299: p_ptip_id in number,
1300: p_refresh_cache in boolean default FALSE,
1301: p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,
1302: p_inst_count out nocopy number) is
1303: --
1304: l_proc varchar2(72) := g_package||'ctpelp_getcacdets';
1305: l_torrwnum binary_integer;

Line 1327: ben_cel_cache.ctpelp_writecache

1323: if g_cache_ctpelp_lookup.count = 0 then
1324: --
1325: -- Build the cache
1326: --
1327: ben_cel_cache.ctpelp_writecache
1328: (p_effective_date => p_effective_date,
1329: p_refresh_cache => p_refresh_cache);
1330: --
1331: end if;

Line 1403: p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,

1399: p_oipl_id in number,
1400: p_plip_id in number,
1401: p_ptip_id in number,
1402: p_refresh_cache in boolean default FALSE,
1403: p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,
1404: p_inst_count out nocopy number) is
1405: --
1406: l_proc varchar2(72) := g_package||'cepelp_getdets';
1407: --

Line 1420: ben_cel_cache.plnelp_getcacdets

1416: p_oipl_id is null then
1417: --
1418: -- PLNELP
1419: --
1420: ben_cel_cache.plnelp_getcacdets
1421: (p_effective_date => p_effective_date,
1422: p_business_group_id => p_business_group_id,
1423: p_pl_id => p_pl_id,
1424: p_inst_set => p_inst_set,

Line 1435: ben_cel_cache.pgmelp_getcacdets

1431: p_oipl_id is null then
1432: --
1433: -- PGMELP
1434: --
1435: ben_cel_cache.pgmelp_getcacdets
1436: (p_effective_date => p_effective_date,
1437: p_business_group_id => p_business_group_id,
1438: p_pgm_id => p_pgm_id,
1439: p_inst_set => p_inst_set,

Line 1450: ben_cel_cache.copelp_getcacdets

1446: p_oipl_id is not null then
1447: --
1448: -- COPELP
1449: --
1450: ben_cel_cache.copelp_getcacdets
1451: (p_effective_date => p_effective_date,
1452: p_business_group_id => p_business_group_id,
1453: p_oipl_id => p_oipl_id,
1454: p_inst_set => p_inst_set,

Line 1465: ben_cel_cache.cppelp_getcacdets

1461: p_oipl_id is null then
1462: --
1463: -- CPPELP
1464: --
1465: ben_cel_cache.cppelp_getcacdets
1466: (p_effective_date => p_effective_date,
1467: p_business_group_id => p_business_group_id,
1468: p_plip_id => p_plip_id,
1469: p_inst_set => p_inst_set,

Line 1480: ben_cel_cache.ctpelp_getcacdets

1476: p_oipl_id is null then
1477: --
1478: -- CPPELP
1479: --
1480: ben_cel_cache.ctpelp_getcacdets
1481: (p_effective_date => p_effective_date,
1482: p_business_group_id => p_business_group_id,
1483: p_ptip_id => p_ptip_id,
1484: p_inst_set => p_inst_set,

Line 1508: end ben_cel_cache;

1504: g_cache_ctpelp_inst.delete;
1505: --
1506: end clear_down_cache;
1507: --
1508: end ben_cel_cache;