DBA Data[Home] [Help]

APPS.BEN_PERSON_OBJECT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 361: procedure set_object(p_rec in out NOCOPY per_assignment_status_types%rowtype) is

357: -- 115.23 set cache entry at current index location
358: g_cache_benass_rec(l_index):=p_rec;
359: end set_benass_object;
360: --
361: procedure set_object(p_rec in out NOCOPY per_assignment_status_types%rowtype) is
362: --
363: l_proc varchar2(80) := g_package||'set_object ast';
364: l_index pls_integer;
365: --

Line 1003: ,per_assignment_status_types ast

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'
1007: and paf.assignment_type = 'E'

Line 1176: p_rec in out nocopy per_assignment_status_types%rowtype) is

1172: end set_bnb_object;
1173: --
1174: procedure set_ast_object
1175: (p_assignment_status_type_id in number,
1176: p_rec in out nocopy per_assignment_status_types%rowtype) is
1177: --
1178: l_proc varchar2(80) := g_package||'set_ast_object';
1179: --
1180: cursor c1 is

Line 1182: from per_assignment_status_types pas

1178: l_proc varchar2(80) := g_package||'set_ast_object';
1179: --
1180: cursor c1 is
1181: select pas.*
1182: from per_assignment_status_types pas
1183: where pas.assignment_status_type_id = p_assignment_status_type_id
1184: and pas.active_flag = 'Y';
1185: --
1186: -- l_rec per_assignment_status_types%rowtype;

Line 1186: -- l_rec per_assignment_status_types%rowtype;

1182: from per_assignment_status_types pas
1183: where pas.assignment_status_type_id = p_assignment_status_type_id
1184: and pas.active_flag = 'Y';
1185: --
1186: -- l_rec per_assignment_status_types%rowtype;
1187: --115.23 - comment out unneeded record
1188: --
1189: begin
1190: --

Line 2677: p_rec in out nocopy per_assignment_status_types%rowtype) is

2673: --
2674: end get_benass_object;
2675: --
2676: procedure get_object(p_assignment_status_type_id in number,
2677: p_rec in out nocopy per_assignment_status_types%rowtype) is
2678: --
2679: l_proc varchar2(80) := g_package||'get_object ast';
2680: l_index pls_integer;
2681: l_not_hash_found boolean;

Line 2682: l_rec per_assignment_status_types%rowtype;

2678: --
2679: l_proc varchar2(80) := g_package||'get_object ast';
2680: l_index pls_integer;
2681: l_not_hash_found boolean;
2682: l_rec per_assignment_status_types%rowtype;
2683: --
2684: begin
2685: --
2686: -- hr_utility.set_location('Entering '||l_proc,10);

Line 3801: l_cache_last_ast_rec per_assignment_status_types%rowtype;

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;
3805: l_cache_last_date_rec g_person_date_info_rec;

Line 3864: l_cache_last_ast_rec per_assignment_status_types%rowtype;

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;
3868: l_cache_last_date_rec g_person_date_info_rec;