PACKAGE BODY: APPS.HR_COMPETENCE_ELEMENT_BK5

Source

1 package body HR_COMPETENCE_ELEMENT_BK5 as
2 /* $Header: pecelapi.pkb 115.28 2004/03/30 18:07:45 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 04/10/27 08:45:56 (YY/MM/DD HH:MM:SS)
5 procedure MAINTAIN_STUDENT_COMP_ELEMEN_A
6 (P_PERSON_ID in NUMBER
7 ,P_COMPETENCE_ID in NUMBER
8 ,P_PROFICIENCY_LEVEL_ID in NUMBER
9 ,P_BUSINESS_GROUP_ID in NUMBER
10 ,P_EFFECTIVE_DATE_FROM in DATE
11 ,P_EFFECTIVE_DATE_TO in DATE
12 ,P_CERTIFICATION_DATE in DATE
13 ,P_CERTIFICATION_METHOD in VARCHAR2
14 ,P_NEXT_CERTIFICATION_DATE in DATE
15 ,P_SOURCE_OF_PROFICIENCY_LEVEL in VARCHAR2
16 ,P_COMMENTS in VARCHAR2
17 ,P_EFFECTIVE_DATE in DATE
18 ,P_COMPETENCE_CREATED in NUMBER
19 )is
20 l_commit_unit_number number;
21 l_legislation_code   varchar2(30);
22 begin
23 hr_utility.set_location('Entering: HR_COMPETENCE_ELEMENT_BK5.MAINTAIN_STUDENT_COMP_ELEMEN_A', 10);
24 l_commit_unit_number := hr_api.return_commit_unit;
25 if hr_api.call_app_hooks then
26 hr_competence_element_be5.MAINTAIN_STUDENT_COMP_ELEMEN_A
27 (P_PERSON_ID => P_PERSON_ID
28 ,P_COMPETENCE_ID => P_COMPETENCE_ID
29 ,P_PROFICIENCY_LEVEL_ID => P_PROFICIENCY_LEVEL_ID
30 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
31 ,P_EFFECTIVE_DATE_FROM => P_EFFECTIVE_DATE_FROM
32 ,P_EFFECTIVE_DATE_TO => P_EFFECTIVE_DATE_TO
33 ,P_CERTIFICATION_DATE => P_CERTIFICATION_DATE
34 ,P_CERTIFICATION_METHOD => P_CERTIFICATION_METHOD
35 ,P_NEXT_CERTIFICATION_DATE => P_NEXT_CERTIFICATION_DATE
36 ,P_SOURCE_OF_PROFICIENCY_LEVEL => P_SOURCE_OF_PROFICIENCY_LEVEL
37 ,P_COMMENTS => P_COMMENTS
38 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
39 ,P_COMPETENCE_CREATED => P_COMPETENCE_CREATED
40 );
41 end if;
42 hr_multi_message.end_validation_set;
43 hr_api.validate_commit_unit(l_commit_unit_number, 'MAINTAIN_STUDENT_COMP_ELEMENT', 'AP');
44 hr_utility.set_location(' Leaving: HR_COMPETENCE_ELEMENT_BK5.MAINTAIN_STUDENT_COMP_ELEMEN_A', 20);
45 end MAINTAIN_STUDENT_COMP_ELEMEN_A;
46 procedure MAINTAIN_STUDENT_COMP_ELEMEN_B
47 (P_PERSON_ID in NUMBER
48 ,P_COMPETENCE_ID in NUMBER
49 ,P_PROFICIENCY_LEVEL_ID in NUMBER
50 ,P_BUSINESS_GROUP_ID in NUMBER
51 ,P_EFFECTIVE_DATE_FROM in DATE
52 ,P_EFFECTIVE_DATE_TO in DATE
53 ,P_CERTIFICATION_DATE in DATE
54 ,P_CERTIFICATION_METHOD in VARCHAR2
55 ,P_NEXT_CERTIFICATION_DATE in DATE
56 ,P_SOURCE_OF_PROFICIENCY_LEVEL in VARCHAR2
57 ,P_COMMENTS in VARCHAR2
58 ,P_EFFECTIVE_DATE in DATE
59 )is
60 begin
61 hr_utility.set_location('Entering: HR_COMPETENCE_ELEMENT_BK5.MAINTAIN_STUDENT_COMP_ELEMEN_B', 10);
62 hr_utility.set_location(' Leaving: HR_COMPETENCE_ELEMENT_BK5.MAINTAIN_STUDENT_COMP_ELEMEN_B', 20);
63 end MAINTAIN_STUDENT_COMP_ELEMEN_B;
64 end HR_COMPETENCE_ELEMENT_BK5;