52: ,P_COMPETENCY_UPDATE_LEVEL in VARCHAR2
53: ,P_VALIDATE in BOOLEAN
54: )is
55: begin
56: hr_utility.set_location('Entering: OTA_CERTIFICATION_BK2.UPDATE_CERTIFICATION_A', 10);
57: hr_utility.set_location(' Leaving: OTA_CERTIFICATION_BK2.UPDATE_CERTIFICATION_A', 20);
58: end UPDATE_CERTIFICATION_A;
59: procedure UPDATE_CERTIFICATION_B
60: (P_EFFECTIVE_DATE in DATE
53: ,P_VALIDATE in BOOLEAN
54: )is
55: begin
56: hr_utility.set_location('Entering: OTA_CERTIFICATION_BK2.UPDATE_CERTIFICATION_A', 10);
57: hr_utility.set_location(' Leaving: OTA_CERTIFICATION_BK2.UPDATE_CERTIFICATION_A', 20);
58: end UPDATE_CERTIFICATION_A;
59: procedure UPDATE_CERTIFICATION_B
60: (P_EFFECTIVE_DATE in DATE
61: ,P_CERTIFICATION_ID in NUMBER
106: ,P_COMPETENCY_UPDATE_LEVEL in VARCHAR2
107: ,P_VALIDATE in BOOLEAN
108: )is
109: begin
110: hr_utility.set_location('Entering: OTA_CERTIFICATION_BK2.UPDATE_CERTIFICATION_B', 10);
111: hr_utility.set_location(' Leaving: OTA_CERTIFICATION_BK2.UPDATE_CERTIFICATION_B', 20);
112: end UPDATE_CERTIFICATION_B;
113: end OTA_CERTIFICATION_BK2;
107: ,P_VALIDATE in BOOLEAN
108: )is
109: begin
110: hr_utility.set_location('Entering: OTA_CERTIFICATION_BK2.UPDATE_CERTIFICATION_B', 10);
111: hr_utility.set_location(' Leaving: OTA_CERTIFICATION_BK2.UPDATE_CERTIFICATION_B', 20);
112: end UPDATE_CERTIFICATION_B;
113: end OTA_CERTIFICATION_BK2;