2584: FOR lp IN phase_types.FIRST..phase_types.LAST
2585: LOOP
2586: SELECT eng_lifecycle_statuses_s.nextval
2587: INTO l_lifecycle_phase_id
2588: FROM dual;
2589:
2590: l_seq_no := l_seq_no + 10;
2591:
2592: insert into ENG_LIFECYCLE_STATUSES (
4083: -- End Changes
4084:
4085: IF p_eco_rec.transaction_type = Eng_Globals.G_OPR_CREATE THEN
4086: SELECT eng_change_subjects_s.nextval INTO l_change_subject_unexp_rec.change_subject_id
4087: FROM SYS.DUAL;
4088:
4089:
4090:
4091: Insert into eng_change_subjects