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_PERSON_OBJECT dependencies on PER_ALL_ASSIGNMENTS_F

Line 252: procedure set_object(p_rec in out NOCOPY per_all_assignments_f%rowtype) is

248: -- 115.23 set cache entry at current index location
249: g_cache_hsc_rec(l_index):=p_rec;
250: end set_object;
251: --
252: procedure set_object(p_rec in out NOCOPY per_all_assignments_f%rowtype) is
253: --
254: l_proc varchar2(80) := g_package||'set_object asg';
255: l_index pls_integer;
256: --

Line 296: procedure set_benass_object(p_rec in out NOCOPY per_all_assignments_f%rowtype) is

292: -- 115.23 set cache entry at current index location
293: g_cache_ass_rec(l_index):=p_rec;
294: end set_object;
295: --
296: procedure set_benass_object(p_rec in out NOCOPY per_all_assignments_f%rowtype) is
297: --
298: l_proc varchar2(80) := g_package||'set_object benass';
299: l_index pls_integer;
300: begin

Line 505: procedure set_appass_object(p_rec in out NOCOPY per_all_assignments_f%rowtype) is

501: -- hr_utility.set_location('Leaving '||l_proc,10);
502: --
503: end set_object;
504: --
505: procedure set_appass_object(p_rec in out NOCOPY per_all_assignments_f%rowtype) is
506: --
507: l_proc varchar2(80) := g_package||'set_object appass';
508: l_index pls_integer;
509: --

Line 522: procedure set_allass_object(p_rec in out NOCOPY per_all_assignments_f%rowtype) is

518: -- hr_utility.set_location('Leaving '||l_proc,10);
519: --
520: end set_appass_object;
521: --
522: procedure set_allass_object(p_rec in out NOCOPY per_all_assignments_f%rowtype) is
523: --
524: l_proc varchar2(80) := g_package||'set_object allass';
525: l_index pls_integer;
526: --

Line 958: p_rec in out nocopy per_all_assignments_f%rowtype) is

954: procedure set_ass_object
955: (p_person_id in number,
956: p_business_group_id in number,
957: p_effective_date in date,
958: p_rec in out nocopy per_all_assignments_f%rowtype) is
959: --
960: l_proc varchar2(80) := g_package||'set_ass_object';
961: --
962: -- Bug 6399423

Line 966: from per_all_assignments_f paf

962: -- Bug 6399423
963: /*
964: cursor c1 is
965: select paf.*
966: from per_all_assignments_f paf
967: where paf.person_id = p_person_id
968: and paf.business_group_id = p_business_group_id
969: and paf.primary_flag = 'Y'
970: and paf.assignment_type = 'E'

Line 977: from per_all_assignments_f paf

973: and paf.effective_end_date;
974: */
975: cursor c1 is
976: select paf.*
977: from per_all_assignments_f paf
978: ,per_assignment_status_types ast
979: where paf.person_id = p_person_id
980: and paf.business_group_id = p_business_group_id
981: and paf.primary_flag = 'Y'

Line 990: --l_rec per_all_assignments_f%rowtype;

986: between paf.effective_start_date
987: and paf.effective_end_date;
988:
989: -- Bug 6399423
990: --l_rec per_all_assignments_f%rowtype;
991: --115.23 - comment out unneeded record
992: --
993: begin
994: --

Line 1030: p_rec in out nocopy per_all_assignments_f%rowtype) is

1026: procedure set_benass_object
1027: (p_person_id in number,
1028: p_business_group_id in number,
1029: p_effective_date in date,
1030: p_rec in out nocopy per_all_assignments_f%rowtype) is
1031: --
1032: l_proc varchar2(80) := g_package||'set_benass_object';
1033: --
1034: cursor c1 is

Line 1036: from per_all_assignments_f paf

1032: l_proc varchar2(80) := g_package||'set_benass_object';
1033: --
1034: cursor c1 is
1035: select paf.*
1036: from per_all_assignments_f paf
1037: where paf.person_id = p_person_id
1038: and paf.business_group_id = p_business_group_id
1039: and paf.primary_flag = 'Y'
1040: and paf.assignment_type = 'B'

Line 1045: --l_rec per_all_assignments_f%rowtype;

1041: and p_effective_date
1042: between paf.effective_start_date
1043: and paf.effective_end_date;
1044: --
1045: --l_rec per_all_assignments_f%rowtype;
1046: --115.23 - comment out unneeded record
1047: --
1048: begin
1049: --

Line 1381: from per_all_assignments_f paf

1377: l_proc varchar2(80) ;
1378: --
1379: cursor c1 is
1380: select paf.*
1381: from per_all_assignments_f paf
1382: where paf.person_id = p_person_id
1383: and paf.business_group_id = p_business_group_id
1384: and paf.assignment_type = 'A'
1385: and p_effective_date

Line 1459: from per_all_assignments_f paf

