DBA Data[Home] [Help]

APPS.FA_MASS_ADDITIONS_PKG3 dependencies on DUAL

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;