136:
137: IF g_profile_id = 0 THEN
138: SELECT pa_competence_profiles_s.nextval
139: INTO g_profile_id 140: FROM dual; 141: END IF;
142:
143: IF g_person_id = 0 THEN
144: g_person_id := p_person_id;
Line 255: FROM dual;
251:
252: IF g_profile_id = 0 THEN
253: SELECT pa_competence_profiles_s.nextval
254: INTO g_profile_id 255: FROM dual; 256: END IF;
257:
258: IF g_person_id = 0 THEN
259: g_person_id := p_person_id;