142: if (l_evaluation_id is null) then
143:
144: SELECT poa_cm_evaluation_s.nextval
145: INTO X_evaluation_id
146: FROM sys.dual;
147:
148: else
149: X_evaluation_id := l_evaluation_id;
150: end if;
242: if (l_evaluation_id is null) then
243:
244: SELECT poa_cm_eval_scores_s.nextval
245: INTO X_evaluation_score_id
246: FROM sys.dual;
247: else
248: SELECT pes.evaluation_score_id
249: INTO X_evaluation_score_id
250: FROM poa_cm_eval_scores pes