35: ,P_ATTRIBUTE20 in VARCHAR2
36: ,P_EXPIRATION_DATE in DATE
37: )is
38: begin
39: hr_utility.set_location('Entering: OTA_CERT_PRD_ENROLLMENT_BK2.UPDATE_CERT_PRD_ENROLLMENT_A', 10);
40: hr_utility.set_location(' Leaving: OTA_CERT_PRD_ENROLLMENT_BK2.UPDATE_CERT_PRD_ENROLLMENT_A', 20);
41: end UPDATE_CERT_PRD_ENROLLMENT_A;
42: procedure UPDATE_CERT_PRD_ENROLLMENT_B
43: (P_EFFECTIVE_DATE in DATE
36: ,P_EXPIRATION_DATE in DATE
37: )is
38: begin
39: hr_utility.set_location('Entering: OTA_CERT_PRD_ENROLLMENT_BK2.UPDATE_CERT_PRD_ENROLLMENT_A', 10);
40: hr_utility.set_location(' Leaving: OTA_CERT_PRD_ENROLLMENT_BK2.UPDATE_CERT_PRD_ENROLLMENT_A', 20);
41: end UPDATE_CERT_PRD_ENROLLMENT_A;
42: procedure UPDATE_CERT_PRD_ENROLLMENT_B
43: (P_EFFECTIVE_DATE in DATE
44: ,P_CERT_PRD_ENROLLMENT_ID in NUMBER
72: ,P_ATTRIBUTE20 in VARCHAR2
73: ,P_EXPIRATION_DATE in DATE
74: )is
75: begin
76: hr_utility.set_location('Entering: OTA_CERT_PRD_ENROLLMENT_BK2.UPDATE_CERT_PRD_ENROLLMENT_B', 10);
77: hr_utility.set_location(' Leaving: OTA_CERT_PRD_ENROLLMENT_BK2.UPDATE_CERT_PRD_ENROLLMENT_B', 20);
78: end UPDATE_CERT_PRD_ENROLLMENT_B;
79: end OTA_CERT_PRD_ENROLLMENT_BK2;
73: ,P_EXPIRATION_DATE in DATE
74: )is
75: begin
76: hr_utility.set_location('Entering: OTA_CERT_PRD_ENROLLMENT_BK2.UPDATE_CERT_PRD_ENROLLMENT_B', 10);
77: hr_utility.set_location(' Leaving: OTA_CERT_PRD_ENROLLMENT_BK2.UPDATE_CERT_PRD_ENROLLMENT_B', 20);
78: end UPDATE_CERT_PRD_ENROLLMENT_B;
79: end OTA_CERT_PRD_ENROLLMENT_BK2;