33: ,P_ATTRIBUTE19 in VARCHAR2
34: ,P_ATTRIBUTE20 in VARCHAR2
35: )is
36: begin
37: hr_utility.set_location('Entering: OTA_CERT_MEMBER_BK2.UPDATE_CERTIFICATION_MEMBER_A', 10);
38: hr_utility.set_location(' Leaving: OTA_CERT_MEMBER_BK2.UPDATE_CERTIFICATION_MEMBER_A', 20);
39: end UPDATE_CERTIFICATION_MEMBER_A;
40: procedure UPDATE_CERTIFICATION_MEMBER_B
41: (P_EFFECTIVE_DATE in DATE
34: ,P_ATTRIBUTE20 in VARCHAR2
35: )is
36: begin
37: hr_utility.set_location('Entering: OTA_CERT_MEMBER_BK2.UPDATE_CERTIFICATION_MEMBER_A', 10);
38: hr_utility.set_location(' Leaving: OTA_CERT_MEMBER_BK2.UPDATE_CERTIFICATION_MEMBER_A', 20);
39: end UPDATE_CERTIFICATION_MEMBER_A;
40: procedure UPDATE_CERTIFICATION_MEMBER_B
41: (P_EFFECTIVE_DATE in DATE
42: ,P_CERTIFICATION_MEMBER_ID in NUMBER
68: ,P_ATTRIBUTE19 in VARCHAR2
69: ,P_ATTRIBUTE20 in VARCHAR2
70: )is
71: begin
72: hr_utility.set_location('Entering: OTA_CERT_MEMBER_BK2.UPDATE_CERTIFICATION_MEMBER_B', 10);
73: hr_utility.set_location(' Leaving: OTA_CERT_MEMBER_BK2.UPDATE_CERTIFICATION_MEMBER_B', 20);
74: end UPDATE_CERTIFICATION_MEMBER_B;
75: end OTA_CERT_MEMBER_BK2;
69: ,P_ATTRIBUTE20 in VARCHAR2
70: )is
71: begin
72: hr_utility.set_location('Entering: OTA_CERT_MEMBER_BK2.UPDATE_CERTIFICATION_MEMBER_B', 10);
73: hr_utility.set_location(' Leaving: OTA_CERT_MEMBER_BK2.UPDATE_CERTIFICATION_MEMBER_B', 20);
74: end UPDATE_CERTIFICATION_MEMBER_B;
75: end OTA_CERT_MEMBER_BK2;