1: package body OTA_CERTIFICATION_BK2 as
2: /* $Header: otcrtapi.pkb 120.1 2005/08/10 15:51 generated noship $ */
3: -- Code generated by the Oracle HRMS API Hook Pre-processor
4: -- Created on 2007/01/03 22:29:25 (YYYY/MM/DD HH24:MI:SS)
5: procedure UPDATE_CERTIFICATION_A
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;
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;