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 274: procedure set_object(p_rec in out NOCOPY per_all_assignments_f%rowtype) is

270: -- 115.23 set cache entry at current index location
271: g_cache_hsc_rec(l_index):=p_rec;
272: end set_object;
273: --
274: procedure set_object(p_rec in out NOCOPY per_all_assignments_f%rowtype) is
275: --
276: l_proc varchar2(80) := g_package||'set_object asg';
277: l_index pls_integer;
278: --

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

314: -- 115.23 set cache entry at current index location
315: g_cache_ass_rec(l_index):=p_rec;
316: end set_object;
317: --
318: procedure set_benass_object(p_rec in out NOCOPY per_all_assignments_f%rowtype) is
319: --
320: l_proc varchar2(80) := g_package||'set_object benass';
321: l_index pls_integer;
322: begin

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

523: -- hr_utility.set_location('Leaving '||l_proc,10);
524: --
525: end set_object;
526: --
527: procedure set_appass_object(p_rec in out NOCOPY per_all_assignments_f%rowtype) is
528: --
529: l_proc varchar2(80) := g_package||'set_object appass';
530: l_index pls_integer;
531: --

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

540: -- hr_utility.set_location('Leaving '||l_proc,10);
541: --
542: end set_appass_object;
543: --
544: procedure set_allass_object(p_rec in out NOCOPY per_all_assignments_f%rowtype) is
545: --
546: l_proc varchar2(80) := g_package||'set_object allass';
547: l_index pls_integer;
548: --

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

976: procedure set_ass_object
977: (p_person_id in number,
978: p_business_group_id in number,
979: p_effective_date in date,
980: p_rec in out nocopy per_all_assignments_f%rowtype) is
981: --
982: l_proc varchar2(80) := g_package||'set_ass_object';
983: l_found boolean := TRUE;
984: --

Line 987: from per_all_assignments_f paf

983: l_found boolean := TRUE;
984: --
985: cursor c1 is
986: select paf.*
987: from per_all_assignments_f paf
988: where paf.person_id = p_person_id
989: and paf.business_group_id = p_business_group_id
990: and paf.primary_flag = 'Y'
991: and paf.assignment_type = 'E'

Line 1002: from per_all_assignments_f paf

998: --
999: /* -- Bug 6399423
1000: cursor c1 is
1001: select paf.*
1002: from per_all_assignments_f paf
1003: ,per_assignment_status_types ast
1004: where paf.person_id = p_person_id
1005: and paf.business_group_id = p_business_group_id
1006: and paf.primary_flag = 'Y'

Line 1014: --l_rec per_all_assignments_f%rowtype;

1010: and p_effective_date
1011: between paf.effective_start_date
1012: and paf.effective_end_date; */
1013:
1014: --l_rec per_all_assignments_f%rowtype;
1015: --115.23 - comment out unneeded record
1016: --
1017: begin
1018: --

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

1053: procedure set_benass_object
1054: (p_person_id in number,
1055: p_business_group_id in number,
1056: p_effective_date in date,
1057: p_rec in out nocopy per_all_assignments_f%rowtype) is
1058: --
1059: l_proc varchar2(80) := g_package||'set_benass_object';
1060: l_found boolean := TRUE;
1061: --

Line 1064: from per_all_assignments_f paf

1060: l_found boolean := TRUE;
1061: --
1062: cursor c1 is
1063: select paf.*
1064: from per_all_assignments_f paf
1065: where paf.person_id = p_person_id
1066: and paf.business_group_id = p_business_group_id
1067: and paf.primary_flag = 'Y'
1068: and paf.assignment_type = 'B'

Line 1073: --l_rec per_all_assignments_f%rowtype;

1069: and p_effective_date
1070: between paf.effective_start_date
1071: and paf.effective_end_date;
1072: --
1073: --l_rec per_all_assignments_f%rowtype;
1074: --115.23 - comment out unneeded record
1075: --
1076: begin
1077: --

