32: ) IS
33:
34: CURSOR C1 IS
35: SELECT EAM_CONSTRUCTION_UNITS_S.nextval
36: FROM dual;
37: BEGIN
38: IF (px_cu_id IS NULL) OR (px_cu_id = FND_API.G_MISS_NUM) then
39: OPEN C1;
40: FETCH C1 INTO px_cu_id;
184: ) IS
185:
186: CURSOR C2 IS
187: SELECT EAM_CONSTRUCTION_UNIT_DTLS_S.nextval
188: FROM dual;
189: BEGIN
190:
191: IF (px_cu_detail_id IS NULL) OR (px_cu_detail_id = FND_API.G_MISS_NUM) then
192: OPEN C2;