APPS.BEN_WHATIF_ELIG dependencies on PER_QUALIFICATIONS

Line 3284: procedure WATIF_PER_QUALIFICATIONS_API(

3280: end;
3281:
3282:
3283: --Bug 2831804
3284: procedure WATIF_PER_QUALIFICATIONS_API(
3285: p_person_id in number
3286: ,p_qualification_type_id in number
3287: ,p_title in varchar2
3288: ,p_start_date in date

Line 3315: select * from per_qualifications qua

3311: ,p_effective_date in date
3312: ) is
3313:
3314: cursor c_person is
3315: select * from per_qualifications qua
3316: where person_id = p_person_id
3317: and qua.qualification_type_id = p_qualification_type_id
3318: and qua.business_group_id = p_business_group_id
3319: and p_effective_date between qua.start_date and nvl(qua.end_date, p_effective_date);

Line 3324: per_qual_rec per_qualifications%rowtype;

3320:
3321: l_person_rec c_person%rowtype;
3322: l_object_version_number number;
3323: l_qualification_id number;
3324: per_qual_rec per_qualifications%rowtype;
3325: begin
3326:
3327: if p_person_id is not null then
3328: per_qual_rec.person_id := p_person_id;

Line 3435: PER_QUALIFICATIONS_API.UPDATE_QUALIFICATION

3431: open c_person;
3432: fetch c_person into l_person_rec;
3433: if c_person%found then
3434: close c_person;
3435: PER_QUALIFICATIONS_API.UPDATE_QUALIFICATION
3436: (p_validate => FALSE
3437: ,p_qualification_type_id => per_qual_rec.qualification_type_id
3438: ,p_title => per_qual_rec.title
3439: ,p_start_date => per_qual_rec.start_date

Line 3467: PER_QUALIFICATIONS_API.CREATE_QUALIFICATION

3463: ,p_object_version_number => l_person_rec.object_version_number
3464: );
3465: else
3466: close c_person;
3467: PER_QUALIFICATIONS_API.CREATE_QUALIFICATION
3468: (p_validate => FALSE
3469: ,p_effective_date => p_effective_date
3470: ,p_qualification_type_id => per_qual_rec.qualification_type_id
3471: ,p_business_group_id => per_qual_rec.business_group_id