Line 256: CURSOR C2 IS SELECT AS_IMPORT_INTERFACE_S.nextval FROM sys.dual;
252: p_PRIMARY_PER_TYPE VARCHAR2,
253: p_DEPARTMENT_CODE VARCHAR2)
254:
255: IS 256: CURSOR C2 IS SELECT AS_IMPORT_INTERFACE_S.nextval FROM sys.dual; 257: BEGIN
258: If (px_IMPORT_INTERFACE_ID IS NULL) OR (px_IMPORT_INTERFACE_ID = FND_API.G_MISS_NUM) then
259: OPEN C2;
260: FETCH C2 INTO px_IMPORT_INTERFACE_ID;