1455: l_proc varchar2(80) ;
1456: --
1457: cursor c1 is
1458: select paf.*
1459: from per_all_assignments_f paf
1460: where paf.person_id = p_person_id
1461: and paf.assignment_type <> 'C'
1462: and paf.business_group_id = p_business_group_id
1463: and p_effective_date

Line 1972: from per_all_assignments_f paf

1968: and ppf.business_group_id = p_business_group_id;
1969: --
1970: cursor c2 is
1971: select min(paf.effective_start_date)
1972: from per_all_assignments_f paf
1973: where paf.person_id = p_person_id
1974: and paf.assignment_type <> 'C'
1975: and paf.business_group_id = p_business_group_id
1976: and paf.primary_flag = 'Y';

Line 2372: p_rec in out nocopy per_all_assignments_f%rowtype) is

2368: --
2369: end get_object;
2370: --
2371: procedure get_object(p_person_id in number,
2372: p_rec in out nocopy per_all_assignments_f%rowtype) is
2373: --
2374: l_proc varchar2(80) := g_package||'get_object asg';
2375: l_index pls_integer;
2376: --l_not_hash_found boolean;

Line 2378: --l_rec per_all_assignments_f%rowtype;

2374: l_proc varchar2(80) := g_package||'get_object asg';
2375: l_index pls_integer;
2376: --l_not_hash_found boolean;
2377: l_env ben_env_object.g_global_env_rec_type;
2378: --l_rec per_all_assignments_f%rowtype;
2379: -- FONM
2380: l_effective_date date;
2381: --
2382: --

Line 2450: p_rec in out nocopy per_all_assignments_f%rowtype) is

2446: end get_object;
2447: --
2448: procedure get_benass_object
2449: (p_person_id in number,
2450: p_rec in out nocopy per_all_assignments_f%rowtype) is
2451: --
2452: l_proc varchar2(80) := g_package||'get_object benass';
2453: l_index pls_integer;
2454: --l_not_hash_found boolean;

Line 2456: --l_rec per_all_assignments_f%rowtype;

2452: l_proc varchar2(80) := g_package||'get_object benass';
2453: l_index pls_integer;
2454: --l_not_hash_found boolean;
2455: l_env ben_env_object.g_global_env_rec_type;
2456: --l_rec per_all_assignments_f%rowtype;
2457: --
2458: -- FONM
2459: l_effective_date date;
2460: --

Line 3644: l_cache_last_ass_rec per_all_assignments_f%rowtype;

3640: --
3641: procedure clear_down_cache is
3642: --
3643: l_cache_last_per_rec per_all_people_f%rowtype;
3644: l_cache_last_ass_rec per_all_assignments_f%rowtype;
3645: l_cache_last_benass_rec per_all_assignments_f%rowtype;
3646: l_cache_last_ast_rec per_assignment_status_types%rowtype;
3647: l_cache_last_pps_rec per_periods_of_service%rowtype;
3648: l_cache_last_pad_rec per_addresses%rowtype;

Line 3645: l_cache_last_benass_rec per_all_assignments_f%rowtype;

3641: procedure clear_down_cache is
3642: --
3643: l_cache_last_per_rec per_all_people_f%rowtype;
3644: l_cache_last_ass_rec per_all_assignments_f%rowtype;
3645: l_cache_last_benass_rec per_all_assignments_f%rowtype;
3646: l_cache_last_ast_rec per_assignment_status_types%rowtype;
3647: l_cache_last_pps_rec per_periods_of_service%rowtype;
3648: l_cache_last_pad_rec per_addresses%rowtype;
3649: l_cache_last_pil_rec ben_per_in_ler%rowtype;

Line 3707: l_cache_last_ass_rec per_all_assignments_f%rowtype;

3703: procedure defrag_caches
3704: is
3705: --
3706: l_cache_last_per_rec per_all_people_f%rowtype;
3707: l_cache_last_ass_rec per_all_assignments_f%rowtype;
3708: l_cache_last_benass_rec per_all_assignments_f%rowtype;
3709: l_cache_last_ast_rec per_assignment_status_types%rowtype;
3710: l_cache_last_pps_rec per_periods_of_service%rowtype;
3711: l_cache_last_pad_rec per_addresses%rowtype;

Line 3708: l_cache_last_benass_rec per_all_assignments_f%rowtype;

3704: is
3705: --
3706: l_cache_last_per_rec per_all_people_f%rowtype;
3707: l_cache_last_ass_rec per_all_assignments_f%rowtype;
3708: l_cache_last_benass_rec per_all_assignments_f%rowtype;
3709: l_cache_last_ast_rec per_assignment_status_types%rowtype;
3710: l_cache_last_pps_rec per_periods_of_service%rowtype;
3711: l_cache_last_pad_rec per_addresses%rowtype;
3712: l_cache_last_pil_rec ben_per_in_ler%rowtype;