Line 168: CURSOR C2 IS SELECT fa_mass_additions_s.nextval FROM sys.dual;
164: X_warranty_number VARCHAR2 DEFAULT NULL,
165: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
166: CURSOR C IS SELECT rowid FROM fa_mass_additions
167: WHERE mass_addition_id = X_Mass_Addition_Id; 168: CURSOR C2 IS SELECT fa_mass_additions_s.nextval FROM sys.dual; 169: BEGIN
170: if (X_Mass_Addition_Id is NULL) then
171: OPEN C2;
172: FETCH C2 INTO X_Mass_Addition_Id;