DBA Data[Home] [Help]

APPS.BEN_ORG_OBJECT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 74: procedure set_object(p_rec in out NOCOPY hr_all_organization_units%rowtype) is

70: g_cache_bus_rec(l_index):=p_rec;
71: --
72: end set_object;
73: --
74: procedure set_object(p_rec in out NOCOPY hr_all_organization_units%rowtype) is
75: --
76: l_proc varchar2(80) := g_package||'set_object';
77: l_index pls_integer;
78: --l_not_hash_found boolean;

Line 259: p_rec in out nocopy hr_all_organization_units%rowtype) is

255: --
256: procedure set_org_object
257: (p_organization_id in number,
258: p_effective_date in date,
259: p_rec in out nocopy hr_all_organization_units%rowtype) is
260: --
261: l_proc varchar2(80) := g_package||'set_org_object';
262: --
263: cursor c1 is

Line 265: from hr_all_organization_units org

261: l_proc varchar2(80) := g_package||'set_org_object';
262: --
263: cursor c1 is
264: select org.*
265: from hr_all_organization_units org
266: where org.organization_id = p_organization_id
267: and p_effective_date
268: between org.date_from
269: and nvl(org.date_to,p_effective_date);

Line 271: --l_rec hr_all_organization_units%rowtype;

267: and p_effective_date
268: between org.date_from
269: and nvl(org.date_to,p_effective_date);
270: --115.2 remove additional declaration
271: --l_rec hr_all_organization_units%rowtype;
272: --
273: begin
274: --
275: --hr_utility.set_location('Entering '||l_proc,10);

Line 462: p_rec in out nocopy hr_all_organization_units%rowtype) is

458: --
459: end get_object;
460: --
461: procedure get_object(p_organization_id in number,
462: p_rec in out nocopy hr_all_organization_units%rowtype) is
463: --
464: l_proc varchar2(80) := g_package||'get_object';
465: l_index pls_integer;
466: --l_not_hash_found boolean;

Line 468: --l_rec hr_all_organization_units%rowtype;

464: l_proc varchar2(80) := g_package||'get_object';
465: l_index pls_integer;
466: --l_not_hash_found boolean;
467: l_env ben_env_object.g_global_env_rec_type;
468: --l_rec hr_all_organization_units%rowtype;
469: --
470: begin
471: --
472: --hr_utility.set_location('Entering '||l_proc,10);

Line 668: l_last_org_rec hr_all_organization_units%rowtype;

664: --
665: procedure clear_down_cache is
666: --
667: l_last_bus_rec per_business_groups%rowtype;
668: l_last_org_rec hr_all_organization_units%rowtype;
669: l_last_pay_rec pay_all_payrolls_f%rowtype;
670: l_last_ben_rec ben_benfts_grp%rowtype;
671: --
672: begin