21: fetch c_comp into l_competence_id;
22: close c_comp;
23:
24: if l_competence_id is not null then
25: fnd_message.set_name('OTA','OTA_COMP_EXIST');
26: fnd_message.raise_error;
27: end if;
28:
29: end chk_competence;
22: close c_comp;
23:
24: if l_competence_id is not null then
25: fnd_message.set_name('OTA','OTA_COMP_EXIST');
26: fnd_message.raise_error;
27: end if;
28:
29: end chk_competence;
30: