APPS.HR_QUA_AWARDS_UTIL_SS dependencies on PER_QUALIFICATIONS

Line 65: PER_QUALIFICATIONS_API.DELETE_QUALIFICATION

61: --
62: -- delete qualification
63: --
64: --per_qua_del.del
65: PER_QUALIFICATIONS_API.DELETE_QUALIFICATION
66: (p_validate => p_validate
67: ,p_qualification_id => p_qualification_id
68: ,p_object_version_number => p_pq_object_version_number);
69:

Line 401: from per_qualifications

397:
398:
399: cursor csr_qualification(p_qualification_id in number) is
400: select *
401: from per_qualifications
402: where qualification_id=p_qualification_id;
403:
404: cursor csr_attendance(p_attendance_id in number) is
405: select *

Line 2504: per_qualifications

2500: SELECT
2501: start_date
2502: ,end_date
2503: FROM
2504: per_qualifications
2505: WHERE
2506: qualification_id = p_qualification_id;
2507:
2508: cursor c1(p_establishment in varchar2

Line 2520: per_qualifications pq

2516: select
2517: null
2518: from
2519: per_establishment_attendances per,
2520: per_qualifications pq
2521: where
2522: per.person_id = p_selected_person_id
2523: and (p_establishment is not null
2524: and UPPER(per.establishment) = UPPER(p_establishment)

Line 2546: from per_qualifications

2542: where upper(name) = upper(p_establishment);
2543:
2544: cursor csr_ok_to_del_attendance(p_attendance_id in number) is
2545: select count(*)
2546: from per_qualifications
2547: where attendance_id = p_attendance_id;
2548:
2549: l_attendance_count number;
2550: l_school_name_id number;

Line 2700: PER_QUALIFICATIONS_API.CREATE_QUALIFICATION

2696: end if; --end insert attendance
2697:
2698: --insert qualification for both qua and award
2699: --per_qua_ins.ins
2700: PER_QUALIFICATIONS_API.CREATE_QUALIFICATION
2701: (p_validate => FALSE
2702: ,p_effective_date => sysdate
2703: ,p_qualification_type_id => p_qualifications(1).qualification_type_id
2704: ,p_qualification_id => l_qualification_id

Line 2952: PER_QUALIFICATIONS_API.UPDATE_QUALIFICATION

2948: end if; --end update attendance
2949:
2950: -- update qua record for both qua and award
2951: --per_qua_upd.upd
2952: PER_QUALIFICATIONS_API.UPDATE_QUALIFICATION
2953: (p_validate => FALSE
2954: ,p_effective_date => sysdate
2955: ,p_qualification_id => p_qualifications(1).qualification_id
2956: --,p_business_group_id => p_qualifications(1).business_group_id

Line 3391: from per_qualifications per

3387: p_attendance_id in number,
3388: p_title in varchar2,
3389: p_qualification_id number) is
3390: select null
3391: from per_qualifications per
3392: where per.qualification_type_id = p_qualification_type_id
3393: --and nvl(per.party_id,-1) = nvl(p_party_id,-1)
3394: and nvl(per.person_id,-1) = nvl(p_person_id,-1)
3395: and nvl(per.attendance_id,-1) = nvl(p_attendance_id,-1)