Line 1412: from per_all_assignments_f paf

1408: l_proc varchar2(80) ;
1409: --
1410: cursor c1 is
1411: select paf.*
1412: from per_all_assignments_f paf
1413: where paf.person_id = p_person_id
1414: and paf.business_group_id = p_business_group_id
1415: and paf.assignment_type = 'A'
1416: and p_effective_date

Line 1490: from per_all_assignments_f paf

1486: l_proc varchar2(80) ;
1487: --
1488: cursor c1(p_allow_cont_wrk varchar) is
1489: select paf.*
1490: from per_all_assignments_f paf
1491: where paf.person_id = p_person_id
1492: and paf.assignment_type <> (decode(p_allow_cont_wrk,'N','C',hr_api.g_varchar2)) /* 8920881 */
1493: and paf.business_group_id = p_business_group_id
1494: and p_effective_date

Line 2026: from per_all_assignments_f paf

2022: and ppf.business_group_id = p_business_group_id;
2023: --
2024: cursor c2 is
2025: select min(paf.effective_start_date)
2026: from per_all_assignments_f paf
2027: where paf.person_id = p_person_id
2028: and paf.assignment_type <> 'C'
2029: and paf.business_group_id = p_business_group_id
2030: and paf.primary_flag = 'Y';

Line 2430: p_rec in out nocopy per_all_assignments_f%rowtype,

2426: --ud changes start
2427: -- added new procedure with p_assignment_id as input parameter
2428: -- checked for same assignment_id otherwise again creating.
2429: procedure get_object(p_person_id in number,
2430: p_rec in out nocopy per_all_assignments_f%rowtype,
2431: p_assignment_id in number) is
2432: --
2433: l_proc varchar2(80) := g_package||'get_object asg';
2434: l_index pls_integer;

Line 2437: --l_rec per_all_assignments_f%rowtype;

2433: l_proc varchar2(80) := g_package||'get_object asg';
2434: l_index pls_integer;
2435: --l_not_hash_found boolean;
2436: l_env ben_env_object.g_global_env_rec_type;
2437: --l_rec per_all_assignments_f%rowtype;
2438: -- FONM
2439: l_effective_date date;
2440: --
2441: --

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

2517: --ud changes end
2518: --Bug 12664112
2519: --
2520: procedure get_object(p_person_id in number,
2521: p_rec in out nocopy per_all_assignments_f%rowtype) is
2522: --
2523: l_proc varchar2(80) := g_package||'get_object asg';
2524: l_index pls_integer;
2525: --l_not_hash_found boolean;

Line 2527: --l_rec per_all_assignments_f%rowtype;

2523: l_proc varchar2(80) := g_package||'get_object asg';
2524: l_index pls_integer;
2525: --l_not_hash_found boolean;
2526: l_env ben_env_object.g_global_env_rec_type;
2527: --l_rec per_all_assignments_f%rowtype;
2528: -- FONM
2529: l_effective_date date;
2530: --
2531: --

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

2595: end get_object;
2596: --
2597: procedure get_benass_object
2598: (p_person_id in number,
2599: p_rec in out nocopy per_all_assignments_f%rowtype) is
2600: --
2601: l_proc varchar2(80) := g_package||'get_object benass';
2602: l_index pls_integer;
2603: --l_not_hash_found boolean;

Line 2605: --l_rec per_all_assignments_f%rowtype;

2601: l_proc varchar2(80) := g_package||'get_object benass';
2602: l_index pls_integer;
2603: --l_not_hash_found boolean;
2604: l_env ben_env_object.g_global_env_rec_type;
2605: --l_rec per_all_assignments_f%rowtype;
2606: --
2607: -- FONM
2608: l_effective_date date;
2609: --

Line 3799: l_cache_last_ass_rec per_all_assignments_f%rowtype;

