APPS.BEN_CVG_CACHE dependencies on BEN_CVG_CACHE

Line 1: package body ben_cvg_cache as

1: package body ben_cvg_cache as
2: /* $Header: bencvgch.pkb 120.3 2006/01/27 01:56:28 rtagarra noship $ */
3: --
4: g_package varchar2(50) := 'ben_cvg_cache.';
5: --

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

1: package body ben_cvg_cache as
2: /* $Header: bencvgch.pkb 120.3 2006/01/27 01:56:28 rtagarra noship $ */
3: --
4: g_package varchar2(50) := 'ben_cvg_cache.';
5: --
6: procedure epeplncvg_getdets
7: (p_epe_id in number
8: ,p_epe_pl_id in number

Line 14: ,p_inst_set out nocopy ben_cvg_cache.g_epeplncvg_cache

10: ,p_epe_oipl_id in number
11: ,p_effective_date in date
12: ,p_cvgtype_code in varchar2
13: --
14: ,p_inst_set out nocopy ben_cvg_cache.g_epeplncvg_cache
15: ,p_inst_count out nocopy number
16: )
17: is
18: --

Line 32: ben_cvg_cache.cppplncvg_getdets

28: begin
29: --
30: if p_cvgtype_code = 'CPP' then
31: --
32: ben_cvg_cache.cppplncvg_getdets
33: (p_plip_id => p_epe_plip_id
34: ,p_effective_date => p_effective_date
35: --
36: ,p_inst_set => p_inst_set

Line 44: ben_cvg_cache.plnplncvg_getdets

40: elsif p_cvgtype_code = 'PLN' then
41: --
42: -- Get the PLNCVG details
43: --
44: ben_cvg_cache.plnplncvg_getdets
45: (p_pln_id => p_epe_pl_id
46: ,p_effective_date => p_effective_date
47: --
48: ,p_inst_set => p_inst_set

Line 54: ben_cvg_cache.copplncvg_getdets

50: );
51: --
52: elsif p_cvgtype_code = 'COP' then
53: --
54: ben_cvg_cache.copplncvg_getdets
55: (p_oipl_id => p_epe_oipl_id
56: ,p_effective_date => p_effective_date
57: --
58: ,p_inst_set => p_inst_set

Line 70: ,p_inst_set out nocopy ben_cvg_cache.g_epeplncvg_cache

66: procedure plnplncvg_getdets
67: (p_pln_id in number
68: ,p_effective_date in date
69: --
70: ,p_inst_set out nocopy ben_cvg_cache.g_epeplncvg_cache
71: ,p_inst_count out nocopy number
72: )
73: is
74: --

Line 143: ,p_inst_set out nocopy ben_cvg_cache.g_epeplncvg_cache

139: procedure cppplncvg_getdets
140: (p_plip_id in number
141: ,p_effective_date in date
142: --
143: ,p_inst_set out nocopy ben_cvg_cache.g_epeplncvg_cache
144: ,p_inst_count out nocopy number
145: )
146: is
147: --

Line 222: ,p_inst_set out nocopy ben_cvg_cache.g_epeplncvg_cache

218: procedure copplncvg_getdets
219: (p_oipl_id in number
220: ,p_effective_date in date
221: --
222: ,p_inst_set out nocopy ben_cvg_cache.g_epeplncvg_cache
223: ,p_inst_count out nocopy number
224: )
225: is
226: --

Line 303: ,p_cvg_set out nocopy ben_cvg_cache.g_epeplncvg_cache

299: ,p_epe_plip_id in number
300: ,p_epe_oipl_id in number
301: ,p_effective_date in date
302: --
303: ,p_cvg_set out nocopy ben_cvg_cache.g_epeplncvg_cache
304: )
305: is
306: --
307: l_proc varchar2(72) := g_package||'epecobjtree_getcvgdets';

Line 309: l_cvg ben_cvg_cache.g_epeplncvg_cache;

305: is
306: --
307: l_proc varchar2(72) := g_package||'epecobjtree_getcvgdets';
308: --
309: l_cvg ben_cvg_cache.g_epeplncvg_cache;
310: l_inst_count pls_integer;
311: --
312: begin
313: --

Line 317: ben_cvg_cache.epeplncvg_getdets

313: --
314:
315: -- Bug 4968171 - Query coverage details in this order : OIPL, PLN, PLIP
316: --
317: ben_cvg_cache.epeplncvg_getdets
318: (p_epe_id => p_epe_id
319: ,p_epe_pl_id => p_epe_pl_id
320: ,p_epe_plip_id => p_epe_plip_id
321: ,p_epe_oipl_id => p_epe_oipl_id

Line 332: ben_cvg_cache.epeplncvg_getdets

328: --
329: if l_cvg.count = 0
330: then
331: --
332: ben_cvg_cache.epeplncvg_getdets
333: (p_epe_id => p_epe_id
334: ,p_epe_pl_id => p_epe_pl_id
335: ,p_epe_plip_id => p_epe_plip_id
336: ,p_epe_oipl_id => p_epe_oipl_id

Line 347: ben_cvg_cache.epeplncvg_getdets

343: --
344: if l_cvg.count = 0
345: then
346: --
347: ben_cvg_cache.epeplncvg_getdets
348: (p_epe_id => p_epe_id
349: ,p_epe_pl_id => p_epe_pl_id
350: ,p_epe_plip_id => p_epe_plip_id
351: ,p_epe_oipl_id => p_epe_oipl_id

Line 369: end ben_cvg_cache;

365: p_cvg_set := l_cvg;
366: --
367: end epecobjtree_getcvgdets;
368: --
369: end ben_cvg_cache;