3795: --
3796: procedure clear_down_cache is
3797: --
3798: l_cache_last_per_rec per_all_people_f%rowtype;
3799: l_cache_last_ass_rec per_all_assignments_f%rowtype;
3800: l_cache_last_benass_rec per_all_assignments_f%rowtype;
3801: l_cache_last_ast_rec per_assignment_status_types%rowtype;
3802: l_cache_last_pps_rec per_periods_of_service%rowtype;
3803: l_cache_last_pad_rec per_addresses%rowtype;

Line 3800: l_cache_last_benass_rec per_all_assignments_f%rowtype;

3796: procedure clear_down_cache is
3797: --
3798: l_cache_last_per_rec per_all_people_f%rowtype;
3799: l_cache_last_ass_rec per_all_assignments_f%rowtype;
3800: l_cache_last_benass_rec per_all_assignments_f%rowtype;
3801: l_cache_last_ast_rec per_assignment_status_types%rowtype;
3802: l_cache_last_pps_rec per_periods_of_service%rowtype;
3803: l_cache_last_pad_rec per_addresses%rowtype;
3804: l_cache_last_pil_rec ben_per_in_ler%rowtype;

Line 3862: l_cache_last_ass_rec per_all_assignments_f%rowtype;

3858: procedure defrag_caches
3859: is
3860: --
3861: l_cache_last_per_rec per_all_people_f%rowtype;
3862: l_cache_last_ass_rec per_all_assignments_f%rowtype;
3863: l_cache_last_benass_rec per_all_assignments_f%rowtype;
3864: l_cache_last_ast_rec per_assignment_status_types%rowtype;
3865: l_cache_last_pps_rec per_periods_of_service%rowtype;
3866: l_cache_last_pad_rec per_addresses%rowtype;

Line 3863: l_cache_last_benass_rec per_all_assignments_f%rowtype;

3859: is
3860: --
3861: l_cache_last_per_rec per_all_people_f%rowtype;
3862: l_cache_last_ass_rec per_all_assignments_f%rowtype;
3863: l_cache_last_benass_rec per_all_assignments_f%rowtype;
3864: l_cache_last_ast_rec per_assignment_status_types%rowtype;
3865: l_cache_last_pps_rec per_periods_of_service%rowtype;
3866: l_cache_last_pad_rec per_addresses%rowtype;
3867: l_cache_last_pil_rec ben_per_in_ler%rowtype;

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

3887: (p_person_id in number,
3888: p_assignment_id in number,
3889: p_business_group_id in number,
3890: p_effective_date in date,
3891: p_rec in out nocopy per_all_assignments_f%rowtype) is
3892: --
3893: l_proc varchar2(80) := g_package||'set_ass_object';
3894: l_found boolean := TRUE;
3895: --

Line 3898: from per_all_assignments_f paf

3894: l_found boolean := TRUE;
3895: --
3896: cursor c1 is
3897: select paf.*
3898: from per_all_assignments_f paf
3899: where paf.person_id = p_person_id
3900: and paf.business_group_id = p_business_group_id
3901: and paf.assignment_id = p_assignment_id
3902: and p_effective_date

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

3928: end set_ass_object;
3929:
3930: procedure get_assgn_object( p_person_id in number,
3931: p_assignment_id in number,
3932: p_rec in out nocopy per_all_assignments_f%rowtype) is
3933: --
3934: l_proc varchar2(80) := g_package||'get_assgn_object asg';
3935: l_index pls_integer;
3936: --l_not_hash_found boolean;

Line 3938: --l_rec per_all_assignments_f%rowtype;

3934: l_proc varchar2(80) := g_package||'get_assgn_object asg';
3935: l_index pls_integer;
3936: --l_not_hash_found boolean;
3937: l_env ben_env_object.g_global_env_rec_type;
3938: --l_rec per_all_assignments_f%rowtype;
3939: -- FONM
3940: l_effective_date date;
3941: --
3942: --